Nintex Forms & Sharepoint Column Validations - Email Address

Email is the one field that has started coming up in most of my forms and a validation for this field is really important when there is a workflow associated with this field.

SharePoint 2010, SP2013 :

Formula :

=AND(     ISERROR(FIND(" ", [Email],1)),     IF(ISERROR(FIND("@", [Email],2)),         FALSE,         AND(             ISERROR(FIND("@",[Email], FIND("@", [Email],2)+1)),             IF(ISERROR(FIND(".", [Email], FIND("@", [Email],2)+2)),                 FALSE,                 FIND(".", [Email], FIND("@", [Email],2)+2) < LEN([Email])             )         )     ) )

Replace [Email] with your list column name and paste this formula in the column validations section.

 

 

The basic rules being enforced here are:

• Email contains No Spaces
• Email should have only 1 @ symbol
• @ symbol cannot be the first character
• Should have at least 1 . after the @ symbol
• Should have at least 1 character between the @ and the .
• Email Field cannot have the last character as the .

Nintex Forms :

I started working on Nintex forms recently and its been a cake walk. Its super easy and simple and I will have a dedicated blog on Nintex forms as well shortly.

 

Meanwhile, if you have validations in your SharePoint columns and have a Nintex form associated with it the validations do not appear in the Nintex form.

 

Nintex form has controls which have huge capabilities

 

In the validation section choose regex : \b[a-zA-Z0-9._%+-]+@[a-zA-Z0-9.-]+\.[a-zA-Z]{2,4}\b

 

Happy Coding!

Whats in a List / Field name ??

A lot of times we need to find the ID aka Guid of a list, and I have always used the below .. but another trick came in handy which I wish to share with everyone..

• Navigate to the SharePoint list using the browser.
• Select the List Settings on the ribbon.
• Copy the Url from the address bar

 

 

http:///_layouts/listedit.aspx?List=%7BB5563F8B%2D3DC6%2D4BC8%2DA065%2DCDAAAE85F78D%7D

 

What is relevant to us is the content after List =

• Replace %7B with }
• Replace all  %2D with -
• Replace %7D with }

You are now left with the Id:
{B5563F8B-3DC6-4BC8-A065-CDAAAE85F78D}

Alternate way :

Another way I found today was to go to List or Library settings as described above, then right-click on the “Audience targeting settings” or “Information management policy settings” links and choose Copy Shortcut.

 
 
 

Also, we need the field’s internal names for CAML query or reference inside our code for various purposes. Here's a quick and easy way to find that.

 

Via Code :

You can find the internal name using code by using the below.

Ex: string internalName = item.Fields["Field Display Name"].InternalName;

Via SP UI
 

• Go to Settings-> List Settings -> Click on the Column listed in the Lists to which you have to find the Internal Name

 

 
  

• Scroll down on page to Columns section
•  In the list of Columns, click on the field name whose internal name you need to find
• In the address bar of the browser and look for the querystring part:

?List=%7BB5563F8B%2D3DC6%2D4BC8%2DA065%2DCDAAAE85F78D%7D&Field=Title

• Then look for the '&Field='

&Field=Title

If the column name contains spaces then the Internal Name will contain some other characters. Here's a trick to get the internal name : 
 

?List=%7BB5563F8B%2D3DC6%2D4BC8%2DA065%2DCDAAAE85F78D%7D&Field=Group%5Fx0020%5FBy%5Fx0020%5FInfo

&Field=Group%5Fx0020%5FBy%5Fx0020%5FInfo

• Replace %5F with _

&Field=Group_x0020_By_x0020_Info

Much used reprinting of list of fields with internal names for easy reference:

Document Library fields

