- luntiandsAsked on November 21, 2017 at 09:26 AM
I have attempted to upload a heap of submissions via csv table and would like to make it as it if was a lookup formula in excel sheet.
What I am trying to do is to have the fields autopopulate based on submitted values on the form. i.e if 1 is selected from the spinner, height would be populated as 86, pier as 230, Wall as 240, Opening as 250Page URL:
- JotForm SupportBJoannaAnswered on November 21, 2017 at 11:49 AM
You can use the Spreadsheet to Form widget to populate your form fields from an external Excel Sheet. Inside of this guide, you can find how to do it:
Another solution is to populate the fields based on the option that was selected in the Spinner field is with the conditional logic.
Here is my demo form: https://form.jotform.com/73244266489971
Feel free to test it and clone it.
Hope this meet what you are looking for.