How to create a beast mode for 1st initial of first name and add the last name

AbeB

Hi everyone,

I'm having issues trying to get a beast mode to work when trying to get the 1st letter of the first name and adding it to the last name.

This is what I have - SUBSTRING('Ticket_Owner_First_Name',1) + 'Ticket_Owner_Last_Name'

I've tried different variations of this but can't seem to get it correct.

Any assistance is greatly appreciated.

Thank you

MarkSnodgrass

Try this:

CONCAT(LEFT(TicketOwnderFirstName,1),TicketOwnerLastName)

MarkSnodgrass

Try this:

CONCAT(LEFT(TicketOwnderFirstName,1),TicketOwnerLastName)

AbeB

@MarkSnodgrass

Thank you sir for the assistance!

When testing different formulas I also tried concat but did not use the " Left" function inside the parenthesis.

Thank you again for the assistance.