Filter Records based on first word

[Anuradha_Abeysu]

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’

[Adam_Minich]

Hello,

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.

[Anuradha_Abeysu]

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