Concatenate 3 First letter and Timenow only numbers

[areyes]

Hi Everyone. I would appreciate your help to figure this out. I am doing a task management app, and I would like the ticket number to autogenerate. This is not gonna be the primary key, but just a reference information. So I want to take the first letter of my customer and the timenow and join them together to be the ticket ID. Something like this:
Customer: Acme
Timenow: 11/01/2021 16:08:31
Ticket ID: ACM-11012021160831

Could you please help me with this? If you have any other idea Appreciate beforehand.

[Marc_Dillon · Accepted solution]

LEFT( [Customer] , 3 ) & "-" & TEXT( NOW() , "mmddyyyyhhmmss" )

help.appsheet.com

LEFT()

Left-most characters of text

help.appsheet.com

TEXT()

Format as text

[areyes]

Thank you so much! I Appreciate your help.