Jscott Posted January 20, 2006 Share Posted January 20, 2006 This might be the wrong place to post this, but I did not see a forum dedicated to calcs. If Field A is populated and Field B becomes populated, how do I delete the information in Field A? Link to comment Share on other sites More sharing options...
mr_vodka Posted January 20, 2006 Share Posted January 20, 2006 If field A gets populated first and the clearing of data rests solely on whether a user enters a new value into field B, then you can use a calculated value (with the option for 'Do not replace exiting value' unchecked) for field A with the formula: Case ( not IsEmpty ( Trim ( B ) ) ; ""; A ). Link to comment Share on other sites More sharing options...
Jscott Posted January 20, 2006 Author Share Posted January 20, 2006 notisEmpty doesn't seem to be a proper function? Link to comment Share on other sites More sharing options...
Jscott Posted January 20, 2006 Author Share Posted January 20, 2006 Sorry, I forgot to place a space between Not and Is.. Thanks Link to comment Share on other sites More sharing options...
mr_vodka Posted January 20, 2006 Share Posted January 20, 2006 BTW. just as a FYI. Your post would belong in the 'Define Fields' forum. Link to comment Share on other sites More sharing options...
Lee Smith Posted January 20, 2006 Share Posted January 20, 2006 I agree, and i moved it. Lee Link to comment Share on other sites More sharing options...
Breezer Posted January 21, 2006 Share Posted January 21, 2006 it is a valid function. You will not see it listed as a function on its own but it's the reverse of "IsEmpty" and it is used when you wnat to check if a field is not empty, hence, not IsEmpty. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6664 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now