Jotform tables:Can I use the values in Row and Column to select a value?

Can I use the values in Row (the green area) and Column (the sky blue area) to select a value automatically (one data in the yellow area) from the table?

Thank you in advanced

Best regards,

Naris C.

Hi Naris,

Thanks for reaching out to Jotform Support. Unfortunately, it is not possible in Jotform tables. If that’s not exactly what you’re looking for, can you explain a bit more so I can help you better? Rest assured, we’ll find a solution for this. Can you share with us a screen recording of what’s happening so we can try to replicate it on our end? You can share the video recording on any public sharing platform like Google Drive or Dropbox, or you can simply use Loom to record the video and share the video link with us.

You can also check out this guide on Performing Calculations With Input Table

Once we hear back from you, we'll be able to move forward with a solution.

Thank you for your prompt reply.

I use the index function in Excel to select a value from a table.
Example: If I select the values of C1, C1.1, R1 and R1.2, then the value of "5" in the table will be automatically selected.

I write the following code to select a value from the yellow area in the table.
=INDEX(D6:K23,MATCH(I28&I38,B6:B23&C6:C23,0),MATCH(I48&I59,D4:K4&D5:K5,0))

How could I do this in the jotform?

Example of the excel form I would like to do it on Jotform.

https://docs.google.com/spreadsheets/d/10e9jLjImffUZrA_mIgGzADzc8ETldRRf/edit?usp=sharing&ouid=104102519129146324749&rtpof=true&sd=true

Hi Naris,

If you want to do the same in Jotform tables, it is not possible to do so. I’ll need a bit of time to look into this. I’ll get back to you as soon as I can.

Thanks for your patience, we appreciate it.

Hi Naris,

If you want to include an input table on your form, add a calculation value per cell, and then get the value using the Form Calculation widget. Check out my screencast below:

If you want to apply it to Jotform Tables, you can try to explore the Advanced Formula Logical Function.

Check out my screencast below:

You can check out my form here and you can clone it as well. If that’s not exactly what you’re looking for, can you explain a bit more so I can help you better?

After we hear back from you, we’ll have a better idea of what’s going on and how to help.