Can the total column be able to calculate totals of each description?

  • PeteSmithiesMedia
    Asked on May 30, 2017 at 12:13 AM
    Hi there,
    Many thanks for your response.
    There are some specific things that I would like to be able to achieve on the matrix (Bale information) part of the form
    http://www.kellswool.co.nz/online-forms.html
    i.e.
    Could the descriptions convert entries to capital letters irrespective of the case that the user inputs
    Can the total column be able to calculate totals of each description?
    Can I add a grand total box below the total column that totals the “total” fields?
    Thanks
    Pete
  • PeteSmithiesMedia
    Replied on May 30, 2017 at 12:16 AM

    I have been able to address the first requqest - i.e Auto capitalization. But not sure how to effect the rest? Pete

  • BJoanna
    Replied on May 30, 2017 at 2:17 AM

    Total column can be use to calculate total of each row. This can be achieved with Update/Calculate Field conditional logic. Inside of this guide you can find how to do it:

    Calculate Values in the Input Table Through Condition

    Also please check this guide, to find out how to calculate the grand total:

    How to Perform Form Calculation in the Matrix Field?

    Hope this will help. Let us know if you need further assistance.