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

  • Profile Image
    yogishchandra
    Asked on July 16, 2017 at 02: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?

     

  • Profile Image
    John_Benson
    Answered on July 16, 2017 at 02: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.

  • Profile Image
    yogishchandra
    Answered on July 16, 2017 at 06: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?

  • Profile Image
    liyam
    Answered on July 16, 2017 at 07: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.

  • Profile Image
    liyam
    Answered on July 16, 2017 at 07: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

     

  • Profile Image
    yogishchandra
    Answered on July 16, 2017 at 02: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

  • Profile Image
    Mike
    Answered on July 16, 2017 at 02: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.