Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.filemaker > #1524

Re: If field is not empty and then it becomes empty - the result doesn't change ?!

Show all headers | View raw

In article <l6fe89$9n2$1@dont-email.me>, Erik Appeldoorn
<ursus.kirk@gmail.com> 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)

Back to comp.databases.filemaker | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

If field is not empty and then it becomes empty - the result doesn't change ?! JayBee <Jennifer_Beecroft@hotmail.com> - 2013-11-19 01:21 -0800
  Re: If field is not empty and then it becomes empty - the result doesn't change ?! Erik Appeldoorn <ursus.kirk@gmail.com> - 2013-11-19 11:24 +0100
    Re: If field is not empty and then it becomes empty - the result doesn't change ?! JayBee <Jennifer_Beecroft@hotmail.com> - 2013-11-19 03:40 -0800
    Re: If field is not empty and then it becomes empty - the result doesn't change ?! Helpful Harry <HelpfulHarry@BusyWorking.com> - 2013-11-20 09:02 +1300
      Re: If field is not empty and then it becomes empty - the result doesn't change ?! clkaufmann@gmx.ch (Christoph Kaufmann) - 2013-11-20 19:49 +0100

csiph-web