I want to create an assessment with a value being greater than other value

I want to create an assessment with a value being greater than other value

I’m building an assessment form in Zoho Forms that includes multiple sections (or categories), each with 4 dropdown questions. Each answer is assigned a numerical value (from 1 to 5), and I use formula fields to calculate a total score per category.

My goal is to identify which category has the highest total score and then use that to trigger an action — for example, setting a hidden field like “Primary Issue Area” to that category so I can send a personalized follow-up email.

However, I’ve encountered a limitation in Zoho Forms conditional rules:
I’m unable to compare one field’s value to another field’s value (e.g., Total_Goals > Total_Profit).
Zoho Forms only allows comparing field values against constants, which means I can’t reliably determine the highest category unless I manually build dozens of rules to account for every possible combination of score values.

This approach becomes time-consuming and unreliable, especially if scores tie or fall below expected ranges. It would be incredibly helpful if Zoho Forms allowed:

  1. Direct comparison between fields in conditional logic (e.g., Field A > Field B)

  2. A built-in function to identify the maximum of multiple numeric fields

  3. A way to assign logic dynamically based on the highest score

Please let me know if there is a workaround, or if this feature is planned for future updates. This functionality would be extremely valuable for assessments, diagnostics, and scoring tools — especially for users who want to automate tailored feedback without building full apps in Creator.