Hi Guys, I really need some help!
What’s the best way to submit information to a ‘Multi Reference’ field in a database collection?
Here’s the scenario;
I have an employer portal that allows employers from different ‘companies’ to upload ‘documents’.
The portal uses datasets to filter the information based on the logged-in user (using code to find out the ‘User Role’ which translates into the ‘Company’ they work for e.g. user role = EY, company name = EY).
Essentially - users only see the documents that relate to their company.
I have a database for ‘Companies’ and another for ‘Important Documents’. Important documents has a multi-reference relationship with companies and vice versa.
I want employers to be able to upload new documents to the portal, but I can’t see how to populate the multi-reference field so that;
- A worker from EY uploads a document
- The multi-reference field auto populates with the company name based on their user role
- Allowing the user to submit and the document to auto-appear based on the dataset filters
Does that make sense?
I’ve tried a number of coding options, but this multi-reference piece has got me stumped (although I’m no coding expert).
I need this fix fairly urgently, but I’d also like to get some ongoing mentoring & consultancy from a coding expert (paid of course) for ongoing development.
If you can help / recommend an expert, please comment below. Thank you