Question

I have an inventory database and a purchases database.

• The inventory DB has a button that creates a new purchase, then opens this new page for the user to fill out a few variables.
• My purchases database has an automation that is triggered by 2 of those 3 variables being edited (and no "page added" trigger, since I believe it occurs at a different time).

When the 2 variables are edited, a 4th variable is supposed to be filled out by this automation. The automation isn't triggering, but it works just fine if I remove one of the 2 variables from the trigger. I'd appreciate it if I could get some help with this issue.

For context, my 3 variables are "Amount", "Price in local currency", "Exchange rate", and the 4th one is "Price in USD". That way, "Price in USD" can be filled out manually or calculated automatically by this automation if "Price in local currency" and "Exchange rate" are edited.

Thanks in advace!

Answer 1

It'll be best if you can share a screenshot of what you're trying to achieve.

But if I were to guess out of context, Notion automation doesn't work if you try to trigger each other.

For example,

Automation 1
When I update Status to Ready

It will try an automation to update the Ready Date to Today

Automation 2

If Ready Date is updated, then send an email.

In this scenario Automation 2 will not trigger as Notion doesn't allow multi-automation trigger.

Hopefully this answer your questions.

The workaround is to either use button to trigger it manually or use 3rd party tool like zapier or pipedream.

p.s. included a video explanation as well - YouTube