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

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

  • Profile Image
    BJoanna
    Answered on May 30, 2017 at 02: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.