Parsing Checkbox Text Type as cell/row content

We can now add checkboxes as a text type in a cell.

Screen Shot 2020-01-30 at 12.13.13 PM

Does anyone know how to parse through these items? They act like listed items, but I can’t pull them apart. We want to grab the ones that are checked (completed) and unchecked (to do) separately.

ParseCSV(char(10)) will pull the list apart, but can’t figure out how to see if they are ‘checked’ or not.

Hi @Johg_Ananda,

AFAIK there is not a solution, but

… if you intimately accept that this is a true hack (and I’m not ready to assure it will be stable forever), something that can get closer is:

ParseJSON(thisRow.[*YOUR_COLUMN*]._Merge() +"","#/ranges/lines").ListCombine().FormulaMap(Concatenate(ParseJSON(CurrentValue._Merge()+"","#/text"),": ",ParseJSON(CurrentValue._Merge()+"","#/isChecked"))).

I’ll deny I ever said it.

1 Like