Skip to main content

Prevent automation triggering if value is changed by another automation

C
Forum|alt.badge.img+1

Hi all

I have a situation where shopify inventory levels in airtable can be changed manually by a user or automatically by shopify when a product is sold.

I have an automation that watches changes to the stock level value and on change, triggers an automation to update shopify via a webhook via integromat.

The problem is that when an order is placed in shopify, this automatically changes the stock level in airtable via integromat, but, this also triggers the airtable automation which then updates shopify again.

How can I prevent the automation from running if the stock level change was a result of an automatic update from shopify rather than a user created update action to the stock level please?

I have tried looking at last modified by but this doesn’t change whether it’s an automation of a webhook that changed the value.

Any help would be gratefully received.

Thanks

Claire

3 replies

Kamille_Parks11
Forum|alt.badge.img+25

Try adding a “Last Modified By” field and adjusting your Automation not to run if that field is “Automations” or maybe “Anonymous”

C
Forum|alt.badge.img+1
  • Claire_Conza
  • Author
  • Inspiring
  • 18 replies
  • December 17, 2020
Kamille_Parks11 wrote:

Try adding a “Last Modified By” field and adjusting your Automation not to run if that field is “Automations” or maybe “Anonymous”


Thanks Kamile

‘Last Modified By’ doesn’t change whether it’s an automation or an external service that affected the change in value - in my case at least. This was my first idea that I mentioned above.

Kamille_Parks11
Forum|alt.badge.img+25
Claire_Conza wrote:

Thanks Kamile

‘Last Modified By’ doesn’t change whether it’s an automation or an external service that affected the change in value - in my case at least. This was my first idea that I mentioned above.


Sorry I missed that part of your post. I believe external sources uses your API key so Airtable considers it “you” making the change. Is there any way data from Shopify comes in that only happens when Shopify does it?

Can you set the Automation not to run if the last modified time of the Stock field is equal to the last modified time of whatever other fields Shopify is editing?

Reply


Most helpful members this week

Terms & Conditions