AppleScript & Automator

Hi to all hope you are keeping well, using fm7 developing for mac only. Im try just as a nice touch on my admin layout to have a button that automatically opens up the account and privilege window instead of the admin user going to file - define - accounts and privilige . Thanks for looking and hints suggestion or shout at my obvious noobiesness welcome.... d

Hello, I'm trying to find the best solution for validating links within a database without exporting records. I have come across such a solution in the past (see attached file) that worked by passing the data from a URL field to another application for validation and then setting a tag field within the database to indicate any failures. However the application that checked the links has not been developed for years and does run on OS X. Is there anyone out there that knows of a similar solution using scriptable link validation software or who can suggest an adaptation of the attached script to work with a similiar application ? Any help appreciated, …

Everything I've read so far says that the document class refers to the found set of a database. But when I run the following: -- already declared lst and filename tell database FileName delete every request repeat with i from 1 to (count of items in lst) -- a list of IDs set r to (create new request) set cell FindField of r to (item i of lst) as text -- Look in FindField for matching IDs end repeat find display dialog (count records of document FileName) end tell It returns the record count (all records in the database), not the count of the resulting found set. I must be missing something obvious; I'd appreciate any help. Than…

Hi - I'm sorry if this has been asked before. I'm new to this forum, FMP, and AppleScript. Here is my situation: I have thousands of High Resolution Tiff files I need to send to many different agencies. The file structures were created years before we contracted these other agencies and are spread throughout many different folders. I can get a found set of the images I need to send to each agency, I just need a way to copy the original Tiffs to a new external HD. All of the Tiffs have a low Resolution JPEG I have referenced to a FMP 6 DB. I also have a path to the Tiff file in that DB. I can only assume the only way to do this is through scripting. Any thoughts are ver…

Used to be you could run an applescript within 1 file omitting the application name- tell database "AnotherDatabaseBesidesThisOne.fp6" do script "MySubscript" end And it would magically work: Try as I might - 7 just gives me object not found errors no matter what I do. I've added the application name, gottent it to close and open files to no avail. Any thoughts? Thanks, Tim

Could someone point me to any resources about creating an Applescript to archive the databases? I need to run a script every few hours from FM Server 5 that will archive and date name backups. I looked around a little but didn't turn anything up. I'm sure that this has been covered and I'm probably missing it.

Hi, I am not that familliar with Applescript and what it can do. I would like to open a database and then run a script within it. Any help would be greatly appreciated. So far I have managed the following: tell application "FileMaker Developer" open database "MyDatabase" do script "MyScript" end tell When I try to run it I get: Applescript error FileMaker Developer got an error: Unable to coerce the data to the desired type. Help!!!

Using Script Editor on Mac 10.3.5, I am unable to refer to FileMaker 7 tables. Even though table appears in the FileMaker Pro dictionary (as an element of database), Script Editor acts like the word "table" is undefined. For example, the following script gets an AppleScript error that the variable tables is not defined. Any suggestions? tell application "FileMaker Pro" tell database 1 count tables end tell end tell

I have a very simple snippet of code that generates a 'Write Access Denied' error. On one table the code works but on others I get the error. All of the tables are in one file that is external to my layout file. I have relationships set up, but nothing that prevents the creation of records tell application "FileMaker Pro 7" activate database "APR Library" tell database "APR Library" set data of cell "File Path" to myPath end tell end tell

I haven't done much with Applescript, so I'm having a hard time figuring this out. I have a solution that automatically sends e-mails, using the Send Mail script step. It works fine, but different e-mail applications behave differently. Mail and Entourage will both send the e-mails automatically (when "show dialog" is unchecked), but Eudora "queues" them until the user manually tells Eudora to send the Queue (or upon quit, but who quits applications anymore?). For the life of me I can't find a setting anywhere in Eudora to automatically send the queue every 10 minutes, even though I could swear that used to be an option (this is with the latest version). If someone c…

How do i activate an open database? I have opened 5 databases and i want the fourth database to be the active/frontmost database. How do i make an applescript to make database 4 to be database 1. Calling the "open" command will take Filemaker some time to open the database even if it is already open, whereas, changing the active database might be faster. Thanks in advance

How do i create a script that will export a Filemaker text field into a Eudora message body. The text styles should not be lost. Thanks in advance

So I've been playing around a little with the filemaker 7 dictionary. I can't seem to get a reference to a table. Layouts, records, etc work fine. But when I try to "set c to count of every table" or refer to tables at all it's as if it doesn't recognize it; keeps telling me it's an unknown constant or an unset variable or something. I have a basic grasp of applescript, but I'm no expert by a long short so maybe I'm missing something. Here's the exact code I'm trying: tell application "FileMaker Developer" set c to count of every table -- also tried: set c to count of every table of database "test.fp7" display dialog c as text end tell T…

