I am trying to do a platform analysis for our company. I’d like to use Coda for this analysis. I would have one primary table where each row is dedicated to attributes about the different technologies I’m comparing. Then I’d like to have additional tables that are essentially mapping to each of the columns of the master table. e.g. Platform table with a row for each platform. Each column focuses on different aspects of each platform. The columns would be laid out like “Platform, Criteria A, Criteria B, Criteria C”
Then there would be tables for Criteria A, Criteria B, and Criteria C. I’d then like to be able to have the rows on the master table be reflected on each of the Criteria Tables. So on the master table the rows would be “Platform 1, Platform 2, Platform 3”.
On each Criteria table you would see the same list of Platforms as on the master table but each column would be a ranking of how each platform scores across different rubrics for each of the Criterium. At the end of the analysis all the scores for Platform 1 on the Criteria A would be added up and reflected in the Criteria A column on the master table. At the end it would be clear which platform is ideal based on all the scoring.
How do I get all the Criteria tables to update with rows as they are added to the Platform table?