Skip to main content
Skip table of contents

Miscellaneous Functions

ACCESS

ACCESS(Item, PropertyName)

Tries to access a property/field of the item. 

ParameterTypeDescription

Item

Item

Item containing the property or a key-value map.

PropertyNameTextProperty or field being accessed.
ResultAny

Value in PropertyName. Undefined if the Item is not an item or key-value map, or it does not have this property.

Example:

  • ACCESS(epic, "Story Points")

HISTORICAL_VALUE

HISTORICAL_VALUE(Item, Field, Date)

Show value of the field at specified date

ParameterTypeDescription

Item

Item

Issue item; use "this" for current row.

FieldTextField being accessed
DateDate/TimeDate or date/time value; use DATETIME function to convert into it: #DATETIME
ResultAnyField value at specified date (current value will be used for future dates)

Example:

  • HISTORICAL_VALUE(this, "cost", DATETIME("15/May/18 6:24 PM")) → 5.55
  • HISTORICAL_VALUE(this, "cost", NOW()) → 5.55

ME

ME()

Returns the user item of the current user.

Example:

  • IF(ME() = "admin"; "You're admin!")

URL_ENCODE

URL_ENCODE(Value)

Translates a text into application/x-www-form-urlencoded format.

ParameterTypeDescription
ValueTextValue to convert
ResultTextValue converted to application/x-www-form-urlencoded format.

Example:

URL_DECODE

URL_DECODE(Value)

Decodes an application/x-www-form-urlencoded text.

ParameterTypeDescription
ValueTextValue to convert
ResultTextDecoded Value.

Example:

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.