### Title

notation format

### Post

Best I found this wonderful script forum, unfortunately I manage my table address field address Delete :: Telephone 2

I want to link this script to the address field // mail :: Telephone2 (for Begium issues)

ADRES::Telefoon 2

Let ( [

input = GetAsText ( Filter ( tel ; "0123456789" ) ) ;

chk9 = Length ( input ) = 9 ;

chk10 = Length ( input ) = 10

];

Case

( input = "000000000" ; TextColor ( "000/000.000" ; RGB (0 ; 0 ; 0 ));

(not chk9 and not chk10) or ( Left (input ; 2 ) ≠ "02" and Left (input ; 2) ≠ "03" and Left (input; 2 ) ≠ "04" and Left (input ; 2) ≠ "09" and Left (input ; 2 ) ≠ "01" and Left (input ; 2) ≠ "05" and Left (input; 2 ) ≠ "06" and Left (input ; 2) ≠ "07" and Left (input ; 2) ≠ "08") ; TextColor ( tel ; RGB ( 220 ; 0 ; 0 ) ) ;

(Left (input ; 2 ) = "02" or Left (input ; 2) = "03" or Left (input; 3 ) = "042" or Left (input; 3 ) = "043" or Left (input ; 2) = "09") and (Land = "") and chk9 ;

TextColor (Left ( input ; 2 ) & "/" & Middle ( input ; 3 ; 3 ) & "." & Middle ( input ; 6 ; 2 ) & "." & Middle ( input ; 8 ; 2 ) ; RGB (0;0;0));

(Left (input ; 2 ) = "01" or Left (input ; 2) = "05" or Left (input; 2 ) = "06" or Left (input ; 2) = "07" or Left (input ; 2) = "08") and (Land = "") and chk9;

TextColor (Left ( input ; 3 ) & "/" & Middle ( input ; 4 ; 2 ) & "." & Middle ( input ; 6 ; 2 ) & "." & Middle ( input ; 8 ; 2 ) ; RGB (0 ; 0 ; 0 ));

(not chk10 or ( Left ( input ; 3 ) ≠ "047" and Left ( input ; 3 ) ≠ "048" and Left ( input ; 3 ) ≠ "049" ) ); TextColor ( tel ; RGB ( 220 ; 0 ; 0 ) );

( Left ( input ; 3 ) = "047" or Left ( input ; 3 ) = "048" or Left ( input ; 3 ) = "049" ) and (Land = "") and chk10 ;

TextColor (Left ( input ; 4 ) & "/" & Middle ( input ; 5 ; 2 ) & "." & Middle ( input ; 7 ; 2 ) & "." & Middle ( input ; 9 ; 2 ) ; RGB (0; 0; 0));

TextColor ("000 000 000" ; RGB (225 ; 0 ; 0 ))

)

)

viewtopic.php? f = 23 & t = 5938 & p = 36929 & Hilit = telefoonnummer # p36929

Thanks

Frederik

That is not a script. It's a calculation that would presumably be set up for your field as an auto-enter field option.