• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 180
  • Last Modified:

Domino/Lotus Notes form, showing list of values based on a condition

I am working on a form in which a field is a dialog list, and uses a view to provide the list of choices.  However, I would like the list to show a different group of values based an answer in another field.
Example, if the person is a Male, show only a list of boy's names.  If a person is Female, show only a list of girl's names.  Is there a way to create a view which contains all of the names, with some sort of Male/Female identifier and then my form displays the appropriate group of values (based on Male/Female selection)?

I hope that makes sense.  I'm looking for some sort of conditional list of values as choices.
0
lwillford
Asked:
lwillford
  • 2
1 Solution
 
Sjef BosmanGroupware ConsultantCommented:
Can be done. Your first field should be a selection field, with the option Refresh fields selected. You have to create a categorized view, of which the first column can serve as selection values for the first field (using @DbColumn) and the 2nd column is to be used in the 2nd selection field's values formula, i.e. a @DbLookup in the view using the value of the first field.

So:

1st field:
Dialog list
Values formula: @DbColumn("";"";"yourview";1)
Option: refresh fields on value change*

2nd field:
Dialig list
Values formula: @DbLookup("";"";"yourview";FirstField; 2)
Option: refresh values on document refresh*

* I cannot remember the exact phrases used, but you'll see what I mean soon enough.
0
 
lwillfordAuthor Commented:
Thanks for the fast response!  I won't be back to this project until Nov 28th, so I'll confirm it then.  I think I understand - I was having a hard time figuring out what direction to even start going on this one!
0
 
lwillfordAuthor Commented:
Excellent response!  The example you gave me was easy to follow and did exactly what I needed.  Thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now