Hello, I have an issue. When referencing a value from a linked relation column, my document sometimes duplicates some of the values.
In the video, I show how my formula only sums the values from two columns, but some values appear twice. However, when I click on the cell, it refreshes and the values are corrected.
I should also mention that both tables are Cross-Doc tables. This problem didn’t use to happen, only a few days ago.
I hope someone can help me.
Hey @Jafet_Mtz
Can you try this in order? If it doesn’t work, we can try a new route to resolving your issue:
-
Reload the doc and click Refresh on any Cross-Doc sync tables. This confirms whether it’s a transient sync or render issue. If it fixes it, you’re likely dealing with a cache or timing problem.
-
Inspect the source table(s) for actual duplicate rows (same unique key). If duplicates exist in the source, the relation will retrieve them all. Remove or dedupe as needed.
-
Check how your relation is defined. Make sure it’s matching on a unique identifier (ID, email, SKU, etc.) rather than a non-unique text field or a view that might surface the same row more than once. Cross-Doc views can behave differently from the original table.
-
If you’re referencing a view in Cross-Doc, try switching to the original table as a test. Relations behave more predictably when sourcing from the canonical table rather than a view.
-
Perform a hard reload, clear your cache, or test in an incognito window. This rules out client-side caching as the culprit.
1 Like