You can refresh a connected table at any time by opening the connected table and clicking Refresh Data on the page bar.
Permissions
The Refresh Data button only appears for roles that have the correct app and table permissions, otherwise only the date of the last successful refresh is shown. To grant these permissions, App admins can navigate to App Settings > Roles and check these permissions for the user's role:
- App Access: Edit app structure and permissions
- Table Access for the connected table: View All Records, Modify All Records, Add, Delete, Edit Field Properties, Fields Full Access
Refresh a connected table automatically
You can also refresh a connected table automatically, on a monthly, weekly, daily, or hourly basis. The scheduled time is based on the app's timezone settings, which are set in App properties.
When you create a connected table, you choose when and how to refresh data in the table on the Refresh options page. App admins and the connection owner can change the refresh options any time.
To set or change refresh options:
-
Open your connected table and select Settings.
-
Click the Connection, for example, QuickBooks connection.
-
On the Details tab, locate Refresh options and then click Edit options.
-
Set or adjust the refresh options and then click Done. To stop a connected table from refreshing according to a schedule, select Manual only.
Tip: Before you change the refresh options, make sure you understand the purpose of the connected table.