New to Coda and trying to pull in data to a specific column in one table from multiple separate tables. Not sure if this is possible.
For context, I am creating a primary stakeholder management table and I want to be able to pull the ‘Name’ data from 3 separate tables - Leadership, Peers, Skip Level. Each of these 3 tables have a ‘Name’ column with respective stakeholder’s names. I can currently get it to pull from one of these tables but cannot figure out how to lookup from all 3 tables.
I realize that is an option but I wanted to keep these tables seperate as they will get very big. Yes, I understand I can create filters too, however, the ideal approach is to have seperate subpages with each table in them. Is this possible?
I am able to get all the tables combined via the ListCombine function, however, when I try to pull all this information into the main able, the names are all showing up as one big group. I don’t quite follow the first 2 screenshots on how I can choose to select a individual name from this aggregated list.
hi @Vinh_Chau , thanks for responding
you should set the column as select list, that is step one and in the select list menu you bring the tables together. I hope this works, I cannot make it more clear than this, sorry.
enjoy your weekend, cheers, christiaan