-
SMDCAsked on January 15, 2015 at 10:22 AM
I want to set up a form where most users will need to submit payment; however, there will be clients that we will want to complimentary register but still have them in our reports at the closing of the event. Is there a way to do this in the same form? I have not created a form yet so I cannot provide the URL.
-
CharlieReplied on January 15, 2015 at 11:36 AM
Hi,
I'm not sure if this would, but you could try adding a "Free" product that will act like a complimentary one.
You can do that by:
1. Adding a Payment Method under the Payment Tools section.
2. Inside the Payment Wizard, you can select product, subscription or donation. In my case I'll add products.
3. I'll add one product that will have a value of $0, which means it's free.
You can check this demo form: http://www.jotform.com/form/50144644090953
I hope this helps or at least gives you an idea on how to proceed. Let us know if you need more assistance on this.
Thank you.
-
SMDCReplied on January 15, 2015 at 11:53 AM
I don't want the public to see this option. I want to enter the submission myself so that it will be in the report. Is there a way to do that privately?
-
CharlieReplied on January 15, 2015 at 12:08 PM
I'm not sure if that is possible in one form, especially if you'll be integrating a Payment Method. What I could recommend is that you create another form for those complimentary registration so that you can add them privately. You can have two forms, Form 1 would be with payment while Form 2 will be for complimentary. If you already created the main form you can then just clone it and remove the payment instead, no need to re-create the whole form. You can check this guide on how to clone the main form: http://www.jotform.com/help/27-How-to-clone-an-existing-form-from-your-account
I hope this helps.
Thank you.
-
SMDCReplied on January 15, 2015 at 12:15 PM
That does help and I see the value of that response. However, does that mean I would need to enter those submissions manually into the excel spreadsheet in order to merge them?
Thank you.
-
CharlieReplied on January 15, 2015 at 12:40 PM
Unfortunately, I believe that is not possible. If you are integrating Google Spreadsheet to your form you'll create a NEW spreadsheet dedicated to that specific form.
So, in that case, you'll have a separate spreadsheet for Form 1 and another for Form 2. But, you can use functions to merge them and have a main spreadsheet or master list. I'm not that familiar with all the functions of Google Spreadsheet but I believe the ImportRange would work. You can check more about it here: https://support.google.com/docs/answer/3093340?hl=en&rd=1
Thank you.
-
SMDCReplied on January 16, 2015 at 10:48 AM
Thank you! Your responses were helpful!
-
CharlieReplied on January 16, 2015 at 11:26 AM
You're welcome.
I'm glad I could be of a help. If you need any assistance again or have other concerns, please feel free to open up a new thread here in the forum.
Thank you.