Skip to main content

Hey! I am struggling to search records in integromat. I have a table with field Status and Last Modified Status autofield. When I try to fetch data with integromat with formula everything is ok:

({Last Modified Status})

but when I add condition to the formula:

({Last Modified Status} <= "{{addDays(now; -30)}}")

it fails with:

The formula for filtering records is invalid: Unknown field names: last modified status

I also tried this formula with the same error:

IS_AFTER({Last Modified Status}, "{{addDays(now; -30)}}")

Any ideas how to fix this error?

Hi @devas,

Welcome to the community :tada:

Try something like

(LAST_MODIFIED_TIME({Status}) <= "{{addDays(now; -30)}}")

Best
Sergio
https://devblocks.agency
If this reply fixed your problem, please mark it as a solution :white_check_mark:

Hi @devas,

Welcome to the community :tada:

Try something like

(LAST_MODIFIED_TIME({Status}) <= "{{addDays(now; -30)}}")

Best
Sergio
https://devblocks.agency
If this reply fixed your problem, please mark it as a solution :white_check_mark:


It looks problem is within Integromat formula. When I copy working formula to VS Code, then edit and copy from VS Code to integromat again (even without changes) itt fails with unknown field error.
Anyway, thanks for the help!

Terms & ConditionsAccessibility statement