Skip to main content
Answer

Help needed - Updating a record triggers send email action twice?

  • November 9, 2020
  • 2 replies
  • 65 views

Forum|alt.badge.img

Hi,

I’m new to airtable and could really need some help.

I’m trying to automate a flow where an email is send to a client every time a new attachment is added to an existing record.

For that purpose i’m using the build-in automation feature.

The trigger I’m using is “When a record is updated”, View “Grid view”, and Fields “Attachment”.

The action i’m using is the Gmail: send email.

All this works fine.

My problem is that is sends the email twice when I upload a new attachment?

I have tried the same setup with Slack, and also here is triggers the actions twice.

What am I doing wrong?

Any help is much appreciated!

Best regards,
Jarl

Best answer by Jarl_Rosenlykke

I have had problems using “When a record is updated” as the trigger, because it fires every time the record is updated at all. I recommend using “When a record matches conditions” or “When a record enters a view” and creating a unique view or condition that will only fire once when a new attachment is added.


Thanks @Nick_Dennis,

I solved it by created a “Last Modified” column that monitors the Attachment column. This way the emails and slack messages only triggers once.

Thanks for pointing me in that direction.

2 replies

Forum|alt.badge.img+14
  • Participating Frequently
  • November 9, 2020

I have had problems using “When a record is updated” as the trigger, because it fires every time the record is updated at all. I recommend using “When a record matches conditions” or “When a record enters a view” and creating a unique view or condition that will only fire once when a new attachment is added.


Forum|alt.badge.img
  • Author
  • New Participant
  • Answer
  • November 10, 2020

I have had problems using “When a record is updated” as the trigger, because it fires every time the record is updated at all. I recommend using “When a record matches conditions” or “When a record enters a view” and creating a unique view or condition that will only fire once when a new attachment is added.


Thanks @Nick_Dennis,

I solved it by created a “Last Modified” column that monitors the Attachment column. This way the emails and slack messages only triggers once.

Thanks for pointing me in that direction.