Jan 07, 2022 10:41 AM
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
Solved! Go to Solution.
Jan 07, 2022 12:13 PM
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!!!
Jan 07, 2022 10:45 AM
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
Jan 07, 2022 10:51 AM
That’s awesome! I will try to figure out how to write that formula. Thanks!!!
Jan 07, 2022 12:13 PM
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!!!