Automation rule trigger breaks when Select options are erased

Your Setup:

  • SeaTable Self-hosted 5.3.12

Describe the Problem/Error/Question:

Under the following circumstances, automations stop triggering:

  • Include a Single / Multiple Select column in your table
  • Add 3 or 4 options in the Select (A, B, C, D)
  • Create an automation that is triggered by changes to a record
  • Watch the Select column, and trigger by “one of“ two of the options (A,D) of that column
  • Test the automation - it should trigger when one of the options (D) is chosen.
  • Remove option D from the Select column

Even when you select “A“ from that column, the automation does not fire any more. Option “D“ now shows as “Option has been removed“ in the automation trigger, and has to be removed there for the automation to work again.

That might be consistent behaviour of the system, but it’s very hard to debug: You have to think of the fact that the column is used as a trigger, and look into every automation after you have changed the column options.

Nicer way would be to make the triggers more robust: Instead of stumbling over Conditions using “Option has been erased“, they could just ignore them and continue.