-
marc.giesenAsked on August 29, 2019 at 5:09 AM
Hello,
I was wondering is it possible to get data from excel to a form.
For example we want to sent a survey to a part of our customers, every customer has is own customer number. I want to see which customer has filled in the survey based on the customer numer or transaction number.
Is this possible?
Kind regards,
Marc Giesen
-
roneetReplied on August 29, 2019 at 5:19 AM
You may consider using the Spreadsheet to Form widget:
https://widgets.jotform.com/widget/spreadsheet_to_form
Guide: https://www.jotform.com/help/442-How-to-Use-the-Spreadsheet-to-Form-Widget
The Spreadsheet to Form Widget allows you to upload a spreadsheet to your form and use the values you have on the spreadsheet to pre-populate the form. By using 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. Think of it as querying a database using the Unique Code as the key index.
Let us know if you have further questions.
Thanks.