How do I add 10 or more cells together using this calculator?

  • cgibson94
    Asked 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 Support
    Replied 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.

  • cgibson94
    Replied on November 3, 2020 at 11:28 AM
    Hi 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 Support
    Replied 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.

    1604425260 5fa1962cc8c87 3 Screenshot 10

    I have cleared your form cache.

    Please try again and let us know if the issue still remains.

  • cgibson94
    Replied on November 3, 2020 at 1:28 PM
    Hi 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 Support
    Replied 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.

    1604441066 5fa1d3ea6a538 zt201103 170340 Screenshot 10

    The calculation should work after.


    1604441161 5fa1d449e1079 zt201103 170556 Screenshot 21

    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.

    1604441399 5fa1d537947f9 zt201103 170902 Screenshot 32

    The widget, by the way, can be set to just run in the background.

    1604441489 5fa1d59152de6 zt201103 171058 Screenshot 43

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

  • cgibson94
    Replied on November 4, 2020 at 9:28 PM
    Hi 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 Support
    Replied 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.