Can't pick up the right entries from AirTable: Last Modified Time vs. Triggers

[BlackCubeLabs]

Hi,

I have this automation that looks at all entries available in an AirTable and is supposed to be triggered every time a row is modified. Then, when it finds the status is APPROVED, it will post on various social media.
There were no issues at the beginning, when I had only a few rows populated, but now that I have hundreds of rows, things are no longer working.

Why? Every time the scenario runs, it scans a row with a modified entry but does not pick up the one with the status APPROVED. Just one that has an empty status.
It is because the STATUS APPROVED filter comes later.

Do I need to use a filter formula on the first airtable module perhaps? I already have one filter between one module and another, but not one inside the airtable module.

The desired outcome is that the automation scans whatever row has been modified recently AND has a status set to APPROVED.
Sharing a few screenshots to better understand.

Thanks for your help.

[Benjamin_from_Make]

Hello!

I’m not an expert in Airtable, but according to their documentation, the IF condition should have an outcome, and maybe you need to add curly brackets. Can you try this? IF({Status}="APPROVED",TRUE(),FALSE())

Benjamin

[BlackCubeLabs]

@Benjamin_from_Make

IF({Status}=“APPROVED”,TRUE(),FALSE())

Thank you. Nothing happens.

[Benjamin_from_Make]

But also you may need to reset the index of the module. Watch modules only pick the newer records.
So try and right-click on the module, select « choose where to start » and select All. Then run again to see if you get anything.

Maybe also my formula is wrong, I have no way to test.

Benjamin