- IanAsked on May 26, 2014 at 07:18 PM
Hi, im looking to lookup data from within an existing spreadsheet ? Specifically to act as data validation which woudl then populate a second feild for example lookup or GET a Job Number and Post the Job Address ?
This sounds simple enough, but there is always a but ?
i have not created this forma as yet ?
Appreciated in advance !
- JotForm SupportjonathanAnswered on May 26, 2014 at 09:00 PM
Unfortunately this feature is not yet doable in our forms when only using the form builder.
To have such functionality, you will need to create a separate program to use the data from google sheet to populate the the form using GET method.
You can use the form's full source code and add your own custom program to complete the functionality.
User Guide: -How-to-get-the-Full-Source-Code-of-your-Form
As an alternative, you may also want to check the Form Field Prepopulator App http://apps.jotform.com/app/field_prepopulator
This app will allow you to manually populate the form with values even before the form can be used.
While the Import Data App http://apps.jotform.com/app/import_data will allow you to import submission data into the form coming from other data sources like Excel or CSV file.
Hope this help. Inform us if you need further assistance.