lotus-noteslotus-formuladomino-designer-eclipse

@!IsNull is still showing null rows in view


My Lotus Note application has a 10 row table. In each row has a field, named cert until cert_9.

These 10 fields will be used in a view, sharing a column, Certificate. Column value formula being:

cert: cert_1: cert_2: cert_3: cert_4: cert_5: cert_6: cert_7: cert_8: cert_9

Not all the fields will be used so I only want the view to not show blank rows. So in view selection formula my formula is:

SELECT !@IsNull (cert: cert_1: cert_2: cert_3: cert_4: cert_5: cert_6: cert_7: cert_8: cert_9)

But when I test preview in Notes, I can still click the empty row below and it can link me to my form, meaning it didn't work.

enter image description here


Solution

  • If I'm undertanding you correctly, and "aaa" and "fsag" are values from the same document (i.e., you are using the "show multiple values as separate entries" property in the view column -- on the second tab of column properties box, then I think what you want is to adjust the column formula (not the selection formula) so that it is

    @Trim(cert: cert_1: cert_2: cert_3: cert_4: cert_5: cert_6: cert_7: cert_8: cert_9)
    

    Documentation for @Trim function