topic Newest Record in a Field Rule - What if the newest is blank? in DemandTools

Newest Record in a Field Rule - What if the newest is blank?

NA — Tue, 24 Jun 2025 23:49:03 GMT

Question: If the field rule for a field says Newest Record and the newest record's value is Blank (or Null, etc.) but the winner record has a value.... would the blank or null overwrite the value that is on the winner record, assuming the winner record is not the newest of course. Thanks.

Re: Newest Record in a Field Rule - What if the newest is blank?

KitK_Validity — Wed, 25 Jun 2025 13:33:59 GMT

Hi NA,

Thanks for your inquiry. Since the field on the losing record is blank, and Field Rules only compares fields that contain values, the field on the winning record will not be overwritten.

I hope this helps!

Best regards,

Kit K. Fan

Senior Customer Success Manager of Validity

Re: Newest Record in a Field Rule - What if the newest is blank?

NA — Wed, 25 Jun 2025 13:43:29 GMT

Thanks. Follow-up question: Is a picklist value of Null condsidered like a blank or is that considered a value?

Re: Newest Record in a Field Rule - What if the newest is blank?

KitK_Validity — Wed, 25 Jun 2025 14:27:25 GMT

Hi @NA

Yes, the same logic applies picklist values of NULL are treated as blank.

Best regards,

Kit K. Fan

Senior Customer Success Manager of Validity

Re: Newest Record in a Field Rule - What if the newest is blank?

NA — Wed, 25 Jun 2025 14:28:53 GMT

Thanks - Much apprciated