May 18, 2020 07:09 PM
When someone completes a form and a new record is created in the grid, how can I notify my team about the new record?
Solved! Go to Solution.
May 29, 2020 10:39 PM
At the bottom of the form setup, there is an option you can switch on to have the account owner notified via email of each new form submission. With that switched on, add a filter/rule in your email client that forwards all such notifications to certain team members.
May 18, 2020 09:46 PM
There are no official notifications built into Airtable (except for collaborators getting notified of comments made to a record that they are either watching or have been added to as a collaborator).
So, a few different ways that you could approach this:
A fun & whimsical (although mostly unhelpful) way of being notified is using the chime block. It makes an alert sound of your choice whenever a new record is added to a specific view. However, the 2 major problems here are that: (1) the block must always be visible on your screen in order for the chime to work, and (2) if you’re away from your computer, you’ll miss the chime.
You guys could MANUALLY check for new records periodically throughout the day by creating a new view that only shows you new records that have been added via your form (but haven’t yet been reviewed by any team members). This new view would be filtered by the criteria of your choice. One possible way that you could filter this view would be to create a new checkbox field that you check off whenever you have reviewed the new record. If this checkbox IS NOT checked, then you could filter the record to appear on this view.
For fully-automated notifications, such as automatic email notifications or automatic Slack notifications, you would need to integrate an external automation tool, such as Integromat or Zapier. (If this gets too complicated for you and you feel like you need to hire an Airtable consultant to help you program this, feel free to send me a private message.)
Hope this helps! :slightly_smiling_face:
May 29, 2020 10:39 PM
At the bottom of the form setup, there is an option you can switch on to have the account owner notified via email of each new form submission. With that switched on, add a filter/rule in your email client that forwards all such notifications to certain team members.
May 30, 2020 09:15 AM
@Ruby_Benoit If you got the answer you were seeking, please mark the appropriate comment as the solution to your question. This helps others who may be searching with similar questions. Thanks!
May 30, 2020 10:26 AM
@Ruby_Benoit I appreciate the solution mark, but you marked my request as the solution, and that comment didn’t actually contain the solution. If you would, please change the mark to the comment that actually contains the solution to your question.
May 30, 2020 02:33 PM
Oh, duh! I totally missed that @Ruby_Benoit asked about doing this through a form. :man_facepalming:t2: Another one of my late-night posts where I’m too tired to read properly. :crazy_face:
Simple & easy solution, @Justin_Barrett, that is built right into the system! :slightly_smiling_face:
In fact, now that I think about it, suggesting this form method for adding new records could be a perfect solution for anyone who wants to get automatic email notifications about new records being added. Someone could even use the new table permissions to prevent users from creating new records via the Airtable interface itself — which would then require users to always add their new records via a form.
Nov 29, 2024 09:41 AM
Hi there!
miniExtensions is a great alternative for achieving this with more advanced tools available to you. We've created a third-party form that integrates seamlessly with Airtable and can send emails automatically after submission to a default email address that won't be shown to the form submitter. You can configure it form settings:
In the Engagement section of the form settings, you can select the field containing the recipient’s email (configure a default value for this field if you want a static value that can be hidden), the field for the email subject, and the field for the email body, which also supports rendering an HTML formula. This feature allows extensive customization options, enabling you to incorporate data from other fields directly into the body of your email: