Skip to main content
We recommend building automation examples directly in AI chat. Just describe the automation you want, and AI will handle the full setup for you, including the trigger, actions, script, and configuration.

Build with AI

Open the AI Chat in your table’s right sidebar and tell AI what you want. For example, you can say: “When a task’s status changes to Completed, write the current date and time into the Completed At field” AI will create the complete automation automatically. You can review the generated script, test it with real data, and enable the automation when ready.

Manual setup

  1. Create an automation with trigger When record matches conditions.
  2. Select your Tasks table.
  3. Set the filter: Status is Completed.
  4. Click Test.
  5. Add an action → Update record.
  6. Map:
    • Record ID → the trigger record’s ID (via +)
    • Completed At → use an expression or set to the trigger’s timestamp
  7. Click Test, then enable.

Why “When record matches conditions”?

This trigger runs each time a record changes from not matching to matching the condition. Edits to other fields while Status remains “Completed” do not run the automation again or overwrite the saved time. If the task leaves “Completed” and later returns, it can trigger again and update the timestamp.

Variations

  • “Started At” — trigger when Status becomes “In Progress”.
  • “Escalated At” — trigger when Priority becomes “Urgent”.
  • “Approved At” — trigger when Approval becomes “Yes”.
Last modified on November 11, 2026