Skip to main content

Hi,

I have a requirement Read-only field should be editable on checking a checkbox field.

 

Details:

Objects & fields: Account object (Product1_Price __c, Checkbox__c)

                             Product__c   object (Product1_listPrice __c) all are type currency fields.

 

While creating an account record "Product1_Price __c" should take the value directly from "Product__c" object "Product1_listPrice __c: field and become read-only, by checking the "Checkbox__c" field on the Account object, the field "Product1_Price __c" should become editable. 

 

Account ---Lookup relation---> Product

 

Any suggestions on how we can achieve this would be helpful.

Thanks

1 answer
  1. Nov 4, 2021, 12:43 AM

    You will need a validation rule. 

    So you reesteic the field from being edited if the checkbox is false.

     

    AND(

    Not(isnew()),

    Ischanged(Product1_Price__c),

    Checkbox__c = False)

     

    It will allow you to update the field via automation when the record is created, after that it cannot be edited unless the checkbox is true

0/9000