ProspectComm Posted September 14, 2009 Posted September 14, 2009 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 Posted September 14, 2009 Posted September 14, 2009 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 Posted September 14, 2009 Posted September 14, 2009 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.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.