Jump to content

Searchable Database

Recommended Posts

HI There,

I'm wanting to host a really basic searchable database on a couple of sites.  The database is really basic and needs to include a company name, stand number and a web address.

I can't seem to find anything that works in a simple & responsive way.  I've explored Caspio - but it's a complicated product that is not responsive without adding extra code, plus its expensive, and my client needs to keep costs way down. They will also need to be able to maintain going forward and are not tech savvy.

Also - Caspio once embedded breaks the editing capabilities of the page its hosted on, which is not good. 

What I'd love is a plug in or something easy to use, that means everything is hosted on Squarespace and there is no double handling or external subscription required.

Crossing fingers someone on here has found a unicorn, :)

 

Link to comment

This isn’t the unicorn you’re looking for (you have to pay a fee for >25 entries, etc) but it might be worth checking out.

community box

Link to comment
  • 2 months later...

There are a number of ways to do this, some of which require you to use a third-party solution and some of which can be built in a Squarespace Collection. It really depends on the specifics of your requirements.

"I need a searchable database" isn't enough information for someone to give you a solution 🙂. We can throw you a bone with the names of some third party products, but they may not help. It's much better if you can provide:

  • a link to the website, whether it's in progress or fully built. Note that the link needs to be public, so if it's a trial, you need to set a password and tell us what it is.
  • full details of the data you want to display.
  • details of where the data is currently held.
  • details of why/how visitors need to be able to search the data
  • a mockup of how you'd like to see it work

 

About me: I'm Paul, a SQSP user for over 18 yrs and a Circle Leader since 2017. I value honesty, transparency, diversity and good design ♥.
Work: Founder of SF.DIGITAL, providing 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 below. Buying a coffee is optional.

Book paid help with domains: Connect a GoDaddy domain. Connect a Squarespace Domain. Domain assistance

Link to comment
  • 10 months later...

Hi!

I have the same problem. I'm all right brain and clueless how to do any coding....

Client has an excel file with item number, location, specs and details, etc. It's not big, maybe 200 items. I want to be able to key in just the item number and the location/name would result in the search.

 
Password: GIFTreview922
 
Data: want user to be able to put in item number and the results would pull up the location and description (tree database kept in excel file).
Excel file.
Users find tree tag and can come to this site to put in the tree tag number which will give the tree name, location, girth, age and local history details.
See attachment.
 
Thank you SO much!!!!
  • a link to the website, whether it's in progress or fully built. Note that the link needs to be public, so if it's a trial, you need to set a password and tell us what it is.
  • full details of the data you want to display.
  • details of where the data is currently held.
  • details of why/how visitors need to be able to search the data
  • a mockup of how you'd like to see it work

GIFT sample database search.png

Link to comment
16 hours ago, MWRDesignGroup said:

Hi!

I have the same problem. I'm all right brain and clueless how to do any coding....

Client has an excel file with item number, location, specs and details, etc. It's not big, maybe 200 items. I want to be able to key in just the item number and the location/name would result in the search.

 
Password: GIFTreview922
 
Data: want user to be able to put in item number and the results would pull up the location and description (tree database kept in excel file).
Excel file.
Users find tree tag and can come to this site to put in the tree tag number which will give the tree name, location, girth, age and local history details.
See attachment.
 
Thank you SO much!!!!
  • a link to the website, whether it's in progress or fully built. Note that the link needs to be public, so if it's a trial, you need to set a password and tell us what it is.
  • full details of the data you want to display.
  • details of where the data is currently held.
  • details of why/how visitors need to be able to search the data
  • a mockup of how you'd like to see it work

GIFT sample database search.png

I see @bangank36 has this plugin to convert Google Sheet to Filterable Table.

You can contact him.

Email me if you have need any help (free, of course.). Answer within 24 hours. 
Or send to forum message

Contact Customer Care - Learn CSS - Buy me a coffee (thank you!)

Link to comment
  • 6 months later...

Same here @paul2009. Had a client wait 3 years to move to Squarespace because of this one hurdle. We're doing it anyways while we look for a solution. This is their current table search page, which uses the ultra basic TablePress plugin to look up brands and models they service.

Some have recommended Caspio but it looks too complicated.

There are some overly complicated solutions using google spreadsheets. Others have implemented similar. Lots of chat in this forum.

Could Awesome Table, Sheet2Site (expensive), or that Custom Table Block plugin be a solution?

Another user suggested "You can create table with Code Block, then you can add filter/search function." ?

Thanks for any expert advice. Awesome Table or some very easy plug and play/free option would be ideal.

Cheers,

Jesse

