• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag
 

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Import and export from Applescript variables into Filemaker Pro
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Import and export from Applescript variables into Filemaker Pro


  • Subject: Re: Import and export from Applescript variables into Filemaker Pro
  • From: Craig Williams <email@hidden>
  • Date: Sun, 30 Nov 2008 13:30:02 -0700

Try this:

tell application "FileMaker Pro Advanced"
tell database "NHANESIII_Database Graphs&Indices"
set SqNr to cell "SEQN" of current record
end tell
end tell

Now the variable SqNr contains whatever value was in SEQN.

Cheers,

Craig



From: Willem <email@hidden>
Date: November 29, 2008 11:53:17 PM MST
To: ApplescriptUsers <email@hidden>
Subject: Import and export from Applescript variables into Filemaker Pro


To be more explanatory, part of my script is as follows:

tell application "Finder" -- Script Debugger 4.5
activate
set the clipboard to ""
activate document file "Test Solver.xls" of folder "Desktop" of folder "lungmummy" of folder "Users" of startup disk
select window of desktop
activate document file "NHANESIII_Database Graphs&Indices.fp7" of folder "Desktop" of folder "lungmummy" of folder "Users" of startup disk
select window of desktop
set FNr to 0
set BCnr to 0
set SqNr to 0
tell application "FileMaker Pro"
activate
--go to field SEQN --- The variable SEQN is not defined.
--copy field {SEQN, NHANESIII - Spirometry} --- The variable SEQN is not defined.
set value of field SEQN of document file "NHANESIII_Database Graphs&Indices.fp7" to SqNr
-- FileMaker Pro got an error: Object not found.
end tell
-- When SqNr was copied in 2 seconds by a Filemaker script into the clipbord,
-- and then pasted by a macro on row 17 of column 17 the next on Excel worked fine:
tell application "Microsoft Excel"
activate
activate object workbook "Test Solver.xls"
set (value of row 17 of column 17) to SqNr
wait 2
set FNr to (value of row 17 of column 16) -- with an addition of ".csv" by a cell formula.
set (value of row 25 of column 11) to SqNr
wait 2
end tell
-- WHY NOT IN FILEMAKER? Not to speak yet about so many Applescript variables
-- with Excel calculation values, which have to be imported into Filemaker fields.
-- I could not find help in "Filemaker Pro.app's" dictionary from Script Debugger 4 or 4.5.
-- But who am I?
end tell

Willem Vriend. 
 _______________________________________________
Do not post admin requests to the list. They will be ignored.
AppleScript-Users mailing list      (email@hidden)
Help/Unsubscribe/Update your Subscription:
Archives: http://lists.apple.com/archives/applescript-users

This email sent to email@hidden

  • Prev by Date: Re: AppleScript-Users Digest, Vol 5, Issue 632
  • Next by Date: tabs to spaces
  • Previous by thread: Re: Import and export from Applescript variables into Filemaker Pro
  • Next by thread: Re: AppleScript-Users Digest, Vol 5, Issue 632
  • Index(es):
    • Date
    • Thread