Pre-populate fields based on a Spreadsheet/Contact List

  • Profile Image
    mhartprograde
    Asked on August 27, 2019 at 05:59 PM

    Can you have form fields populate info based on a spreadsheet or contact list? Such as if John Doe was sent an email can the Name and Email Address fields be pre-populated with the info submitted through a contact list or spreadsheet, that was uploaded to Jotform or an email application such as campaign monitor?

  • Profile Image
    stevenmarshall
    Answered on August 27, 2019 at 06:45 PM

    Hi @mhartprograde,

    We do have a widget that you can add to your Form called Spreadsheet to Form that might come close to your requirement.

    The Spreadsheet to Form Widget will allow you to upload a spreadsheet to your form and use the values you have on the spreadsheet to pre-populate the form. You will use a unique code present on each row of your spreadsheet. You can access that specific row when it matches the unique code entered on the form.

    Guide: widget/spreadsheet_to_form

    Guide: How-to-Use-the-Spreadsheet-to-Form-Widget

    Another option is to prepopulate fields vias URL parameters.

    Guide: Prepopulating-Fields-to-Your-JotForm-via-URL-Parameters

    Or you can also use this App: https://prepopulate.jotform.io/

    Please let us know if you have any further questions.

    Thank you