Spreadsheet data to form

  • Profile Image
    thomasfrederickmason
    Asked on June 28, 2020 at 05: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

  • Profile Image
    VincentJay
    Answered on June 28, 2020 at 06: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.

  • Profile Image
    Richie_P
    Answered on June 29, 2020 at 05: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.