Clear Prompt Selection On One Field When Something is Selected on Another Field

Question

I am trying to accomplish something like the opposite of a Default Selection in a dashboard prompt.  I have 2 field selections that should be mutually exclusive.  If user sets a value of one, the value of the other field should be reset (set back to null).  It shouldn't be possible for both fields to be filled in at the same time.  I am using 11g.  Is such a thing possible?

SriniVEERAVALLI · Answer

Something like

when PromptA='A1' and PromptB='B1' then 'None'

when PromptA='A1' and PromptB!='B1' then 'B Prompt'

when PromptA!='A1' and PromptB='B1' then 'A Prompt'

condition value 'A Prompt' goes to PromptA field in report

condition value 'B Prompt' goes to PromptB field in report

Matt_S · Answer

Could you elaborate regarding 'report level validations'?

FYI, I experimented with setting up a main prompt, then having a separate 'switch' prompt (composed of 2 choices), and then having two more separate conditionally visible prompts that showed the field corresponding to the user's radio button option.  This method doesn't fully meet my needs because a user could potentially 'break the switch' by selecting a radio choice, filling out corresponding conditional field selection, then changing switch to other option and selecting this new corresponding conditional field.  What I'm really interested in is that automatic clearing out.

SriniVEERAVALLI · Answer

Looking for Radio button type for Prompts!!

for time being: You may go for report level validations for those 2 prompts using Presentation variables.