- DBConsortiumAsked on July 27, 2017 at 02:30 PM
Read entire thread from bottom up...
From: Don Brown [mailto:email@example.com]
Sent: Tuesday, July 25, 2017 7:45 PM
Subject: RE: Automatically fill in data from last registration
Thanks for creating the Spreadsheet to Form Widget.
However – I am wondering if there is a way of using a “live” spreadsheet, rather than importing a “static” spreadsheet into the form. In other words, rather than import a spreadsheet which after it is imported, the data is no longer updated, could we use a “URL” to a live spreadsheet, so that we don’t have to keep downloading a fresh spreadsheet each time we want to use the form for the next workshop?
OR – is there some way to automatically update the downloaded spreadsheet with new data?
Sorry if my question is not artfully worded– but I hope you get the idea.
I look forward to your answer.
Mobile : 1-215 688 1469
FAX : 1-267-552-6248
Doylestown, PA USA
A new response has been received:
Answered by liyam
One way possible to get data from Workshop 1 form to be able to be transferred to Workshop 2 form by making use of the spreadsheet to form widget.
This is a newly created widget which the spreadsheet data can prepopulate fields on your form once they enter a keyword such as an ID. So the idea that I could think of here is that once you're done with your first workshop, you can get the Excel data of your submissions, trim the data and use it for your 2nd form that shall prefill the fields upon having a matching information.
If you have additional questions, please let us know.
- JotForm SupportMikeAnswered on July 27, 2017 at 03:46 PM
I am sorry to inform you but we do not currently have a feature to dynamically populate the form from a remote data source. It might be implemented at some point in the future, but we do not have a ETA at this time.