Solved

Perform Find Not Equal to Filemaker pro 11

Posted on 2011-09-15
4
1,644 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 500 total points
ID: 36547058
And here's the file with the revised script.
Find-Not-Equal-v2.fp7
0

Featured Post

[Live Webinar] The Cloud Skills Gap

As Cloud technologies come of age, business leaders grapple with the impact it has on their team's skills and the gap associated with the use of a cloud platform.

Join experts from 451 Research and Concerto Cloud Services on July 27th where we will examine fact and fiction.

Question has a verified solution.

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

Conversion Steps for merging and consolidating separate Filemaker files The following is a step-by-step guide for the process of consolidating two or more FileMaker files (version 7 and later) into a single file with multiple tables. Sometimes th…
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…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

635 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