Critical Field Check

Hi there,

Just checking if any update an be applied to this challenge!

I have a Masterdata list and module, that has 200 fields, of which 20 are Primary, 80 are Secondary and 100 are tertiary. When a new product is created, I would like to ensure that ALL the Primary fields are complete and display to the user the status.

Current method would be to write a formula IF ISBLANK(field1) OR ISBLANK(field2) or FIELD3 = 0 OR etc etc etc

Is there a better more robust method for checking fields are complete?

thanks

Accepted answers

All comments

rob_marshall

@DeveloperCYT ,

The only way I know of is to do something very similar to what you stated, but to use an AND instead of an OR as well as remove the IF. Have the result render as a Boolean. Also, since it is master data, please make sure Time is not part of the validation.

Hope this helps,

Rob

DavidSmith

Agreed, there is no real shortcut to this

I'd also add, that, if you can, keep each of the checks in separate line items and then have a check 1 OR check 2 OR check 3 etc. for the final formula. It will be a more efficient calculation ("break it up - 2.02-18 planual rule", but it will also allow you to filter on specific "errors"

David

Quick Links

Can you help?

Unanswered questions

Not Able to Join the Level 1 Model Building Course
Hey Everyone, I was trying to learn about the Level 1 Model Building Course, when i log in to my system and click on "Start the course" option its showing training unavailable, Can anyone please help me with this @Dikshant and all?
Generating Failure Dump - even though no warnings/error in Actions
I've few actions in our Supply model which when run takes some time on the "generating failure dump" step at the end of the action even though the import is a full success without warning or errors. This is just a few seconds when run for a single action, however we have a process with 120 actions, and most of these…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…