-
mtarter15Asked 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.
Page URL: https://form.jotform.com/242465767163161 -
Gaud JotForm SupportReplied 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.
Give it a try and let us know how it goes.
-
mtarter15Replied 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 SupportReplied 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:
Let me show you how to do it:
- In Form Builder, select the form element’s gear icon to open properties.
- In Properties panel, click Advanced on the right side of the screen.
- Scroll down to the bottom and expand Field Details.
- Copy the value in the Unique Name field.
Check out the result below:
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.
-
mtarter15Replied 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 SupportReplied 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.
-
mtarter15Replied 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
-
Aries JotForm SupportReplied 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 SupportReplied 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.
2. Go to Widgets and choose Form Calculation then add it to your form field.
3. Click on the wand icon.
4. Then click on Add Field.
5. Choose the fields you want to copy and click Save.
6. Now recreate the condition to copy the value from Form Calculation widget to field 7.
Here's the conditional logic I used:
Here's the result:
Give it a try and let us know how it goes.
-
mtarter15Replied 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).
-
Gaud JotForm SupportReplied 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:
- 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.
- On the right side, on each field, click on the 0-9, and it will turn into the gray.
- Press comma button and comma should be gray too. That's it.
Let us know how it goes.