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

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?

0 5 503
5 REPLIES 5
Top Labels in this Space