How do I hide all b ut the last four digits of the SSN?
Should this be auto-calc for a test field, or calc field?
1) remember that you are talking to the world, not only to the US - some very good posters might not know what SSN stands for and you will lose potential good answers by not defining what you are talking about.
2) a calc field will do - it can be right(yourSSN; 4) or GetValue(substitute(yourSSN; "-"; ¶);3)
3) You can avoid another useless calc field: use a monospaced font to display the social security number, right align it and cover with a rectangle coloured the same colour as the layout background, with no line; make the rect big enough to show 4 digits but no more. >> no calcs, just a display thing.
Of course, the field should be set to field entry - browse mode to off, search on, via inspector.
Be careful about storing data such as the social security number. It could be seen as a major security issue - like storing a credit card number. Most would probably tell you not to store a SSN. Security through obscurity is not security.
ditto. If you must store, then encrypt the data.
I agree that this kind of data should not be stored at all, but some industries still revolve around using SSNs. Schools (although they are trying to minimise use these days), credit businesses, and medical businesses use SSNs frequently. So it is sometimes needed and I would say small credit/loan offices and schools are the likely use cases for a FM solution.
I remember when I was in school I did not give them my SSN for use as an ID number and demanded I have a unique ID number assigned. This was quite a hassle, but in the end they were able to manage making it happen and this allowed for others to request this if they wanted to. I was a bit of an idealist back then.
Sometimes it's necessary to keep SSN or S.I.N. An example would be managing pension fund contributions. Given you store a person's name and SSN, NEVER STORE THE BIRTHDAY. It's the third item needed for identity theft.
Are you guys saying Filemake is not a safe product to store data such as SSN, DoB, and EIN. ?
Mask Data with Concealed Edit Boxes in FileMaker 15 | beezwax > blog
I don't store them in MS SQL or MySQL either.
Bank Card numbers have very particular rules according to those issuing them.
There are ways to encrypt data before storing, if you really must.
Sent from miPhone
I see, well that's made me feel better about me learning FileMaker.
Retrieving data ...