Use case: Cigar Collection + Smoking Journal

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 :smiley:

(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)

1 Like

Looks good, nice job!

Nice to see that you have used to column element to create a header and to position text and image side by side. This makes you application more responsive on mobile devices.

Also good to see the use of the repeat element.

Be sure to check out all the new styling capabilities of the 1.26 release. It will help you to create a richer user experience.

1 Like

Thank for the styling tip. I’m revisiting some sections to be more uniform.

This is interesting ! Too bad the pages are hard to load.

Glad you like the project, oplso.

I’m aware - the site is rather image-driven, so a lot of data needs loading.
There also might be a dns-problem sometimes. I’m monitoring ping responses once in a while, and BaseRow people will look into it further.

have a nice weekend,
David

@DavidCeulemans you’ve got an eye for good web design, good job !