Auto format a field

[samshem]

I some help on how to auto format a field. I would like to be able to enter a 3 digit number such as 203 and have automatically formatted as 2.0.3 when I tab to the next field.

I found a template on how to do something similar to this for a phone number field but am unable to adapt it to what I need. Any help would be greatly appreciated. Thanks!

[RalphL]

Use auto-enter by calculation using Left(field; 1) & "." & Middle(field; 2; 1) & "." & Right(field; 1) wher field is the field name. Allow the value to be replaced. This is a text field.

[-Queue-]

Use an auto-enter calculation with 'do not replace' deselected.

Let( T = Filter( thisfield; "0123456789" ); Case( Length(T) = 3; Left( T; 1 ) & "." & Middle( T; 2; 1 ) & "." & Right( T; 1 ); "ERROR" ) )

Of course, this should be a text field.

[samshem]

Use an auto-enter calculation with 'do not replace' deselected.

Let( T = Filter( thisfield; "0123456789" ); Case( Length(T) = 3; Left( T; 1 ) & "." & Middle( T; 2; 1 ) & "." & Right( T; 1 ); "ERROR" ) )

Of course, this should be a text field.

That worked great, thanks so much!