Screen Shot 2021-07-14 at 11.22.27 AM.png

Link to comment
8 minutes ago, mrjessewalker said:

Awesome-Table.com was a perfect solution

The pricing is not awesome.

$39 per month is considerably more than the Squarespace website.

Link to comment
  • 1 year later...
  • 2 weeks later...

Ditto here!

On March 10, 2023 I also need this.

I'd like to create a searchable data base on my website also, possibly a map feature that allows people to see or link to our vendors location and contact info.

I realize this will no doubt be a plug in if it exists. 

Link to comment
  • 3 months later...

Does anyone legitimately have a solution here?

I have a basic 2 row table with a lot of data, that is from the Table Block plugin (SquareWebsites.org).  I need it to just simply be searchable?

The client will be updating a Google Sheet for this as well.

 

 

table.png

Edited by SteveWeb2023
Link to comment
8 hours ago, SteveWeb2023 said:

Does anyone legitimately have a solution here?

I have a basic 2 row table with a lot of data, that is from the Table Block plugin (SquareWebsites.org).  I need it to just simply be searchable?

The client will be updating a Google Sheet for this as well.

 

 

table.png

Squarewebsites.org should have Search * Filter feature Have you try contacting their support yet?

Email me if you have need any help (free, of course.). Answer within 24 hours. 
Or send to forum message

Contact Customer Care - Learn CSS - Buy me a coffee (thank you!)

Link to comment
  • 1 month later...

Hello! I am looking to build a searchable database that I can feature on my Squarespace website. We are creating a resources database that features other organizations and the services they offer. 

I want people to be able to select multiple tags as filters. For example, if someone wants to see an organization that offers both housing and health care services, they would be able to select both tags/filters and see organizations that offer both. 

I've looked at options like Community Box, but I don't love that it's a reoccurring subscription. https://www.communitybox.co/. Ideally, I'd want a one-time purchase plugin or service. 

I've also looked at the Squarespace Universal Filter, but I'm unsure if people are able to use multiple tags to filter items -- all the examples I've seen only allow you to select one tag. https://www.squarewebsites.org/squarespace-plugins/universal-filter

Link to comment

I suggest your first stop should be DataTables.

I don't know if it can handle the kind of filtering you need but DT has so many features I wouldn't be surprised. DT is a complex piece of code and although you can get something basic going pretty easily, if you're not into web site programming you'd probably need a developer's help.

The base product is free. Plug-ins may be free or cost. Developer services will of course cost.

If you have a lot of data the base product may not perform well and would need to be connected to an external database for better performance.

Let us know how it goes.

Find my contributions useful? Please like, upvote, mark my answer as the best ( solution ), and see my profile. Thanks for your support! I am a Squarespace ( and other technological things ) consultant open for new projects.

Link to comment
2 hours ago, lightfoundchi said:

I am looking to build a searchable database that I can feature on my Squarespace website. We are creating a resources database that features other organizations and the services they offer. 

You may also want to take a look at this thread:

 

About me: I'm Paul, a SQSP user for over 18 yrs and a Circle Leader since 2017. I value honesty, transparency, diversity and good design ♥.
Work: Founder of SF.DIGITAL, providing 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 below. Buying a coffee is optional.

Book paid help with domains: Connect a GoDaddy domain. Connect a Squarespace Domain. Domain assistance

Link to comment
  • 5 months later...

I used Airtable. Their free version gives you unlimited bases (tables) with up to 1,000 records per base, and you can embed a base into any web page that supports iframes. You can see how I embedded a database using Airtable's "Grid View" here.

 
Link to comment
  • 2 months later...

I'm in a similar situation. I'm trying to create a searchable, crowdsourced database.

  • A link to the website, whether it's in progress or fully built. Note that the link needs to be public, so if it's a trial, you need to set a password and tell us what it is. No published website yet. It's in the design phase on Squarespace, but I don't want to commit the $$ without knowing I can get a functional database that meets my needs. 
  • Full details of the data you want to display. I'm trying to create a searchable database with mostly crowdsourced data. It will have company names, multiple employer benefit information fields, with about 20 different fields in total, along with the ability to have thousands of company entries. These fields should be either drop-down selections or manual entries from users (again, crowdsourced). 
  • Details of where the data is currently held. I haven't figured this out yet. Excel? Google Sheets? It needs to be accessible by users to enter the data. I'm not sure what would be easiest. 
  • Details of why/how visitors need to be able to search the data.  Users should be able to search by company, company size, city, state, or by specific benefit category. 
  • A mockup of how you'd like to see it work. Don't currently have this.
Link to comment

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.