This message was deleted.

You can create a new field formula, which value depends on the selected field. Could work out

Thanks @sticky-night-20812. I don’t think that would help. It’s not a problem for me to find out the value of the current state, it’s the problem that I don’t know from which value it changed. e.g. I have a single select field = “A”, “B”, “C”. I need to run an automation when it changes from “A” to “B” or from “A” to “C”. But not when it changes from “B” to “C” or “C” to “B”. In my situation, I have even more drop-down values.

If it’s really that much dynamic then my first thought is to script it. So, you could still use another column to trigger the automation, or something else, and the “business logic” would happen within a JS script. You’d also need a column that contains the “previous” value, which would be read and then updated by the script to keep it in sync with the “value”. It’s a bit complicated to explain maybe (I just woke up, doesn’t help) Basically, two fields: currentValue (single select) and valueBefore (text) One automation, reads both, and does something different based on both values In the end of the automation, update valueBefore to match the new value in currentValue Could not need a custom JS script, depends on the complexity, scripting might be simpler to maintain in such case

Yes, that would make sense (to use the script to keep old value)