Grant Application form with budget table including calculations

  • Profile Image
    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_

    Here is the table

    1636562628_618bf6c44a7bf_

    Here is the Widget

    1636562657_618bf6e1ace94_


  • Profile Image
    Amin_N
    Answered on November 10, 2021 at 02: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.

  • Profile Image
    colleensaylor
    Answered 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.

  • Profile Image
    Hanne_L
    Answered on November 12, 2021 at 01: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.

    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.

  • Profile Image
    colleensaylor
    Answered on November 12, 2021 at 01:34 PM

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

  • Profile Image
    colleensaylor
    Answered on November 12, 2021 at 01: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.
    ...