DATA ENTRY
I am a new QB user. How does one add an employee's social security number (numbers and dashes)? Should I just use the numeric feature and just forget about inserting dates between sets of numbers? ...
Forum Discussion
Mark, thank you for your Feb 9 reply to my question (Re: Data Entry).
------------------------------
Bruce Kasen
------------------------------
I'm doing something wrong.
- I named the field SSN Number
- I used a Numeric - Formula in the Basic, Type section
- I typed in the formula as follows:
- var text SSN = Trim(ToText([SSN Number]));
- var text SSNFormatted=
- List("-",
- Left($SSN,3),
- Mid($SSN,4,2),
- Right($SSN,4));
- If(
- Length($SSN)=0,"Missing SSN Number",
- Length($SSN)<>9, "Invalid SSN Number",
- $SSNFormatted)
- I get an error message for the first line that reads " Column: 27>Field [SSN Number] is not identified.
Thoughts?
------------------------------
Bruce Kasen
------------------------------
Bruce,
You need two fields to make this work, one that the Users enter their data and then one that holds the formula.
For example
SSN Entry
This where they will type 123456789
Then SSN Number will use the data in SSN Entry to create the formatted out put you want
Your first variable declaration would change to:
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
You need two fields to make this work, one that the Users enter their data and then one that holds the formula.
For example
SSN Entry
This where they will type 123456789
Then SSN Number will use the data in SSN Entry to create the formatted out put you want
Your first variable declaration would change to:
- var text SSN = Trim(ToText([SSN Entry]));
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------