I have a Collection called Events that I wish to populate from a form.
On the form, I have added the ‘Event’ dataset and a ‘Branch’ dataset that stored a list of Venues where the event is held.
I have a Branch dataset which stores (in a multi reference field) the services that a Branch offers - one of them which could be ‘Venue’. I have added a MANUAL filter to the Branch Services dataset so that it filters for ‘Venue’ only.
I can’t seem to connect the drop down list to the Event dataset whilst also filtering the list to Venues only.
I have a drop down box which I have connected to the Branch dataset. I want this to only show a list of Venues in the drop down list and to populate the ‘Venue’ field of the Event when Submit is clicked.
