Hi 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.commark.shnier@gmail.com------------------------------

Original Message:

Sent: 02-08-2020 11:18

From: Mark Shnier (YQC)

Subject: DATA ENTRY

I 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

mark.shnier@gmail.com

Original Message:

Sent: 02-08-2020 11:10

From: Bruce Kasen

Subject: 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?

------------------------------

Bruce Kasen

------------------------------