#STACKER AIRTABLE PRO#

Can I sync records from multiple sources into a single destination table?Ĭustomers on our Pro or Enterprise plan offerings are able to use the multi-source syncing feature to accomplish this workflow. For more context, we recommend reading this support article about combining multiple tables and this support article about copying a table from one base to another. If you need to add, delete, or edit fields on a record: sync may not be the best option for your workflow. Can I edit and move records from one table to another using Sync? Sync is a one-way process so you can not add, edit or delete records in the synced destination table. Though any changes to records in the source table will no longer be reflected in the destination table.Ĭan I add or delete records in the destination table created by a sync? The contents in the destination table will remain. What happens if I 'unsync' the destination table from the source table of a sync? Please send us your feedback and ideas here.ĭon't see an answer to your question below? Check out our extended Sync FAQs. We’re excited to share access to this long-awaited feature.

#STACKER AIRTABLE UPDATE#

If you use the PUT endpoint it will update the field.

#STACKER AIRTABLE PATCH#

We recommend using the PATCH endpoint when connecting Airtable because it will update the specific field in the table and leave all other inputs. You can also choose to create a new destination base from the source base's shared view or copy the data into a new (non-synced) table in an existing base that you can edit. Airtable is also unique in that it offers both the ability to use the PUT or the PATCH for updating a record, typically APIs only use one of these. Then, select the workspace and destination base you want to sync to.

While viewing a source base's shared view that has sync enabled, click the ‘Use this data’ button on the top right.

Step 2: Open the syncable view share link and click 'Use this data' Click the ‘Use this data’ button on a shared view page In the example below, we are sharing a view of employees on the engineering team, so we will create a new view that hides certain fields and filters records. You may choose to set a password or a domain restriction to further restrict access. You can copy the URL in the pink box and share it with other users that may want to sync this data. Then, click Share view to create a view share link and select “Allow data in this view to be synced to other bases”. You can determine which information can be synced by filtering out records and hiding fields. Step 1: In the source base, create a view share link and enable syncĬreate a grid view that you’ll use as the source for the sync.

Use the setup window to create the synced table.

Open the syncable view share link and click 'Use this data'.

Create a syncable view share link in the source base.

There are three steps to complete in order to set up a basic sync. To keep automatic syncs active make sure that some kind of action is being performed in the base on a regular basis. NoteAutomatic syncs will eventually stop on bases that don't have any recent activity.

Stacker airtable