Script Workspace and Script Triggers

Hi Everyone, I'm working on a many-to-many relational database and I'm having trouble writing a script. There are 3 databases: Teachers, Events, and EventTeach (join file). I can add events to teachers and vice versa fine, but I want the Add Event script to check to see if that teacher already has a specific event associated with them so that duplicates events don't get added to one teacher. I don't know how to go about doing this. I was thinking about how to script current field info and then checking if it already exists as a record. Any help would be great. Thanks. FileMaker Version: 5 Platform: Mac OS 9 Many to Many.zip

Hi I have a text field 'Par" with 5 carriage returns in each record. Sometimes there are only 4 lines. So I would like to have a calculation that would send the last line to a field called "five" when it occurs. So it would normally have 4 lines in the field "par" and when there is a five line exception I would a calc to send the 5th line to field "five" I would like your help please Thanks Dave FileMaker Version: 7 Platform: Mac OS X Panther

Hello, I'm using a summary field that counts the number of customer ID numbers in a sub summary part. In turn I can find out the total number of invoices John Doe has in my db. But I can't sort or search in this summary field to find out who my most active customers are. Is there's a way to copy the value in a summary field and paste it into a text field where I can perform a search or is there another way I could be doing this altogether? Thanks in Advance Michael FileMaker Version: 6 Platform: Mac OS X Panther

G'day So I've got this awesome looking database, and due to my inept scripting, I'm throwing up windows and giving them fancy names left, right and centre. As you can imagine what often happens is that I have users moving between windows using scripted buttons, but sometimes these buttons, in an effort to be generic, and cut down on dev time, don't deal with the windows in an intuitive way. ie. the windows stay open when they probably shouldn't, and close when they could have been left open. The real stinker comes when a user manages to navigate (or just click) on a window and repeats a script by clicking on a button already clicked - an annoying result is …

does anyone know of a script debuggin plugin? I just got fm7 and I am strapped but I am feeling the pain of not having the debuggin feature in developer. FileMaker Version: 7 Platform: Windows XP

Hi I have created a script to work out the next serial number after importing records. I need to know how to adapt this script so that it automatically updates the serial number in the related line items file Any suggestions ? FileMaker Version: 6 Platform: Mac OS X Panther

I need to automate a search. I have a Donations layout with donation date, donorName, donorID, amount given, etc... I need a search that will show all records based on amount given every year for last 3 years from user inputted amount. So, the query would automatically check current date and then look back 3 years, and display everyone who has given say between $100 and $500 every year since 3 years ago. So all the user would input would be the $ parameters of the search, like amount > $500 and < $1000. I hope this makes since. I would greatly appreciate any help in this task.

I have a layout which shows result set of a search. However when looking at this list there will be some that are thrown up that are not relevant is there any way that I can add a button which remove a record from the found set but leaves the rest? FileMaker Version: Dev 6 Platform: Windows XP

Hello I have a new text import that I brought into a large global field in Filemaker. I there are sometimes 4 lines instead of the 3 - Iwas using . The first line can go to another field a called " header" but the other lines need to be switched. The third line needs to take the place of the fourth line in other words, lines 3 and 4 need to be reversed. Is there a way to script this? This should be a part two to this question but I was wondering if it is possible to find a word in a line and then put a ";" before the word before the word that is found. EX V8 5.7 Liter K is the line I would like to locate the word "liter" in each line and put a ";" before t…

I can't seem to find a solution to this dilema and I thought in the past that I could accomplish this. Does anyone know how to Open a file with the Open script disabled? FileMaker Version: Dev 6

I've looked throgh the tech support on fmpro7 and they acknowledge the EMAIL SCRIPT issue where all is populated except the "to" in your email program. I happen to be using netscape but they mention outlook on XP but offer no solution. Anyone stumble on to a fix FileMaker Version: 7 Platform: Windows 2000

I am developing a database that is to be converted to a runtime version. Now i need two different print script steps. 1] a print script to print the current record 2] a print script to print selected records. I have seen that in the print dialog box the user can (or even more, must) select to print either the current record or the selected record. In the runtime version i obviously do not want the user to have this choice. So what i do is i make two script steps. The first step to print one record and the second one to print the selected. In both scripts i have disabled the show dialog option. So far so good. But how about the printer choice. …

I'm getting the message box shown in the file when I run a scrip that I wrote to prevent users from seeing files that were not created by them.......anyone know what I'm doing wrong? thanka in advance FileMaker Version: 6 Platform: Windows XP FM.txt

