Filter Emirates ID

[Msaeed]

As per mentioned in topic ,I would create script help me to make" - " between number for Emirates ID include 15 like ...

783-1986-1234567-9

Thanks alot for any help....

[comment]

The question is not quite clear. If i am guessing correctly, you want to make the field auto-enter calculated value (replacing existing value) =

Let ( 
digits = Filter ( Self ; "0123456789" ) 
;
Replace ( Replace ( Replace ( digits ; 15 ; 0 ; "-" ) ; 8 ; 0 ; "-" ) ; 4 ; 0 ;  "-"  ) 
)

This would allow you to enter the ID as digits only or already formatted and have the auto-entry re/format it to the pattern you show.

The field itself should be of type Text, of course.

 

[Msaeed]

thanks a lot for reply yes this is what I need but if I need more professional in case visitor put more than 15 number or missing number should give him show dialog or error

[comment]

If it's important to have exactly 15 digits, then you should validate the field using a calculation =

Length ( Filter ( Self ; "0123456789" ) ) = 15

In addition, you can use a script trigger to check the field before it is validated; this allows you to provide a nicer user experience compared to the built-in validation error message.

 

[Msaeed]

now is working perfect :)