I would like to modify the user input to ensu...

(Stephen Logan) #1

I would like to modify the user input to ensure the formatting is correct.

For this example the field is 10 char long.

If the user inputs “1234” I would like to update the data to “0000001234”.

I would generally use the following formula =right(“0000000000”&[_THIS],10) but do not know how to implement this in AppSheet.

Can someone assist?

(Aleksi Alkio) #2

No need for that. You have the option to choose how many digits to show. You can find this option from the column’s definition.

(Stephen Logan) #3

@Aleksi_Alkio The problem is I need to add the leading 0’s to the users input.

It’s a character field (not number) and the system requires the zero’s be padded to the right.

(Zecharya Michelsohn) #4

Make a virtual column. Or an action that runs on form submit.

(Aleksi Alkio) #5

I would use an action for this purpose as well.

(Stephen Logan) #6

Action would work.