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

  • Profile Image
    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

     

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

    1566708100Rates-Unsuccessfully Separated0

     

    Thanks in advance for your help!

  • Profile Image
    AshtonP
    Answered on August 25, 2019 at 03:04 AM

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

  • Profile Image
    NicolCorcExpo
    Answered on August 25, 2019 at 08:23 PM

    Thank you! I really appreciate it!

  • Profile Image
    AshtonP
    Answered on August 25, 2019 at 09: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.png

    Here is the form in action - 

    1566782930form-in-action.gif

    You can create conditional logic as below - 

    1566783028Screenshot_96.png

    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.

  • Profile Image
    NicolCorcExpo
    Answered on August 26, 2019 at 08:42 AM

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