Can I dynamically generate columns in a table?

1

I’m working on a use case where I need to dynamically generate columns based on a user input. for example, the user can select a start date and the number of years (3) for inventory sheet, then the document should dynamically generate generate 36 months with month names YYYY-MM as column names. the values of these columns will be populated later based on formula from another input. is this possible in Coda?

1 Like
2

I don’t think it’s possible, the only current column related formula is RefreshColumn.

Your idea would make a good suggestion! Since you can add rows with formulas I don’t see why shouldn’t be able to add columns

1 Like
3

Thanks @Rickard_Abraham for your reply. it seems you may have tried to generate rows dynamically using formulas, can you please share some details on how to do that? thanks

4

Sure, here’s an example where I combine two tables into one based on their name:

5

HI Hustli,

Welcome to Coda and the community!

Is there a specific reason to have the yyyy-mm in separate columns?

It is a much more flexible approach to have a single yyyy-mm column, and then populate that column with 3 years of yyyy-mm information. Everything else you can then do with filters on that column.

Your second comment on the creating rows - there are MANY different ways to go about it and explained in the community. Could you provide some idea of what you are looking for?

Regards
Rambling Pete

6

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.