Input Table: Prepopulating the Input Table for the next submitter based on the previous input of the same Table.

  • Bee_Queen
    Asked on March 3, 2020 at 4:32 PM

    The form we are using may require us to put in the same information in certain fields in the table, so we're hoping to be able to prepopulate it. I've tried several ways of typing the #inputs but it doesn't seem to go through. Is it possible or am I just doing it wrong?

  • Sonnyfer JotForm Support
    Replied on March 3, 2020 at 9:32 PM

    Hi,

    Thanks for reaching out.

    #input or FIELD IDs are used to style your forms using CSS codes. This is the reason why it doesn't go through to the forms you wish to be prepopulated. Please use UNIQUE NAME instead. You can find it by navigating through Field Properties > ADVANCEDField Details.

    1583288868unique name Screenshot 10

    Moreover, here is a detailed guide that might help you with prepopulating your form: Prepopulating-Fields-to-Your-JotForm-via-URL-Parameters

    Hope this helps.

    Please let us know if you need further assistance.


  • Bee_Queen
    Replied on March 4, 2020 at 11:32 AM

    Oh, I'm aware of that, but I use the input fields, for example in 'Address', to get all the individual text in the right field or it'll only all show up in the first line (address line, city, zipcode all in one), and it works, it shows up in their own field. Therefore I tried the input fields because I want them all in their own text field on the Table.

    And when I just use the UNIQUE NAME for the input field, all it shows is "Array" in the first box and not the prepopulated information I needed.

    1583339269Array Screenshot 10

    I played around with it some more and this is the best I got.

    1583338002Capture Screenshot 21

    This is so close but I need Position 1 and 2.

  • Sonnyfer JotForm Support
    Replied on March 4, 2020 at 3:04 PM

    Hi,

    Thanks for the clarification.

    For Input Tables, you need to declare the UNIQUE NAME together with its exact position in the multidimensional Array.

    For instance, if you wish to prepopulate the first row, first column of your Input Table with UNIQUE NAME labour, you need to specify labour[0][0] in your form URL.

    The first [0] is the row number while the second [0] is the column number. Note that array index always starts with zero (0).

    Here's a sample code I tried to prepopulate the table named labour in your form:

    https://www.jotform.com/200616185311243?labour[0][0]=John&labour[0][1]=CEO&labour[0][2]=8:00AM&labour[1][0]=Mark&labour[1][1]=CFO&labour[1][2]=8:15AM

    1583351288labour Screenshot 10

    Kindly give it a try and let us know if you face any issues working with multi-dimensional arrays for prepopuating your Input Table.


  • Bee_Queen
    Replied on March 4, 2020 at 4:22 PM

    Thanks for your help! So I tried it and it looks good so far on its own:

    1583356386Capture2 Screenshot 10

    But I guess the next issue is that I'm prepopulating these values from the same form when a submission is made, so it will change from each one. So I did something like this for example:

    &labour[0][0]={labour[0][0]}&labour[0][1]={labour[0][1]}&labour[1][0]={labour[1][0]}&labour[1][1]={labour[1][1]}&labour[2][0]={labour[2][0]}&labour[2][1]={labour[2][1]}&labour[3][0]={labour[3][0]}&labour[3][1]={labour[3][1]}

    I made a submission myself with an autoresponder with the link in it. Everything else I put in the link pulled over beside the values for the table...

  • Sonnyfer JotForm Support
    Replied on March 4, 2020 at 5:34 PM

    Please allow me some time while I do some tests on my end. Will get back to you on this thread once I have results to share.

  • Bee_Queen
    Replied on March 4, 2020 at 5:51 PM

    Thanks so much!

  • Sonnyfer JotForm Support
    Replied on March 4, 2020 at 6:41 PM

    Thanks for your patience.

    Unfortunately, it appears that it is currently not possible to capture only a part of the Input Table once the form is submitted. I have tried testing some codes to capture a specific field/column on the table but it always returns the whole input table.

    1583363535labour 00 Screenshot 10

    I will escalate this to our backend team as a feature request. However, we cannot provide you an ETA for implementation as it depends on the developer's availability and urgency of other requests. We will inform you of the updates via this thread.

    Thanks for understanding.