Simplifying a formula with multiple checks for User Input
Hi,
I have a grid in which there are multiple line items (approx. 25). These line items are user inputs and when the user enters these either manually or through file upload, he sees a validation message that checks his input related to multiple conditions (e.g. Invalid Date, Mandatory Field Blank, Duplicate Entry etc.) . There are also some conditions that are derived from the combination of two user inputs. I am looking for some way (maybe like a lookup table or something) so that it's easier to maintain and update the formula if required. I do not want the formula to contain so many if-else statements + if else combinations. Can anyone suggest how can I simplify this?
Any help is appreciated.
Thanks and Regards,
Aakash Sachdeva
Answers
-
What validations are you doing?
Could some of it be handled in the UX layer?
Configure character types for a form - Anaplan Technical Documentation
Would normally recommend boolean line items combined with conditional formatting for validation.
Do you need to drive the validation parameters from a system module?0
