Row Unique Buttons Actions

[Mario]

Hi @Andy_B, thanks for sharing the doc

Notes: as @Johg_Ananda have already posted a nice solution (good looking, probably well made and working fine, i haven’t tested it ) i will not re-start with the explanation but instead i’ll take Johg steps and comment them

We can divide the solution in 3 steps:

1. having all the button that you need placed and working!
   this means that you have to set up all the buttons that later you will be “pressing” in all the table where they are needed.
   (p.s. be careful with button use regarding ‘coda best practice’ done by the amazing @Paul_Danyliuk, they can be really heavyweight in the final doc! more info here:

This doc is too big to sync

Here are a few very short facts. I’ll expand on these in my blog when I have more time. The doc size limit is 125 megabytes. This is 0.json (schema file) and 1.json (data file) size combined in their uncompressed form: [image] When the doc goes over this limit it becomes “too big” and you won’t be able to access it through API / Cross-doc, and automations will most likely not run either. You’ll still be able to open it in your browser — it just won’t open on Coda servers for automation/API…

2. create a dashboard page where you place all the needed buttons, the one that will RunActions to press the other made in the 1) point (this can be achieved both with canvas buttons or with table buttons, chose your preferred one )

3. Configure and test your button to work properly
   this in the longer part obv, and based on your shared doc i can see that you have already a basic understanding in how RunActions works, just let me share my way

---

Your current way of setting up buttons:

What you are telling coda here it’s
“Press ALL the buttons that are in the table ‘TEST TABLE BTN 1’, the one in the column BTN”

---

My proposed way is this one:

What i’m saying here is similar but with more freedom
“Press ALL the buttons that are in the table ‘TEST TABLE BTN 1’ and satisfy the given filter (in this case a stupid checkbox check).the one in the column BTN”

If you want you could have also other button column to recall, to create more peculiar setups
In the same formula you can play as you like with various conditional “if()” or retrive data in a give table/cell to modify the output of the actions, and blablabla
More info here:

How to perform multiple actions with a single button (or, how to use RunActions()!)

Ooh, there’s so much more to that! If/Switch/SwitchIf work within actions: If( thisRow.Done, SomeTable.AddRow(...), OtherTable.Filter(...).DeleteRows() ) Use _Noop() (no operation) if you only need to do something if the condition is true but nothing if it’s false: If( thisRow.Done, thisRow.DeleteRows(), _Noop() ) FormulaMap() works within actions: Projects.Filter(...).FormulaMap(RunActions( thisRow.ModifyRows([_Current project], CurrentValue), Tasks.Filter(Project = th…

hope that helps, update us on your progess!!!