Read Only for submit once approved

Highlighted
Contributor

Read Only for submit once approved

Hi,

 

I have 2 line item, Submit and Approved, Both are Boolean format.

Once an Item is both checked for Submit and Approved as True, I need Submit(line Item) to be read only, i.e it should not be allowed to unchecked again.

 

Thanks & Regards,

Asha

2 REPLIES 2
Highlighted
Certified Master Anaplanner

Re: Read Only for submit once approved

Hi @AshaPatil ,

 

You can use a staging module and Dynamic Cell Access for this requirement.

 

Thanks 

Highlighted
Super Contributor

Re: Read Only for submit once approved

Use two line items

Submit and Approve
Third line item should be opposite of approve (Reverse Approve)
Reverse Approve formula to be "NOT Approve"
Both Boolean formatted
Use the dynamic cell acess for Submit and link it with Reverse Approve in the write access driver and Approve in the read access driver