How to enable calculation in payment form?

  • Profile Image
    miadarling
    Asked on January 01, 2018 at 03:10 AM
    Apologies for the delayed response. Please respond promptly. Is it possible
    to add eCommerce to each of these dropdown fields so that when all of them
    are selected across the bar, the "submit" button enables the client to
    actually link to pay for the service selected from the dropdowns? Also,
    could a percentage discount be applied in the calculation where repeat
    visits redeem a reduced price? For example, if they book the service
    monthly there's a 5% discount in the calculation, bimonthly in 10%, weekly
    20%, and then packages of all four is 15% off?
  • Profile Image
    ashwin_d
    Answered on January 01, 2018 at 03:31 AM

    Yes it is possible to achieve your requirement by taking advantage of our "Calculation Values" feature. You can also pass the calculated value to your payment field as well. You may like to take a look at the following guides which should help you:  

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

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

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

    Hope this helps.

    Do try it out and get back to us if you have any questions. 

  • Profile Image
    Mia
    Answered on January 01, 2018 at 05:05 PM

    I need the Standard, Signature, and Deep Clean dropdown options to be conditionals. So when the user selects Standard and then 1 bedroom, this adds $10 versus when they select Signature and then 1 bedroom, this adds $20. So everything is dependent on if they select Standard, Signature, or Deep Clean. And then, on top of that, if reserving the service as Monthly it is 5% off, Bi Monthly 10% off, and Weekly 20% off.


    Please SHOW me how to do this and create a form like this for me to clone. I have seen the links provided and tried but I am very confused and don't know how to put it together. I started with this here: https://form.jotformz.com/80006013093643.


    Please see attached document with the mathematical pattern that needs to be applied for all dropdowns and conditionals.

    https://www.dropbox.com/s/8riktcb4s94ckls/Gregoria_Pricing%20Mathmatical%20Pattern.docx?dl=0

  • Profile Image
    BDAVID
    Answered on January 01, 2018 at 06:16 PM

    You would need to assign the values to the dropdown options: https://www.jotform.com/help/301-How-to-Assign-Calculation-Value 

    And perform the calculation using a Form Calculation widget: https://www.jotform.com/help/259-How-to-Perform-Form-Calculation-Using-a-Widget 

  • Profile Image
    miadarling
    Answered on January 01, 2018 at 08:43 PM
    Yes, I know this. I need an example for the first two combinations to clone
    please. Please add to the jotform that I created with this per the attached
    Dropbox document in last message:
    - Standard + 1 Bedroom + 1 Bathroom + Monthly
    - Standard + 2 Bedrooms + 2 Bathrooms + Bi Monthly
    - Signature + 1 Bedroom + 1 Bathroom + Monthly
    - Signature + 2 Bedrooms + 2 Bathrooms + Bi Monthly
    ...
  • Profile Image
    liyam
    Answered on January 02, 2018 at 12:33 AM

    On your calculation, there is an extra + sign on the last part of the formula. This causes the calculation to malfunction. As the formula would appear (Field1 + Field2 + Field3 +).

    15148711412018-01-02_1330.png

    What you need to do is just remove the last plus sign and your form should work fine.

    If you have additional questions, please let us know.


  • Profile Image
    gregoria
    Answered on January 02, 2018 at 01:20 PM

    I have removed the plus sign: https://form.jotformz.com/80006013093643.


    But this doesn't do what I've asked for it to do. I need you to add just the first two combinations here for me from the form that I've created. Also, why does it say "Booking Form 10790" in the calculation widget field? The amount isn't 10790 and it shouldn't say the text "Booking Form" there anyway - only numbers.


    Please do the following from this form per the attached Dropbox document in earlier message:


    Standard + 1 Bedroom + 1 Bathroom + Monthly

    Standard + 2 Bedrooms + 2 Bathrooms + Bi Monthly

    Signature + 1 Bedroom + 1 Bathroom + Monthly

    Signature + 2 Bedrooms + 2 Bathrooms + Bi Monthly

  • Profile Image
    miadarling
    Answered on January 02, 2018 at 01:43 PM
    I have removed the plus sign: https://form.jotformz.com/80006013093643. But
    this doesn't do what I've asked for it to do. I need you to add just the
    first two combinations here for me from the form that I've created. Also,
    why does it say "Booking Form 10790" in the calculation widget field? The
    amount isn't 10790 and it shouldn't say the text "Booking Form" there
    anyway - only numbers. Please do the following from this form per the
    attached Dropbox document in earlier message:
    Standard + 1 Bedroom + 1 Bathroom + Monthly
    Standard + 2 Bedrooms + 2 Bathrooms + Bi Monthly
    Signature + 1 Bedroom + 1 Bathroom + Monthly
    Signature + 2 Bedrooms + 2 Bathrooms + Bi Monthly
    ...
  • Profile Image
    liyam
    Answered on January 02, 2018 at 03:08 PM

    I'm trying to analyze to simplify the table from the Dropbox document. But there is a missing part on which I am not able to understand. Please correct me if I am not understanding these:

    Standard1 (1TB) --- every bedroom costs $10, every bathroom costs $10

    Standard2 (2TB) --- every bedroom costs $20, every additional bathroom costs $20


    On the other parts of the table, I'm at a loss on how it should compute the standard for $30, then the one for $50. I'm thinking there is a base rate. Are these the base amout for each?

    1. For the $30, the base rate is 147
    2. For the $50, the base rate is 227


    If I am missing something here, please let us know.

    Thanks.

    f 2

  • Profile Image
    BDAVID
    Answered on January 02, 2018 at 05:50 PM

    We apologize for the delay. Please note that we can guide you on how to build a form, however, building a complex solution goes beyond our main scope due to the high amount of questions we handled every day.

    That is the reason why it is hard for us to fully focus on the the mathematical pattern that needs to be applied in your form. So, my recommendation would be to hire a programmer to expedite the process. 

    Meanwhile, I have corrected what you have so far, basically you are operating the fields as String values:

    1514931791THIS_001.png

    Please click on the "brown" box to make it "black", which indicates that it is operated as a number:

    1514931888black.png

    Now for the discount, you could add a new Form Calculation widget that you can hide, in order to obtain the total discount:

    1514932301discount_001.png


    Then you could perform the calculation through conditions: https://www.jotform.com/help/268-How-to-Insert-Text-or-Calculation-into-a-Field-Using-Conditional-Logic 

    1) 

    1514933237one.png

    2)

    1514933254two.png

    3)

    1514933268three.png

    Finally, add a new Form Calculation field to get the "Total - Discount":

    1514933371total_001.png

    Here is my form example: https://form.jotform.com/80017087426959 

  • Profile Image
    liyam
    Answered on January 03, 2018 at 12:51 AM

    I think a better approach here would be creating different set of fields for different categories.

    Example:

    you create a first field which allows the user to select these options:

    - Standard 
    - Signature
    - Deep Clean

    Then for each selection there you create your group of dropdown fields. for each selection above. Example:

    For Standard you have:
    - Studio/Bedroom dropdown field 1
    - Bathroom field 1

    For Signature you have:
    - Studio/Bedroom dropdown field 2
    - Bathroom field 2

    For Deep Clean you have:
    - Studio/Bedroom dropdown field 3
    - Bathroom field 3

    This way, you are able to set your specific values for $10 for Standard, $20 for Signature, $30 for Deep Clean.

    Then lastly, a single field that handles the computation for monthly since the 5%, 10% and 20% appears to be a static rate for all options.

    If you need clarification on this, please let us know.

  • Profile Image
    miadarling
    Answered on January 03, 2018 at 07:43 AM
    Okay, yes this makes sense. And the frequency discount dropdown would be on
    the end of the bar as the last dropdown for each one?
    Does this mean that each set would be in its own row stacked on top of each
    other on the form? If so, is it possible to tighten the space gap
    significantly between the rows? Or could we add the Configurable List
    widget (https://widgets.jotform.com/widget/configurable_list) with the
    calculation widgets and eCommerce payment widgets inside of it, since this
    has the sleeker design layout I’d be looking for if we add rows to the
    form. The space between the rows is much shorter and nicer in the
    Configurable List widget.
    Or, would it make sense to add page breaks in the form instead of rows to
    keep the slender bar look? However the concern would be that the user can’t
    see that there other the other options of Signature and Deep Clean until
    they would click for the next page on the form.
    ...
  • Profile Image
    ashwin_d
    Answered on January 03, 2018 at 09:30 AM

    And the frequency discount dropdown would be on the end of the bar as the last dropdown for each one?

    Yes you can do that to calculate the amount or add discount on the price based on the frequency.


    Does this mean that each set would be in its own row stacked on top of each other on the form? If so, is it possible to tighten the space gap significantly between the rows?

    That depends on how you want the form fields to be placed. Yes we can align the form fields and remove gaps by injecting custom css code. Please let us know how you want the form fields to be placed after your form is built and we will help you with the required custom css code. 


     Or could we add the Configurable List widget https://widgets.jotform.com/widget/configurable_list) with the calculation widgets and eCommerce payment widgets inside of it

    Unfortunately no. It is not possible to add payment fields or calculation fields inside configurable list widget. It is not possible to add calculation in configurable list widget. 


    Or, would it make sense to add page breaks in the form instead of rows to keep the slender bar look? However the concern would be that the user can’t see that there other the other options of Signature and Deep Clean until they would click for the next page on the form.

    Yes if you add page break field in form, all the pages will be displayed separately and will be visible on the click of next button. Alternatively, you can also add "Form Tabs" widget in your form which will display a menu header to users. 

    Hope this helps.

    Do get back to us if you have any questions.

  • Profile Image
    miadarling
    Answered on January 03, 2018 at 10:43 AM
    Thank you! I’ll check this out and get back to you. Also - Once the user
    submits the form, what do they see to submit their payment? Does a much
    larger window appear, and if so, how would this look for the iFrame itself?
    I can’t have arrows in the iFrame itself appear and it can’t take up a lot
    of space since it’ll be added on a small spot of the homepage of a website.
    ...
  • Profile Image
    liyam
    Answered on January 03, 2018 at 11:37 AM

    Other than the option of showing them lined-up per row, how about using a show/hide condition on your form? This will keep your form to show just one line. This is because it will only show or make visible a set that have been selected by the form user.

    This guide on using the show/hide condition will give you a better idea on how you can use it on your form: https://www.jotform.com/help/316-How-to-Show-or-Hide-Fields-Base-on-User-s-Answer

    With regard to the Thank you page, I recommend using a Thank you URL instead for you to be able to fully control the contents. Although you should be able to control the contents as well on a built-in thank you page on your form in order to limit the area of what appears. 

    You can check out these guides for more information: 

    https://www.jotform.com/help/211-Setting-up-the-Thank-You-Page

    https://www.jotform.com/help/38-Redirecting-Users-to-a-Different-Page

    In any case, feel free to build your form and we'll assist you through the process.

    Thanks.