AnsweredAssumed Answered

Question about a field

Question asked by AaronRoss on Apr 4, 2012
Latest reply on Apr 4, 2012 by philmodjunk


Question about a field


hello. i have a field called APPT ID: it is a unique id auto generated each time a rep creates a new record. I also have a field called TM-ID. i need a calculation that will take the first 6 letters of the APPT ID so i can auto copy and past it to the TM-ID.

EX: John Doe creates a record. the APPT ID generates as GATM04APT1232. the TM-ID is always the first 6 letters of that ID. tm-ID: GATM04

Is there a way to maybe create a filter that filters out everything but the first 6 letters in a field?