Truncate the postal code by removing the first 2 digits

AppSheet AppSheet Q&A
, ,
1

Good morning,

I want to truncate the postal code by removing the first 2 digits.
I know how to do it in clac or excel but can we do it in appsheet?
If yes, how ?

Thanks for your help

2

You can do it with a formula MID([ColumnName],3,20). But as you can’t do that with the same column while the user is typing, you need to do that when the form is saving. That you can do with the Event action and you can find it from the Form view.

2 Likes
3

Thank you it’s perfect because it’s the result that should be displayed after saving the form

4

You’re welcome