Initially I skipped a separate index but as your are arguing, the filesystem should not be the index—and so neither should be Agenda for me. So I think I’ve seen the light there.
I took a brief look at Airtable (basically to be able to look at your template ), but I found that Apple Numbers actually can do something similar quite nicely—and I own that anyway.