Can you pull specific fields from an input form into a text box or email notification?

  • NicolCorcExpo
    Asked 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).

    1566707991Address Successfully Separated Screenshot 10

     

    This is the unsuccessful attempt of separating the fields of the input table:

    1566708100Rates Unsuccessfully Separated Screenshot 210

     

    Thanks in advance for your help!

  • AshtonP
    Replied on August 25, 2019 at 3:04 AM

    We are checking his and we will get back to you with an update

  • NicolCorcExpo
    Replied on August 25, 2019 at 8:23 PM

    Thank you! I really appreciate it!

  • AshtonP
    Replied 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. 

    1566782510Screenshot 95 Screenshot 10

    Here is the form in action - 

    1566782930form in action Screenshot 21

    You can create conditional logic as below - 

    1566783028Screenshot 96 Screenshot 32

    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.

  • NicolCorcExpo
    Replied on August 26, 2019 at 8:42 AM

    Thank you @AshtonP! I appreciate you looking into that! This is SUPER helpful!