This isn’t exactly an answer, but something like Baserow or NocoDB could be helpful. They’re self hosted versions of Airtable (if you’ve ever used that). Basically it’s a very fancy spreadsheet that can be used to do a ton of custom logic. If you can’t find software that fits your exact needs, chances are you could set something up with one of these! Good luck!