Tuned Listener
Posts: 6
Country: India
Message 1 of 3 (735 Views)

Unique ID

Hi I am using Sage Act! 2010 premium, i have customised  the contact layout. i want to have a field named "UID"(unique Identity)  which is in number format,and it should be autogenerated  according to the no of contacts.Eg if there are 4 contacts already in list and while entering the new 5th contact, the UID field should be bydefault "5" .Is it possible  i any ways? and how?

Posts: 1,163
Country: USA
Message 2 of 3 (702 Views)

Re: Unique ID

[ Edited ]

There are numerous ways this could be accomplished, one might be to just retrieve the # of contacts after the contact has been added and assign that number to the UID field. Another slower approach might be as new contacts are added to check this field in all contacts, find the lowest existing number in this field and increment that integer by 1.


Of course, if you not just looking for an incremented numeric value, but instead a trully unique identifier you could simply display the already assigned Contact ID Act has assigned to the contact.



Matthew Wood
Act! SDK Support
Community Moderator
Copper Super Contributor
Posts: 112
Country: Australia
Message 3 of 3 (650 Views)

Re: Unique ID

just adding up the number of contacts and adding one does not work.. if i had 20 contacts and deleted 5 (contacts with ID's 1-5) then the next number would be 16.. and there is already contact with the ID 16.. so thats not very unique at all