Help

Creating Views Based on Alpha Order

Topic Labels: Base design
Solved
Jump to Solution
1367 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Daniel_Rushton
6 - Interface Innovator
6 - Interface Innovator

Good Afternoon!

I am a Learning Design Coach for a public K-12 virtual school. I am attempting to move our registration process over to Airtable. Is there a way using filters (or any other way) to create views based on alpha order. So I need a view that shows all of the records in which a student last name starts with an A as well as all other letters up to L. Thanks ahead of time!

Dan

1 Solution

Accepted Solutions

I got it! In case you want to try this or anyone else wants to, here is the formula I used:

IF(FIND(“A”,{Student Name - Last})=1,“1”,
IF(FIND(“a”,{Student Name - Last})=1,“1”,
IF(FIND(“B”,{Student Name - Last})=1,“1”,
IF(FIND(“b”,{Student Name - Last})=1,“1”,
IF(FIND(“C”,{Student Name - Last})=1,“1”,
IF(FIND(“c”,{Student Name - Last})=1,“1”,
IF(FIND(“D”,{Student Name - Last})=1,“1”,
IF(FIND(“d”,{Student Name - Last})=1,“1”,
IF(FIND(“E”,{Student Name - Last})=1,“1”,
IF(FIND(“e”,{Student Name - Last})=1,“1”,
IF(FIND(“F”,{Student Name - Last})=1,“1”,
IF(FIND(“f”,{Student Name - Last})=1,“1”,
IF(FIND(“G”,{Student Name - Last})=1,“1”,
IF(FIND(“g”,{Student Name - Last})=1,“1”,
IF(FIND(“H”,{Student Name - Last})=1,“1”,
IF(FIND(“h”,{Student Name - Last})=1,“1”,
IF(FIND(“I”,{Student Name - Last})=1,“1”,
IF(FIND(“i”,{Student Name - Last})=1,“1”,
IF(FIND(“J”,{Student Name - Last})=1,“1”,
IF(FIND(“j”,{Student Name - Last})=1,“1”,
IF(FIND(“K”,{Student Name - Last})=1,“1”,
IF(FIND(“k”,{Student Name - Last})=1,“1”,
IF(FIND(“L”,{Student Name - Last})=1,“1”,
IF(FIND(“l”,{Student Name - Last})=1,“1”)))))))))))))))))))))))

Thanks Allessio!!!

See Solution in Thread

3 Replies 3

hi @Daniel_Rushton,
I think the easiest way to complete what you are describing is to create a column with a formula field that looks for the first letter in the name and accordingly puts either Group 1 or Group 2. Then in the views you can use filters to only show records that belong to that particular group.
Hope this helps!

Alessio
Website: alessiomonino.com
Email: alessio.monino@gmail.com

That’s awesome! I will try to figure out how to write that formula. Thanks!!!

I got it! In case you want to try this or anyone else wants to, here is the formula I used:

IF(FIND(“A”,{Student Name - Last})=1,“1”,
IF(FIND(“a”,{Student Name - Last})=1,“1”,
IF(FIND(“B”,{Student Name - Last})=1,“1”,
IF(FIND(“b”,{Student Name - Last})=1,“1”,
IF(FIND(“C”,{Student Name - Last})=1,“1”,
IF(FIND(“c”,{Student Name - Last})=1,“1”,
IF(FIND(“D”,{Student Name - Last})=1,“1”,
IF(FIND(“d”,{Student Name - Last})=1,“1”,
IF(FIND(“E”,{Student Name - Last})=1,“1”,
IF(FIND(“e”,{Student Name - Last})=1,“1”,
IF(FIND(“F”,{Student Name - Last})=1,“1”,
IF(FIND(“f”,{Student Name - Last})=1,“1”,
IF(FIND(“G”,{Student Name - Last})=1,“1”,
IF(FIND(“g”,{Student Name - Last})=1,“1”,
IF(FIND(“H”,{Student Name - Last})=1,“1”,
IF(FIND(“h”,{Student Name - Last})=1,“1”,
IF(FIND(“I”,{Student Name - Last})=1,“1”,
IF(FIND(“i”,{Student Name - Last})=1,“1”,
IF(FIND(“J”,{Student Name - Last})=1,“1”,
IF(FIND(“j”,{Student Name - Last})=1,“1”,
IF(FIND(“K”,{Student Name - Last})=1,“1”,
IF(FIND(“k”,{Student Name - Last})=1,“1”,
IF(FIND(“L”,{Student Name - Last})=1,“1”,
IF(FIND(“l”,{Student Name - Last})=1,“1”)))))))))))))))))))))))

Thanks Allessio!!!