# 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.