-
colleensaylorAsked 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.
Here is the table
Here is the Widget
-
Amin JotForm SupportReplied 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.
-
colleensaylorReplied 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 SupportReplied 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.
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.
-
colleensaylorReplied on November 12, 2021 at 1:34 PM
Thank you, I think I can work this out now.
-
colleensaylorReplied on November 12, 2021 at 1:44 PMHanne,
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.
...