AppleScript & Automator

Proof of concept, probably not much use, but perhaps interesting. Included is a small AppleScript droplet to Insert whatever image file is dropped on it into a container field of the current FileMaker record. It (should) work with either local or mounted volume files. It is too bad we do not have the ability to somehow have an AppleScript "hot spot" object on a FileMaker layout, which could do this internally. This file requires FileMaker 8+, because it uses script Variable file paths. [P.S. The skull smoking a cigarette is a Van Gogh painting.] Import_wDroplet_8.zip

Hi gays Need big HELPPPPPP Pls. Can somebody write or send to my private e-mail Apple script which create empty folder somewhere on Hard disk. Thank You very much Ino :thanks:

I've tried to use the syntax: set myRecs to (every record of table "mytable" of database "mydb.fp7" whose cell "myCell" = "something") But all of the time I found it not working or not working all the time. Could anyone share the correct syntax and or the tricks for me to feel confident to use this way of accessing the tables.

I was wondering if there was a script that helped take invoice information and help it work with quickbooks. I'm just taking a basic client name and credit or charge amount and plugging them into quickbooks. I think that filelinks fmbooks are way more advanced then i need in sharing information. Thanks, Jonny

is it possible for applescript to use filemaker variable. or does anyone know how to set the last created item as target item in applescript?

Hello, I am trying to use an AppleScript from within FileMaker to copy a shipping address to a program called Endicia, which prints mailing labels and postage. The AppleScript works fine, except the address in Endicia doesn't handle the carriage returns properly (see attachment). What can I do to convert the carriage returns (which are ASCII 13 I think)? Do I need to convert them to ASCII 10 (LF)? Regards, Sean Mills

I have an apple script to mount a remote volume via the script however it leaves the finder window on top. How do I modify my apple script to mount the remote volume hidden or with out spawning a new finder window, leaving Filemaker the active application?

I'm trying to export a couple of fields into Powerpoint, but I cannot get the applescript correct. Running a native applescript will allow me to put something into Powerpoint, but I can't get a field to export and then show up in Powerpoint. I've tried writing a calculated script, but I always seem to get an error 2741, so I must have something wrong. Here is the calculated script I'm using any help would be appreciated. "tell application "Microsoft PowerPoint" activate set this_presentation to make new presentation set this_slide to make new slide at the beginning of this_presentation ¬ with properties {layout:slide layout title slide} set the…

I just added the FileMaker Pro Action Pack, and built an Automator workflow which is: - Get Selected Mail Items [Mail] - Display Mail Messages [Mail] - Combine Mail Messages [Mail] - Copy to Clipboard [system] - Perform FileMaker Script [FileMaker] The last Action calls a FM script which Pastes without style into a field. The FM script works by itself in FM when I've copied text in FileMaker (to the clipboard) and run it. The Mail and System Automator Actions appear to work (but the FM Action doesn't) -- when I run the workflow, and then afterwards manually Paste into a TextEdit document, I get the expected results. When I try to paste or paste without …

Is this possible? 1. Can you create an applescript to execute a script in FileMaker 2. Can you create code for a web browser to execute applescript therefore Can you embed applescript into a webviewer html page to execute filemaker scripts?

I applied a simple Applescript routine (included in the next paragraphs) to read the time code from a opened Quicktime movie and to insert it in a database field. This routine still works fine using Filemaker 6, MacOS 10.4.8 and Quicktime 7.1.3, but when I copy the routine to use it with Filemaker 7 or 8, it does not work. Any suggestions to translate it properly?. tell application "QuickTime Player" activate global this_time set this_time to the current time of movie 1 end tell tell application "Filemaker Pro" activate set cell "G1" to this_time end tell

I am writing a script to tell a remote machine running FileMaker Pro to run a FileMaker script. set remMachine to "eppc://" & userName & ":" & pasword & "@" & ipNumber tell application "FileMaker Pro" --of machine remMachine do script FileMaker script "Some-Script" end tell Note that of machine remMachine is commented out. If I uncomment out that part of the command I get an error when I try to compile the script... Sytax Error: Expected end of line but found “script”. How do I make this script work? Thank you.

I'm updating a script that was working fine against a FMP 5 Server database, but in upgrading it for a database now on 8 server, I'm unable to show a newly created record using the pointer returned by the create new record command: This script returns an "Object not found" error: property dbURL : "fmp7://[email protected]/DBName" tell application "FileMaker Pro Advanced" activate getURL dbURL tell database 1 show layout "New DataEntry" set new_rec to create new record show new_rec end tell end tell The Event Log looks like this: tell application "FileMaker Pro Advanced" activate getURL "fmp7://[email protected]…

