Changing the PrivateMembersData main field

HI folks,

When I created my PrivateMembersData database I read that I should use the member’s Email Address as the “Main Field”. This doesn’t work for me because when I try to use the members’s Email Address as a reference field in other databases I can’t always identify the Member by their Email Address.

I was wondering if this might work:

  1. “Export Data to File” from WIX PrivateMembersData as a CSV file
  2. Delete all the content in the WIX PrivateMembersData
  3. Will it then let me change the “Main Field” to Name?
  4. Will I be able to then “Import Data From File” using the CSV file?

Thanking you in advance,
Sylvia

You can only read from the PrivateMembersData collection:
https://support.wix.com/en/article/corvid-wix-members-privatemembersdata-collection-fields
https://support.wix.com/en/article/corvid-wix-members-privatemembersdata-collection-fields#login-email-loginemail480

To use it in your code you need to use “Members/PrivateMembersData” and not simply “PrivateMembersData”.

instead of using the email address field, which in theory could be used multiple times if you don’t search/check for duplicates, in cases like this it is better to use a different field called “Owner”.

You can find it the same way as the “ID” and its purpose is to link between all of the items that belongs to the same user who submitted/own them.

Although, just note that the “ID” field in the Members collection is the same as the “Owner” field in all other collections.
https://support.wix.com/en/article/about-your-database-collection-fields#system-fields
https://www.wix.com/corvid/reference/wix-users.User.html#id
https://support.wix.com/en/article/corvid-wix-members-privatemembersdata-collection-fields#id-_id

Thank you so much, I just saw this I must have to change my notification settings to get comments emailed to me.

@1425club66601

What comments emailed back to you, if you are wanting a reply from any user input form then simply use Wix Automations or use a triggered email on form submission.
https://support.wix.com/en/ascend-by-wix/wix-automations
https://support.wix.com/en/article/corvid-tutorial-sending-a-triggered-email-to-members
https://support.wix.com/en/article/corvid-tutorial-sending-a-triggered-email-to-contacts
https://support.wix.com/en/article/corvid-tutorial-sending-an-email-on-form-submission