SharePoint Custom Mask & Unique Field Validation

Creating a Mask

Every mask can consist of several blocks. You can use one of the following field formats while mask creating:

  • Text – a static value that will not change. For example, if you want to identify help desk tickets, you might want to include “HD” text in the front of the identifier;

  • Date/Time – can be used to identify your list items with the date and time they were opened;

  • Existing Column Value – you can also use a secondary column value from the same items in the ID;

  • Site Name – use this type to point when the item resides in the portal by using the Site Name and List Name options in your ID;

  • List Name – add this type to point when the item resides in the portal by using the Site Name and List Name options in your ID;

  • Number – Auto Incremented, Go beyond the single digit ID of 1, 10, 100 and set it to show the same number of digits, say 4, all the time: 0001, 0010, 0100.

This means that mask can consist of blocks of different types. For example, you need to create a Virtosoftware Identifier which will include a text part, number and a date.

Select “Text” type and click “Add”.

You can define text to be displayed and make it editable or not and set the color. Also, you can define field width and set pattern if needed.

Click “Refresh” and see how the mask looks like in preview.

Now you need to add a number which will be automatically generated in the mask.

Select “Number” type and click “Add”.

Now define number format, for instance 0001, and check the box “Auto increment” to make this value automatically generated. Click “Refresh” to see the result.

Now you need to add a date which will be automatically added (date of item adding).

Select “Date/Time” type and click “Add”.

For example, define M/d/yyyy format and do not allow editing. Click refresh to see the result.

You can delete some blocks if you need. Just click “Delete” button opposite the block.

In case you need to change the order of blocks use “Up” and “Down” buttons in order to do it.

Click “Refresh” to see new order.

When you have added all the required blocks to the mask, click “OK” to save the settings. And return to the SharePoint list to see the result. Now when a user adds a new item to the list, he will see an identifier generated automatically.

The same way you can create any masks which will suppose filling out fields with some information. For example, make date editable for users.

And when adding a new item, date will be editable.

This way you can use masks for credit card numbers, help desk system and other situations.