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

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

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

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

Lee

WC_Howard_.fp7.zip

Share this post


Link to post
Share on other sites

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
Sign in to follow this  

  • Who Viewed the Topic

    1 member has viewed this topic:
    siroos12 
×

Important Information

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