Allow users to pay based on an existing submission?

Hello, thanks for getting back to me so quickly. This is a bowling tournament registration form. I want a user to be able to fill out the form, pay for any bowlers they want to and submit the form. I was hoping that they could then forward the autoresponder e-mail with the edit link to any other bowlers that need to pay and those bowlers would be able to select who they want to pay for, fill out the payment details (with their name and credit card information) and click the submit button to charge their credit card. This particular form was submitted with ‘0’ in the payment field because I wanted to test that process.

Unfortunately, it is not possible to trigger payments on the edit link. What I have in mind to accomplish your goal is to use two forms. First form is for the registration details while the second form is the actual payment form. 

However, the problem on the process you want is that the whole form submission is NOT for all the bowlers, instead you want the payor to choose which bowler to pay? Is that correct? 

The setup I have will allow you to generate prepopulated URLs for Form 2 that will be unique for each bowler or for the whole team. 

Here's what I have:

Form 1: Cloned main form https://form.jotform.com/72050569180959. I have removed the payment field here.

Form 2: https://form.jotformpro.com/72050712180949. This is the actual payment form.

1. First, I have set an order ID field using the Unique ID widget. To learn more about this, you can check this guide: https://www.jotform.com/help/79-How-to-Add-Custom-Unique-IDs-to-your-Form-Submissions. Basically, I will use this as the reference to map the payment submissions. 

 

2. Here I will create my Form 2. 

Order ID => This is a simple text box, we will prepopulate it with the value from the submission in Form 1. 

To: => Similar to Order ID, this is prepopulated with the values from submission in Form 1.

Cost => This is the amount being paid to the bowler or to the whole team.

My Products => This is the payment integration setup in our end.

 

3. The total value on our payment field will be based on the "Cost" field, which is a form calculation widget. 

 

4. Now we will create the unique links. What we want to achieve is this:

A. User fills out Form 1.

B. Payor receives email with preopulated unique links of Form 2.

C. Payor can choose or share the links to those who want to pay for specific bowlers or to the whole team.

This approach is based on this guide: https://www.jotform.com/help/351-How-to-Automatically-Pass-Form-Data-to-Another-Form. We want to pass the data from Form 1 to Form 2. 

 

5. Here are the format on how I setup my Form 2 links:

Bowler 1A: https://form.jotformpro.com/72050712180949?orderId={uniqueOrder}&to={name}&cost={grandTotal} 

Bowler 1B: https://form.jotformpro.com/72050712180949?orderId={uniqueOrder}&to={name187}&cost={bowler1b} 

Bowler 2A: https://form.jotformpro.com/72050712180949?orderId={uniqueOrder}&to={name188}&cost={bowler2a} 

Bowler 2B: https://form.jotformpro.com/72050712180949?orderId={uniqueOrder}&to={name189}&cost={bowler2b} 

Full Payment to team: https://form.jotformpro.com/72050712180949?orderId={uniqueOrder}&to={teamName}&cost={totalTeam} 

 

Those links will be added in the email alerts and the receiver can choose who they would like to pay. 

This is the format of the link:

https://form.jotformpro.com/72050712180949?orderId={uniqueOrder}&to={teamName}&cost={totalTeam} 

Green => Form 2 URL

Yellow => "?" is the starting point of the prepopulation.

Blue => These are the "Unique Name" of the Form 2 field. Below is an example on where to find it. Select a field -> Properties -> Advanced -> Unique Name. 

 

Red => The "=" which assigns a value to the field.

Pink => This is the field tag that fetches the value of Form 1. You can get it in the email alert. 

Grey => "&" is used to append another field or in the parameter.

 

Basically we are filling out the Form 2 fields based on Form 1 fields. 

This is how it looks like:

 

You can test my form and clone it to see how it works. Here's how you can clone the form: https://www.jotform.com/help/42-How-to-Clone-an-Existing-Form-from-a-URL. 

 

Additional tip: If you wish to organize the payment submissions, you can integrate it to Google Spreadsheet so that you have a better way of viewing it. 

I hope that helps.

Hello. Thanks so much for your response! I think this will definitely work for me and can’t wait to try it out. I am a new user to JotForm and I have been very impressed with the product but I am overwhelmed by the awesome support you provide. Your response shows that you truly take the time to understand the end user’s needs and develop a solution that works for them and the step by step documentation is great for novice developers like me. Thanks again for all of your help with this!

...

We thank you for your comments on our product and support. Please give it a try and let us know if you need any further assistance. We will be happy to assist. 

Thank you for using JotForm!