Automation to match one property in a Notion database to another passed the test but isn't running for new entries

Hi ​@Matt BR 

Help links for using Notion in Zaps: https://zapier.com/apps/notion/integrations#help

For us to have more info, post screenshots to give us context about how your Zap steps are outlined and configured in EDIT mode.

Hi ​@Matt BR, welcome to the Community! 🎉

Is your Zap using the New Database Item trigger that Troy referenced, or is it using the Updated Database Item trigger?

If it’s the latter, was the Next Due field updated a short time after the item was created—specifically within 1 minute? Asking as the timestamps in Notion are set to the nearest minute. If it's edited within the same minute that it was created then that might be why the Zap isn’t triggering on it, as the created and edited timestamp would have the same value and not be seen as an update causing it not to trigger.

And if the Next Due value was updated well over a minute later it, is it only that formula field that’s being updated? As Troy noted, Formula fields aren’t fully supported currently so that might be the cause for it not triggering. 🤔 That said, is the formula being updated when a value is updated in a different field (one that is supported) on the same item—and if so, is that field updated manually or by another Zap?

Looking forward to hearing from you!

Hi ​@SamB it’s using the Updated Database Item trigger. I tried waiting longer than a minute to edit it and it still did not run the zap.

The Next Due (formula property) is being updated when the user clicks a button “complete task” and then the Next Due is calculated based on the Last Completed Date and Frequency properties (if frequency is set to weekly, then next due is set to 7 days from the Last Completed Date). 

I’m having a similar problem with another zap that is supposed to mark a property as “true” based on another property (formula) calculating as “true”.  In both cases, the test runs correctly (when I select the specific database item to run the test on) but then the zap does not run when I try it on another database item (not a test). 

Thank you for your help, it seems like this is probably the same issue I’m having in both zaps.

You could well be right, ​@Matt BR. If both Zaps that are affected are need to trigger off of a change that’s being made to a formula field then they’re likely running into the same issue.

I’ve just tested a simple formula in a Notion that adds the value of two separate columns together, then edited one of the values which caused the formula to update triggered my Zap. So I thought, maybe it’s to do with the button that’s updating the Last Completed Date field. Perhaps that sort of change isn’t deemed by Notion’s API as an edit by a user?

So I tested with a button that updates a Last Completed field which is connected to a formula field to generate a “Next Due” date. And that was able to successfully trigger the Zap:

Which suggests that it should be working in your case as it’s pretty much the same setup. 🤔

In both cases, the test runs correctly (when I select the specific database item to run the test on) but then the zap does not run when I try it on another database item (not a test). 

The Updated Database Item trigger only allows you to select a Database, not a specific database item in it’s setup:

If it’s not triggering when you select a different database it might be that the Zap doesn’t have the right access permissions for that other database page. Do you think that could that be the case?

If not, then maybe there’s some sort of disconnect between Notion and Zapier. In which case it might be worth turning the Zap off and back on again to reset the connection, as well as reconnecting your Notion app account.

Let me know how it goes, keen to ensure this gets sorted!