Concatenate field values

  • Profile Image
    darliechloe2
    Asked on June 29, 2021 at 08:49 AM

    Or do I add a Formula Field that string together Kid1Age-Kid1Gender-Kit2Age-Kit2Gender-Kid3Age-Kid3Gender-Kid4Age-Kid4Gender ?

    Please provide the right syntax perhaps coz I've tried to do and spent a lot frustration... and still can't do it. I just want the Jotform info all well-zapped into Airtable. (especially this KidsAge information. In a string or TEXTJOIN preferrably.


    Thanks!!

    Chloe

  • Profile Image
    Michal_S
    Answered on June 29, 2021 at 09:04 AM

    Hello!

    You can do that using the Form Calculation widget.

    The widget will take the values from multiple fields and string them together into one field.

    Here's how to get it working:

    • Add a Form Calculation widget to your form, you can hide it if you don't want it to appear on the form:
      133038_hide%20field.png


    • Configure the widget as follows - use the Add Field button to add the fields to be concatenated, separating each one with a separator of your choice - you can input it from your keyboard - make sure you then click on all elements to turn them brown to make them parsed as strings:

      133039_calcconfig.gif

    The result is as follows:

    133040_calcresult.gif

    Related guide: How to Perform Form Calculation Using a Widget

    Please let us know if you require any further assistance.

    Thank you!