- aolivier422Asked on March 02, 2016 at 06:13 PM
I'm building out a End of Day Reconciliation form for some of my medical practices. I'd like to use the configurable list because it allows the user to add more lines. The only issue I can see is there's no way to get a subtotal from the Number field. Is that correct? Is there a way I can add a subtotal?
What is the best way you have seen other organizations handle setting up forms that require a subtotal and the user to possible enter multiple lines?
- JotForm SupportChriistianAnswered on March 02, 2016 at 09:07 PM
A possible workaround for your form would be to use the spreadsheet widget: http://widgets.jotform.com/widget/spreadsheet
Or perhaps you can add a regular number field and duplicate it so that you have the maximum entries expected on your form. This way, you can perform calculations in the fields without any issue.
Here's a demo form so you can see it in action: https://form.jotform.me/60618574494465
You can clone it to your account by following this guide: How To Clone A Form
Do let us know if you need further assistance.
- aolivier422Answered on March 03, 2016 at 11:45 AMThat widget would work if I could change the column and row headings, the numbers and letters do not look professional.
I have no idea what the max entries per day would be as it’s an end of day reconciliation of cash, mc, visa, AmEx, checks, and insurance payments and adjustments……… I need the user to define how many but still be able to add up each category with a subtotal field.
I take it nothing like that exists in JotForms?
Business Development Project Coordinator | P: 360.558.5610 | M: 503.358.8988 | F: 866.678.9706
Audigy Venture Group | Audigy Group | Audigy Medical | Stratus Dental
“Learn from yesterday, live for today, hope for tomorrow. The important thing is not to stop questioning.”
Connect with Audigy Group:
[Description: Description: _0048_Facebook] [Description: Description: _0046_Twitter] [Description: Description: _0016_Youtube] [Description: Description: _0018_Linkedin]
Audigy Group is a management company and provides only broad-based business advice and recommendations. If you have specific questions, please consult your financial planner, tax advisor, or attorney. This e-mail and any files transmitted with it are confidential and are only for the use of the person to whom they are addressed.
- JotForm SupportKiranAnswered on March 03, 2016 at 01:02 PM
Unfortunately, it is not possible to perform calculations using Configurable list widget. However, you may add multiple fields to your JotForm and show the fields by using some conditions as shown below:
Please see the form below to see if that works for you.
You may clone the form to check how the conditions are set on the form.
Please get back to us if you need any further assistance. We will be happy to help.