Skip to main content
Best answer

Creating a trigger only for modified Airtable records

  • February 7, 2023
  • 4 replies
  • 261 views

Hi Zapier community!

Workflow question for you all. Is it possible to create a Zapier trigger that sends pre-populated text to Slack within a comment thread?

More context

Here’s my current project management workflow (Airtable + Slack triggers):

  • Project is submitted via an Airtable form.
  • Once the project enters Airtable, an automatic message is sent to a specific Slack channel with additional details (e.g. who submitted the project).

Here’s the workflow I’m trying to build:

  1. Project is submitted via Airtable
  2. Once the project enters Airtable, an automatic message is sent to a specific Slack channel with additional details.
  3. If a specific field in Airtable is updated (e.g. a dropdown status field is changed to ‘in progress’), an automatic message is sent to a specific Slack channel (ideally the message in #2 creating a threaded comment).

Right now it looks like you can only create triggers for new records or new AND modified records, not just modified records. So I’m not entirely sure if this workflow or a variation of it would work.

Any help/guidance would be greatly appreciated!

Best answer by Troy Tessalone

Hi @jb_crunchbase 

Good question.

You need to specify a Last Modified field.

You can use a Last Modified field in Airtable that only watches a specific column.

https://support.airtable.com/docs/last-modified-time-field

 

 

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

4 replies

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • Answer
  • February 7, 2023

Hi @jb_crunchbase 

Good question.

You need to specify a Last Modified field.

You can use a Last Modified field in Airtable that only watches a specific column.

https://support.airtable.com/docs/last-modified-time-field

 

 


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • February 7, 2023

@jb_crunchbase 

Alternatively you can use Airtable Automations to trigger Zaps:

 


  • Author
  • Beginner
  • February 8, 2023

Thanks for your thoughts, @Troy Tessalone ! This is helpful. Is there any way to create automated messages that go to a Slack thread in a specific channel or create a thread within an existing comment in a specific channel?


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • February 8, 2023

@jb_crunchbase 

In the Zap action: Slack - Send Channel Message

There is this field for Threads