Button to uncheck checklists

2

Hey @Marissa_Griffin ,
I only know a very “hacky” workaraound, that uses an experimental hidden formula of Coda. These formulas need to be used with caution, because they could also break one day. This is also probably more advanced, but I try to explain it in detail and step by step and provide a demo.

Click here to Show Demo

Approach
The use of the inline checkbox makes a complex object out of the normal text. That is why we can not just “replace” or “uncheck” the checkbox inside your textcolumn.

But with experimental formulas, we can have a look into the complex object, edit the object to our need and then put it into the column again with a button.

Step-by-step

  1. I made column called “Ingredients_raw” where I output the JSON of the “ingredients” list with the formula
    ingredients._merger()+"".
    When you have a look at the output now, you can spot our desired part: “isChecked”:true or “isChecked”:false. You will see that these values change when checking/unchecking a checkbox in ingredients.

  2. Now I make another column “ingredients_unchecked” with the goal to replace every checked checkbox to an unchecked one. I do this by using regex replace: thisRow.Ingredients_raw.regexreplace('"isChecked":true','"isChecked":false' )

  3. Now I need to make the output to something a human can read again. Therefor I made a column “Ingredients_reset” where I parse the raw JSON that we just produced in step 2 with the formula:
    ParseJSON('{"o":'+thisRow.Ingredients_unchecked+'}')
    Now you can already see our empty check boxes, but since this is a formula now, you can not interact with it.

  4. Last step is to make a button column. The button is a modifyrow button which fills in the content of our “ingredients_reset” into the “ingredients” column
    Bildschirmfoto 2021-08-17 um 07.36.18

  5. Repeat the steps for the “steps” column and hide the ugly helper columns…

From what I know right now, this is probably the only way of achieving what you want to achieve. Hope that helps for now :slight_smile:

P.S.:Thanks for the recipes! The pile of powder was a little bit dry, but I just added 2 pounds more sugar to make it work for me :crazy_face:

5 Likes