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

  • Profile Image
    Hadden_Jason
    Asked on March 03, 2020 at 04: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?

  • Profile Image
    Sonnyfer
    Answered on March 03, 2020 at 09: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.png

    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.


  • Profile Image
    Hadden_Jason
    Answered on March 04, 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.PNG

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

    1583338002Capture.PNG

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

  • Profile Image
    Sonnyfer
    Answered on March 04, 2020 at 03: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.png

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


  • Profile Image
    Hadden_Jason
    Answered on March 04, 2020 at 04:22 PM

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

    1583356386Capture2.PNG

    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...

  • Profile Image
    Sonnyfer
    Answered on March 04, 2020 at 05: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.

  • Profile Image
    Hadden_Jason
    Answered on March 04, 2020 at 05:51 PM

    Thanks so much!

  • Profile Image
    Sonnyfer
    Answered on March 04, 2020 at 06: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.png

    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.