Hi, I am just starting to play with the script function and it seems to be highly addictive. Im am using FM7. Is there a script step that will create a new table? I haven't found it yet. Joern FileMaker Version: Dev 7 Platform: Mac OS X Panther

I can't seem to do this, though it makes sense to me. I'm trying to set up a comparison like this: fieldOne fieldOperatorChosen fieldTwo where fieldOne and fieldTwo are values and fieldOperatorChosen is a value chosen from a value list with "=, ?, <, >" as options. I know i can do it by branching off into different script versions, e.g. if fieldOperatorChosen="<" then perform script compareLessThan... and so forth. But there has to be a better way. I've tried getField(fieldOperatorChosen) and getField("fieldOperatorChosen") but the validation never works. I have a feeling I'm missing something obvious, at least I hope I am. FileM…

Hello I am looking for a way to find if a specific word is present in the first line of a 3 line chunk of text in a text field. For example I am trying to find if the word " diesel" is in the first text line in a field called "Paragraph" A ny help and all help very appreciated Thanks STAN FileMaker Version: 7 Platform: Mac OS X Panther

A. I have two different files that I usually have open on the desktop. Is there a simple script that I can attach to a buttom that will jump from one to the other when they are already open? B. Also in scriptmaker to go to the different modes. Is there a way to tell it to go to layout mode at the end of the script? FileMaker Version: 6 Platform: Mac OS X Panther

I want a to open all related files when I open one file. Is there a way to do this without using a script. If not, does anyone know how to create a script to do this? Thanks FileMaker Version: 5 Platform: Mac OS X Panther

Hello, Any help??? I am trying to develop a project manager for sales reps. Basically, When a customer says they want to set up an account there are a series of tasks that need to be done for that client to be set up and handled properly. Tables CustomerTable-Contains customer info TaskTemplate-contains the Master task List that need completed for every customer CustomerTaskData-contains the tasks for each customer. Basically, whenever a customer says yes, we need to copy all of the tasks from the TaskTemplate Table into the CustomerTaskData Table so that they are connected via the customer number. Then we can track on a customer by customer basis …

Hello Is there a way to look through a long global text file and copy only single lines and replace them with 2 additional copies. This is in response to an earlier post today. But I found I have some single lines in my text and they should be tripled so I can use the script from earlier. So I am looking for a script to look for a single line of text with a paragraph break at the end and copy it and paste it back in the same location 2 more times to get a three line version of the same text instead of one line. This will help me tremendously with my project and the hard work that others have given me to help this to happen properly Thanks STAN FileMa…

Hi listers, this may have been covered before but in the short time that I have been on here I haven

Hey guys, I need some help w/ a script to do the following. I think it should be pretty simple but I

I am sure this is a stupid question, but how do I combine 2 text fields. I am used to lotus approach. Current Field value="test" Need field value to="test2" Thanks. FileMaker Version: Server 7 Platform: Windows 2000

Hello I have a field with a huge text file that I brought in so I could automate a process. I have a certain amount of space then three text lines show up and I want to copy them and place them in another file. Can this be automated with scriptmaker? There is always different amounts of space between the 3 line text groups like below for example The dish ran away with the spoon Mary had a little lamb Its fleece was white as snow. Everywhere that Mary went The lamb refused to go not exactly the nursery rhyme Fee Fi Foe Fum I smell the blood of An Englishman. So as above they are always three lines but varying space b…

I am trying to develop a project manager for sales reps. Basically, When a customer says they want to set up an account there are a series of tasks that need to be done for that client to be set up and handled properly. Tables CustomerTable-Contains customer info TaskTemplate-contains the Master task List that need completed for every customer CustomerTaskData-contains the tasks for each customer. Basically, whenever a customer says yes, we need to copy all of the tasks from the TaskTemplate Table into the CustomerTaskData Table so that they are connected via the customer number. Then we can track on a customer by customer basis that every task is getti…

I hope I am posting in the right place and not a repeat of a question. I think I have looked at almost every post for the past few years. So... I need to bring in a field from 9 different databases (only 1 field per database) into one database. I have set my relationships but it would be best if I could script a button to import without dialog. Can this be done with Filemaker 6 or would Developer 6 make it happen? Thanks for all the amazing information. I never could have gotten as far with this project without all your help. Pat FileMaker Version: 6 Platform: Windows XP

My solution works with Windows 2000 and Filemaker 5.5 I have a solution that works with a web service. Everytime I receive a new record I have to create a text file with the new record

