Custom Ticket ID formula

Question

I would like to create a custom Ticket ID that pulls in the following:Year ticket open-provider name-ticket number17-Gov-14985

chrischris · Answer

[custom ticket id] = formula text field[year]&amp;"-"&amp;[provider name]&amp;"-"&amp;[ticket number]Set as Key field in field list.

chrischris · Answer

If not all three are provided or imported, you risk QB sending you a duplicate key field error message.

stephony_dbh_ · Answer

Thank you!

stephony_dbh_ · Answer

So I have a date field that is Today's Date. How do I just make it so the Year of the date field shows?

chrischris · Answer

[year] = formula number fieldYear([date])So here is the whole formula :Year([date field])&amp;"-"&amp;[provider name]&amp;"-"&amp;[ticket number]If your date is actual a date time field, do this:Year(ToDate([date field]))&amp;"-"&amp;[provider name]&amp;"-"&amp;[ticket number]

Forum Discussion

Custom Ticket ID formula

Related Content

Formula Query with custom key

Custom Record Titles

custom email

Parent table with custom key from a formula

Formula Assistance