The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
Jun 29, 2023 08:28 AM
Can an automation be created (and how) based on frequency that a particular person in the CRM fills out a form appears as well as the frequency between submissions?
Example: B2B partner X fills out a form on our site on June 1 that appears in the Airtable CRM. I would like to receive an alert when there is no new submission from B2B partner X after 60 days.
How can this be created?
Maybe a very simple logic but I can't come up with it in Airtable automations. Eternal thanks!
Jun 29, 2023 09:57 AM
A simple solution (if you have a "last submission" field) would be to create a new view filtering on that where the date is on or before 60 days ago. You could then use the "when a record enters a view" trigger on your automation.
Jun 29, 2023 10:08 AM
Thanks @BillH, but how do I create the condition that it only alerts me when the specific client hasn't filled in the form after 6 days past the first one?
Jun 29, 2023 10:16 AM
It's hard to give a specific answer without knowing the details of the tables involved, but the filter for the view I suggested is
whatever field you are using would replace Calculation_2 in the example, and you can just adjust the number of days to 6 (or whatever you need).