Spreadsheet data to form

  • thomasfrederickmason
    Asked 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

  • VincentJay
    Replied 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.

  • thomasfrederickmason
    Replied 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 Support
    Replied 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.