Jump to content

Searchable Database

Recommended Posts

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.

Link to comment
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.

About: Squarespace Circle Leader since 2017. I value honesty, transparency, diversity and great design ♥.
Work: Squarespace Developer and founder of SF Digital, building the features Squarespace didn't include™. 
Content: Links in my posts may refer to SF Digital products or may be affiliate links.

Catch up on all the release notes and announcements 2023 [for Circle members only]. There's a public version here too!
If I helped, you can thank me by clicking one of the emojis below. If you prefer, you can buy me a coffee.
Improve your online store with our extensions.

Link to comment
  • 2 months later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

×
×
  • Create New...

Squarespace Webinars

Free online sessions where you’ll learn the basics and refine your Squarespace skills.

Hire a Designer

Stand out online with the help of an experienced designer or developer.