Sync table not updating on weekly schedule

  • 0
  • 1
  • Question
  • Updated 3 months ago
  • Answered
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.
Photo of Everett Patterson

Everett Patterson

  • 966 Points 500 badge 2x thumb

Posted 4 months ago

  • 0
  • 1
Photo of Evan Martinez

Evan Martinez, Community Manager

  • 11,346 Points 10k badge 2x thumb
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
(Edited)
Photo of Everett Patterson

Everett Patterson

  • 966 Points 500 badge 2x thumb
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!