Filtering Alphabetically with Airtable (not sorting)

Hi Brian,

You need a New Formula Column in the Names Table that includes this Regex Code :

REGEX_EXTRACT(Name, "\\b[a-zA-Z]")

( In here for the Name add your column name that consists the name of that name )

And then add this Filter in your Names List :

Search(LOWER('Input'),LOWER({Regex formula column}))

( You can add Search('Hawaii', {Field Name}) too but when you create a item that starts with a simple letter and then that name will not show in the list. )

Here’s a video :

Thank you

1 Like