What would happen if an AppleScript called a do script command to trigger FileMaker Pro but FMP was already running a script? If bad things how what do I do to make sure FileMaker Pro is idle before I tell it to run a script?

How can I make sure my Database is open before I try to access it via AppleScript? And if my FileMaker Pro client loses its connection with the FileMaker Server, is there a way I can automatically dismiss the warning that appears and then have FMP try to reconnect?

I have a Filemaker script that sets a variable $tempvariable and then performs an Applescript. I would like to pass the value stored in $tempvariable to the Applescript -- something like tell application "Filemaker Pro" set thePassedValue to the variable "$tempvariable" end tell but this doesn't work. I know that I could accomplish essentially the same thing by using a global field instead of a variable, but using a variable seems conceptually more appropriate.

Is it possible to get movie infro from a quicktime movie into filemaker? For example, Size, Length Title and so on? Thanks Thomas

Let me start by saying that these applescripts worked last year before I moved to a newer Mac (both OSX). I have run these three scripts in the script editor, and they work fine. I'm thinking it may have something to do with permissions, but I can't remember. 1.tell application "FileMaker Pro" set chooseFile to cell "PathName" of current record of database "SRename.fp5" end tell tell application "Finder" set name of file chooseFile to "Rename.txt" end tell 2.do shell script "sudo chmod -R a+wr /Users/redcent/Sites/Documents/Rename.txt" password "******" with administrator privileges 3.tell application "FileMaker Pro" set newName to cell…

I'm having difficulty setting a variable to the contents of a field in a calculated AppleScript. Any help would be appreciated. Following the mess I have now. The actual script won't be doing "display dialog"; I'm simply trying to get the variable set for now. Part of the escape and quote code was set by FileMaker after using: """" "set theThing to " & "" & myTable::myField & "" & ""¶ display dialog theThing" Ken

Hi I am selecting a list of files which I want to put into filemaker eg set the_files to (choose file with prompt "xxx" with multiple selections allowed without invisibles) set file_names to {} repeat with each_file in the_files copy name of (info for each_file) to end of file_names end repeat return file_names tell application "FileMaker Pro" to set cell "global" of current record to file_names this doesnt add anything to filemaker Ultimately I want one file per record. I figure it is probably easiest to dump the full list into a global then separate into the new records with a calculation script. Maybe there is a more direct way…

Hello I am a newbie that has made a very silly mistake and is hoping to get around it. In a photo db I created sometime ago, I have numerous containers in a sheet that contain low res pix that I have imported. Over time this db has become far larger than first designed so I am looking for a way to get FM to automatically look at each container contents name i.e. photo and search my HD for the original before replacing the FM container with the file location. In short: 1. Establish the file name in the container 2. search the HD for the file 3. If a dupe found, ask what to do. 3. If not, replace the container contents with the file location. Writing it l…

Please can anyone help! I've written a script which works fine when performed on a database opened on the machine hosting it. But when the same database is opened from another computer using 'open remote' the script stops at the 'set cellvalue of field to "blaa" line with an error stating 'Object not found'. Is there an issue with running scripts via "open remote" if so is there a way around this problem as it is very important that I get this sorted. The problem section of the script is: tell (create new record) set cellValue of field "Number" to ResultNumber end tell As I said the script works fine unless the database is "open remote"…

I am a beginner, working from a business user stand point, but a former programmer. I work for a 4 person contracting company that is keeping track of prices in an Excel spreadsheet in a Mac environment. Based on what I have seen in FM, it looks like we should be able to access data from a database so as prices change, those updates can be pulled from a central source. Is that correct? If so, please direct me to some documentation on where to start. Thanks, Mark

Hi folks, I need a bit of help with this one, its got me stumpted. PROBLEM OUTLINE: I need an applescript / or possibly an automator script or combination of both to perform housekeeping functions, essentially getting a list of JPG names from a csv / txt file and finding them from a folder called 'images' on a windows volume and then deleting them. The csv / text file will be created by filemaker and I have control over the structure of the file if this helps. My aim, once this script works will be to attach it to a folder as a folder action essentially creating a "hot-folder" and I will have filemaker write the csv / text file into the folder. …

Hello, I've never used applescript. I want to be aple to copy an email, in Mail into a field in a database, where I could then parse it [once I figure that out] In fact, even some script to simply select all the email data and copy to the clipboard would be great, then I could just paste it Any wizards here who could please tell me how to do this? Thanks

I just installed some new Automator actions from FMP. One of them is to export data. My automator steps are this: Goto Layout (in FMP) Get Record Data (this is the export) Format Record Data New Folder (this is a Finder action) The Workflow seems to run - but no data is put into my new folder that is created. Thanks for any advice. CS