Heres the jist of my script: --tell current record of window 1 pull some variables ---tell application "Finder" do finding of files, pattern search etc return value XXX (a string of text) ---end tell ---Tell application "FileMaker" set cell foobar to XXX ---end Tell --end tell The set cell foobar fails EVERY time. (its a text cell) It quietly doesnt set the cell. When ive tried adding explicit commands to the active window etc i get the "data in use" error or "field not found" message. The problem has to be either my syntax or filemaker, as i have coded the script to put the value XXX into text edit…

I have been able to use applescript for FileMaker 10.2.8 and up to retrieve the NIC number from my Mac. However, I cannot get this to work properly with OS 9.2.2 I keep getting an error with the Write script: "FileMaker Developer got an error: Unable to coerce the data to the desired type (error -1700)". Does anyone have a simple Applescript that will allow me to grab the NIC number and save it into a field in FileMaker 6.0. I have found this script, I don't know if it could be edited to work. In order to get the MAC Address from Apple System Profiler, you first need to know that ASP refers to this as the "AppleTalk Address", and that it returns the add…

Hey, there. A client recently upgraded from OS 9 to OS X. We are using an applescript to move data from Filemaker 6 to MYOB AccountEdge v2. The file path specified is no longer valid given the new directory structure in OS X, but I can't seem to find what the correct path name is? I get an error message "Can't find the file..." when I run the script. I have tried using the path provided by Get Info and have also added the path provided by terminal: pwd, no luck. Help, anyone? sb here's the problem part of what we have: property MYOB_Data_FilePath : "Orion:Server:A Accounting/Invoicing Stuff:ATM Inc. Data/V9" tell application "FileM…

Both faxing and scanning result in creation of PDFs that we currently copy the image in Preview and then paste into a container in a new record. I would love the create an applescript to automate this process but Preview is not applescriptable. Ideally the script would open the PDF in a program and for each page, copy the image to the clipboard and run a script in Filemaker. I know how to do the last part, but do not know of a program that will accomplish the first part. TIA

Doesn't the following handler correctly express the database to which I am addressing the 'do script' command? According to the behavior (it always runs the script within "People.fp5") and the event log below, the "tell database" statement is being ignored. This is part of a stand-alone applescript. Thank, Chap on export(theDatabase) display dialog "theDatabase is currently: " & theDatabase try tell application "FileMaker Pro" tell database theDatabase do script gFMExportScriptName -- constant, set to "Export" end tell end tell on error myErr display dialog myErr end try end export -- Event Log -- te…

Here is my scenario. I need to have three buttons 1. DreamWeaver 2. GoLive 3. BBEdit Attached to each button I need a script that will open that program. In Windows I can easily do this by using the "Send Message" script and just type the word "dreamweaver.exe" in the text box and dreamweaver will open. No problem...unfortunately not so with the Mac. Is there a way to name the application in a script, such as BBEdit.app and have it open on the Mac? I know I can do this by selecting and absolute path, but, the .app may not always be in the same location from computer to computer. Thank you for your help! In Kindness Stephen K knight

I'm looking for some software that will 'watch' a folder for changes. I know Folder Actions will notify you of Adds and Deletes but it ignores Modified files. The software has to be able to call an AppleScript with a list of the added, deleted or modified files so I can do some processing withing FMP. A plug-in would suffice as well.

Does anyone know if it is possible to get a script in filemaker to call for example a customer with Skype (www.skype.com)? Is it possible to somehow export one number in to Skype and make a call?

I have a script to open an email from FM6 is it possible to use applescript (or any other method) to attach a file with a specific path on to the entourage window that opens?

I am trying to build an applescript within FM that will mount a network share based on the contents of global fields that contain the ip of the remote machine, the share point, the user name, and the password. The applescript script itself is contained in another global field that is calculated at run time to combine the other fields with static text to get it into the proper applescript form. I then tell the FM applescript step to use that global field for the applescript. It ends up looking something like this: property AFPdisk : "afp://192.168.123.110/thesharepoint" property AFPuser : "theusername" property AFPpswd : "thepassword" try mount volume AFPdisk…

Can I use an applescript with FM to force a user's computer monitor to change from 800x600 to 1028x 768? Can it change back when they quit? I have some users who prefer the larger resolution, but the database I made for them doesn't show entirely if the monitor is set to that resolution. I have never applescripted before. If someone has a simple one and can tell me how to use it with Filemaker Pro, I would be grateful!

i have a filepath to a pdf document that imported with this information: file:// G4/Users/jeffbill/Documents/tutorials/Page 4 - Channels Masking.pdf into a field called "path" How do I automate Filemaker with apple events or applescript to launch the file at the end of this path? I'm new to applescript and apple events -thanks -J

