Create a row and reference it at the same button press

Hi @Vasily_Skalon,

RunActions runs sequentially in the order written but do not carry values from one action to another.

Thank you for the detailed summary of what you have and what you want it to do. I am not sure the example I have put together does it justice but the core functionality should be there for you to adapt.

Explanation:
You have a Lookup column in your starting table (Daily Reports). It uses ModifyRow and to update that row in Daily Reports and for the value of the lookup we use AddRow. In this way the result of the AddRow which is the new row feeds back into your lookup. The next action does the same thing again but rather than modifying thisRow we are modifying the row now stored in our Lookup column.

I hope that the doc and explanation make sense.

If you would like something more tailed to your exact structure you will need to provide a safe copy of your doc that we can work on. The best method is to create a copy of your doc, delete all rows of data, add some dummy data and then share it. You can find info on sharing here: https://help.coda.io/en/articles/1137949-sharing-your-doc. Be sure to set the sharing tab to “people with link can View” and then copy and paste the code from the Embed tab.

Kind regards

Dale

2 Likes