Path: csiph.com!usenet.pasdenom.info!aioe.org!.POSTED!not-for-mail From: Helpful Harry Newsgroups: comp.databases.filemaker Subject: Re: If field is not empty and then it becomes empty - the result doesn't change ?! Date: Wed, 20 Nov 2013 09:02:21 +1300 Organization: Aioe.org NNTP Server Lines: 42 Message-ID: <201120130902218090%HelpfulHarry@BusyWorking.com> References: NNTP-Posting-Host: 5zOXw0wKH5K4cz2kCkTZmA.user.speranza.aioe.org Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Complaints-To: abuse@aioe.org User-Agent: Thoth/1.5.4 (Carbon/OS X) X-Notice: Filtered by postfilter v. 0.8.2 Xref: csiph.com comp.databases.filemaker:1524 In article , Erik Appeldoorn wrote: > JayBee schreef op 19-11-2013 10:21: > > > > Hi > > > > There's a text box at the bottom of the screen - which is not visible on > > all users screens so I've been asked to make an asterix or other relevant > > text character(s) appear higher up the screen where it will be visible on > > all users screens when there is text in the field that goes off some > > screens. > > > > I started with the following calculation: > > If ( not IsEmpty ( off_screen_text_box ) ; "*" ; "" ) > > This worked in that if you typed text into the off screen text box the > > asterix would appear in the calculation field. But then I tried to delete > > the text from the off screen text box , to see if it would clear the * to > > blank to show users that they no longer need to scroll down to see it, it > > does nothing. > > > > I also tried: > > Case ( not IsEmpty ( off_screen_text_box ) ; "*" ; IsEmpty ( > > off_screen_text_box ) ; "" ; ) > > > > but I got the same result as for the 'If' calculation. > > > > How do I tweak the calculation to get the result I want please? :-) > > The first should work, but .... > Make the calculation unstored It should do, but just as a personal prefernce I'd turn it around - rather than checking for "not empty", check for "empty" (it's just a bit easier to read). If (IsEmpty(off_screen_text_box); ""; "*") It may also need some tweaking to cope with people who "delete" data by typing a space / tab / carriage return over the top, but I haven't tested to see if FileMaker ignores those by itself. Helpful Harry :o)