Hello I need a formula to extract the 2nd entire line of a paragraph("PAR"). And I need a formula to get the third line only. "PAR" I appreciate your help very much. STan "par" is the paragraph field name. FileMaker Version: 7 Platform: Mac OS X Panther

Is there any easy way to create a script to find all of one name in a database and change the text color for just that name?? For example, I have a database that gets the names of people from a value list. The names are formatted title case and all black. I want to find all Joe's and change to red color. could someone tell me how to do this?? I am going through database now and changing each occurence of Joe manually. Thanks Larry FileMaker Version: 6 Platform: Windows 95/98

Is there any way to insert data into fields from another application using ActiveX? The way I do it now is with the clipboard which is somewhat of a pain and a bit slow. I had hoped in version FM 7.0 there would be some additional ActiveX methods, but it's exactly the same as FM 6 as far as I can tell. Anyone know of a plug-in that supports this? FileMaker Version: 6 Platform: Windows XP

Hi there, now doing some report that will using the subsummary function. I need to display the page number base on this format "Page 1 of 2, Page 2 of 2". But i can get the total page number because i'm not sure how many record will be printed on one page. So, i just want to know normally how you all calculate the value on the report with subsummary function. Regards, Henry FileMaker Version: Dev 6 Platform: Windows 95/98

I want to show a layout in a file in a pop-up window. I have file 1 and file 2 and start with both files open, but file 2 window is hidden. On a layout in file 1, I click on a button, and I want it to show file 2 window on top of file 1 window. Currently, file 2 window opens, but it appears behind file 1. How do I get it to appear on top? Secondly, how can I get the layout in the file 2 window to appear at a set size every time. Currently, the size varies depending on what I last had that file open as. I want this layout to only appear at a certain size. Thanks FileMaker Version: 5 Platform: Mac OS 9

I have a file with a report with a summary field "Average price hour by year" (Salaries file) There is any chance to capture this result to use it in another file (Actuations) in order to calculate the cost of an actuation = "number of hours of actuation" (of one agent) * "Average Price hour by year"(Of the same agent). This has by done by scripting. But I don't know if I can capture this result (Average) from a subsummary part of one report to use it in another relationshipped file? Is possible? thanks a lot FileMaker Version: 6 Platform: Mac OS X Panther

Can anyone clue me in as to how to determine if a value in a field is a member of a value list? I have date field that I'd like to check to see if it matches a list of dates that are contained in a value list that gets its values from a field in another file. Basically, the value list contains the dates that my organization is closed for holidays, and I want to check that a value in a date field that is automatically entered by a script using a calculation does not get entered if the date matches one of our holidays. This might seem simple, but I can't find the answer anywhere. Any assistance would be greatly appreciated! FileMaker Version: 6 Platform: Ma…

Hello I have a text field in which there are sometimes 3 or more lines. Each has a paragraph return. I need to make a calc that returns only the 1st 2 lines. Can someone tell me how to do that? Thanks Stan FileMaker Version: 7 Platform: Mac OS X Panther

Is there a quicker way to write a script to enter field values from a related file without doing a set field command for each field? I have three different tables to pull from, but I need to have a button scripted to fill in all of the values in the base table. FileMaker Version: 6 Platform: Mac OS X Panther

I'm trying to create a computerized questionnaire for subjects in my psychology experiment. Ideally, they would see uniform instructions in the header of each screen, receive each question individually, and use radio buttons to respond before pressing a button that moves them to the next question on the next page. I've figured out how to do all of this manually, but I'm sure I'm doing it the most absolutely dumb way ever (I'm a graduate student who has never used Filemaker before and I have a hunch that each question really shouldn't need it's own separate layout - really, it's ok to laugh). Any help would be very much appreciated by everyone in my lab. Think of your…

I, too, am fairly new to FileMaker, especially scripting. I have a FM database and have imported records from HyperCard, but some of the date fields have the wrong year. Instead of the year beign 2003 or 2004 it came in as 1903 and 1904. I'm trying to figure out a script that will change the year to the appropriate date, either 2003 or 2004. At this point I'm pretty frustrated. Please help!

I would like to send a mass email from Filemaker to Outlook, but use the bcc feature in Outlook so everyone doesn't have to scroll through a huge list of email address at the top of their email. There is a cc feature in the Sent Email dialog box, but is there a way to do a bcc? FileMaker Version: 5 Platform: Windows XP

In the abstract, 3 databases are involved. A has a one-to-many relationship to B. A has a one-to-many relationship to C. For a record in A I need to find all related records in B, and create a new record set in C, based on the content of B and other info. Approach must be Web compatible. How is this done? If they were merely tables in one DB, I could do it, but this is not an option. Ken FileMaker Version: Dev 7 Platform: Windows XP

