im not a programmer nor computer expert, sorry if my question is basic. I already make a database app with appsheet, it similar with phonebook (name, address, etc). My problem is i have too much data and some people name have same sounds but different writing, ex: Eric, Erict, Erick, Erric. So if i want to search their name, i just type ‘Er’ (part of name) and appsheet will show all of ‘Er’ name. But sometimes there too many name to show.
Is it possible to make a combine search, people with ‘Er’ name and ‘xxxx’ address (part of address)? So the list shown will be shorter.
Thanks in advance