A new "filtered" table from existing table

Hi,
I searched through the topics, but couldn’t find a solution for what I want.

I have a table with exported data. It contains all the invoices of a year. This table will be updated regularly.
I want to give out data for people, but not everything. I want to provide them a separate table(not a view) which is already filtered, by one of the columns (project number). This way source data remains intact and people could have their own table to work with. Table structure would remain as the source export table with all its columns. So its a filtered copy of that table.
I assume this is somehow possible in coda, but couldn’t figure it out yet

I would be pleased if someone could help me with this. Thank you!

oh… and ideally automated by pushing a button and not manually :slight_smile:

Hi @Konsztantinosz_Dulasz1 ,
and welcome to Coda Community!

Have a look at this example:

You then just need to create an automation that runs at a convenience schedule and that triggers the button.

I hope this helps.
Cheers!

4 Likes

Thanks @Federico.Stefanato
So I will need to set up an empty table first, with as many columns as in the source table and give them the same column names. I think this can work out this way for what I need it. Thank you!

1 Like

Correct.
If you want to have a completely detached solution.

Anytime!