Hi, I tried this query in the Import/Export forum without success. Maybe someone here can help. I have been unsuccessfully trying to upload a FM export (.csv doc) to a departmental web site. It would only upload the first line. I found that opening the export on an XP machine and re-saving with Line Feed character as well as carriage return fixed the problem. Can I get FM to insert this character into the export, or perhaps trigger an Apple script that will do it? It doesn't take long to do it manually but I am trying to make it a 1 buton process in FM because I don't always run the export. Along the same lines, one of the import files always needs a header stripped…

I need some help with an applescript that deals with a filemaker database. What happens is the user searches the database and omits certain records So e.g. he found 10 of 30 records. Then i want to process the records the user has found and set the content of the records to a list. If i process every record in the Database i use code like: set Rec_list to every record in database DB_name But i have no idea how to put the currently found records to a list. Can someone help me out on this one?

Im running an applescript to update/create records in my FM5.5 runtime app The applescript reads a text file that contains the entries that need to be added or updated. while the Applescript is running the runtime app "unexpectedly quits" and leaves my database corrupt. It is quiting at random spots in the text file the weird thing is that it works completely fine in OS 10.3 and OS 9. it even works in 10.2 if the USR runtime files are run from filemaker and not the runtime. im completely stumped...if anyone can help, it would be greatly appreciated Thanks

Hi, Any way I can capture the Dock size, scale and position so to decide how to position my FileMaker Windows for Mac users ? Thanks

I want to save smaller copies of a large batch of jpg files and want a script which will run an application that can do this. Any suggestions welcome. Mike Owen

How do you keep AS from proceeding until the FM script it has initiated has actually completed? Below is a snippet from my AS. The dialog pops up immediately, long before the Filemaker script has finished. try tell application "FileMaker Pro" tell database pFMMasterFile do script pFMScriptImport end tell end tell on error errMsg error errMsg end try display dialog "Hello from Applescript - has the Filemaker Import finished?"

I would think this would work: tell application "Finder" set source_file to (choose file with prompt "Choose File...") end tell tell application "FileMaker Developer" tell database "LexiconProduct" tell layout "Control Panel" set cell 247 to source_file end tell end tell end tell It always stops at the cell reference and puts up a Dialog "blah, blah, blah. Object not found" TIA

I need to create an FMP script that will copy an email address from an FMP field, open up the default mail application on the host computer - and then create a new email with the email address from FMP as the send to address. I'm guessing I have to incorporate an applescript to handle the non-fmp segments of the task. Am very new to applescript, however. Any help or suggestions pointing me in the right direction much appreciated! Thanks!

Hello. I can't for the life of me get this, and I'm hoping you can help me out. I simply want an applescript to write a text string into the second repetition of a repeating field? Any ideas? I don't have much hair left to pull out (plus, I guess it's time to acquire some familiarity with applescript). TIA.

