My own approach to date has been to rely on some fancy footwork in @Formulas. However, right now I'm sweating on this because of the 64k limit for @DbLookup/@DbColumn - I've made life a bit easier by counting a column with a single character in it.
Your evolving solution is a lot better - more robust, able to handle large numbers of documents. I guess I have avoided using too much lotusscript until now, but you've given me the impetus to go an make the change!
Thanks for this Jake.
My own approach to date has been to rely on some fancy footwork in @Formulas. However, right now I'm sweating on this because of the 64k limit for @DbLookup/@DbColumn - I've made life a bit easier by counting a column with a single character in it.
Your evolving solution is a lot better - more robust, able to handle large numbers of documents. I guess I have avoided using too much lotusscript until now, but you've given me the impetus to go an make the change!