# Push Buttons in Certain Order

I want to push buttons in a column of a table in a specific order, first where a specific row contains A then B then C is that possible?

Not actually alphabetically because I realize I can sort the table how I need it and then the push buttons will go top to bottom. If this is the only way to go about it then is there a way to sort columns based on matches or would I just maybe add a formula column with a numbering scheme and then sort on that. (i.e. Column = Dog, 1, Column = Cat, 2, 3)

Thanks!

Hey there!

Test this out and hopefully it gives you some ideas. All formulas and explanations are inside the doc. There are definitely other ways to do it, but you can essentially wrap your actions inside a button using `RunActions()` which will specify the specific order in which they are pressed

1 Like

Scott,

Thanks for the quick reply. This was close but I forgot to mention a fairly big hurdle. My table completely reset and changes on a daily basis. My order is not necessarily A, B, C but more like press all Aâ€™s then all Bâ€™s then all Câ€™s, without know in advance how many of each their are.

I think a couple of hidden columns that help with sorting is probably the best bet I just donâ€™t like how often I use that as a crutch, my tables are riddled with extra columns.

In that case, you could probably do something like the following

``````RunActions(buttonTable.filter(letterColumn="A").button,
buttonTable.filter(letterColumn="B").button)

``````

Essentially saying - â€śHey Coda, go find every button in my table where the `letterColumn` is A and press it. After that is done, go find every button in my table where the `letterColumn` is B and press that.â€ť

Thatâ€™s gonna work! On mobile at the moment but will try it in a bit and circle back. Thanks Scott! Now I just need to solve this lookup of a multi select from a multi select problemâ€¦.

Just thought of a better way (if you are working with a data set that could be sorted such as numbers, strings of text alphabetically, or dates):

``````[Buttons in Order].Letters.Sort().FormulaMap([Buttons in Order].Filter(Letters=CurrentValue).Button)
``````

I reset my embedded document with a new green button that utilizes this method. Should give you some thoughts to work with. I can a think of a few other ways to get it done but difficult providing direction with a shared doc or exact use case.

Hopefully it helps though!

Just got done making my changes and your previous suggestion worked a charm. I may add this nested within the last one. I basically have text based categories with priorities â€śHighâ€ť â€śMediumâ€ť â€śLowâ€ť. The first solution addresses that and then what youâ€™ve just provided should allow me to sort within to prioritize dates.

1 Like

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