Script evaluation of fields by data type
Script fields evaluate data based on the field type of the input.
| 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 | Image omitted: CheckOn.png The true icon > true Image omitted: CheckOff.png 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. | Image omitted: ZeroDuration.png > "1970-01-01 00:00:00" Image omitted: TestDuration.png > "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. | Image omitted: BasicSelect.png > "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 | Image omitted: Reference.png > "287ee6fea9fe198100ada7950d0b1b73" |
| Image | Returns the path to the image | Image omitted: ImageFiletype.png > images/icons/image\_name.gif |
| URL | Returns a string | Image omitted: URLExample.png > "http://www.service-now.com" |
| Glide Lists | Returns a string of comma-separated Sys IDs | Image omitted: GlideListExample.png > 5137153cc611227c000bbd1bd8cd2007,46d14f04a9fe19810142e40c6b071512 |
Parent Topic:Scripting