I have a “membersprivatedata” table that is created from a members form and a “usergenerateddata” table each member creates by filling in a form I made. In the membersprivatedata table the system generates an ID called “contactid” and in the user generated data there is a system generated ID called “owner”…both of these are the same. How do I link these two tables on those fields? This should be a simple “key” connection so I can pull data from both data sets using that key identifier however I can’t seem to figure out how to do it without writing code (I’m not a programmer). A reference field won’t work since this is user generated data and I’m not going to go into the data base and manually create a connection one line at a time.
Thank for any help.
David
So basically you are using the Wix Members app which automatically adds the Members/PrivateMembersData collection to your site.
https://support.wix.com/en/article/corvid-wix-members-privatemembersdata-collection-fields
Along with your own dataset from a member profile page like in this tutorial here.
https://support.wix.com/en/article/corvid-tutorial-building-your-own-members-area
Then yes the ID (_id) field (don’t use the Contact ID field) in the Wix Members app collection …
ID (_id)
Description : The member ID that was created by the server. This is a system field and is hidden by default.
Type : Text
Can connect to data : Yes
Can use in dynamic page URL : Yes
Read-only : Yes
Along with the Owner (_owner) field in your own dataset…
Field Name Owner
Field Key _owner
Field Type Text
Description A unique identifier for the creator of the item. Used by the permissions model to determine which user is assigned the Site member author role for the item.
https://support.wix.com/en/article/about-your-database-collection-fields#system-fields
They are both the same exact field and hence why you are getting the same value in both datasets.
Have you actually read the Wix Support pages about using reference fields to display content from multiple datasets as you don’t need to use code to do it.
https://support.wix.com/en/article/about-reference-fields-in-database-collections
https://support.wix.com/en/article/displaying-content-from-multiple-database-collections-using-reference-fields
https://support.wix.com/en/article/displaying-content-from-multiple-database-collections-using-reference-fields-4034931
https://support.wix.com/en/article/about-displaying-database-content-in-a-table-or-gallery#2-connecting-one-database-collection-with-reference-fields-to-a-table
https://support.wix.com/en/article/working-with-multiple-item-reference-fields
https://support.wix.com/en/article/about-referencing-multiple-items-in-one-field
I have and it seems that everything starts with creating the reference field between two data sets…after that everything is easy. So my question is…Is this the only way to make the connection from one data set to another:
"Step 3 | Fill in the Reference Field Data in the Main Collection
Double-click each cell in the Reference field column in the main collection.Select the item you want from the list. (The list displays the data in the main field of the referenced collection.)"
If I read this correctly I have to manually make the connection using the drop down of the reference field column to connect to the column of the referenced collection. This won’t work with user generated data that I need to know who created it.
It would seem that the owner is already a reference field that would otherwise connect these collections. Wonder why it is not treated as a reference field as that would make our lives easy?
wix is such a rudimentary platform and I am repeatably shocked by its limitations.