Script Workspace and Script Triggers

I am trying to write a script to add 7 days to the current date by clicking a button and enter the new date in a specified field. all help is much appreciated. Running FM 5.5 PC Best Regards, a311shark

Is there a way to import Scripts built via a text editor, into FileMaker Pro for Windows. (just working with FM Pro for 3 days now and want more out of it)

I am trying to assign records in a seperate database with data from records in the first. The problem is that the script is only assigning the first record over and over again. How I have things set up is the first database (Statement Entry) is the data entry part where questions are assigned on one layout then the question text is automatically inserted into a seperate layout (magic!) where the responses to the questions are entered for each respondent. I have things set up so the records are one to each respondent. Each question has 3 factor fields where the user assigns a broad definition(s) to what the respondent said. The second database (Factor Assig…

I am need to get quotation marks to appear in the result of a InsertCalculatedResult. I am trying to do a find of a calculation. However, I need quotes around the whole calculation so that I only find the exact phrase. I've tried three quotes in a row, to try and get a single quote, but that doesn't work. For example the result I want is "15 OHM" ( with the quotes ) I'm using InsertCalculatedResult[select,"Description", "gOhms & " OHM" ") ( Where gOhms is a variable, in this case 15 ) But, the result is 15 OHM - ( without the quotes ) Is it possible to enter the ASCII character for a quotation mark ? If so, how ? Thank…

I want to make a script perform a calculation based on date fields. Example, an individual registers for a course on (date field 1). This individual's date of birth is (date field 2). Everyone who registers for this course must re-register annually within one year based on the aniversery of their birth date (date field 2). I want to make a script that will find each individual record that exceeds 365 days. Could anyone help me with this tough one?

I am trying to crate a script that will take the user to a specific field. If my Global field is set to status current field then I move out I want to be able to go back to that field by script. My problem is that I can only see a way to bring me to a specific field EG go to a set field given by the field chooser box and not go to field given by whatever is in the current field global. I hope that I have been able to make myself clear.

Hey, This is probably a stupid question, but here goes.... I have a script that I only want to run on the host machine. status(CurrentHostName) tells me who the current host is. But how do I know if a given computer is the host? Status(CurrentUserName) gives the name of the current user, but not the name of his or her computer, so this won't work. Do I have to parse it out from the status(CurrentFilePath) function? Thanks, Dan

How can I activate a VisualBasic script from within Filemaker?

Hello all, Running on Windows XP Pro. I'm using the Send Message["aevt", "odoc"] command to open another application -- QuickBooks in this case. If QuickBooks is already open, an error message results, though everything works ok. So, is there a way to close another application from FM? Alternatively, is there a way to determine if it is already running so that I can skip the Send Message step? I was thinking that I could use Send Message to run a DOS batch program that would kill QuickBooks, or maybe compile something from VB. Any thoughts or prior experience out there? Thanks, Dan

In FILE-A I have 2 fields and a button. Ideally, when I click the button, I'd like for it to look in a FILE-B for every record that matches the same as fields 1 & 2, and then spit it out in a report in FILE-A. How can I accomplish this and what scripts do I need to make? I'm new to scripting so I might need some help with that too... Any ideas? Thanks so much!

Hello, Is there a way to get a button showing in table view? (I know I've read about this somewhere here but I can't find it) Thanks for your help.

Is there any way to edit a Filemaker Script in something other that the ScriptMaker? I have a set of 9 fp6 files that make up a client database, calendar, etc. Needless to says it's very involved. I originally made the series of databases for one client. Unfortunately, they no longer have use of it, so now I'm trying to use it else where. The new customer wants to be able to have 6-10 clients files open at any one time. I'm assuming his processor and ram can handle it. Basically I'm creating a set of these 9 files for each one of their clients. But I made the file names slightly different for each client. For example, Client A has a set of files like AAA_…

i am trying to create a time tracking database. i need to assign specific codes per job and track the amount of time that was allocated to each job throughout the days. what i'm having a trouble with is creating a summarization field for a dynamically generated field. because there are hundreds of codes, i cannot create static fields of summarization for each code. i need a calculation to recognize similar codes and calculate a running total for each code. can anyone provide some insight please? cheers!

I would like windows 2000 to activate a script in Filemaker 5.5. Does someone know how to do it ? What should I use ? VBScript ? How ? Thanks. LVA

greetings all! I have little problem and I don't really know if it can be solved.... I have a computer (duh!) that is connect to 2 printers (let say and laser printer and a LABEL printer. One of my file maker document requires the Laser Print and the other the Label printer. question: Is there a way to script the change of printer without having to go into the page setup every time? I just find that everytime that I have to print out a label that I have to change the print setup or else it will print on the laser, and when I print out a label, I have to change it back to the laser.....grrrrr... HELP!! Learner

I'm making a script to import new records to a database and I want to assign an individual serial # to the batch - however, I want it to be incrementally assigned. For example - if I already have batches 2001 through 2004 assigned in the file, the next batch should be 2005. Can anyone help me with a script to do this?

Hi, I don't know where to begin with this.... I let my user make a selection of records based on name - from this selection he can check the records he needs; what I want to do then is copy the id-numbers of those records into repeating fields of one record in an other database.... I can run a summary on the amount of checkmarks he set so I know how many there are, but can I set the number of repeating fields upfront and then how do I fill those repeating fields?? If it's possible to set the repeating fields, then how do I run the (summary number) amount of times to fill the repeating field?: Is that possible? Any ideas? I'm using FM 5.0 by the way

Slowly I move to a different system. Now that I have it stable and working better than ever. grrrrrrr. Can you believe they are now going to make it part Java part .Net and part Cold Fusion??? I told them I would rather stick with just File Maker and upgrade to 6.0. No wonder it was such a mess when I took it on. Anyway, to the point. I am doing away with one whole database since it is moving to Cold Fusion. What I am looking for is a way to make it so that when a person would normally be sent to one of the layouts for that db they get sent to the new CF site instead. I'm sure this is easy to do, but I'm trying to decipher an intern's mess in SQL Server at…

I have a script that finds a set of records. I want to go through that set and increment a series of counters, based on ZIP Code. I wrote a script (simplified to one ZIP only) as follows: If ["ZIP Code = 90266"] Set Field ["Undup Count 90266", "Undup Count 90266+1"] Set Field ["Undup Count Non~BCHD", "Undup Count Not 90266+1"] Go to Record/Request/Page [Exit after last, Next] End If The script runs, but the fields I want to increment do not return a value. The selected set of records totals 39, of which I know 2 are ZIP 90266. I have tried putting the fields in the Body, Footer, and a Summary field, but none of that helps. Could someone tell me w…

I have a script that imports some records from a file but if no records happen to be imported a message is shown saying - No records were found - and the script and sub scripts should stop and go to the main file to the menu layout. I

I would like Filemaker to be able to copy a string from a field. open another program up. and then paste the string into a field in the program. Can this be done? For example: a user has a record with an associated filename. the user types the filename into a text field. THe use pushes a button that opens the scanning program. The program's screen asks for what filename to save it as. I want filemaker to automatically put the filename into that field, it may not be the first field, say it's the 3rd field. so you have to press [tab] 2 times to get to the filename field. Can this be done? Can Filemaker send windows commands between programs?

I'm sure this one is rudimentary, but I don't know it- In an address database, I'm including a button which loads the currently selected record to the Clipboard, so that it can be pasted into a formal letter as text. The address information is stored as discrete fields; I have an extra field [AddressCalc] which is a calculation, returning text, which simply lists the pertinent information, separated by line breaks. What I want is to tell the box to skip the line break if there is no information there. For example: I have two Address lines, since some addresses need E. Allan Poe 1313 Mockingbird Lane (-->) Road C, PH B Baltimore, MD 19999 Others…

I have a file called A. In it is a field called Target. I also have a file called B. In it is a field called Source. I make a script in file A: Copy [select,"B::Source"] Paste ["Target"] It asks me to create a relationship between A and B, for which I created some random field in both files. I must have not understood something, because it doesn't copy data from B::Source to A::Target. It copies nothing (and because of that of course pastes nothing). The clipboard never gets to get filled with the contents of field B::Source. If I create a Source field in A, it will copy and paste just fine. I ended up calling a script called Copy in file B fr…

I AM TRYING TO LEARN SCRIPTING. I HAVE A DATABASE WITH NAMES,ADDRESSES, ETC AND I WOULD LIKE TO HAVE A SCRIPT THAT WOULD GO TO THE NAME FIELD AND THEN ALLOW ME TO ENTER A NAME TO FIND. I HAVE TRIED --- GO TO FIELD["NAME"] -- PREFORM FIND[RESTORE,REPLACE FOUND SET] BUT IT DOES NOT ERASE THE NAME IN THE NAME FIELD SO I CAN ENTER A NAME TO FIND. COULD SOMEONE PLEASE HELP ME? THANKS LEARNING

Hi all, I'm trying to write a small script that checks if the content of a Date Field has a value that is two days over. Erm example Three records... and today's date is 12/4/03 12/2/03 12/6/03 12/4/03 I would want my script's If statement to accept 12/2/03. I hope that make sense, because I'm feeling quite funky today. Cheers, Steve Griff

I've got 5 repeating fields in a layout, each showing 30 repetitions. Using ScriptMaker, I want to create a script that will clear all 30 of the repetitions in one step, rather than doing Clear [select, "RepeatingField"-1] Clear [select, "RepeatingField"-2] Clear [select, "RepeatingField"-3] Clear [select, "RepeatingField"-4] through Clear [select, "RepeatingField"-30] for each of the fields. Can't figure out how. Any suggestions?

Post deleted by LUC.ROBITAILLE

I would like to create a script that would open a .doc file in a container field. Currently I am "right" clicking on the container and selecting Open Document. Thanks in advance.

Hi this is my first time posting on to the forum. The question may sound stupid. My case is I have a range of data entered daily and while viewing the report, they want it automated by just clicking the buttons without need to key in date range for this week. I have no problem creating for the week and months. For doing this also I have cracked lots of books and come out with it. I just couldn't get the Year done. Can anyone help me on this ? I have attached the file. date.zip

Is there anyway of assigning a file type to an existing container field? I have graphics but they don't have a file type so EXPORTFM won't touch them.

I would like to emulate the records counter on the staus bar w/o the bar. I've used Status (current found count) which shows me the correct found set of records. But if I use Status( current record number) it will only give me the proper record number of the found set in browse mode if all records are available. Fer instance, when I perform a find the total number of found records count is correct but the record number (1 of3, 2of3, etc. reflects the record number of the record in the "complete" record set. Any suggestions?

This really bugs me rotten and any help with earn +karma in enlightening me to what is endless suffering in trying to insert data into fields with scripts when in FIND MODE. I haven't worked out why but sometimes the 'set field' just wont work. So I end up using 'insert calculated result' or even copying the data (pre find mode)changing to a 'paste layout' I have in my database mid script just so I can get the data 'pasted' into a field. Why rhyme or reason is there to the 'set field' script in find mode. (salvation guaranteed or your money back ;-)

I am using FMPro 5.5 on a PC in case that matters. I have a relational DB that has many files but my question regard only 2 of them. The two files are connected by a serial number. I already have a button that executes a script that takes the user viewing a particular record to the related record in the related file. That much I have down. What I need is a script that would do this: --If there is already a related record in the related file, will take the user to view that record in the related file........ --If there is not yet a related record in the related file, will recognize that fact and go ahead and create a new record (with all of the accompanyin…

I'm writing a simple script to Find, Sort and Export data in HTML file format. The export file needs to stick with a naming convention that is a concatenation of a few of the fields in the database For example: the file name would look like this: Name_Company_Date My question is: How do I get the script to paste the string I create into the File name dialog in the "Exports Records to File" window?

Hi All, The problem: For various reasons, users are occasionally hitting the new record button in a database when there is already a new blank record. This leaves blank records scattered through out the database, which is causing some problems. The solution: instead of having the new record button linked to "New Record" use a script that will check for a blank record before creating a new one. This is what I've come up with so far: Go to Layout["Main"] Sort [Restore, No dialog] Go to Record/Request/Page [Last] If [isEmpty(FirstName & LastName) Exit Script End If New Record/request Is this the best way to handle the problem, or is …

folks, we have a db, that's feeded by several other (web-published) dbs (see my other posts for details, please). we'd like to set up a script that: 1. checks wethere there are any records, 2. if yes, picks up the oldest (by date changed), 3. executes a (sub-script, do applescript), 4. deletes the record. so finally we end up in an empty db, sooner or later .... background: we are feeding the seperate db with applescripts that takes lots of time to execute. by this feeding we avoid the web-connected db to wait for the result of the applescript. any help appreciated by: phonoguy.

Hi, I'm trying to automate the printing of job report by employees. Here is a description of what I have and what I have to do: I have a list of employees that are assign job. A job can be ongoing, done or cancelled, each job have a serial number. I have a report layout that shows (once you have done a Find by employees and ongoing) of the job for each employees. What I would like is a script that go through all the employee list and print out the report of ongoing job. Each employees need his on print out without seeing the job of other employees. I've been fiddling with things, but I can't seem to figure out the Set fields script with Perform and…

Hi, Is there any way for filemaker to run a script at exactly 12am or any other set time? Thanks

I'm lookink for a way of showing find results with a different field color. Or an alternative may be to have a different field color base on a radio value type ?? If it make any sense for anyone !

I have 2 databases related by constant throught the relationship "donor". One is a calander type database. What I am trying to do is this. Click on a date on the calander, this copies the date into a DateField in the calander db. Then through an OK button that performs a script, this date should be set in another field in the related db. My script looks like this, and I can not figure out what is going on. If[isEmpty(gNavigator)] Show Message [buttons: "OK","";Data: "No date is selected"] Else Set Field [Donor:ScheduledTowDate, gNavigator] End if Any ideas where I have gone wrong, or how I can get this to work? Thank you

Ok, I've got a script that runs, checks for new records, if new, determines a few things about the new record, then, if certain criteria are met, it fires off a series of scripts. Its basically a start at first record, loop and exit after last. The problem is, when it goes to the nested script and then finishes with it, it automatically starts off where it left off in the parent script. Ordinarily, this would be fine, but in this case, I would like it to start over with the whole script. If it goes to the very beginning of the loop, it performs infinitely. If it put nothing in it starts where it left off. is there a way to tell the parent script where to restart. Somethin…

First, I apologize if this has been asked recently, I seached the forum to no avail... Is there a way to trigger a script to run when a field changes? I would like to be able to trigger a script to run immediately after a user makes a choice from a pop-up menu, without requiring them to click a button. Is this possible? Thanks.

Hi, I don't know much about filemaker and need help creating a script. I want to create a report of current employees and their departments and phone numbers. I have created a layout that I want to show this information in. I have a field called 'current employee,' whose value is either 'yes' or 'no.' How do i create a script that only shows records that has a 'yes' for this value? thanks.

I have a series of "if" statements within a loop, I've tried a few combinations, but when I run the script, it either: 1. Stops when the criteria is not met and does not go on to the next if statements that follow (I need the script to check the other "if"'s). 2. It just checks the first "if" statement and does not even go on to the next statements... I've tried this: Loop If...... Print If..... Print End If End If Exit Loop I'v also tried this Loop If...... Print Else Refresh Window (Just to give it something to do so it goes on to the next If) If..... Print End If …

Hi, I've seen this script in action, but do not know how to create it. I want to add the same text information to a field in every record in a specified search. What I want to do is specify the field, have an empty box open into which I can type the text I want to add, hit go and have that text show in the same field on every record (without overwriting any existing text) Any ideas? Thanks.

I hope I'm in the right forum. I need to specify criteria before a report is run. For instance, if I want to look at all registration paid in a particular year, rather then have all registrations from all years run. Is it possible to create a message box that will prompt a user to enter a date range for the year they wish to retrieve?

Hello, I'm pretty new to Filemaker Scripting. I have created a database solution for affiliate marketers that I have compiled into a runtime solution. As I add features, my customers will need to upgrade the .USR file. Any idea how I could build an "Update to current version" script that would pull the records out of the old file and into the new one? I'm using FM 5 Developer. Thank you!

This is an incredible brain-bender for me ... so much so that I need to ask for help with the logic involved in the following: I have 10 records with a Number field, "sort_order", containing unique values sequentially from 1 to 10. The sort_order field is used to sort the records. Let's say I change the sort_order field in record 2 to "1" so that record 2 will sort first in the list. Obviously, in this case, record 1 will then have its sort_order set to "2". This works out to be a simple swap, as it would be if I changed any sort_order value to it's next higher or lower position. But, what if I want to change the sort_order field in record 4 to "7". In th…

Help! I can't figure out how to 1)check a check box and 2)change a value in a radio button field, using script steps. Thanks.

A user on another forum asked about how to create a random list of integers within the range of 1 to "N" . One way of doing this is to create the following fields: a "constant" field (indexed calculation of type Number with the value of 1) an indexed number field, "random number" a global number field for the user's "N" input ("g_desired record count") a global number field to temporarily hold the random integer ("gn1") and one relationship: "gn1" on the left side, "random number" on the right side The script then looks like this: New Record/Request Set Field [ random number, Int(Random* g_desired record count + 1) ] Loop Exit Lo…

I've worked and worked and worked on this but I can't figure out what's wrong. I'm a real newbie at scripts. All I know is that I've done everything I've been taught in this forum, but script misfires in one area. Specifically, it's the GO TO PAGE feature via the button on the Main interface (currently only in the "Misc" one). I've attached the working file so that the problem can be seen. A brief mention of the 2 types of data, there is "Misc" (Source "M") sourced and "Book" (Source "B") sourced data. When I enter a page # to go to while I'm in the Misc interface that has no corresponding entry under "Misc", if there is one for a book, it'll bring the book one …

Hi there, now i try to create my own database design report for some analysis work. I have done the basic function which checking all the database name, field name and also field type for all fm files which is open. Now i need to improve more function, i want it to display out the field details information such as which layout contain the field and which script using the field. I know that all this function can be done by fm design report, but i want to build my own for better control. Regards, Henry

Hi Everyone, I've been trying for ages and ages! The complicated bit is that i don't know what field it is that i'm trying to find out about ... i've got an array, and I'm wanting to go from field to field checking if it's empty. Cos the array is kinda large (20-30) I've set the script up as a loop, and got it going from field to field (using goto next field) checking if the field is empty (my problem!) - if it's not, the contents get copied out, and the field name gets copied into another field which all then get put into another data base. It's all working fine except the determination of whether the field is empty. I've been trying to use Status(…

Is there anybody know how to code/define/create an array (A1, A2, A3...)(or even 2 dimension array A11, A12, A13...) in a loop of a FM script ? Thanx

I have a script that is returning "no records found" even when it finds records. When I remove the steps with my message box it runs fine but doesn't tell the user if no records were found. I've attached it as a pdf. Can someone explain what step(s) are incorrect. CoachInfo.PDF

Hi, long time no write, I have a question, what's the best way to insert records into related file based on specific condition, something akin to a trigger in RDBMS. I want to attach this script to creating a new record that meets specific condition in FileA, and then insert a record with sp[ecific values into FileB. I want to do this without plug-ins, I'm aware that oAzium Events plug-in will do this. Thanks

I have application where I am exporting some data to a file (no dialog) and calling another script which imports the data into another special database used for printing. Since moving to OSX we have had problems with not being able to export the file on some users computers. I get errors sometimes where it says it can't open (the export) file. Is there a better way of doing this? Since the file is being served, the file is being exported to the computer running filemakersever, I assume that is part of the problem.

I'm trying to automate the process of extracting email addresses out of a text field. I have acheived this by locating the '@' and then working backwards and forwards of this to extract the address depending on whether there are spaces or carraige returns (or a combination) before and after the address. The problem I am having is that sometimes there may be tabs either before or after (or both) the address which is causing extra data to be extracted. How can I check to see if this is so - or am I complicating the whole procedure....God I'm confused! Cheers Nick

I am new to the forum and have little experience with FM. I paid a co-worker at the time to create an operating system for my little home business. Now that I am having problems with the database, he has since moved with no additional contact information. Here is my problem. He built a purchase order DB where I create all of my new purchase orders. I use CTRL N to creat a new file and it has worked fine until now. There was a problem with the DB so I had to import a backup of existing records from a file created some time ago. I was currently on PO # 1103. Now after the import, although I show that I am on PO # 1103, when I try to create a new PO it automatically st…

Hello Everyone, I'm only new and using FM6 (Windows), I have designed a small database which I need to do the following: On the left hand side my portal diplays a company name without repeating the same name. EG: Jeffe Incorporated Luke Enterprises Fashion Australia And on the right hand side I need to be able to diplay another portal that will display mobile phone numbers for example when I click on "jeffe Incorporated" it will display something like this.... Jeffe Incorporated 0411111111 0422222222 0433333333 0444444444 0455555555 At the same time if I want to …

Is it possible to change a feilds colour within a script ie if feild "x" = "in progress" then i want feild "b" to change it's back ground colour to green thanks, Bill

I need to store movie references in a container field, and then show the movies in the web using webcompanion. Reading the forums I found that storing the movies path is the only way that ables me to show the movie in the web browser. But, I din't find a way to select a movie and store it's path in the database at the same time. If I could access directly the path stored in the container with cdml would be great, but as I already said I have no hopes on that. Can anyone help me? Thanks

Hi all, I am about to start on deduping a database of about 10,000 contacts and 9,000 odd companies. I would like to be able to create a separate database to track which ones i delete change etc. Can anyone point me in the right direction? Thanks in advance Simon ----- [email protected]

Hi there, just want to know how to capture all the prime number between a range and then store the result into a field. Regards, Henry

I am using a script, in the master file, to duplicate a set of records in a sub file to another record in the master file. Because I don't always want all of the records to be duplicated, I use a toggle (Toggle_1) to select the duplicate items. The master script finds the related records, via Go To Related Record [show only related records], then calls a sub-script in the sub file to set all items to duplicate (Toggle_1 = 1). The user then has the option, via a portal, to remove the unwanted items. This part works fine. The master script then calls a second sub-script to duplicate the remaining records. The problem is that in the set of duplicate items some …

I have inherited 2500+ files and need to place a unique ID# in each. I have created the ID# field and just need a looping script that will place an ID# number + 1 in each successive record. Is there a way? Thanks.

My database has several records with duplicate values for one field. I need to find the unique value for that one field and Delete All others. Example: I have a PO # 1234 for Record #1, PO # 1234 for Record #2 and PO # 1234 for Record #3. My goal is to find PO # 1234 and Delete All the other PO # 1234s. The catch: I have several different PO #s that are duplicates, ultimately I need to get one unique set of PO #s. Any tips or pointers would be greatly appreciated, thanks in advance.

Hi, Can you help me with this? I have 2 related databases. One is called "Contacts" and the other is called "Activity Log" I have a portal set up to show multiple past activities from the activity log for each contact and I have it set to allow creation of related records. Here is what I need to accomplish: I need to be able to do a "Find" for a set of contacts in the "Contacts" database and then create a new record through the portal in the "Activity Log" with the exact same data in the exact same fields for each contact found. There are only 4 fields shown in the portal. "Date", "Time", "Regarding", and "Artist" Right now I do a find for all necess…

I have a printing script that takes a user to a print layout in preview mode and pauses to allow them to make sure everything is correct. If they hit the cancel button, I want to redirect them to a certain layout. How can I capture the cancel button being pushed? I tried doing Status(CurrentError) but that did not work or maybe I was looking for the wrong status. Any help would be appreciated! Thanks, John

I have a database with 5400 records made up of about 700 students. The file was designed so a new record was created each time a student took a different class. I need to pull out a set of records that are just one record for each individual student. I have an ID field that is a unique identifier, but I'm not sure how to write a script that will compare the ID Field in record 1 with the ID field in record two and if the records match delete the record then repeat and if not go to the next record. I may have records 1 through 4 be duplicates then 5 through 11 be duplicates. I'd like to automatically compare and delete 1 - 3, see that 4 does not equal 5 so it is not …

Hi All, Could we run an external script without going to that file? what i mean that i run an external script (file : from file A without going to file B? Since everytime i run an external script it leads me to another file Thanks Anh Tran

Perhaps I just don't get it but what happens after the Dial phone script step is executed? Can one dial a fax number and then send a fax or is it for dialing up to a ISP or what? The Mad Jammer And then...there was nothing

I am publishing my filemaker database as a webpage, but I find that my navigation buttons no longer work along with the buttons attached to "send mail" scripts. Are there web specific scripts that I need to be using or do these functions not work for web based databases? --magilla

i've a script that performs a find/replace... using the values stored in two globals: gFind and gReplace. the find/repl is performed on every record in the current found set on only one field. It works ok, but sometimes 1 record is left out from the find/replace... operation. In other words it does the find/replace on all records in the found set except one.: when this happens, that record is selected and the cursor is in the field. Any idea? Thanks!

Hello, Is it possible to automate the selection of the Remote Data Access Companion sharing option as part of a file startup script? My goal is to open a FileMaker database from a remote machine, transfer data, and close the database, all as part of a SQL DTS process, and of course the data transfer won't work unless that sharing option is enabled. Thanks in advance for your help. Aaron

Forgive me if this has been answered before. I'm trying to write a script that will send out a mass email to a found set within my database. I want individual emails, not one email with everyone's address in the To: field. Right now, I have it set up where I can click my email button, have the email sent over to Eudora (without dialog), and then jump to the next record. So, if I want to send the email to 93 people, I'm clicking the button 93 times. Last night, I thought of looping the Send Mail script and this is what I came up with: Loop Send Mail (no dialog, "Subject of Mass Email") Go to Layout (First Page) Go to Record (next, exi…

Hello everyone. I'm trying to write a simple Find script that asks for two dates (start and finish), then automatically finds all records within that date range. I'm not sure what I'm doing wrong, but this seems like it should be simple??? I'm using the Custom Dialogue script step in FMP6 and having the dates stored temporarily in two global fields (date_from and date_to). I then attempted to have FM create a Find Request and insert: date_from & "..." & date_to ...into my date field for the search. While FM doesn't complain about this script step, when run, it only inserts the first date. What am I doing wrong? Thanks! -Rob

I would like to create a number field that would have a number range from 0000 to 9999. The highest number would be 9999 after reaching it, the field would go back to 0000. I also want to have a script that would allow me to increase and decrease the number on that field by 1, taking into consideration that if the field has the number 0000 and I use the script to decrease that number it would have to go to 9999. thanks in advance.

I have a script (Script A) in a Master file that calls a sub-script (Sub-Script in the Sub file. Sub-Script B calls another sub-script (Sub-Scipt C) in the same sub file. If I run Sub-Script B in it's own file it works flawlessly. When I call it with Script A it skips over the Preview Mode function and performs the Show Message function in the Browse Mode of the Master file. - If I add a halt script after the Preview Mode function it will halt as requested in the Preview Mode of the Sub file. - If I add a beep after the Preview Mode it will "beep" and display the Show Message function in the Browse Mode of the Master file. - If I add a Pause/Resume Script …

My order processing system ( FM Server, FM 6.0, Windows 2000, 10 users ) uses the following method of order ID allocation. All record IDs are held in a single record 'parameters' file. When a new order is raised, Cusomer ID and basic order details are recorded in global fields in the order file. When ready to create the order, a script creates a new record in the orders file, turns global values into record values, sets the Order ID from a master relationship to the parameters file and immediately increments the Order ID in the parameters file by 1. This method is tried and tested in another system that I wrote, but in this particular system, I have had duplicat…

I have a script to open a file, but it doesn't work. I'm sure the file is closed, and I'm sure it's the correct version in the correct folder. Any suggestions? Thanks

I have a network of Macs running OS9 with Filemaker Pro 6, networked using TCP/IP. One of the Macs is always started first, and provides a set of hosted databases. All the users log on by running a small FMP database on their Mac which contains a start-up script which contains an OPEN FILE step, which opens the menu file in the hosted datafiles. After this open step is completed, the file closes itself down, leaving the menu file loaded from the host running. Each user does this once, perhaps twice a day to get started with the database. This works OK most of the time, but once a month they call me to say that the local file doesn't work any more. Invariably when I l…

I have been trying to think and do about making filemaker to Word. But it seems to me that I can not find a way to solve it. What I plan to do is to make a script to export some data to Word or all data to Word when usert click a button like in C++, can it be done in filemaker? I really need help for this topic. Someone has an idea about it? Thanks Anh Tran

I wanto t create a script that open all the files on my database. It will be triggered when opening a database called default. I tried creating a script but it pops the files on the screen while opening the them, it looks very unprofessinal. Is there a way to lock the user on a layout while the files are being opened so that he doesn

I've just moved my FM database from Windows 98 to a new computer using XP. None of my "Send Mail" scripts work (with any record). Do I need to assign FM to talk to Outlook in some "properties" tab somewhere? Thanks!

Hey all... In our invoincing system i would like to create a inventory type system that will auto update when an item is entered into a PO. Here is the main components: Pricing DB: holds all items, will be the base of the Inv. solution. PO DB: holds all the basic PO info. PO Backend DB: A portal that stores the line items for each PO. Conditional Value Lists relate to the pricing module. INV Add: keeps track of the additions INV Remove: keeps trak of the removals Items within POs will sometimes need to be removed from the inventory (customer order) or added to the inventory (stock refurbished). I didnt originally have a unique id for each PO line i…

Here is the situation: I work in a school. We are trying to create a database to store our daily announcement list. Each record has a start date fiedl and an end date field. We would like to write a script that will select a group of records examining each record to see if the current date falls between the start date and end date values. Once it has selected the group of records, we want it to switch to a different layout and display the records. Here is the one sticky point: The database will be hosted on a Filemaker Server, and the documentation we have found so far, says that in order for it to get the current date, the database must be closed and then …

I'll try to explain the situation. My solution was made to edit, maintain, add information to digital price lists (I'm in the wholesale business) It is made of a client side (one fm file on the user pc) and a server side (some files on the server). The basic idea is this: the server stores a lot of price lists, every edition from each supplier. The user "download" from the server the price list he have to work on, work on it locally and then "upload" the single price list into the server repository. The download is easy, just an "Import records" from the server file. However I cant use "Import" for the upload because the client fm file may be anyw…

I have two databases that are related to each other through a calculation field set to the value of 1 on both databases. When a user pushes a button on database "A" the following occurs: - A external script on Database "B" is triggered to create a new record on database "B". - Information from Database "A" is inserted on Database "B". - The user is sent to Database "C". The problem is that this routine occurs around 1000+ times a day, most of the time it works fine but sometimes, without a reason, when the user pushes the button on Database "A" the record on Database "B" is not created and the scripts jumps straight to the Database "C". I wanted t…

I am trying to create 1 script and attach it to a button that does this: In a found set of 2 records, depending on the contents of the field "Purchase #", this script needs to print the appropriate layout. If "Purchase #" is empty print layout 1, if "Purchase #" is not empty, print layout #2...that's it. I would like to do with with as little user interaction as necessary. Basically hit the button, and maybe OK to print and thats it. Similarly, if there are 10 records in the found set, I need it to print the appropriate layout. Any ideas? Thank you.

Hello I would like to find a way to script a bit of text to change color within a string. The 5th 6th and 7th characters of a string. 123456789 567 so I can make 567 ReD is this possible Thanks Dave [color:"red"] [color:"red"]

Hi there, if i want to calculate a total of a series of value in a text field, how can i do it. Just like if a text field contain ( 2 5 7 2) then the result will become 16. The value are normally in seperate line. Like 2 5 7 2 Regards, Henry

I think I

Hello all! I need to create a calculation or script that will accomplish the following: I have a TimeSheet file with fields Activity, Time, and Project ID. The TimeSheet file has multiple entries relating to the same Project ID, and there are multiple instances of each Activity for each Project ID. I need to find all instances of each Activity for a specific Project ID and then add up the total hours spent on that specific Activity, for that specific Project to create line items in an invoice. I cannot have multiple line items for Design, for instance.... simply a sum of all hours spent on the Design Activity. Any assistance would be GREATLY appreci…

Hello ... Need a little help. I want an open script to go to one of three layouts depending on which password is entered. Is this possible?

I need to print multiple copies of 5 different layouts and print layout script repeating over and over. Eg: Go to Layout [sample] Print [No dialog] Print [No dialog] Print [No dialog] Print [No dialog] Go to Layout [sampleA] Print [No dialog] Print [No dialog] Print [No dialog] Print [No dialog] Go To Layout [sampleB] Print [No dialog] Go To Layout [sampleC] Print [No dialog] Go To Layout [sampleD] Print [No dialog] I know there is a better way of doing this but I am not sure how.

i have 2 files with a relationship setup. one is a sort of a log that displays a summary of all the records in the second file. problem is... i can't seem to have the log display all the records from the file, just the first one, and if i delete it, then no records will be displayed... any ideas?

In FMP5.5 I am trying to create an application with the following functionality... Start Page will be a graphical interface that allows users to "Add Projects" and "Line Items" per project. Each project can have an unlimited number of line items associated with it, and they all need to appear below the previous item in an orderly fashion on a seperate layout behind the graphical interface. Help is needed to place the line items below the others in a dynamic format. Can someone please give me shove in the right direction. Cheers, Pall

using fmk 4.1 on a mac in os 9. i have one field (a) in one module. have field ( in another module. the module that has field ( also has a modification field that auto enters date modified, EXCEPT when field ( is triggered by field (a). the script is in layout that has field (. the script is as follows: If(IsEmpty(newitemISBNSKU::FileName), "", "Yes") can i add something to this script so that when the field (a) adds a "Yes" to field ( it updates modification date field in the same layout as field (? what would i add?

how do i setup a script to run on 'open'? i would like to limit the amount of records shown to users by finding only records pertaining of interest to them. i basically have to "Find records where FIELD equals VALUE" but i want this done automatically to increase user experience. any ideas? cheers!