Script Workspace and Script Triggers

I have a database with a field country. It is a popup menu field with this option: USA, Chile, France, Other I need to make a script that find all record's than match country=USA or country=Chile at once. How can I do it ??

Greetings, I'll try to make this as simple as possible. I'm just now breaking into working with loops, or at least realizing that I could use one here. I would like to loop through a set of records to determine the total qty. of 4 different size binders from one field <binder size> among dozens of clients--each client represents a separate record. (i.e. Client A would have 1 2.5" binder; Client B would have 2 1" binders). I plan on sorting by <consultant>, for one consultant has many clients. I think that I should have 4 global fields, 1 for each of the 4 sizes. These fields should be used to paste the result of the loop calc, right? Basically, what wou…

Okay..... Here we go again... I've searched through to see if anyone has already posted a similar issue but I didn't find one. This question is going to seem so elementary that I hesitate to ask. Still, the dbase must be completed so.. here goes. Currently running FMP5.5 I have a report set up to print mailing labels using the standard template available. Fields are listed like this in the Layout mode. [color:"blue"]<FirstName> <LastName> <Address1> <Address2> <City>, <State> <zip> Everything prints the way it's supposed to except, obviously, <State>. <State> is a text field and, on my o…

I have a form (CY 104 Form) that gets sent to the local police department. On the form, it has a list of the Child's name/info, the Mother's name/info, the Father's name/info, and the Perpetrator's name/info. These fields will be automatically filled in by this script that I'm attempting to create. The information comes from a 'significant other' database that is filled out and includes the victim's mother/father/brother/sister/perpetrator/etc. I want to have either checkboxes or a dropdown (or a combination of both) in the significant other records to display the relationship of the sig other to the victim. If I used a dropdown, I'd also have to have a checkbox for …

When I produce an invoice the line items each have it's own price .I have customers that at times would buy more than one item and we would just add the item to the next line of his invoice and post a message "sold with previous item" and charge him 0.00. I would like to activate this with a button that allows you to automatically add the message above if this item is added on to the invoice. Is this possible?

I need to substitute a script with an imported one. I delete the old script, import the new script and then rename the new script to match the name with the old one. However when I delete the old script any reference to it is lost, and not re-established even when a new script is created (or imported) with the same name. Is there any way to work around this ?? Thank you

How can I write a script to send text from a field in filemaker to MS word and automate the MS word formatting of the text?

Hi, I'd like to create a script that opens a file in MS excel. (Using FM 6 Developer and Win XP). I think that this requires a DDE command. But I'm not sure. And if so, I have no idea what that command is. Can anyone help out? Where should I go to find a listing of DDE commands for other applications. Thanks for any suggestions, Dan

Hi all, I need my script to copy the content of an text field and paste it into a value list. Is there any way to do this? The only option I have found is to have the script open the Define Value List box, but that is not going to do it for me. Thanks, Matt

