Skip to main content
Best answer

Creating a trigger only for modified Airtable records

  • February 7, 2023
  • 4 replies
  • 105 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 TessaloneBest 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

 

 

View original
Did this topic help you find an answer to your question?
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
Forum|alt.badge.img+14
  • Zapier Expert
  • 30938 replies
  • 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
Forum|alt.badge.img+14

@jb_crunchbase 

Alternatively you can use Airtable Automations to trigger Zaps:

 


  • Author
  • Beginner
  • 4 replies
  • 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
Forum|alt.badge.img+14

@jb_crunchbase 

In the Zap action: Slack - Send Channel Message

There is this field for Threads