Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Search records by (Last Modified Smth)

Topic Labels: Integrations
Solved
Jump to Solution
495 2
cancel
Showing results for 
Search instead for 
Did you mean: 

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?

1 Solution

Accepted Solutions

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:

See Solution in Thread

2 Replies 2

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!