Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Perform Find Not Equal to Filemaker pro 11

Posted on 2011-09-15
4
Medium Priority
?
1,710 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 25

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 25

Accepted Solution

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

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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…
Having just upgraded from Filemaker 11 to Filemaker 12 over the weekend, we thought we would add some tips for others making the same move.  In general, our installation went without incident. Please note that this is not a replacement for Chapter 5…
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…
Loops Section Overview

916 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