Automation to create a note when a tag is added or removed

Hi Boppa,

Regarding your requirement: “Automation to create a note when a tag is added or removed” — I understand you want a note to be created automatically in the Notes table whenever the “Awaiting Payment” tag is removed from an order.

For PostgreSQL, this can be solved with an AFTER UPDATE trigger on the Orders table:

• The trigger will compare OLD.tags and NEW.tags.

• If OLD.tags had “Awaiting Payment” and NEW.tags no longer has it, then the trigger will insert a note into the Notes table.

This approach removes the need for a separate “Tags Previous State” field since the trigger itself handles the comparison.

If you are using a different database (MySQL, SQL Server, etc.), let me know — I can share the solution for that as well.

Thanks ​@TheTimeSavingCo - it’s so simple once you see it in action. Thanks very much.

​@palak_12 - I like what you suggest, and it makes perfect sense, but I’m not using any of PostgreSQL, MySQL or SQL Server. Just Airtable and Softr. Thanks for contributing - I am sure somebody else will find this helpful too.