AnsweredAssumed Answered

Serial number issue

Question asked by willrollo on Aug 6, 2012
Latest reply on Aug 15, 2012 by philmodjunk


Serial number issue


If I have two fields, one which is a company name and another which is an autocreation serial number, how to I create a third feild calc that produces the first three letters of the company field followed by the last three digits of the serial number field?


i.e. Customers::company= Harrods   Customers::Serial= 123456   New Field= HAR456



Thank you