-
thomasfrederickmasonAsked on June 28, 2020 at 5:52 PM
Hi there,
I understand that i can get all the submission data to intergrate into a spreadsheet via google sheets etc.
I was wondering if its possible to do the opposite- populate the questions based on an existing spreadsheet. specifically question text, option text and calculation value.
My form will change weekly and this intergration will be so helpful as the text is all in spreadsheet format, ready to go. Would help avoid copy and pasting, resulting in possible errors.
Thanks for any help
Cheers
-
VincentJayReplied on June 28, 2020 at 6:00 PM
Hello,
You can do that by using this widget: https://www.jotform.com/widgets/spreadsheet-to-form
Also, please check our complete guide on how to use the widget: https://www.jotform.com/help/442-How-to-Use-the-Spreadsheet-to-Form-Widget
Give it a try and let us know if you need further help. Thank you.
-
thomasfrederickmasonReplied on June 29, 2020 at 4:15 AM
Hi Thanks for your response;
Thats looks like a handy widget, but not exactly what I'm looking for.
I want to to actually change the text of the questions based on values in the spreadsheet.
For example if i have a question with two check box options (italics are the 2 options)
Question 1 may be:
Do you like apples?
Option 1 - No, i don't like apples
Option 2 -Yes, I like apples
But when i want to update the form based on my spreadsheet, Question 1 will be updated to be:
Do you like bananas?
Option 1 - No, i don't like bananas
Option 2 - Yes, I like bananas
Note the change in question text is denoted by the color change-
Is there a way to auto populate the questions not the answers
Thanks
-
Richie JotForm SupportReplied on June 29, 2020 at 5:52 AM
Unfortunately, we cannot use conditions to change fonts.
We may change fonts using the form builder or through CSS but it is not dynamic.
Hope this information helps. If you have further questions, let us know.