How (using FM8.5 on MacOSX 10.4) can I most speedily get a file written to disc containing the contents of one or more FM fields, with a filename (and preferably path) taken from fields in the same record? The full Applescript would be much appreciated, as I know less about AS than about FM http://fmforums.com/forum/skins/Crisp/icons/wink.gif Is Applescript the best (or indeed only) way to achieve this?

I've been experimenting with: http://www.briandunning.com/cf/194 ...and fail to see how the required single ' in osascript'ing gets into the CF. There must be something perverted by my webbrowser?? When we're at it ...is it worth trying to audit track to get every change in a field mirrored into the Address Book this way. It feels like feeding a dinosaur when usually dealing with relational approaches?? Anyway the client is so in love with the Address Book ...I would try do something similar the opposite direction by monitoring changes to the file behind the Address Book, since you apparently can single out modified records via applescript. --sd

Hi, I have a script which attempts to grab the content of an email message from Apple Mail and insert it into a text field. The problem is that Filemaker strips out all the carriage returns and paragraph breaks etc from the email contents, resulting in one big unreadable lump of text. Copying/pasting from Apple Mail into the field does preserve the formatting. Does anyone know of a technique to preserve this information?

This is apparently a big bug in the implementation of "Native AppleScript" in ScriptMaker. Consider this short loop that accepts a list of files in a folder. (The third command is a FMP 8.5 dialog that displays the value of MyGlobalField.) repeat with currentFile in fileList tell application "FileMaker Pro Advanced" display dialog "currentFile is " & POSIX path of (currentFile as string) set cell "MyGlobalField" to POSIX path of (currentFile as string) do script "Display Dialog" end tell end repeat When this is run as an external script, it works perfectly. However, when it is run as a native AppleScript (inside FileMaker), it misbehaves. …

I have an applescript that extracts some file info from a file, and sets a variable with it. Now I want to enter that variable value into a filemaker field. How can I do this?? Here's the code: set this_file to choose file try tell application "Image Events" launch -- open the image file set this_image to open this_file -- extract the property value copy the dimensions of this_image to {xres, yres} copy the name of this_file to originalname -- purge the open image data close this_image end tell display dialog "The file " & (originalname as string) & " Resolution is " & (((xres as string) & " by " & y…

Hi! Can someone explain Sent Event script step to me? In help is brief explanation. What I want to do is open FileMaker runtime application ( I figured out how ), but how can I then perform a script? AppleScript works fine but is there alternative on windows with send event and do script? Can you give me few starting tips please? Thanks Dejan

i'd like to have the external volumes that refrenced files are stored on open and mount when a user opens the database remotely.

Greetings, I am trying to run an Applescript from within FM8 to create a folder on our server "automatically" with the name of the applicant so that we can add related documents to it. The folder gets created, but I can't figure out the syntax for making FM feed in the applicant data for the folder name. Can anyone give me a hand? Applescript: ------------------------ tell application "Finder" activate select Finder window 1 select Finder window 1 set target of Finder window 1 to disk "Groups" select Finder window 1 select Finder window 1 set target of Finder window 1 to folder "Applicant Group" of disk "Groups" clean up Finder window …

Hello All, We have a new client that will emailing us a text file that needs to be imported into our database on a daily basis. I can get the file imported automatically using the automator plugin with filemaker, but I hav no way of automatically downloading the attachment from the email. If there is an applescript that someone could come up with, that would save me ALOT of time. Thanks in Advance.

Does anyone have an apple script that sends contact data from filemaker to os x address book? Name, phone number, address, email, etc I am mostly ignorant of applescript, but after looking over a jim crack of a script for exporting events from filemaker to calendar, I think I can swing it if I just had an outline to go from.

How would it be possible to get info from a application like Final Cut! A apple script that opens FC and retrieves clip times! I'm sure not to many have FC here so maybe there is a different apple app we could use as sample! Thanks TMAS

Hi, Filemaker inc. just insulted our intelligence and despissed our time by wrongly labelling the class "tables" as tables while it returns the Table occurence. how can I get just the tables ? I need just the tables. I've spent 5 hours to do a solution, and all was nice till that "bug" ruined it.

I'm currently working on a kiosk database to be used on a couple of new iMacs that will have a review section for people who visit the kiosks to add their comments to. I thought it might be fun to incorporate the reviewers picture as well into the review through using the iMacs camera. Has anyone incorporated this into their solution yet? jon

