Show multiple value from different fields to one single field?

  • mtarter15
    Asked on September 6, 2024 at 10:59 AM

    Hello,

    I have created a form where I want information from several different fields to copy into another single field. I have set up the condition for this but it doesn't seem to be working and instead enters a 0 into the field instead of the data I have selected. I have tried editing how I have the condition set up in various ways but nothing so far has worked.

    Show multiple value from different fields to one single field? Image 1 Screenshot 20

  • Gaud JotForm Support
    Replied on September 6, 2024 at 11:55 AM

    Hi Michelle Tarter,

    Thanks for reaching out to Jotform Support. I'll do my best to help you. I've checked out the screenshot you shared with us. You will need to set up the conditions for each field separately. So, it should be similar to this one. Add an Update/Calculate Field condition to pass the values from the field 3 to the 7,8,9,10. Let me show you how:

    a. In Form Builder, in the orange navigation bar at the top of the page, click on Settings.

    b. In the panel on the left side of the screen, select Conditions.

    c. Select Update/ Calculate field and then set your conditions just like you see below. 

    d. Then, click on Save and you’re done.

    Show multiple value from different fields to one single field? Image 1 Screenshot 70

    Show multiple value from different fields to one single field? Image 2 Screenshot 81

    Show multiple value from different fields to one single field? Image 3 Screenshot 92

    Show multiple value from different fields to one single field? Image 4 Screenshot 103

    Show multiple value from different fields to one single field? Image 5 Screenshot 114

    Show multiple value from different fields to one single field? Image 6 Screenshot 125

    Give it a try and let us know how it goes.


  • mtarter15
    Replied on September 6, 2024 at 12:19 PM

    What I am actually trying to do is copy the entries from fields 3, 8, 9 and 10 into field 7. I did try setting it individually but doing it that way wouldn't allow for the multiple entries.

  • Camila JotForm Support
    Replied on September 6, 2024 at 1:04 PM

    Hi Michelle,

    I checked your form, and it appears that your number 7 field is a paragraph field as of now? If you want to display the details from 3, 8, 9 and 10 into field 7, you need to get all the Unique names of 3,8,9,10 and add it to your Paragraph field like this:

    Show multiple value from different fields to one single field? Image 1 Screenshot 40

    Let me show you how to do it:

    1. In Form Builder, select the form element’s gear icon to open properties.
    2. In Properties panel, click Advanced on the right side of the screen.
    3. Scroll down to the bottom and expand Field Details.
    4. Copy the value in the Unique Name field.

    Show multiple value from different fields to one single field? Image 2 Screenshot 51

    Check out the result below:

    Show multiple value from different fields to one single field? Image 3 Screenshot 62


    You can check out this Demo Form so you can try it by yourself. If you want to clone the form, you can check out this guide about How to Clone an Existing Form From a URL. You can also check this guide about How to Find Field IDs and Unique Names.

    If that’s not exactly what you’re looking for, can you explain a bit more so I can help you better?

    Let us know if there’s anything else we can help you with. 

  • mtarter15
    Replied on September 6, 2024 at 1:15 PM

    I was able to get the fields into the Paragraph field and have it appear as I would want but ultimately I want to use that field to prefill onto a secondary form. https://form.jotform.com/242485307156155

    From what I found online, it doesn't look I can use the prefill option for the paragraph data.

    Is there a way you can get several fields to copy into a single one so I can use the single field to then prefill into the secondary form with a field labeled "Trip Name"?

  • Gaud JotForm Support
    Replied on September 6, 2024 at 2:05 PM

    Hi Michelle,

    You can't pass the data from one paragraph field into another one. You can use the short text field instead. Then you can use the update/calculate field conditional logic to combine the values of 3,7,8,9,10. Then you can use the prefill for your second form.

    https://form.jotform.com/your_secondary_form_id?tripName={input67}

    Here is a guide on how to automatically pass the form data to another form you can go through.

    Let us know how it goes.

  • mtarter15
    Replied on September 6, 2024 at 2:38 PM

    I have been able to use the prefill option to transfer the data I want from the first form to the second.

    The issue I am having is that when I try to have the data from fields 3, 8, 9 and 10 copy into field 7 it doesn't do it and instead only enters a 0.

    I have reverted the form to an earlier version so you can see how I have it currently set up with a screenshot of the condition below. https://form.jotform.com/242465767163161

    Show multiple value from different fields to one single field? Image 1 Screenshot 20

  • Aries JotForm Support
    Replied on September 6, 2024 at 3:03 PM

    Hi Michelle,

    I’ll need a bit of time to look into this. I’ll get back to you as soon as I can.

  • Aries JotForm Support
    Replied on September 6, 2024 at 3:39 PM

    Hi Michelle,

    Thanks for your patience. You can try to use the Form Calculation widget to copy the value from 3, 8, 9, and 10, then pass the value to field 7. Let me show you how.

    1. In Form Builder, click on Add Form Elements.

    Show multiple value from different fields to one single field? Image 1 Screenshot 60

    2. Go to Widgets and choose Form Calculation then add it to your form field.

    Show multiple value from different fields to one single field? Image 2 Screenshot 71

    3. Click on the wand icon.

    4. Then click on Add Field.

    5. Choose the fields you want to copy and click Save.

    Show multiple value from different fields to one single field? Image 3 Screenshot 82

    6. Now recreate the condition to copy the value from Form Calculation widget to field 7.

    Here's the conditional logic I used:

    Show multiple value from different fields to one single field? Image 4 Screenshot 93

    Here's the result:

    Show multiple value from different fields to one single field? Image 5 Screenshot 104

    Give it a try and let us know how it goes.

  • mtarter15
    Replied on September 6, 2024 at 3:47 PM

    I set up everything just as you described but it is still entering 0 into the Trip Field (7).

    https://form.jotform.com/242465767163161

  • Gaud JotForm Support
    Replied on September 6, 2024 at 4:19 PM

    Hi Michelle,

    I've checked out the Form Calculation widget, you will need to select the String value instead of number value. With String value, you will be able to pass the information. Let me show you how:

    1. Open your form in Form Builder, and in the orange navigation bar at the top of the screen, click on the magic wand icon of the Form Calculation widget.
    2. On the right side, on each field, click on the 0-9, and it will turn into the gray.
    3. Press comma button and comma should be gray too. That's it.

    Show multiple value from different fields to one single field? Image 1 Screenshot 30

    Show multiple value from different fields to one single field? Image 2 Screenshot 41

    Let us know how it goes.

Your Answer