[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

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

Posted on 2016-11-17
3
Medium Priority
?
147 Views
Last Modified: 2016-11-28
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
Comment
Question by:lwillford
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 46

Accepted Solution

by:
Sjef Bosman earned 2000 total points
ID: 41892346
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
 

Author Comment

by:lwillford
ID: 41892363
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
 

Author Closing Comment

by:lwillford
ID: 41904814
Excellent response!  The example you gave me was easy to follow and did exactly what I needed.  Thanks!
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This is an old article, please see an updated version of this article, located here: http://www.experts-exchange.com/articles/23619/Notes-8-5x-Windows-7-Notes-info-and-tips.html
This article covers general Notes 8.5 troubleshooting information including recreating the Notes\Data folder.
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…
Suggested Courses

656 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question