How do I submit information to a 'Multi Reference' field in a database collection?

Hi Guys, I really need some help! :pray::pray:

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;

  1. A worker from EY uploads a document
  2. The multi-reference field auto populates with the company name based on their user role
  3. Allowing the user to submit and the document to auto-appear based on the dataset filters

Does that make sense? :thinking:

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 :pray::pray:

#corvid #multireference

Have a look at the Wix Data API and the insertReference, replaceReference and the removeReference functions.
https://www.wix.com/corvid/reference/wix-data.html

As for looking for help, you can take a look through the Wix Marketplace.
https://www.wix.com/marketplace