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.
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)