Hi, After some hours of testing, my experience is that the "Send Message" script step in FileMaker is limited in the sense that it does not use the windows character set when passing on the string to the OS. If I try to send a string containing a diacritical character (such as the character

I need some help creating a script, if you all would be so kind. I have two tables. One called "Library" that has unique records each with it's own library number. The other table, "Music Videos" has records with duplicate library numbers. I have a layout using Library with a portal to Music Videos based on Library number. I need to merge the fields in each Music Video record into a field in Library based on Library Number. Music Videos has multiple records with the same library number. Basically I need to get rid of the Music Video table so searching is easier for users. I'm not that fluent with scripts, so any and all guidance is welcome. FileMa…

I'm creating a db to keep track of stock (shares not sheep). My main layout is a list of all stock held. The records displayed are 'masters'; all sell/buy transactions are omitted but related to the 'master', which contains the net position. Clicking on the name of a stock, displays a button menu for that record only. The menu items are Increase, Decrease, Edit, etc. Take Increase - buying some more. Clicking the button takes me to a specific layout where details of the new purchase are entered. For reasons I won't go into, the original current record is now no longer the current record so when I return to my list, it may well have moved position on the screen. …

I use the Open URL script to open a website and is working fine on most of my record. Except on some record, instead of opening an Explorer window it goes on Outlook and show me the new email window with strange caracter in TO. Is that happen to anyone ? FileMaker Version: 6 Platform: Mac OS X Panther

at the top of a field box ? I created a script to insert the current date but it keep putting at the end of the previous date. I need to put it before older date, pushing older date to the bottom. It is possible with filemaker ? thank for your help. FileMaker Version: 6 Platform: Mac OS X Panther

Is there a way to have a checkbox that makes a field locked or open for entry based on a checkbox value? Thanks Simon FileMaker Version: Dev 6 Platform: Windows XP

Hello, I have a script that gets a found set of records (reports) and then sorts them by customer number (field name Customer#). I want the script to go through the found set and omit EVERY record with the same customer number. I also have a global number field to "Set Field" Customer# into (for comparison). My problem is that I can get it to omit the first several records with the same customer#, but then it still leaves one record (which had the matching customer# to begin with). I tried doing a simple find with the criteria I'm looking for (including the "!" in the Customer# field and omitting those records), but that didn't work. I got a message that…

I have imported emails from outlook which contain web form replies in the following format. ------------------------------------ Contact_FirstName: FName Contact_LastName: LName Contact_Title: Mr Contact_Organization: Filemaker Inc Contact_StreetAddress: PO Box 123 Contact_Address2: AppleLand Contact_City: Applesville Contact_County: Contact_PostCode: AP2222 ------------------------------------- How can I split this up in to the appropriate fields that are needed for this? Any help would be appreciated Thanks Simon FileMaker Version: Dev 6 Platform: Windows XP

I'm building a fault tracking system. I pplan to place a screen with a list of live faults on a desk for an engineer to glance at occassional to check for new faults appearing in the list. I would like the list to refresh itself every few minutes so that new faults appear in the list automatically without requiring someone to run the find/sort repeatedly. Can this be scripted ? Some sort of script that loops slowly: find live faults sort pause 2 mins repeat Any suggestions would be welcome. Shane FileMaker Version: 7 Platform: Mac OS X Jaguar

Can I show the content of a field in a dialog box? FileMaker Version: 3 Platform: Windows 95/98

Hello all-- Am trying to write a script that will simply find the next entry in a value list. For example, if my layout has a field on it called "Name", and that field uses a value list called "Names", and the Name in the current record is "Joe", I want to launch a script that will perform a find on the value immediately following "Joe" in the value list. Hope that makes sense. Sure, the user could just go into find mode and arrow down 1x in the value list that pops up, but--long story short--I need it to be done via a script. Thanks, all--- FileMaker Version: 6 Platform: Mac OS X Panther

Hi, FM 7. Is it possible to use the value of the "Optional Script parameter" (for a button that triggers a script) in the Find Request Criteria box of a Perform Find action in the script which is triggered by the button? I have created two buttons which both trigger the same script. The first button needs to tell the script to look for all invoices in which field TYPE has value A, the second button tells to look for value B. Now it seems that in the Find Request only static values can be entered. No other field values can be used (like a global field value), nor the result of the "Get(ScriptParameter)" function. It will literally search on the entered text, so i…

Hallo I wonder if someone could help me with a script. I want the data (text) from one repeating field to be "sent" to another repeating field (in another file). Don't ask me why, or, well you could and I'll try to explain why but I would rather not embaress myself. This is what I've tried with so far: SET FIELD ["Relation:field 2","Get Repetition(field 1;1)"] SET FIELD ["Relation:field 2","Get Repetition(field 1;2)"] etc.... and in the field specify option I've set repetition to 1, then 2 and so on. But the only thing thats been inserted is the data into the first repetition of field 2. The other repetitions are empty. WHY ?? FileMak…

Hi, I'm trying to write a script that allows the user to jump to a specified record. (i.e. The records have unique serial numbers in one of the fields. I'd like for the user to be able to enter the serial number of the record they want to jump to, and hit a Go To button) It thought it would be a simple: Go to record/request/page["Field name"] (where Field Name is where the user enters the record number) but it's not working. Does anyone have any advice? Thanks a lot! FileMaker Version: 6

Hi there, I want to create a dialog box with 2 buttons to warn the user about the next action. Buttons: OK and Cancel. OK means to continue the script. Cancel means to abort / exit the script. I'm having difficulties with the Cancel button. Thanks for your help

I'm a brand new user of FM Pro 7 and enjoying the experience. Can anyone please tell me how I can show the logged in User Name on the Print output of records from my database? I see it as a function - but I'm obviously missing the plot because I can't get it to print! Thanks in anticipation. FileMaker Version: 7 Platform: Windows XP

Is is possible to execute a script each time an existing record is viewed? ( I want to change the layout depending on the contents of a record) Thanks FileMaker Version: 7 Platform: Mac OS X Panther

Hi any thoughts on how to separate some exiting repeating fields? thanks FileMaker Version: 7 Platform: Mac OS X Panther

Can anyone direct me to a good resource for learning how to write Scripts and Calculations in FM (class/book/website,etc.)? I understand the basics and can write simple scripts and some calculations, but I want to expand my skills to something more advanced. My problem is that I don't know command words/phrases that FM is expecting. I can figure out the structure of a script/calculation just fine, I just don't know the terminology enough to translate what I'm thinking into what FM understands. Please help! Thanks, -Johnson FileMaker Version: 7 Platform: Windows XP

Hi all I Have a portion of a script that is not working and i cannot understand why. Would someone look at it and tell me why. Allow user Abotr [off] Set Error Capture [On] Set field [g_drawingno, ""] Show Custom Dialog (Message) One button the "OK" Dialog has an input Field (g-drawingno) Go to layout [main] Enter Find Mode Insert Calculated Result[drawing_no,g_drawingno] Performd Find If[ Status(Currenterror)=401] Beep Show message (message) One button"OK" Show all Records go to layout (menu) Exit Script else If (status(Currenterror)=400] "Find criteria is empty" beep Show mesage (mesage) One button"OK" Go to Layout (Menu) ex…

I'm trying to use the Convert File step in script maker to convert several hundred files from File Maker 5 to File Maker 7. However, when I issue the command I get prompted, first to rename the file, then to choose the new name for the file even though I have selected the "Perform without Dialog" option. Does anybody know how I can get the command to quietly convert the file with no prompts - or is there another way to either convert large batches of files or single files in a script? Thanks, Steve FileMaker Version: 7 Platform: Windows XP

How do you do, I call it MoMo. I have participated from Japan. English is not its favorite. I learn the solution method. Please download and check a sample. http://www.ne.jp/asahi/office/momo/upfiles/ScriptExec.ZIP FileMaker Ver4.0->Ver7.0 It moves by the version 7.0 from a version 4.0. Please click the memorandum field. And please carry out the choice of others and input A, B, or C. Although each message is displayed, this can be transposed to a sub script. I am pleased if it becomes your reference. I would appreciate your favor in the future Version: v6.x Platform: Windows 2000

My first post. I saw this posted and never could find it again - how to add to a field while retaining preexisting text? In a mail import file, upon importing, I've got a script that allows the user to name the "source" (fieldname) for the new set of records. Some records may be dupes from previous imports, and I'd like to have both (or multiple) names listed. I usually use the replace function for multiple records, and I'm not sure in this case if I'll need to do a loop for data entry. Simple solution, I'm sure. Any advice is welcome. A value list will also be made out of this list for searching purposes... Version: v6.x Platform: Mac OS X Jaguar

Hi, is it possible to turn on/off field indexing via ScriptMaker? This is normally done via the define fields area, and changing the storage options for a particular field. But I just wanted to know if it's posisble via a script? Thanks. Version: v6.x Platform: Mac OS X Jaguar

Hello I have a script that fills in a bunch of fields with insert text command. It gets to the 13th field in the row and I have a dialog box which says " This field is defined to contain only specific values. Allow this value? " I have checked the field and there is no such criteria . It is a text field. I am inserting text. The field is exactly the same types as the others but this one always stops my script . Is there anything I can do to get rid of this dialog box . I don't think the error makes sense. Thanks Version: v6.x Platform: Mac OS X Panther

I am trying to create a script that will allow users to jump forward ten records within a found set. Is there anyway of doing this? I have buttons for go to record next,last, first etc but would like the option to jump forward and back 10 records within a found set. Version: Developer v6 Platform: Windows 2000

Hello, I am writting simple event schedule. I need to figure out how i check for conflict when someone try to create event for the same city, time, room. Example would be Austin, 3:00pm, room B. if someone try to create a record with the same info, i want a message to pop up and inform the person who is entering that datat that city, time, room are already taking.

as you will see in my "users" database, i have a lookup field. whenever anyone makes an order their details go into my users database. is there a script that will be something like "if email address exists dont import this record"?? if so could you edit my database files so that it uses this script? thanks a lot Version: v6.x Platform: Mac OS X Jaguar

I have a login.fp5 file that will allow user to login into my menu.fp5 file. For this menu.fp5 file, there are 5 passwords with 5 different privilege. Then I need to create 5 opener files (such as opener_1.fp5, opener_2.fp5, opener_3.fp5, opener_4.fp5, opener_5.fp5) to allow users with different login to open this menu.fp5 file. When a user is logged in, he is directed to one of these 5 opener files and then the opener file will open the menu.fp5 file with the according privilege. My question is "why do I need to create a opener file to open the menu.fp5 file?" Can I implement this within a script such as "when username/password correct, open file menu.fp5 w…

whenever anyone sends me an order off my site i get this email: --------- FORM DATA STARTS HERE --------- <First Name> Potato <Last Name> Head <Email> [email protected] <Email Confirmed> [email protected] <Address> Potato House Highland Road Northburog Shiringhamshire IG7 4FX Twoodeland <Refered By> friend <Friend's Email> [email protected] <DVD> Saving Private Ryan <Gift> portabledvd <Comments> make it snappy! <Terms> on <Mobile/Phone Number> 07548 531468 ---------- FORM DATA ENDS HERE ---------- Now t…

Hey, I see Script steps that allow me to go to a layout or record by a number. But is there any way to reference a FIELD indirectly? Eg, to go to, copy from, paste into, or set a field without specifying a specific field-name, but rather specifying a global VARIABLE which POINTS to the desired field (by number or name), so that I could use a loop to change 40 fields without doing them 1 at a time. Thanks! Eliot Version: v5.x Platform: Mac OS 9

Hi I have transferred some scripts from a sample database (SortDemo) which doesn't work in my database. I had to do some alterations due to FMv3 to v6 script differences. All I want to do is sort a list view of records by 3 different fields and have the column header (icon) change to show it is the column being sorted and also a toggle set for Ascending/descending. Part of the script follows, there are other parts to the script, but they all seem to follow similar lines to this - the one thing that puzzles me is that there is no scripted reference to the name of the field to be sorted - which is 'Composer' If[""SortOrder" = GetRepetiton(GlobalGS, 1)"…

Hello! I have about 5000 small .dbf files that I need to import into FM (FM6). Is there a way I can 'collectively' open them, or is there some kind of merge process, or some other way of avoiding having to do this process 5000 times?

Hi there, just a small question to ask, is that any to count the total line in a text field? Now i have created a small mailing system that let us easy to print out their letter. It contain a customer databases and a letter format selection. I have create a text box that let user to write their mail and the system will print out the mail with correct format(with mailing address and etc). Now the problem is if how can i perform multiper page printing? If one page i only allow user to fill in 30 line text, then it should break the contain of the text field in to different page. I can't use patterncount for return key("

I noticed in Script Maker just now that I can make my own dialog boxes. There are not a whole lot of options but if I could do this it would save me a lot of work! I know I can make a dialog box and have up to three buttons on it. What I don't know is if I can make each button go to a different Layout. If I could... oh, would that be awesome! Version: v7.x Platform: Mac OS X Panther

There should be an easy way to do this, I just don't know it. With applescript you can tell an application to come to the front with the "activate" command. Is there an equivalent to this in windows batch scripting or vbscript? If you use the send message script step and simply run the executable file, windows just starts another instance of the program rather than bringing the already open application to the front. This isn't the behavior I need. Does anyone know how to do this? Thanks, Dana Version: v7.x Platform: Mac OS X Panther

is it possible for a background script to run which will log a user out if filemaker hasnt been used for a period of time? (filemaker in particular as distinc from an idle computer ) thanks Version: v6.x Platform: Mac OS X Panther

I have a relational solution and a script that runs in the main file. It copies data from a field, and then runs 4 subscripts (same script steps in 4 different files), each entering find mode, pasting the copied data, and finding. Back in the main file, the data is displayed. Everything works fine, except when I look at the layout where the data is supposed to be, most of the fields *appear* blank. In other words, nothing is displayed until I click in the field. Once I click in it, the correct data appears... What do I need to do so that the data displays without the clicking? I assume it's a script step I'm missing. Thanks, Susan Version: v6.x Plat…

I have 5 tables. Equipment and Who_had_last are related on Inventory in both. When equipment is checked back into the warehouse, the user currently clicks on a button which changes the "checked_out_date" to the current date, and changes the "Assigned_to" field to that warehouse. The changes that we need, is to keep a log of who had that piece of equipment last. My thought was to create a new table called "who_had_last." After this, I would create a script to copy this info over. Once the button is pressed, FMP goes to run an external script on the "who_had_last" file. This script 1)creates a new record, 2)inserts today's date in the transaction_date fie…

