Script Workspace and Script Triggers

File 'A' has record that I need to duplicate and change a few field values for each record. I have a script in Field 'B' that initiates the script. - Goto Related Records (File A) - Perform Ext. Script (File A -> Duplicate Records) ........- Goto Record (First) ........- Loop .............- Duplicate Record .............- Set Field 1 = "" .............- Set Field 2 = "" .............- Set Field 3 = File C::Global_Value .............- Goto Record (Next, exit after last) ........- End loop It will only duplicate the first record in the relationship, and then stop. Any ideas? Thanks! : )

I have a file with many purchase order records. Each record can have a different purchase order number. There can be as many as 30 records with the same purchase order number. I want to find and print all the records with the same purchase order number that are on the record the customer is looking at, without them having go to the find mode. It won't always be the Max purchase order number. This script will then print a Purchase order summarizing all those found records. Is there a script step I am not aware of that allows me to set a find criteria without using the manual find routine?

Hello I have been trying to get a calculation or a script to automate the deciphering of a vin number. The problem is most formulas have exceptions and for example the model number might involve 2 , 3, 4, 5,6 of the 17 digit number and not always at the same starting place. If I am calling each part of the number with a V then the numbers of the VIN number are V1, V2, v3, v4,v5,v6,v7,v8,v9,v10,v11,v12,v13,v14,v15,v16,v17 . I am trying to figure out for example a way to decode this. A 2002 Dodge status has a model or v5,v6,v7 or specifically G42 but a LExus is decoded at the 4th digit v4,v5,v6,v7,v8 or BF30G for 5 digits. Some are only 2 digits long. Does anyone have…

I have a custom solution that heavily uses the Custom Dialog script step. This is something that should have been in version 1, but anyway... So it works great. You can have up to three fields. It works directly in find mode or for entering in text and passwords... BUT... Here's my issue. If you click ANY button other then the default far right one, it doesn't actually use the text you put in the text box(s)! So I can't use something that says something like this... Enter User Name: <Field> [Cancel] [No More] [More] Any button other then [More] results in the text NOT getting recorded! Any help would be useful as I bought V6 Dev jus…

Hello people! a push in the right direction would be great! scenario: 3 fields [Contact_ID] [Company_ID] [LockRecord] I am trying to validate user input and "lock" it down based on the fact that there can only be one combination of Contact_ID and Company_ID I have tried to mark the record by: LockRecord= If( ((Contact_ID) and (Company_ID))>1,1,0) but no luck...basically I would like to allow 1 Contact per 1 Company. These records are entered through the portal so I need to stop the entry as the list might be large and scrolling through all the recors (to make sure that "Contact was not already assigned to the same Company") would be a pai…

how do you force users to only view as a list on some layouts... as well, how do you make only certain layouts read-only, so they cannot be modified. cheers

I have scripts that are assigned to the portal rows such as displaying more information and such. For some reason there are instances when they click on the portal row the script is not triggered at all. It is either they get the black highlight color which is i think is the default color for portal rows or the gray highlight color that occurs when you click on something with a script attached. The control script steps are set to PAUSE. Thanks.

Hi guys I am trying to figure out a way of having a countdown timer to a specified date that never changes such as Christmas Day or July 4th (as opposed to say Easter) so for example if today was December 1st my calculation script would return a numerical answer of 24. Being the remaining number of days till Christmas Day. If I was counting down to July 4th and the current date was June 29th the calculation would return '5'. Can anyone help me or suggest an easy calculation. aTdHvAaNnKcSe

Hi all, In my database I have created a email option. When I use the "Send Mail" command (all the nessesary fields are selected) nothing happens. Are there limitied supported e-mail apps? Or am I doing sopmething wrong. I use as default emial app "PowerMail" If there are limited supported email apps, which one are supported in FM 5 and/or in 6? Please let me know Cheers Koen

Newbie alert! I want to write a script to perform a find that inserts a word into a field that someone has already entered into a different field. ie User has entered into a field called Subject "Food" User presses find button and it enters the word "Food" into a field called "category" and he can then enter other options into his search Hope that makes sense. Thanks

Hello from Greece (sorry for my not so good English) I have a line item file for tracking jobs in city's I have separate person.fp5 jobs.fp5 city's.fp5 in different files for good normalization I fill the line item fields via script and portal ...so far so good ....my line item file is light and speedy 1st Rule: one person or more can do one or many jobs in one or more city's 2nd Rule: in one city there can be one or many jobs The line item file has: person FK ID (P, P1, P2, ...) jobs FK ID (J, J1, J2, ...) city's FK ID (C, C1, C2, ...) ...and of course Line item pk ID A typical situation is: Record 001 C…

