Can I autofill a Spreadsheet to form

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

    1637249395_619671739c027_

  • Profile Image
    Hanne
    Answered 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.

  • Profile Image
    Darussalam_Mosque
    Answered on November 18, 2021 at 06:01 PM

    Thank you Hanne, is there any workaround?

  • Profile Image
    Roneet
    Answered on November 18, 2021 at 07: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_

    1637281255_6196ede7e4e44_

    Let us know if this would work.

    Thanks.

  • Profile Image
    cannenorbit
    Answered on November 19, 2021 at 06:02 AM

    I think when I edit my submitted form there is an error or something that blocks the editing process please help.
  • Profile Image
    Vick
    Answered on November 19, 2021 at 06: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

  • Profile Image
    Darussalam_Mosque
    Answered on November 20, 2021 at 12:33 AM

    Thank you Roneet. The workaround works!