Is it possible to use a URL parameter to prepopulate the spreadsheet to form widget?

  • revisionskincare
    Asked on February 21, 2019 at 6:53 PM

    We want to send unique links to our customers that send them to this jotform with their info prepopulated. Is there any way to do this? We looked into this article but this doesn't seem to apply for the widget field: https://www.jotform.com/help/71-Prepopulating-Fields-to-Your-JotForm-via-URL-Parameters

    Please let me know. 

    Thanks,

    Lauren

  • Jed_C
    Replied on February 21, 2019 at 8:13 PM

    Yes, it is possible if you are just referring to the "Enter your ID" field. You'll need to get the unique name https://www.jotform.com/help/146-How-to-Find-Field-IDs-and-Names of the field and follow the steps below.

    1). Get the form URL https://www.jotform.com/help/401-Where-to-Find-My-Form-URL 

    2). Add "?" at the end of the URL and add the spreadsheet to form widget unique name = the value you want to fill.

    ex.

    https://form.jotform.com/90506122303139?enterYour=abcde

    The first value enterYour is the unique name and abcde is the value you want to fill. Try that one out and let us know if you have any questions.

  • revisionskincare
    Replied on February 22, 2019 at 11:43 AM
    Thank you. This worked, but the user still has to click the "Auto Complete
    Fields" button to fill the form. Is there a way to submit this action so
    that the user doesn't need to press the button to fill the fields?
    Thanks,
    Lauren
    ...
  • David JotForm Support Manager
    Replied on February 22, 2019 at 12:44 PM

    The Autocomplete button of the Spreadsheet to Form widget can be triggered only upon users action. It cannot be triggered through URL Parameters.