tag:blogger.com,1999:blog-1088154180376946156.post7053470812237755299..comments2020-12-01T21:58:36.860-05:00Comments on chiqnlips sharepoint blog: SPD Workflow: Display Full Name Instead of Domain\usernamechiqnlipshttp://www.blogger.com/profile/11265743292603389622noreply@blogger.comBlogger17125tag:blogger.com,1999:blog-1088154180376946156.post-3667485239583882272009-09-17T11:01:56.284-04:002009-09-17T11:01:56.284-04:00well, arun, you're only going to be able retri...well, arun, you're only going to be able retrieve and manipulate the userid part of the domain\UserID. fortunately, in my case, my organization's policy on userid is firstname.lastname. if yours is not in that format then you will need to manipulate the userid string of data that benefits you most, or this solution may not benefit you at all. unfortunately, you are limited by the data you are given. good luck!chiqnlipshttps://www.blogger.com/profile/11265743292603389622noreply@blogger.comtag:blogger.com,1999:blog-1088154180376946156.post-33130493654602318832009-09-17T08:49:48.670-04:002009-09-17T08:49:48.670-04:00Hi,
I have created a column called HCreated(Singl...Hi,<br /><br />I have created a column called HCreated(Single Line) and through the SPD WF im assigning the CReated By value to new Colum ,here in new column is filled with domain\UserID<br /><br />How can i mirror or how will i get the full UserName<br /><br />ThanksAnonymoushttps://www.blogger.com/profile/11740595651759443767noreply@blogger.comtag:blogger.com,1999:blog-1088154180376946156.post-1685852652990798322009-09-17T07:43:35.228-04:002009-09-17T07:43:35.228-04:00arun, i haven't tried it but i assume the same...arun, i haven't tried it but i assume the same step (1) to create a mirror for the the person or group column might work for the created by and modified by columns. if you try it please let us know the outcome.chiqnlipshttps://www.blogger.com/profile/11265743292603389622noreply@blogger.comtag:blogger.com,1999:blog-1088154180376946156.post-17872580390353485312009-09-17T02:30:34.651-04:002009-09-17T02:30:34.651-04:00how will you create mirror column for the Created...how will you create mirror column for the Created By column?Anonymoushttps://www.blogger.com/profile/11740595651759443767noreply@blogger.comtag:blogger.com,1999:blog-1088154180376946156.post-71952087477027605072009-05-27T21:05:57.893-04:002009-05-27T21:05:57.893-04:00michael,
apologies for the delay...just follow ste...michael,<br />apologies for the delay...just follow steps 1 and 3 to mirror a column.chiqnlipshttps://www.blogger.com/profile/11265743292603389622noreply@blogger.comtag:blogger.com,1999:blog-1088154180376946156.post-80598899139969923472009-05-20T10:58:38.669-04:002009-05-20T10:58:38.669-04:00Ok, how do you mirror the Person or Group column?Ok, how do you mirror the Person or Group column?Michaelhttps://www.blogger.com/profile/16620802300116943398noreply@blogger.comtag:blogger.com,1999:blog-1088154180376946156.post-56131118161817281682009-03-25T05:14:00.000-04:002009-03-25T05:14:00.000-04:00Hi,When I create a workflow for copying the value ...Hi,<BR/>When I create a workflow for copying the value from People and Groups field into a text field, it copies domain\username for some reason. So basically I do't have anything useful to extract in the formula step.. <BR/>Does anyone has an idea how to workaround this?<BR/>Many thanks,<BR/>ErikErikhttps://www.blogger.com/profile/08485470046813999491noreply@blogger.comtag:blogger.com,1999:blog-1088154180376946156.post-37006365465992399612009-03-13T12:58:00.000-04:002009-03-13T12:58:00.000-04:00masood,Thanks for your comment! What you see in y...masood,<BR/>Thanks for your comment! What you see in your Resource column is the display name from your LDAP. I do not know of a way to get that info from LDAP via WSS. My solution simply manipulates the information available to me. My company keeps its user accounts in the format firstname.lastname and I could parse that to get useful information (firstname & lastname). If your company keeps its user accounts in a different format (first initial + lastname) then you will need to modify the string manipulation formula above accordingly. You should be able to retrieve J Doe from domain\JDoe. Unfortunately, that's the best you will be able to do. But fortunately, you can at least do that! Hope this helps.chiqnlipshttps://www.blogger.com/profile/11265743292603389622noreply@blogger.comtag:blogger.com,1999:blog-1088154180376946156.post-21814784498161182382009-03-13T10:08:00.000-04:002009-03-13T10:08:00.000-04:00Great idea.I have a column name "Resource" type Pe...Great idea.<BR/>I have a column name "Resource" type Person or Group. I created another column as "Copy of Resource" type as single line text.<BR/>I created workflow and copy the user name from "Resource" to "Copy of Resource" column.<BR/>In "Resource" column name are displayed as LastName, FirstName i.e Doe, Joe but after copy the name in "Copy of Resource" column now name are displaying as domain\JDoe. Now question is how can I get name as Doe, Joe ?<BR/><BR/>Thanks<BR/>MasUnknownhttps://www.blogger.com/profile/13465346918129331485noreply@blogger.comtag:blogger.com,1999:blog-1088154180376946156.post-81861338254570057072009-01-08T09:27:00.000-05:002009-01-08T09:27:00.000-05:00Very creative use of calculated columns. You can a...Very creative use of calculated columns. You can also achieve the same result using custom SPD workflow activities from CodePlex. Just blogged about it earlier today:<BR/>http://sharepointapplied.wordpress.com/2009/01/08/get-full-name-in-sharepoint-designer-workflow/<BR/><BR/><BR/>Good luck with your blog!<BR/>Greg OsimowiczAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-1088154180376946156.post-66264297531516021092008-12-29T13:59:00.000-05:002008-12-29T13:59:00.000-05:00fromonesource,Your summary is a nice suggestion. ...fromonesource,<BR/>Your summary is a nice suggestion. Thanks for adding your comment! I am certain I will be reviewing your blog again if my organization upgrades from WSS 3.0 as it looks like this solution only works with MOSS.chiqnlipshttps://www.blogger.com/profile/11265743292603389622noreply@blogger.comtag:blogger.com,1999:blog-1088154180376946156.post-32343393388301627912008-12-29T11:41:00.000-05:002008-12-29T11:41:00.000-05:00I did a quick summary of how to do this using Info...I did a quick summary of how to do this using InfoPath and web services: http://surepoint.wordpress.com/2008/12/29/get-users-full-name-in-infopath-using-sharepoint-profile-web-service/<BR/><BR/>I imagine it could be done with a custom coded column as well.fromonesourcehttps://www.blogger.com/profile/09411905142752376982noreply@blogger.comtag:blogger.com,1999:blog-1088154180376946156.post-65056539692206116872008-12-27T10:32:00.000-05:002008-12-27T10:32:00.000-05:00ma zhe,The workflow is simply used to update the h...ma zhe,<BR/>The workflow is simply used to update the hiddenColumn with a working value of the "Person or Group" column. Then you use the string function formulas in calculated columns (First Name, Last Name, Full Name) to parse the respective parts of the domain\user.name value in the hiddenColumn.<BR/><BR/>You are correct that my organization uses the firstname.lastname user account format. If your organization only uses 3 letters for a user account then that is all you will be able to extract.<BR/><BR/>Hope this helps!chiqnlipshttps://www.blogger.com/profile/11265743292603389622noreply@blogger.comtag:blogger.com,1999:blog-1088154180376946156.post-37356395984627216962008-12-26T09:25:00.000-05:002008-12-26T09:25:00.000-05:00my doman user name like: doman\use(3 letters)i gue...my doman user name like: doman\use(3 letters)<BR/>i guess your doman user name like this: doman\user.name , can you help me with my state?Ma Zhehttps://www.blogger.com/profile/01416623116192538095noreply@blogger.comtag:blogger.com,1999:blog-1088154180376946156.post-91733775867071996882008-12-26T06:19:00.000-05:002008-12-26T06:19:00.000-05:00hi Kevin,I have watched this video about Run a wor...hi Kevin,<BR/><BR/>I have watched this video about Run a workflow when a specific field changes, but I do not know how to get and convert the Full Name to text string value via workflow, can you give me any help or comments? thank you very much!!!Ma Zhehttps://www.blogger.com/profile/01416623116192538095noreply@blogger.comtag:blogger.com,1999:blog-1088154180376946156.post-73430176175694145382008-12-24T11:24:00.000-05:002008-12-24T11:24:00.000-05:00Thanks! YAY, finally!!!Thanks! YAY, finally!!!Laura Derbes Rogershttps://www.blogger.com/profile/10696495598981317546noreply@blogger.comtag:blogger.com,1999:blog-1088154180376946156.post-24908962848608886362008-12-24T06:54:00.000-05:002008-12-24T06:54:00.000-05:00Great idea! Thanks for sharing.--Paul Galvin @ ht...Great idea! Thanks for sharing.<BR/><BR/>--Paul Galvin @ http://paulgalvin.spaces.live.comPaul J. Galvinhttps://www.blogger.com/profile/08376170201728568783noreply@blogger.com