[Solved] Trouble with pre-populating answers into specific questions in my survey



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..

Cities of Service asked

    Best answer


    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…

    Dominic Sharpe answered


      Question stats

      • Active
      • Views2579 times
      • Answers1 answer
      • Followers0 followers