Jump to content

seach buttons if criteria...


This topic is 7777 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

I am very new at FileMaker

I am trying to make a button that will perform a search if a field meets a certain criteria.

For example:

A field will either be: 10, 9.5, 9, 8.5...

I would like a button that will search all the records listed as "10".

or all records listed as "9.5"...

Thanks for your help and patience.

Link to comment
Share on other sites

I think I understand what you want. You want to enter a number into a field (10,9.5,9,8.5...) and push a button to find all the records with this value?

If this is the case:

Create a field: gField (global, number)

Write the following script:

Allow User Abort (off)

Set Error Capture (on)

If (IsEmpty (gField))

Exit Script

End If

Enter Find Mode () <----- Uncheck Restore and Pause

Set Field (field, gField)

Perform Find() <----- Uncheck Restore

If (Status(CurrentError) = 401)

Show Message (No records found!, OK)

End If

This search can also be done manually by just going to Find Mode, entering the value you wish into "field" and clicking the find button in the status bar.

-bd

Link to comment
Share on other sites

You need to look in the Community forum for book recommendations and do some reading up on FileMaker. As simple as you can get is:

Enter Find Mode (pause) <----- Uncheck Restore

*** user enters number into field and hits enter ***

Perform Find() <----- Uncheck Restore

As a minimum, I'd read through the FM manual. -bd

Link to comment
Share on other sites

This topic is 7777 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.