Null/Blank Checks on Nested JSON Objects

#1

I’ve been having trouble checking blank fields on nested json object. I tried following the suggestion from Dynamically populating cells dependent on the previous cell being not blank but wasn’t able to get this to work with nested JSON objects. I’d tried using “<PARENT.FIELD_NAME>”.nil? as well as field("<PARENT.FIELD_NAME>").nil?

Is this possible for nested JSON objects?

#2

Turns out formulas are not executed if a field is determined to be blank (because of blank% > 0). Here’s a reference: http://forum.mockaroo.com/t/how-to-return-blank-rather-than-null/1342