Overview of fields types
Field Types in Scripting
Field Types in Scripting
Field Type
Type in Scripting
Data Type In Scripting
Data Type for Formulas vs Scripting
1
AI
text
object
Different
2
Attachment
multipleAttachments
object
Different
3
Autonumber
autoNumber
number
4
Barcode
barcode
text string
5
Button
button
varies/other
Different
6
Checkbox
checkbox
boolean
Different
7
Count
count
number
8
Created By
createdBy
object
Different
9
Created time
createdTime
ISO 8601 text string
Different
10
Currency
currency
number
11
Date
date
ISO 8601 text string
Different
12
Date (with Time enabled)
dateTime
ISO 8601 text string
Different
13
Duration
duration
number
14
Email
email
text string
15
External sync source
externalSyncSource
Different
16
Formula
formula
varies/other
17
Last modified by
lastModifiedBy
object
Different
18
Last modified time
lastModifiedTime
ISO 8601 text string
Different
19
Linked record
multipleRecordLinks
array
Different
20
Long text
multilineText
text string
21
Long text (with rich text enabled)
richText
text string
22
Lookup
multipleLookupValues
varies/other
23
Multiple select
multipleSelects
array
Different
24
Number
number
number
25
Percent
percent
number
26
Phone number
phoneNumber
text string
27
Rating
rating
number
28
Rollup
rollup
varies/other
29
Single line text
singleLineText
text string
30
Single select
singleSelect
object
Different
31
URL
url
text string
32
User
singleCollaborator
object
Different
33
User (w/ allow multiple)
multipleCollaborators
array
Different
There are no rows in this table
Thank Kuovonne for creating this content!
Want to print your doc?
This is not the way.
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.