Solved

Perform Find Not Equal to Filemaker pro 11

Posted on 2011-09-15
4
1,549 Views
Last Modified: 2012-05-12
I am trying to build a script that performs a find. It is supposed to find values not equal to 1. I tried to set the set field value in the script to "not 1" but that just brings up any value set up to zero. I want all the values not equal to 1 to show on my layout.
Find-Not-Equal.fp7
0
Comment
Question by:PachecoPrimo
  • 2
4 Comments
 
LVL 6

Expert Comment

by:ThomDroz
ID: 36546853
PachecoPrimo

You can do a find for "1" then do "show omitted only"

Tom
0
 

Author Comment

by:PachecoPrimo
ID: 36546920
Tom,
I modified my script (see attached), however when i the "show omitted only", it brings all the records.

Thxs,
Pacheco
Find-Not-Equal.fp7
0
 
LVL 24

Expert Comment

by:Will Loving
ID: 36547057
You had a few too many steps in your script for this operation. I've reduced the Find part of the script to a single step:

Perform Find [Restore]

  Find Requests
The saved Find is to "Omit Records" where the Main::Value is 1. When you save a Find into a script, you can save multiple criteria (aka "Find Requests") and you can save them with the "Action" being either "Find Records" or "Omit Records". If you have multiple Find Requests, you should always put the "Find Records" ones first before the "Omit Records". In this case you need only one "Omit Records" Request.

 Omit Records request detail
There is also no need to create a separate variable for the Found Count to then use in the dialog. Just use the Get ( FoundCount ) function directly in the Dialog calculation.

  Get ( FoundCount )
0
 
LVL 24

Accepted Solution

by:
Will Loving earned 500 total points
ID: 36547058
And here's the file with the revised script.
Find-Not-Equal-v2.fp7
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" An…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now