How to know who actually changed a column value

Again, I ask you devs here for help about how to know who (or what) actually changed a column value when the action is triggered by a user.

I have an integration which uses “When column value changes” as a trigger.
If the action is “change column value” and both trigger and action are set to read and write on the same column, this potentially causes an endless loop.

For example, if my integration doubles the number inside a column, the value is doubled endlessly, despite the number was typed by a user or updated by the app.

As the app uses the ShortLivedToken key sent by the integration, the action is performed with the users credentials and there’s no way to know if the change came from the user or the app.

My current solution is to block the execution of the integration if the trigger column and the destination columns are the same, but that’s not so elegant and precludes some legit uses.

Do you have any suggestions?
Thanks for your help.

6 replies