Perform Find Not Equal to Filemaker pro 11

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
PachecoPrimoAsked:
Who is Participating?
 
Will LovingConnect With a Mentor PresidentCommented:
And here's the file with the revised script.
Find-Not-Equal-v2.fp7
0
 
ThomDrozCommented:
PachecoPrimo

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

Tom
0
 
PachecoPrimoAuthor Commented:
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
 
Will LovingPresidentCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.