Skip to main content

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)

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)

Thanks! I didn’t know about these formulas!


Reply