DBLookup in Hide When Formula for Text?

HCL Domino Domino Forum
1

Hi,

I am trying to write a Hide-When formula that looks up a view and checks to see if a user has documents in that view. If so, then I would like to show text in a Page. I don’t know if this works since it is a view vs a form. Any ideas?

Here is what I have now:

tmpLkpPending:=@DbLookup(“”;“”; “NoticePendingClosed”; @Name([CN];@UserName); 1);

@If(tmpLkpPending=“”;@True;@False)

I have also tried

tmpLkpPending:=@DbLookup(“”;“”; “NoticePendingClosed”; @Name([CN];@UserName); 1);

tmpLkpPending = “”

I can’t figure this out. The text I am trying to hide show up no matter what. I added a computed text to the page just so I could see what value the DBLookup returns and that seems to work, but the hide when does not.

Thanks in advance!!

2

Subject: DBLookup in Hide When Formula for Text?

If @DbLookup fails and you haven’t used the [FailSilent] flag in the formula, it returns an error value. That’s not the same thing as “”. So your formula returns a list of stuuf if the user has stuff in the view and an error if there’s nothing there. Neither of those values is “”, so the text always displays.

3

Subject: RE: DBLookup in Hide When Formula for Text?

So do I add the [FailSilent] to the formula, so it now states:tmpLkpPending:=@DbLookup(“”;“”; “NoticePendingClosed”; @Name([CN];@UserName); 1;[FailSilent]);

tmpLkpPending=“”

The text is still showing up. Any more ideas?