How can I tell if a value is pinned in a cell?
It is possible to obtain a fixed value attribute for fields with codes — true or false using #h.fieldname.
How do you take the calculated value and not the pinned one?
For fixed fields, you can get the calculated value through #c.fieldname.
How to get the level for a tree?
The reference #l.name_field can be used for any field select-tree — returns the nesting level of the value in the field.