Airtable
Seamlessly integrate Airtable with your favorite APIs, databases, and programming languages, using WayScript.
Airtable works like a spreadsheet, but gives you the power of a database to organize anything.

Functionality

With the Airtable module you can:
  • Read Table Data into WayScript
  • Delete Table Rows
  • Create New Table Rows
  • Update a Row

Setting Up Your Airtable Account

1. Drag the Airtable module into your WayScript program

2. In the Airtable Module, select "Add an Account" in the "Select an API Key" input

3. A form will pop-up that allows you to connect your Airtable account

Follow the instructions below for setting up each of these form inputs.

4. Navigate to the Airtable API page****

https://airtable.com/api

5. Select the "base" you want to automate with WayScript

In this example, we are using the "Event Marketing" base. Click on the base.

6. Add the name of the base to the "Workspace Name" field of the WayScript form

7. On the base API page, select "AUTHENTICATION" on the left navigation bar

8. On the right side of the page, this highlighted key is your Base Key. Copy this key

9. Paste the Base Key into the corresponding field of the WayScript form

10. Go to your Airtable account page

https://airtable.com/account

11. Double Click on and copy your API Key

12. Paste the API Key into the corresponding field of the WayScript form

13. Press the submit button on the form and you're ready to get started!

🎥
Video Tutorial

Watch: Setting up and Working with Airtable on WayScript

💼
Working with a Table

Choose the table you want to work with in the "Table Name" input. (In this case, the "Events" table.)

🔎
Select an Operation

Choose whether you would like to Get Records, Delete Rows, or Create a New Record.
What would you like to do?

🗃
Get Records

The "Get Records" option allows you to retrieve data from a table.
You can choose whether you want to retrieve All Rows, rows that match a Filter, or a Single Row.

All Rows ( Optional Inputs ):

  • Filter By Formula : Provide a formula to filter results. The formula will be evaluated for each record, and if the result is not 0, false, "", NaN, [], or #Error! the record will be included in the response. For example, to only include records where Name isn't empty, pass in NOT({Name} = '')
  • Max Records : The maximum total number of records that will be returned in your requests
  • Page Size: The number of records returned in each request. Must be less than or equal to 100. Default is 100
  • Sort : A list of sort objects that specifies how the records will be ordered. Each sort object must have a field key specifying the name of the field to sort on, and an optional direction key that is either "asc" or "desc"
    For example, to sort records by Name in descending order, pass in: [{field: "Name", direction: "desc"}]
  • View : The name or ID of a view in the testing table. If set, only the records in that view will be returned.

Filter Results

If you choose the "Filter" or "Single Row" option, you will need to define the filter you want to match on.

Matching Rows

All rows matching your settings above will display in the "Inputs" section.
Click the "Refresh" button for the most up-to-date results.

Delete Rows

The "Delete Rows" option works much in the same way as the "Get Records" option, but deletes any matching records instead of retrieving them.

🌟
Create a New Record

You also have the option to Create a New Record.
If you choose this option, you can either:
  • Build the data you would like to create using WayScript
  • Input raw JSON

Build Data

If you opt to build Data yourself, you will need to define each of the field values of the new row you wish to input into the table.
The new row created
Raw JSON
If you opt to input raw JSON, you will need to select the WayScript variable that contains that JSON or Hardcoded JSON. Both of them need to be in the following forma (The same format as a Fields JSON output item in Get Records) :

Update a Row

Update Type

  • PATCH - A PATCH request will only update the fields you specify, leaving the rest as they were
  • PUT - A PUT request will perform a destructive update and clear all unspecified cell values.

Submission Type

Build Data (Recommended)
  • Inputs:
    • Record ID - The ID of the Record you want to update. This can be retrieved using the Get Records mode.
    • Fields - This is where you put the Key and Value that you want to update. The Key is the name of the column, the value is the new value you want for that cell.
Input Raw JSON (Advanced)
  • This mode allows you to input your own JSON or Struct into Airtable. The json MUST fit this structure:
1
{
2
'id' : '<INSERT_RECORD_ID>',
3
'fields' : { 'column name' : 'new value', }
4
}
Copied!

Output

1
Success: Bool //This tells you if the row successfully updated
Copied!

📤
Outputs

Each column of your table will be available to select as an output from the Airtable module.
Last modified 8mo ago