Showing Numbers in a formula field

Hello everybody! Inside my base we have 10-digit codes for each of our users for passwords and such. I was wondering if I could somehow use a formula field to only show a select few digits of that code. Similar to a phone number when they send you a confirmation text you can only see the last four.

Thanks!

Hi @Nathan_Ramey
Yes, you can use either the LEFT(), RIGHT() or MID() formula to extract from the string.

If you want the last 4 try this:

RIGHT({10 Digit Code},4)
1 Like

Thanks! I didn’t know about these formulas!

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.