AnsweredAssumed Answered

Autofill a field

Question asked by cpking on Jan 16, 2018
Latest reply on Jan 17, 2018 by philmodjunk

I KNOW this is a silly one.... I have a field for email address (Email). If email address is missing from a record, I want another field (EmailMissing) to populate with "NEED EMAIL ADDRESS".

I've tried to use Case, If isempty, etc., and it will not populate on existing records.

 

When I enter a new record, it populates with the "NEED EMAIL ADDRESS" but  after an email address is entered, it doesn't go away.

 

Seems like this should be a simple one...

Outcomes