Contact Support
Sign up for free
Account
Account overview
Billing
Policies
API
API Overview
Get your API key
Documentation
Troubleshooting
Integrations
Resources
Community
Enterprise
Admin Panel
Enterprise Plans
Airtable Security
Terms of Service
Privacy Policy
Resources
Community
Marketplace
Templates
Universe
Contents
x
Getting started with Airtable
Airtable Automations
Airtable Bases
Airtable Betas
Collaborating in Airtable
Airtable Enterprise Support
Airtable Extensions
Airtable Fields
Integrating with Airtable
Learning and Resources
Airtable Interface Designer
Managing Airtable
Airtable Policy
Airtable Records
Airtable Sync
Airtable Views
Airtable Workspaces
Powered by
Common Solutions: Beginner
6 Articles
in this category
Print
Dark
Light
Contents
Common Solutions: Beginner
6 Articles
in this category
Dark
Light
Using checkbox fields in formulas
When working with checkbox fields and formulas, "= 0" means that a box has not been checked, and "= 1" means that a box has been checked. So, to make a formula field which returns A when a box has been checked, and B otherwise, you would need to se...
Updated on : 06 Jul 2022
Converting numbers and text in a formula field
In addition to using formula functions to convert data types, there are a few alternative options you can implement in your formulas to cause similar conversions. Number to text string If you append &"" to a formula working with numbers, then ...
Updated on : 06 Jul 2022
Converting serial dates from Excel to readable dates in Airtable
One of the ways Microsoft Excel stores dates is as serial numbers which are formatted to be used in calculations ( more here ). This means that by default, January 1, 1900 is serial number 1, with each new day being assigned the next sequential numb...
Updated on : 31 Oct 2022
Extracting file names from Airtable attachments
If you'd like to extract the file name from a file in the attachment field, you can do so with a formula like the example below: LEFT({Attachment Field},FIND("(",{Attachment Field})-1) Note that this formula only accounts for attachment ...
Updated on : 31 Oct 2022
Converting unix / epoch time to current date
Epoch time is defined as "the number of seconds that have elapsed since January 1, 1970 (midnight UTC/GMT), not counting leap seconds (in ISO 8601: 1970-01-01T00:00:00Z). Literally speaking the epoch is Unix time 0 (midnight 1/1/1970), but 'epoch'...
Updated on : 31 Oct 2022
Using formulas in Airtable's primary field
The primary field (the first column in any table) can be configured as a formula, which takes data from other fields in the table to compose a unique name for each record. This can be useful if your table does not lend itself particularly well to ...
Updated on : 15 Nov 2022