Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Reducing value list


Recommended Posts

I have two fields for subject with drop down value list.


OPT 3 > value > Bio, Math ( Value list name Sub 3 )


OPT 4 > Value > Bio, Math, IT ( Value list name Sub 4 )


You first select OPT 3 and then OPT 4.


I want the subject selected in OPT 3 should be omitted from the value list of OPT 4.


I am at my wit's end trying to figure out how to do it.



Link to comment
Share on other sites

Hi kjoe,


Thanks for the post.


I tried Ray Cologon's Dynamic Values. it is very good. It omits values from one list.


I have two lists as mentioned. I found this custom function at briandunning.com


AddRemove ( value ; content )



Let (

value_exists = PatternCount ( "¶" & content & "¶" ; "¶" & value & "¶" );

Case ( value_exists; MiddleValues ( Substitute ( "¶" & content ; "¶" & value & "¶" ; "¶" ) ; 2 ; 1000000 ); content & value & "¶" )




It is giving me the desired result. But it is giving a new problem too.


I am unable to select any value from the list. When I click the field, it drops down like a text field and I can't select any thing. When I go away from that field only the first value shows.



Link to comment
Share on other sites

This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...

Important Information

Terms of Use