This technique allows you to make dynamical checkboxes for both Web and Notes. As a feature it can be used as workaround for 32k limit. BTW, R6 won't have a limit for @dblookup/@dbcolumn.
Dynamical checkbox field:
1. Field "dspAnames" Checkbox/Editable formula for field options: @DbColumn("":"NOCACHE";"";"pick_role";1)+"|"+@DbColumn("":"NOCACHE";"";"pick_role";2)
2. Field "Anames" Text/Multivalued/Computed/Hidden formula for field: aNames
3. View pick_role
The first column is sorted. Contains options. Their names. The second should contains aliases for options.
The screenshot below (in Russian) is example as $readers/$authors type fields may be arranged. Sure, all the roles are stored as documents and synchronization between them and ACL were realized.
The other way of using this technique is getting more than 32k.
1. Some documents with field "Some"
2. View has some columns contain formulas breaking apart long string stored "Some".
Then we can make smth. Like this: list1:=@dbcolumn(...1); list2:=@dbcolumn(...2); ... listN:=@dbcolumn(...N); result:=list1+list2+...+listN
The problem is only equal number of elements. Hmm... why don't we check if view column value is empty? This problem solution is replacing empty value by wowel.