I just need to know if the following is possible with FM 8 or 8.5 (at work, we are still running version 6!) We have a database which displays multiple records per person, in portals. By hand, I have exported this information into a tab-separated text file, imported it into Excel, and constructed a fairly complex graph based on it. Now my boss wants me to find a way to automate this process so that a novice could do it, relatively quickly, for hundreds of records. I can buy the latest version of Filemaker if this will help us accomplish the task. Is FM v.8 more powerful than v.6 for this kind of thing? So, can I script not only the export of certain fields, but …

Try as I might, I cannot get an AppleScript application to run by launching it through the Perform AppleScript script step. Correction: It launches, appears briefly in the Dock, quits gracefully, with no error from AppleScript or from FileMaker 8. But it never does anything. I know it works, because when I launch the very same applet by double-clicking it in the Finder, it runs just beautifully. It will "tell" Finder to have the user select a folder, then it walks that folder, and will "tell" FileMaker to process each file in the folder. FileMaker inserts data correctly. However, in the Perform AppleScript script step, I have tried to name the file in a cal…

Hi, I need help about Filemaker Server 7 automation. I need a create an AppleScript about: Tell application "Filemaker Server" close database "xxx" end tell Tell application "Filemaker Server" open database "xxx" end tell I don´t know how it is possible. Is Filemaker Server Admin scriptable? Thanks

FMP8 returns the error "Object not found" for every variation of this simple AppleScript: tell application "FileMaker Pro Advanced" set MyText to "Cryptonomicon" set data cell "Book" of current record to MyText end tell The current table is named "Global", and the current record contains the global field "Book". I've tried "Global:Book" and everything I can think of, but get the same error no matter what. Any ideas?

Hi I can get cell info as per follows; "set transmittal_name to cell "FIELDNAME" of current record as string" but can I get it to a related record? I tried "set transmittal_name to cell "FIELDNAME" of current record of(fmnet:/IPaddress/relatedfile.fp7) as string but no dice. thanks for any help cheers

Does anyone know how I could set up to retrive zips from a website? I have addresses in a database, but no zip codes, I would like to be able to automate going to the usps.com site, where you can enter an address and get the zip code. I have thousands that need done and doing them by hand will take forever. Is there a way to set this up? I have seen where you can do a similar thing with maps, entering data and it will retrive the map from a web site. Any help would be appreciated.

I have searched the web and not found a solution for this. Does anyone know of a way to trigger an AppleScript from PHP? If so, could you please reply with the code. and the procedure. Thanks in advance - Sam

Hey There - I have an apple script: set TextOfFile to read choose file with prompt "Choose file to import." Set file_path to "(I have a FilePath here)" open for access file file_path with write permission write TextOfFile to file file_path close access file file_path It works perfectly when I run it through the Applescript editor, but in FM, after I enter it as a native Applescript, it says: Expected End of line, etc. but found identifier. and then it highlights TextofFile in the "Write" line. Help? I attempted to create a calculated applescript too, but when I ran the FM script, the same message popped up. Thanks in advance!

I need a script for the export function that searches the hard drive for the original of a refrenced image and puts a copy of the image on the desk top of the person who clicked export. please? I am not very good with computers and I don't know how to write scripts but I have a workign database that I need to speed up by refrencing images instead of embedding them directly into the container. However if i refrence them the people who search the database are not able to just quickly export the images they need. -sarah

I was wondering if it is possible to show the names of folders in a particular folder. I can get the names of the folders but dont know how to extract them do shell script "ls /Volumes/apple seed160/ work" The ideal solution would for the list to become available as a valuelist. If that is too tricky a suitable option may be to just see the list or add it to a field. Thanks

I need to do a Find function on my db. I've just switched to v8 from v6 : and when I script my find, it does not find "only" the criteria I just entered, it "keeps" the previously found records as well. What am I missing? [color:blue]set [color:green]BookCode to "00113" tell application "FileMaker Pro" tell database "BookRunPrinter_" do script "show_all" delete every request create request with data [color:green]BookCode find end tell end tell

Hi all, new to FM and needing some help... Our FM server does a backup nightly and we want to change the name of the backup files/folders to reflect the date of the backup so that we create an archive of backups on the hard disk it backs up to. E.g. files become named "2004-10-19-backup" instead of "backup of database." It is running on OS 9 and so I think there is an Applescript that could do this but I'm new to Apple administration and need some help. If anyone has any advice or what the script should look like (I am new to applescripts too) that would be greatly appreciated. Thanks, John

Can i with applescript get all data out of a portal in Filemaker. // Jocke

Hello all, I'm putting together a similar Applescript using the getURL command from the previous topic. I'm using this syntax: getURL "FMP7://[username]:[password]@[iP Address]/[Database name]" The problem I'm having is that our database does not require a username. So if I run this command: getURL "FMP7://:[email protected]/database.fp7" It brings me directly to a login screen and doesn't login automatically for me. If I try any username other than a blank it won't let me login. Does anyone know how to pass a blank username in the url?

