I put together a sample app to perform a more free-form search rather than the literal search provided by the built-in search bar. The app uses slices, a dashboard view, and keeps searches isolated to each device.
A huge limitation is that text manipulation in AppSheet is very difficult. The inability to easily isolate words from non-space non-words (e.g., punctuation) makes matching whole words difficult when the words are adjacent to non-space non-words. Would be nice to have EXTRACTWORDS()…
Oh DARNIT I was hoping you had magically solved the “partial search” problem with AppSheet lol. But this is awesome too! So good to have an example - wish I’d had this two weeks ago! :-))) The next person trying to do this should find it easier.
Yes it’s a massive, massive problem with AppSheet that “partial word” search just isn’t possible. When I search “light” I expect to find “lighting”, but its not possible. Insanity. Especially now from a Google product. LOL
My current workaround (it sucks) is to have a Keywords column in my table, and for each item I try to manually add variations (light lighting lighter lite) believe it or not. And make sure I don’t put any commas or periods or anything in there. (!!)
Also, Steve, if you think of any other way to say “partial word search”, please write it here so people desperately trying to find this info can find it! And know that it’s not possible before they hit their head against a brick wall too much lol
Well done!! My head just exploded trying to figure out what you’re doing under the hood to make this work hahaha. I’ll get back to this and try to figure it out someday!!! Then try to implement it on my own stuff!