How to reference a field in Time-Based Automation?

Hello everyone!

I’m trying to create a time-based automation on a table that performs an action for rows that have a checkbox that is unchecked.

I’m having trouble referencing the field correctly.

I’ve tried things like:
thisrow.[complete] == false()
false(thisrow.[complete])

But in each case it appears that thisrow.[complete] is not the correct way to reference a field.

How can I do this?

Hey @Chris_Hall ,
I’m doing something similar and I remember that I also struggled with that. I worked around it in a different way, maybe it helps:

  • I’ve added a button column in the table. The button runs the action I want to automate. E.g. change column value or post to slack
  • In the THEN I filter the table and run the button for all rows with empty result column (in your case false checkbox) with

[tableName].filter(result.isblank()).[ButtonColumn].RunActions()

That way you don’t need to reference any “thisrow” or “result of step x”. :man_shrugging:t3:

Is that what you mean / would that work for you?