How can I call data to a form from an excel sheet or other form?

  • yogishchandra
    Asked on July 16, 2017 at 2:19 AM

    Hi,

    I wish to know if it is possible to call data from another form's table to a form and use it in the current form?

     

  • John_Benson
    Replied on July 16, 2017 at 2:28 AM

    If you're referring to Export Form Data to Excel, that is possible here in JotForm. To do that, please follow this guide: https://www.jotform.com/help/44-How-to-Export-Form-Data-to-Excel

    Hope that helps.

  • yogishchandra
    Replied on July 16, 2017 at 6:47 AM

    Hi,

    It is not exporting data to a excel sheet. For example I have two forms and two tables.

    F1 T1 and F2 T2

    Based on some condition is it possible to import selective data from T1 to F2 dynamically?

  • liyam
    Replied on July 16, 2017 at 7:52 AM

    You can import your data from your spreadsheet to your form by using the JotForm Import App. You can check out this guide for more information on where to get and how to use it: https://www.jotform.com/help/308-Import-App-Easily-import-your-Excel-or-CSV-data-into-JotForm 

    If you have questions, please let us know.

  • liyam
    Replied on July 16, 2017 at 7:55 AM

    Hello again. I think I'm getting a clearer picture of what you mean. If I'm getting it correctly, you would like to use the spreadsheet and use the contents of its data to pre-fill some fields in your form, is that it? If so, please check out this guide instead: https://www.jotform.com/help/442-How-to-Use-the-Spreadsheet-to-Form-Widget

     

  • yogishchandra
    Replied on July 16, 2017 at 2:07 PM

    Hi,

    Sorry, I think I missed saying that I was referring to only jotforms internal tables and not importing any external files.

    For example I already have two forms. Say Form 1 and Form 2. Form 1 has a text box for entering data and Form 2 has a different text box which is read only.

    Is it possible to place a particular data from Form 1 table to Form 2 text box using unique code of data of Form 1

  • Mike
    Replied on July 16, 2017 at 2:37 PM

    Unfortunately, we do not have built-in functionality to achieve that goal. This might be only possible if you use a form source code in combination with programming. The data from the other form can be retrieved using our API.