Number special formatting

Hello, I want to format a text field in this way ###_###_### when the user is typing.
Is it possible ?

Solved Solved
0 2 161
1 ACCEPTED SOLUTION

Look answer for that post
https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/Text-or-Number-Box-with-Dots-in-between-to-ente...
Notice: any checks executed not imediatly user types data, but when edited field lost focus (switch to next field or button)

View solution in original post

2 REPLIES 2

Look answer for that post
https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/Text-or-Number-Box-with-Dots-in-between-to-ente...
Notice: any checks executed not imediatly user types data, but when edited field lost focus (switch to next field or button)

Not when the user is typing.  AppSheet does not use input format strings.

AppSheet does allow you apply validation rules in the a property named "Valid_If" on each column.  You can apply expressions to verify the input is in the format you expect and if not present a message  composed in the "Invalid value error" property.

To accomplish the same thing, I would include in your field label text such as (e.g. ###_###_###) to give the user an example upfront of how you wish the values to be entered, then implement a "Valid_If" with "Invalid value error" expression to confirm the format and show a message if its wrong. 

Top Labels in this Space