BRIDGE - Add Row with Text in Checkbox Column

Paul Newcome

I am using an Add Row module in a Bridge workflow. Within the module I am trying to output a text string into a checkbox field.

I would think that you could just set the text as a cell like you would for anything else, but it keeps adding the row with the checkbox being unchecked (false) as opposed to my text string.

I tried adjusting the "Override Validation" to each of the different options.

I tried it initially as a regular cell then as an advanced cell, all with no luck.

The only way I could get it to work was by setting it as an advanced cell with a formula of ="HIDE". Was my initial thought way off base? Is my workflow glitching? Is this the expected behavior with checkboxes?

Use case here is that rows added by this particular workflow shouldn't have the checkbox available. I am outputting a specific text string so that I can then use conditional formatting to basically "hide" the checkbox on these rows.

Paul Newcome

So it sounds like expected behavior that can be circumvented by having it output a formula instead of just a string.

At least we have some kind of option aside from manual.

prime_nathaniel

@Paul Newcome that has been my experience as well, if it helps you can see the raw output from curl sending "abc" to a checkbox that does not have strict typing on it and api DOES have override on.

{ "refId": "01e2e14f-7495-42a3-85b4-c2cd777443e1", "errorCode": 5536, "message": "The value for cell in column 1420023661023108, did not conform to the strict requirements for type CHECKBOX."}

Even with override validation on, it won't take a string. I suspect for some reason the API model has a typecast or weird bit reduction on it that the UI does not.

Paul Newcome

So it sounds like expected behavior that can be circumvented by having it output a formula instead of just a string.

At least we have some kind of option aside from manual.