dbTalk Databases Forums  

Find Button on a field not empty

comp.databases.filemaker comp.databases.filemaker


Discuss Find Button on a field not empty in the comp.databases.filemaker forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Buckbuck
 
Posts: n/a

Default Find Button on a field not empty - 05-10-2010 , 11:14 AM






FM8.5
I have a Ledger
It has an Account column - Cdn Dollar
I want to create a button that will allow me to find any record in a
list when this column is not empty, ie; there is a value.
This will allow me to see a single account in a multi-account Ledger.

I do not understand how to create a script that has a calculated
result.

Can you help

Thanks
Matthew

Reply With Quote
  #2  
Old   
Christoph Kaufmann
 
Posts: n/a

Default Re: Find Button on a field not empty - 05-10-2010 , 12:57 PM






Matthew <buck.matthew74 (AT) yahoo (DOT) com> wrote:

Quote:
FM8.5
I have a Ledger
It has an Account column - Cdn Dollar
I want to create a button that will allow me to find any record in a
list when this column is not empty, ie; there is a value.
This will allow me to see a single account in a multi-account Ledger.

I do not understand how to create a script that has a calculated
result.
Try scripts with or without bottoms after you have found out how to find
the data manually.

In order to do that, go to find mode, place the cursor into your field
and try the "symbols" tool in the status area on the left.

The sign = will find records with an empty field. The sign * finds
records with anything in it.

Now that you know how to phrase the search, you can script it.
--
http://clk.ch

Reply With Quote
  #3  
Old   
Buckbuck
 
Posts: n/a

Default Re: Find Button on a field not empty - 05-10-2010 , 01:52 PM



On May 10, 10:57*am, c... (AT) tele2 (DOT) ch (Christoph Kaufmann) wrote:
Quote:
Matthew <buck.matthe... (AT) yahoo (DOT) com> wrote:
FM8.5
I have a Ledger
It has an Account column - Cdn Dollar
I want to create a button that will allow me to find any record in a
list when this column is not empty, ie; there is a value.
This will allow me to see a single account in a multi-account Ledger.

I do not understand how to create a script that has a calculated
result.

Try scripts with or without bottoms after you have found out how to find
the data manually.

In order to do that, go to find mode, place the cursor into your field
and try the "symbols" tool in the status area on the left.

The sign = will find records with an empty field. The sign * finds
records with anything in it.

Now that you know how to phrase the search, you can script it.
--http://clk.ch
Thanks for your help
Matthe

Reply With Quote
  #4  
Old   
Your Name
 
Posts: n/a

Default Re: Find Button on a field not empty - 05-10-2010 , 04:03 PM



"Christoph Kaufmann" <clk (AT) tele2 (DOT) ch> wrote

Quote:
Matthew <buck.matthew74 (AT) yahoo (DOT) com> wrote:

FM8.5
I have a Ledger
It has an Account column - Cdn Dollar
I want to create a button that will allow me to find any record in a
list when this column is not empty, ie; there is a value.
This will allow me to see a single account in a multi-account Ledger.

I do not understand how to create a script that has a calculated
result.

Try scripts with or without bottoms after you have found out how to find
the data manually.

In order to do that, go to find mode, place the cursor into your field
and try the "symbols" tool in the status area on the left.

The sign = will find records with an empty field. The sign * finds
records with anything in it.

Now that you know how to phrase the search, you can script it.

Usually I just use the = symbol and the Omit option, but I don't know if
there's any speed benefit / penalty between that and using the * symbol.


Helpfull Harry )

Reply With Quote
  #5  
Old   
Christoph Kaufmann
 
Posts: n/a

Default Re: Find Button on a field not empty - 05-12-2010 , 11:55 PM



Helpful Harry wrote

Quote:
Usually I just use the = symbol and the Omit option, but I don't know if
there's any speed benefit / penalty between that and using the * symbol.
Didn't notice any difference either, but * is quicker on my Windows
keyboard because I need the shift key to get the =

I also had situations where = wouldn't work, probably with related data in
portal or something, but * and omit did.
--
http://clk.ch

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.