Announcements
How can I expand on this search ability here so that it will search on any of the fields in my database view here and return records as I type in the Search textbox.
Hi @Terry-B
You can specify the additional column names that you want to search against like so...
Search('part-masters', Text(TextBox1.Value), "cr670_name", "cr670_customertool", "cr670_oempartnumber" )
thanks,
I have also read further now that the Search function only works with "TEXT" fields. GRRRRR.....Why!!!!!!!!!
Anyway around this?
I get why this is frustrating. For as long as I've known, the Search function has only supported text fields. I guess Microsoft have never updated Search to support target columns of other data types. What target fields do need to search against (eg, numbers or LookUp columns)?
A possible work around for this would be to wrap the call to Search around a call to Filter, and to filter the results from the Search function that match the criteria from the non-text columns. The disadvantage of this however is that it would not be delegable.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 551
WarrenBelz 430 Most Valuable Professional
Valantis 298
