AppleScript & Automator

Hi All, Does anyone know the proper applescript sytnax to tell FileMaker 5 to open a database served up by FileMaker Server over TCP/IP? Thanks

I need to have my serial numbers update with a special designation at the beginning of a particular record. I have several categories of video tape that need to be put into a database. We would like the different types of tape to be designated with a certain code at the begining such as DV- for DV tapes and MINI- for MiniDV. I deally the client would like to be able to select the type of media either from a radio button or a pull down menu, at this point the serial numbering system would auto update the beginning designation to reflect the type of media selected.

APPLESCRIPT PROBLEM: I need to write an applescript to perform a multiple FIND on a Mac FMP5 database. For example: To show records whose field "Name" contains "A","B","K", or "N" (in manual FIND mode I would simply use Command N to add each new criteria) My starting point is: tell application "Filemaker Pro" show (every record in database "myDatabase" whose cell "Name" = "A") end tell This successfully shows the "A" record. Many tries later, I still can't find the correct language to extend the command to show all four records ("A","B","K","N"). It can't be that hard. Can someone please embarrass me? BobH

Ugh, why doesn't this work? I followed Chuck's advice and made the script like this: set the thatMove to cell "Episode" of layout 0 of current record of database "Library" set the inPoint to cell "TimeIn" of layout 0 of current record of database "Timecodes" but I still always get the first record in the database from "Timecodes" The only thing I can think of is that it does this because the "Timecodes" DB is in list view (although the call to the script comes from a particular record) - so I've made it switch to a normal layout before launching the AppleScript. Strangely, it doesn't seem to make the switch until after the AppleScript has run. Where am I going wrong…

I have inherited a project that's causing me a few problems. Here's what we're trying to do in a nutshell. 1. Post a form that causes a specifc record in an FMPro 5 database to update (i.e. change the data in some cells) 2. Run an applescript that opens another application, opens a document in that application, and updates the document based on the record changes in the database. Background The original version of this was done with CDML and a FileMaker script was run when the post was done, the FileMaker Script ran the AppleScript. This caused problems because when two Web users tried to run the Script simultaneously, everything ground to a halt ( a problem I saw …

how do i pull the month of the current date and get it as a number instead of text? is it possible?

Is anyone here familiar with Outlook Express scripting? Specifically, I'm interested in creating a message with a recipient, subject and attachment, and Outlook isn't recordable to any great extent, and the dictionary is just about useless. Thanks, Chuck

Okay, I solved the other QT problems I had, but this one has me puzzled. When I send a timecode to QT to launch a specific part of a movie, I can't seem to pull the correct record from FMPro. The script looks like this: set the thatMovie to cell "Episode" of layout 0 of database "Library" set the inPoint to cell "TimeIn" of layout 0 of database "Timecodes" ... tell "QuickTime Player" activate open file thatMovie set the current time of movie 1 to inPoint as number etc. What I always get is the first record in the list, even though the script is being run from a particular record. How do I pick a particular record? What am I missing?

I've got a DB which opens a QT movie and I want it snug up against the top-left corner of the screen - the rest of the screen is filled with two DB windows. I can't seem to get AppleScript to position it (at 0,0 or 1,1 ?) and the documentation isn't much help. Also - and this is probably the wrong place to ask, but I'm clutching at straws on a deadline - is it possible to make the movie open to a specific point (timewise), according to an item taken from a FM field?

Bob, Help! Maybe it's because it's a Friday afternoon and the sun is shining outside I can't get this or maybe the fact that AppleScript isn't my thing but . . . I have a number of error checking actions occuring within a try. On an error I have a simple dialog appear. If an error occurs, I'd like to simply quite the whole applescript and let the user do what they must to fix the problem. What syntax must I use? The current problem is the applescript continues and a subsequent error message may appear thus confusing the user as to what the actual problem is. Thanks in advance even if you have to tell me slap myself upside the head. Here's a section of the applesc…

