Discussions

Expand all | Collapse all

Custom Ticket ID formula

  • 1.  Custom Ticket ID formula

    Posted 03-07-2017 15:20
    I would like to create a custom Ticket ID that pulls in the following:

    Year ticket open-provider name-ticket number

    17-Gov-14985


  • 2.  RE: Custom Ticket ID formula

    Silver
    Contributor
    Posted 03-07-2017 15:22

    [custom ticket id] = formula text field

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

    Set as Key field in field list.




  • 3.  RE: Custom Ticket ID formula

    Silver
    Contributor
    Posted 03-07-2017 15:23
    If not all three are provided or imported, you risk QB sending you a duplicate key field error message.


  • 4.  RE: Custom Ticket ID formula

    Posted 03-07-2017 15:27
    Thank you!


  • 5.  RE: Custom Ticket ID formula

    Posted 03-07-2017 15:35
    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?


  • 6.  RE: Custom Ticket ID formula

    Silver
    Contributor
    Posted 03-07-2017 15:37

    [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]



  • 7.  RE: Custom Ticket ID formula

    Posted 03-07-2017 16:02
    Thanks! Worked perfectly!