Help

Showing Numbers in a formula field

Topic Labels: Formulas
Solved
Jump to Solution
1131 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Nathan_Ramey
6 - Interface Innovator
6 - Interface Innovator

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!

1 Solution

Accepted Solutions
Vivid-Squid
11 - Venus
11 - Venus

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)

See Solution in Thread

2 Replies 2
Vivid-Squid
11 - Venus
11 - Venus

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!