ProspectComm Posted September 14, 2009 Share 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 Link to comment Share on other sites More sharing options...
jshobar Posted September 14, 2009 Share 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. Link to comment Share on other sites More sharing options...
rpaterick Posted September 14, 2009 Share 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. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.