Using calculated columns you could achieve both (in a limited kind of
way).
Provided the naming convention is constant across your directory then
you could use one or more text conversion formulas to strip the domain/
component.
e.g. =RIGHT([ColumnName], LEN([ColumnName])-8) Will remove the first
7 characters from the value.
DOMAIN\john.smith -> john.smith
You can also explicitly declare the format for a datetime field.
e.g. ="The date is: "&TEXT(Today,"dd-mm-yyyy")
You can obviously do a lot more with a VS workflow.
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Crabbe, David
Sent: Thursday, 28 August 2008 6:23 PM
To: [email protected]
Subject: RE: [OzMOSS] Workflow Email Notifications
I'm afraid I have to agree with Clayton. There doesn't seem to be an
easy way to access the Name field associated with the Person or Group
column within the email action, or any other action for that matter.
________________________________
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Clayton James
Sent: Thursday, 28 August 2008 3:09 PM
To: [email protected]
Subject: RE: [OzMOSS] Workflow Email Notifications
Hi Anthony
The only way I was able to achieve this previously was to make a
calculated column in the list that looks at the DateTime column and
display only the date component. Then in your workflow use the
Calculated column instead.
As for displaying the users Fullname instead of their account name....I
am not sure.
Let me know if you find a solution.
cheers
Clayton James
________________________________
From: [EMAIL PROTECTED] on behalf of Anthony Lee
Sent: Thu 28/08/2008 2:16 PM
To: [email protected]
Subject: RE: [OzMOSS] Workflow Email Notifications
Workflow is built with Sharepoint Designer, via the Action "Send email".
Within the email, we are doing a lookup on the Created By field and Date
field. The Created By field returns the user's account. We however want
it to return the name of the user.
The Date field returns the date + 12:00:00AM and we only want the date
to appear in the email sent out via the workflow.
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Crabbe, David
Sent: Thursday, 28 August 2008 1:33 PM
To: [email protected]
Subject: RE: [OzMOSS] Workflow Email Notifications
Can you please indicate the type of workflow that you've set-up:
out-of-the-box (e.g. Three-state, Approval etc), one built via
SharePoint Designer or one built with WWF and Visual Studio?
________________________________
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Anthony Lee
Sent: Thursday, 28 August 2008 11:15 AM
To: [email protected]
Subject: [OzMOSS] Workflow Email Notifications
Hi all,
We have a workflow set up on a list, which sends an email to a
particular user. In the body of the email, we want to be able to display
the created by's user's Full Name instead of their account. Does anyone
know if that is possible, and if so how to do that?
Additionally does anyone know how to remove the timestamp in the
workflow email - we are doing a lookup of a date field which is set to
date only (no time), however in the email text generated from the
workflow, the timestamp is displayed?
Thanks.
-------------------------------------------------------------------
OzMOSS.com - to unsubscribe from this list, send a message back to the
list with 'unsubscribe' as the subject.
Powered by mailenable.com
This is an email from Fujitsu Australia Limited, ABN 19 001 011 427. It
is confidential to the ordinary user of the email address to which it
was addressed and may contain copyright and/or legally privileged
information. No one else may read, print, store, copy or forward all or
any of it or its attachments. If you receive this email in error, please
return to sender. Thank you.
If you do not wish to receive commercial email messages from Fujitsu
Australia Limited, please email [EMAIL PROTECTED]
-------------------------------------------------------------------
OzMOSS.com - to unsubscribe from this list, send a message back to the
list with 'unsubscribe' as the subject.
Powered by mailenable.com
-------------------------------------------------------------------
OzMOSS.com - to unsubscribe from this list, send a message back to the
list with 'unsubscribe' as the subject.
Powered by mailenable.com
-------------------------------------------------------------------
OzMOSS.com - to unsubscribe from this list, send a message back to the
list with 'unsubscribe' as the subject.
Powered by mailenable.com
____________________________________________________________________________
This e-mail is intended for the use of the addressed recipient(s) only and may
contain confidential and privileged information. If you have received this
message in error, please delete the message and any attachments and copies
immediately; and notify the sender by return e-mail.
Any views expressed in this message or any attachments are those of the
individual sender and do not necessarily represent the corporate opinion of the
Catholic Education Office (CEO), Sydney.
The CEO Privacy Policy is located at http://www.ceo.syd.catholic.edu.au
____________________________________________________________________________
------------------------------------------------------------------- OzMOSS.com
- to unsubscribe from this list, send a message back to the list with
'unsubscribe' as the subject.
Powered by mailenable.com