Hi all, I just inherited a database to work on. In it are some calc fields that have multiple, nested, if then statements (about 35 each). These calcs are unstored and take about a minute to calculate when I want to display the results on the layout. I am trying to optimize the calcs, is there any speed difference in FMP(6.0) when evaluating multiple nested if then statements versus evaluating a single multi line case statement? Opinions all? TIA Jerry.

I am need to script for the following From a current form with customer id, goto report layout with the current record. ANd generate a portal containing the product that customer purchase but only with the same purchase date. I came up with Set Field ["gobal date", "Purchase date"] Go to layout{Refresh window, "Purchase Form"] Enter Find Mode[] Set Field["Status", "Purchase"] New Record/Request Set Field["Date", "Purchase date"] Perform Find[Replace found Set] Some how its not getting the date right, its return all the purchase with different date. Any Clues

Guys, Hoping someone can help me out with this question. When you use the pause script, in scriptmaker, the left hand FileMaker Status bar comes up with two buttons continue or cancel. Can I replicate the continue button within my layout using a script within scriptmaker, as I want to get rid of the FileMaker status bar. Thanks Guys Jalz

Hi Is there anyway that anyone knows of as you are entering a new record being able to search. I want to try to stop duplication so as someone is entering a new contact for example on the left after each entry it is throwing up a search on the side? Anyone have any ideas? Thanks Simon