Display Name	Internal Name	GUID	Type
ID	ID	{1d22ea11-1e32-424e-89ab-9fedbadb6ce1}	Counter
Content Type ID	ContentTypeId	{03e45e84-1992-4d42-9116-26f756012634}	ContentTypeId
Content Type	ContentType	{c042a256-787d-4a6f-8a8a-cf6ab767f12d}	Text
Created	Created	{8c06beca-0777-48f7-91c7-6da68bc07b69}	DateTime
Created By	Author	{1df5e554-ec7e-46a6-901d-d85a3881cb18}	User
Modified	Modified	{28cf69c5-fa48-462a-b5cd-27b6f9d2bd5f}	DateTime
Modified By	Editor	{d31655d1-1d5b-4511-95a1-7a09e9b75bf2}	User
Has Copy Destinations	_HasCopyDestinations	{26d0756c-986a-48a7-af35-bf18ab85ff4a}	Boolean
Copy Source	_CopySource	{6b4e226d-3d88-4a36-808d-a129bf52bccf}	Text
Approval Status	_ModerationStatus	{fdc3b2ed-5bf2-4835-a4bc-b885f3396a61}	ModStat
Approver Comments	_ModerationComments	{34ad21eb-75bd-4544-8c73-0e08330291fe}	Note
URL Path	FileRef	{94f89715-e097-4e8b-ba79-ea02aa8b7adb}	Lookup
Path	FileDirRef	{56605df6-8fa1-47e4-a04c-5b384d59609f}	Lookup
Modified	Last_x0020_Modified	{173f76c8-aebd-446a-9bc9-769a2bd2c18f}	Lookup
Created	Created_x0020_Date	{998b5cff-4a35-47a7-92f3-3914aa6aa4a2}	Lookup
File Size	File_x0020_Size	{8fca95c0-9b7d-456f-8dae-b41ee2728b85}	Lookup
Item Type	FSObjType	{30bb605f-5bae-48fe-b4e3-1f81d9772af9}	Lookup
Effective Permissions Mask	PermMask	{ba3c27ee-4791-4867-8821-ff99000bac98}	Computed
ID of the User who has the item Checked Out	CheckedOutUserId	{a7b731a3-1df1-4d74-a5c6-e2efba617ae2}	Lookup
Is Checked out to local	IsCheckedoutToLocal	{cfaabd0f-bdbd-4bc2-b375-1e779e2cad08}	Lookup
Checked Out To	CheckoutUser	{3881510a-4e4a-4ee8-b102-8ee8e2d0dd4b}	User
Name	FileLeafRef	{8553196d-ec8d-4564-9861-3dbe931050c8}	File
Unique Id	UniqueId	{4b7403de-8d94-43e8-9f0f-137a3e298126}	Lookup
ProgId	ProgId	{c5c4b81c-f1d9-4b43-a6a2-090df32ebb68}	Lookup
ScopeId	ScopeId	{dddd2420-b270-4735-93b5-92b713d0944d}	Lookup
Virus Status	VirusStatus	{4a389cb9-54dd-4287-a71a-90ff362028bc}	Lookup
Checked Out To	CheckedOutTitle	{9d4adc35-7cc8-498c-8424-ee5fd541e43a}	Lookup
Check In Comment	_CheckinComment	{58014f77-5463-437b-ab67-eec79532da67}	Lookup
Checked Out To	LinkCheckedOutTitle	{e2a15dfd-6ab8-4aec-91ab-02f6b64045b0}	Computed
Document Modified By	Modified_x0020_By	{822c78e3-1ea9-4943-b449-57863ad33ca9}	Text
Document Created By	Created_x0020_By	{4dd7e525-8d6b-4cb4-9d3e-44ee25f973eb}	Text
File Type	File_x0020_Type	{39360f11-34cf-4356-9945-25c44e68dade}	Text
HTML File Type	HTML_x0020_File_x0020_Type	{0c5e0085-eb30-494b-9cdd-ece1d3c649a2}	Text
Source Url	_SourceUrl	{c63a459d-54ba-4ab7-933a-dcf1c6fadec2}	Text
Shared File Index	_SharedFileIndex	{034998e9-bf1c-4288-bbbd-00eacfc64410}	Text
Edit Menu Table Start	_EditMenuTableStart	{3c6303be-e21f-4366-80d7-d6d0a3b22c7a}	Computed
Edit Menu Table End	_EditMenuTableEnd	{2ea78cef-1bf9-4019-960a-02c41636cb47}	Computed
Name	LinkFilenameNoMenu	{9d30f126-ba48-446b-b8f9-83745f322ebe}	Computed
Name	LinkFilename	{5cc6dc79-3710-4374-b433-61cb4a686c12}	Computed
Type	DocIcon	{081c6e4c-5c14-4f20-b23e-1a71ceb6a67c}	Computed
Server Relative URL	ServerUrl	{105f76ce-724a-4bba-aece-f81f2fce58f5}	Computed
Encoded Absolute URL	EncodedAbsUrl	{7177cfc7-f399-4d4d-905d-37dd51bc90bf}	Computed
Name	BaseName	{7615464b-559e-4302-b8e2-8f440b913101}	Computed
File Size	FileSizeDisplay	{78a07ba4-bda8-4357-9e0f-580d64487583}	Computed
Property Bag	MetaInfo	{687c7f94-686a-42d3-9b67-2782eac4b4f8}	Lookup
Level	_Level	{43bdd51b-3c5b-4e78-90a8-fb2087f71e70}	Integer
Is Current Version	_IsCurrentVersion	{c101c3e7-122d-4d4d-bc34-58e94a38c816}	Boolean
Select	SelectTitle	{b1f7969b-ea65-42e1-8b54-b588292635f2}	Computed
Select	SelectFilename	{5f47e085-2150-41dc-b661-442f3027f552}	Computed
Edit	Edit	{503f1caa-358e-4918-9094-4a2cdc4bc034}	Computed
owshiddenversion	owshiddenversion	{d4e44a66-ee3a-4d02-88c9-4ec5ff3f4cd5}	Integer
UI Version	_UIVersion	{7841bf41-43d0-4434-9f50-a673baef7631}	Integer
Version	_UIVersionString	{dce8262a-3ae9-45aa-aab4-83bd75fb738a}	Text
Instance ID	InstanceID	{50a54da4-1528-4e67-954a-e2d24f1e9efb}	Integer
Order	Order	{ca4addac-796f-4b23-b093-d2a3f65c0774}	Number
GUID	GUID	{ae069f25-3ac2-4256-b9c3-15dbc15da0e0}	Guid
Workflow Version	WorkflowVersion	{f1e020bc-ba26-443f-bf2f-b68715017bbc}	Integer
Workflow Instance ID	WorkflowInstanceID	{de8beacf-5505-47cd-80a6-aa44e7ffe2f4}	Guid
Source Version (Converted Document)	ParentVersionString	{bc1a8efb-0f4c-49f8-a38f-7fe22af3d3e0}	Lookup
Source Name (Converted Document)	ParentLeafName	{774eab3a-855f-4a34-99da-69dc21043bec}	Lookup
Title	Title	{fa564e0f-0c70-4ab9-b863-0177e6ddd247}	Text
Template Link	TemplateUrl	{4b1bf6c6-4f39-45ac-acd5-16fe7a214e5e}	Text
Html File Link	xd_ProgID	{cd1ecb9f-dd4e-4f29-ab9e-e9ff40048d64}	Text
Is Signed	xd_Signature	{fbf29b2d-cae5-49aa-8e0a-29955b540122}	Boolean
Merge	Combine	{e52012a0-51eb-4c0c-8dfb-9b8a0ebedcb6}	Computed
Relink	RepairDocument	{5d36727b-bcb2-47d2-a231-1f0bc63b7439}	Computed

 

 Custom list fields 

