What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

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.


  • Profile Image

    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

    Submissions thanks count one form
  • Profile Image

    Answered by raul on January 26, 2015 at 04:42 PM

    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.
    Thank you.

  • Profile Image

    Answered by fhpw on January 27, 2015 at 10:33 PM

    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.

    Thanks,

     

  • Profile Image
    JotForm Support

    Answered by Charlie on January 28, 2015 at 08:47 AM

    Hi,

    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:

    http://apps.jotform.com/app/combine_submissions 

    http://apps.jotform.com/app/submission_view 

    I hope this helps or at least gives you an idea on how to proceed.

    Kind regards.