AnsweredAssumed Answered


Question asked by Annette on Mar 5, 2013
Latest reply on Mar 5, 2013 by philmodjunk





     I'm importing information from several different users.  They have various info including FIrstName, LastName and DOB. 

     I've created a Combined info field which is the first five digits to the left of each of the three fields.  Ex.  Joseph Smith, 15/01/85 would be JosepSmith15/01.  Now, what I am wondering if there a way to have it assign each a serial number, BUT, not in the standard way.  As these lists are combined from several users, Joe Smith could be on four different lists with different info, so I want it to give the same ID number to those with matching combined fields.  Is this something that can be done through a calculation or anything?