-
tbtimburke3Asked 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.
-
Richie JotForm SupportReplied 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.
-
tbtimburke3Replied on June 25, 2019 at 1:43 PMHelpful 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 SupportReplied 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.
-
tbtimburke3Replied on June 25, 2019 at 3:43 PMI 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 SupportReplied 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
-
tbtimburke3Replied on June 28, 2019 at 11:43 AMThis 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 SupportReplied 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.,
-
tbtimburke3Replied on June 28, 2019 at 1:43 PMI’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 SupportReplied 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.
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.
-
tbtimburke3Replied on July 1, 2019 at 10:43 AMYes 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 SupportReplied 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.
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.
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.
-
tbtimburke3Replied on July 1, 2019 at 2:43 PMOk, 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 SupportReplied 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.
-
tbtimburke3Replied on July 1, 2019 at 4:43 PMThank 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 LeadReplied 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 LeadReplied 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:
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:
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:
Here's the result:
Also, here's a link to the cloned form. Feel free to clone and inspect it:
https://form.jotform.com/91816537862972
-
John Support Team LeadReplied 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.
-
tbtimburke3Replied on July 2, 2019 at 9:43 AMThat is a placeholder for now but it will mimic the 6+ package. Nothing to look at for now.
... -
tbtimburke3Replied on July 2, 2019 at 9:43 AMGreat 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?
... -
AndrewHagReplied 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