Let's say I have a Zoho Creator Form with the following Number fields: A, B, C, Score1, D, E, F, Score2.
When A,B,C are filled, Score1 should be calculated as the average of A,B,C.
Similarly, when D, E, F are filled, Score2 should be calculated as the average of D, E, F.
Is this possible to do this with a single function and without clicking the Submit button first? I want it to be updated as the user keeps filling the fields.
I tried using "Validations on form submission" but obviously it requires the form submission. And on "Field rules" I can't seem to add a Deluge function.
Is my only option to use "User input of a field" for C and F inputs in separate worfklows?