Search only for text that begins with "te" (for example)

[Vanyanie]

I got a vocabulary app and I can search the list of words just fine.
But is there a way to search only word that begin with a specific set of letters?
When I type "te" into the search field the results will be all word in my database including "te".
Is there a trick I can search only word that begin with "te"? Like a SQL search like "te%" or a regular expression?
Thanks

[AleksiAlkio]

Im afraid AppSheet doesn't have that kind of built-in functionality. A workaround is to create that functionality by yourself.

[Vanyanie]

But how? I've no idea where to start.

[AleksiAlkio]

AppSheet has the expression StartsWith() that you can use with the slice. Now if you have a Dashboard view with twe views, quick editable detail view and the slice, it filters your table view for example as you requested. When you type something on the detail view, the slice finds those rows that matches.

[Vanyanie]

I understand the basic idea, but when I use QuickEdit the value of the data will change. Also I don't understand how to use

StartsWith([column], "what I wanna search")

I don't know how to connect these.

[AleksiAlkio]

Another workaround is to have an additional column with the first two letters from your original column and make only that new column searchable. 

[Vanyanie]

Finally, got it to work.

[AleksiAlkio]

Good to hear!