Here is my concern, lets see if someone has the same problem
I’m making a coda workspace for project tracking and resource allocation.
based on the information I wanna people work with I made this structure of documents:
- parameters (I set a DATES table to use in a normalized way in all the docs, a profile table and other)
- resources (people table and people table by date where I have rows per people and per dates as a lookup column from DATES they worked with us linked with dates table in parameters)
- projects (project table with project and the people that worked in each one, of course, linked with DATES table as a lookup column from parameters document)
What’s the problem? When I link the DATES table from parameters document in projects document I supposed I’m using the same table that I’m using in resources… but NO! the row “date” in the linked table resources in projects is grey and telling me that the table does not exist…
The only workaround I found with coda’s team help was to add the dates table from resources also in projects document… with that the dates are ok in linked resources table but… are not the same “entities” in order to filter or compare them between the data points comming from table dates comming from parameters and table dates comming from resources!!
Some idea about how to fix this or if it is a schema problem ?
Thanks in advance !