# Synced tables: another base, Google Sheets, Jira and Salesforce

> Bring a table of another base, a Google Sheet, Jira issues or Salesforce records into a base as a table that updates itself every hour.

Source: https://artavolo.com/page/synced-tables

A synced table is a table of your base that follows another app, one way. The records are kept and changed in that app, and Artavolo reads them again every hour: new ones are added, changed ones updated, and records gone from the app go to the table's trash. Your other tables can link to a synced table, and views, forms, interfaces and automations use it like any other.

The owners of a base add synced tables: open the base, click its name at the top left and choose **Synced tables**.

## Another base

A table of another base you can open, or only the records one of its views shows: for example the company's list of clients, kept by the sales team in their base, used by the support team in theirs.

1. In **Synced tables** pick **Another base**.
2. Pick the base and the table. The list holds the bases you may read.
3. Under **Records** keep **All of them**, or pick a view: only the records its filter keeps come over, with the fields it shows.
4. Click **Sync this table**.

Fields keep their type where a copy can hold it (text, numbers, dates, options with their colours, checkboxes, files). Links to other records and people come over as their names, and formulas, lookups and rollups as their values. The table is read with your rights in the other base: if you lose access to it, the sync stops with a message and the table keeps the records it had. Within one base, link the tables instead.

## Google Sheets

Share the sheet as **Anyone with the link** can view and paste its address. See [Sync a table from Google Sheets](https://artavolo.com/page/sync-google-sheets) for the steps.

## Jira

Issues from Jira Cloud, chosen with a JQL search.

1. Make an API token: sign in at [id.atlassian.com](https://id.atlassian.com/manage-profile/security/api-tokens), open **Security**, **Create and manage API tokens**, click **Create API token**, name it (for example Artavolo) and copy it.
2. In **Synced tables** pick **Jira**.
3. Type your Jira site (the address you open Jira at, like `yourcompany.atlassian.net`), the e-mail of your Atlassian account and the token.
4. Under **Which issues (JQL)** type the search Jira's issue search uses, for example `project = WEB order by updated DESC` or `assignee = currentUser() AND statusCategory != Done`.
5. Click **Sync this table**.

Each issue becomes a record with its key (WEB-12), summary, status, type, priority, assignee, reporter, labels, due date, created and updated dates, and a link to the issue. The table shows what your Jira account may see. The token is kept sealed and never shown again; to use another token, stop syncing and sync the table again.

## Salesforce

Accounts, contacts, opportunities, leads or cases from Salesforce.

1. Once per installation, the administrator connects Salesforce: in Salesforce **Setup**, an app for Artavolo with OAuth turned on, the callback address shown in Artavolo's administration under **Settings**, **Authentication**, **Salesforce**, and the scopes **Manage user data via APIs (api)** and **Perform requests at any time (refresh_token, offline_access)**. Its consumer key and secret go in those settings.
2. In **Synced tables** pick **Salesforce** and click **Connect Salesforce**. Sign in to Salesforce and allow access; you come back to the base.
3. Pick the records to sync, such as **Opportunity**, and click **Sync this table**.

Each object brings its usual fields: an opportunity its name, stage, amount, close date, probability and account; an account its name, type, industry, phone, website, city, country and annual revenue; and so on. The table shows what your Salesforce user may see.

## Working with a synced table

- **Read only.** People cannot add, change or delete its records in Artavolo, so nothing is lost at the next sync. Change them in the app they come from.
- **Sync now.** **Synced tables** lists each one with its records and when it last synced; **Sync now** reads it again straight away.
- **When a sync fails**, for example because a token expired or a sheet stopped being shared, the list says why, and the table keeps the records it had until the next sync works.
- **New values.** A new status or stage in the app becomes a new option of the field.
- **Stop syncing** keeps the table with its records, as an ordinary table you change in Artavolo.
- A synced table holds up to 20,000 records.

## Related

- [Sync a table from Google Sheets](https://artavolo.com/page/sync-google-sheets)
- [Link records between tables](https://artavolo.com/page/link-to-another-record)
- [Automate routine work](https://artavolo.com/page/automations)
