What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    Automatically fill in data from last registration

    Asked by DBConsortium on July 27, 2017 at 02:30 PM

     Read entire thread from bottom up...

     

    From: Don Brown [mailto:don@donbrowninc.com]
    Sent: Tuesday, July 25, 2017 7:45 PM
    To: jotformforum_1191087@interlogy.com
    Subject: RE: Automatically fill in data from last registration

     

    Hello JotForm

     

    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.

     

    Don

     

    ===============

    Don Brown

    Mobile : 1-215 688 1469

    FAX    : 1-267-552-6248 

    don@donbrowninc.com

    Doylestown, PA  USA

    ===============

     

    From: JotForm [mailto:noreply@jotform.com]
    Sent: Tuesday, July 04, 2017 11:42 PM
    To: Don@DonBrownInc.com
    Subject: Re: Automatically fill in data from last registration

     

    A new response has been received:

    JOTFORM

    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. 

    https://widgets.jotform.com/app/spreadsheet_to_form

    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.

    View this thread on browser » Unsubscribe Thread

     

    1499226149 

  • Profile Image
    JotForm Support

    Answered by Mike 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.