Hello! First, I must say that this forum is a terrific resource and thanks to all those who have help me and the others with their database issues. Now, I have a scripting problem I think may stump some of the experts, but hopefully not I created a looping script(thanks in part to this site) that creates new records based on a time start and time end and for two different variables, below is the script: Set Field [gnexttime_1, gtimestart_1] Set Field [gnexttime_2, gtimestart_2] Loop starts Set Field [Time Start_1, gnexttime_1] Set Field [Time Start_2, gnexttime_2] Set Field [bus_1, gbus_1] Set Field [bus_2, gbus_2] Set Field [gnexttime_1, g…

I've a script like this: Enter Find Mode[Restore,Pause] Set Field[ "USER"," "=="&USER " ] Set Field[ "Password"," "=="&Password " ] Perform Find[] Most of the times it works perfect: the user types his name/pass, for example: USER: steve jobs Password: 123 then the script changes the request for finding USER: ==steve jobs Password: ==123 If the users types exactly his name/pass then one record is found and the user is authenticated. BUT SOMETIMES.... the script, after finding one record, applies the two "Set Field" to the record in browse mode(instead of applying it only to the find request). Takin…

Is there any script step for toggle between Kiosk-mode and desktop, actually a step for shortcuts Command+Tab/Alt+Tab instead. Thanks,

Greetings: I am working on a custom comic book database for myself. I have the standard fields involving title, issue number, etc., and am working on summarizing everything via each different comic book title (i.e., a list of each issue per title, and the like). This is where I need help. I have a drop down menu listing the different titles. I would like to make a selection from the drop down menu, then after I make the selection, automatically find all comics under that title, sort them according to number, and then display the list in a certain layout. Using the script I have so far, it works, but after I select the title, I have to click to continue the s…

I have two similar contact files. One big, one small. I want to put the records from the small one into the big one, one at a time if I need to. How do I create a new record in the big file, and copy fields from the small file to paste into the big one. I can use a relationship but not lookups because the small file will eventually go away. I've tried a simple script starting in the small file using an external subscript which creates a new record in the big file and then selects a field in the small file, copies that and then pastes it in the selected field (based on the relationship I set up which I'm now realizing doesn't work)

Hello, Does anyone know of any strange reason why my db is not running the opening scripts I specify it to? I have multiple databases under the same conditions, but they run opening scripts fine. Is there like a quirk or something I'm missing? Thanks

Hello All, I noticed in Scriptmaker it is possible to mark a script step with a red square in front of it. Does this feature do anything else but mark the script step ? I can't find any explanation in the manual or help ... (using Filemaker Developr 6) Peter

For the Filemaker gurus out there, a simple question: In an address book db, I'd like to have a row of buttons corresponding to the letters of the alphabet that when clicked jump to the record that has that letter as the first letter in a specific field (LastName). Sort of a shortcut to that section of the db. I'm sure it can be done with a script, just not sure on the specifics. Any ideas? Thank You for your time, lokimann

Hi y'all I can't think straight anymore and hope somebody out there will help me even if it looks like something real simple!... I have several databases with relations Main is an order-entry database - this contains a repeating field where the user can choose (using look-up) a 'production-type' (a description for the type of work being done); this is then copied from an other 'code'database that contains that productiontype as well as the price for that (those are non-repeating fields) In my main database I want to copy the price from the 'code'database's price field into the main's repeating price-field as soon as the productiontype is chosen . I just…

My scheduling application is based on several pieces of equipment and the jobs which are assigned to them. A user can click on a day and see the jobs and hours associated with that piece of equipment... here's the dilemna. Jobs which are alike (i.e. same colors in the job) only require the machine to setup once and all of the like jobs can be completed. However, some days there are many unlike jobs (i.e. some have like colors, others do not) and require the equipment to setup several times at 6 minutes per color change. Because the schedule changes so much, can someone suggest a way for a script to set color criteria for job 1 and base al of the other jobs upon…

is it possible to create a dynamic field size based on the text it contains? Thanks, Evan C

Which, in your experience, is faster: Replace Contents or Loop? I've run some tests, and over a network they seem to be the same. Running on a local machine Replace seems to win the race. The database I'm working on contains a hierarchical list of records, and functions similar to the Finder in Mac OS: click the triangle to toggle records open & closed with in the hierarchy. The problem comes when I run a script to show all, or hide all. The field which indicates how the triangle is to be displayed must be set to either 1 or 2 (depending on whether the records are being opened or closed) for every record displayed. This can be a quite lengthy process, when…

Is there a way to force FileMaker to open a new window when a button a selected. For example, the user clicks on a schedule for jobs for a specific piece of equipment. Currently, I have a button where if they click on a record, it changes views and shows details about a particular job... but not though a new window.. This would probably be easy through applescript. However, almost all user are windows. I want the user to click on a button and a new (additional) window appears where edits can be made and the data would be updated so that when the additional window closed, the data in the original window would be accurate.. Makes sense?

I have a script which is designed to omit records from a search that do not meet a certain criteria (see below): Go to Record/Request/Page[First] Loop If ["Count < Max Count1 or Count1 < Max Count2 or Count2 < Max Count3 or Count3 < Max Count4 or Count4 < Max Count5"] Omit Record End If Go to Record/Request/Page[Exit after last, Next] End Loop where the Count fields are calculation fields counting how many times a certain word appears in a field and the Max Count fields are user-inserted text fields When I run the script it only Omits some of the records and I have t…

Hi gang, Just a quickie, because the solution escapes me just at the moment. I have a global field (gproduct_code). What's the most efficient way (i.e - without using a loop script step) to check if my TEXT field called product_code doesn't already have a product code that matches what's in the global field. Trying to keep fields unique, thanxs, hope it all makes sense. Steve Griff.

Hi I would like a client's choice out of a list to set a value in a field in another database - I would expect to do that with a script, but I can't think of any way to let that script start when the client makes his choice (FM 5). Is there any way to do that??? hans

i'm making a filemaker file with a list of people. each having a username and pasword (among a lot of other things) a part of this database i will be uploading to a mysql database on a webserver (with a simple seperated list in txt format). I'm making the filemaker thing because the webinterface has only got a small portion of the information. but the webinterface will be using the loginname and pasword from the user file to let people log in. my question ---------- can i encript the paswordfield? with a script when I'm exporting it to a seperated txt file. (so i don't send the paswords onencrypted over the web) how can i make a generate pas…

