I would like to create a simple database where I can read a sutta, enter that sutta’s ID, and attach my own keywords/tags to that sutta. Most importantly, I’d like it to also have a “lookup” feature that has two functions:
When clicking on a sutta id (e.g., MN 1) from a master list of all suttas, it will show all of the keywords I’ve entered for that individual sutta.
When clicking on a keyword (e.g., “sekha”) from a master list of all keywords I’ve entered, it will show all of the suttas linked to that keyword.
I’m not a coder; just have a basic proficiency with common programs like MS Office and its Google versions. A friend of mine helped me build something in Google Sheets, but it’s pretty complicated and requires him to update it periodically so that the newly-entered suttas and tags show up in the lookup feature. It seems that there must be a simpler way – ideally one that I can maintain by myself.
This sounds like a good use case for a personal wiki. There are many applications, across all of the common platforms; it may take some trial-and-error to find one with the features that suit your needs.
Specifically, I put the suttacentral epubs on the Google Play Books app. I turn on note exporting to Google Docs and then highlight the sutta title and add my tags there (in addition to highlighting and annotating passages that speak to me).
These notes (along with all my other notes on everything else) are then easily searchable on Docs.