Non-Admin refresh Sync table?
Pretty sure the answer is no...can a non-admin of an app use the refresh link in a Sync table?
Forum Discussion
- Only the creator / owner of the sync connection can manually refresh the data.
Also, another bug in the system. If the owner does a "Test the app as another role" and then close their browser, without "Ending Test", the sync will not work as well. Even if it set to run on a set schedule. - Thank you matt and thank you for the extra tip. That could have tripped me up for sure!
- I can't find any documentation, but while you do not need to be the Connection owner, it seems that you do need to be in the Admin Role. Not quite sure which Admin permission it actually requires, I would guess something like "Edit App Structure and Permissions", but I did not want to test for fear of locking myself out as Admin from my own app.
- Thanks Mark. I asked because I have a sync table which connects to Box. I wanted my managers to be able to upload their .csv and then enter QB to refresh their dashboard.
I'll use a nightly refresh schedule. I didn't want to use hourly because there are multiple sync tables in the same app and I'm not sure how multiple hourly syncs would affect performance. - In my experience, the sync does not affect performance much. I think that they have it tuned to take 2nd priority to real users. I recall when it first came out I ran a giant Sync on an app and it really did not seem to affect the performance at all.
I do agree that it would be nice to have a button to click so users could force a refresh. Users can see the date and time of the last refresh in the spot where the button normally appears for Admins.
- Any updates on this? I would really love this. Or even a 15min refresh cycle. I have a multi-layered app structure and it takes half a day to get to the end.
- You are in luck. I answered this is more detail on this post.
https://community.quickbase.com/quickbase/topics/url-to-manually-refresh-a-connected-table - Matthew, can you explain in that linked post above how to get at the refresh Key.
I did an "Inspect" near that icon using Chrome, but it was not apparent how to get the Refresh Key.
You can initiate the refresh with a url similar to this:
https://mydomain.quickbase.com/qb/sync/refreshTasks?replicationID=12345
The trick is knowing your replication ID. You will need, as the admin, monitor your network traffic during a manual refresh, and pull out the ReplicationID.