Hey all, Sorry, I've already posted a question that is very similar to this, but I don't think that I did a very good job explaining what I'm trying to do. So, I'm starting a new post, and I'll give you an example that is very similar to what I am doing... I have two FMP files, Company and Customers. The Company file is basically just a list of companies. The Customers file has a large list of customers, and each one is assigned a company (for the purposes of this example, there can be multiple entries of a customer with a different company name). The Customers file has a relationship with the Company file where it pulls data from the latter file. …

So let me explain the situation here: I have a whole database with different layouts, on the last layout, I created a button to validate all my informations. But I want that button to export 2 specific layouts into a new file (which would be the historic). How can I export those informations into a new file? (what type of script should I use?)

Hi all, I don't know if this is possible or not, but I don't see why it shouldn't be, but is there anyway that you can put a database field or a calculation result into the "Show Message" step? At the mo I can only put static text into the field. It ain't very flexible, Any help would be most appreciated. Steve Griff

Sorry for the newbie question, How do I concatenate the fields last name and phone number in my client file to make a client ID field ? Thanks for your help!

I'm not sure of the correct terminology but I want to do the equivilent of clicking outside of a field (to exit a field so my script works properly). I'm pretty sure I've read of a way to do it but I'm not sure how to search for it.

For some reason, I can no longer get the DIal Phone script step to work. When I click on a button that has a Dial Phone script step, I get the "Hang up you modem" box, but no tones are sent to the phone. I know the modem in my B/W Mac G3-350, running OS 9.2, is working, because I can send faxes with it. This feature was working until I had to do a disk rebuild (from the bottom up - new installation of all OS and application files). The modem is set up as ATQ0V1E1S0=0, Prefix is DT (I'm using this on private line), Hang Up is +++ATH, speed is set at 28800 (highest one available in FMP 4.0). It's frustrating because I have grown very accustomed to th…

I have a script that is very simple that when the user clicks on a button it adds their username, date and time to a comment field, the next person that comes into this record it adds their comment to the bottom of the field and so on...I would like this text to be in a particular color can I automate that? I dont want all the text in this field to be that color just the text they are adding by performing this script. Any ideas?

Sorry, I know this isn't the most appropriate place, but there doesn't seem to be one and I know you guys live in this part of all the forums! Anyway, does anyone know of any really good Word/(other msn product?) developer's forums that give good advice/feedback as this forum does? To date I have found many forums but they are not advanced enough for my sort of queries. Maybe even a forum in advanced VB Scripts would be good. Also, since I'm so out of it, I thought I might raise it here anyway Have there really been any advances in encryption of documents. As a law firm, any document we send out needs to be as difficult to edit as possible. The protect fun…

I have a list of options an order can have each option is a value list with multiple options. (for example: option 1, option 2, option 3) now i need to make a total of this order (knowing that option 1 is ?40, option 2 is ?20, ... , but the name of the option doesn't include the price). So i think i need a calculation with "if" "then" commands... hope this is clear

Hi everyone! I've been presented with a problem I can't figure out. It's driving me nuts! It must be simple! If I have a checkbox (Value List "Yes" and "No") and, if the value is changed to "yes", I want a DateCompleted field to insert the current date. I've created a transparent button and placed it over the checkbox and my script is: Script Name: Set Completed If [Problem = "No" or Problem = ""] Set Field [ Problem, "Yes" ] Set Field [ DateCompleted, Status(CurrentDate) ] End If Else Set Field [ Problem, "No" ] Set Field ( DateCompleted, ? Exit Script How do I set a date field to blank if the User changes their mind! …

I'm trying to prevent distribution of my solution I'm finishing. I have a installer that require a serial and have put the same serial call when they open the solution for the first time. The solution is then set and is not calling for the serial the next time. There is no limit, to my knowledge, that it is just to copy that serial set solution over to another machine and use it with great success. I thought about a step and hoped for a Status() parameter that could give an unique machine ID into a field for any kind of verification formula in a startup script, but could't find one. Maybe there is some other workaround? Thanks,

Hi, In my database, I have a report that shows every record in the db. Each record has a status associated with it, which is assigned from a value list. There are about 15 different status options. What can I add to a script that would show every single record EXCEPT the records that have a status from one particular value in the list? For example, I'd like my report to display every record except for the records with a status of "No Action Required". Thanks for the help.

Hello All! I know this is simple, but math was never my best subject. I need to create a looping script that adds 1/2 hour base on a start and end time. I use global's and set fields to set up the script. The problem is with the counter, here is the script: Set Field [gnexttime,gtimestart] Loop New Record/Request Set Field [timestart,gnexttime] Set Field [gnexttime,gnexttime (this is where I need help with the counter to increase the next time by 1/2 hour)] Exit Loop if [gnexttime>gtimeend] Any help is appreciated!!!

Hi all I have a program that calculates welders repair rate. Once a welder repair rate has been calculated for the month, a script is run and the information is deleted to calculate the next welder repair rate. I would like to save this information now to a second db. The second db has fields for each month of the year. I would want to transfer the repair rate percentage calculated only to the second db for each month automatically. I have made a relationship using the welders stamp and have checked the created a related record and use the set field command to create a record in the second db. This is what i have tried sofor in a script: set field["pwr","isempty(jan)"…

Is it possible (via Status(CurrentError) to suppress the standard dialog when trying to open FP3 files in FP5.5 and automate the conversion process? In other words, prevent message from showing, convert the file to new format and place it on same volume as current (fp3) location?

Hi Everyone! Well, for goodness sakes! Either I dislike the way FM (doesn't) show what is stored in a scripted Find, Sort or Export ... or ... I'm missing something here. It drives me nuts not to know what has been stored in these three script steps. Wouldn't it make sense to include a comment line before Sort, Find or maybe even Export - identifying what has been stored? For instance on sort - the sort sequence: Customer(A), ServiceDate (A)? Well, I've never seen a script which lists the sort order so it's quite possible I'm misunderstanding an important point! Can someone clarify for me before I start adding comments in this way? LaRetta

Hi there, Does anyone know about a scriptstep to autoplay QuickTime items so it would work on both mac and win? Would be nice not have to think toward Director. Thanks!

Hi, I have a drop-list which has a relationship to another file. The file are as follows Course file which has Org and Department Department file which has Org and Deparment Relationship Course:Org->Department:Org I grab the value from the droplist from the relationship:Department field. Such that my department relies on the value selected in the Course:Org field I have a add "others ..." to allow entry of new item. How do I after input an "Other..." value, allow this value to appear as in the drop-down for selection for the next time

I have a field which is populated by a script that dynamically has the dates for the next two weeks. Users can select a date to produce a job from this field as a popup list. This same filed exists in two other layouts as standard fields. Today when I logged into the database (Which is running on Filemaker server, WIN2K) all of the layouts which contained the popup menu had the same listed for every record. The layouts which were standard, showed the date which was selected earlier. Can anyone suggest why this field might have changed so that all records have the same date. This is an odd question, but nobody knows when or how this occurred or how to prevent it…

Hello I have two file maker databases. I would like to make a script that takes data from a feild in one database and uses this data to search the other database. Does anybody know how to do this? Best wishes

I need to make a simple script to find the records that have a field with a number greater then another number. I.e. (fieldname) > 1000. Or have it omit records that have a specific field empty. I.e. (fieldname) <> "". I can make FM do the FIND and get what I need but can't get the scriptmaker to do the same. I am very frustrated with FM because it is nothing like SQL. SQL is so easy with select statements. I thought ever db used the "*" as a wildcard. FM doesn't even like that. Help.

Hi everybody, I have a problem witch i can't seem to fix...I hope someone here can help me! I have 5 loose fields with a purchase price (purchase price1, purchase price2, etc...etc) witch are populated and 5 loose fields with a sale price (sale price1, sale price2, etc...etc) witch are not populated. Next to those fields I have a total saleprice field witch must be higher/same than the sum of the 5 fields with the purchase price. When I fill in the total sale price field, I want to run a script (or even a caculation in the 5 sale price fields) witch devides the total sale price over the 5 loose sale price fields. But the hard part is that the price that is…

Hi, I'm trying to make a script that will take a user back to the layout that they previously had been on before arriving at the layout which they are currently using. Is there a way to do this? It seems that if a user's layout could be recorded in a global field, then returning them to this layout might not be too difficult. Am I barking up the wrong tree? Is this possible at all? Thanks, Dan

I am using FMP 5.0v1 with Win 98SE. What I'm trying to do comes pretty much from the FMP help files, but I can't get it to work. Here's my script: Enter Browse Mode [] Go to Layout ["Student Entry"] Show Message ["Repeat the last find?"] if ["Status (CurrentMessageChoice) = 1"] Modify Last Find Pause/Resume Script [] Perform Find[] Else Enter Find Mode [Pause] Perform Find [Restore] End If No matter how I tinker with this, the script ALWAYS performs the last find (the one that was in effect when I defined the script). HELP!!! I am thorougly frustracted!

Is there any way to run a script step by step so that you can see what it is doing?

I'm not sure if this is a common problem or not, I couldn't find anything else here - but it could keep from having to rewrite an area of my system. Some background, I have an standard order/invoice database. When the order comes to the stage were it is to ship. The user is prompted sequentially if they want to make one of four different shipping forms (Customs, Cargo Manifest etc etc). The forms are in another database and are edited in 4 different layouts in that database. As well, the forms database is accessible all the time since each order can have more then one form of each kind. When the user clicks a button to run a script to do all the shipping stuff i…

Sorry I've posted this before, but I am unclear... What is the most efficient way to show data in a new window (I understand FM uses only one window per file). I have a schedule which shows a list of jobs. When the user clicks on the job, it changes layouts and show the details of the job. Unfortunately my app is a little clunky and requires too many buttons to get back to the place prior to the job detail. I need simply for the user to click on the job detail and have a new window (file?) open which has the appropriate data. I also need to have the ability for the user to change data in this new window and have it dynamically update the data in the original fil…

Hello, I am fairly new to FileMaker but do understand the basics. I need to write a script which can delete old/aged records. So for example, if there is a post submitted today (and subsequently a record created for it) then after 7 days (say) I would like the script to delete the record. I looked at scriptmaker and the various control functions etc. I think I know how the control structure may look like but am not sure how to check the age of the record. Any ideas on how this can be done ? thanks!

Have a filemaker file called startup that has a few buttons that run scripts and all they do is open different hosted files. i.e. Button A from startup opens hosted file A. Button B opens hosted file B. etc. Now when this script is run and the hosted file isn

Anyone else have this problem? I have an automated email shipping confirmation in my DB, and although FM appears to run it just fine, no message actually gets sent. I've rebuilt the script, re-assigned Mail as the primary email program, etc. John

I have a portal in a database. The portal has been set to delete records. I have placed a button in the portal in each row that has been set to delete portal row. But when I hit this it not only deletes all rows in the portal in deletes the entire record that is related to the portal table. It is an orderform - product items type situation. So I just want it to delete a product item from the orderform, but it is deleting the whole orderform record. Has anybody come across this? Or am I doing something really obvious/dumb? Thanks for any hints you can give me. Cheers, Chris.

I am in need of help in designing a script that will log incoming and outgoing telephone calls in FM 5.Any ideas? TIA

Want to let user type password one time and the solution shall contain over 1000 passwords, which enable the app after their valid pass. First time it is asked for the password which bypass that password layout the next time. I put all the passwords in a Case() formula, but there seems to be a limitation on how many results there can be in a Case(). It will not accept all of them. But I get all passwords in a valuelist and for me it seemed right to try formula, ValueListItem(dbname, valuelist) in a If ["passwordfield = ValueListItem(dbname, valuelist)] Iam not able to test this because it won't recognize my current dbname. Would this work at all,…

Can anyone tell me if it is possible to script a button such that it changes the value in a field each time it is switched (like a logic switch)? What I want is for the field value to change from 0 to 1 (if it is 0) and change back from 1 to 0 the next time it is clicked. I know I can do this with two buttons for each choice, but I have to need a lot of them, and it really clutters up my layout. Thanks,

I have a program that has calculations that require scripts to activate them. Example: "select_rate" script If["rate_code = "4"] Perform script[sub-script, "rate_misc_1"] Halt script End If If["rate_code = "5"] Perform script[sub-script, "rate_misc_2"] Halt script End If I have about 20 of these if statements running in the "select_rate" script "rate_misc_1" script Enter browse Mode set field ["rate_misc_1", "price *.10"] rate_code is a calculation that states if the name of the rate is "name", then use this Code #. Example: Rate = "10% Min 100", 2 Rate = "10% Misc", 4 and so on. The rate_code is based o…

I'm trying to have the city and state fields in a clients file populated automatically by zip code, which I have working using lookups. The zip codes and their corresponding city and state are all stored in a separate zipcode file. But I wanted to add on some additional functionality by having the zipcode database self update. Whenever a user enters in a zipcode in the zipcode field in the clients file, and tabs out of it, i have a script that kicks off. What I want the script to do is to check if that zipcode already exists in the zipcode database, and if it does not, prompt the user to create a new zipcode record in the zipcode file, and then bring the user to a la…

i don't mean this in the simple sense of defining a field to repeat so many times... i already have that. What i am trying to do, is have a user define how many times he/she needs to have a field repeat. Printing company... going through a job spec. they need to define options for the 'job part'(cover, text, etc.) each 'job part' has the same options through the a value list. So, i have a field next to the field name 'job part' where the user can input a number, 3 for example, and that will define how many repeating fields occur under the 'job part' field. does that make sense?? i have been through one very mediocre book, and one much more extensive book, …

I have a field in my database into which a bar code number must be typed. The number is always 13 characters long I want to attach a script to the submit button that basically says if there are less than 13 characters or more than 13 characters in this field flash up a message saying "the bar code must be 13 characters long". I'm sure it's dead easy but I can't seem to fathom out the steps or language I need to use. Heeelp Graham

Hello everyone, Here is my question: I have two number field, Number1 = 2 and Number2 = 3, and a text field Formula. Is it possible to enter, for example, the text "Number1 + Number2" in the field Formula and to make it react like a calculated field to have the result (5 in this case). In other words, is there a way to change the value of a text field to a calculation?

Does anyone know how to pause a script that has an external sub-script called from within it. I don't have a problem running the sub-script but the database that has the sub-script requires the user to change/add info. Once they are done doing that I need the original script to resume what it was doing. I've tried pause but that only works for a certain set amount of time. Thanks.

[color:"purple"] Here's my problem . . . I want the mouse to change either color or to a hand icon when the mouse is over a button. My layout has some graphics for buttons, so I want to make sure the user knows he/she can click on it. Another route I'm willing to go is having the button change somehow (underline/change color/outline) to signify it's a button. I've searched all the resources I have and I can't find anything. Can anyone help me??? Sabrina

Got myself stumped, can any of you Filemaker wizards help us out? Question: As part of a project billing db, I've got a starting time field, a stop time field, and a result field that shows the difference. All good so far. What I'd like to do is round the resulting time to the next 15 minute increment. I found the Round function in the Calculation dialog, I just couldn't figure out how to implement it. Help, please! Bonus question: The start, stop and result fields are in another file that is shown in a portal. This lets me enter unlimited instances of time periods for each project. (So I can do bits of the project from time to time, and it still shows o…

I'm trying to create a report which will put the number of found records in a global field within the report layout. I also need an average rating from a field in the found set to be put into the report. Both of these problems seem easy enough when working over all the records in the database but not when working on a found set! There is probably an easy enough answer to this one so a script pointing me in the right direction would be much appreciated.

I have a script that does the following:- Set error Capture [On] Open [Open Hidden, "Colleger Register"] if [status(currentError)=0] SetField[Register Online Status", "Online"] Else SetField[Register Online Status", "Offline"] End if The script works fine most of the time, but occasionally sets the field to "online" even when the "college register" file has not been found. In other words Status(CurrentError) is returning 0 after an error on open. Anyone any ideas?

How do I use the "insert a calculated result" field in a script to show the result in a database?

Hi everyone! I have a script which opens with a splash screen. Everything works but I can't get the window to center on the screen for the 4 seconds it should display. The screen is approx. half size. Is there any way to make the window center instead of appearing at the top left? Script is: Open Go to Layout [ Splash ] Toggle Status Area [ Hide ] Toggle Window [ Zoom ] Set Zoom Level [ 100% ] Pause/Resume Script [ "0:00:04" ] Go to Layout [ Main ] Toggle Window [ Maximize ] LaRetta

Hello I am trying to make a quiz that any teacher can use. Meaning they type the question and answer and the solution will automatically grade the test. I wish to do this without hard coding the answers. Maybe having the answers on another database and having the test database cross reference the answer database. Any help would be greatly appreciated.

All of a sudden, a script I've been using as gotten much slower (what once took seconds now takes about four minutes or so). The script creates a new record in another database, and copies fields from one database to the other. What might be messing things up? (Freeze window doesn't help fix the problem.)

Based on ideas from these forums, I have created aliases on all of my users desktops that are for opener files. These opener file consist of a script that opens a hosted database and then closes itself. This works nicely except for a one thing. If the target file is already open but hidden or minimized, the user thinks nothing happened. How would I script it to open a file that is open but hidden?

i'm running 5.5 on windows xp. there's no network, only one machine. i have a total of 4 db's, and i have scripts(buttons)to navigate between them all. the problem i'm having seems to be random, it comes and goes, altho i'm sure it's something i'm doing that makes it happen. in each file, i have 3 navigational scripts that open a different file(one script for each of the other files). eg: in file one, i have these scripts: open file 2 open file 3 open file 4 in file 2, i have: open file 1 open file 3 etc. the problem i'm having is that mostly one--but sometimes two--of the files won't open from each other. the message i get when i try to go f…

Saving a search query. I would like to keep a log of what poeple have searched for is that possible?

I'm somewhat of a newbie (or at least I feel so asking this question) at FMPRO. I used to use it about 5 yrs ago but have forgotten much of what I learned. I am looking for what would generally be known as contact mgmt, but things that can be particular to political campaigns, such as values/rankings, geographical areas, cross references with other fields.

Perhaps this is a bit tedious, but I hope someone can help me out... I have a Tasks DB on a macosx and a Projects DB on a PC. I've created a web form so that webusers can enter new task directly to the Tasks DB. However, the requirement is that a task cannot be created UNLESS the webuser creates a new project record first (because there are other DBs that also link to the Projects DB). I'm running Web Companion on osx. Is there a way to perform the above functions by using scripts? If so, how? Thanks a lot.

I have a field in my [Contacts] file called

Hi I have a database that I use at work and one of the tasks I have to do is print out a list of jobs required for the day as well as a option to select yesterdays list or tomorrows. I would like to set up a script that will do this for me. Is this possible and if so how do I go about this? Regards Peter

I am trying to write a script that finds a range of records between StartDate and EndDate fields. I have a Date Created field which is what I wound the search to be done on. I tried using this: Enter Find Mode [] Set Field ["Date Created", "StartDate"] Paste Literal ["Date Created","..."] Paste Result ["Date",EndDate"] Perform Find [] Like the June 5 post from ZuperZZ suggested, but I quickly found out that my version of FM does not have the Paste Literal command in Scriptmaker. Am I missing something (i.e. I'm stoopid) or is it really not there.. Or is there another way to achieve this? Thanks to all who reply.

I want to be able to run a script that says: If(Code = "1") Perform Script["Dealer Min 100 Max 200"] Halt Script End if The problem I'm having is creating the script "Dealer Min 100 Max 200". This script will contain the calculation: If(Price < 200, "Price * .50", If(Price >= 200 < 1000, "100", If(Price >= 1000 <= 2000, "Price * .10", "200"))). How do I put this calculation into a script? Dobbers

I want to script copying the email adrs from all records of a Find and paste to either a new email or some other doc so that I could make a mailing list. Any ideas for this one.?

Hi to all Can some please help me with this? I have a dropdown menu that lists 4 different types of address i.e. postal, billing, shipping, and street. Depending on which the user selects (example If["edit_address = "Billing""] Set Field ["layout_name", "Status(CurrentLayoutName)"] Go to Layout {"billing_address_edit"] End If I have used a global text for layout_name Now depending on what the global text field is set to I what to go to that layout. Is this simple to do, as I am very new to Filemaker. Thanks for any advice or help with this Craig

The database I am designing is set up for a 15" monitor. Meaning that all of my layouts are set up that way. So if someone has a 17" monitor or larger, the layout stay at 15". I appreciate your help.

Ok.. I have a whole heap of records. defining field is tower - highrise or skyrise. From the main menu they select say "highrise" this then performs a script of Perform find [tower=highrise] Goto Layout I need to be able to script a constrained search so that they can search on whatever field they like, but it will only return that search within tower=highrise. I just created a button/script which only line was Modify find and this seems to work??? sounds all too simple to me??

Oh, this is very exciting to learn! Thanks to DJ, I found out that using Set Field (with anything) will remove a $ from a numeric field. Well, that got me to thinking about why it worked. And then I realised that it had a much greater implication in terms of handling mixed-data fields. If I am dealing with a numeric field that also holds text (either because of an import from a text file or from changing a field definition), it is possible to

Hi everyone! I am importing a set of data. My fields are number. The data is listed as $73.15. I have written a script to remove the $ and change the amount to a minus. The script does remove the $ but doesn't add the minus! I assume it's because my fields are numeric? Any suggestions on how to accomplish this? GoTo Record/Request/Page [ First ] Loop Set Field [ Charges, Substitute( Charges, "$" , "-" ) ] Set Field [ AmountAllowed, Substitute( AmountAllowed, "$" , "-") ] Set Field [ Payment, Substitute( Payment, "$", "-") ] Set Field [ CoPay, Substitute( CoPay, "$", "-") ] Set Field [ Withhold, Substitute( Withhold, …

Problem I just received over 10,000 student scores from a state required test. The scores go back to 1997 to 2002. There would not be a problem putting the scores into a field except some students pass the test the first time and others may try to pass the test a 8 different times. (with a different date for the test taken. I need to create a loop or way to mark each test with a seperate mark for each attempt to pass the test. I would like to use an "a" for the first time the student took the test, a "b" for the second time, etc. I also have indicators for a pass-faill. If the student passed the test on the date the record gets a "ps" if failed, "xs" I thin…

I am trying to copy data from a field in another file and paste it into the current file using a script. The data doesn't load into the clipboard in the following windows example: Create two databases, name one 'COPY' one 'PASTE' Create one field in each, name one 'NAME' in the 'COPY' file, name one 'ID' in the 'PASTE' file. Enter sample data into the 'NAME' field of the 'COPY' file. (e.g. FRED) copy some junk into the clipboard (e.g. hhhhhh) Define a relationship in the 'PASTE' file named 'copypaste' 'NAME=ID' Create a script in the 'PASTE' file named 'pastefrmcopy' script line 1: Copy[select, copypaste::NAME] script line 2: Paste[select,"ID"] run sc…

Hello I have a database with about 253 records. How can I sort them in such a way that it only shows me the 6 more recent ones in a layout. Thanks in advance Pablo Ramirez

Can someone help? What I want seems pretty simple but I have no clue on how to do this. What I want is a database that have a drop down box that have different software names in it and when the user select the name (a example being Outlook) it will open the folder with all the tech notes pertaining to Outlook. I have the field and drop down box made but I do not know if I need a script or what I need to accomplish this. Thank you.

Hey all, I have been working really late on a project, and I'm totally having a brain fart. I just need some advice from anyone as to what is the best method to develop my relational DB. Let me briefly explain my situation and that should help demonstrate my problem. I am designing a Contacts DB with the contacts for music publishers. This is a fairly simple DB with the exception of the large publishers (such as Sony and EMI) where they have roughly 30 sub-companies apiece. For a big company such as Sony, we will have the exact same contact information for both Sony and the 30 sub-companies that it owns. What I want to do in my relational db is enter …

I would like to know how I can use different keyboard keys to run a script. I have checked the boards here and no mention of it. I saw one Filemaker solution, called PayGo, that uses the function keys (F1, F2, etc) to run scripts with one key press. How do they assign a function key to a script? Thanks

I currently have a database using only one layout but many many records. I have a button which, when clicked, opens up adobe acrobat reader and opens a pdf file from outside of the database. My problem is this; that button only opens up the one pdf file it is set for in that one layout. However, every record will need to point to a new pdf file. [color:"blue"] FYI every record is a company, so each company has a unique pdf brochure and/or description.

How can I assign the "F2" key so that it runs a script

Hello everyone, I'm relatively new to FileMaker (particularly the scripting end of it) and have been learning quite a bit from the forums here over the past few weeks. And although Ive searched these lists repeatedly, I'm having problems getting a script I've been working on to function properly. This is what I need, I hope someone can point me in the right direction: I am basically finished creating a database for a primary care/detox facility, except for one thing. Among various other fields for patients' names, complaints, date of admission, etc., there is a field for the date of their initial Medical exam and a date field for their initial Psychiatric exa…

Hi I

Hi All, I am trying to generate a script that will perform a sub-script based on Status(Currentfieldname). My script so far is Enter Browse Mode Go to Layout [National Report Summary] Set Field ["Prob_group", """"] If ["Status(CurrentFieldName)="Tot_P_sent_pakg""] Perform Script [sub-scripts, "whatever"] End If The sub-script works fine and returns the value I want, the current field is a summary field showing the total of a calculated field. I have not used status functions before and am not sure if I am on the right track. The objective is for the user to click into a field and run the right script. If they click into a different …