Synced tables: another base, Google Sheets, Jira and Salesforce
Updated
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.
- In Synced tables pick Another base.
- Pick the base and the table. The list holds the bases you may read.
- Under Records keep All of them, or pick a view: only the records its filter keeps come over, with the fields it shows.
- 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 for the steps.
Jira
Issues from Jira Cloud, chosen with a JQL search.
- Make an API token: sign in at id.atlassian.com, open Security, Create and manage API tokens, click Create API token, name it (for example Artavolo) and copy it.
- In Synced tables pick Jira.
- Type your Jira site (the address you open Jira at, like
yourcompany.atlassian.net), the e-mail of your Atlassian account and the token. - Under Which issues (JQL) type the search Jira's issue search uses, for example
project = WEB order by updated DESCorassignee = currentUser() AND statusCategory != Done. - 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.
- 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.
- In Synced tables pick Salesforce and click Connect Salesforce. Sign in to Salesforce and allow access; you come back to the base.
- 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.