Hi!
I’m a bit of a newbie with Wix and I was wondering, is it possible to reference a 2nd field into a main collection?
Let me explain…
I have a collection which I named “Hosts”. In the Hosts collection, I have listed all the people’s names (in the title field) and in a second field I listed all of their email addresses.
In my main collection, I have a reference field labelled “Host name” which pulls in the name of the host from the Host collection… and then I also have another field in my main collection called “Host Email”…
I’m wondering how can I automatically pull the Host’s email address from the Host collection into my Main collection, based on the Host’s name that’s been pulled in.
Is that even possible and if so, how would you approach this?
Thank you in advance!
Hi @dina-kanarellis ,
It’s possible to get all the fields that are from the referenced collection, by using datasets or code.
For exact steps and examples, check this article about displaying content from multiple collections from the Wix help center
So I have a field already on my main collection that references the Host’s name, my issue is getting the field called Host Email" on my main collection to automatically populate with the email of the Host depending on whose name is chosen. I don’t want the Host Email to be displayed on an element, I just need it to populate in the data collection in the background.
My overall goal is to set up a system where a person checking in to my establishment, chooses their host’s name and when they submit the data form, the host will get an email notifying them their guest has arrived. I plan on using google sheets and zapier to set it up as I don’t see any other way. I just need the email to populate on the main collection in order to do this and I can’t seem to figure it out 