- KhalidAsked on January 21, 2016 at 08:59 AM
the other problems I have is how to allow multiple submit of the forms (for more than one student) without the need to keep entering the same credit card information? Like can we save the total from student 1, then ask if there is student 2, then save the total till all students are done then fill out the credit card form and pass the total of all students into the payment section?
so student 1 will need to fill out how many slices per week he wants then find the total of slices for student 1
same for 2, 3, 4 and 5 if needed. Then use the total as quantity times the price of one slice in the payment section
I have the logic built in a google form, but i can't make calculations in the form and I can't pass the gran total to the payment section.
I have authorize.net and I have paypal
- CharlieAnswered on January 21, 2016 at 09:51 AM
This should be possible by dividing the section of the form with multiple student sections then use the conditional logic to display each section when the user wants to add another student.
Here's a sample form: https://form.jotform.com/60204010942944
Here's how I did mine:
1. I saw in your Google Form that you are using a table to get the number of slices per week. In my case, I will use the Matrix Field. We can assign calculation values on it by following this guide: http://www.jotform.com/help/343-How-to-perform-form-calculation-in-the-Matrix-field
2. The total price of the order of student 1 will be based from the number of slices he/she selected multiplied by $2, assuming that that's the price for each slice.
I will insert all the selected radio buttons on the matrix field, sum them up and multiply them by 2.
3. Now we have order for student 1. How do proceed on student two?
We will use a form collapse tool to hide/show the section of student 2. We will repeat the same setup on student 1 section, we'll have another matrix field and a form calculation widget exclusive for student 2.
Here's a guide on how to use the form collapse tool: http://www.jotform.com/help/297-Show-or-Hide-multiple-fields-at-once-using-form-collapse-tool
The form collapse tool will only be displayed when the condition:
IF "Add another student" is equal to "Yes" is met.
Please note that the question "Add another student?" for student 2 comes from student 1 section.
4. Now I will add a page break at the bottom part of student 2 section, I want the final total and the payment tool to be added on the next page.
The final form calculation widget will sum up all the final total on each student section.
5. The question is how do we pass the final total in our payment integration? That is possible by following this guide: http://www.jotform.com/help/275-How-to-pass-a-calculation-to-a-payment-field
I hope that helps. Do let us know if that works.
- kyaqoubAnswered on January 21, 2016 at 03:15 PM
Thank you so much for the quick response and very detailed solution. I learned a lot from your answer, it's been only couple of days for me on the site, your detailed answer came as hands on training.
I followed your example and was able to find answers to all my questions. I only have one issue, and it happens also on the form you created. When I hit the submit button, it does not submit the form, instead it returns error! I happens with and without a payment! You can try it on your own form and you will see that. Is it a field that Jotform mishandling?
- JotForm SupportMike_GAnswered on January 21, 2016 at 07:48 PM
I would like to apologize, however, I tried to submit my colleague's form and didn't get any error and was just redirected to the Thank-You page of the form. Since the Total Price field from the last page is not being passed yet to a payment field like PayPal. How-to-pass-a-calculation-to-a-payment-field
Once the value of that field is passed to the PayPal payment field, you will then be redirected to PayPal's page when you submit the form.
Note: I have received a message at the end of the screencast since firstname.lastname@example.org isn't a real PayPal account.
By the way, what's the error message you're getting when you submit the form?
If you can post a screenshot here in the forums, that will be great!
- kyaqoubAnswered on January 21, 2016 at 10:31 PM
Sorry my mistake seems my firewall at work was blocking the final step for some reason. I am trying it from home and it's working.
May I ask how did you get the lines above and below Student 1
Also what's the reason for using "stopper".
I did exact form as yours:
I set the total price $ as a hidden field to avoid displaying same info twice when populating the payment, but it still shows up on the form! can't the form calculate field be hidden?
- CharlieAnswered on January 22, 2016 at 03:08 AM
No worries, I'm glad that you are being more familiar with our form builder now :)
Regarding your follow up questions, the lines above and below of "Student 1" is a default if you are using the "Header" field.
The reason for using a form collapse stopper is to separate the last part of the form. If you add a form collapse tool it will cover everything at the bottom, so if you do not use a stopper, it will hide the submit button or everything below it. Example:
Everything below on form collapse 1 will be hidden
-Form Collapse 1
--- Student 1 form fields
--- Payment section
--- Submit button
To separate "Payment section" and the submit button on student 1, you need to use a form collapse tool and set it to visible and open. This is how it looks like then:
-Form Collapse 1
--- Student 1 form fields
-Form Collapse stopper
--- Payment section
--- Submit button
If you are referring to the "Form Calculation" widgets as total price for each student section, you can hide them by right clicking on them and setting "Hide Field". Calculations should still work even though they are hidden.
There seem to be also an error in your conditions. I would suggest fixing it to avoid further problems. You can open the conditions wizard to see the message.
If I may also suggest, I would strongly suggest using "Show" function instead of "Hide" in the conditions. You can also use a form collapse tool for "Student 1" to organize it better.
Here's how I setup mine:
Here's my cloned form: https://form.jotform.com/60210991981962. You can clone it to have a copy of it in your account. Here's a guide on how to clone a form: http://www.jotform.com/help/42-How-to-Clone-an-Existing-Form-from-a-URL
I hope that helps.
- kyaqoubAnswered on January 22, 2016 at 08:09 AM
Thank you so much. I like the idea of form collapse before showing student one and use it in the condition rather rather hiding all other fields.
One last thing left. Some weeks the school would be off,like spring break,winter break, Thanksgiving, Christmas. Is there a way to have a date condition that could hide that week from the matrix or make it read only, or set the value to ZERO regardless of number selected?
If that's not possible, I am afraid, I have to break up the matrix, and use regular drop boxes for each weak and put the date conditions there. But I really like the matrix, very simple and looks more professional.
I appreciate your input on this and thanks again for your support
- kyaqoubAnswered on January 22, 2016 at 08:21 AM
I also want to hide the "NEXT" button when form is not allowed. Right now it shows the NEXT button and takes me to submit button although nothing was filled out and nothing to pay for.
- CharlieAnswered on January 22, 2016 at 09:41 AM
Unfortunately, the condition can't hide specific columns of the matrix field as it works as one field only.
If you'll be separating each week by a radio button, you can assign calculation values on them by following this guide: http://www.jotform.com/help/301-How-to-Assign-Calculation-Value
You can also show/hide the "Next" button or the page break using conditions. Here's an example:
I set the first "Total Price" for Student 1 with a blank value on the "Default Result".
I then setup a conditional logic to identify that the page break will only be displayed if the "Total Price" of student 1 is filled out.
I hope that helps. If you need any assistance again, I would strongly suggest opening a new thread here in the forum :)