Dependency on dropdown value challenge

Hi

Hopefully a simple one. I'm creating a dependency based on a single value from a dropdown list. It's working to only show the field when the value is selected, however, it also shows when the value is blank. We have the dropdown set to default to blank.

isInList($bvdid_status_c,createList("BVDID_Does_Not_Exist",))

Can anyone advise how to ensure the field do not appear when the field is blank?

Best wishes

Lucy

Parents
  • Sorry to Hijack your question, but mine is very similar - If I want to make a field (actually multiple fields) only show if any one of a series of linked/related fields contain a value - (they will all have the same fieldname/relationship.) will that still work.

    Ie. if an Opportunity has a series of potential products linked - and one is currently selected, but the others are still in the list of products - and we were looking for any product with feature - X - to trigger questions about X - would that be the identical formula, or would we have to add some more code to allow for the possibility that one may be yes and another may be no?

    (I think I have just realised you can't have related fields anyway in a visibility formula?)

Reply
  • Sorry to Hijack your question, but mine is very similar - If I want to make a field (actually multiple fields) only show if any one of a series of linked/related fields contain a value - (they will all have the same fieldname/relationship.) will that still work.

    Ie. if an Opportunity has a series of potential products linked - and one is currently selected, but the others are still in the list of products - and we were looking for any product with feature - X - to trigger questions about X - would that be the identical formula, or would we have to add some more code to allow for the possibility that one may be yes and another may be no?

    (I think I have just realised you can't have related fields anyway in a visibility formula?)

Children