Display Name	Internal Name	GUID	Type
ID	ID	{1d22ea11-1e32-424e-89ab-9fedbadb6ce1}	Counter
Content Type ID	ContentTypeId	{03e45e84-1992-4d42-9116-26f756012634}	ContentTypeId
Content Type	ContentType	{c042a256-787d-4a6f-8a8a-cf6ab767f12d}	Text
Title	Title	{fa564e0f-0c70-4ab9-b863-0177e6ddd247}	Text
Modified	Modified	{28cf69c5-fa48-462a-b5cd-27b6f9d2bd5f}	DateTime
Created	Created	{8c06beca-0777-48f7-91c7-6da68bc07b69}	DateTime
Created By	Author	{1df5e554-ec7e-46a6-901d-d85a3881cb18}	User
Modified By	Editor	{d31655d1-1d5b-4511-95a1-7a09e9b75bf2}	User
Has Copy Destinations	_HasCopyDestinations	{26d0756c-986a-48a7-af35-bf18ab85ff4a}	Boolean
Copy Source	_CopySource	{6b4e226d-3d88-4a36-808d-a129bf52bccf}	Text
owshiddenversion	owshiddenversion	{d4e44a66-ee3a-4d02-88c9-4ec5ff3f4cd5}	Integer
Workflow Version	WorkflowVersion	{f1e020bc-ba26-443f-bf2f-b68715017bbc}	Integer
UI Version	_UIVersion	{7841bf41-43d0-4434-9f50-a673baef7631}	Integer
Version	_UIVersionString	{dce8262a-3ae9-45aa-aab4-83bd75fb738a}	Text
Attachments	Attachments	{67df98f4-9dec-48ff-a553-29bece9c5bf4}	Attachments
Approval Status	_ModerationStatus	{fdc3b2ed-5bf2-4835-a4bc-b885f3396a61}	ModStat
Approver Comments	_ModerationComments	{34ad21eb-75bd-4544-8c73-0e08330291fe}	Note
Edit	Edit	{503f1caa-358e-4918-9094-4a2cdc4bc034}	Computed
Title	LinkTitleNoMenu	{bc91a437-52e7-49e1-8c4e-4698904b2b6d}	Computed
	LinkFilenameNoMenu
