Our Org has a form for Quality Control review. There are around 50 questions with "Pass," "Fail," and "N/A" options. We have custom fields for "Fail Count" and "Total reviewed." Total reviewed being all questions NOT answered with "N/A." It would amazing to use form logic to count these responses automatically. IE, Replace value in "Fail Count" with "Count of [select field(s)] that equal [value(s)]."
We currently tally up the two count fields using the process flow after submission: 50 condition sets value check each question- If answered "No," both count fields are appended with the number 1. If answered "Pass," only "Total" is appended. After reviewing all 50 questions, you are left with "tally" values such as "1111111." The remaining 50 condition sets convert the values to an integer, "7" in this case. Our team asked if we could do a "Fail Percentage" in this manner, and we had to explain it would take ~1,300 condition sets to accomplish in the current system, which is simply unfeasible.
If the system were updated to do basic math functions based on field values, this type of calculation would be simple and a ton of value to form logic and process flows. IE, update percentage field to "[Fail Count] divided by [Total Reviewed]." Another scenario would be a form for purchasing. You could have a "Grand Total" SUM field where dollar values are totaled up based on items selected for purchase. This grand total could be evaluated after submission to determine if there should be additional management approval, for example.
If anyone can think of other use cases, please leave a comment.
