JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
Where is the captured data located for multiple payment forms?Asked by fhpw on January 26, 2015 at 02:24 PM
This all works great. However, how is the data collected? Is it in multiple places? I am trying to collect reservations with PayPal and pay at door, plus condition with late fees. So, I have four iFrames in one form. It will be impossible to keep track of all our count if submissions go to multiple databases. Please advise. Thanks,
This is a re-post of a comment on How to Update the Multiple Payment Form
The data collected will be kept in your account and you will be able to see it in the Submissions screen. In your case, you'll need to check each payment form depending on the payment method selected by your submitters and enter to the corresponding submissions screen to see the entered data in the form.
For the sensitive information such as credit card numbers, this information is kept under the selected payment processor system which means that if a user selects Paypal the payment related information for this user will be kept on Paypal's servers and you'll be able to see it using your Paypal account.
Hope this answers your question.
Let us know if you have further questions.
Thanks for the reply. I know where the submissions are located, my question is when using iFrames as the work around for having PayPal option and Purchase Order and late pricing in one form - is the data captured in multiple databases? This will be extremely difficult to manage tracking total number of attendees to an event. Is JotForms working on a solution to have one form with different payment options so submissions are in one location.
AdobeFormsCentral has this capability. With Adobe Forms, you can HIDE/SHOW multiple payment fields in one form. Thus, there is only one submit button and all data is dumped into a single Excel Sheet.
I believe if you are using this tutorial on how to make multiple payment on a form, I believe all submissions will be stored in each form created.
But, we can do a workaround on it. If you would like to have all the submissions be in one excel sheet here's what I would do.
1. Integrate each form to a Google Spreadsheet, here's our app on that: http://apps.jotform.com/app/google_spreadsheets_integration.
2. Each form would have individual Spreadsheet, now where's the single sheet?
3. What we can do is create manually from our Google Drive our Master Spreadsheet, what we want to do is Integrate each spreadsheet to have one master list.
4. To do that we will use the ImportRange of Google Spreadsheet, here's the documentation on how to do that: https://support.google.com/docs/answer/3093340
We also have a couple of apps that might be of a help, hopefully. Here they are:
I hope this helps or at least gives you an idea on how to proceed.