Social Security Number typing and saving...
Hi, and many thanks for your help, we appreciate it We are not the best coding so we will try our best. We are a attorney at law office and we register all info about our customers, including t...
Forum Discussion
One option is three fields on the form with dictated lengths
XXX
XX
XXXX
then a formula field to put the pieces together
------------------------------
Don Larson
------------------------------
Thank for your time Don,
We figure out that we were hoping too much, so trying to resolve we did what you said before with next formula text field:
var text PartOne = Left([SS#],3);
var text PartTwo = Mid([SS#],5,2);
var text PartThree = Right([SS#],4);
List("-", $PartOne, $PartTwo, $PartThree)
It is working fair good enough, but we facing the following now; Some SSN were written like ( ###,###,###) so, the new field keep them as (###-##-,###). That take me to question, is there a way that formula void (, / . ) symbols?
We appreciate your time Don, and else others.
------------------------------
AlfaCenter LawGroup
------------------------------The function you need is Search and Replace
This details it for you:
https://login.quickbase.com/db/6ewwzuuj?a=dr&r=f8&rl=2
------------------------------
Don Larson
------------------------------I did a quick demo app
The input fields are limited in length
the output is a formula text field
------------------------------
Don Larson
------------------------------
