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

[Stephen_Logan]

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]

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]

@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_Miche1]

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

[Aleksi_Alkio]

I would use an action for this purpose as well.

[Stephen_Logan]

Action would work.

Thanks!