Jump to content
Sign in to follow this  
WC Howard

Exacting detail

Recommended Posts

This has got to be one of those "it's so simple but the answer eludes me" questions...

I'm trying to write a script step where a part number is copy/pasted for a Find in another file, but I want to add the "==" parameter to it for exact searching... Any suggestions??

Share this post


Link to post
Share on other sites

Setfield[thefieldinthefindfile;"=="&thefieldnamethatcontainsthepartNo.]

I seem to recall that the divider in 6 might not have been a semicolon. You will have to look that up.

Sorry also for the elongated names but with nothing else to go on...

HTH

Phil

Share this post


Link to post
Share on other sites

Hi Phil,

It's a comma, but it really doesn't matter, as ScripMaker enters it automatically.

Hi WC,

Stay away from Copy and Paste, use a global field instead.

In order to perform a find in a second file, you will need two scripts.

I'll use File A and File B to explain it.

Create the following.

In File A, a global (I'll use [color:red]g_find).

In File B, create a relationship to File A. (I'll call it [color:green]B|A_Relationship)

In File B, create your script to perform the find

[color:blue]TheFindScript

Enter find mode

Set Field [ YourFindField, "==" & [color:green]B|A_Relationship::[color:red]g_find ]

Perform Find.

In File A, create a script with at least these two steps.

SetField (g_find, YourFindData)

and

Perform External Script [color:blue]TheFindScript.

HTH

Lee

Share this post


Link to post
Share on other sites

Also, if fr some reason set field odes not work, use the insert calculated result step instead.

Dave McQueen

Share this post


Link to post
Share on other sites

: Not working...

The calculation box keeps telling me it needs an operator where the comma (and I tried the semi-colon too) is... Also, I don't understand how the global field will identify the record in file A that is currently being browsed...

Could you explain?

Share this post


Link to post
Share on other sites

I noticed that you have added that you are NOW using 8.5. Things have changed since the v6 days, so which way do you want the example to be written. v6 or v8.5?

Share this post


Link to post
Share on other sites

(assumes the position of great shame)

I am sorry... it is 8.5...

I have been a member for a long time, and we just recently upgraded (after much prostrating and begging); I haven't changed my user preferences and they default to 6... Sorry...

Share this post


Link to post
Share on other sites

Location: Main Index » Forum Index » Your Control Panel » Public Profile >> [color:blue]FileMaker Questions (last item on the list.)

Share this post


Link to post
Share on other sites

It is a little bit hidden. I recently updated mine and it took me awhile to find the place to change it......lol

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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