Hi, Im working on a database which will eventually be cross platform. I have a script step which is: If (Status(CurrentPlatform)=1) Do the Mac Script Else Do the PC Script End If Im working with FM pro 6 and myclients have both mac os9/10 and windows 98/xp/2000 machines, what am I doing wrong? Im testing in OSX.3 Thanking all in advance

Thank you ahead of time for your help! This is a great site for getting over mental speed bumps... what would be wrong with this script? I'm not wanting it to, but It's copying every field over from the next record. I'm trying to copy the contents cell/field by cell/field of a record that has more contents than the newest record that is basically a duplicate. For example the new record may have only an updated mailing address, but the other duplicate record may have all of their other info like phone numbers, emails, etc that is still accurate and needs to be kept. So, in an effort to merge the two records, I only want the script to copy the contents of a cell…

is it possible to disconnect guests via a script step? I can set a file as Single User via a script, but if the file is shared the user gets a dialog box and the script pauses. I'd like to automate the disconnection of guests so that I can run a timed backup of the hosted file Yes I know the client should be using Filemaker Server... (X-posted with Filemaker 5 board) Version: v5.x Platform: Mac OS 9

This is driving me crazy. I have a database with record with three fields : veld1; veld2 and veld3 (yes indeed i am dutch) Now i want to perform a find script that finds records with veld1 contains text to find veld2 contains zero or more characters veld3 contains nothing How should i define the necessary fields steps specifically how to set the field veld3 to nothing ? Thanks Jitse Schaafsma

