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

Groups > comp.databases.filemaker > #1520 > unrolled thread

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

Back to article view | Back to comp.databases.filemaker

Contents

  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

#1520 — If field is not empty and then it becomes empty - the result doesn't change ?!

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? :-)

[toc] | [next] | [standalone]

#1521

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

[toc] | [prev] | [next] | [standalone]

#1522

Thanks :-D

[toc] | [prev] | [next] | [standalone]

#1524

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)

[toc] | [prev] | [next] | [standalone]

#1528

Helpful Harry <HelpfulHarry@BusyWorking.com> wrote:

> 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.

Tests with Data Viewer on FMP 10:

isempty ( "¶" ) = False
isempty ( " " ) = False

If you have Filemaker Pro Advanced, check Brian Dunning's Site for the
Custom Function "Supertrim".

I often use the Auto-Enter calculation:

TextFormatRemove ( Supertrim ( self) )

to get rid of almost all the junk typed or pasted into fields.

-- 
Christoph Kaufmann
http://clk.ch

[toc] | [prev] | [standalone]

Back to top | Article view | comp.databases.filemaker

csiph-web