Multi-reference use in database

Ask the community
, ,
1

Hi, I’ve wix users database i.e. Private Members collection with the basic details. Now, for complete profile I’m going to use another collection. Instead of adding the redundant data, I would like to use basic details from the private members collection. I’ve checked the multi-reference wix documents but not helps me. Could you send your work or explain it. Please help me to link collections with common data i.e. EMAIL.

Thanks in advance.

2

Are you looking to do something like this?
https://support.wix.com/en/article/corvid-tutorial-building-your-own-members-area

Or something different?

There is an example in Wix Users API that you can use to work from for querying the Wix members app collection and getting the users info.
https://www.wix.com/corvid/reference/wix-users.html

How can I get the current user’s name?
Use the currentUser property to get the current user’s id. Then query the Members/PrivateMembersData collection for the item with that _id.

wixData.query("Members/PrivateMembersData") \
  .eq("_id", wixUsers.currentUser.id) \
  .find() \
  .then( (results) => { \
    lastName = results.items[0].lastName; \
  } );

Or look at this previous forum post.

However, if the user is currently logged in and you are using the Members/PrivateMembersData, then you can simply add a dataset element to your page and connect it to the Wix members collection.

Then just connect that user input or text box to the specific field from the dataset and as the user is already logged in, the dataset will be filtered for that user only and it will only display that users data.

Otherwise, you can use getCurrentItem() and set the user input or text box with that. getCurrentitem(); will return all the users data, if you want to just call a field then you need to be using getCurrentItem().fieldname;

If you autofill something like a user input, then it won’t recognise a value has been entered and if you tried to save it as is, then it would just return an empty value.

Therefore you would need to use the setFieldValue() or setFieldValues() with a submit button or the save() function in code to save your prefilled entries into the collection.

You can see an example here from Vorbly how to do it.
https://www.vorbly.com/Vorbly-Code/WIX-CODE-AUTO-FILL-FORM-WITH-USER-INPUTS

3

Sorry, I think you didn’t get my point. Here is the detailed information: -

I’ve a page named “Artsit”. Here all the profiles are fetched from “artistpages” db collection. As these are dynamic pages, so the clicking on the single artist a page open with the details of that artist.

Visitor: - can view the information only. No issues, working perfectly.
Member: - can view & edit the information only. This is the issues.

While the member is logged in, a button is shown to update details. But this button shows for all member. Any member can edit the profile of other member and that is the Issue.

Now, I’m registering the members in Wix Private Members collection first then the artist details in “artistpages” db collection. I want to make the user id of Wix Private Member common with the artist pages so that I can compare it show the update button to the person having the same Id.

If still anything unclear then please feel free to ask.