Auto change/fix value (convert to decimal)

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?

Please post a screenshot of the action configuration, and a screenshot of the complete expression.

Sure



IF this condition is true:
…ALL these statements are true:
…1: (The value of column ‘F1’) is greater than or equal to (10)
…2: (The value of column ‘F1’) is less than or equal to (70)
THEN use the value of:
…(The value of column ‘F1’ / 10
ELSE use the value of:
…The value of column ‘F1’

1 Like

Column F1 is of type Number, so it will never have a decimal point or fractional part. You’ll need to change the column type to Decimal to get a decimal value.

image

Thanks Steve for your help. I tried that before, i was using type decimal and now i realize what the problem is. The action work’s fine on form view, but it doesnt work in the quickedit, at least that is what i am experiencing.

1 Like

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!

2 Likes