Filter Records based on first word

Topic Labels: API
862 2
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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
Airtable Employee
Airtable Employee


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.