-
cgibson94Asked on October 31, 2020 at 4:33 AM
How do I add 10 or more cells together using this calculator? Every time I add the column, I get zeros forced in some of the columns. However, whenever I use only 9 rows everything calculates fine. Please help.
Thank you,
Chase Gibson
-
Mike_G JotForm SupportReplied on October 31, 2020 at 6:35 AM
I have checked the account associated with the email address you have contacted us from and I see your Maury Microwave Budget Proposal form that I assume you are referring to.
Please give me some time to inspect the calculation you set up for the Input Table fields in your form. I'll get back to you on this ticket with my findings as soon as possible.
-
cgibson94Replied on November 3, 2020 at 11:28 AMHi Mike,
Thank you for reaching back out to me.
Yes, that is the correct form I am referring to. I can use the widget
calculator just fine for under 10 lines of adding the total section. But
when it comes to adding in 10+ sections, the calculator seems to bug out
and show a bunch of zeros that I can't edit out.
I'm also wondering if there is an easier way of adding additional rows
while also having the calculator update accordingly? There are times when
I'm adding an additional row and when I go back to the calculator, all of
my previous information I calculated disappears/clears. Would be awesome to
have the calculator remain the same when adding or subtracting rows (and
have a note reminder telling the customer to edit the widget tool).
Would be a huge time saver for me.
Let me know if there is any additional information I can provide you to
help troubleshoot further.
Thank you,
Chase G.
... -
Richie JotForm SupportReplied on November 3, 2020 at 12:43 PM
I have checked your form and I have found some of the form calculation widgets without any calculation.
May we know the calculation field with the issue?
I have tested a cloned version of your form but I can't seem to replicate the issue at my end regarding adding 10+ calculation on the widget.
I have cleared your form cache.
Please try again and let us know if the issue still remains.
-
cgibson94Replied on November 3, 2020 at 1:28 PMHi Richie,
The field with the issue is the "Hardware_pt1 Total ($)", "Hardware_pt2
Total ($)" & "Hardware Total ($)". I would like to only have one widget
calculator here. I tried multiple things, the last try was splitting the
"hardware" sheet into sections then adding those sections (pt1 & pt2)
together. I still had no luck with that.
[image: image.png]
[image: image.png]
I can't edit out the zeros in the amount column, it keeps reverting back to
zero.
Let me know what else I can provide to help out.
Thanks,
Chase Gibson
Technical Sales Specialist
Maury Microwave
2900 Inland Empire BLVD,
... -
Mike_G JotForm SupportReplied on November 3, 2020 at 5:11 PM
We would like to apologize for any inconvenience.
The Input Table with Input Type set to Multi-Type Columns that involves dropdown field type with options that has no numeric value may not be ideal for calculations within the Input Table itself since it is not possible to set Calculation Values for each option in the dropdown field.
What I'm referring to in the Hardware input table is the Required/Optional column.
The dropdown fields under that column have two options with no numeric values — Required and Optional.
Depending on what value you would like to set, you can include a simple numeric value by doing this on each option.
The calculation should work after.
Also, may I suggest that you include in your form a DateTime Single widget, please? Include the widget in your conditions to trigger the calculation automatically. Here's an example.
The widget, by the way, can be set to just run in the background.
Please give it a try and let us know if you need any further assistance.
-
cgibson94Replied on November 4, 2020 at 9:28 PMHi Mike,
I followed your advice and am now good to go! Thank you for the tip about
the Date time widget, I implemented this in along with some code and am
loving this feature.I do have a question and possibly a suggestion for a
future implementation into Jotform. Could you please advise the best way of
cloning a condition but alter it per line without manually going in and
changing each time? Attached are some screenshots to help get the message
across:
[image: image.png]
[image: image.png]
[image: image.png]
Is there a way of not having to manually select the next field and moving
to the next column? I.e. is there a faster way of adding conditions per
field or do I really have to go line by line per spreadsheet? My suggestion
to make this easier would be to allow editing the condition in the field by
double clicking and editing the already existing condition field. Or even
be able to select multiple rows to be assigned to multiple rows instead of
just assigning to one line.
I'm open to suggestions to make this process a more efficient one.
I really appreciate your guys' help.
Thanks,
Chase Gibson
Technical Sales Specialist
Maury Microwave
2900 Inland Empire BLVD,
... -
Mike_G JotForm SupportReplied on November 4, 2020 at 11:17 PM
I'm glad that the solution worked for you.
As for your new concern, I have moved it to a new ticket considering it is about a new topic.
Here's the link to the new ticket: https://www.jotform.com/answers/2680929
We will be responding to that ticket shortly. If you have any follow-up questions about the new topic, please refer to that ticket to avoid confusion.