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; 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? 🤔 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 🙏🙏 #corvid #multireference
![](https://static.wixstatic.com/media/a27d24_44449a5155e342cc90e7470814f7770b~mv2.png/v1/fill/w_49,h_35,al_c,q_85,usm_0.66_1.00_0.01,blur_2,enc_auto/a27d24_44449a5155e342cc90e7470814f7770b~mv2.png)
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