I am struggling with how to build a documents data table that connects to an events data table. Idk why I can’t wrap my head around it. I want to do 2 things - 1) Upload documents specific to the event (maps, permits, contracts, etc) and 2) link generic documents to the event record (yearly licenses, liability insurance, etc)
So right now I’m testing a single documents data table that connects to my events data table, which is fine for uploading the event specific documents, but not for the generic documents.
To complicate things a bit more… my event documents are currently stored in OneDrive - with a folder path of ‘Shared/2020/mm-dd Event Name’ - just wanted to make note of how we’re currently storing documents. I’d love to be able to link that folder to a event record but I don’t think it’s possible.
And to further complicate things…I’m using Integromat to generate documents based on event record fields and saving a download link directly to a field in the event record. If I use the above method (Documents Table linked to Event Table) - I’ll be creating a record everytime a document is regenerated so I’ll wind up with multiple iterations of the same document linked to an Event record.