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.

Filter Records based on first word

Topic Labels: API
322 2
Showing results for 
Search instead for 
Did you mean: 

is there a way to filter a table based on first world in a column.
(like search in sql)
i have a table and it has products,
i want to get all products starts with ‘television’

2 Replies 2


Welcome to the community! You can find our guidelines and FAQ’s here.

I made a short video explaining how I would approach this. The formula field reference is helpful when building out these types of formulas.

Thanks for your reply, I want to get it using api.