Discussions

Expand all | Collapse all

Sync table not updating on weekly schedule

  • 1.  Sync table not updating on weekly schedule

    Posted 02-05-2019 16:41
    I have a table sync between two Quick Base apps set to update weekly on Sundays. Recently, when I come in a Monday there is no data showing in the table and it seems to take several manual attempts to refresh the sync before the data shows back up. What would be causing it to become de-synced with no data? I'm ready to stop using sync and start manually updating the same tables in different apps.


  • 2.  RE: Sync table not updating on weekly schedule

    Top
    Contributor
    Posted 02-05-2019 21:09
    Hi Everett,

    Are any of the filters used within that Quick Base to Quick Base Sync set up based on a formula field that may not always be true? It could be a formula field not always being true or not evaluating in the way you expect if it is part of a filter or key. Do you receive any error messages for that Sunday Sync or does it show up in the Sync history as a successful sync? I am curious if the same happens with your manual sync or not. 

    Something like this sounds fairly unusual and usually a good time to reach out to Care to see if they can look for any history on this Sync and what might be causing it to become de-synced if you aren't receiving error messages. You can contact our support when signed into Quick Base by clicking on the question mark icon in the upper right hand corner and selecting Manage Support Cases or directly here


  • 3.  RE: Sync table not updating on weekly schedule

    Posted 02-08-2019 21:25
    Yes, I believe it was formula checkbox that determines if the location is open or closed based on a date field, which I had to correct the checkbox formula by using values true/false instead of 0 or 1,  so I will see if that fixes the issue this coming weekend and check it on Monday. Much appreciated Evan!