I have many tables (for ex: “Table 1” & “Table 2”) in my document and i would like to add all tables value to “Grand Final” Table. There are 2 options for end-user to do it:
Add every single row value by pushing a button in each table
Add whole table column value: As User can create new tables (table 3, table 4, etc), listcombine in Grand Final is complicated to them to modify formula in new tables. I suggest a “Table Content” containing buttons which push all button in each table.
For option 2, depending on Table name in column 1, I want every button action to connect to relative table. For ex: Button on the first row pushes all button in Table 1, Button on the second row does the same thing in Table 2.
I have tried a formula of action Add Table Column button but it does not work. RunActions([Thisrow.column1].Button)
In my opinion, Coda should take Excel’s Indirect into consideration in this case.
If you have other ideas to solve it, pls share with me.
@Loi_Quang_Ho - It would help if you can provide context on what you are using Coda for I would be able to provide more informed opinion.
just based on what I could figure out based on your question and sample document, it seems like you are creating multiple tables for storing same type of information - if so, I would suggest use Views to break down data in separate views vs creating separate tables. and then once you have a single table, you would not have to do “Grand Final” table - your table would act as a grand finale.