Beast Mode

Beast Mode

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

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

Tagged:

Best Answer

Answers

  • Answer ✓

    Try this:

    CONCAT(LEFT(TicketOwnderFirstName,1),TicketOwnerLastName)

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.
  • @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.

Welcome!

It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign In