How to create reference field? Instruction very unclear

Ask the community
, , ,
1

Hi,
I tried to create reference fields in my database so that when users click on one item on the displayed table (that’s linked to a database), another item (image/text linked to another database) will change accordingly based on the selection.
I read the document about how to create reference field “Wix Support” multiple times. But I can’t work out how to do it.

It says “in the Content Manager” — which one is the “Content Manager” and how do you get to that?
Then it talks about “Set the field type to be Reference”, I have 2 datasets on the page, but can’t find anything about setup field type to be Reference. Then tried to change in the database design, as below screen dump, I tried to create a new field, but can’t find any “field type” option called “Reference”?

Can someone please provide some help/directioin please? Thanks

903×945 27.5 KB

2

Hi guys, I need this quite urgently, any update/hint please? Thanks

3

Hi,
It should be there, you are in the right place.
Can you please share a link to your site so we can inspect ?
Roi.

4

After I realised it actually works on Chrome of my home windows 7 laptop, but doesn’t work on Chrome of my work Laptop (also windows 7), did some further investigation and I think I found out why… drum rolls, please… I should get a bounty award for this…

Back in end of Feb I raised this issue about Wix Support Forum always shows “under maintenance” due to “third party cookies” been blocked (which is still not fixed yet!), see https://www.wix.com/code/home/forum/questions-answers/why-wixcode-forum-always-shows-under-maintenance-in-chrome

This “reference field” problem is caused by the same reason!!! “Block 3rd party cookies” setting in Chrome!!!

Tried on another Windows 7 machine and was able to reproduce the problem.
As shown below, if enable “blocked 3rd party cookies”, when right click on any field, the last part only has 2 options “Managed Properties” and “Move to Trash”

737×591 27.8 KB

If tried to change the field type, there are only 8 options, no “Reference”.

864×661 39.8 KB

Then with “block 3rd party cookies” disabled on the same chrome/website, as highlighted in red, extra “Set as Primary field” option is available in the middle.

745×577 29 KB

And when tried to change field type, we now have 9 options, with “Reference” shown at the top. The last one “Document” was accidentally chopped off - sorry…

705×631 33.1 KB

As below, my work laptop has the “Block third-party cookies” settings enabled in chrome and enforced by Windows AD group policy - which means I don’t have the access to change it… Damn, I can’t use my work laptop for my WIX development then…

1354×606 34 KB

So Wix guys, I know you always did a great job in fixing problem and issues. However this one definitely should get a lot more attention and higher priority. Because lots of your corporate users who unfortunately have the “block third-party cookies” enforced at work like me will either think that (1) your Wix Code Forum is always under maintenance, and/or (2) your “reference field” creation thing doesn’t work…

Please fix this asap or provide some alternative solution/work around…

Note: I would also strongly recommend to (1) update your “under maintenance” message to remind user to check if “block 3rd party” setting was enabled in browser, and (2) update the info on your “How to create a reference field” page Adding a Reference Field to a Database Collection | Help Center | Wix.com to check the same thing if can’t see the “Reference” field type.

5

Hi,
Thank you for your feedback.
We are inspecting in our side.
Roi.