How to make a latched flag or checkbox?

1

Hello,

I am attempting to create a doc that assesses whether individual tasks are accomplished on time or not. I have a formulaic column in a table that states a job is overdue if it is past the due date and is not completed. I would love to create another column that contains a latched column called “Ever Overdue?” that once triggered to become true will never revert back.

Essentially, I want a column for tasks that are currently overdue and one for tasks that have at any time been overdue. How can I use Coda to accomplish this automatically?

I have everything else built: I literally only need a way to make a checkbox persistent.

Thanks!

1 Like
2

Hi Samuel,

Welcome to the community!

There are many many ways to accomplish what you are asking for, but since you don’t seem to be interested in storing when was it overdue etc. in my opinion the simplest solution would be:

  • Create 2 checkbox columns
  • Hide the 1st one and introduce a formula to the 2nd one to equal the 1st one, so that it can’t be modified
  • Create an automation triggered daily at 00:00: If a task is overdue, set the 1st checkbox to true

Hope this helps,

Pablo

1 Like
4

Pablo, thank you for answering!

One follow-up problem: My initial Overdue column is formulaic, so the automation rule cannot use it in the condition clause in order to change the first manual checkbox column.

Am I mistaken?

1 Like
5

You can do almost anything in Coda :slight_smile:

Just leave the If part of the automation empty and define an action similar to this:

image

or if you don’t want to modify rows that already had Checkbox1 activated, then

Table1.Filter(Overdue? AND Checkbox1.not()).ModifyRows(Checkbox1,true)

1 Like
6

That worked!

Thanks a ton for the help. I clearly have a lot to learn.

2 Likes
7

Coda has a steep learning curve, but totally worth it to climb it!

2 Likes
8

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.