Payment Confirmation and Database...

User 2869370 Photo


Registered User
15 posts

My form has been configured to perform the following actions:

1. Upon submittal, the database to which the form is communicating is updated with the entries provided on the form.
2. Also upon submittal, the user is provided a summary of the items purchased in his/her browser.
3. After reviewing the order, the user will press the payment button, which is configured to allow payment through PayPal. Alternatively, the user can return to the form and update/correct anything noted in his/her review of the purchase summary, and then resubmit the form

I would like to update the workflow so that, upon completion of payment, payment confirmation is sent back to the site hosting the form to ensure the database is updated to indicate successful payment. If payment is cancelled, or perhaps does not occur after a timeout period, I would like to remove the entry for the user from the database.

Can anyone provide suggestions for how I should implement this workflow?
User 187934 Photo


Senior Advisor
20,181 posts

Hi KirK,
Are you altering your form manually after export with your current settings or are you strictly using the work flow the Form Builder provides?
I can't hear what I'm looking at.
It's easy to overlook something you're not looking for.

This is a site I built for my work.(RSD)
http://esmansgreenhouse.com
This is a site I built for use in my job.(HTML Editor)
https://pestlogbook.com
This is my personal site used for testing and as an easy way to share photos.(RLM imported to RSD)
https://ericrohloff.com
User 2869370 Photo


Registered User
15 posts

Hello Eric,

I have altered the form to include some PHP code that I created to track the availability of some of the events on the form. This is a registration form, with some of the activities allowing only a certain number of participants, so I'm tracking, via the database, the number of registrants signed up for those events and thus can display on the form the number of remaining positions.

Other than that, and changing the source (src) in the link I place in the index.html file to kick off the form, I've maintained the workflow provided by the software generated by Web Form Builder. I am however, amenable to other changes if required to allow the update to the database to be predicated on the confirmation of payment.
User 187934 Photo


Senior Advisor
20,181 posts

You'll need a Paypal API script. I thought I posted an example a few years back. I'll do a search and check it out.
I can't hear what I'm looking at.
It's easy to overlook something you're not looking for.

This is a site I built for my work.(RSD)
http://esmansgreenhouse.com
This is a site I built for use in my job.(HTML Editor)
https://pestlogbook.com
This is my personal site used for testing and as an easy way to share photos.(RLM imported to RSD)
https://ericrohloff.com
User 2869370 Photo


Registered User
15 posts

Thank you Eric. I believe I found that post, subsequent to creating my post. It had to do with PayPal IPNs, I believe. Is that the one you're thinking of?

Have something to add? We’d love to hear it!
You must have an account to participate. Please Sign In Here, then join the conversation.