Calculation on card forms

  • Profile Image
    tbtimburke3
    Asked on June 25, 2019 at 11:53 AM

    Good morning,


    I am looking to create an electronic version of the attached grid. The grid would allow patrons to enter a numerical value in the column marked "# TICKETS". I've tried looking through the standard Jotform options as well as the widgets and haven't been able to reproduce this. Any help is appreciated.

    Screenshot
  • Profile Image
    Richie_P
    Answered on June 25, 2019 at 12:44 PM

    Unfortunately, we cannot view the screenshot your have shared.

    Kindly follow this guide in posting screenshots:How-to-add-screenshots-images-to-questions-to-the-support-forum

    May we know if you have tired using the Input table?

    You may change the field into numeric textbox.

    You can also add calculation to the table.

    Here is a guide:https://www.jotform.com/help/343-How-to-Perform-Form-Calculation-in-the-Matrix-Field


    Please give it a try and let us know if this fits your requirements.

  • Profile Image
    tbtimburke3
    Answered on June 25, 2019 at 01:43 PM
    Helpful but what I’m looking for is two columns under each header—one that allows patrons to enter a numerical value while the other column refers to a price. One static column with values while the other is a variable column where a patron enters a number. Does that make sense?
    ...
  • Profile Image
    Richie_P
    Answered on June 25, 2019 at 02:21 PM

    Unfortunately, we cannot add a static field with the Input table.

    You may try the Spreadsheet widget.

    https://www.jotform.com/help/442-How-to-Use-the-Spreadsheet-to-Form-Widget

    Please give it a try and let us know if this fits your requirements.

  • Profile Image
    tbtimburke3
    Answered on June 25, 2019 at 03:43 PM
    I don’t believe any of those widgets are customizable enough. Is it possible for you to take a look at the form I currently have in place and for me to describe what I’m lacking?
    ...
  • Profile Image
    Richie_P
    Answered on June 25, 2019 at 05:10 PM

    I have checked your form and it seems you're using the input table.

    Unfortunately, you can only add calculation values to your input table.

    Here is a guide:https://www.jotform.com/help/343-How-to-Perform-Form-Calculation-in-the-Matrix-Field

    May we know if would you like to get the quantity of tickets?

    You may try the inventory widget and the form calculation widget.

    You will get the total of the inventory widget using the form calculation widget.

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




  • Profile Image
    tbtimburke3
    Answered on June 28, 2019 at 11:43 AM
    This is helpful. However I am running into an issue. I have ten possible dropdown slides in which people can enter information and I want to tabulate totals from these at the end. For some reason my formula is not calculating empty slides as “zero” even though I have entered that as an option for a blank entry. Because of this, my total at the end is inflated. Thoughts?
    ...
  • Profile Image
    Richie_P
    Answered on June 28, 2019 at 12:00 PM

    I have checked your form and kindly remove the $ sign in your calculation values if you want to calculate the total.

    You may add the $ sign in the form calculation widget.

    Please give it a try and let us know if you need further assistance.,

  • Profile Image
    tbtimburke3
    Answered on June 28, 2019 at 01:43 PM
    I’ve made that change but the problem continues. If someone only chooses/fills 6 of the 10 slides, I want the other 4 to calculate at 0. This isn’t happening. Is there another way to make these slides calculate to 0?
    ...
  • Profile Image
    Richie_P
    Answered on June 28, 2019 at 02:14 PM

    To clarify, if a dropdown question is empty, you want to have its value to be 0?

    Can you please share to us the flow of your form?

    You may use conditions to assign a value to your field, however this will create a conflict with your assigned value.

    To be able to this, you would need to add another field to hold the value when the field is empty.

    Then you add the field calculation to your total.

    Here is a sample form you can check:https://form.jotform.com/91785128919976


    Please give it a try and let us know if you have further questions.

  • Profile Image
    tbtimburke3
    Answered on July 01, 2019 at 10:43 AM
    Yes please take a look: 2019-20 Van Wezel Package Subscription Form is the name of my form.
    Couple things:
    1) I tried the method from your previous email to leave a zero-value cell in the values for my shows that aren’t chosen from the form but it still calculates as if those have a value in them.
    2) I’ve tried setting up conditions to hide a cell titled “Where do you want to sit? - E2M6” when other selections are chosen, however that cell still appears when “Full Classical” is chosen under “What package are you looking to purchase?” Is chosen. Is there something else set incorrectly here?
    ...
  • Profile Image
    Richie_P
    Answered on July 01, 2019 at 12:17 PM

    I have checked your form and it seems you're assigning your conditional value to your total calculation.

    Kindly try assigning each calculation condition to a field.

    Example: You add a short text entry/or form calculation widget to hold the value for your question 24.

    15619974861.gif

    Then update your condition to add the value to your field.

    You would have to create another short text/Form calculation widget for each question and assign them.

    Then add the fields with the calculation values to your Total Form Calculation widget.


    Please give it a try and let us know if you need further assistance.

  • Profile Image
    tbtimburke3
    Answered on July 01, 2019 at 02:43 PM
    Ok, thanks. I’m trying this setup, however can you let me know if I’m heading in the right direction?
    Currently I am multiplying each show total by the calculated “zero” total, with the thought that if cells are filled, the “zero” cells will be moot. No totals appear in my final cell with the grand calculation. Can you take a look?
    ...
  • Profile Image
    Richie_P
    Answered on July 01, 2019 at 04:04 PM

    I have checked your form and it seems there is an issue with your total form calculation. I would suggest you slowly add/multiple your fields to avoid confusion with your formula.

    However,multiplying a value of 0 will always return a 0 value. Can you please give us more information in how you would like your form calculation to work?

    Do you want to multiple the number of packages?

    Looking forward for your response.

  • Profile Image
    tbtimburke3
    Answered on July 01, 2019 at 04:43 PM
    Thank you for your quick reply. Here is a step-by-step process of how I
    would like the form to work:
    1) Person chooses a numerical value in "How many packages are you looking
    to purchase? - 6" (slide #13).
    2) Person then chooses the performances they want to purchase (slide #16),
    activating the opportunity to choose their seating for each respective
    performance.
    3) Patron chooses where they want to sit for each performance, with each
    selection representing a monetary value (slides
    #24/26/28/30/32/34/36/38/40/42). These slides are ONLY activated if
    choosing the respective performance in slide 16.
    4) If patron does *not* choose a performance and activate the opportunity
    to choose seating, I would like for that slide's value to be equal to zero
    (slides #25/27/29/31/33/35/37/39/41/43).
    5) Slide entitled "Make-Your-Own 6+ - Total $" should calculate the total
    of all slides.
    --Number of packages * seating location should equal the $ for each
    show.
    --If a show is not chosen by the customer, it should be equal to a
    zero dollar value.
    --When added all together, total should equal the overall value of the
    order.
    Currently I am multiplying the first two lines above for each show and then
    adding each show together, with the thought that if there is a positive
    value for each show, the zero would not automatically go into the zero
    slide (25/27/29 etc.).
    Any more insight on what I can do would be greatly appreciated.
    ...
  • Profile Image
    JohnRex
    Answered on July 01, 2019 at 06:08 PM

    Thank you for the additional information that you provided.

    I have a few suggestions in mind, but let me have some time to test it with your form.

    I will get back to you on this thread shortly.

  • Profile Image
    JohnRex
    Answered on July 02, 2019 at 01:15 AM

    Hi again,

    As requested, here's my insights:

    I did a few tests about the form, and as I observed, all other options are working except these two fields:

    1562041415make your.PNG

    15620437634to5.png

    I can see that you created container fields to contain 0 values. My suggestion is that instead of using that as container for  values, why not make it as a container for the multiplication formulas (No of package X Preferred seat). In that way, we could simplify the formula in the Make-Your-Own 6+ - Total $ field.

    Here's a sample formula for container field EM26:

    1562044077em26.PNG

    We'll use the same formula to the other container fields. Then upon submission, we'll sum it up in the Make-Your-Own 6+ - Total $ field:

    1562044163sumitup.PNG

    Here's the result:

    1562044471van wezel.gif

    Also, here's a link to the cloned form. Feel free to clone and inspect it:

    https://form.jotform.com/91816537862972

     

  • Profile Image
    JohnRex
    Answered on July 02, 2019 at 01:21 AM

    I forgot to mention about the "4-5 package" option. I wasn't able to picture out a scenario for this one. Could you share us also the transactions for this package? Like what to show, what to compute and etc. Because I presume, this can be done using 6+ package alone.

  • Profile Image
    tbtimburke3
    Answered on July 02, 2019 at 09:43 AM
    That is a placeholder for now but it will mimic the 6+ package. Nothing to look at for now.
    ...
  • Profile Image
    tbtimburke3
    Answered on July 02, 2019 at 09:43 AM
    Great idea on simplifying the formulas and the 0 placeholder slides. I've
    replicated your suggestions and this is all working. I will replicate for
    the 4-5 show setup.
    Question for going forward--with the different payment widget options, are
    there any that will save a card and allow me to access it securely at a
    later date, without running payment initially?

    ...
  • Profile Image
    AndrewHag
    Answered on July 02, 2019 at 11:02 AM

    To assist you better, I am moving this question to a different thread. Please follow this link: https://www.jotform.com/answers/1877419