Review Form and Update Invoice Prior...

User 2869370 Photo


Registered User
15 posts

I created a form using Web Form Builder and am hosting it on my own site to allow me to execute some PHP code to provide dynamic content. Specifically, my form is a convention registration page. In addition to allowing the user to register for the convention, it allows them to choose from various additional activities, some of which require a fee be paid. However, each activity has limited availability, i.e., only a limited number of persons is allowed to participate in any given activity. If there aren't positions available for a registrant to attend a particular activity, I would like to automatically add them to a wait list, and reflect on their order summary/invoice that they are wait-listed and will not be charged the fee until such time as they may be admitted into the activity.

To accomplish this, I think I need to intercept the form after it has been submitted, review the database to determine whether or not space is available in the specified activity, and either confirm they can attend that activity and charge them accordingly or, if no space is available, indicate on the order summary that they have been placed on a wait list and are not being charged the fee. Does this seem like the right approach? If not, does anyone have other suggestions? And, if so, how do I implement this capability? I've explored the code Web Form Builder provides to process the form, but I have not determined how to intercept the form after submittal but before sending it on to PayPal. And, once intercepted and verified/updated, how do I then continue the process of sending the registrant to PayPal's site to make payment?
User 2869370 Photo


Registered User
15 posts

Eric Rohloff wrote:
I cut mine down to a simpler form. It will set an item_sold to 1 in a database and send the customer a thank you email.
You then use a mysql query on your page with the item for sale to check the value in the database and set the proper display properties.
I didn't have time to test it but it's setup with error logging to help with any issues.
https://ericrohloff.com/coffeecup/ccfor … xample.zip


I found this in a post dated March 20, 2015. But, it appears the zip file is no longer available on your site. Would you be able to make it available again?
User 187934 Photo


Senior Advisor
20,181 posts

The zip file downloads for me.
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 2699991 Photo


Registered User
4,782 posts
Online Now

Eric Rohloff wrote:
The zip file downloads for me.


and downloads ok here in Indonesia
Mastering The Understanding With Hands-On Learning
NEW TO "COFFEECUP SITE DESIGNER" FOUNDATION 6 FRAMEWORK?
STUCK ON SOMETHING?

LEARNING & UNDERSTANDING "THE HOW TO"? THE WHY'S & THE WHEREFORE'S?
WITH WAYAN'S STEP BY STEP TUTORIALS
Contact Me For One To One Assistance
https://alphathemes.coffeecup.com/forms … an%281%29/
User 379556 Photo


Registered User
1,533 posts

It downloads for me too. I'm wondering whether some browser or security software prevents downloading unless the 'http://' is replaced by 'https://'.

Frank
User 2869370 Photo


Registered User
15 posts

Thank you. I’m not sure what happened when I tried this Tuesday, but I am now able to download the file. Attribute it to user error. ????
User 283347 Photo


Registered User
388 posts

For the record...I could not download it the other day either... it simply refreshed the page when clicking...but since then (maybe Wednesday?) It down loads ...must have been a server hiccup that was fixed.

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.