Configurable List

  • Profile Image
    aolivier422
    Asked on March 02, 2016 at 06:13 PM

    Hi there,

     

    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?

     

    Thanks!

    April Olivier

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

  • Profile Image
    aolivier422
    Answered on March 03, 2016 at 11:45 AM
    That 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?
    April Olivier
    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.”
    -Albert Einstein
    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.
    ...
  • Profile Image
    Kiran
    Answered 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. 

    https://form.jotform.com/60624658725967

    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.