Creating Views Based on Alpha Order

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

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

1 Like

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

1 Like

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.