Hi there,
As I don’t see too many use cases shared, I decided to showcase mine.
While it’s a hobby project, I think it shows the power of BaseRow and AppBuilder, even while the latter is pretty new…
I used to have an Airtable database to keep track of my cigar collection and keep reviews of the cigars I smoked, with a Softr frontend. When Airtable changed its free tier, I decided to turn to an alternative solution.
After some other options , I tried BaseRow. Main selling point for me was the generous free tier, combined with its options and relative ease to use, and finally: the launch of the App-Builder.
Basically, the database consists of several linked tables:
- cigar list - a list of cigar to choose from, this is also the table that tracks several lookups, and rollups. A calculation field keeps track of the number of cigars I have in my humidor.
- purchase list - a date-stamped list of all cigars I purchase, get gifted, give away, etc…
- smoking journal - a chronological diary of all smoking sessions. Here I keep track of session scores, that get rolled up in the cigar list (and create a living average of all sessions). This allows to have all kind of fun statistics.
To be able to have some more statistics, I also have some additional tables:
- countries (to keep track of origins, statistics by country, etc… )
- people (who smoked, purchased, etc …)
- brands (to keep track of cigar lines, cigars purchased or smoked by brand, etc …)
- shops (to keep track of purchases by shop)
Behind the scenes, there are some forms (for logged in users only) that allow quick creation of new records (purchases or smoking sessions) that features pre-filled fields (such as date, cigar, etc).
This is all a work in progress, but check it out here: https://spookycigars.baserow.site
Don’t forget to visit the stats section. Hopefully, someday this can all be done from within BaseRow…
Feedback surely appreciated
(if there are no records in ‘My Humidor’ or ‘My Smoking Journal’, just reload. BaseRow sometimes gets an network error - Network Error - could not connect to the API server)