Calculate total from my 3 forms (more in the future) into another "check out" form

  • zapin
    Asked on December 12, 2017 at 1:21 PM

    I would really like to make it, so it will be possible to order from each of my forms, and then check out only ones, with everything ordered from all forms (or only from one form, if customer only needs that). As it is now, you have to submit the order on each form, what I´m hoping for, is to make a "total" form, where the total from each form is passed to, and also other relevant shipping info, like date and time (can be different from form to form), and then the customer can check out from the "total" form once for all, where total ammount and date info is avaible.

    I´ve asked this earlier, and learned a little about how to automatically pass form data to another form, but I must admit, that I really don`t know how to get started on this problem, and if this is the right approach to it, and I tried to read the "manual" for it, but guess my skills aren`t there yet to make that happen :) so I hope you`re able to help me with this problem ?

  • David JotForm Support
    Replied on December 12, 2017 at 1:58 PM

    Is there a reason that each form needs to be separate?  You could make the form multiple pages with each section on a separate page:

    https://www.jotform.com/help/119-How-to-Create-Multi-Page-Forms

    Pages can be hidden or skipped conditionally:

    https://www.jotform.com/help/350-How-to-Skip-Pages-Using-Conditional-Logic

    You can assign calculation values to options:

    https://www.jotform.com/help/301-How-to-Assign-Calculation-Value

    And get totals for each page using a calculation field:

    https://www.jotform.com/help/259-How-to-Perform-Form-Calculation-Using-a-Widget

    You can then pass a grand total to the payment field at the end:

    https://www.jotform.com/help/275-How-to-Pass-a-Calculation-to-a-Payment-Field

    This would be much easier than trying to pass data between multiple forms.

  • zapin
    Replied on December 12, 2017 at 2:39 PM

    Ok, a few questions before I jump into that, and really not sure I understand alot of it, but at first some questions.

    On my site today, you choose which form to go to from front page, or from menu on the different pages (it goes to the wanted page/form at diffent url adresses today), is that still possible if I make the form as one and break it up ? Want the user to be able to navigate from the site, and not from the form.

    Will it give problems shoving on mobile devices, been strugling really hard to get this to work already, so would prefer not to mess that up again :)

    Can I embed my present forms into one, or do I have to create a new form for that ?

    The calculation part I really don`t get how to set up, but I need to transfer the grand total to the payment field from each form/page, and as you descripe that seems to be possible, but I also need for the customer to be able to choose different dates and time on each form/page, and sent this as well along with the grand total in the payment field ?

    Hope the above makes sense.







  • David JotForm Support
    Replied on December 12, 2017 at 3:10 PM

    On my site today, you choose which form to go to from front page, or from menu on the different pages (it goes to the wanted page/form at diffent url adresses today), is that still possible if I make the form as one and break it up ? Want the user to be able to navigate from the site, and not from the form.

    If you want to skip to a specific page in a form, you can add ?jumpToPage=5 to the end of the URL.  For example:

    https://form.jotform.com/72897152252966?jumpToPage=18

    Jumps to page 18 of that form.

    https://form.jotform.com/72897152252966?jumpToPage=14

    Jumps to page 14 of that form.

    So you could have one link go to page 3, one go to page 4 etc, instead of one link to form 3 and one link to form 4.

    Will it give problems shoving on mobile devices, been strugling really hard to get this to work already, so would prefer not to mess that up again :)

    It would redoing the way the form is set up and much of the current formatting would not apply to the new setup.  Redoing the products would also take quite some time since there are so many.

    Can I embed my present forms into one, or do I have to create a new form for that ?

    For the setup I suggested, it would require creating a new form.

    The calculation would be based on newly set up fields.  Each product would need to be set up using fields like number fields, single/multiple choice, short text etc.  You can then perform calculations on the values assigned to or entered in those fields using a calculation widget:

    https://www.jotform.com/help/259-How-to-Perform-Form-Calculation-Using-a-Widget

    The method I described would take quite a bit of different set up than you current forms.  But is the only way I can think of to allow for using the forms in the way you are looking for.  Trying to keep a running total between forms using separate payment fields would end up being rather confusing.

    In the end, either set up is likely going to be fairly complex to set up.


  • zapin
    Replied on December 12, 2017 at 3:22 PM

    Ok, I´ll never get that to work correctly I think.

    Is there no way to send the total from each of my present forms into another check out form page with the grand total added ?

    For me that sounds to be way easier, then having to change all my forms and setup as it is now.

  • Kevin Support Team Lead
    Replied on December 12, 2017 at 4:44 PM

    Yes, it's possible to have the data sent to another form, please check this guide that will help you passing the submitted information over to another form:  https://www.jotform.com/help/351-How-to-Automatically-Pass-Form-Data-to-Another-Form 

    I hope this helps. 

  • zapin
    Replied on December 14, 2017 at 1:26 PM

    I can`t seem to move my grand total data from my Form 1 over and into my Form 2 ?

  • David JotForm Support
    Replied on December 14, 2017 at 2:54 PM

    The easiest way to do this would be to pass the total from the payment field to a number field or short text entry field using a condition:

    1513280997Capture Screenshot 10

    Then use that value to populate a number field field in the second form.  It would not be possible to pass the value to the payment field of the second form if the payment field has products.  Adding the total of the products from the first payment field to the total of the products in the second payment field would not work since you can only either set up products or pass a value to the payment field, not both.

    For that, you would need to use the setup I described in my original post.  The one with products set up outside the payment field.