Generic database sample / template

[Kirk_Masden]

Basic idea:  It should be fairly easy to build a sample app that stores data in a Google spreadsheet and allows users to arrange of searches of different types of columns: text (IN or 😃 and range (numbers, dates).  If the app builder is ambitious, it should also be possible to create a flexible interface that allows the user to combine a number of search criteria with a combination of AND or OR conditions.

Question: Has anyone made such a generic database app? If so, have you published it as a template?

Background: I've been using rather expensive database software for many years.  It's good software but for me it's mostly overkill.  I'm considering transferring my data to a Google spreadsheet.  I could probably set up a little interface there to use query statements to do the work I'm currently having the database software do for me.  But, it occurs to me that AppSheet could do this too.  I think I could build such an app but if one already exists I see no reason to reinvent the wheel, so to speak.

[WillowMobileSys]

Can you not simply use the Column filtering now available in the Search function?

Or maybe you want to save the search for later retrieval? 

I have built such a feature for a client but no longer have access to that app.  If this is what you want, then you simply need to build a Filter table with columns of criteria you wish to search by or ranges to search within (i.e. Start Date and End Date).  When a user saves such a row with the selected filter values, you then use an action with the LINKTOFILTEREDVIEW() function to apply all of the criteria to your source data giving a view of the filtered results.

The rows of the Filter table are the "saved" searches.  You can include a name such as "New Products entered after 1/1/2022".  On the Filter view row, include a button that again fires off the LINKTOFILTEREDVIEW() function to get a fresh view of the data.  On the filtered view you could have buttons to create a CSV file or trigger some report.

I hope this helps!

[Kirk_Masden]

Thanks.  Your comments do help.  I think I'll wind up putting something like this together eventually.  I was just curious as to whether something like this had been published as a template.  Perhaps not at this point.