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?