Automation to set checkbox

Hi,
I’m looking for an automation so that when a status changes to “yes” a checkbox column becomes a tick. Is there a way to do that?

2 Likes

Hey Drew,

I am afraid this isn’t currently supported in the platform. I love this suggestion however, so please be sure to submit it as a feature request via the submit an idea section in the forum :pray:

To achieve this you can look into external tools such as Integromat, Zapier or even exploring our API :pray:

Hi There!

Can you provide context to what you are trying to accomplish with this desired set up?

There might be other options that are also much more scalable within the system and open up for more workflow options?

If you want to chat with us, we do free consults as well as custom builds for solutions you are looking for! Please reach out:

https://www.axanexa.com/contact-us/

Looking forward to hearing form you!

Mike B
Automation Architect

Hi@johnners,
you can do create when a status changes to “yes” a checkbox column becomes a tick by using Make
As a complimentary, here is our magic link to get 1 Month Pro plan free (10,000 operations)
https://www.make.com/en/register?pc=msquare 2

If you need any implementation support kindly contact us

MSquare Support
Visit us here
Youtube Channel

I highly recommend using a status column in lieu of checkboxes. You can have a status that’s default (gray) and “done” (green) and nothing else.

I recommend avoiding checkboxes in most circumstances because you close the door on triggering on change to done, conditions in other automations, and of course cannot set them by automation. You also limit what you can do in dashboards and my work.

Basically, checkboxes are a pathway to frustration in the long term.

1 Like

You cannot set a checkbox value via the API or any integrations like Make or Zapier. It’s not possible. There are other support articles on this.

The best possible solution is to change the checkbox column to a Status column and have values like “Yes” and “No”. You can automate Status columns.

FYI - Integromat changed names to Make.com over a year ago.

@charlieg you absolutely can change the checkbox value via API.

To set it to checked:

mutation {
  change_multiple_column_values(item_id:1234567890, board_id:9876543210, column_values: "{\"checkbox\" : {\"checked\" : \"true\"}}") {
    id
  }
}

To clear the check:

mutation {
  change_multiple_column_values(item_id:1234567890, board_id:9876543210, column_values: "{\"checkbox\" : null}") {
    id
  }
}
1 Like

You can use an automation for that with general caster app.
For formula just enter 1.