Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Showing Numbers in a formula field

Topic Labels: Formulas
Solved
Jump to Solution
159 2
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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

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!