Jump to content

switching layouts/tables in AS


Sam W
 Share

This topic is 5761 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I'm building a 3-table file in fp7 and using Applescript to populate it from properties in Quark. I got the quark part and the filemaker part working.

I have layout "text component" open

and this works:

tell "Filemaker Pro"

tell document "nci07.fp7"

tell layout "text component"

set thisRecord to create new record tell thisRecord

set cell "key" to arbFile

end tell

end tell

but when I add this:

tell layout "text component"

set thisRecord to create new record tell thisRecord

set cell "pgCt" to funfun

end tell

end tell

end tell

end tell

It fails to find the cell.

Obviously, I'm not addressing the right table/layout. I've searched the forums and tried different variations but it only works with one or the other when I manually switch layouts. One set of this will fail. I've tried switching the layouts in the script but they're failing too.

I've tried figuring the properties to get clues there. I've used this:

tell application "FileMaker Pro"

name of cell 1 of layout 1

end tell

to figure out how FM is addressing the layouts/tables. But while I have 3 layouts, only layouts 2-3 are seen. Layout 1 is not.

What would you do, and keeping three tables? thanx, sam

Link to comment
Share on other sites

After failing to find solutions that worked in the forums, here's what I found. To switch layouts in AS:

tell application "FileMaker Pro"

tell document "nci07.fp7"

tell window 1

tell layout "component"

go to it

set thisRecord to create new record

tell thisRecord

set cell "key" to arbFile

end tell --thisrecord:component

end tell -- table component

end tell --window 1

end tell --doc 1

end tell --app fmpro

Probably has some bad form in it, but it's getting me over my hump, thanx, sam

Link to comment
Share on other sites

This topic is 5761 days old. Please don't post here. Open a new topic instead.

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
 Share

×
×
  • Create New...

Important Information

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