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?
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.
@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.
Make a virtual column. Or an action that runs on form submit.
I would use an action for this purpose as well.
Action would work.
Thanks!
User | Count |
---|---|
43 | |
29 | |
22 | |
20 | |
15 |