How to use lastname of PrivateMembersData in other database

Ask the community
,
1

Hello

I would like to know how can use the lastname of the PrivateMembersData to put into a another database form ?

For example I’ve a form with two labels and I would like to put the last name of the member when the form is submitted.

thanks

2

If the site member is already logged in, then you can simply have a read only user input which is connected to the last name field from the Wix Members app own collection.
https://support.wix.com/en/article/corvid-wix-members-privatemembersdata-collection-fields#last-name-lastname

As it is site member specific, then only the actual logged in site member’s last name will be shown in that user input which you can also have as hidden on load so that it does not show to the user themselves.

Then you can simply include that user input when the user uses the submit button or you do it yourself through the Wix Dataset Save function

Otherwise, you can look at using the getCurrent Item function along with the setDieldValue function, so for example:

$w.onReady(function () {
$w("#input1").value = $w("#yourdataset").getCurrentItem().fieldName;
});

export function Submit_click(event, $w) {
$w('#yourdataset1').setFieldValue('lname', $w('#input1').value);
$w("#yourdataset1").save();
}

Finally, you can do it by just using Wix Users API and it is already provided there for you as a sample.
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;

.
So it would be something like this on your page.

import wixUsers from 'wix-users';

$w.onReady(function () {
});

let user = wixUsers.currentUser;

let userId = user.id;      
let isLoggedIn = user.loggedIn;

wixData.query("Members/PrivateMembersData")
  .eq("_id", wixUsers.currentUser.id)
  .find()
  .then( (results) => {
    lastName = results.items[0].lastName;
    //rest of your code below//
3

ok thanks,

so I managed to retrieve the data and display it in text labels how do I put it in a database ?

in other words how I put $w(‘#text21’).text = results.items[0].lastName; in my database ?

4

This is exactly what I have been trying to do for days.

I have a form for my “clubs” database. The users pick the club they want they sign up.

I am trying to get the “current user’s name” and add it to a “students” (multiple people) field in my “clubs” database. Without overriding the other “clubs” data fields.

I have used insert, it works but it deletes all the other names in the “students” field.

I have tried update but it didn’t work. Any Corvid Masters willing to give this a try?

5

Hello

I’m looking to do something similar, I would like to know how to query a Currenitem (dynamic dataset) to “filter” based on the title, so basically if the field already has a specific entry, it cant be duplicated for THAT ITEM!

this is what i came up with, but it isn’t working. I don’t want to use hooks.

$w.onReady( function () {
$w( “#input1” ).onChange((event, $w) => {
let ($w( “#teamDataset” ).getCurrentItem();
wixData.query( “reviews” )
.eq( ‘title’ , currentitem.title)
.find()
.then((results) => {
if (results.length > 0 ) {
//id is not unique. show error and disable submit button
$w( ‘#button34’ ).disable();
wixWindow.openLightbox( “Oops” );
} else {
//id is unique. do nothing
}
}). catch ((err) => {
let errorMsg = err;
});
});

So the following code works, but the problem is it “filters” according to the field key, for all the items, and not just the current item.

$w.onReady( function () {
$w( “#input1” ).onChange((event, $w) => {
wixData.query( “reviews” )
.eq( ‘title’ , event.target.value)
.find()
.then((results) => {
if (results.length > 0 ) {
//id is not unique. show error and disable submit button
$w( ‘#button34’ ).disable();
wixWindow.openLightbox( “Oops” );
} else {
//id is unique. do nothing
}
}). catch ((err) => {
let errorMsg = err;
});
});
});