Is there a way to trigger an automation when a record is removed from a view? I know there is one from when a record enter a view, but I need the opposite and my random tests have not been working!
Answer
Airtable Automation - When record is removed from view trigger
+5Best answer by kuovonne
You can create a view with the opposite conditions as the actual view, so that when the record leaves the original view, it will enter the new view. Then use entering the new view as your condition.
+29You can create a view with the opposite conditions as the actual view, so that when the record leaves the original view, it will enter the new view. Then use entering the new view as your condition.
+5You can create a view with the opposite conditions as the actual view, so that when the record leaves the original view, it will enter the new view. Then use entering the new view as your condition.
Thank you for this! Is there a way in the action to show who made the change? and specifically what the filter column changed to?
+29The automation itself does not know who made the change that triggered the automation. So you need to get this information from field values.
You can use a combination of {Last Modified By} and {Last Modified Time} fields to get this information.
The automation will also have the current field value for the filtered value. It will not have the previous value of the filtered field. Getting that value requires another field to store the old value, and automations to keep it updated.
+5The automation itself does not know who made the change that triggered the automation. So you need to get this information from field values.
You can use a combination of {Last Modified By} and {Last Modified Time} fields to get this information.
The automation will also have the current field value for the filtered value. It will not have the previous value of the filtered field. Getting that value requires another field to store the old value, and automations to keep it updated.
This makes sense! Thank you so much for your help here!
+21Glad to know that you got the answer you were seeking! If you would, please mark @kuovonne’s comment above (whichever one feels most appropriate) as the solution to your question. This helps others who may be searching with similar questions. Thanks!
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.