Change text when all of the checkbox is checked.

[SuperNam]

Hi Everyone. I have 2 tables that are connected via ID. I want to change a field of my table 1 to "Complete" when all the checkbox in table 2 has been checked. Is this doable? Thank you in advance!

[IamNatoyThatLovesYou]

Hi @SuperNam, I have here a trigger you can insert to your table that has the checkbox. This will update your table with the status to complete when all of the checkbox related to the id has been checked. I hope this helps!

 

- Natoy

[SuperNam]

Thanks @IamNatoyThatLovesYou! This worked!

 

[IamNatoyThatLovesYou]

That's great. They also have a Documentation for triggers. You can check it here.

[astroboy]

Hello there, I encountered a similar workflow in the past but instead of doing it on the table level, I created mine on the DataPage level. This is possible using calculated fields with the help of SELECT and CASE WHEN statements. The only downside of this solution is that the output is not being saved in the table. For reference, you may check this HowTo article:

https://howto.caspio.com/function-reference/