Hi, so i have a form with drop down lists where each control populates one of 3 text-boxes which then i count at the end. While counting I have 3 text boxes named A,B,C where the count is shown. Now i need to determine which field is greater and I have put in rules in the A,B,C for this.
My problem comes when i change the values in the drop down lists when my C value is highest but i change it so that B=C, my formula should populate a final text box with B but, its not changing. I already have a rule in place for this in the B field ( Condition: B >/= C and B> A; Set field's value: Textbox= High). This rule i think isn't getting triggered as the change is happening in C field mainly.
Is there a way that i can get to trigger my rules every time either of these 3 fields change? Or any other way to solve this problem?