Page 1 of 1

Regarding sharepoint gridview quick edit update field on change

Posted: 19 Jun 2017
by WinstonFroidPinto
Hi,
I have a related item(quick edit) with two fields name and designation. Name is a people picker field field on change of that field i want to display his designation by querying user profiles.How can this be done??I have referred the following articles:

1. https://www.spjeff.com/2014/05/17/quick ... rendering/
2. https://www.codeproject.com/Articles/81 ... ith-JSGrid

Drawback of link 1 is that the value is not set in the field but just shown.
Link 2 does update the designation field but on change only email and display name is returned by the event and all the methods expect account name to query user profile service.

Regards,
Winston.

Re: Regarding sharepoint gridview quick edit update field on change

Posted: 19 Jun 2017
by Dmitry Kozlov
Hi,

You can resolve login by e-mail address:
https://stackoverflow.com/questions/311 ... ject-model

And then use the login to retrieve profile properties:
https://dev.office.com/sharepoint/docs/ ... t-model-in

Re: Regarding sharepoint gridview quick edit update field on change

Posted: 23 Jun 2017
by WinstonFroidPinto
Hi,

Tried it for sharepoint 2016 it works, but on 2013 environment on change of people pickeri am able to retrieve just the display name on the basis of which querying user profile is not possible.Any method which returns me all user properties of the changed value of people picker of current record in the quick edit mode so i can query user profiles and set the another field accordingly?

In short when i chose a user,his designation should be shown on quick edit.Please suggest any other methods if applicable.



Regards,
Winston.

Re: Regarding sharepoint gridview quick edit update field on change

Posted: 23 Jun 2017
by Dmitry Kozlov
Hi,
Here is the code retrieving an e-mail address of the selected user:

Code: Select all

fd.field('User').value()[0].EntityData.Email

Re: Regarding sharepoint gridview quick edit update field on change

Posted: 27 Jun 2017
by WinstonFroidPinto
Hi,

The above code works fine if people picker control is part of the form. I actually have a people control inside related items and want to fetch email id of the person entered there if a person is selected from quick edit mode(sharepoint 2013) and set his designation which is another field in related item.

Re: Regarding sharepoint gridview quick edit update field on change

Posted: 27 Jun 2017
by Dmitry Kozlov
Our support team can assist you with the task. If you're interested, send the detailed requirements with screeshot of profile properties and list settings to support@spform.com and we will estimate them in support hours.