BaseSelect the base that contains the record you want to update. TableSelect the table that contains the record you want to update. Record IDIf you are updating a record, enter or map the unique Airtable ID of
For example, if you just wanted to show Trips where the Name was Hawaii, the value of your filter would be the following formula: ({Name} = 'Hawaii') *Whatever is inside of the curly brackets should be the name of the column in Airtable. ...
Airtable home or view your bases Platform
In order to use Airtable, you need to be familiar with a few key concepts. If you’re already an Airtable whiz, feel free to skip to the “Writing to Airtable with a serverless function” section. Bases.According toAirtable documentation, “Abaseis a database that contains all of the inf...
Here's a basic formula to check if a particular date field contains a Tuesday and display a message accordingly: IF(WEEKDAY({Date})=2,'Happy Tuesday!','Not Tuesday yet... :(') As you can see, the formula looks at a field appropriately-titledDate, processes it with theWEEKDAY()funct...
Airtable formula playground. This template base is a convenient reference for the 98 functions supported by Airtable. IDG Airtable scripts use JavaScript and an Airtable API to let you manipulate your base and automate repetitive tasks. Airtable Interface Designer Interface Designer, currently in ope...
When the output of a formula is text, it potentially contains a mix of dates, numbers, and/or plain text. You can format this output to match an option from a preset list similar tosingle select fields. To enable single select style formatting: ...
If you add them, your collaborators will have access tothe data in a base—which, without the right context, can become time-consuming to navigate. Instead, a shared view link gives collaborators a lightweight way to see what they need, and stay focused on what’s relevant to their work...
If your table contains fields with long names or if you want to prevent accidental misspellings of field names, then we recommend that you start typing the name of a field and then choose the field in the “Insert a field or function” section below the formula you are creating. You can...
IF(expression, value1, value2) The function tests the logic entered into theexpressionfield, then it returnsvalue1if that logic is true, orvalue2if it is false. Like in Excel, you can create nested IF statements and insert other functions into your IF formula. ...