I'm VERY new to FMP. Is there a TIMER function? I'd like to make a database form (new to the terminology) that has Start; Stop; Resume; and Reset buttons; that shows the time in HH:MM:SS format, as well as in 1/10's of an hour (or other increment that I desire). Also, I'd like the 'time' to be such that it can be 'added' or 'subtracted' from other values, so I could see how much total time was spent (in 1/10's of hours, as well as HH:MM:SS). Also, a 'round up' function would be nice, so 3 mintues 44 seconds yields .1 hour; 6 minutes 12 seconds yields .2 hours; etc. I imagine many would find this helpful, so as full of an explanation as po…

I am a novice at this real Filemaker stuff, my 10 year experience limited to making mailing labels and tracking addresses and phone numbers, but usually I learn by doing, so here I am. And I bought a book, but it seems pretty confusing to read. So here's what I am trying to do, and I apologize if this actually is simple. I am trying to write a script that opens up a second file, opens up a new record and enters data from a field in the first file into a particular field in the second file. I thought the way to do it is to write a script that first 1) copies the data in the field from the first file, 2) opens the second file, 3) creates a new record, 4) goes to the fi…

Datafile A is used by many users. They create new records, do their data entry and then "submit" this record to Datafile B. The script in Datafile A omits the record, shows omitted, then performs a script in Datafile B which imports records, creating a new record in Datafile B. That is fine and dandy, unless another user executes submit during the process. How do I lock out users until the first script completes? Please go easy on me. I am learning this by the seat of my pants!

Is it possible to FTP from FM 3.0? If not how about is it possible to open a webpage? I need to FTP the results of a search. Currently it uses about 6 BAT files and 3 FM files to do this. I streamlined it down to 1 BAT file, 1 Cold Fusion page, and 1 FM file. It would be nice to keep it all "in house" with FM tho.

Hello everyone, I know it's possible to have a notes field where current user, date and time are automatically added with a script but how can I make that field not modifiable after the user note has been entered. Also I'm importing about 100,000 records into one db and I need to get rid of one record of all records that are duplicated. It's been about 3 years since I used FMPro so I'm a little rusty. Thank you all for your help

Hello Thanks to Lee Smith I have some headway in my project. I am stumped because in the VIN number there are some inconsistencies. namely a Dodge and a BMW. So I have to make a calculation that names the car a "BMW" only if the first digit of the VIN number is a "W" and in the Second number of the VIN number is a "B"-- But if the first number is 1 or a 4 and the second number is a "B" it is a Dodge. Not sure the best way to write this. Help please. and of course thank you. Dave

I need a script to copy a date field to another date field and to clear the rest of the date field. I am using cut and paste it works but sometime the validation dialog pops up. Clearing date field leave a ? using setfield, how to get blank without activating the validation.

Hi! Not even sure if this would be a "scripting" issue or not... Here's my question...is there a way to do a sort within a sort? Example: I have twenty records to display. Each record has a 'title' field, a 'part' field, a 'status' field, and 6 different 'date' fields (date1, date2, date3 etc). Is it possible to sort by title, then depending on what the status field says, by the appropriate date field? i.e. the first 8 sorted records are for the title "Eagles" The first 3 of those 8 records are status="A", which would need to be sorted by the date2 field...The next 4 records are status="B", which would need to be sorted by the date3 field, etc.…

I cannot see how to script or calculate the result I need. Any help is greatly appreciated. I'm new to this depth within FMP. I'm using a copy of the "FileMAker Solution Framework" provided at FM site for Sales of Inventory via its Invoicing logic, etc. I have added a "Select field" in Customer Record, values = blank,1,2,3,4,5,6. Let's say the"Select field" = 3. When adding a line item to an Invoice, using a drop-down list attached to the Product ID field in the line, I want the "Price" field to pull or look up the price (in the Products File) from the "Price3" field. If =4 use "Price4" field, etc. I had hoped it could be done using the "Calculated Value" feature in the…

I need a exit script that will clear the the checkboxes in a field for all records .... any ideas

Hi there, now i want to do come script that will depend the position of the curson, just like i have 3 field a, b, c. Now i add in another cal field that chaecking the position of the cursor, if the cursor in field a, then return 1, if b then return 2 and c return 3. I use the status(currentfieldname) with case script. But it can't work automatically even i already set the cal field as unstored. It will work only i click the cal field then click another field. If i just using tab kay to go to next field, it will not calculate the result. The other question is if i using tab key to go to next field, how to i made the field turn reverse color(highlight)the words if t…

Hello I was just wondering if anyone has successfully made a FMP database to decode vin numbers accurately and how. Thanks Dave

I have a Filemaker server 5.5 based solution that utilizes a top menu database that launches sub databases. From within the subdatabases there is a button that says "Menu". When pressed this button executes a script in the menu database to make it pop up so that the user can open a different subdatabase. This usually works fine. On occasion (one in 20 times?) the subdatabase from which the menu button is pressed will flash and then "get stuck". You can't minimize it, or go to another database through the windows menu (All the others are greyed out). All you can do is close the offending database. If you keep hitting the menu button, it will flash and stay in the same data…

This is my first post. Please let me know if I should be in another forum. I own a small business and I use FileMakerPro6 to keep all of my records on individual clients. I am looking for previously designed scripts that I can use. For instance I have a field called "late fee". Numerical entires are 0 and 1. I want my script to say that if "late fee" = 1, the add 5 to the field called "Balance Due" . Any way that I word this in the calculation box, it comes up with some error like "not enough separators" or "this field does not exist". What should be soooo simple is so complicated and there is no help offered anywhere that I can find on line or in books. …

Hello, I am using FileMaker Pro Developer 6 and I'm pretty new to it. In my application, I want to allow the user to choose ONE among all currencies (US, CAN, UK etc) to work with. I added a text box where the user can type his choice. The problem is, the user can add records to that table that is supposed to contain just one record, which is the chosen currency. Anyone knows how to deal with this? Thanks a lot.

thanks for all the help you guys!

Probably a newbie question...but I guess that's just what I am. Trying to make FMP send faxes through the 4fax plugin (http://www.tribord.fr), I'm having some syntax problems. For example the syntax for the script step 4FaxStartMessage is External ("4FaxStartMessage"; parameter) In the manual I read this command should be used like this External ("4FaxStartMessage"; From | Subject | CoverPage) The script step External("4FaxStartMessage"; fromfield ) is accepted, but what do I do when I want to use the other parameters (Subject and CoverPage) too? For all I know the "|" sign in a syntax means I have to choose from one of the given possibilities. I've…

I am making a FP5.5 solution, containing a quiz with 25 questions, that the user needs to answer with a Yes or a No. I have made the corresponding scripts, attatched them to, and placed corresponding Y/N buttons on the layout. What I also would like to do is to let the user answer by pressing the Y or the N key on the keyboard, if they chose not to use the mouse. The only (un-elegant IMHO) solution i've managed to do, is the following script: The field keyinput is a global Text field, which has been hidden on the layout with a size of height 1 and width 1, and font size 1 point. I was wondering if anybody have an easier and better solution. Plug…

Hi Scripters! I'd like to open several FM-Databases via AppleScript, including the passwords. Works fine so far... But there are some files with an other password, not included in the script. At these it is necessary to press the cancel-button manualy. Is there a way to include this "pressing" into a script? Otherwise the opening of the remaining files stops until the button is pressed. Thanks for your help in advance!

any ideas on how to do this. my key value is "sku" i am using the process from http://www.filemaker.com/ti/103792.html to make sure that no duplicate skus are entered during data entry. when i do an import i would it to add new records but if one of the new records has a duplicate sku, it will not add it.

question is: can i have fm auto enter skus starting at 100038 and go up from there. and skip specific numbers i need to enter in some skus. i have a book shelf with a lot of books that i put online. they all have skus. i lost my harddrive so i am starting over. i have a list of those books in a db. they are in order from lowest sku (10038 is the first sku) to highest. however i do not have the numbers that are supposed to go in the sku field. i would run a script that would enter the numbers in and increase by one but the problem is, i sold some books before i lost my db. so the skus skip a number once in awhile. ie car book sku 100038 plane b…

I don't see anyway to do this, but best practices do direct us to comment our code for future reference, so is there anyway to do this in FM? Other than seperate documents that is.

First of all... I apologize if this is not the correct forum to ask this question. MODERATORS: Please move this to it's correct forum if it is NOT in the right place and notify me of where it got moved to. Thanx!!! Now... I am looking to find out two things about my query: a) If it is possible : where to get more info on how to implement, if it IS possible Here where I just started to work, they use FMP on Macs & Wintel boxes. I am trying to implement a new process for logging information on submitted files to our department. The way (I think) I want it to work is, I open-up an existing client (record) and click on a logging button to bring me to…

i have a list of books. each record has 4 fields title price listing id author right now each record has the title and author in the title field. ie: The Peppered Moth by Drabble, Margaret what can i do to move all text starting at "by" and ending at the end of the field, into the author field?

i have a filed called "trackingnumber" and i want to press a button to have it Open url "http://usps.com/shipping/trackandconfirm.htm?from=home&page=0035trackandconfirm" then i would like to have the tracking number entered into the field. can i do that?

Hello. Trying to make a database of pdfs. I would like to assign one button (representing the first page of the pdf) to each pdf. When I click the button it would open the desired pdf in Acrobat. I managed to make it work with the "open URL" script. I made lots of small fields in which I inserted the pdfs (so that the first page would be visible). Then I assigned a button for each field performing the script "open URL" with the path file:///computer/users/myuser/folderpdf/file1.pdf ...file2.pdf ...file 3.pdf etc.. The problems I have are: 1) Is it possible to add the path to each pdf automatically ? The problem is that I had to manually enter all the pat…

I tried to use Status(CurrentFieldName) in a script and it gives me back the field contents. BTW, Status(CurrentFieldContents) also gives me field content. Anyone else have this problem, or am I doing something wrong??

Hi, All I want to do is have other check box(es) automatically checked ("y") when I check another, specified box. Sounds so easy. Is impossible! All I can find in the FMP help script section is how to insert a calculation. Not relevant as far as I can see. Although I'm a pro at creating layouts, obviously I'm a total dummy when it comes to automation and scripts. Help!!! Karen

Hello all, I'm sure this is easy it's just not my day. I have a field set as a radio button. What I would like is if the user selects NO it will perform a script that populates 4 different fields. The script works fine. What I tried was placing a button behind NO in the field so that when no is selected it will run the script. I send the button backward and it goes behind the field. I bring the button forward and you cant tell if the Radio button is selected but it performs the script. What am I missing? Thanks for the assistance. Michael

I

I'm trying to self-teach myself FM Pro and so far have had pretty good luck,but now I have run into a snag. The DB that I've written has about 70 records, more or less. One of the fields is a date-shipped field that is blank until the item is shipped. What I would like to do is print one of two reports. One where the field is blank (nul value, not yet shipped) and one where a date has been entered (not nul, shipped). I tried "if-then" and "isempty" statements in a script, but I'm doing something fundamentally wrong. Is there an online resource where I can learn this ridiculously simple process? Maybe a thread that I missed? I've done a quick search …

Hi forum! My structure is (I think) the basic structure: Orders file with OrderID joined to a LinItems file on OrderID. LineItems are created by clicking into a portal in Orders. What I want: If Sales clicks a button called 'duplicate' on an order form, it duplicates the order and all of it's lineitems. I want to control what is duplicated (I don't want to duplicate the Order ID for instance, or the Creation Date or Order Date). The order date is currently set Auto Enter calculation of Status(CurrentDate). I started by creating several global fields to hold the data I wanted to duplicate and then scripted using: Set Field [globalSalesID, SalesID] S…