(OS X only) I got this idea to hide my four-file database, along with a few shell scripts and other "resources", down inside an Applescript that has been saved as an application bundle. Specifically, I created an Applescript that simply tells the Finder to open the master FM file (see below); saved the Applescript as an application bundle; opened the package contents and drilled down into Contents:Resources: and put my folder in there. The client can no longer accidentally open the wrong file at startup (in fact he doesn't even have to know about database files at all). I can create an icon with his logo and affix it to the Applescript, as a nicety. There must be…

Hi all, I just wanted to post a question and comment. After testing Applescript and Filemaker exhaustively I have been unable to get a returned value to place in any cell NOT on the frontmost or active window. I tested and followed the examples and syntax provided by Apple and Filemaker to no avail. My file is open and hidden in my solution. The applescript works flawlessy at returning the information. Does anyone have an example which works in a hidden window of a different table in a different file? TIA

Hello, I'm hoping someone can help me. The goal: to AppleScript a SECURE PDF through Acrobat and have it automatically have the PDF attached in an email. I don't know AppleScript very well so I'm having trouble doing this myself. I currently have an AppleScript that I got from either Apple's website or from this website (not sure which). It will automatically create a pdf, give me the option to name it, then it automatically creates a new email message in "Mail" and attaches the PDF. The script resides in my Library folder inside a folder named "PDF Services". That way when I print a document, there is a button in the print dialog box called "PDF". Whe…

Is there a way to write an AppleScript that will automatically Export Records of your choosing (with formatting intact) to an AppleWorks spreadsheet?

How do you go to the next record with AS? tell application "FileMaker Pro" create new record go to current record + 1 --or go next --or go next record end tell Thanks Chas

I am trying to automate a data dump into Word. My client wants to be able to take some of the results, press a button and have it "magically appear" in Word so she can fine tune the information into a report. My problem is I can't get AppleScript to allow the copy from FM to Word. I get an error message along the lines of "Word does not have access to that data." I have never used AppleScript before so I do not know the rules of data sharing in this program. Can someone point me to a resource that explains this or tell me the theory behind what I want to do? I started with this script in FMP: tell application "Microsoft Word" activate make new docume…

Recently upgraded to FM 7 (version 7.0v2) from FM 6 and a script that I use every three months stopped working. Traced the problem to FM Pro error when AppleScript tries to set a value for a find request on a calculated field. Got error "write access denied" every time. Non-calculated fields work fine, and I tried every permissions/access type of fix that I could think of. I actually called FM tech support, which was non-helpful. My work around was to create a new field with looked up value from the calculated field using a self relationship. Seems a tad kludgy. I saw one other post that mentioned the issue, but also several other problems so the answer wasn't clear.…

I have a list of bounced emails that I want to purge from Filemaker and have found a (maybe) strange thing... First, I know the email address exists in the FM stack and lives in cell 32 this is my script.... global TheList tell application "FileMaker Pro" tell application "BBEdit" set TheList to {} --set TheList to file "textList" set TheList to the text of window 1 --set TheList to every word of TheList end tell -- set TheList to {[email protected], [email protected], [email protected]} delete every request repeat with i from 1 to the length of TheList set newReq to create request set cell 32 of newReq to item i of TheList…

I want to be able to send my client clones of his databases whenever I make miscellaneous tweaks to the non-data portion of a database (scripts, field defs, etc). He should open the clone and run the script "Upgrade" which asks him to locate the folder containing his current db files, and then runs Import for each file. The files in the current and new folders have matching names, if it matters. I figure this is a FM script that kicks off an Applescript to prompt for the location of the source data. But how do I then run the Import script step, telling it where to import from? I'd rather him not have to be faced with the Import dialog for each of the four files. …

My FM script has a Perform Applescript, containing the following: ----- set debugSwitch to (cell debugParameterName of current record) ----- From what I can guess of the FM error message ("Object not found"), the notion of 'current record' has been forgotten by this point. In the FM script leading up to Perform Applescript, I have got: ----- set debugSwitch to (cell debugParameterName of current record) Set Field["g_CurrentRecordNumber", "Status(CurrentRecordNumber)"] // remember curr rec [... a Find and a SetField, but no record deletions...] Show All Records // make sure we're not in a found set Go to Record["g_CurrentRecordNumber"] …

I want for a global field to contain an Applescript template that I can copy and modify at runtime with a FM script. How can I initialize this field? SetField doesn't like its being >253 characters. And I don't think I should simply initialize it once, manually, because it could possibly be deleted. Thanks! Chap

I have a student enrollment database & layout from which I have to create a MS Word confirmation letter. Once we have enrolled someone in a workshop, I want FMP6 to tell MS Word to create a new document from a template, and to fill in merge fields with info from the database, such as student name, workshop name, dates, and so forth. I know basic Applescripting but very little about MS Word. I need a suggestion as to the general approach, rather than being given the code. (I can do the legwork once I have the general approach.) Word can, I've read, pull merge data from a FM database, but it's not clear to me how my FM-driven Applescript would communicate to Wor…

Hi all: I have an AppleScript that pulls data from a Canto Cumulus db and transfers it to a FMP 6.0 db. I am then using PHP and a class called FX to query the FMP db and display the results through a web browsers. (FX queries the FMP db, gets the results and parses the XML and then returns it to PHP in a multidimensional array - very cool). When I query a hand coded db it works fine, when I query a db that was created with AppleScript I get an XML error - invalid token. I don't think it is the db per say because I took the one that was giving me the error, purged it off all records created by AppleScript, added a new record, queried it from my web page and it wo…

We have a cross platform database (FileMaker rules!) but I develop mainly on a PC - use a Mac for checking our solution. I've been using Macs quite a bit for a couple of years but I've no idea when it comes to AppleScript or AppleEvents. At the moment I have several buttons on the front page to our solution that act as shortcuts to shared folders on our network. Being a PC developer I've only managed to get these to work on PCs. All our PC users use these buttons for quick access to the shared network folders. The way I've got it set up on the PCs is by using the 'Send Message' script step. It sends the 'open document/application message' And the message t…

Are there any good tutorials (well laid out) about integrating and using filemaker with applescripts? Web, books, sample files, etc.. I'm just toying around with some idea's now and wouldn't mind doing some detailed reading up on this if anyone can recommend anything good. Thanks. Joe

I want to use Applescript to delete the access log file in my web folder. I am using FileMaker 7. I would like to be able to import the access log and then delete it. I cannot figure out how to import the file with applescript as the access log file is saved with a .log extension. Any insight on this would be greatly appreciated. Thanks Joe Mele

I'm guessing this is a job for Apple Script. How would I go about using a button to open preview to display the full sized version of an image I have in a container field? Thanks!

I want to use a FM script to launch an Applescript application. However, the dialog that comes up when I script "Send Apple Event" won't take my application specification. I'm telling it to send the open application event (along with Bring App to Foreground, and Wait for Event Completion). When I click Specify Application, the OSX Open dialog allows me to select my app, but after I press Open, the Target Application still displays "<unknown>" The app is called Direct Download.app; it's an Applescript that's been saved as an application bundle. It runs fine when I double click it. FMP6.04, Panther.4, Applescript 1.9.3 Any ideas what I'm doing w…

I'm getting stuck with a "where is the application?" dialog. Can anyone help me eliminate it and improve my script? Thanks. "tell application " & """ & "Entourage" & """ & "

Hi there. I've installed the Xmail (OSAX style) Scripting Addition. I'm trying to have Filemaker generate a calculated Applescript that sends attachments to a file (or files, hopefully), specificied by the path of a container field. I can send emails fine with the script, but can't seem to send an attachment (regardless of whether the file is local or on a mounted network drive). The path I'm trying to send to is valid, because the send mail script step sends the attachment just fine. Could someone please take a peek and take a guess as to what's wrong ? Here's what the calculated script ends up looking like: Set toList to {

OK, I'm stumped and obviously missing something. How can I get the index of the current record so I can use it like this (where 'N' would be the index): set x to get cell "A" of record N of layout "A" of window 1 of database "Test" I know I could write: set x to get cell "A" of current record of layout "A" of window 1 of database "Test" but for some odd reasons that's not working in all of the cases in FM 7 (I get object not found). So back to the original question - how do I get it?

Okay, I'm a TOTAL Applescript virgin ... be gentle. I have a client who wants to be able to switch between printing to her default printer, and printing to a pdf. The print dialog is disabled in all of her print scripts On the PC, I can change FM's default printer by changing it in the Print Setup dialog. I've tried to do this in Panther, but the pdf-writer isn't available as a selection. Is there an applescript I could send her that would toggle between the two, or do I have to go out to her office and enable all of the print dialogs? Thanks for any help you can provide. Paul Version: v6.x Platform: Mac OS X Panther

I have a very limited experience with AppleScript and need your help. In my (chemical) Compounds.fp7 file, I have a FM script which copies the content of a container field, Structure (picture), and calls, via AppleScript, another app, CS ChemDraw Ultra, to perform calculations on the Structure. The result of the calculation (e.g. Molecular Formula in the example below) returns into an another field (MolFormula) of Compounds.fp7. For example, if the Structure field contains benzene structure (a sort of hexagon, you remember?), the MolFormula field will be populated with "C6H6" etc. tell application "CS ChemDraw Ultra" activate open file "Macintosh HD:Use…

Here's my AppleScript (embedded into the FileMaker file as a calculation field: tell application "Finder" activate if not (exists disk "Engineering") then beep display dialog "You must first mount the Engineering volume." with icon 2 buttons ("OK") default button 1 else if file "050-0000-0108-00D.pdf" of folder "050-0000-01XX-XX" of folder "050-0000-XXXX-XX" of folder "050-XXXX-XXXX-XX" of disk "Engineering" exists then select file "050-0000-0108-00D.pdf" of folder "050-0000-01XX-XX" of folder "050-0000-XXXX-XX" of folder "050-XXXX-XXXX-XX" of disk "Engineering" open selection else beep display dialog "There is no …

I have tried in many ways but i didn't get control on Print dialog windows of Preview, using the System Events management, as following (I had to choose to crop the document that is bigger than the paper format): tell application "Preview" to activate tell application "System Events" tell application process "Preview" click menu item "Print

Hello all, does anybody know how to archieve this: I have a Drawing Database, and the Record lets say has a Number 10001. I want to import a Drawing, Jpeg, File into the Records Container Field, and in the Process change the Name of the imported File to the Drawing ID. Is this possible? I read another Post, whcih explained how to change the Filename after importing, but i see problems with that and my Users. It would be better if the FIlename is already the same of the Drawing ID before they export it again. Does anybody know a Solution? Thanks for all Input or reference to learning Material regarding the Topic. Overrider

I'm having a problem entering a value into a FM7 request from applescript. The script I have, basically, is: on run set myfilename to "Testname.mov" tell application "FileMaker Pro 7.0" tell database "EPICPhotographs" show every request delete every request set myrequest to create new request show myrequest set cell "filename" of myrequest to ("==" & myfilename) as string find try return cell "header" of current cell on error return "" end try end tell end tell end run the cell "filename" is a calculated field in the database. when I run this script, I get: "FileMaker Pro 7.0 got an error: Write …

I'm trying to set up a cross-platform script that will find and open a folder on the network. The network folders are grouped under primary folders named "10000s", "20000s" etc. The final folders are numbered corelating to the record number. For example: Server->20000s->29001. So far I've got it working on Windows, but I'm not making as good progress on the Mac. On Windows I have a script step using "Send Event" to Explorer to open document using the calculation: "explorer serverfolder_afolder_b" & Floor (Database::RecNo /1000) & "s" & Database::RecNo Most of the calc just determines which major folder it's in, then it has explorer look for the f…

I have an Applescript program that loads a Filemaker database. In order to provide progress feedback, I added a global text field to the layout. The layout is visible during load, and the Applescript periodically updates the global, using tell application "FileMaker Pro" set cell theCell of database theDB to theValue end tell where theValue is the progress message. I formatted the text attributes of the field with font, size, style, alignment, and text color. At some point in the loading process, after displaying correctly for a while, the field appears to lose most of its text attribute settings, reverting from 24-point bold white to 12-poin…

I'm looking for a script to automatically open a word document. Every record needs to open a different word document, but the documents are all in the same place. Any suggestion ?

I've been made the adhoc database designer/maintainer for a person i tutor and i've been able to get by until now.... we have a database where he will plan his roadtrips (he's finding himself doing more and more roadtrips) and the solution that i have come up with that doesn't quite fit his needs is as follows: we have a database full of campgrounds, with fields for among other things, the city, state, address and notes on the particular camp ground. i also have 3 fields specially for his planning: Arrival Date, Departure Date, and the order of the stops on the currently planned trip. (i realize i could just sort by date, but he fills those in *after* deciding o…

I need to locate a record on a specific layout and set one of the cells to a value. I have done this thousands of times in FMP6 but am having great difficulty in FMP7. Can anyone help me please?! Here's my code... tell application "FileMaker Pro 7" tell database "IMS" go to layout "shell [imageTemp Lookup]" show(every record whose cell "id" contains "T0000003") set cell "status" of current record to "Completed" end tell end tell --This causes "Event Failed" error.

Hi there How do I, using Applescript I assume, format the selected text in a field (ie: make bold, underline, etc.). I have no Applescript experience - but surely this would be a simple little applescript? Thanks.

I couldn't find a completely satisfactory answer with my search, soooo.. Can anyone explain how I can open a remote file via applescript or a Filemaker script? I have several files, on an OSX box. I want a script to call open a file named "A-scans" on our remote hosting unit using a script and a pre-defined password. I do not want to show the user any "open remote" dialog boxes or any password dialogs. There may be as many as 30 databases opened and searched with the Applescript/FMPscript, so speed and user simplicity is important. TIA, Chris

Summary I need a way to filter/find records based on 4-5 criteria, but FM7 is ignoring items in the whose clause beyond the second. Details I have a table which among other fields has category, subcategory, year, month, and price fields. I need to be able to bring the total of all prices over into an (existing) excel spreadsheet, with a unique subtotal for each combination of the category, subcategory, year, and month. Further, I need to get a 0 subtotal value even if no records for a specific subcategory or month have been entered. I was doing this using Filemaker 2.1 (!) and applescript, but using Classic for FM2 has become a problem. So I'm trying to port…

I'm working on exporting my Filemaker layouts to pdf's so I can e-mail them. Since I'm not fond of getting a plugin, I'm relying heavily on applescript. Right now, I have it setup so that the script exports the pdf to a "Quotes" folder on the users Desktop. I'm trying to rename the pdf with the following applescript. set newname to cell "Prospect ID" of current record set filepath to (((path to desktop) as string) & "Quotes:temp_quote.pdf") tell application "Finder" if name of document file (((path to desktop) as string) & "Quotes:" & ((newname as string) & ".pdf"))exists then --do nothing else set name of document file file…

tell application "FileMaker Pro" getURL myURLStringHere end tell will give me an error if the script is for a file of FileMaker 6 yet the user has FileMaker 7 currently running. The same problem occurs with attempting to create an AppleScript to work on a FileMaker 7 file with FileMaker 6 running. How can distinguish in AppleScript to specifically tell which version of FileMaker to execute the AppleScript on? Thanks.

Hi, I've been using a very simple Applescript which opens a PDF and prints it using Acrobat, but when I move it from OS 9.2.2 to OS X 10.3.3, it stops working, Acrobat opens the file, but it doesn't print any more! here's the original version: tell application "Acrobat 5.0" activate try open file "File path here" print pages first 1 shrink to fit close end try end tell (I've tried leaving out the "shrink to fit" with no success.) Can you tell me what I need to change for OS X? thanks, jeff

Is it possible with either Applescript or Scriptmaker to adjust a fields size or position? Thanks,

Is thier any way with either Applescript or Scriptmaker to control the size and location of a field?

I'm in need of a little help in translating the AppleScripts I used with FM6 to FM7. In FM6, I used a FileMaker script that looped through the records of a database and performed an AppleScript on each record. This AppleScript would set variables to the data of various fields, and these variables would be used to tell other applications to do something. For example: tell application "FileMaker Pro" tell database "test.fp5" tell current record set myVariable to get data of cell "test data" end tell end tell end tell tell application "Finder" --do something end tell This approach is no longer working for me in FM7. I've tried …

Hey Folks, I know this is do-able, but I haven't been able to find an example of how to do it. I'm trying to call an applescript from filemaker, then have that script return a value back to filemaker. Could someone post an example of setting a field (global or otherwise) in a particular filemaker file from an AppleScript? Thanks much, Jeff

Hello All, I have a database that I'm trying to link a help document to using a <Help>. Currently, the help info is in an Excel workbook. Is there a way to link (via a <Help>) this info to the database? If so, how? If it has to be linked within a FileMaker table, can I link it with a simple script? I appreciate everyone's time and help! Lisa

I am new to Applescript and I am trying to open FM7 and start an application with the following code: tell application "FileMaker Pro 7" tell database "pb-a514:Users:Dave:Desktop:MS2_Latest.fp7" activate do script "Go To Work" end tell end tell Any help is greatly appreciated! SORRY, I just got it to work with: tell application "FileMaker Pro 7" open file "PB-A514:Users:Dave:Desktop:MS2_Latest.fp7" do script "Go To Work" end tell

Is it possible to define a FM script in one table/database that looks in a second table/database and then updates information in the second database based on the search results? here's the background: working on an ad ordering & produciton status project. Ads can be ordered for up to 26 issues using a single form. The order form will be static, that is the information will not change unless the contract conditions change. The production criteria (ad size, placement, proofing, material requirements) for each of the 26 ads can change for each issue. In other words, a client can contract for 26 issues and submit a different ad for each issue. A simple relatio…

I have a subroutine finding all matching records and building a list of Record ID (example: 3.5869E+4). Unable to directly go to those records, so I have a clunky work-around of stepping through every record and seeing if that specific record matches. There has to be a better way. Here is the slow code that brute forces its way through the DB... --Finds specifc date records in DB. This works quickly and well. set foundRecords to findSingleDay(simpleDate, "Text DB", "Detailed Layout") tell application "FileMaker Pro" --counts entire database (98% worthless data) set countOfTextDB to count every record of database "Text DB" end tell set i to 0 …

Hi, I have a question using FMP 6, a database served by a Panther machine to OS 10.3 and 9.22 clients. I've created a button that I've set to "Send Apple Event" to activate an Applescript applet that I've been using a while. This works wonderfully locally (on a test machine, test version of the database, with no clients), but I'm having a bit of trouble finding the proper place to put it for the server based database. For OS X clients, If I distribute the applet to each client and place it on the root level of the hard drive it links correctly and works. For OS 9 clients, the first time I press the button in the database I'm asked to locate the applet, but there…

I'm trying to make an AppleScript that will change the document named rename.pdf to another name. I tried: tell application "Finder" activate set name of document file "rename.pdf" of folder "Desktop" to "hello.pdf" end tell to make it work, I have to add the full path... set name of document file "rename.pdf" of folder "Desktop" of folder "jasonwood" of folder "Users" of startup disk to "hello.pdf" but this won't always run on a machine with user "jasonwood". I also tried ..."Desktop" of folder "/~" of startup disk to "hello.pdf"

I'm writing an Applescript app to fetch a large amount of data and add records to a FMP database. The process is time-consuming, and I'd like for the user to be able to switch away from FMP and do other work. However, whenever I try this, FMP stops and bounces its icon in the dock until I switch back to FMP. It appears to want to be brought to the foreground to display every new record as it's loaded. I would swear that, in an earlier incarnation of this application, FMP did not attempt to display every new record as it was added, and did not complain if I switched away from it. I have no idea what I have done to tell it to show me its progress! Any ideas or…

How can I insert an image into a FM Pro database using applescript so that the image loads not the reference to the file? The following command will insert a reference to an image. set cell "Image" to file Test_Image Thank you. ss

I am having a few problems with an applescript opening a hosted file on FM server 5.5 When I use the following script it doesn't find the relevant file. Is there an easy way to direct the script to open a database from a specific server? tell application "Finder" activate select file "filemaker pro" of folder "filemaker pro 6 folder" of folder "applications" of startup disk open selection end tell tell application "FileMaker Pro" open file "FM.fp5" end tell Would I have the same problem with this script in OS X? Thanks Kieron.

I need to control a movie in a container field. I want to use filemaker buttons to move forward and backward one frame at a time. There is no direct way in filemaker to do this, does anyone know of an applescript reference to control a movie in a container field?

Hi, Is it possible with FileMaker running on Mac OS X set it up so that FM script will run every week at a certain time? For example, I need to import records into FIleMaker every week on Monday from the file which always will have the same name and will be stored at the same place on the server. How can I do that? Can I use ApplyScript for that or any other tool? Thank you Jul

Hello everyone: I've got a task that I imagine is fairly simple & straightforward; however, I've rarely (read: never) actually worked with the guts of an Apple OS before. What I'm looking to do is to save a copy of the "Events.log" file in the FM Server 5.5 folder daily. Ideally it would automatically be saved to another folder using some form of the date as the filename. If anyone can point me to an easy tutorial website on how to use this applescript setup or on if this is possible from within filemaker pro server I would greatly appreciate the assistance. Thanks for the inevitable replies! ~Tom

I'm trying to open up a pdf file with "send apple event," and though Acrobat Reader will open, the particular file specified in the path does not open. I can open up a Word file with "send apple event," and even a jpg, but not a pdf. Any suggestions?

Hi There, I'm new to using Applescript with Filemaker and need some help. I have an applescript that shows a list of printers connected to a computer and allows you to select a default printer which it sets through Print Center. Here is the script. tell application "Print Center" set printerlist to name of printers set oldprinter to name of current printer set printerchoice to (choose from list printerlist with prompt

i am trying to write a script that will let me change the custom username in application preferences. i have written a script with a custom dialog that allows the user to chose a new username and then copies it to the clipboard. i need the applescript to pick it up from there and paste it within the application preferences window. what i can't seem to locate is the way to access items that are under the filemaker pro menu in os x which is where these preferences are. i opened the dictionary and see how to get to all but this menu. anyone know how this would get scripted? thanks, Limore

Does anyone know how I would go about telling applescript which version of FM to open up. As far as I can tell, it opens up the version that was installed most recently, but I'm not sure if this is the case. Any help is appreciated.

Post deleted by jackinva

Ok here's my situation. I have a filemaker script that does a few things and then eventually calls and applescript which presents the user w/ a few choices of what to do next. The only problem is i want one of those choices to allow the user to cancel the script but I can't figure out how to do this. I looked through the filemaker applescript dictionary and didn't see anything of use and my other idea was to somehow use a filemaker "If" and "Exit Script" script step but i can't figure out how to define a applescript result in scriptmaker nor can i find a way to call these steps directly from applescript. If anybody has any ideas please post here.

Filemaker fun with unixy stuff for Mac OSX - get the top N values in any field in any database. Put the following in perform applescript step in a FileMaker script: choose from list (get name of every field) set whichfield to item 1 of result set theData to field whichfield of document 1 set AppleScript's text item delimiters to ASCII character 10 Set shellStuff to " | sort | uniq -c | sort -rn | head -5" do shell script "echo " & quoted form of (theData as text) & shellstuff display dialog result SaleData.zip

Is there any way to trap the file name of a file as you import it into a container field? I want an "add image" button that will import a picture into a filemaker container field, and then populate a text field with it's filename. My assumption is that this needs to be applescript, but if not, would be more than happy for a built-in alternative Thanks for any assistance. Cheers, Justin

Hi All FMU on OS X tends to crash (apparently this is well known, I've only just found out!!) Apart from using OS 9 can I use an applescript to check whether FMU has indeed crashed and then open FMU with some predetermined Databases? I do not know applescript so would appreciate some help/pointers I anticipate using the script with cronniX to run the script at pre-set intervals. anyone? TIA Matt

oh man.. i give up... i just wanted to rename my exported filemaker file to include current datetime as part of its filename. i read somewhere in this forum that i could do this using applescript but hell.. i have only been a mac user for a month.. i guess its not a duration long enough for me to fully understand the language that apple uses and how does the scriptmaker functions... think i need help here.. an applescript which renames file will be good and i will work out from there...

.com Solutions Inc. has updated its FileMaker 7 AppleScript Reference with a new FileMaker 7 version of the file (16K download file), in addition to the PDF version. The guide provides a side by side quick reference for commonly used FileMaker 6 and FileMaker 7 AppleScript code examples. Each code example is stored within a FileMaker 7 database field for easy copying to the MacOS X Script Editor. These updated files may be downloaded from: FileMaker 7 AppleScript Reference - download (16K)

I've had amazing success using Applescript to send, receive and pass information to and from FileMaker in version 6 (and 7). I have a solution that I wish to create runtimes using Dev 6 (and eventually 7) that use Applescript in the same way. Basically I wish to create a protable version of my solution. I am having strange and unstable results using the same exact things when my solutioin is coverted to a runtime. Sometimes the Applescript app (script saved as and app and or from scriptmaker) succeeds in passing info to FM runtime but most others my runtime crashes and the applescript displays and error of connection lost. I figure this may have to do with speci…