Non-Admin refresh Sync table?

  • 0
  • 1
  • Question
  • Updated 8 months ago
  • Answered
Pretty sure the answer is no...can a non-admin of an app use the refresh link in a Sync table?
Photo of Heather Bryant

Heather Bryant

  • 994 Points 500 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,478 Points 20k badge 2x thumb
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.
Photo of Heather Bryant

Heather Bryant

  • 994 Points 500 badge 2x thumb
Thank you matt and thank you for the extra tip. That could have tripped me up for sure!
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 53,240 Points 50k badge 2x thumb
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.
Photo of Heather Bryant

Heather Bryant

  • 994 Points 500 badge 2x thumb
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.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 53,240 Points 50k badge 2x thumb
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.
Photo of Meredith Moore

Meredith Moore

  • 556 Points 500 badge 2x thumb
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.
Photo of Matthew Neil

Matthew Neil

  • 31,478 Points 20k badge 2x thumb
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 Neil - Product Specialist
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 53,240 Points 50k badge 2x thumb
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.
Photo of Matthew Neil

Matthew Neil

  • 31,478 Points 20k badge 2x thumb
""""

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.

""""