How to remove a choice from a second list if it has already been selected in the first

766
2
03-28-2017 03:41 AM
PeterHeath1
New Contributor

Hello,

I've got two 'select_one' questions in an XLSform and I do not want the answer selected from the first question to be available for the second.  

For example if I select 

Q1 Sampler Initials?  - Sampler A

1. Sampler A
2. Sampler B
3. Sampler C

 

Q2 Sampler Partner Initials? (Sampler A disappears because it was selected in Q1) 


2. Sampler B
3. Sampler C

Whats the best way to remove the answer chosen in Q1 from Q2?  

 

0 Kudos
2 Replies
JamesTedrick
Esri Esteemed Contributor

Hi Peter, 

A similar question was asked a little while ago - https://community.esri.com/thread/189993-drop-options-from-single-select-as-they-are-selected  .  At this time, the ability to do this is unsupported; I'm adding this post to request list.

0 Kudos
Nicole_Ueberschär
Esri Regular Contributor

In case someone is stumbling over this question: You can solve this by put for question2 in the choice filter not(selected(${question1},opt)) and column opt in the choices sheet with the same values as in opt. Tested with select_multiple only but don't see why it shouldn't work for select_one questions.

0 Kudos