Empty Data Field Rule

[ProspectComm]

Anyone know how to create a rule that puts in a default value if a data cell is empty? Example: an address with no first name.

 

Rick

[jshobar]

Rick- use an if then statement to check if the field value is blank (==""), if it is, return your default value, if it's not, return your field.

[rpaterick]

return Field("Full Name") || Field("business") || "Current Resident";

If no Full Name it will go to business. If no full name or business it will default to say Current Resident.