treze Posted January 13, 2022 Posted January 13, 2022 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.
paul2009 Posted January 14, 2022 Posted January 14, 2022 16 hours ago, treze said: He has a list of insurance policies on google sheets and wants it to be searchable on their website. It isn't possible to do this because you cannot place the data in a secure location from where it can be searched. For the data to be searchable the entire list will need to be accessible to visitors, meaning that it won't be secure. creedon 1 Me: I'm Paul, a SQSP user for >18 yrs & Circle Leader since 2017. I value honesty, transparency, diversity and good design ♥. Work: Founder of SF.DIGITAL. We provide high quality original extensions to supercharge your Squarespace website. Content: Views and opinions are my own. Links in my posts may refer to my own SF.DIGITAL products or may be affiliate links. Forum advice is completely free. You can thank me by selecting a feedback emoji. Buying a coffee is generous but optional.
Jake235 Posted April 12, 2022 Posted April 12, 2022 Actually, I may stand corrected. @paul2009 while there seems to be no native solution for a database, how about having a members only area, and using airtable? If you have a members only area, wouldn’t that be a viable solution?
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment