You need to sign in to do that
Don't have an account?
Akshay Juwa
Lock the 'Distribution Date' field so that if cant be changed and set the date based on when the 'code used' checkbox is checked?
Hello everybody, I'm trying to figure out how to lock the date field when the code used checkbox is checked and set the date based on the code used is checked. Initially I was going to approach using a flow, but team prefered to use a formula instead. I'd really appreaciate the help.
Thanks for confirming. We cannot use ISCHANGED() or PRIORVALUE() in case of Formula field . So we may not be able to achieve this using formula field. As you said we may have to go with flow only.
If this solution helps, please mark it as best answer.
Thanks,
All Answers
Can you confirm what type of field Distribution Date is . If that is Date field then your approach of using flow is correct. Because it is normal Date field you cannot use the formule for it. Are they asking you to use Default Value to populate the date?
Thanks,
The Distribution Date is a date formula field. They haven't speified on using the default value to populate the date but if thats a possibility I'd be more than happy to use it.
Thanks for confirming. We cannot use ISCHANGED() or PRIORVALUE() in case of Formula field . So we may not be able to achieve this using formula field. As you said we may have to go with flow only.
If this solution helps, please mark it as best answer.
Thanks,