February 24, 200521 yr 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!
February 24, 200521 yr 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.
February 24, 200521 yr 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.
February 24, 200521 yr Author 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!
Create an account or sign in to comment