Jump to content
Sign in to follow this  
stanley

again with the correct record

Recommended Posts

Ugh, why doesn't this work? I followed Chuck's advice and made the script like this:

set the thatMove to cell "Episode" of layout 0 of current record of database "Library"

set the inPoint to cell "TimeIn" of layout 0 of current record of database "Timecodes"

but I still always get the first record in the database from "Timecodes"

The only thing I can think of is that it does this because the "Timecodes" DB is in list view (although the call to the script comes from a particular record) - so I've made it switch to a normal layout before launching the AppleScript. Strangely, it doesn't seem to make the switch until after the AppleScript has run. Where am I going wrong?

Share this post


Link to post
Share on other sites

I had this happen recently, and I couldn't figure it out. My workaround was to first set the field I needed to a global field and then use AppleScript to reference the global field. It didn't matter which record it was using, since the global field is the same for every record. Again, I don't know why it wasn't working, but this workaround did the job.

Chuck

Share this post


Link to post
Share on other sites

We had the same problem. Perplexing.

Find your record with:

show (first record whose cell "your_search_field" contains your_search_field)

Share this post


Link to post
Share on other sites

Try this :

set the thatMove to cell "Episode" of current record of layout 0 of database "Library"

The order is : cell > record > layout > database

Share this post


Link to post
Share on other sites

I don't think the current record command will work. When you return from an external script filemaker puts you on record one. You need to return filemaker back to the correct record.

We have an import picture script that looks like this: (all done from withn a filemaker calculation field in the record we want to process. Path_1 is a calculated file name). Note the image is on the clipboard at this point.

__________

tell application "FileMaker Pro"

activate

show (first record whose cell "our_rec_id" contains our_rec_id)

do script "paste_picture1"

end tell

(paste picture1 just goes to the first image field and does a paste)

Hope this helps

Jerry

WebDudes

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  

×

Important Information

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