Hi We get a number of contact details sent to us via a form on our website. I was just wondering how I could automate them to go in to a separate part of the database? They are all currently in outlook? Anyone with any bright ideas? thanks Simon Version: v6.x Platform: Windows 2000

I am trying to create an activity signup database. Each event will be a record, and there is a repeating field called Attendees. There is a field called Capacity that defines the maximum amount of participants. There is also a global field called Username that, through VBScript, contains their logon username. I want the users to be able to click a button and have the script find the next empty row and insert their username, but not allow them to sign up if the number of repetitions in the Assignees field exceeds Capacity. Version: v6.x Platform: Windows 2000

I am responsible for a system that is being used in a call center. We are using FileMaker 5.5 and windows 2000. I have a script that has to show a message to all users logged on the calling center. For this this message to be sent to all users, I

Is it possible to create a script to populate all repitions of a repeating field? I am creating a bid sheet for an auction and need to create bid value increments based on a Value field. Example 30 is value. Rep 1=30, Rep 2=(Rep1+10), Rep 3 = (Rep2+10), etc. Thanks Novine in NC Version: v6.x Platform: Mac OS X Panther

I have a script that is triggered by a button in a portal row- The script acts on the data in that row. A problem arises when a field in another portal row is already selected ( the script acts on that portal data). All works fine if no fields are selected. any ideas thanks? Version: v6.x Platform: Mac OS X Panther

