Forum Discussion

EverettPatterso's avatar
EverettPatterso
Qrew Captain
7 years ago

Sync table not updating on weekly schedule

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.
Quickbase Sync
  • EvanMartinez's avatar
    EvanMartinez
    Quickbase Staff
    7 years ago
    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. 
    • EverettPatterso's avatar
      EverettPatterso
      Qrew Captain
      7 years ago
      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!