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

Groups > comp.databases.filemaker > #1521

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

Show all headers | View raw

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

-- 
met vriendelijke groeten,
Erik Appeldoorn

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