Hello, I am very new to Filemaker and on the verge of getting my boss to buy FMPro7, I greatly appreciate your time and comments. We are doing a documentary about the building of the new UCLA medical center. We have over 180 tapes of footage shot over a seven year period. The tapes were logged using a program called TEP made by Imagine Products and can be exported to element based XML file and a corresponding directory filled with JPEGs of the frame-grabs. So the ultimate goal is to consolidate all the logs and JPEGs into a master FM database where they can be easily searched, sorted and manipulated. I have downloaded the trail version of FM6 and I

Hi Everyone! I need some ideas/help/suggestions. I am very new to filemaker and because I am the one with the most computer knowledge I have been given the task of automating some actions. It looks as though scripts will be the best way. Here is what I need to do: At the end of each month, find all records that have had samples sent to customers from the month before ie. On March 31 pull up records from Jan 1 to Jan31 Merge the customer information to a letter(already set up) and print each letter(heres the major catch) In printing each letter the print setup can be changed to actually use our fax machine and print to fax. However the script has …

is there any way to find the values from DB through script..... like actaully i have tow global variable and where these i am taking from input boxes and when i am giving the values and click on ok button then i would like to search that content in that file.... how can i write this... Thanks Version: v6.x Platform: Windows 2000

I have donor numbers (format SC-yy-mm-xxx where xxx is a serial that starts over each month), ex. SC-04-03-087, that are put in a field that is a pop up (in case the referral is NOT a donor). I have automated the first sections of the number but cannot figure out how to make a serial # start over each month with 001. When the user clicks the "Convert to Donor" button, the field is populated with the donor # (except for the last three digits!). If the referral is not a donor, the user clicks in the field and chooses a deferral reason. I guess I can make the user manually enter the last three digits but to cut down on errors, I would rather automate it. Any suggestions? …

