Solved: Auto change/fix value (convert to decimal) - Page 2

Nicolás · 01-15-2021 11:15 AM

Hello everybody

I have this form for grading, the values should be decimal from 1.0 up to 7.0
I need a formula to change de value in case one teacher writes 56 so it will become 5.6, so that "if the number is bigger that 10 and less than 70, that value should be divided by 10
I made an action
set the values of some columns in this row
FIRST GRADE = IF(AND([FIRST_GRADE] >= 10 [FIRST_GRADE] <= 70, [FIRST_GRADE] / 10, [FIRST_GRADE])
I set the action on form submission but nothing happends. Any ideas?

Nicolás

Good news, I manage to do it using the action in a workflow. I ise “change data” on the grades table for any update> do this: action “decimal”(the action i made before)

THANKS!

View solution in original post