Can i set null values in business rule
*This post is locked for comments
Hi Smith,
When you clear field value using Business Rules that means you are basically clearing the current value , if the field have any default value then you can see always its set to default value. If there is no default value for the field in that case field value will store as NULL in the database.
Can you please share with us what exactly your requirement , or if you have any specific issue .
Use the following condition as we cannot set value as NULL.
IF
Tenant ID does not contain data
THEN
Hide field Agreement
ELSE
Show field Agreement
HI
You can clear value to the field. May i know what purpose do you need to make it null?
If you are trying to set null value of field then it is not possible..
when you set one field value from another field, and parent field has null/empty value then second field value will be set to null/ empty.
But I don't understand why do you want to set null value, and not clearing field value.
Yes I know about clear field value...but I want to know it takes null value or not.
Kindly share with example.
Hi,
You can clear values using Business rule.
for more information check
www.powerobjects.com/.../clearing-a-field-value-using-business-rules
www.powerobjects.com/.../using-business-rules-to-clear-cell-values
yes you can but not in Busienss rule interface. Put some dummy value while creating business rule and save the business rule. After that download the solution which contains the entity where business rule is attached. Unzip the solution, go to folder "Workflow", find the business rule by name. Search for the field and enter empty value and zip the solution and import into the system. This is a work around solution in CRM 2013. May be in the latest version, CRM allows to set null, I have no idea.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Andrés Arias as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Aric Levin - MVP 2 Moderator
MA-04060624-0 1
