A somewhat of a documentation of hidden formulas [Added mechanics of nested buttons]

[Paul_Danyliuk]

@Filmos

In order to display it properly you need to wrap it with any kind of property. This works because a preview of an object is its first property and control objects inside of a standard object aren’t flagged to display as structure.

I found a solution of how to get rid of the popup and render the actual control object, not a control object wrapped in an object. You still provide it wrapped to ParseJson(), but then use _Deref_Object() to extract the control object:

ParseJson('{"0":' + YourJson + '}')._Deref_Object("0")

I used this in my latest demo to insert text into Tasks table not wrapped but perfectly editable:

Pro hack: Convert checklist to separate rows

I was playing around with the idea of being able to enter meeting notes in a Big Cell mode, and then quickly convert those into separate rows in a Tasks table. Here’s what I managed to do: [ezgif.com-optimize (72)] This is a hacky solution that relies on deep object modification (props to @Filmos). I added the logic to include sub-lists etc when copying each task. reducing nesting level by one. I haven’t implemented the way to preserve character-level formatting (bold, color etc) because that…