+- Form Tools (https://forums.formtools.org)
+-- Forum: Form Tools (https://forums.formtools.org/forumdisplay.php?fid=1)
+--- Forum: General Discussion (https://forums.formtools.org/forumdisplay.php?fid=5)
+--- Thread: retrieve record ID into thankyou page (/showthread.php?tid=788)
retrieve record ID into thankyou page - rhaimson - Jul 21st, 2010
Hi All, Thanks in advance for any help you can offer.
I've an application that must accept donations via PayPal & and link it to a form sumbission that contains required info PayPal doesn't ask for. I've got the info on a Donations page, which stores a record in the MySQL database & then have the link to PayPal on the Thank You Page. I need to somehow link the PayPal donation to the data in the database from the prior form submission.
Is there a way for Form Tools to return the record ID from the submission to the Thank You page? I could then pass this on to PayPal via a hidden field such that I could link the donation on my PayPal statement with the first form submission. I've already spoken to PayPal & they've advised me as to which field to use on their end, so the key is for the Thank You page to be able to retrieve the record ID.
If it is possible, please be kind in that, although I have access to folks fluent in php, I'm completely ignorant of it myself, (although I am a programmer, so it isn't beyond me). Hopefully, any solution would include sample code, (if coding is necessary), and explain it at a newbie level. If anyone is already doing this or has a better idea of how to accomplish this, I'm all ears.
Thanks Again
RE: retrieve record ID into thankyou page - Ben - Jul 21st, 2010
Hi Rhaimson,
Sure! It depends on the method by which you're submitting the form contents to Form Tools - via the API or through a direct POST request to process.php - but either is pretty straightforward.
If you're using a POST request, just log into Form Tools, edit your form and go to the Fields tab. There, click the "Pass On" checkbox for the submission ID row. Then, whenever your form is submitted the submission ID will be tacked on via the query string like thanks.php?submission_id=X
If you're using the API, you need to do this manually. Let me know if you're doing that (doesn't sound like it) and I'll provide a few more pointers.
Hope this helps!
- Ben
RE: retrieve record ID into thankyou page - rhaimson - Jul 21st, 2010
Ben, That's awesome! Thanks so much. Silly me didn't catch that it was built into the application. As you said, I now get the submissionid on the query string, which I'll have no problem parsing & passing on to PayPal.
Thanks Again - This tool is Great!!!
(Jul 21st, 2010, 9:40 AM)Ben Wrote: Hi Rhaimson,
Sure! It depends on the method by which you're submitting the form contents to Form Tools - via the API or through a direct POST request to process.php - but either is pretty straightforward.
If you're using a POST request, just log into Form Tools, edit your form and go to the Fields tab. There, click the "Pass On" checkbox for the submission ID row. Then, whenever your form is submitted the submission ID will be tacked on via the query string like thanks.php?submission_id=X
If you're using the API, you need to do this manually. Let me know if you're doing that (doesn't sound like it) and I'll provide a few more pointers.
Hope this helps!
- Ben
RE: retrieve record ID into thankyou page - wakerider017 - Apr 15th, 2016
Newbie here.. Trying to use the Pass On feature to show the submission ID on the Thankyou page.
Not sure where to put the 'thanks.php?submission_id=X' line?
Tried the Thankyou page template and nothing happened. Any ideas? Thanks a bunch!
(Jul 21st, 2010, 9:40 AM)Ben Wrote: Hi Rhaimson,
Sure! It depends on the method by which you're submitting the form contents to Form Tools - via the API or through a direct POST request to process.php - but either is pretty straightforward.
If you're using a POST request, just log into Form Tools, edit your form and go to the Fields tab. There, click the "Pass On" checkbox for the submission ID row. Then, whenever your form is submitted the submission ID will be tacked on via the query string like thanks.php?submission_id=X
If you're using the API, you need to do this manually. Let me know if you're doing that (doesn't sound like it) and I'll provide a few more pointers.
Hope this helps!
- Ben
RE: retrieve record ID into thankyou page - wakerider017 - Apr 18th, 2016
Anyone?