Overview of fields types
Field Types in Scripting
Field Type
Type in Scripting
Data Type In Scripting
Data Type for Formulas vs Scripting
AI
text
object
Different
Attachment
multipleAttachments
object
Different
Autonumber
autoNumber
number
Barcode
barcode
text string
Button
button
varies/other
Different
Checkbox
checkbox
boolean
Different
Count
count
number
Created By
createdBy
object
Different
Created time
createdTime
ISO 8601 text string
Different
Currency
currency
number
Date
date
ISO 8601 text string
Different
Date (with Time enabled)
dateTime
ISO 8601 text string
Different
Duration
duration
number
Email
email
text string
External sync source
externalSyncSource
Different
Formula
formula
varies/other
Last modified by
lastModifiedBy
object
Different
Last modified time
lastModifiedTime
ISO 8601 text string
Different
Linked record
multipleRecordLinks
array
Different
Long text
multilineText
text string
Long text (with rich text enabled)
richText
text string
Lookup
multipleLookupValues
varies/other
Multiple select
multipleSelects
array
Different
Number
number
number
Percent
percent
number
Phone number
phoneNumber
text string
Rating
rating
number
Rollup
rollup
varies/other
Single line text
singleLineText
text string
Single select
singleSelect
object
Different
URL
url
text string
User
singleCollaborator
object
Different
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.