Hi. I've got a little problem and I would be grateful if somebody could help me... I have a database called "Users.fp5" and it has a field called "TimeIn" which contains the last time that the user signed in on my website. I have a another field called "Signed" which indicates whether or not the user is signed "In" or "Out". I would like an applescript to make the field "Signed" to equal "Out" if there is more than a 4 hour difference between the "TimeIn" value and the current time. Since I'm planning to use this applescript as a method of automatically signing (timing) out users, then I would also like this applescript to work every hour. Can anyone help me? …

ok, i'm by no means an Applescript guru, but I did come up with this little dittie that I use in my FM database for creating an email that requires attachments. Here it is choose file with prompt "Choose an attachment" set oefileatt to result tell application "Outlook Express" activate make new outgoing message with properties

I'm attempting to create an applescript to set the name of a newly created pdf file from filemaker pro. Apparently "get data" won't use the variable name in parens. I'd like to know how to get a reference to that variable. Thanks

How do you create or edit a simple text document? .... Thanks. [ May 24, 2001: Message edited by: Krishan ]

I'm using: code: on idle set myDate to current date set currentTime to time of myDate tell application "FileMaker Pro" tell database "Users.fp5" do script "TimeIn" end tell end tell return (30 * minutes) end idle But.... The "on idle" and "end idle" commands stop my applescript from working. So I've tried using code: set myDate to current date set currentTime to time of myDate tell application "FileMaker Pro" tell database "Users.fp5" do script "TimeIn" end tell end tell return (30 * minutes) And my applescript works but the "return (30 * minutes)" command doesn't wo…

I have developed a snippet of AppleScript that I am calling from within a FileMaker script. The AppleScript checks to make sure that certain conditions are met regarding the configuration of the machine. I would like to be able to pass a boolean result back to the FileMaker script, which would then prompt the user accordingly. I know I *could* pass the info back to a field, etc. of the database I am opening (the script would run on open), but I don't wanna do that. Does anyone know an easy way to pass an AppleScript result back to the FileMaker script that contains it? Thanks in advance. ---- Obbie

Hi. I don't know any applescript but I would be extremely grateful if you could help me. I have a database called Users.fp5 with a field called "UserID". Do you know how to create an applescript which can automatically create a new folder everytime a new record is created in the Users.fp5? And each new folder is named the "UserID" of that particular new record. Thank you for your time.

Is it possible to specify a specific File Maker file or will applescript simply affect the current file. Instead of: tell application "FileMaker Pro" to do script "Send All Mail" could I do something like: tell application "FileMaker Pro" to do script "MemoLog.fp5:Send All Mail" Or something to that effect. Thanks

Hi I have little Applescript experience. The problem/requirement: Since upgrading to Filemaker server v5 I am experiencing a conflict between Retrospect (back-up software) and Filemaker server such that during the back-up procedure there is a loss of communication for any computers linking to the Filemaker server. I have tried changing the preferences in Filemaker but still get the problem. The back-up script is performed at 10pm every night. Retrospect automatically requests the next days backup tape after it has completed and it is this message that is sent to the front that I believe causes the Server communication problem. So what I'd ideally like the applescrip…

Happy to find forum. I am using FM 4.1 & have a large but simple flat db. Would really prefer to use the show statement within Applescript to make this find: show every record whose cell 4 = "apples" or cell 4 = "oranges" and cell 1 = " (what I need is the equivalent of !, the duplicate wildcard) " My question: can this be done?

I used to use applescript a long time ago where I did find results in Filemaker, and then wrote them to a text file on my desktop. I can't remember now how I did that now, but I seem to remember some commands such as, 'open for access' but it's been a long time. Does anyone have such a script(s)?

Ok I have the following script and it works fine if I am connecting via AppleTalk but what do I do if i want to connect via TCP/IP? code: tell application "Finder" copy (computer name) to cname mount volume "File Server" on server "ASIP server" as user name cname with password "password" end tell

