Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 63 Insurance
- 535.7K On-Premises Infrastructure
- 138.1K Analytics Software
- 38.6K Application Development Software
- 5.6K Cloud Platform
- 109.3K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71K Infrastructure Software
- 105.2K Integration
- 41.5K Security Software
DRM validation formula

Hi. I have a custom property in DRM that I want to add a real-time validation for, to be used during a hierarchy import from a flat file.
The custom property is used as a Planning attribute and can have a value of either A or B. I'm assuming that the best way to do a validation on the value of a custom property definition is with a formula?
Can someone give me an example formula syntax to validate that a custom property can only contain the values "A" or "B" ?
Thanks!
Best Answer
-
Hello,
if you use the "Formula" class (node level), the following formula should work.
If(or(equals(string,PropValue(Custom.PropName),A),equals(string,PropValue(Custom.PropName),B)),True,False)
But, I wouldn't set this as a real-time validation. I would do batch. Plus, I am not sure how you would set this to an import. Maybe I am missing something.
Answers
-
Hello,
if you use the "Formula" class (node level), the following formula should work.
If(or(equals(string,PropValue(Custom.PropName),A),equals(string,PropValue(Custom.PropName),B)),True,False)
But, I wouldn't set this as a real-time validation. I would do batch. Plus, I am not sure how you would set this to an import. Maybe I am missing something.