Custom Ticket ID formula
I would like to create a custom Ticket ID that pulls in the following: Year ticket open-provider name-ticket number 17-Gov-14985
Forum Discussion
[custom ticket id] = formula text field
[year]&"-"&[provider name]&"-"&[ticket number]
Set as Key field in field list.
If not all three are provided or imported, you risk QB sending you a duplicate key field error message.