How to Create Fields with Unique Values

Root > 3. Customisation

How to Create Fields with Unique Values


Much like the <#SEQUENCE tag, the <#UNIQUE tag will create a sequential value that increases by 1 each time it is used. The difference is that <#UNIQUE will save the created value to a database field. <#UNIQUE will only create a new number if the field is empty. If the selected field already has a value, it will not be overwritten. This tag is useful for creating unique ID fields for contacts.

An example of <#UNIQUEwould be-
<#UNIQUE Field=1001 Start=15 Mask="##-##-##" Length=6>
FIELD= Is the associated ACT! field number the value will be saved to.
Start= Number assigned for the starting value. The default value is 1.
Mask=  Format for the created number.
Length= Number of digits to use. The default is 1. If a number less than 0 is selected, then a 15 digit number based on time/date will be used.

<#UNIQUE param1=value1 param2=value2 etc…>

This tag creates and saves a unique number for any contact that does not have a value in the associated field.
Field =x where x is the field number of the field you want to associate the unique number to.
Start =x where x is the value to start with.  The default is 1.
MASK =x where x is the format of the uniqueID that you are creating.
Length =x where x is the number of digits to use.  The default value is 1.  If you use a number less than 0, then a unique 15 digit number based on date/time will be used.

 



Regional details are also available at http://www.wiredcontact.co.uk

Add Feedback