Custom Ticket ID formula

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
I would like to create a custom Ticket ID that pulls in the following:

Year ticket open-provider name-ticket number

17-Gov-14985
Photo of Stephony (DBH)

Stephony (DBH)

  • 586 Points 500 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of Chris

Chris, Champion

  • 4,390 Points 4k badge 2x thumb

[custom ticket id] = formula text field

[year]&"-"&[provider name]&"-"&[ticket number]

Set as Key field in field list.


Photo of Chris

Chris, Champion

  • 4,390 Points 4k badge 2x thumb
If not all three are provided or imported, you risk QB sending you a duplicate key field error message.
Photo of Stephony (DBH)

Stephony (DBH)

  • 586 Points 500 badge 2x thumb
Thank you!
Photo of Stephony (DBH)

Stephony (DBH)

  • 586 Points 500 badge 2x thumb
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?
Photo of Chris

Chris, Champion

  • 4,390 Points 4k badge 2x thumb

[year] = formula number field

Year([date])


So here is the whole formula :

Year([date field])&"-"&[provider name]&"-"&[ticket number]

If your date is actual a date time field, do this:

Year(ToDate([date field]))&"-"&[provider name]&"-"&[ticket number]

(Edited)
Photo of Stephony (DBH)

Stephony (DBH)

  • 586 Points 500 badge 2x thumb
Thanks! Worked perfectly!