I am planning to distribute my survey to approximately 10 people. I am trying to pre-populate answers in my survey using the grid question type. I went through the Log-in action tool where I attempted to map a spreadsheet. Attached is a screenshot of the spreadsheet I attempted to map as well as a screenshot of Q17, the grid question type where I would like the answers to pre-populate from my spreadsheet..
I think the trouble might be related to the’Metric’ column in your spreadsheet..
When you ‘map’ a spreadsheet to a login action, you are mapping a spreadsheet column to a column in your table – each row of your table on the survey needs its own dedicated 3 columns in your spreadsheet.
For example, in order to map “Unit of Measurement”, “Goal” and “Progress” to the “Litter” row in your table, you will need 3 columns in your spreadsheet. The “Community Events” row will need its own 3 columns in your spreadsheet and so on..
I hope this helps clear things up just a bit…