Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Using variables to find records

Using variables to find records

Using variables to find records

I'm new at filemaker pro 8.5. I want to search records using a field 'names' but entering the searchstring using a variable $$mystring. I dont know how, please help!
Thank you.

RE: Using variables to find records

Hello Nic,

I assume you want to script the search.  Try a script something like this:

Enter Find Mode
Set Field ["names";$$mystring]
Perform Find

The Set Field command of course works in the BROWSE mode but for people new to Filemaker, it is not so obvious that it also works in the FIND mode.  It populates the field with the term that you are searching for.

Does this help?


RE: Using variables to find records

Also remember that when you set your "$$mystring" variable, that it's a global variable and will be available as long as the application is open (and will contain that same value, unless you reset it somewhere else).  

If you aren't going to need that variable value outside of the script you are using, use a script variable (only one dollar sign ... $mystring ) instead.  It goes away when the script finishes, which is helpful if you name your variables similarly, or if you duplicate scripts for reuse and forget to comment out or change the variable name.

Sorry for jumping in TStriker ... just thought I'd add my $0.02.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close