The field is not populating data to another form

I want to push the data from "Total Price for Verification" field from the Quonset All in One form to "Total Contract Price" field on Verification letter, but it's not working

Hi Orders_Buildway,

Thanks for reaching out to us for help.  I understand what you’d like to do, but I’ll need a bit of time to work out a solution. I’ll get back to you shortly.

Thanks for your patience and understanding.

Hi Orders_Buildway,

To push data from the Total Price for Verification field in your Quonset All in One form to the Total Contract Price field on the Verification letter form, you can use the URL Parameters feature or the Form Prefill method. This allows you to pass data between forms. Here’s how to do it:

1. Use the Form Prefill app: Go to the Field Prepopulator app at https://io-apps.jotform.io/prepopulate/ and authorize it to access your forms.
2. Select your source form: Choose your Quonset All in One form and continue.
3. Set prefill values: Map the Total Price for Verification field to the Total Contract Price field on the target form (Verification letter).
4. Generate the prefilled URL: Copy the generated URL and use it to open the target form with the data prefilled.

To do this, I first need to get the unique names of both the source field and target field. Let me show you how to do that:

1. In the target form's Form Builder page, click on the target field, and click on the Gear icon to open Properties.
2. Go to the Advanced tab, and expand Field Details by clicking the Downward Arrow icon.
3. Copy the Unique Name.

You also need to get the unique name of the source form's field, where the data will be from. Check out the screencast below:

The URL parameters should be:

https://form.jotform.com/251525874526968?totalContract={totalPrice}

Now, you need to add this URL to your source forms Thank You Page under Settings. Let's do it:

1. In Form Builder, click on Settings in the orange navigation bar at the top part of the page.
2. Select Thank You Page from the left-side menu.
3. Select Redirect to an external link after submission.
4. Enter the given URL parameters above into the Enter URL field.

Check out my screencast to see how it'll work:

Another way is to use the Form Prefill feature. Prefilling your form using another form is easy. Let me show you how:

1. In Form Builder, in the orange navigation bar at the top of the page, click on Publish.
2. Now, click on Prefill in the menu on the left side of the page, and then select Form Prefill.
3. Click on the Downward Arrow icon and select the form that you want to prefill from, and then match the fields.
4. Finally, click on Save Settings on the bottom-right side of the Form Prefill section.

Now that you’ve set up the prefill settings, you'll need to add a new prefill. Let’s do it:

1. Click on Add a New Prefill and select a row or the rows you want to be prefilled.
2. Then, click on the Create button in the right corner of the page.

That's it. Now, a prefill link's been created, and you can share that with people. When they open the link, the matched fields will be filled automatically. Check out the screencast below to see how it works:

If you want your prefilled fields to be read-only and not editable, you can change the options for those:

1. In the Form Prefill settings, click on Can Edit next to the prefill link.
2. In the dropdown menu that opens, select Read only, and that's it.

Give it a try and let us know if you need any other help.

Hi, I try to use the add column --> Send Form function in the Quonset All in One table

All the field work well except "Total Contract Price". Please advise

Thanks

Hi Orders_Buildway,

Since all fields except Total Contract Price are working well, here are some points to check and steps to ensure this field populates correctly:

1. Verify Field Mapping: When setting up the Send Form Action Button column, make sure the Total Contract Price field in the target form is correctly mapped to the corresponding column in your table.
2. Check Field Compatibility: Confirm that the Total Contract Price field type in the target form matches the data type of the source field. For example, if one is a number field and the other is text, it might cause issues. Make sure that both fields are number fields. Total Price for Verification field is a number field, and Total Contract Price field must be a number field as well. For example, if one is a number field and the other is text, it might cause issues.
3. Allow Editing or Prefill Settings: In the Send Form setup, check if the Allow User to Edit Answers option is enabled if you want the recipient to modify the prefilled data. Also, ensure the Prefill Form Fields setting is turned on.
4. Test with a Single Entry: Try sending the form for a single entry to see if the data populates correctly. Sometimes bulk sending can have different behavior.
5. Review Form Access Settings: Ensure the target form is accessible to recipients, so the prefilled data can be viewed and edited as intended.

If the issue persists, you might want to reconfigure the Send Form button settings or remap the fields to ensure everything is set up properly. Make sure that you are selecting the Verification Letter form and that in the prefill settings, Total Price for Verification is mapped to Total Contract Price field.

In line with this, I tested the Send Form button in the Jotform Table in the Quonset All in One form, and it works the way it was set up. Take a look at the screenshot below:

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