Coda Cross-Doc Tables: Duplicate Values in Formula from Relation Column

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:

  1. 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.

  2. 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.

  3. 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.

  4. 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.

  5. Perform a hard reload, clear your cache, or test in an incognito window. This rules out client-side caching as the culprit.

1 Like