-
NicolCorcExpoAsked on August 25, 2019 at 12:41 AM
Hi there!
I'm set-up request form for work. The idea is that we can collect all of the information in a single place and also be able to generate some specific language directly into the form based on the previous responses (essentially a mail merge).
I have an input table where the columns are named "RATE NAME", "COST", and "UNIT" and there are 6 rows names "Rate 1" to "Rate 6". I would like to be able to pull the specific fields to create language like "Standard Rate: $37/SqFt"
I remembered from a previous form I made that I was able separate out fields from an address so I tried using the same logic of using an open curly bracket, unique field name, colon, input id (after the underscore), and closed bracket, but it didn't work.
Any thoughts or solutions?
This is a picture of the successful separation of fields for the address (what I used as a guide).
This is the unsuccessful attempt of separating the fields of the input table:
0
Thanks in advance for your help!
-
AshtonPReplied on August 25, 2019 at 3:04 AM
We are checking his and we will get back to you with an update
-
NicolCorcExpoReplied on August 25, 2019 at 8:23 PM
Thank you! I really appreciate it!
-
AshtonPReplied on August 25, 2019 at 9:33 PM
Hello @NicolCorcExpo, I appreciate your patience. I have tried to play around with the Input Table and HTML text field, however, I had no luck. Unfortunately, you cannot copy the value from the Input table cells to the HTML Text field on the form.
However, there is a workaround you can use. You can copy the Input table cells' values to Short text field using conditional logic and then copy it over to HTML Text field. You will need to add a short text field for each cell. You can hide these fields so they are now shown on the main form
In an example below I have created a short text field for the first row.
Here is the form in action -
You can create conditional logic as below -
Useful Guide: https://www.jotform.com/help/268-How-to-Insert-Text-or-Calculation-into-a-Field-Using-Conditional-Logic
Here is my demo form: https://form.jotform.com/92368004734962
I hope this helps. Feel free to get in touch should you have further concerns.
-
NicolCorcExpoReplied on August 26, 2019 at 8:42 AM
Thank you @AshtonP! I appreciate you looking into that! This is SUPER helpful!