AnsweredAssumed Answered

A field response based on a selection from a value list

Question asked by dgmjr on Jul 4, 2016
Latest reply on Jul 6, 2016 by wintertj

Hi there,

 

I have two fields : "ConsultantDiscipline" and "DateToConsulant"

 

The field "ConsultantDiscipline" is a drop down menu in which has a value field of say five values.

When a particulate value is selected, I want the "DateToConsultant" field to to respond with a specific result

 

Example:

If I select "Arch' from the value list from the ConsultantDiscipline field, I want the response in the DateToConsulant field to be "-".

If a selection is made from any of the 4 remaining values, the "DateToConsultant" field result would be empty

 

This is a calculation that I tried with no success:

if( ConsultantDiscipline  ≠ "Arch"; DateToConsultant ; "-" )

 

Any input would greatly be appreciated,

 

Thanks,

 

David

Outcomes