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.

Creating Views Based on Alpha Order

Topic Labels: Base design
Solved
Jump to Solution
344 3
cancel
Showing results for 
Search instead for 
Did you mean: 

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!!!