How to add a hyphen automatically to a number field?
Hi, i need to create a field to input Identity card number. I need a calculation to make it automatically add hyphen between numbers. For example: 886546-87-1123<------ how i make a calculation to let the field auto add hyphen when i type in the number? Can anyone show me the calculation please...........
First, the field must be of type text and not number;
then you could use this calculation in the options of automatic insertion of calculated value:
Replace ( Replace ( Filter ( Self ; 1234567890 ) ; 7 ; 0 ; "-" ) ; 10 ; 0 ; "-" )
P.S.: remember to unflag the box: "Do not replace existing value..."