Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Convert numbers to pre-defined letters - to create a simple password

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

Hi. I have a very basic password system that uses letters to denote numbers. The numbers come from a client's DOB.

I have a date (DOB) field and another field using DATETIME_FORMAT to only show the numbers (DDMMYY). That's all fine.

I would like to have a new field that displays a particular letter for each number - to create a very simple password. Lets say: 1=a, 2=b, 3=c, 4=d, 5=e, 6=f, 7=g, 8=h, 9=i, 0=j

Is there a formula that would do this please?

 

1 Solution

Accepted Solutions
Sara
8 - Airtable Astronomer
8 - Airtable Astronomer

Hi, this is the only way that I could think about, Let me know if you have any question 🙂

 

Sara_0-1708453261207.png

SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE({Number},"0","A"),"1","B"),"2","C"),"3","D"),"4","E"),"5","F"),"6","G"), "7","H"),"8","I"),"9","J")

Sara_1-1708453312211.png

 

See Solution in Thread

2 Replies 2
Sara
8 - Airtable Astronomer
8 - Airtable Astronomer

Hi, this is the only way that I could think about, Let me know if you have any question 🙂

 

Sara_0-1708453261207.png

SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE({Number},"0","A"),"1","B"),"2","C"),"3","D"),"4","E"),"5","F"),"6","G"), "7","H"),"8","I"),"9","J")

Sara_1-1708453312211.png

 

hauwi
6 - Interface Innovator
6 - Interface Innovator

Thanks so much. I know it's not pretty - but it works perfectly! 😄