How to transfer info from PayPal success to existing dbase

I'm new to Chronoforms and need some help. I'm trying to make a registration package. I can make a form, save the fields to a dbase, (send emails, etc.) Then I can redirect the user to a Paypal button with the amount, first_name, etc all auto-filled. What I can't do feedback success (or failure) to the dbase so the website can confirm the registration and update the dbase. I can direct PayPal success to a new chronoform, when I try to make it update the dbase on loading, a new record is created, with a new user, empty fields. Help!

Andrew

Hi Andrew,

Which ChronoForms actions are you using to link to PayPal?

Bob

Bob,

Thanks for the quick response. I'm using ReDirect URL followed by ReDirect User. ReDirect User is blank, and ReDirect URL contains:

https://www.paypal.com/cgi-bin/webscr ?method=post

cmd=_s-xclick
amount={amount}
first_name={first_name}
last_name={last_name}
hosted_button_id=12456ABCDE

Hi Andrew,

I think that I'm right in saying that if you use a basic PayPal account with a ReDirect URL then there is no Success information passed back by PayPal. You can set an Cancel URL and a Return URL (which may be included in your hosted button) but you can't be sure that the Return URL will be used - the user could just close the window and go somewhere else. In this case you have to rely on the PayPal email to tell you if the transaction succeeded.

If you use one of the more advanced PayPal options - like IPN (Instant Payment Notification), PDT (Payment Data Transfer), Express CheckOut or another API - then you can get immediate payment information but it gets more complex to set up.

Bob