Calculation on card forms

  • 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.

    Jotform Thread 1869520 Screenshot
  • Richie JotForm Support
    Replied 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.

    Calculation on card forms Image 1 Screenshot 20

    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.

  • tbtimburke3
    Replied on June 25, 2019 at 1: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?
    ...
  • Richie JotForm Support
    Replied on June 25, 2019 at 2: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.

  • tbtimburke3
    Replied on June 25, 2019 at 3: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?
    ...
  • Richie JotForm Support
    Replied on June 25, 2019 at 5: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




  • tbtimburke3
    Replied 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?
    ...
  • Richie JotForm Support
    Replied 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.

    Calculation on card forms Image 1 Screenshot 30

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

    Calculation on card forms Image 2 Screenshot 41

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

  • tbtimburke3
    Replied on June 28, 2019 at 1: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?
    ...
  • Richie JotForm Support
    Replied on June 28, 2019 at 2: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.

    Calculation on card forms Image 1 Screenshot 30

    Then you add the field calculation to your total.

    Calculation on card forms Image 2 Screenshot 41

    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.

  • tbtimburke3
    Replied on July 1, 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?
    ...
  • Richie JotForm Support
    Replied on July 1, 2019 at 12:17 PM

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

    Calculation on card forms Image 1 Screenshot 50

    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.

    Calculation on card forms Image 61

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

    Calculation on card forms Image 2 Screenshot 72

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

    Calculation on card forms Image 3 Screenshot 83

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

    Calculation on card forms Image 4 Screenshot 94


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

  • tbtimburke3
    Replied on July 1, 2019 at 2: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?
    ...
  • Richie JotForm Support
    Replied on July 1, 2019 at 4: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.

  • tbtimburke3
    Replied on July 1, 2019 at 4: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.
    ...
  • John Support Team Lead
    Replied on July 1, 2019 at 6: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.

  • John Support Team Lead
    Replied on July 2, 2019 at 1: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 Screenshot 10

    15620437634to5 Screenshot 21

    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 Screenshot 32

    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 Screenshot 43

    Here's the result:

    1562044471van wezel Screenshot 54

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

    https://form.jotform.com/91816537862972

     

  • John Support Team Lead
    Replied on July 2, 2019 at 1: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.

  • tbtimburke3
    Replied on July 2, 2019 at 9:43 AM
    That is a placeholder for now but it will mimic the 6+ package. Nothing to look at for now.
    ...
  • tbtimburke3
    Replied on July 2, 2019 at 9: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?

    ...
  • AndrewHag
    Replied on July 2, 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