I have two fields,one is “System” which is dialog list,the other one is "Institution"which is dialog list and editable.i’d like to make user to select from "System"list,that means System is the key and display the return value in "Institution field.Inside the default value of “Institution”,i wrote formula
@If(System !=“”;@DbLookup(“” ; “”; “System List” ; System; 2); “”);
but doesn’t work.
if i change “Institution” field type to Computed field,it is no problem.
However,i am aim to use Dblookup to retrieve data in the view as defaulted value in “Institution” and user is able to edit,so editable field i needed.
how to solve this problem??
Any help will be greatly appreciated!
Subject: Edited Field and Computed Field
check “Refresh Fields on Keyword Change” property of the “System” field
check “Refresh Choices on Document Refresh” property of the “Institution” field
this should work
Subject: RE: Edited Field and Computed Field
I have checked these two options. doesn’t work. It works only change “Institution” field to “Computed”
Subject: RE: Edited Field and Computed Field
put the forumla in the “Institution” field properties>2nd tab>Choices. Select “Use formula for Choices” and put this lookup formula there.
Just to confirm,
Institution field should be below the “System” field as formulas are evaluated from Left to Right and Top to Bottom
cheers!!
Subject: RE: Edited Field and Computed Field
I cannot put lookup formula there. the “Institution” field is dialog list with more than one value that user can choose, but my lookup formula only 1 value,my purpose is use lookup formula to default the “Institution” field value, but still allow user to select different institution from the dialog list.yes, "System field is on the top of “Institution” field.
Subject: RE: Edited Field and Computed Field
use the onChange event of SystemSelect Client and Lotus script
Sub Onchange(Source As Field)
Dim ws As New notesuiworkspace
Dim uidoc As notesuidocument
Dim doc As notesdocument
Set uidoc=ws.currentdocument
Set doc=uidoc.document
doc.Institution=doc.System
End Sub
this acts like the exiting event but is only effective if the value of System has changed.
Subject: Edited Field and Computed Field
What I’d normally do is make the user change the ‘system’ field by way of an action or button. The code behind it can then change the ‘Institution’ field as well, but leave the institution field editable.
Dan