Title	LinkTitle	{82642ec8-ef9b-478f-acf9-31f7d45fbc31}	Computed
Select	SelectTitle	{b1f7969b-ea65-42e1-8b54-b588292635f2}	Computed
Instance ID	InstanceID	{50a54da4-1528-4e67-954a-e2d24f1e9efb}	Integer
Order	Order	{ca4addac-796f-4b23-b093-d2a3f65c0774}	Number
GUID	GUID	{ae069f25-3ac2-4256-b9c3-15dbc15da0e0}	Guid
Workflow Instance ID	WorkflowInstanceID	{de8beacf-5505-47cd-80a6-aa44e7ffe2f4}	Guid
URL Path	FileRef	{94f89715-e097-4e8b-ba79-ea02aa8b7adb}	Lookup
Path	FileDirRef	{56605df6-8fa1-47e4-a04c-5b384d59609f}	Lookup
Modified	Last_x0020_Modified	{173f76c8-aebd-446a-9bc9-769a2bd2c18f}	Lookup
Created	Created_x0020_Date	{998b5cff-4a35-47a7-92f3-3914aa6aa4a2}	Lookup
Item Type	FSObjType	{30bb605f-5bae-48fe-b4e3-1f81d9772af9}	Lookup
Effective Permissions Mask	PermMask	{ba3c27ee-4791-4867-8821-ff99000bac98}	Computed
Name	FileLeafRef	{8553196d-ec8d-4564-9861-3dbe931050c8}	File
Unique Id	UniqueId	{4b7403de-8d94-43e8-9f0f-137a3e298126}	Lookup
ProgId	ProgId	{c5c4b81c-f1d9-4b43-a6a2-090df32ebb68}	Lookup
ScopeId	ScopeId	{dddd2420-b270-4735-93b5-92b713d0944d}	Lookup
File Type	File_x0020_Type	{39360f11-34cf-4356-9945-25c44e68dade}	Text
HTML File Type	HTML_x0020_File_x0020_Type	{4ef1b78f-fdba-48dc-b8ab-3fa06a0c9804}	Computed
Edit Menu Table Start	_EditMenuTableStart	{3c6303be-e21f-4366-80d7-d6d0a3b22c7a}	Computed
Edit Menu Table End	_EditMenuTableEnd	{2ea78cef-1bf9-4019-960a-02c41636cb47}	Computed
Name	LinkFilenameNoMenu	{9d30f126-ba48-446b-b8f9-83745f322ebe}	Computed
Name	LinkFilename	{5cc6dc79-3710-4374-b433-61cb4a686c12}	Computed
Type	DocIcon	{081c6e4c-5c14-4f20-b23e-1a71ceb6a67c}	Computed
Server Relative URL	ServerUrl	{105f76ce-724a-4bba-aece-f81f2fce58f5}	Computed
Encoded Absolute URL	EncodedAbsUrl	{7177cfc7-f399-4d4d-905d-37dd51bc90bf}	Computed
File Name	BaseName	{7615464b-559e-4302-b8e2-8f440b913101}	Computed
Property Bag	MetaInfo	{687c7f94-686a-42d3-9b67-2782eac4b4f8}	Lookup
Level	_Level	{43bdd51b-3c5b-4e78-90a8-fb2087f71e70}	Integer
Is Current Version	_IsCurrentVersion	{c101c3e7-122d-4d4d-bc34-58e94a38c816}	Boolean

 Sometimes when the ribbon has been removed from your SharePoint page, you may find it difficult to place the page into Edit mode to add/edit web parts.  Here are two quick methods for you:     

• Add the toolpaneview=2 or toolpaneview=3 parameter to your URL.  Each opens a different version of the Add Web Parts menu.
• Add the contents=1 parameter to your URL   
• You can add the DisplayMode=Design parameter, which will place the page in design mode as well.