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?