Looking for a way to…

Say I have a table that has 20 columns of data and I have another table that has 4 columns of the same data in it. Is there a way to make an automation where when you enter data into the one table, it will add a row to the table and put the information into that one also?

Thanks for any help!

I have to ask why there are two tables - based on what you’re describing, the Coda way of doing it would be to create a view of the 20-column table, with all but 4 columns hidden. That way both tables are always in sync, data can be input/updated in either one, etc.

But perhaps you have a good reason for the two tables thing. In that case, you could have an automation with a Row Changed trigger, and then keep track of whether a row is new or not using this technique (I know… “new row” should be its own automation trigger!)

2 Likes

What we have is two tables that were imported into coda one of which has every data point on a specific item and the other one just has a specific dataset that is used for reporting. I never thought about using a cross doc and hiding rows that’s genius. Once I get all of the data synced, I will do that. Thanks for the advice!

1 Like

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