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
MarkShnier__You
Qrew Legend
Qrew LegendI suggest using a numeric field for data entry and then a formula to display with the dashes. I can help with that formula if you like. It would also be possible to have a Custom Data Rule to validate the number. I assume it has to have a certain number of digits and there must be a check digit which could be validated.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
[email protected]
------------------------------
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
[email protected]
------------------------------
- MarkShnier__YouHi Bruce,
There are a variety of approaches. If you want to have the data entered as pure numeric, then i would use a numeric field for data entry, and then a formula field to display in the traditional format.
var text SSN = Trim(ToText([SSN Numeric]));
var text SSNFormatted=
List("-",
Left($SSN,3),
Mid($SSN,4,2),
Right($SSN,4));
IF(
Length($SSN) = 0, "Missing SSN",
Length($SSN) <> 9,"Invalid SSN",
$SSNFormatted)
Note that for this formula to work, you will need to insert your data entry field name into the first line (or call it [SSN Numeric] like I did) and also set that field's properties to not treat blank as zero.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
[email protected]
------------------------------- Mark, thank you for your Feb 9 reply to my question (Re: Data Entry).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:
- var text SSN = Trim(ToText([SSN Entry]));
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