hi I've noticed in a couple of .fp5 in that you can rename the menu item scripts? Does anyone know this?? Thanks Simon Version: Developer v6 Platform: Windows 2000

HI I have a separate search screen and the problem is that if you do a search and there are no matches you get a dialog box with "Modify Find", "Continue" and "Cancel" options. If you click cancel the search page displays an entry which can be editted if someone thinks they are still in the search layout. How can I make this cancel take them to another layout or run a script which goes back to finding. Thanks Simon Version: Developer v6 Platform: Windows 2000

Hi I would like to write a set field or insert calculated result script to send data to populate a whole group of fields. Is this possible? If I have fields named q1, q2, etc and I want to send the data "chair" lawnmower" respectively. Is it like q1="Chair" , q2="lawnmower" I am not sure how to write this. Thanks STan Version: v6.x Platform: Mac OS X Panther

Hi- Here is an example that makes more sense than my last question. I have 10 records and each record has a field called "color." The records are entered to tell the color of Pens sold. The 10 were entered as follows: Black Green Red Blue Blue Blue Black Red Purple Yellow Although there are 10 different records. I need to find out only those originals and not the duplicates. and have it that result sent to another file "originals" into a field called "SaleColors" The result would be Black, green, red, blue, purple , yellow I am trying to figure out how to script that. Thanks Dave

Hi I can search and "extend" a found set but what would I need to do to be able to search within a found set. does anyone have any examples of this? Thanks Simon Version: Developer v6 Platform: Windows 2000

Wondering how I can make use of the OK / Cancel buttons when I add a Show Message step to a script. What I want to do is continue the script if the user responds by clicking OK, but abort the script if the user clicks Cancel. I thought if I followed the Show Message step with an If step . . . but I don't know how to refer to the value of the button from the message box. Hoping someone can point me in the right direction . . . Version: v6.x Platform: Mac OS X Jaguar

Hi guys, We have a spam catcher program running at work which allows us to filter out unwated emails. Company receives about 300 to 400 spams daily. The log file has to be checked to make sure that no good emails were blocked. We know what filters are the most likely to block a good email. I would like to be able to get the file into Filemaker to be able to search for the filters that are most likely to block a good email. The log looks like this: --- From:Ferrara Brain Pan To:Stan Reed , Thomas Dohmen , Ure Thra Subject:[Drone] Drone Zone Date:February 12, 2004, 20:10:52 Deleted on: February 12, 2004, 20:36:41 from Filter:drone --- …

I am trying to create a solution that will assist in emailing a selected set of vendors contract information. Currently I have two databases set up. One contains the Contract Information and the other contains the Vendor Information. A user enters a new contract in the Contract database which references specific vendors from the Vendor database to populate what vendors are assigned to each contract. I created a form in the Contract database that pulls all the vendor email addresses associated with a specified contract number. I then assigned the email script to pull the emails and create a message in my email application (Outlook). However, this script repea…