Exacting detail

[WC Howard]

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??

[Inky Phil]

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

[Lee Smith]

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

[David McQueen]

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

Dave McQueen

[WC Howard]

: 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?

[Lee Smith]

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?

[WC Howard]

(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...

[WC Howard]

(Side note) Now see... There I tried to change all that in myh last post and it didn't take...

[Lee Smith]

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

[AudioFreak]

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

[Lee Smith]

v8 has made things a lot simpler. Here is an example of using both methods.

Lee

WC_Howard_.fp7.zip