Help

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

Topic Labels: Formulas
Solved
Jump to Solution
385 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! 😄