Cannot set field value when filtering for an Automation

Question

Hey all. I'm trying to create an automation to delete certain records each day. I've done this before but the interface does not look the same for the current table.

Here is the way I expect it to look:

Here is what the new automation looks like when I try to create it:

Notice that in the second image, the value (Unchecked) is grayed out. I cannot change it to Checked like the other one. I tried turning the automation on with
Should Delete is not equal to the value Unchecked
But this tried to delete ALL Vendor Invoices!
Can anyone shed some light on why the second automation is not acting the like first? Both fields are Checkbox Formulas.
Thanks!
------------------------------Nick Mangine------------------------------

AustinK · Answer

Is "Should Delete" a field in both tables or is it a lookup to one of those tables? That might make a difference. Automations are weird sometimes.

What do you see as options for the second automation? Are you able to pick anything other than the greyed out unchecked?

Sign up

Login to the community