Regarding sharepoint gridview quick edit update field on change

Discussions about Forms Designer for SharePoint 2013 / 2016 and Office 365.
Locked
User avatar
WinstonFroidPinto
Posts: 32
Joined: Thu Mar 16, 2017

19 Jun 2017

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.

User avatar
Dmitry Kozlov
Site Admin
Posts: 1524
Joined: Thu Jun 07, 2012

19 Jun 2017

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

User avatar
WinstonFroidPinto
Posts: 32
Joined: Thu Mar 16, 2017

23 Jun 2017

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.

User avatar
Dmitry Kozlov
Site Admin
Posts: 1524
Joined: Thu Jun 07, 2012

23 Jun 2017

Hi,
Here is the code retrieving an e-mail address of the selected user:

Code: Select all

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

User avatar
WinstonFroidPinto
Posts: 32
Joined: Thu Mar 16, 2017

27 Jun 2017

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.
Attachments
screenshot.png
screenshot.png (4.3 KiB) Viewed 3386 times

User avatar
Dmitry Kozlov
Site Admin
Posts: 1524
Joined: Thu Jun 07, 2012

27 Jun 2017

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.

Locked
  • Information
  • Who is online

    Users browsing this forum: No registered users and 3 guests