Hi, I'm trying to do the following (using FM8) At a specific time (say 3:00 am).. Open Filemaker Client on a local machine... Log on the Filemaker Server (with specific user/password)... Run a script... Wait until script is finished... Quit Filemaker client. Does anyone know what the applescript code for that is... Thanks a lot, Michael Reade

We seem to run into a bit of problems with Date and Times. We use calculations to determine the time a job has spent in our plants. It is a simple calculation. Plant Out Date - Plant In Date. This also affects our SQL upload because the records are found by the last time uploading was ran and the record modification date/time. However when power goes out at a plant the clocks for the computer get set to the Mac 1/1/1907 time. We thought we could correct the issue by setting all the Clocks to Set Automatically in System Prefences. It does great so far. However it seems that it takes a while for the clock to realize the date is wrong and then correct itself.…

I am having problems retrieving values from a table unless I am displaying a layout in FileMaker containing the fields (or table - I am not sure which...) For example, when I have a table containing the following records: Table: Manuals ManualID ManualName Language 0001 First manual EN 0002 Second manual EN 0003 First manual DE 0004 Second manual DE and I want to get every manual with Language="EN", I use the following AppleScript to get the IDs (not the ManualID) of those records: --Get a reference to the table I am using tell application "FileMaker Pro" to set manualTable to (first table where n…

I just read a post about this dating back to 2002. It stated that I should have an applescript that looks like the following tell application "Finder" activate reveal filepath end tell I have a field that has the filepath, e.g. Powerbook/Users/jeffbills/Filemaker Info & Packages/FILEMAKER DOCS/ FMUG SACFM Directions.pdf How do I insert this filepath into the 'reveal filepath' step in applescript? I've tried using a variable but everytime I use the "$" symbol I get an error message Thanks

I have a solution that needs regular maintenance scripts to run. I have one that prints records to a calendar and others that update records in other ways. I need these scripts to run over night because some take several minutes or even hours to run. I have FMS8 and have put an applescript (one that just opens a webpage for this test) in the scripts folder to test the Schedules function. When I right click and say run now nothing happens. After leaving it over night it said Disabled and I cant even test it. I am sure I am missing something here can someone clue me into what I am doing wrong? Thanks

Hi, I am newbie using Filemaker 6 server and have a schedule setup to backup our database every 2 hours. The problem is that the files are overwritten with each scheduled backup. There are no options in FM server that I can see to set it to use a unique folder for the backup, like with a date and time stamp. From reading a few threads on the forum I see lots of discussions about using apple script, I have not used this before being fairly new to Macs. is there an easy solution I am missing? Many Thanks

In File Maker Pro 7 (OS X) I would like that on creation of a new record a new folder will be created in a specified root directory. The folder would have to have the Student name of the record (it is a school db of students)Then inside this folder I would put scanned images of certificates, comendations,etc. The purpose of this is to be able to click on a button within a layout/table (Table of student info) called 'certificates' for example and it will bring up the scanned image or images that the folder contains. I hope you get what I am aiming to do. Is there a better way to do it? Any help would help, thanks. I am working on an A-level project so …

Hi all, I'm having a bit of a problem here with getting data into the correct DataBase. I have two DataBase Files open and I'm using the script below which states to use this DataBase "weather.fp5" but for some reason if the second DataBase is the front most window it tries to use that one. Any thoughts or work arounds? tell application "FileMaker" activate try activate database "Macintosh HD:Users:dalejmartin:Desktop:weather.fp5" on error open "Macintosh HD:Users:dalejmartin:Desktop:weather.fp5" end try set theRecord to create new record try Thanks, Dale

We have a server that is running FM Server. Additionally this server stores our current project folders, which are created by an Applescript from Filemaker. The script looks like this: [color:gray]tell application "FileMaker Pro" tell document "JobList" tell current record set JobNum to cell "JobNum" end tell end tell end tell tell application "Finder" activate make new folder at folder "Current Jobs" of folder "Public" of folder "server" of folder "Users" of startup disk with properties {name:JobNum} make new folder at folder JobNum of folder "Current Jobs" of folder "Public" of folder "server" of folder "Users" of s…

Hello all, i am trying to build a small database which enables the user to up or download pictures he stored inside of a container field to a specified ftp server directory. while i know there is a nice plugin which can probably do that, i hope i can make use of OSx internal ftp command, connected with applescript. Can anyone maybe give me a headstart on how to accomplish this? thanks a lot, overrider

I wrote a filemaker pro 7 database program for my wife's practice. I wanted to create backups of the database for each time she changed something. Ideally I would keep only the last 2 months of backups and delete the rest. Since you can only make a file "Database Copy.fp7" from within Filemaker pro 7, I thought I would write an Applescript that could be called from within filemaker. I would set filemaker pro to call a filemaker script at shut down that would first make a generic backup of the database "Database Copy.fp7" in a backup folder "clientbackups". Then the filemaker pro script would perform an applescript to rename the file with a date and timestamp. I would then…

Hi! I have the following problem: This Script works fine on a local database. If the same database is running on an Server (fm8v2), then the same filemaker client has on access to the record ids and got an error: tell application "FileMaker Pro Advanced" tell database "Programm_Import" show layout "Programme_zum_Einspielen" tell table "Programme_zum_Einspielen" set newrecord to create new record save set cell "Programmname" of newrecord to "test" end tell end tell end tell I have tested this on 2 different machines with the same result. Does anybody have a solution for this? best regards, karo.

Hi To All, I am using Indesign CS2 and Incatalog to dynamically update data from Filemaker. This all works fine. (Incatalog is a plugin for Indesign and works well) I am having trouble with an applescript that will work no problems from the editor. When I run it from within a calc field in FM 8 it seems to go into an endless loop. I then have to force quit Indesign CS2. Here are the two scripts that I want to run sequentially. The status is that both the fm DB and the Indesign target are open the second script fails in an endless loop. tell application "Adobe InDesign CS2" activate tell application "Finder" open file "Macintosh HD:Users:…

Does anyone know of an easy way to get Filemaker Pro 8 to integrate with Apple iCal. I also want it to go both ways so if I mark a task as "done" in iCal, it will also mark it as done in FMP? Thanks

Hi all, I've been trying all afternoon to get this to work but I'm finally ready to throw in the towel and ask for help on this one. Here's the scenario: I need to insert files into a container in FM, but they need to have their names changed before I insert them. I have all my fields and variables holding the correct info but I can't get the AppleScript to work, This is what I've got so far.. "Tell application " & Quote ( "Finder" ) & ¶ & "set name of file " & $filePath & " to " & $newFileName & ¶ & "end tell" $filePath is called out with colons, like "Mac:users:me:NameOfFile.pdf" $newFileName is cal…

Hello, I am having trouble with writting an AppleScript to click on a button on a webpage to download data. So far, this is what I have: tell application "System Events" if exists process "Export Window" then tell process "Export Window" delay 2 set frontmost to true click button "Download" end tell end if end tell Can anyone please help. Thanks, tdogolf

From within my FM app as part of a script, I do a 'Perform AppleScript' command. The AppleScript sets a variable, 'set x to 5', let's say. How can I then use the value of that x variable in the FM script that follows the 'Perform AppleScript'? Did a search in the forum on this topic, but did not quite find what I needed. Thanks.

I'm running a small office server that runs a few password-protected FMP7 databases (not using Server). I want to have a startup script automate opening these, so if the server needs to restart, someone doesn't have to be there to open the databases manually. I flipped through the FileMaker dictionary and found the syntax for "open", which seemed exactly what I want, and wrote the following: When I try to compile it, I get this, with the quote mark right before the password highlighted: I've tried other variations of this command, such as capitalization and "Password" and "Account" instead of the above plural versions (which oddly enough makes it…

I'm frustrated and baffled. I have a test DB with the following data: bar foo value 1 dog 77 2 dog 11 1 jim 33 1 dog 88 2 dog 99 This script works: show (every record whose cell "bar" = 1 and cell "foo" = "dog" ) correctly showing the values 77 and 88 This script works: show (every record whose cell "value" > 80 and cell "foo" = "dog") correctly showing the values 88 and 99 BUT, this script (adding a third criterion) fails horribly: show (every record whose cell "foo" = "dog" and cell "bar" = 1 and cell "value" > 80) showing the values 77 and 88. Repeated tests in this area show me…

I can't figure out how to get the data of a field of the current record. I want to store it and pass it on to another script. Here is my FM script that returns data from all of the a particular field in the database: tell application "FileMaker Pro" get data of field "Assets_title" as string end tell

Folks, I've got a Dymo LabelWriter Duo and I used the Mac SDK (which uses Applescript) for it to automate barcode printing using the Dymo app. The Dymo software will generate any barcode I need. I need to know how to pass or use the contents of one field in Filemaker as the data I want the Dymo software to barcode and print. Can I integrate this all into Filemaker? Also, how do you insert a hard return and text after the barcode? Below is my applescript: (* DYMO Label Software V7.0 SDK This example demonstrates how to print a barcode using the Tape Editor plug-in. *) tell application "DYMO Label" loadPlugin name "Tape Editor" op…

Hello, I am trying to get information out of a field on a specific layout of a database. I have tried go to layout "z" get data of cell "x" of current record set y to result it cant get the data of the cell... any help would be greatly appreciated. Thanks.

Hi. I've got a database of IP addresses with two tables: Table 1 - IP_Addr Table 2 - IP_Usage Table IP_Addr stores individual (and unique) IP addresses Table IP_Usage tracks the dates that I've seen this IP address in my email (I get this data from an AppleScript in Entourage) I want to do the following steps in AS (and combination of FM scripts if needed) 1. take a new unknown IP address from Entourage 2. Test to see if it is already in Table 1 -- If no, then (1) add a new record in Table 1 with the IP address and add a new related record in Table 2 with the date -- If yes, then add a new related record with the date I've been s…

Well, let me start by saying that I know almost nothing of Applescript, but I wrote a little script based on different posts I've read. And I'm not surprised to find that it doesn't work. All I want it to do is have FileMaker open a pdf when the container is clicked based on the path field. I don't know what to do differently than what I have tried. Before the most recent attempt, it would just say "Object not Found", but now it pretens to do what I asked but really doesn't do anything. If anyone could give me a helpful push in the right direction, it would be extremely helpful and very much appreciated. Thank you! Amber employeeinfo.fp7.zip

I have a fairly long Calculated Applescript that runs inside a database. when a dialog pops up, it gives the user a message and the user's only option is to click the cancel button which brings the script to a halt. My question is why do I get two "Extra" dialog boxes after the initial Applescript dialog? Two from Filemaker. First: "User Cancelled" button OK Second: "Unknown error -128" button OK

Hello all At my workplace we have a new ups system and i'd like to ask if there is a way of executing the fmsadmin commands via terminal on mac but without manually having to do it i.e. via a script of somesort? ...so that when a powercut occurs, the server files close and shutdown safely and lessening the chance of file/data corruption. i hope this makes sense and that someone can help. Thanks in adv N

Hello all, I need to use the Caps Lock key to stop a loop in a script (using Status(CurrentModifierKeys)). In order to do this without leaving the user with Caps Lock "On" I was wanting to set Caps Lock "On" automatically at the beginning of the script. This way when the user uses Caps Lock to exit the loop, they are left with Caps Lock Off. I have looked far and wide for a way to achieve this using AppleScript but without success. It needs to work on both OS X and OS 9, though it can be 2 different scripts. Ideas anyone ? AppleScript ? Apple Event ? xCode ? Shell script ? Thanks to all cincin

Does anyone know how to run a FileMaker script from an AppleScript? I have an AppleScript that adds records to a FileMaker database and when it's finished creating the records I'd like it to run a script to clean up / process the record. Thanks, Hal

Hi! In FileMaker Pro 6 the following code user to work, but now in FileMaker Pro 8, it returns --> FileMaker Pro got an error: Event not handled tell application "FileMaker Pro" tell database "hiddenDatabase" --window must be shown? set kRecordMatch to ID of (every record whose cell "field" = "searchValue") end tell end tell If the database window is visible, the above script works as expected. Does anyone know of a workaround for this?

I have written an Applescript that passes variables from Filemaker Pro fields to Mail (eg. Subject, email address of recipient and Body text), ie. dynamically generated Applescript. Even though both Filemaker 7 and Mail applications are both Unicode compatible when I run the script the accented characters are no longer readable in Mail (some kind of undesired conversion has taken place). Are there any Applescript commands which ensures the character set remains Unicode?

Hello, FMP Dev 6.0v4, Mac OS 10.4.4 In my main solution I have a simple FMP script that preforms an AppleScript if Status(CurrentPlatform) = 1 or -1: tell application "Timer" open "Timer.clm" end tell Where "Timer" is a FMP 6.0v4 runtime file and "Timer.clm" is the related runtime FMP file with a custom extension. Basically this is meant to open the separate FMP runtime "Timer" from my main solution. It works perfectly before I turn my main solution into a runtime. Once the main solution is compiled however, the script returns the following error message: Where is the name of my main solution file. The "Timer" …

How do I get a count of records from a database? Thanks

I want to tell FM Server 5.5 to run a backup schedule called "Immediate Backup" using applescript. How??

I am trying to get all of the records from a database. this is the scrpit i am working on... tell application ... tell window .. get data of cell "#" of current record set x to result end tell tell window ... show show (every record whose cell "File number" contains x) end tell go to window ... tell window ... activate do script ... end tell end tell i have also tried get every record whose cell "File number" contains x nothing works... any help is much appreciated...

I have a variable defined in FM ScriptMaker. I then need to reference that FM variable as part of a native AppleScript step. Is this possible?

I have spent a total of about 8 hours trying to troubleshoot why a simple getURL command to open a remotely hosted Filemaker database when executed from within an idle loop will not function. What makes this so weird is that the same looping script functions perfectly with another database on the same host, and if I excerpt the script and run it as it's own script or applet, it works fine. I build the URL from variables and in the Event Log, the last event executed by the script that fails is the exact same syntax as the script outside the idle loop that works. Does anyone have any idea why this might be happening? Any direction on this would be greatly ap…

tell application "Filemaker Pro" tell window "Time" show show every record whose cell "Z" is x end tell end tell this fails to create a new found set of records in "Time", keeping in mind that the x sets correctly when requested from the current record of the related database any ideas?

I have a project where I need to import information from text files that contains lines and lines of 3 comma separated values. I used this thread to get most of the way there. Link to earlier thread but then the customer said that the filename of the text file needed to be included as well. After much thought I came up with this solution below. Feel free to comment on any clumsy code, or potential pitfalls. The script looks at an "in" folder, and works its way through the list of text files available. The text in the file is written to temporary file and at the end of each line the filename is added (to make a fourth field). The applescript launches a Filemak…

Here is the Applescript code run from within FileMaker that copies the CD info from iTunes and inserts it into FileMaker. However it no longer works with FileMaker 7 or 8. It only copies the first track and inserts that track and that is all. The layout used to insert the tracks is a layout with a Self Join relationship showing only the portal. I did not write the original AppleScript, I'm "almost" totally lost. But understand enough to fix this if I had the right direction. Can anyone tell me what needs to be done? on run clearProperties() tell application "iTunes" set thePlaylist to front window's view copy every track of thePlaylist to allTrack…

I've searched this forum but my search terms must be too vague. I'm copying onStyles from a Quark text string that will produce a list of at least one item but will have a variable number of elements in an list. I want to capture them all and use them as flags, but unsure how to capture it. Right now, I've set them into their own field with a try statement, but that's proving to be unworkable for flags in calculations. How would i set up a field to capture a list, and in AS, how would you set the field to the contents of that list? thanx, sam

When I use Apple's Script Editor I can run my little applescript without any problems. However I can't enter the same commands in filemaker's "Perform Applescript" script step because it gives me the following error: Expected end of line, etc. but found ")". Here are the applescript commands: set MyFile to open for access (path to desktop as text) & "Results.txt" with write permission write (the clipboard as text) to MyFile close access MyFile The script creates a text file on the desktop using the contents of the clipboard. Any ideas about why filemaker objects?

Hi all Has anyone written an applescript droplet to add a file to a container in field. I have created a database for distributing digital dictation files. Currently the users click an icon in the dock that runs an import script in the database. The users then navigate to the file and add it to the database. I was wondering if it was possible to use an applescript to get the filepath and then run the import script passing that information to the Filemaker script. Any idea? TIA Happy holidays. Drive Safely. Keep Safe. Regards S :

I'm trying to use Applescript to run a series of shell commands. I have encoutered a problem while creating the calculation, that will be sent as an Applescript. do shell script" & Quote( " chmod 770 " & Substitute ( Preferences::Path ; " "; "" ) & "Contacts") &" The problem comes with files and folders that contain spaces in their name " ". I'm using the Substitute Function, but the outcome is not what I'm expecting. Applescript needs "" two forward slashes to refecence spaces " ". But no matter what I input on the data that will substitute spaces, I never get the "" needed by the Applescript. "" returns "" "" gives me an error "" …

I am creating a standalone kiosk application that will run on a Mac mini. I need to create an [Exit] button that will exit the FM app and *also* automatically shut down the computer. Not sure how to go about this. Is there some sort of AppleScript commmand to shut down the computer? I am new to AppleScript, but I note that you can make AppleScript calls from within FM scripts...

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 r…

I got such a fast responce to my last post re calculating applescript I have now moved onto my next problem which must have been solved many times before but i cant find any referance to it. I want to be able to calculate the name i save a file as e.g I want to send a personalised fax to a list of my clients, I also want to be able to refer to this fax at a later date so i need to save it with a filename of clientname-todaysdate. Any ideas :???

i am trying to automate creating and saving a pdf file, switching from printer to apple internal modem and sending a fax to each recipient on my list. Creating the pdf is no problem but I cant get filemaker to accept my calculated Apple script. I know the script syntax works Ok as i can run it from terminal. When i paste the script into filemaker as a scipt this works, however when i try and calulate the script so i can change the recipients fax no it generates a -2740 error. List below is the working applescript and the calculation. I think the problem is centred round haveing to use quote in the calc. Applescript "do shell script lp -d Internal_Modem -o phone=015…