When syncing data between two tables using Coda’s Cross-Doc feature, the system sometimes (with images) incorrectly maps columns based on their order rather than their names. This leads to incorrect associations of data across synced tables, causing critical mismatches, especially when the column structure of the source and target tables doesn’t align.
Steps to Reproduce:
- Set up cross doc, change the order of the columns in the cross-doc table.
- Update data in the source table, where column orders and names differ between source and target tables.
- Observe that instead of aligning data by column name, the sync aligns data by the column index or position.
- When you change the column order back to the order of the source doc - the tables will synch correctly again.
The data should map across the two tables by column name, ensuring that each piece of data is associated with the correct field, regardless of its order in the table. But with images data is mapped by the column order, not by name, which results in incorrect data placement. This leads to major confusion and potential data corruption as fields do not align correctly. Users relying on synced data across tables with different structures encounter incorrect associations, leading to poor data integrity.
Suggested Fix: Ensure that the Cross-Doc sync maps data between columns based on their names rather than their positions in the table. The mechanism for identifying columns uniquely, across all documents and independently of the name and position of the column in the cross-doc, must be corrected.
Processing: image.png…