Script evaluation of fields by data type

Script fields evaluate data based on the field type of the input.

Table 1. Evaluation of fields by data types
Type Evaluates to in script Example
String The string "dog" > "dog"
Decimal A number with up to two decimal points 12.34 > 12.34
Integer A number with zero decimal points 12 > 12
True / False true or false

The true icon > true

The false icon > false

Date A date formatted as yyyy-mm-dd 2008-11-04
Date-time A day and time formatted as yyyy-mm-dd hh:mm:ss 2008-11-04 06:46:20
Duration

A date that is equal to January 1st 1970 00:00:00 + the amount of time of the duration being stored

Note: This date corresponds to the system time zone. If a different user time zone has been specified, the date and time value may appear different for that user.

> "1970-01-01 00:00:00"

> "1970-01-02 02:03:04"

Choice Returns the contents of the value field for the sys_choice record associated with that choice. See: Choice List for more information on returning the value associated with a particular item in a choice list. > "2" (Note that this value is is a string)
Journal Returns a string of all entries made to that journal field. See Journal Fields for scripting of journal type fields The web server is down > The web server is down
Reference Returns the sys_id of the record that is referenced > "287ee6fea9fe198100ada7950d0b1b73"
Image Returns the path to the image > images/icons/image_name.gif
URL Returns a string > "http://www.service-now.com"
Glide Lists Returns a string of comma-separated Sys IDs > 5137153cc611227c000bbd1bd8cd2007,46d14f04a9fe19810142e40c6b071512