Join Values from Multiple Fields

  • criterions
    Asked on May 5, 2015 at 8:39 AM

    It might be too much to ask, but does anyone know if it is possible to a fields value (using conditions) by concatenating something to its current value. Something like this:

     

    Field 1: Dog

    Field 2: Cat

    Field 3: Mouse

    I want to update Field 1 by using its current value and appending the value of Field 2 and Field 3 to it, yielding:

     

    DogCatMouse

    I've attempted it and get some bizarre results.

     

  • Sammy
    Replied on May 5, 2015 at 10:04 AM

    Repopulating a filed that is used in the same condition criteria will result in unpredictable data and text output will be repetitive, I would recommend using the form calculation widget and the outputting the concatenating values in its result textbox.

    Add a calculation widget to your form

    Join Values from Multiple Fields Image 1 Screenshot 70

    Select the Three fields to include in your calculation

    Join Values from Multiple Fields Image 2 Screenshot 81

    Join Values from Multiple Fields Image 3 Screenshot 92

    Click on the numeric fields to change the input type to text

    Join Values from Multiple Fields Image 4 Screenshot 103

    Now click on Show Advanced options

    Join Values from Multiple Fields Image 5 Screenshot 114

     

    Test your form

    Join Values from Multiple Fields Image 6 Screenshot 125

    You can clone a copy of the form, here is its URL : http://form.jotformpro.com/form/51244461674960

    If you have any more questions feel free to ask.

  • criterions
    Replied on May 5, 2015 at 11:34 AM

    Excellent - many thanks!