How to send calculation values to Sheets?

cygnetclinic
Asked on June 17, 2020 at 07:27 AM

Hi, I've set up a questionnaire with choice (e.g. rarely, sometimes, always) with the calculation options enabled (rarely = 0; sometimes = 1, always = 2). When I export this to Google Sheets, I wanted the numbers to prepopulate the fields, but instead, I still get the word label "eg, sometimes" in Google Sheets or Excel. Am I missing a step?

This is a re-post of a comment on How to Integrate Forms with Google Sheets
Bojan

Jotform Support

Answered on June 17, 2020 at 08:00 AM

Greetings and thank you for your message.

These values will only be used only for the calculations. These values will not be saved to the Sheets. The only way to change the sent text is to update the label.

Let us know if you have any additional questions.