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.
- Thank you!
- 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?
[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]
- Thanks! Worked perfectly!
