Hi all. I’m building a CMS style app that allows customers to upload, share, and track reads of documents. I’m struggling with the DB and how it can be visualised. The goal is to create a matrix style table/bunch of repeating groups that has:
- Documents assigned across the top row (data type document)
- Users names in column 1 (data type user)
- Read status of each document for each user in the remaining grid space (data type read status)
I keep running into limitations. Ie, the table functionality does not allow me to easily display data from differing types. I’m then struggling to set up 3 separate repeating groups, each containing the relevant data type, as responsive and vaguely well-designed.
Should I change my DB set up? It’s
- Users
- Documents
- Read status
- Organisation (customer)
Or am I being dense and missing something here?
Any help, would be much appreciated.