Tables: Perform calculations with data from all the ssubmissions.

  • Profile Image
    SPapplication
    Asked on June 28, 2021 at 11:29 PM

    TRIO Book Voucher · Tables (jotform.com)


    Hello. I wanted to utilize the sum feature in tables but the addition is off. Can you guys see if you see what I see?


    Thanks.

  • Profile Image
    Zahra_S
    Answered on June 29, 2021 at 06:51 AM

    Hi there,

    Can you please elaborate on the query so we could assist you better? I checked your form's tables but couldn't find a column with SUM. Do you mean that the sum is not showing? Please let us know for which column you are trying to calculate the sum.

    Waiting for your response.

  • Profile Image
    SPapplication
    Answered on June 29, 2021 at 11:33 AM
    Im trying to sum the column with the $ amounts. It’s not on because it wasn’t calculating correctly so I turned the feature off.
    Julio Rodriguez
    ...
  • Profile Image
    AndrewDurant
    Answered on June 29, 2021 at 04:41 PM

    Hello there,

    Thank you for reaching out to Jotform Support! I am having a hard time understanding your request. I just cloned the form into question into my own account, and I am not seeing a sum field, nor do I see any columns that you could be trying to sum together.

    Can you please re-implement any changes that you are trying to make, and provide us with the link to the form in question so that we can help you work on a solution here?

    User Guide- https://www.jotform.com/help/401-where-to-find-my-form-url

    Thank you!

  • Profile Image
    SPapplication
    Answered on June 29, 2021 at 04:55 PM
    I apologize…there are different tabs on this table. I thought you would be able to see all of them.
    TRIO Book Voucher · Tables (jotform.com)
    Can you please try this link….
    All Sierra College campuses will be closed on Friday starting June 4th through August 13th.
    [signature_364950]
    Julio Rodriguez (He/him/his)
    Student Services Specialist
    Retention and Completion Division
    Phone 916-660-7377 Mobile 925-695-7478
    Web www.sierracollege.edu Email jrodriguez40@sierracollege.edu
    5100 Sierra College Blvd, Rocklin Ca 95677
    [signature_688918698][signature_1485691725][signature_857214503]
    THIS MESSAGE IS A CONFIDENTIAL COMMUNICATION and intended only for the use of the individual(s) to whom it is addressed. It should not be shown to anyone not employed by Sierra College and should be shown to College employees on a legitimate educational interest basis only.
    ...
  • Profile Image
    AndrewDurant
    Answered on June 29, 2021 at 06:20 PM

    Hello there,

    Thank you for the follow-up! I believe I now understand your request correctly. Essentially, each submission will include a payment amount, and you are looking to total all of these payment amounts so that you can view your total payments through our Table view, correct?

    If I am understanding this correctly, this is not currently possible natively in our Table product. I will escalate this thread to our Developers as a new feature request, and ask that our Developers consider implementing this functionality in the future.

    As a work-around for the time being, I would suggest exporting your submissions into a CSV file, as this will give you more flexibility in regards to data manipulation. You can find the process to export your data here, and a help article from Microsoft that will help you create this formula.

    While we are unable to offer an ETA for this feature to be enabled, this thread will be used to track our progress, and any updates will be published here as soon as they become available.

    Thank you!

  • Profile Image
    SPapplication
    Answered on June 29, 2021 at 06:33 PM
    Would you be able to explain the “sum” feature? What would that be used for?
    Julio Rodriguez
    ...
  • Profile Image
    Zahra_S
    Answered on June 30, 2021 at 01:52 AM

    Hi Julio,

    We apologize for the confusion.

    I checked your tables page again and was able to figure out the issue. The 'Sum' option was cutting off because of the page responsiveness issue. I reduced my window size and was able to find the 'Sum' option.

    I have added this option for you, please check:

    1625032296_60dc06685755e_

    I hope this helps. Please let us know if you need further assistance.

  • Profile Image
    SPapplication
    Answered on June 30, 2021 at 11:44 AM
    Yes. Thank you. But that is not the issue. If you look at the total of the sum in the picture it says $2,402.9. That sum is incorrect. All of the payment entries on that form should add up to $1991.xx. The form isn’t adding it up correctly.
    Julio Rodriguez
    ...
  • Profile Image
    AndrewDurant
    Answered on June 30, 2021 at 01:00 PM

    Hello there,

    Thank you for your confirmation! I will be forwarding this thread back to our Developers to let them know that this Sum Function is not working properly. We will forward any additional information your way as soon as we receive them.

    Thank you!