Form Pre-populate URL: Using Unique Code to Autofill Hidden Customer Details

Can I use the pre-populate URL style to call the unique code. i.e. /form?uniquecode={{contact.email}}

Unique code would be hidden, as these would be customer details that we'd want to be pulling out via the spreadsheet (currently 70K customers, though only 4 fields, name (first & last), email address and 1 other).

Hi Jeff,

Thanks for reaching out to Jotform Support. The Spreadsheet to Form widget doesn’t support using the pre-populate URL method to call a unique code. The widget generates forms based on the data in your spreadsheet and maps the values directly to the form fields, so parameters like /form?uniquecode={{contact.email}} can’t be passed or dynamically referenced through the URL.

If the unique code needs to be tied to customer data, it would need to exist as a column in the spreadsheet and be mapped to a form field (which can be set as hidden). This way, the value is pulled directly from the spreadsheet when the form is generated, without exposing it to respondents. This approach works even with large datasets, as long as the fields are properly mapped within the widget.

Let us know if you have any other questions.