Discussions

Expand all | Collapse all

Non-Admin refresh Sync table?

  • 1.  Non-Admin refresh Sync table?

    Posted 04-11-2017 15:46
    Pretty sure the answer is no...can a non-admin of an app use the refresh link in a Sync table?


  • 2.  RE: Non-Admin refresh Sync table?

    Top
    Contributor
    Posted 04-11-2017 15:52
    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.


  • 3.  RE: Non-Admin refresh Sync table?

    Posted 04-11-2017 15:53
    Thank you matt and thank you for the extra tip. That could have tripped me up for sure!


  • 4.  RE: Non-Admin refresh Sync table?

    Posted 04-11-2017 15:58
    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.


  • 5.  RE: Non-Admin refresh Sync table?

    Posted 04-11-2017 18:01
    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.


  • 6.  RE: Non-Admin refresh Sync table?

    Posted 04-11-2017 18:20
    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.


  • 7.  RE: Non-Admin refresh Sync table?

    Posted 04-13-2018 21:16
    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.


  • 8.  RE: Non-Admin refresh Sync table?

    Top
    Contributor
    Posted 04-13-2018 22:03
    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 Specialistmneil@mcftech.com Phone: 440-201-6050 ext. 476" width="300px">


  • 9.  RE: Non-Admin refresh Sync table?

    Posted 04-13-2018 22:44
    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.


  • 10.  RE: Non-Admin refresh Sync table?

    Top
    Contributor
    Posted 04-13-2018 22:47


    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.