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

Variable Prohibition


Recommended Posts

Lets say we have two fields. Field A and Field B.


Field A can only be in two states "Yes" and No"


If Feild A = "No" then Field B will allow modification with a value list assigned to it.


If Field A = "Yes" then Field B will be locked.


Thanks for your help in this matter.

Link to comment
Share on other sites

Set the options of FieldB to be validated by calculation:


FieldA and IsEmpty(FieldB) or not FieldA


Make it strict and add a custom message like "You cannot select a value for FieldB when FieldA is Yes".


Also, I would set FieldA to have an auto-entered value of No and validate to be strictly not empty.



Link to comment
Share on other sites

David, thanks fo the help, I want the field A to be able to be changed by the ppeople working on it.


If they select "No" in Field A then field B locks.


If they select "Yes" then they are allowed to enter info into Field B


This is if I change to yes in field A then I am locked outdoing anything.

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