If I forgot to enter a value or made it as blank in a cell in grid, how can I show a validation or something that will prevent me from saving that particular grid without that data.
Can somebody please assist me in getting a workaround for the same.
Anaplan does have some limitations in regards to data validation. Specifically, it cannot prevent a missing value. In addition, it can't prevent many incorrect values.
This said, there are some things we can do to flag bad (or missing) data, as well as prevent that data from being shared in downstream models or applications.
First, we can use Conditional Formatting to highlight where values are either invalid or missing. In most cases, the conditional formatting rule is tied to a 2nd (often hidden) line item that contains a formula that evaulates to some specific numbers that help control the related conditional formatting colors.
Second, where data is being exported to another model (or application), we can apply filters that remove the bad data from the export, so that only validated data gets exported.
It goes without saying that we can create (what I refer to as) Audit Dashboards that allow us to quickly see our key data filtered to only show invalid (or missing) values. This way, we can fix things without having to search too long.
Cheers!
Thank you so much paul for the woraround.
There was an error rendering this rich post.
Hi all, The Client ID and Client Secret are available, intended for uploading and downloading files. Could anyone advise how to use these credentials DIRECTLY to make API requests? Thank you!
I have A6 as the parent list and two sibling lists: A6.5 and A7. The A7 list includes an attribute that maps to A6.5. In the UX, the user will select A6.5 using a content selector, and the grid (dimensioned by A7) should display only the A7 items associated with that selected A6.5. Since the selector is a page context and…
