Jump to content

Searchable Database Form for Google Sheets


Recommended Posts

I created a Query in Google Sheets which uses a blank cell as a search box. It works fine and retrieves the requested records based on the text input in the defined cell. However, when I rolled it out to my site, I realized that it did not work for  Iphone users unless they also load the Sheets App on their phone. The iphone does not let the user input text in the defined cell.  My organization does not want users to have to add an app to their phone in order to find their record.

Next, I created a searchable form on top of Google Sheets using a company called Xref. Good Dog Agility - Doggie Bytes Balance Query (x-ref.se) It works exactly how I want it to except the pricing is too high for my non profit organization. Does anyone have any other suggestions that are affordable with a fixed one time fee instead of an annual fee in perpetuity? Thank you for your assistance!

Link to comment
Share on other sites

  • 2 weeks later...

Maureen,

I am sorry no one has replied and that I do not have a specific script/service to recommend. However, your hosting service with us allows you to run your own databases and scripts. I would recommend finding a free or paid script to create a searchable database and front end. You could also have someone design and create a basic tool for you.

 

 

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

×
×
  • Create New...