I frequently use table-sync to sync tables between bases. I then link the synced records to records in other tables to maintain a single-source of truth for all of the information that I manage across my bases.
I have been running into an issue where...
This is to track inventory first-in-first-out.
I have 3 tables. First is a list of inventory received. Second is ...
@Val If the view you are syncing has records filtered out during a sync, then those records will be removed from the synced base. If they are removed, then they will be de-linked from any linked records.
This DOES highlight a major problem with syncing. I’m lucky that my bases do not have thousands of records and I was able to go in and re-link manually. In another month or two this would not be possible.
It’s funny how after dealing with an issue for weeks, minutes after posting the question is when I finally figure it out.
This was happening because I was not maintaining an untouched separate synced view. I was syncing my master view, which I would ...