Okay, so here's where I'm trying to go: We're trying out some ODBC connectivity overnight to some DBs that needs to run on a machine that has a forced restart in the middle of the night. The simple trick is to get the appropriate database open with ODBC connectivity on (which doesn't appear to default or remember once you close the database) without human interaction. I've banged my head a while with Applescript and now I'm looking for some help. Here's the questions: 1) Is there anyway to simply get the RADC to default to being "on" for a single database when it opens? 2) If not, the obvious choice (well, to me) would be to script turning it on. The trick there i…

I would use Applescript to transfer (cut and paste) the graphics directly from Filemaker to Photoshop (er... is Photoshop scriptable?) to do the cleanup and then have photoshop save the final file. Applescript could do the final file renaming if necessary. Filemaker has just enough Applescript capabilities to lure you into thinking that you can do anything without too much trouble. Then suddenly everything falls apart. I've had some trouble trying to manipulate any data that cannot be treated as text.

Is there anyway to get Filemaker to accept input from function keys? My natural response to this would be apple script but I am not sure how to go about it.

That is a question i would like answered if you know of them, but i couldn't find one in the last 7 min, so i figured i'd ask you guys if you know of any and go ahead and ask my non-FM-Related applescript question. DISCLAIMER: I know zero about applescripting, i usually just hit record, do what i need it to do and hit stop. I'm running a script that copies files from one drive to another, it will run every night (at 2:00 am). no prob there. But after the first run, it now stops with the dialog box "Would you like to overwrite, blah blah blah," message. When i do my trusty "record" action, it doesn't record me saying "yes, overwrite all them old files" it just sits …

Filemaker Server is scriptable but not recordable. That means that any actions you take inside FM Server won't record. So, you will have to manually write that part of your script yourself. I haven't personally written any Applescripts for FM Server, but I believe that the script should look like this: tell app "Filemaker Server" open database "filename" end tell You can create this with the Applescript Script Editor, and save it as an application which will run whenever you double click it. You can also create it as a Perform Applescript step in a Filemaker script, and then execute it from Filemaker. Hope this helps.

I'm wondering how to get data into filemaker other than text. Date objects in AppleScript are actually DateTime stamps containg both day and time data. There are easy way to seperate day, time, and the like, but I can't find a way to get that into a filemaker Date or Time Field. If I try to put data like "10/13/80" into a date field, I get an error. Any ideas? No, I don't want to create an extra calculation field, or global field... I just want to put this date into a date field. It's really frustrating.

It looks like you've set up your script to return a list of records to whatever called the script in the first place, rather than telling Filemaker to just find the records. If there a lot of records in the found set, that would explain the out of memory problem. I think what you really want to do is this: code: tell application "FileMaker Pro" delete every request create request set cell "DiscoveryId" of request 1 to "JEFF FOOTT.00001" find end tell or: code: tell application "FileMaker Pro" -- find all records show every record of database 1 -- find a group of records show (every record of database 1 whose …

I am creating a script that will select a series of records based on one field, and export selected fields to one text file (delimited) and all fields to another text file...I am just starting with it and am using the "get" method, and am getting memory errors (108), and cannot figure out why...any help??? tell application "FileMaker Pro" every cell of current record end tell also... tell application "FileMaker Pro" cell "Description" as text every record whose cell "DiscoveryId" = "JEFF FOOTT.00001" end tell

How do I use the run schedule command in AppleScript? I tried this to no avail... tell application "FileMaker Server" activate run schedule "test" end tell The schedule works if I ececute it myself so I know I have no errors in the setup. Any have any sugestions? Thanks, G

I'd like to save records in Filemaker (such as important faxes). I'd probably need an applescript to do this but I have absolutely no idea what I'm up against. I read the help files etc., and experimented around a bit, but I still find it difficult. Can anybody tell me how to accomplish this? Or is there another way to save single records anywhere else on my computer? ------------------ Yeti

