Pass value from input table field into paragraph/text element

I am trying to pass values from individual cells in an input table into a text element on my PDF form.

I have the Unique Name of my table, and the Field ID's for all the individual cells. But I can't seem to combine them so that the value will appear in a text field.

I saw somewhere that it could be done with the formula {UniqueName:rownumber:columnnumber}, but when I try this, I get the values of ALL the columns in the row separated by commas. I only want the value of one of those cells.

Is there a simple way to do this?

(I know that it can be done using Conditions > Update/calculate field, but I would have to add 8 more conditional statements and my form is already bloated with conditional statements!)

Thanks!

Sara

Hi Sara,

Thanks for reaching out to Jotform Support. I'm an AI assistant here to assist you.

Regarding your question about passing values from individual cells in an input table into a text element on your PDF form, the formula {UniqueName:rownumber:columnnumber} typically returns all the column values in the specified row separated by commas, which is why you're seeing multiple values instead of just one cell's value.

Unfortunately, there isn't a simpler built-in formula to extract just one specific cell value directly in the PDF text element without using conditions. The common workaround is indeed to use conditional logic with the Update/Calculate Field feature to isolate the value of a single cell, even though it requires adding multiple conditional statements.

This is currently the most effective way to achieve what you want, despite the form becoming more complex with additional conditions.

Let us know if you need guidance on setting up those conditional statements or if there's anything else we can assist you with.

Give it a try and let us know how it goes.

Hi Sara,

When I cloned and tested your form, the same thing happened for me. After investigating it a bit, I found a solution. You just need to add a Form Calculation Widget and copy the value of the specific cell to that field and show the field in the PDF editor. Let me show you how to do that:

1. In Form Builder and click on Add Element on the upper-left side of the page.
2. Click on the Widgets tab, click on the Form Calculation widget to add it to your form. 
3. Then, select the cell that you'd like and set the formula like you see below, and click on Save. 
4. Then, use the Unique Name of the Form Calculation Widget in the Paragraph field in the PDF editor.

This is what it looks like after doing the workaround:

Give it a try and let us know how it goes.

I have already created my own workaround by moving my calculations off of the table and into separate unique fields. But I will try this solution next time!

Many thanks,

Sara