Hi everyone, Well, I just about have this set up. I have one additional problem. I have Orders db with OrderID and LineItems db with OrderID. I have a LineItem# which is set to auto-enter serial number (01 etc). My problem is that the lineitem numbers keep getting bigger and I want them to start over for each new order. Lineitems are created when adding in a portal in Orders. Is there a way to make the serial number start over for each new order? If so, I can use a calculated field of OrderID & LineItem# for the Unique lineitem ID. I tried using a self relationship in lineitems but got myself totally lost. Pete

I know its possible to download a webpage with apple script direct into filemaker but is it possible to dl a picture from the web into a folder on the desktop within filemaker?? Thomas

I'm VERY new to FileMaker scripting so I may say ignorant things. If I do, I'm sorry in advance... I'm trying to work on a scheduling database for our office where our order clerks insert orders into the database throughout the day (in one FM view) and then (in another FM list view) as the projects progress from waiting to working to complete the background color of the database entry changes from red to yellow to green... Basically if I have 10 orders showing I want to be able to click the 'waiting" button on 5 of them so that they will show red, the "working" button on 3 of them so that they will show yellow, and the complete button on 2 of them so that they w…

Hello, Does anybody know whether it is possible to construct a fieldname in a scriptstep? What I would like to do is to make a loop. In this loop there must be a scriptstep that pastes a result in a field. The name of this field varies all the time, for example the first time the field is 'result1', the second time 'result2' and so on. In order to do this, I would like to change the name of the field with some formula, e.g. 'result+a' in which 'a' becomes higher all the time. I've already asked this question in the 'fields' thread, but I now realize that this is a better place (newbie after all) Martin