You could AppleScript Program linking to FileMaker Pro 3 and 4 over the network, but FileMaker 5 doesn't come up as a linkable App. Does anyone know how to control Filemaker over the network? Or how to switch Program linking on for FileMaker 5

Anybody know how to turn on Web Companion via Applescript?

You could AppleScript Program linking to FileMaker Pro 3 and 4 over the network, but FileMaker 5 doesn't come up as a linkable App. Does anyone know how to control Filemaker over the network? Or how to switch Program linking on for FileMaker 5

I want to use single keys on the keyboard (probably the "z" to "?" row) to tally data points in various categories: "z", for example, might increase the numerical value of fieldone by 1, "x" might increase the value of fieldtwo, and so forth. Pressing the key has to do the whole job--pressing "return", for example, would make the process too inefficient. Is it possible for me to seize control of the keyboard in this way? Thanks.

Hi, I have a filemaker script to perform exporting data to a file and then open the exported file in another application. The problem is after I exported the file, how can I store the path to that file so I can pass it to another application via apple script? Thanks in advance for any help.

Anyone know the script to create a new folder usind a FM field as the name? Basically want to go to HardDriv/Clients/Projects and create a folder with our job number and description and then open in in the finder. Thanks in advace.

Does anyone know how to use AppleScript to get the Name of the Current Machine, and then copy it to the clipboard? I then want to run a FileMaker DoScript to paste it into a field. Is there a better way to do this? My second question is: is there a way to make sure that a an exported FMP tab-delimited text file is always saved into the user's startup disc preferences folder? Best Regards, Jeffrey Ellis

In version 4 of filemaker you could display a message via AS that would show a field value and a button choice, is that possible with 5 and how is it done. Cheers Coops [This message has been edited by Coops (edited January 09, 2001).]

I have a user in my office who need to do a complex Find in our very large databases using many related fields. This looks like it will take a lot of time. Simplified database setup: Database A contact ID, contact name, title & status Database B contact ID, event & year My script is as follows: I do a Find in Database B to find specific events & years. I then switch to a layout in Database B that has only the contact ID on it and perform a copy all records. I switch back to Database A and paste into a global field. I have a relationship set up between this global & the contact ID field of Database A. I perform a Go to Related record [show only rela…

I was wondering if any of you guys might know of a good online resource for scripting quark with applescript. Maybe a forum like this one but centered around applescript. Or maybe a book title specific to scripting quark. Any suggestions would be great, G

I'm trying to do something I've never seen done with FMP yet. I have a test database with two text fields and one container field. I created a standard "website" using the FileMaker Connection Assistant. Of course, it wouldn't let me put the container field into the "new.htm" file, but I did it in GoLive with a File Browser form control. As I expected, I got nothing at all in the container field when I actually ran the page with the Web Assistant. So, how do we get images from users, and load them into the container fields in our web-enabled databases? Do we have to do something REALLY esoteric like write an applet that handles the data stream and then moves the xferred…

i am using fmp as a picture database. on the database i saved the filename of the pictures . how can i autimat an import getting all the pics without doin it manually. something like get file 001.jpg (fieldname=001) thx s.

I'm trying to perform a find using applescript I want to find records from 30 days from todays date. I've got the following: on findOlderthan30(findType) ignoring application responses if findType = "Show" then tell application "FileMaker Pro" activate show (every record of database 1 whose cell "deudate" = "Today - 30") end tell end if end findOlderthan30 Today is ment to be todays date minus 30

is there a way to emulate holding down the option-button while choosing, for example, the print command (for faxing), using a button with applescript? this would be useful for solutions where the menu bar is not accessible with the current access privileges.

does anyone know a simple way to get a client copy of filemaker running as a server to click over to the next day after 12pm. If the only solution is to shut down and restart so that status(currentdate) can recalc then does anyone know how to get win98 to do that or have an applescript for it on the MacOS.(or can anyone write me the script cheap!)

How do you refer to a TCP/IP hosted database (on NT) in applescript? I have tried all sorts of combinations of brackets and file names but with no success. Conan Gorbey