Text Search

[Kenn-95a0]

If I have a field that is a text block - can I do a "find" like search to return all records with a specific text string in the text block field?

[Nanc-5d83]

Hey @Kenn-95a0,

After reading your post I recalled a previous post one of HoneyCode's representatives responded to and he gave two possible solutions one using the column list search feature which performs flexible searches, as well as provides the filter formula you can use to perform a search.

A "like" condition for FILTER()

Hi @TomRoot welcome to the forum and thank you for your question! The easiest way I could think of achieving this result is to use the Search feature of Lists: [search_2020-06-29_12-27-40] This allows app users to search lists: [2020-06-29_12-28-46_search_2] If I really needed to use filters, I would use the Search function from Honeycode Functions . For instance if I had a MyTable table that looked like: Name John Doe Does This Work John Work Working Example Then the for…

I hope the link is helpful. If you need any more assistance please don't hesitate to reach out!

Best Regards,

Nancy