Grant Application form with budget table including calculations

  • colleensaylor
    Asked on November 10, 2021 at 11:44 AM

    I am working on a grant application form that has a section for them to input their expected amounts for various types of expenses. I have tried both the spreadsheet widget and the table and am struggling. I really liked the look of the table better but I can't get calculations to work in either. I found some previous posts that helped me with code for the labels on the rows of the widget but any assistance is appreciated. I would like the totals on the right and bottom to autocalculate as we have them in the current word format while allowing the user to enter the amounts in greyed columns. Ideally the total columns would also be read-only.

    1636562369 618bf5c19df8b  Screenshot 10

    Here is the table

    1636562628 618bf6c44a7bf  Screenshot 21

    Here is the Widget

    1636562657 618bf6e1ace94  Screenshot 32


  • Amin JotForm Support
    Replied on November 10, 2021 at 2:05 PM

    Hi there,

    Thanks for reaching out to us!

    You don't really need the Spreadsheet widget for that. Actually, you can perform all sorts of calculations on/in the Input Table using conditional logic and the calculation widget.

    Related guides:

    Calculate-values-in-the-input-table-through-condition

    How-to-perform-form-calculation-in-the-input-table-field

    After reading the guides, if you still need further assistance, please let us know.

  • colleensaylor
    Replied on November 12, 2021 at 11:56 AM

    I just started using Jotforms this week and this is very unclear to me. Is there a realistic tutorial with math calculations to watch the process? The example video was for something entirely different. I tried it with the conditional logic and it would not work and the instructions for the calculation values on the Input Table Properties was unclear to me. Am I putting CIP funds requested, Cash Match, In-Kind Match then how does it total it? I apologize but I am pretty confused.

  • Hanne JotForm Support
    Replied on November 12, 2021 at 1:29 PM

    @colleensaylor

    Thank you for following up.

    I have made a clone of your form, I moved the field up top just for convenience, the placement will not matter.

    You can clone my demo form to have a closer look at the conditions and field calculations. I have also made a screen recording attempting to show how to use the different fields of the table in the Calculation widget.

    1636741541 618eb1a5c5549 calculatetable Screenshot 10

    This is not the whole table, but you can fill it in using the same steps. I do hope this is helpful.

    Please, do let me know if you have additional questions.

  • colleensaylor
    Replied on November 12, 2021 at 1:34 PM

    Thank you, I think I can work this out now.

  • colleensaylor
    Replied on November 12, 2021 at 1:44 PM
    Hanne,
    Thank you , this is helpful
    Colleen
    Colleen Saylor
    Court Improvement Program – Data Analyst
    Indiana Supreme Court
    Office of Judicial Administration | IOCS
    She/Her
    251 North Illinois Street, Suite 800
    Indianapolis, IN 46204
    Tel: (317) 234-5346
    Fax: (317)233-3367
    Email: colleen.saylor@courts.in.gov
    Court Improvement Program Website
    CONFIDENTIALITY NOTICE AND DISCLAIMER:
    Please be advised that this e-mail and any files transmitted with it may be privileged, confidential, and subject to legal restrictions and penalties regarding unauthorized use. Please refrain from copying, distributing or otherwise using the information contained if you are not the intended recipient. If you have received this e-mail in error, please notify the sender by return e-mail and delete the e-mail received in error along with all attachments from your system. The sender cannot provide legal advice to the public and any communication with the public is not intended to form an attorney-client privilege.
    ...