Data Source - Airtable
Ha Ngan Nguyen avatar
Written by Ha Ngan Nguyen
Updated over a week ago

Within Creative Force, there are multiple ways for you to connect with a Data source and using Airtable is one of the methods. You will first need to enable the connector here.

To create a Data source, go to your Studio settings -> Data sources then click ‘Add’.

After clicking ‘Add’ you will be prompted to the setup dialog, please contact your IT team to have the needed information for:

  • Access token: make sure that the token can access the data in the selected workspaces and bases. Please follow the support article from Airtable to create the Access token here.

Note:

When creating the personal access token, you must set the scope to have at least these below scopes enabled:

  • Read data records

  • Read schema bases

  • Manage webhook

  • Base: you can select the Base you want from the drop-down list

  • Product table: you can select the Product table you want from the drop-down list

Note:

  • If you have more than one Base and Product table, you will need to set up a separate Data source for each of those.

  • Changing the Base and Product table for the existing Data Source setup will sync the new file/product table, hence changes made on the previously selected Product Table can not be considered and will not reflect in Creative Force.

Schedule setup

  • Frequency: You can decide how often the data source gets updated automatically. It can be either Hourly - Daily - Weekly - Monthly. If you choose ‘monthly’ you will have to decide which day of the month. If you choose ‘weekly’ you will have to decide which day of the week.

  • Day of weeks: The day that the data gets updated.

  • Hour in day: The hour in the day that the data gets updated.

  • Minute in hour: The minute in the day that the data get updated.

After finishing setting up the data source, you can assign the data source to a client here.

In the ‘Last check’ column, you will find the following statuses:

  • Data ready: After successfully syncing for the first time, the status will show Data ready

  • Wait for first sync: No sync has been succeeded previously

  • Cannot connect: Creative Force cannot connect to the Data source. Please contact our support team for further details.

  • Syncing: Creative Force is in the process of syncing the data

  • Wait to map: The columns have not been mapped, after these have been mapped, the sync can start

Did this answer your question?