# Copy row from table to a view of the table **URL:** \ **Category:** Ask the Community\ **Created:** [January 31, 2021, 2:38am UTC](https://connect.superhuman.com/t/copy-row-from-table-to-a-view-of-the-table/21093 "2021-01-31T02:38:56Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Gregg\_Stebben](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/gregg_stebben/32/597_2.png) [@Gregg\_Stebben](https://connect.superhuman.com/u/Gregg_Stebben)\ **Post date:** [January 31, 2021, 2:38am UTC](https://connect.superhuman.com/t/copy-row-from-table-to-a-view-of-the-table/21093/1 "2021-01-31T02:38:56Z")
Hi! I have a master list of stock symbols and the first column is for date and time, the second column are stock symbols and the third column is for notes. When I want to write a note about a symbol, I use a keyboard macro to put the current date and time in the first column, then write my note in the third column. Separately, I have a view of the master table that is an archive of all these notes. Presently, I just cut and paste the new notes (columns 1, 2, 3) from the master list to the archive sheet. But I would love to be able to automate this…so everytime I add a date/time in the first column AND/OR a note in the third column it gets added to the archive view (in a perfect world, this would happen when a button was pushed or some other trigger by me). Is this possible? I tried to write an automation to do this…but sort of made a mess. I also tried to do this with a Cross-Doc…but I don’t see my master table in the list to the right. Any help you can offer will be greatly appreciated! ---
**Author:** ![Piet\_Strydom](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/piet_strydom/32/19269_2.png) [@Piet\_Strydom](https://connect.superhuman.com/u/Piet_Strydom)\ **Post date:** [January 31, 2021, 4:25am UTC](https://connect.superhuman.com/t/copy-row-from-table-to-a-view-of-the-table/21093/2 "2021-01-31T04:25:29Z")
HI Gregg, welcome back. When you say “I have a view of the master table that is an archive of all these notes.” Do you mean a copy in a different table, or a view of the existing table? Table entries always exist in any view of the table, unless they are filtered out. I would like to suggest that you only have one table. This table will contain all the notes you have made. Then you create another view(s) of that table, where you put in filters, probably an interactive filter, so that you can select the time period and the ticker symbol you would like to see. Regards Piet Strydom Fewer tables, more views ---
**Author:** ![Gregg\_Stebben](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/gregg_stebben/32/597_2.png) [@Gregg\_Stebben](https://connect.superhuman.com/u/Gregg_Stebben)\ **Post date:** [January 31, 2021, 5:11am UTC](https://connect.superhuman.com/t/copy-row-from-table-to-a-view-of-the-table/21093/3 "2021-01-31T05:11:00Z")
> [@Piet\_Strydom](#): > > Piet Hi, Piet…thank you for your reply! It is one master table, and the archive is a view of that master table. But I actually think that what I learned from you (and you may not like this!) is that I do need two tables…and here’s why: After I cut and paste the the new notes (Col1: date and time, Col2: symbol, Col3: Notes) to the archive, I then erase the dates and times from the master table so that I can add new dates/times and notes on the next review. Maybe that’s a bad idea all around…but it’s been my method to date. I am actually going to try making the archive a new table…in fact, I have to confess I got confused about the difference between different tables and different views until a few minutes ago. Thank you again for your reply…and if you think there’s a better way for me to accomplish my goal, I would love to hear about it! Gregg ---
**Author:** ![Gregg\_Stebben](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/gregg_stebben/32/597_2.png) [@Gregg\_Stebben](https://connect.superhuman.com/u/Gregg_Stebben)\ **Post date:** [January 31, 2021, 6:47am UTC](https://connect.superhuman.com/t/copy-row-from-table-to-a-view-of-the-table/21093/4 "2021-01-31T06:47:48Z")
Just to update my own comments here…after creating a new archive table and messing around with Cross-Doc and Automations I realized that because I want to delete the dates/times and notes from the master list after they are added to the archive table, then the dates/times and notes get removed from the new archive table once the Cross-Doc syncs again or the automation runs again. Is there a way to automate or a formula for cutting and pasting info from one cell to another in the same row? Again, many thanks! Gregg ---
**Author:** ![Gregg\_Stebben](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/gregg_stebben/32/597_2.png) [@Gregg\_Stebben](https://connect.superhuman.com/u/Gregg_Stebben)\ **Post date:** [January 31, 2021, 7:11am UTC](https://connect.superhuman.com/t/copy-row-from-table-to-a-view-of-the-table/21093/5 "2021-01-31T07:11:16Z")
And I now realize this is an impossible mission. 😀 ---
**Author:** ![Christiaan\_Huizer](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/christiaan_huizer/32/28269_2.png) [@Christiaan\_Huizer](https://connect.superhuman.com/u/Christiaan_Huizer)\ **Post date:** [January 31, 2021, 9:27am UTC](https://connect.superhuman.com/t/copy-row-from-table-to-a-view-of-the-table/21093/6 "2021-01-31T09:27:59Z")
hi @Gregg_Stebben , you might be able to inject info in the same column a bit higher or lower following these two suggestions: 1. apply a ModifyRows via a button 2. use tricks to acces previousRows or followingRows. The logic behind [I wrote here.](https://huizer.medium.com/coda-io-and-previous-rows-a32011f562ed) I hope it helps. Cheers, Christiaan ---
**Author:** ![Pch](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/pch/32/17688_2.png) [@Pch](https://connect.superhuman.com/u/Pch)\ **Post date:** [January 31, 2021, 5:13pm UTC](https://connect.superhuman.com/t/copy-row-from-table-to-a-view-of-the-table/21093/7 "2021-01-31T17:13:07Z")
Hi there @Gregg_Stebben : Not sure if I understood correctly your setup but would this help ? 😇 https://coda.io/embed/daFK8PRA2v/_suUVW?viewMode=embedplay&hideSections=true (If yes, I can add informations later 😉 ) Edit : Or this maybe 😇 … https://coda.io/embed/daFK8PRA2v/_suI91?viewMode=embedplay&hideSections=true ---
**Author:** ![Piet\_Strydom](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/piet_strydom/32/19269_2.png) [@Piet\_Strydom](https://connect.superhuman.com/u/Piet_Strydom)\ **Post date:** [January 31, 2021, 5:41pm UTC](https://connect.superhuman.com/t/copy-row-from-table-to-a-view-of-the-table/21093/8 "2021-01-31T17:41:59Z")
If you had a single table, with an “archive view”, why were you cutting and pasting? As far as using two tables so that you can add new entries, not sure why you need to delete the old entries first? ---
**Author:** ![Gregg\_Stebben](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/gregg_stebben/32/597_2.png) [@Gregg\_Stebben](https://connect.superhuman.com/u/Gregg_Stebben)\ **Post date:** [January 31, 2021, 8:08pm UTC](https://connect.superhuman.com/t/copy-row-from-table-to-a-view-of-the-table/21093/9 "2021-01-31T20:08:58Z")
This is great stuff…I am going to have to brew a big pot of coffee and tackle this later tonight…it looks like a fun all-nighter!! Thank you! Gregg ---
**Author:** ![Gregg\_Stebben](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/gregg_stebben/32/597_2.png) [@Gregg\_Stebben](https://connect.superhuman.com/u/Gregg_Stebben)\ **Post date:** [January 31, 2021, 8:10pm UTC](https://connect.superhuman.com/t/copy-row-from-table-to-a-view-of-the-table/21093/10 "2021-01-31T20:10:26Z")
This is very interesting…you’ve shown me a lot of tools here I didn’t know were possible…I will try these and see what happens! Thank you! Gregg ---
**Author:** ![Gregg\_Stebben](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/gregg_stebben/32/597_2.png) [@Gregg\_Stebben](https://connect.superhuman.com/u/Gregg_Stebben)\ **Post date:** [January 31, 2021, 8:12pm UTC](https://connect.superhuman.com/t/copy-row-from-table-to-a-view-of-the-table/21093/11 "2021-01-31T20:12:37Z")
Hi, Piet…thank you for replying again! I am thinking about your questions…they are helping me look at what I am trying to do with a fresh perspective. You’ve given me some ideas here, and so have the others…I think I have a fun late night ahead of me trying some different things. Thank you again! Gregg ---
**Author:** ![Gregg\_Stebben](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/gregg_stebben/32/597_2.png) [@Gregg\_Stebben](https://connect.superhuman.com/u/Gregg_Stebben)\ **Post date:** [February 2, 2021, 4:57am UTC](https://connect.superhuman.com/t/copy-row-from-table-to-a-view-of-the-table/21093/12 "2021-02-02T04:57:41Z")
Oh man, this is beautiful! Both of these are better than I even imagined!! Thank you so much!!! Greg ---
**Author:** ![Pch](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/pch/32/17688_2.png) [@Pch](https://connect.superhuman.com/u/Pch)\ **Post date:** [February 2, 2021, 7:10am UTC](https://connect.superhuman.com/t/copy-row-from-table-to-a-view-of-the-table/21093/13 "2021-02-02T07:10:56Z")
You’re welcome 😊 ! Glad to know you could make it work 😊 ! (without the explanations I should have add but didn’t got the time to 😇 ) ---
**Author:** ![Gregg\_Stebben](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/gregg_stebben/32/597_2.png) [@Gregg\_Stebben](https://connect.superhuman.com/u/Gregg_Stebben)\ **Post date:** [February 2, 2021, 6:45pm UTC](https://connect.superhuman.com/t/copy-row-from-table-to-a-view-of-the-table/21093/14 "2021-02-02T18:45:28Z")
I haven’t made it work yet…but I am figuring the formulas out. This has been a great learning process for me…you showed me a lot of things with Coda I never knew were possible! Thank you again!! Gregg ---
**Author:** ![Gregg\_Stebben](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/gregg_stebben/32/597_2.png) [@Gregg\_Stebben](https://connect.superhuman.com/u/Gregg_Stebben)\ **Post date:** [February 4, 2021, 1:31am UTC](https://connect.superhuman.com/t/copy-row-from-table-to-a-view-of-the-table/21093/15 "2021-02-04T01:31:09Z")
Hi, Again! I pretty much figured this out thanks to you and all your help!! But I have one question: How can I make the button trigger when there is an entry in the Date & Time column instead of the Notes column? I tried figuring this out on my own, but I couldn’t make it work. I love this solution, I am so excited about it. Thank you again! Gregg ---
**Author:** ![Pch](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/pch/32/17688_2.png) [@Pch](https://connect.superhuman.com/u/Pch)\ **Post date:** [February 4, 2021, 10:38am UTC](https://connect.superhuman.com/t/copy-row-from-table-to-a-view-of-the-table/21093/16 "2021-02-04T10:38:17Z")
Hi @Gregg_Stebben : Sorry for the delay but what do you mean by “trigger” 😊 ? ---
**Author:** ![Gregg\_Stebben](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/gregg_stebben/32/597_2.png) [@Gregg\_Stebben](https://connect.superhuman.com/u/Gregg_Stebben)\ **Post date:** [February 4, 2021, 3:07pm UTC](https://connect.superhuman.com/t/copy-row-from-table-to-a-view-of-the-table/21093/17 "2021-02-04T15:07:35Z")
Ahhh! In other words, the formula you put in the button doesn’t recognize that there’s data to archive until there’s an entry in the Notes field. A better use case would be that an entry in the Date & Time field causes the button to recognize that there’s data to archive. For Background: In practice, before every note is written, Date & Time are input. But sometimes I input Date & Time but no note (to remind myself to add a note later) and those entries with only Date & Time should be archived too. Does that make sense? I feel like I should be able to tweak your button formula to make this change…but I just can’t figure it out. If you can help, I would be grateful. Thank you! Gregg ---
**Author:** ![Pch](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/pch/32/17688_2.png) [@Pch](https://connect.superhuman.com/u/Pch)\ **Post date:** [February 4, 2021, 6:12pm UTC](https://connect.superhuman.com/t/copy-row-from-table-to-a-view-of-the-table/21093/18 "2021-02-04T18:12:37Z")
Ah 😊 ! It’s the `Disable if` formula in the button 😉 . I’ve prepared another sample as you’ve added some useful context here (compared to what you said in your other posts, at that time, it seemed like the notes where the important part so I’ve used this as the main thing the button should look at, but if in fact the important part are the dates and times, that’s will work too 😉 ) but I’m going to begin with the `Disable if` part 😊 . The formula I used in the button (see sample below 😉 ) is this one : ```auto [Notes 3].Filter([Date & Time]="").Count()=[Notes 3].Count() ``` And what it does is : - Count how many rows in the table `[Notes 3]` in the field `Date & Time` are `Blank` 👉 `[Notes 3].Filter([Date & Time]="").Count()` - Count how many rows there are in the table `[Notes 3]` 👉 `[Notes 3].Count()` And then, **if** the `Count()` for the `Blank` rows in `Date & Time` **is equal to** the total number of rows in the table `[Notes 3]` , the button gets disable 😊 (because it means that all the rows (at least in the `Date & Time` field) in the table are empty. If it’s not the case and they are different (`!=` ), it means there’s at the very least one row with a `Date & Time` 😊 . Now, if you’re sure the `Dates & Times` are the important values here (compared to the notes) following one of the examples I’ve shared above, here’s now the `Action` formula of the button 😊 : `[Notes 3].Filter([Date & Time]!="").FormulaMap(RunActions(AddRow([Notes 3 - Archives],[Notes 3 - Archives].[Date & Time],CurrentValue.[Date & Time],[Notes 3 - Archives].[Stock Symbols],CurrentValue.[Stock Symbols],[Notes 3 - Archives].Notes,CurrentValue.Notes),ModifyRows(CurrentValue,[Date & Time],"",Notes,"")))` In short, the button does 2 things (that’s why I used `RunActions()` ) : 1. Copy the appropriate rows from the table `[Notes 3]` in the table `[Notes 3 - Archives]` (`AddRow()`) 2. Clear the `Date & Time` values and the `Notes` for the rows it just copied (`ModifyRows()`) Now, for the longer version : First the button needs to know which rows it should used to do what it has to do 😊 , in this case the rows where `Date & Time` are not blank. 👉`[Notes 3].Filter([Date & Time]!="")` Now that it knows which rows to use, it does this : 👉 `[...] FormulaMap(RunActions(AddRow([Notes 3 - Archives],[Notes 3 - Archives].[Date & Time],CurrentValue.[Date & Time],[Notes 3 - Archives].[Stock Symbols],CurrentValue.[Stock Symbols],[Notes 3 - Archives].Notes,CurrentValue.Notes) [...]` In other words 😊 : For each (`FormulaMap()`) rows in the list of all rows where the `Date & Time` are not blank (`CurrentValue`) add a row in the table `[Notes 3 - Archives]` with those values : - For the field `[Notes 3 - Archives].[Date & Time]` 👉`CurrentValue.[Date & Time]` The current value of the field `Date & Time` for that specific row - For the field `[Notes 3 - Archives].[Stock Symbols]` 👉`CurrentValue.[Stock Symbols]` The current value of the field `Stock Symbol` for that specific row - For the field `[Notes 3 - Archives].Notes` 👉`CurrentValue.Notes` The current value of the field `Notes` for that specific row After that, the button does this : 👉`[...] ModifyRows(CurrentValue,[Date & Time],"",Notes,"") [...]` and in others words : Still for for each rows (as it’s still in `FormulaMap()`) in the list of all rows where the `Date & Time` are not blank (`CurrentValue`) modify the value for the `Date & Time` field and put it as `Blank` (`""`) and modify the value for the `Date & Time` field and put it as `Blank` (`""`) too 😊 . And that’s it I think 😊 . https://coda.io/embed/daFK8PRA2v/_su8aa?viewMode=embedplay&hideSections=true Hope this helps 😉 ---
**Author:** ![Gregg\_Stebben](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/gregg_stebben/32/597_2.png) [@Gregg\_Stebben](https://connect.superhuman.com/u/Gregg_Stebben)\ **Post date:** [February 4, 2021, 6:20pm UTC](https://connect.superhuman.com/t/copy-row-from-table-to-a-view-of-the-table/21093/19 "2021-02-04T18:20:23Z")
Now I know why I couldn’t figure it out!!! This is genius…how can I thank you for your kindness? You are a master teacher… …and you’ve given me so many other ideas for how to apply these principles!! Thank you again! Gregg ---
**Author:** ![Pch](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/pch/32/17688_2.png) [@Pch](https://connect.superhuman.com/u/Pch)\ **Post date:** [February 4, 2021, 6:29pm UTC](https://connect.superhuman.com/t/copy-row-from-table-to-a-view-of-the-table/21093/20 "2021-02-04T18:29:03Z")
I’m very glad to know it helped 😁 (and it’s more than enough 😉 … but thank you for the compliment 😊 )! [Next page](https://connect.superhuman.com/t/copy-row-from-table-to-a-view-of-the-table/21093.md?page=2)