asked on

AFTER ENTERING DATA INTO A FIELD THEN FIELD SHOULD APPEAR...........

What function or script I should use for special fields such as phone numbers , social sec numbers.

Example:

If I enter phone number 5593512032 in a phone number field, when I move to next record or exit then the phone number field should appear as (559)- 351-2032 or 559-351-2032 and same thing with Socaial Secuirty field if I enter 603456743 after moving to next record or exiting the last field ( Social secuirty field )should appear as 603-45-6743.

Any suggestions. Help please !!

ASKER CERTIFIED SOLUTION

prifre

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Member_2_908359

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

billmercer

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Member_2_908359

I forgot to mention how it works:
You should use the external function
EXTERNAL("FMcs-CallScript", "[script name]")
in the 'control by calculation' property of the field.
(Names may be wrong, I have the same pb as prifre, not using an english version.)
It does nothing if the field is entered but left unchanged.

billmercer

Split it.

Member_2_908359

agreed.

gurshaan

ASKER

Thanks Guys

I will try all of the options. You guys been very helpful.

Thanks again