Sync data between bases

Sync data between bases

4 min read
Available with these plans:
Starter
Basic
Pro
Enterprise
To upgrade your Lark Plan or for more information, contact Support or your Customer Success Manager. The Lark Basic plan supports only specific countries and regions.
I. Intro
Gather all your key data into a single base by syncing with other bases. You can specify the data you want to sync or select all data and turn on automatic sync as needed. The data in the synced table can't be modified or edited, but you can create new fields or remove the sync to turn the synced table into an ordinary table.
Note: Only users with manage permission for the base can see the Sync Data From button in the lower-left corner to sync data across bases.
Use cases:
  • Unified management: Use a base to record and summarize all key data and each department or team can sync the data they need to their own base.
  • Data aggregation: Data in bases of different teams or departments can be aggregated into a single master base for comprehensive analysis.
  • Data segregation: When reporting or summarizing, you can sync and share only essential data for presentation, ensuring smooth information flow while keeping sensitive data secure.
250px|700px|reset
II. Steps
Set up sync
  1. Open the base, click Sync Data From in the lower-left corner, and select Base.
  • Note: You need to have manage permission for the base to see the button for this feature.
250px|700px|reset
250px|700px|reset
If this is the first time, you're syncing data with another base in this base, you will see the pop-up window appear, as shown below. Click Configure to enter the sync setup page.
250px|700px|reset
  1. Select the data source in the pop-up window, that is, select the base, table, and view to sync, and click Next. You can use search when selecting the base, table, and view.
  • Note:
  • If the base you selected as the data source does not have advanced permissions turned on, you need to have the permission to copy the content of that base in order to select it for syncing.
  • If the base you selected as the data source has advanced permissions turned on, you need to have the permission to manage that base in order to select it for syncing.
  • Private views cannot be selected for syncing.
250px|700px|reset
  1. Select to sync all fields or only specific fields. Turn on Automatic sync (every hour) as needed and data from the base will be synced to the table every hour. Click Save and Sync.
250px|700px|reset
Manage sync
250px|700px|reset
Click Save and Sync and the selected views in the data source will be added to a table in the left navigation bar.
  • The synced data table will have a lightning bolt icon, and its name will be the same as the source data table by default. You can rename it as needed. In the table, you can also perform actions such as copying and deleting as well as adding fields for data management. The synced fields in the table will also have a lightning bolt icon. You cannot edit or delete the content or modify the field type.
  • Note: When you duplicate a synced table, the duplicate will be an ordinary table. Its content can be modified and edited, and it won't be synced with the data source.
  • Manually sync data: Click the synced table, click the ⋮ More actions icon on the right side of the table name, and select Sync Data.
  • Note: If advanced permissions are not turned on, users with manage or edit permission can manually sync data. If advanced permissions are turned on, users with manage permission can manually sync data.
  • Configure sync settings: Click the synced table, click the ⋮ More actions icon on the right side of the table name, and select Sync Setup. In the pop-up window, click Configure to change the fields to sync. You can also turn auto sync on or off as needed. Click Save and Sync when you're done.
  • Note: Only users with manage permission can configure sync settings. Modifying the data source is not supported here, that is, you cannot change the base, table, and view to sync. To change the data source, you need to set up a new sync.
250px|700px|reset
  • Remove sync: Click the synced table, click the ⋮ More actions icon on the right side of the table name, and select > Remove sync. The table will become an ordinary table and will no longer sync with the data source, but the synced data will be retained in the table. Removing sync cannot be undone.
  • Note: Only users with manage permission can remove sync.
III. FAQs
Who can sync data across bases?
Only users with manage permission for the base can see the Sync Data From button in the lower-left corner and create a sync between bases.
What bases can I sync with?
  • When advanced permissions are turned off: You can sync bases for which you have permission to duplicate.
  • When advanced permissions are turned on: You can sync bases for which you have manage permission.
Who can manually sync data?
  • When advanced permissions are turned off: Users with manage and edit permissions can manually sync data.
  • When advanced permissions are turned on: Only users with manage permission can manually sync data.
Is there a limit on the number of rows that can be synced across bases?
Yes, a maximum of 20,000 rows of data can be synced. The data beyond this limit will not be synced.
What are the limits or restrictions for syncing different field types?
  • The index field of the source base will be synced by default and cannot be removed.
  • Syncing flow fields and button fields is not supported.
  • Numbering fields, lookup fields, one-way link fields, and two-way link fields will be synced to the new table as text.
  • For formula fields, the field type that will be used in the synced table will be based on the format of the formula output. If there is no applicable field type for the formula output, the text field will be used by default.
Can I edit the data in the synced table?
No, you can't edit or delete data in the synced table or create a form view from it. Adding or deleting records is also not supported.
Will deleting the source base affect data syncing?
If you delete the source base, the data in the synced table will not be deleted, but you won't be able to set up sync again.
Can a synced table act as a source table?
Yes.
Can a single base support multiple synced tables?
Yes.
After setting up sync, under what circumstances will automatic sync be reduced in frequency or turned off?
If the base has not been browsed for more than 10 days, the frequency of automatic syncing will be reduced from once every hour to once every 24 hours. If the base has not been browsed for more than 30 days, automatic sync will be turned off. To restart automatic sync, click the ⋮ More actions icon to the right of the synced table, click Sync Setup, and turn on Automatic sync (every hour).
After syncing data, can I cancel (undo) the synced data?
No.
How can the numbering field be converted to other formats after syncing?
After syncing, the numbering field will be converted into text format. If you need to convert it to other formats, you can use the TEXT function.
Can I sync a table to another table within the same base?
No.
Can I sync a base from outside of the organization?
Yes, but you need to have the following permissions:
  • If the base you selected as the data source does not have advanced permissions turned on, you need to have the permission to copy the content of that base in order to select it for syncing.
  • If the base you selected as the data source has advanced permissions turned on, you need to have the permission to manage that base in order to select it for syncing.
Written by: Lark Help Center
Updated on 2025-01-29
How satisfied are you with this content?
Thank you for your feedback!
Need more help? Please contact Support.
0
rangeDom
rangeDom
rangeDom
rangeDom
rangeDom
rangeDom
rangeDom
rangeDom
rangeDom
rangeDom
rangeDom
rangeDom
rangeDom
rangeDom
rangeDom