I’m jumping in a bit late on this discussion but another database program to consider is Panorama X. Caveat: I’m the author of Panorama X so obviously I have a biased view. But I’ve been doing this for over 30 years so must be doing something right!
Panorama’s basic interface is a lot like a spreadsheet, so it’s easy to get started, but it also has full graphical capability for creating your own custom layouts - shapes, icons, buttons, etc. It includes a programming language so it can be fully automated, and even has a “watch me” mode where it can record your actions and write short programs for you automatically.
If you visit our web site, there is an introductory video and a free trial you can download.
Those of you that have been using the Mac for a long time may remember older versions of Panorama going all the way back to 1988. If you’ve looked at previous versions of Panorama, I hope you’ll look again – we released an all new AppKit version, Panorama X, in 2018. Up until then Panorama was still a Carbon app, and frankly quite out-of-date (though still very functional for many long time users). The new version, which was almost 7 years in the making, is a completely modern Mac-first app (in fact Mac only, we also dropped the Windows version of Panorama when Panorama X was released).
If you’re intrigued, check out the video and the free trial, and if you like it, here’s a $25 discount code for Panorama X, good thru June 15 - MPUTALKSPECIAL0519. Also, if anyone reading this is going to the Orange County Automators meetup tonight, I’ll be there, please say hello!