Explore recipe: Recording the time when a checkbox was checked

Return to top
Have more questions? Submit a request

2 Comments

  • Jed Hollander

    Does this formula work for any custom field? I guess the better question are timestamps saved for all custom fields?

     

    Thanks

    1
  • Chandra Robrock
    Community Moderator

    Hi Jed Hollander - While you won't see an attribute exclusive to the custom field change timestamp, you will be able to understand the exact timestamp in which a custom field was updated by using the Update - Timestamp. The timestamp shown within the Update - Timestamp attribute will be based on the exact data you're looking at in Explore. 

    For instance, in the formula provided in this recipe article, the Update - Timestamp attribute will only reflect ticket updates in which Checkbox_1 was selected.

    In terms of whether you'd be able to use this same formula for other custom fields, you should be able to use this for most (if not all) custom ticket field types. However, you'll likely need to change the formula based on the type of custom field you'd like to report on since not all custom field types would return an old/new field value of either 1 or 0. Instead, the custom field value might actually be text or a ticket tag.

    Additionally, in the case of a dropdown menu that has a lot of different options, this formula might be a better way to go so that you don't have to explicitly call out each individual dropdown menu option within your query.

    IF ([Changes - Field name]="Dropdown_1")
    AND
    ([Changes - Previous value]=NULL))
    AND
    ([Changes - New value]!=NULL)
    THEN
    [Update - Timestamp]
    ENDIF

    Hope that helps point you in the right direction!

    0

Please sign in to leave a comment.

Powered by Zendesk