Am I nuts ? I cant seem to get this to work and maybe I am just doing something silly or maybe it is the new sheets API
INSURED | CERT | POED | BLDG Total LIMIT | PROP RATE | BLDG PREM |
ABBEYDALE COMMUNITY ASSOCIATION | 2000 | $1,401,455 | $1,175,955 | 0.159395796 | $1,874 |
ACADIA COMMUNITY ASSOCIATION | 2001 | $11,990,000 | $10,890,000 | 0.109981999 | $11,977 |
Albert Park/Radisson Heights Community Association | 2002 | $1,556,426 | $1,364,000 | 0.171949801 | $2,345 |
Alexandra Centre | 2229 | $5,287,500 | $5,150,000 | 0.183758371 | $9,464 |
APPLEWOOD COMMUNITY ASSOCIATION | 2167 | $286,000 | $268,000 | 0.208166151 | $558 |
This is a sample of my sheet ( there are more columns but this is the gist of what I am trying to do:
1. I was to run a batch to load one row
2. I want the columns to all load into the template that I created. So I use generate from Word from ( name of my template )
3. I use the side bar to enter the variables into the template
4. I choose upload file to folder in my drive
5. I open the ultra doc and run batch to test the first three and it will create 3 docs and upload them where I tell them, however the only column that populates is the first one. The rest dont pull in at all
HELP! please and thank you