> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://help.dorik.com/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# Airtable Job Board

# Getting Started

The **Airtable Job board** element allows you to integrate Airtable and embed job data from Airtable’s API. It is particularly useful if you are willing to display job data from Airtable on your website.  This article will cover how you can add and edit the Airtable Job Board element. Follow all instructions accordingly.

# Adding the Airtable Job Board element

Follow the steps below to add an **Airtable Job Board** to your site. 

- Click on the `+` button labelled **Add Element or Container** within an empty container
- From the **Elements** tab, select **Airtable Job Board** element


**Refer to the GIF & Screenshots below:**

![](https://storage.crisp.chat/users/helpdesk/website/cf1fc9cc00911000/gif-recording-2024-05-13-at-23_nug95x.gif)


![](https://storage.crisp.chat/users/helpdesk/website/cf1fc9cc00911000/image_jp2y4f.png)


![The Airtable Job Board element](https://storage.crisp.chat/users/helpdesk/website/cf1fc9cc00911000/image_14sh54d.png)

---

# Airtable Connection

To integrate Airtable, follow the instructions and steps given below:

1. Expand the **Airtable Connection** option in the Airtable Job Board editor and click on **Clone Airtable Templates.**

![](https://storage.crisp.chat/users/helpdesk/website/cf1fc9cc00911000/image_xu2ohr.png)


2. You will be redirected to a preset **Airtable** base


![](https://storage.crisp.chat/users/helpdesk/website/cf1fc9cc00911000/untitled-design-2_1rwlnhj.gif)


3. Click on **Copy base**


![](https://storage.crisp.chat/users/helpdesk/website/cf1fc9cc00911000/untitled-7_1l6aru3.png)

4. Choose a workspace to copy the base to and click on **Add base**


![](https://storage.crisp.chat/users/helpdesk/website/cf1fc9cc00911000/untitled-8_1u7ux25.png)


5. From here, click on the **Account (1️⃣)** option and select the `Developer hub` **(2️⃣)** option, as shown below.
    
    Or you can go to this link- https://airtable.com/create/tokens


![](https://storage.crisp.chat/users/helpdesk/website/cf1fc9cc00911000/image_1j7zk1q.png)



6. Click on the **Create Token** button and then follow the steps shown in the video below:


${youtube}[Airtable Token Generation](VXs0SUCTJfY)



7. Go back to the builder and click on the `+` button under the **Token** option. Then, give it a **Name** and paste the **Token** you copied in the previous step.


![](https://storage.crisp.chat/users/helpdesk/website/cf1fc9cc00911000/add-token-name_1iby8kj.gif)


8. Do the **Airtable configuration** by adding the **Base**


![Airtable Base](https://storage.crisp.chat/users/helpdesk/website/cf1fc9cc00911000/image_1bb0mqj.png)


![](https://storage.crisp.chat/users/helpdesk/website/cf1fc9cc00911000/gif-recording-2024-05-13-at-25_yd3k4z.gif)



9. Your **Airtable Job Board** has been connected and configured ⬇️


![](https://storage.crisp.chat/users/helpdesk/website/cf1fc9cc00911000/untitled-12_1uhs592.png)


---


# Adding Prefilter

To filter out data you do not want to display on your Airtable Element, follow the steps below:

- After configuring the Airtable element, expand the Prefilter option just below the Airtable Configuration option
- Click on **+ Add New Filter**
- Select a field
- Choose a filtering option (Equal, Does Not Equal, Contains, Does Not Contain, etc.)

Refer to the list below to understand how these filters work:

**Filters**

- Equal
- Does Not Equal
- Contains
- Does Not Contain
- Is Empty
- Is Not Empty

**Supported Airtable Field Types**

- singleSelect
- multipleSelects
- singleLineText
- longText
- phoneNumber(will be treated as TEXT)
- url(will be treated as TEXT)
- email(will be treated as TEXT)
- date(not dateTime)
- formula(will be treated as NUMBER /TEXT)
- rollup(will be treated as NUMBER/TEXT)
- multipleLookUp(will be treated as NUMBER/TEXT/multipleSelects)
- currency(will be treated as NUMBER)
- percent(will be treated as NUMBER)
- rating(will be treated as NUMBER)
- number
- autoNumber(will be treated as NUMBER

**Refer to the GIF below to see an example of how prefilter works:**

${youtube}[Airtable Pre-filter](CpE464f_STU)

# Advanced Fields

You can render Advanced fields like Formula fields, Rollup fields, and Lookup fields into your Airtable Element.

## Formula Fields

To render formula fields from your **Airtable base** into your **Airtable element**, follow the steps below:

**Creating Formula Field**

- Open your Airtable base
- Select the table where you want to add the formula field
- Add a new column
- Choose “Formula”
- Add any formula of your choice

**Populating the data into your website builder**

- Go back to your website builder
- If you have already configured your Airtable Element, click on the 🔄 button
- Expand the **Fields** option
- Expand Default Fields or,
- Expand Custom Fields
- You will find your Formula field(under its name) under **Content** if the **Element Type** is Text (refer to screenshot 1)


![](https://storage.crisp.chat/users/helpdesk/website/cf1fc9cc00911000/untitled-2023-01-25t163301884_cmu4xy.png)


![](https://storage.crisp.chat/users/helpdesk/website/cf1fc9cc00911000/untitled-2023-01-25t163303315_2rmp29.png)


This GIF demonstrates the above steps:


![](https://storage.crisp.chat/users/helpdesk/website/cf1fc9cc00911000/gif-recording-2023-01-24-at-63_p62kji.gif)

## Lookup Fields

To render Lookup fields from your **Airtable base** into your **Airtable element**, follow the steps below:

**Creating Lookup Field**

- Open your Airtable base
- Select the table where you want to add the Lookup field
- Add a new column
- Choose “Link to another record”
- Choose the table you want to link inside this column.
- Click on the `+` icon on your Airtable cell
- Start adding values from the table you have linked with

**Populating the data into your website builder**

- Go back to your website builder
- If you have already configured your Airtable Element, click on the **🔄** button
- Expand the **Fields** option
- Expand Default Fields or,
- Expand Custom Fields
- You will find your Lookup field(under its name) under **Content** if the **Element Type** is Text (refer to the screenshots)


![](https://storage.crisp.chat/users/helpdesk/website/cf1fc9cc00911000/untitled-2023-01-25t163441277_vrxpyk.png)


![](https://storage.crisp.chat/users/helpdesk/website/cf1fc9cc00911000/untitled-2023-01-25t163443597_1vtvkx1.png)

This GIF demonstrates the above steps:


![](https://storage.crisp.chat/users/helpdesk/website/cf1fc9cc00911000/gif-recording-2023-01-24-at-63_104u7kk.gif)

## Rollup Fields

To render Lookup fields from your **Airtable base** into your **Airtable element**, follow the steps below:

**Creating Rollup Field**

- Open your Airtable base
- Select the table where you want to add the Rollup field
- Add a new column
- Choose “Rollup”
- Give the rollup field a name
- Choose the Field on the table that links to the records you want to summarize
- Choose the ****table field that you'd like to roll up
- Add an aggregation formula that rolls up the values in each linked record

**Populating the data into your website builder**

- Go back to your website builder
- If you have already configured your Airtable Element, click on the **🔄** button
- Expand the **Fields** option
- Expand Default Fields or,
- Expand Custom Fields
- You will find your Rollup field(under its name) under **Content** if the **Element Type** is Text (refer to the screenshots)


![](https://storage.crisp.chat/users/helpdesk/website/cf1fc9cc00911000/untitled-2023-01-25t163804392_9ajpnt.png)


![](https://storage.crisp.chat/users/helpdesk/website/cf1fc9cc00911000/untitled-2023-01-25t163830121_4tvi28.png)

This GIF demonstrates the above steps:


![](https://storage.crisp.chat/users/helpdesk/website/cf1fc9cc00911000/gif-recording-2023-01-24-at-64_5c8oo7.gif)
