How to pass data of "Input table" from one form to "Input table" of another form dynamically?

  • gordonyang
    Asked on October 12, 2017 at 7:27 PM

    Hello, I looked at the tutorial here for how to transfer data from one form to another using URL variables. https://www.jotform.com/help/351-How-to-Automatically-Pass-Form-Data-to-Another-Form

    However, the tutorial does not cover how to do this when the field type is a data table.

    I've tried to mess around with using the field indexes, but nothing I have tried seems to be working.

    Can someone advise on the proper way to do this? The URL I have been using to help populate the fields on the second form is something along the format of this:

    https://mywebsite.com/form2.html?session={email}-{id}&accountlist[0]={accounts:0}&accountlist[1]={accounts:1}&accountlist[2]={accounts:2}&accountlist[3]={accounts:3}&accountlist[4]={accounts:4}&accountlist[5]={accounts:5}&accountlist[6]={accounts:6}

    In this case, accountlist is the variable on the second form that represents the table, and accounts is the variable on the first form that represents the table.

    The table on both forms are the same format, just one column of fillable data, and 7 fillable rows.

    The second form only seems to fill the table with the word "array" on it instead of the actual data that was filled on form 1.

    I think I'm just missing the correct syntax for how to populate data between two tables. The other types of fields I've used a similar format to this and those have been working flawlessly just like the tutorial mentioned. Using brackets [] on the field to be populated on form 2, and {} on the data to be extracted from the first form.

    Does anyone have any ideas?

  • Ashwin JotForm Support
    Replied on October 13, 2017 at 1:21 AM

    Can you please let us know which is the form from where you are reading the data and populating it? I did check your last edited form but it does not has any "Input Table" field added.

    Let me check test and get back to you on how to read the value of specific cell of input able and populate it in different form.

  • gordonyang
    Replied on October 13, 2017 at 10:36 AM

    Hi Ashwin,

    Here is the form that data is being read from: https://form.jotform.com/72477893180164

    Here is the form that is being populated: https://form.jotform.com/72497153380157


  • Ashwin JotForm Support
    Replied on October 13, 2017 at 11:32 AM

    I did test this issue and unfortunately it is currently not possible to read the matrix cell value and pass it on to second form to populate another matrix / Input table field. I am forwarding this issue to our backend team. We will get back to you as soon as we have any update from them.

    For now, I can suggest you a workaround solution to achieve your requirement. I would suggest you to please add a "Form Calculation" widget for each of the matrix cell and set the formula to read the cell value. I will create a demo form and get back to you on this soon.


  • Ashwin JotForm Support
    Replied on October 13, 2017 at 12:05 PM

    As explain earlier that for workaround solution, you need to add a new "Form Calculation" widget for each matrix / input table cell. Please check the screenshot below on how to add form calculation widget and set the formula to read the matrix / input table cell values:

    1507909683formCalu Screenshot 10


    I have cloned your first form and added the following prepopulation URL for your second form:

    https://form.jotform.com/72497153380157?q284_accountlist[0][0]={it_checking}&q284_accountlist[1][0]={it_moneyMarket}&q284_accountlist[2][0]={it_savings}&q284_accountlist[3][0]={it_sweep}&q284_accountlist[4][0]={it_other}&q284_accountlist[5][0]={it_loan}&q284_accountlist[6][0]={it_lineOf}

    Please test the following cloned first form and see if this works as expected and populates the second form correctly:  https://form.jotform.com/72854960518971

    Do get back to us if you have any questions.