How can I auto populate a field within a Lotus notes form based of the results of another field?
Posted on 2008-11-06
Lotus Notes 6.5
How can I get a notes field to auto populate another notes field based off the selection from the first field?
user fills out the form, I'd like to have it pre-fill a couple of fields based off a selection in field 1.
User selects NO it then auto fills fields 2&3 with N/A
Field 1 Field 2 Field 3
No N/A N/A
If the users selects No
then it pre-fills Field 2 and 3
with N/A. If the user selects Yes
then it does nothing.
Field 1 is a dialog list/editable Field 2 is text Field 3 is text
It pulls values from a profile editable. no profile editable. no profile
document document document
All fields are required fields based off this formula-
@If(@IsDocBeingSaved & Months = "" ;@Return("Please fill out the field. Thank you.") ;@Success)
I'm new to this so picking up from other dB's as I go