Formula for When a Field Value is Null after Record Insertion

Question

Is it possible to write a formula for if a Date field is not null upon record insertion?

I would prefer to not write a trigger for this.

Flow:

Record Example A --> Field XYZ is null --> Formula evaluates to False.

Record Example B --> Field XYZ is 2016-04-25 --> Formula evaluates to True.

What is the field type?
– Adrian Larson ♦
Apr 25, 2016 at 22:02 — Adrian Larson, Apr 25, 2016 at 22:02
@AdrianLarson Date field.
– Steel Reserve 211
Apr 25, 2016 at 22:04 — Steel Reserve 211, Apr 25, 2016 at 22:04

Adrian Larson · Accepted Answer · 2016-04-25 22:16:49Z

1

It's pretty simple, you just need to negate the results of the ISBLANK function. You can also detect insert with ISNEW.

AND(ISNEW(), NOT(ISBLANK(My_Date_Field__c)))

answered Apr 25, 2016 at 22:16

Adrian Larson♦

149k37 gold badges233 silver badges415 bronze badges

Add a comment |

1 Answer 1