JavaScript required
We’re sorry, but Coda doesn’t work properly without JavaScript enabled.
Gallery
Kuovonne's Guide to Airtable
Share
Explore
Gallery
Kuovonne's Guide to Airtable
Kuovonne's Guide to Airtable
Kuovonne's Guide to Airtable
Fields
Overview of fields types
Editable Field Types
Computed Field Types
Field Types by Formula Data Type
Field Types in Scripting
All Field Types
Specific field types
Formula fields
Demystifying Formulas (DareTable 2022)
Rollup fields
Select fields
Attachment fields
Uploading Attachments
Attachment Size
Attachment URLS
Thumbnails
Converting Field Types
Naming fields
Metadata fields
Simple Metadata Fields
Data Validation
Additional Dependencies
Original Record URL (Thumbprint) Field
Column Divider Fields
DareTable 2023 Presentation
Field dependencies
Formulas
Formula Field Reference
Writing Formulas
Using AI to Write Formulas
General tips for writing formulas
Testing for Blank Values
Drafting Formulas in Parts
Function versus Operator
Typing Special Characters
Commenting Formulas
Formulas to avoid
Formatting Formulas
Basic Rules
Nested IF formulas
SWITCH Formulas
Operators
Specific Formulas
Ranges of Numbers Values
Comma Separated List of Fields Values with Optional Fields
Earliest / latest date across columns
List Fields Values (one per line) with Optional Fields
Rounding a date to the half year
Url of Interface Page for a record
Removing varying items from a list
Data Type Conversion in Formulas
Text to Numbers
Numbers to Text
Data type conversions with Dates
Troubleshooting Formulas
Formulas that won't save
Hiding or showing #ERROR!
Troubleshooting date/time/duration formulas
Troubleshooting numeric formulas
Troubleshooting formulas with lookups
Troubleshooting text formulas
Automations
Triggering automations
Triggering automations for typed values
Triggering automations on existing records
Sending Emails
Ways to send emails
Using links in emails
Emailing Attachments
Accessing updated record values
Third party automations
Managing automation runs
Templates
Templates for record values
Templates using field values
Controlling Access
Sharing a base
Access control considerations
Techniques for limited access
Airtable interface
Share link access
Synced table
Prefilled forms + Automations
3rd party portal
3rd party webhook
Preventing base duplication
Specific Solutions
Most recent form submission for ermail
Email digest of a person’s records
Sum of Multiple Select choices
Link to multiple records based on select choices
Dropping Lowest Score (top 4 of 5)
Identify the position of a record in a linked record field (top 4 of 6)
Sequential Numbering of Records
Ending a list of rollup items with ", and"
Table ID in a formula
Latest/earliest date across several fields
Miscellaneous
Web API Calls for External Integrations
Getting paid to work with Airtable
Hiring a consultant
Airtable Communities
Making major changes to a base
Suggestion for this guide
Future Content Ideas
🚧Normalized Design
Tidying Fields
Automations
Design Principles
Vocabulary
Use cases
Templates
Backend
Named formulas
MiniContent
hidden pages for future use
Linked Record Fields
Automations
Choosing a trigger
Record based triggers
Time based triggers
Webhook trigger
Interfaces
🚧Views
Selecting Data to Show
Filtering Records
Showing and Hiding Fields
Grouping and Sorting Records
Record Coloring & Row Height
View Types
Grid View
Kanban View
Calendar View
Timeline View
Form View
List View
Gantt View
Gallery View
Picking a field type
Text fields
Single select vs Checkbox
Select vs Linked record
Number versus Currency
Number vs Text
Duration vs Number
Overview of fields types
Field Types in Scripting
Tip Jar
Thank Kuovonne for creating this content!
Field Type
Type in Scripting
Data Type In Scripting
Data Type for Formulas vs 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!
Give Kuovonne a sandwich
Signup for Coda w/ referral link
Buy from my Gumroad Store
Gallery
Share
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
Ctrl
P
) instead.