Scripting of field types

Table 1. Scripting of field 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