Hi - I have a lookup control that, when changed, should trigger an automation. Is there any way to make this happen?
You could possibly have a table (single-rowed) that references the control via formula. Then have the automation run off a row-change for that table. It should trigger every time the control changes.
Alternatively (as I haven’t tested the previous scenario out) - You could utilize a single celled table as a control and then let the automation run off that row-change.
I like @Scott_Collier-Weir 's ideas as a workaround, but it would be really great if you could set the “when” of an automation to trigger off of a Control changing. E.g. I have a Select control that I’ve named and would like to reference in a similar way to a “row change” in a table, or how Controls can be referenced for Filters.
Just wanted to express it here in support of the OP’s idea and it seems more intuitive to be able to do this rather than kludge it via a table.
In general it seems the automations system needs a major overhaul. It could be so much more useful than it is. Similarly, I wish they introduced the same sequential mechanics into the core formula language: