Inviewedit and condition

HCL Domino Domino Forum
1

Hi,

There a few examples on how to make Inviewedit and fields blank. I could not find any examples how to make entries based on the condition. I have two fields; planned hours and used hours. Used hours can not be blank when planned hours are not null. Any idea how to do it??

Thanks!!!

2

Subject: Inviewedit and condition

I think this example:

http://www-12.lotus.com/ldd/doc/domino_notes/7.0/help7_designer.nsf/f4b82fbb75e942a6852566ac0037f284/a38baee5e06bdb038525704a00411d8a?OpenDocument

shows how to check for null values in columns

3

Subject: RE: Inviewedit and condition

I also got this example from the Domino Help. In my view I need to add more… If one field (ex. planned hours) is not null then another view column (ex. used hours) can not be null.

Thanks!!

4

Subject: RE: Inviewedit and condition

I think all you have to do is that when either column value changes, for example columnvalue(1) and columnvalue(3), apply the same test to both.

If Fulltrim(Columnvalue(1)) = “” and Fulltrim(Columnvalue(3)) <> “” Then

Messagebox “Planned hours must not be null if project hours have a value”, “Error”

Continue = False

End If

5

Subject: RE: Inviewedit and condition

I’ll try it.

Thanks so much, Cesar!!