gurshaan
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 !!
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Split it.
agreed.
ASKER
Thanks Guys
I will try all of the options. You guys been very helpful.
Thanks again
I will try all of the options. You guys been very helpful.
Thanks again
You should use the external function
EXTERNAL("FMcs-CallScript"
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.