Automated card button with complicated move request

[Domenic Curulli]

I almost have my board running perfectly automated, except for this last integration I cannot work out!!

I have a list setup for each day of the week, with jobs assigned to that day. See below for an example, showing at the top a job that needs to be completed marked yellow.
Once that setup is done, the user hits an automated card button 'Strike' which completes a bunch of actions, one of those is moving it to the bottom of the list (end of the day) so my team know to strike this event at the end of the day.

 

However I also have events that are marked with label 'Set Next Week' and assigned next weeks date. I do not want the strike automation button to move it below the next week jobs, but instead move it below every card in that list except anything with a 'Set Next Week' label. Basically, the next week card should always be at the bottom.

The catch is, I do not want to do this via the 'sort by list' action, as I believe it would sort and move every card in that list, ruining the order I have things set above.

I also cannot use 'sort by date' as again, it would shift everything around depending on the date and time set which I do not want. Also, some of these cards move across multiple days before they are selected as 'Strike' so that action would not work.

Tl;Dr - how can the automated button move a card to the bottom of the list, but above items with a certain label or date?

Let me know if I can clarify anything, as it's hard to explain but simple in practice!
Thanks

[Domenic Curulli · Accepted solution]

Nevermind - I jumped the gun and think I have it working!

I added the following action to the bottom of the action list for the button

- sort the list by label pink "Set Next Week" - descending

This seems to do exactly as required, keeping the next week labels at the very bottom.