Field Dependencies if not picklist

Question

Hi SF Community,

I'm trying to create a depency field without having a picklist as the dependent field. Here's the example:

Controlling Field = Product Category

Once a sales rep selects a certain product within the product category it would null our additional add ons that are already included within that product.

Field Dependencies if not picklist - would be the product

I want benchmarking (Currency field) to turn Null but leave extra user seats open.

Any ideas on how to make this happen?

Thanks!

Drew

Sunil Sarilla · Answer

Hi Drew,

You will need a Visualforce Page to do the same other than you will have to write a validation rule (this will not grey out the field but will restrict users populating a field in the Benchmarking field)

the formula will be something like below

AND(
TEXT(Picklist_Field__c) = 'Your Product Name here',
NOT(ISBLANK(Benchmarking__c))
)

use the insert field button to select the field API Names

Field Dependencies if not picklist

Sales And Marketing

Aprendizaje relacionado

Más ayuda