Hello, I have a script that finds duplicate records and deletes. However, If the script does not find a duplicate it returns a message "No records match this request". What should I add to the script to not show this message when a duplicate is not found? Any advise would be appreciated. Shari

I am trying t find scripts and tabs that allow a user to jump to letters of the alphabet. I know i've seen tabbed letters on the top of screens and when clicked on a letter you are taken to that letter in a list rather than scrolling down the list. Does anyone know where I can find this or and easy way to create it? Thanks Lester

How can I have a script run automatically at a specific time of day? Larry

Folks, Has anyone noticed a bug where the "replace" command fails within a script? I have a script which does a find to select a subset of records, and then does a Replace Contents [No Dialog, "field", """" ]. The Replace just doesn't happen. No error, no nothing. If I run the script in the debugger, step by step, it *does* work, so something is clearly amok. Any suggestions on diagnosing/fixing this? Is there some time when the Replace will fail? I can reproduce at will. Thanks, David.

Hi Forum, This may be too much to ask, or as already been adressed, somewhere burried here on the thousands of "Multi-keys" threads.... I have 7 fields from Field A to Field G Each of them hold a different number of key values separated by a "

Hello, I am new to this. Is it possible to set up scripts to export different sets of fields without a dialog. I have it exporting one set very nicely to the specified file, but it uses whatever the last group of fields was. Can I set up one script which exports fields a,b and c to fileone.tab, and have a second script which exports fields d,e and f to filetwo.tab. Again without the dialog box. Thanks, -Jason

Greetings All, I have and invoice DB (Invoice.fp5), a jobs DB (Jobs.fp5), and a services DB (services.fp5). Both the services DB and the jobs DB call scripts in the invoice DB to create an invoice for the respective module. After the invoice is created, there is a button in the invoice module ("Print/Record") that runs a script ([bTN] = Print/Record Invoice) that will send the invoice to the printer, and set the invoice as recorded. All I want to do in this script is test the invoice type, jobs or services, and return to that file with focus. But the way the script ends, with If/Else steps, the script need to return back to the invoices module to finish the…

i have been trying to do this for a while with no success. I need to do some kind of keyboard in filemaker, i have 30 fields, each one with a code in it. i need a script that allow me to read the contents of any field and put it in a temp field, the challenge in this, is that each field is a button and have to work with the same script. The escript have to do something like this: set field("temp","Status(CurrentFieldContents)") the problem is that i have no chance to select the field because is a button. someone tell me that the only way to do this is making a script for each button, but, if i need to do a keyboard with a 100 buttons?. there is a way to …

Hi all... I have a rookie questions I'm sure. I've been working for a while now teaching myself how to use this for the program I'm setting up at my job. I tried searching to figure out how to remedy this but haven't been able to find an answer in any previous posts. Anyhow... I'd like filemaker to calculate a date for me this is what I have... Expiration = Date(Date Certified) + Year(Length of Certification) I get the error "There are too few seperators in this function" Thanks for your help in advance Trisha

I have a mail list project where I will need to append the 3 closest dealers to each recipient record. I have created a test that does what I want. The problem is the time it takes to perform the task. My test file has a little over 1,000 records in both the recipient and dealer files. The test took 99 minutes to complete. The production data will have 75,000 recipients and 1,300 dealers. Basing a time estimate on the test db, I am looking at well over 100 hours to perform this task on the production data. I am looking for ideas, database design changes that will speed this process up. I have attached my test dbs so you can see what I have done. The recipient_list.fp5 …

I've seen a few examples where the parent file creates a related record in the child file by simply performing a set field of the foreign key in the child file. The relationship is Parent ID -> Parent ID (in child file) I tested it out and my question is how do you go about in creating multiple related records because I tried the script step of just "Set Field[Parent_Child::Parent ID, Parent ID] and this only seems to work when creating one related record. I ran it again and it didn't create another record. The child file's primary key is Child ID with an auto-enter serial no. What I have been doing is passing the foreign key through a global. I…

I am wondering if there is a way to implement an automatic tab in which the user can type information into consecutive fields (which have character limitations of 2 in each field) so that you user does not have to be interuptted by hitting tab. For example, If there is a phone number entry set up as three seperate fields of 3, 3, and 4 characters each, can the user type 10 numbers in a row without having to hit tab between area code, first three digits, and last four digits. These three fields cannot be combined into one field. (it is not a phone number for for example purposes it works the same way). Thanks

I have what I thought was a fairly simple script - but I can't get the Loop to work properly. I have a db of competitors. There is a portal which shows what classes the comp. has entered. I have a field that will be printed which will indicate what classes each comp has entered. The end result I am looking for is a list: Comp Name, Horse Name, Class number, Class number, Class number, Class number This script works but is cumbersome as you have to keep changing the row number & clicking yes, then clicking no when you get to the end. Go to portal row (first) copy (select, Classes:Class#) go to field (classes for program) paste (classes for pro…

Hello, I am working on a system for bidding, making proposals, for an interior design firm. The proposal "form" has space for 45 separate items(all separate fields Qty 1, Qty 2; Desc. 1, Desc. 2; Price 1, Price 2). Depending on the clients likes and dislikes some or all of these items will be put into PO's (separate DB) for purchasing. I have limited the PO to 5 items per PO. I am trying to eliminate the need for re-keying the item info into the PO db. This would be simple if it were a 1 to 1 transfer via a lookup. But, because I'm taking a potential list of 45 items and creating several different POs any of the bidded items could end up in any of the 5 P…

If you exit a script via the "Exit Script" step, FM show up the file the script belongs to, even if the window was hidden. For example: Toggle Window[Hide] Exit Script the window comes out. Halt script does the same. Just wondering if it is a bug or a feature... BTW: it is annoying for me because I often call external script on "data only" databases from the "interface file". If the ext. script exits via Exit Script, the "data only" file comes out.

Does the Send Mail script step work with FM5 for Macintosh and Outlook Express 5 for Macintosh? It appears not!! If not, do you know of a work-round. Does it work in FM 5.5? I know it works in FM6. Help much appreciated. Thank you.

I am sure this has been discussed already, but I couldn't find it. I would like the user to choose what action to take, while in preview mode. So if they choose a specific report, and are viewing it, there needs to be a location where I can place buttons for printing, quitting, cancelling and going back to the menu, etc. How can this be done since preview mode is the only way to view a report but at the same time buttons can't be placed there? Thank you

What is the best way to avoid the dialogue "Script has been cancelled, continue or abort" and being left in layout limbo? I made a print script that ends like this is the user cancels the print in dialogue.

Hi all, sorry to cross-post but I think I chose the wrong area! I am new to FMpro v6 having mostly worked with PHP/MySQL. I have a fairly basic problem which I could code in PHP but am stuck with filemaker!! The system is for handling customer orders of books and then converting these to supplier orders. The files I have are as follows:- Customers:- cust_id, name, address, etc Books:- book_id, name, title, author, supplier_id (which relates back to cust_id in books, as some customers also happen to be publishers) Customer orders:- order_id, cust_id, dates, etc bookorderjoin:- orderjoin_id, order_id, book_id, quantity, etc (this is for…

i have a loop which checks what field the user is currently typing in so that when the user enters a certain field, a different script begins to execute. this all works perfectly except for one minor problem. When the user types slowly in large text fields, the script is fine, however, if the user types quickly, periodically filemaker beeps as if there were an error and skips over the letter that the user had just typed. This is a problem since most of the users who will be using this database in my company will need to be typing quickly so that the data can be entered efficiently and promptly. I have a pause set for a duration of 2 seconds because i was getting less beep…

I'm perplexed by the action of one of my scripts and I can't figure out the problem. Here's what I've got: Set Error Capture (on) If [isEmpty(field2)] Copy [donor id FM] Perform external script End If If [not IsEmpty(field2)] show message (with choices for each of the 3 buttons) End If If [status(CurrentMessageChoice)=3] copy [donor id FM] Perform external script End If If [status(CurrentMessageChoice)=2] Copy [donor id FM2] perform external script End If ****Note that everything works just fine up until this point when I run this part only. Now the trouble starts when the script continues: If [status(CurrentMessageChoice)=1 Cop…

Is it possible to run a script in the background? Like constantly looping waiting for an event to occur?

I have a student database based on student ID. I would like to search the db and delete duplicates. Trying to think this out. Not very experienced. How about this. Go to field StudentID Insert ! Find Now I have all the duplicates Can I have the script delete every second record? Thanks for your help in Advance

Any ideas how to solve this problem? I have a field with a page of text. What i would like to get is a script that searches for a specific word (Cast&Crew) and copys the text between the specific word (Cast&Crew) and a second word that follows sometime after in the text. The in between text then will be entered into the field. Any ideas?? Thanks!

Hi everyone, I am new of FM. I have a entry question: how can I type the Carriage Return Marker into script? I try "Alt+0182", it doesn't work. I copy from other place but it become question marker("?") after I pasted it into my script. Can anybody help me? Thanks in advance. Ken

I have a file that contains records of attendance at various support meetings for cancer patients. Each record contains a date, an event ID, and a classification number (0

Hello all... another question that I can't figure out. In my d-base we print labels, postcards, letter1, letter2, letter, and we also send email. I created a field called "status" field formatted at checkbox. What I'm looking for is anytime we do one of the letters to check the appropriate box weather is a letter, postcard or an email. Can anyone help please. Thanks -Raul

FileMaker inexplicably crashed on me a few hours ago. I was able to re-open all the files but 1. I've tried to Recover the bad file, but it's not working. I have yesterday's backup, but I did a lot of work on that particluar file today and need the current state back real bad. Any suggestions? Please?

I have a request from the boss for our small fm db. He would like to have a 50 page document (word) available for the 40 or so users to edit. I am not sure what the best way to go about this is, or if FM is the tool. I can see large fields where useres can make changes. Then I need to do all the formatting in FM to have the output maintain its appearance. All users have FM and Word on their computers. Wea re running a 1GHZ G4 with FM server. Could I get some advice on this? Thanks in Advance norm

I have a text field on a layout which users record notes relating to events associated with the record. These notes are recorded by the user in sequential order. I would like to be able to do one of two things. (1) have a text field automatically display the last x number of lines instead of the first x number. or (2) have the ability to place the cursor anywhere within a field so that new comments can be entered at or near the top. The scroll bar is enabled, but I rather the user be able to see the latest notes at a glance without needing to click on the field. Any suggestions.

Hi all, I'm a fm 6 newbie. I have a database with a date and boolean checkbox (the field is specified as a number). I can get filemaker to search on the date ok, but i want to search on boxes that are NOT checked. Basically, the search needs to be for a specific date AND the box is UNchecked. I've tried Null values... The script I'm using looks like this for the date: Enter Find Mode [] Insert Current Date [select, "MyDateField"] Perform Find [replace found set] Now, how do I find the empty checkbox? Should I be using a different search technique in the first place? Thanks a billion! -Will

I'm trying to figure out a way I can sort alphabetically ASCENDING while ignoring the Null records. For instance, on a sort by Company, Last Name, First Name, all ascending: The problem is that not all records are attached to a Company, so if I sort Ascending, I have a lot of empty fields at the top of the results. What I'd like to see is the Company, Last Name, First Name, with the Company displayed on top, disregarding the empty Company fields. I'm sure there's a simple solution whcih escapes me. Thanks

I have a calendar in which the dates of the days of the week are calculated based on the month and year, which means there are 31 date boxes (date1, date2, date3, etc). So, for instance, if we're in Sept 2003, date9 = 8 (because it's Monday, Sept 8). If we go to Oct 2003, date9 = 6 (Monday, Oct 6). Now I wish to create a script in which a user can click on the date and see a detailed view of events for that date, but how can I determine the date they've clicked on, short of creating 31 scripts? I've tried GetField(Status(CurrentFieldContents)) and similar, so that when they click on date9, it'll get an 8 if we're in Sept and a 6 if we're in Oct, but that doesn't…

I have a db_search file that has a few globals in it that you enter and it searches multiple files using those values. All of my other searches allow the users to press 'enter' after they type in the field, because they are in find mode of the current file (the one that they are searching). Since I'm in browse mode when I hit 'enter' in a field, it inserts a new line. I can't have it go into find mode, because it's not searching the 'db_search' file. I have it running the script that takes me to the search layout, and pauses it. Then when the user enters the info and click the resume on the status area, (and I want them to be able to hit enter at this point) …

We need a section of this forum just for my questions. The problem is the search/export script. Just to review, it is running on a seperate computer from the FM Server. It runs just in FMP3.0 It is supposed to take an input, search for the record on the Server, then export the data to a tab delimted file. Here is the breakdown: SCRIPT :KICKER Imports data from a text file containing the SSN of the desired patient. KICKER then executes a remote script on CHART which resides on the Server. CHART is the main application holding all the patient data. KICKER copies the SSN, then CHART script goes to the layout, goes into FIND mode, pastes the SSN, t…

Is there a way to name a report within a script? What I mean is, when you run a script to find a list of salesman and print the list. I need to

I have a portal with several fields, let's just say there are 3 fields for example. When the cursor enters the third field, I need to call another script. I have one set up that works except for one problem. Assuming the three fields are labeld field1, field2, field3, and there is a global called field_name: Go to Field ["field1"] Loop Set Field ["field_name", "Status(CurrentFieldName)"] If ["field_name = "field3"] Perform Script [sub-scripts, "field3_script"] End If End Loop I placed the script on field1 so when the user clicks on it, the scfript begins to execute. However, without any pauses, the script freezes up entirely. I tried t…

I have 2 related files Donor.fp5 & Buyer.fp5, related buy the relationship BuyerNumber(Donor::BuyerNumber = Buyer::BuyerNumber). I want to create a summary invoice. I want the report to run from Donor, based on the found set of records. If the buyer purchased 3 seperate items I would like the reoprt to show each individual item, the charges for the item, and the subtotal for the item, and then at the bottom, the total amount due for all charges combinded. (basically a total of all the individual itme net) I know this is possibl, but my md has gone blank. Thank you.

Help.. I have this quirky problem when I run Import Picture from a script; it [usually, but not always] opens the Sound file first. Then I have to cancel that and it will bring up the Pictures folder dialog box to select. This only happens in my script. If I use the Import Picture option from the menu, it works just fine. What I'd really like to do is have the script always open a pre-defined folder where the images will be maintained and then let the user select the image. Also, since this will be a bound solution and eventually ported to the MAC (I'm on Windows XP), the pointer to the "picture folder" would have to be relative to the solutions folder, so i…

Perhaps it's easy but I 'm not able to solve this one. A chunk of text is in the global field "G_Source". The global field "G_split" defines the start/end position of a new record. (a word within G_Source that is repeated) "T_text" for placing the extracted text on a record. [color:"blue"]Loop 1) Create a record and fill T_text with the text from the start of G_Source to the first G_split. 2) Create records for every time G_split occurs in G_Source. Fill T_text on each record with the text between the G_Split, and the next... 3) Create a record and fill T_text with the text from the last G_split to the end of G_Source. [color:"blue"]end loop …

Hi, I need to produce a report that shows counts of field information for all records of a given class ID. For example, I have a field called Polling, the data is either yes or no. I have another field called status, which has different data. I need a report that shows the specific class, with a count for each data element in the different fields. I need this for all the classes. How can this be accomplished? Thanks.

Is there any way to auto enter the current date into a field without using a script. I have a training database that requires a date entry into various fields during the training period. It would make it alot easier if the curent date was inserted when the individual field was selected. I would appreciate any help on this matter. Steve

Since I haven't seen this trick posted before, I'll venture from my lurking and make a post. I've been searching and agonizing for a way to format text in a script without resorting to a plugin, and I finally came up with a trick to do so. The trick is to copy and paste into a formatting field that has a space with the desired formatting. The formatting field is reset at the beginning of the script by copy/paste from yet another formatting field that has a master copy of the formatted space. The final important trick: set the default style/color of the formatting fields to something you'll never use (mine are in puse/outline) so that the formatted space is in a di…

Hmm... So here's the problem: I have two files, one called "LabInfo" and the other "RunningJob"...... In LabInfo, my laboratory writes, in one big textbox-like field called 'tests performed,' what tests they are running on a certain job. what i need is for the Lab to be able to identify which jobs are completed, and which jobs are not... this is easily done by putting radio-buttons off to the side, lined up with each line of my large text-field/box. so, every line of text in the 'tests performed' box has a corresponding radio-button off to the side where they can specify if the test is done or not. what i want to do (and don't know how to do) is have …

I have assigned a script to a button, but when I click the button, I receive the error message that says this script can not be found or has been deleated. HOWEVER, after I click OK on that message, IT RUNS THE SCRIPT. I have tried deleating the button and recreating it, and reassigning the script but I still get the same error message. Any suggestions?

I have three files, A, B, and C. File A is related to file B, and file B is related to file C, but A and C cannot be effectively related. In my layout in file B I have placed a portal to File A and File C side by side. I need a script to create records in file C and insert in those records data from the records appearing in the portal of file A. Thanks in advance...

I want to do a search with exclude. With scriptmaker, I don't able to check the checkbox Exclude or to enter a character in the field to do this. I try "not", "<>" before the value and it don't work. Help me !

hi, sorry for this question, but i'm absolutely new here, and one of my costumers asked me to find an answer to this question: he has a database in fm 4. about 600 fields per record, and in a script he wants to activate a field, where the fields name is written in another field. so, what he did so far was, to run through all fields, always checking (with status actual field) if the name is the same, as the field he is searching for. kinda slow this solution, so he is searching for a faster way to get to the required field. anybody any ideas???

i have a folder w/ about 20 scanned images. each image has a reference id (ei: 0000010340.jpg). i have a filemaker database called images.sjb. i would like to create a script that copies the image reference id (0000010340.jpg) and pasted it into the field called "FileName". once it is pasted, move on to the next image and so on.... should i use filemaker or applescript. newbie to both, so how could i do this?