I’m trying to figure out a way to create an automation that will trigger a script when I create a new record from within a filtered view. We have one airtable base that manages all content type for our website, and I handle a subsection (the blog). I have a filtered view that shows the publication pipeline for just blog posts. When a new item is created in our AirTable, we have automations set up so that if you check a box, it will create a Google Doc that is affiliated with that record. I’ve been trying to set it up so that if I create a new record from within a filtered view (i.e. I create a new record under “proposed story”), which has already been filtered to only show blog posts, I’d like it to run the script to create the Google Doc.
It seems as if everything I try requires an additional manual step (either change the content type to blank and then change back again to blog post OR uncheck and then recheck the box to create a Google Doc). Is there any way that if a record is CREATED within a filtered view (not moved to a filtered view) for an automation like this to run?
Thank you for any help you provide! I’ve spent far too long trying to figure out a solution on my own.
