Collection with Reference Field and Dyn. Page with Dropdown

Imagine the following situation: there is one collection with all employees and one with all companies. Employee does have a field with the name “company” of the type Reference. This is working pretty well in the Collection directly.

Now i want to add a form on a Dynamic Page in order to create new employees. I do have two Datasets configured on the page for both collections. I’ve added a dropdown user input field as well. I’m now able to have a dropdown listing all companies but i cannot set the selected company on the new user. The target field in “Value connects to” is not selectable.

What am I doing wrong?

Hi,
I recommend checking out our cascading form example here . In this example, there’s a change of the dropdown options based on a previous selection. Note that you can use the query( ) function to get all the relevant records and set it to the dropdown instead of connecting it to the dropdown using the editor. This way, you’ll be able to filter the irrelevant records.

I hope it makes sense.

Good luck,
Tal.

Thank you for the fast reply. This looks like it migth work… But somehow its looks like a workaround. Looks like References are not fully supported in Wix.

It depends how you manipulate the Json object. Should the issue persists, please add the code added to your site and we’ll have a look.

Have a great day,
Tal.