Can I autofill a Spreadsheet to form

  • Darussalam_Mosque
    Asked on November 18, 2021 at 10:30 AM

    1637249395 619671739c027  Screenshot 10

  • Hanne JotForm Support
    Replied on November 18, 2021 at 11:22 AM

    @Darussalam_Mosque

    Thank you for reaching out. 

    The Spreadsheet to Form widget can be used to autofill in a form, taking the values from the spreadsheet and mapping them to your fields.

    See this demo: https://form.jotformpro.com/71500914392957.

    However, it does not appear our prefill options can map to the Spreadsheet to Form field itself.

    I hope this information can be helpful. Please, do let me know if you have additional questions or if I misunderstood you.

  • Darussalam_Mosque
    Replied on November 18, 2021 at 6:01 PM

    Thank you Hanne, is there any workaround?

  • roneet
    Replied on November 18, 2021 at 7:23 PM

    You can map another field in the prefill and in the backend copy the field's data to the spreadsheet to Form widget:

    1637281373 6196ee5d8dae1  Screenshot 10

    1637281255 6196ede7e4e44  Screenshot 21

    Let us know if this would work.

    Thanks.

  • cannenorbit
    Replied on November 19, 2021 at 6:02 AM

    I think when I edit my submitted form there is an error or something that blocks the editing process please help.
  • Vick_W Jotform Support
    Replied on November 19, 2021 at 6:17 AM

    Hi @cannenorbit,

    I've created a separate ticket for your concern. You will receive a reply shortly on the following link.

    https://www.jotform.com/answers/3524598

    Thanks

  • Darussalam_Mosque
    Replied on November 20, 2021 at 12:33 AM

    Thank you Roneet. The workaround works!