Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Feb 01, 2021 08:54 AM
I’m having trouble with an automation I created to notify other team members when a long-text field is updated on a record. Edits to the field generate multiple emails instead of only one. How can I get the automation to send only one email with the complete update?
The same issue is documented here, but the thread is closed and I can’t see the solution anywhere.
Thank you!
Feb 02, 2021 03:27 PM
I’m the guy who posted that earlier question – same as the question you have now. I clicked back to it and I see that it’s closed because (it claims) the issue was resolved. I don’t recall the issue being resolved.
I just looked at this again. I came up with a kind of workaround:
Now the way it works is, user clicks into the Update Sent field, gets a calendar dropdown and clicks the “Today” button. That enters the current date/time (so you now have a record of when the update email was sent). And because clicking into a date/time field like this and selecting “Today” is a single event (unlike typing a bunch of letters), the field is only updated once, and thus only 1 email will be sent.
Of course this isn’t perfectly satisfactory. The email part is automated, but the triggering part isn’t. So user has to know to click on that field and update it by clicking ‘Today’. No change in that field, no email. The other reason this isn’t super satisfactory is that it’s possible for somebody to trigger the sending of an email without actually changing the record.*
By the way, I thought perhaps I could finesse the problem by editing the trigger field in a form. Web form, maybe (didn’t try that). But a normal Airtable data-entry form (what you get when you hit spacebar with a record selected), nope. Still sends multiple emails.
William
Feb 02, 2021 05:42 PM
Hey All,
I’m also looking to sort out the same issue! so following this post.
Feb 03, 2021 01:17 PM
I also tried to use the “when record enters a view” trigger and created a view to accommodate when the field is not empty… same result, if actually sends the first letter of the text in the row and that’s all…
Aug 25, 2022 09:22 AM
Following. Same issue.
Aug 25, 2022 10:09 PM
Hey @Angel_Clark, you could:
Last Modified Time
field to track the long text field in questionLast Modified Time
fieldThe downside is that your automation might run anywhere from 5 minutes to an hour or two later, so if you need emails to be sent out quickly this might not work for you though