+9Hello 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!
Best answer by Vivid-Squid
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)
+16Hi @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!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.