Hi all, I just ran into the searchable database issue with a client. He has a list of insurance policies on google sheets and wants it to be searchable on their website. Basically the page would have two fields "Policy Number" and "Client name" and a "search policy" button. The report generated is supposed to display three types of info from the spreadsheet: "Policy type", "Expiration date" and "Status". Ideally the data has to be secured and not expose the info of other clients.
P.s. I'm not a programmer but I'm trying to figure out a way to solve this.