Script Workspace and Script Triggers

Well, I'm stumped. I am trying to convert a text month to it's numeric equivalent, then concatenate that number with the day number and year, and convert the whole text string to a date, in date format. The script works fine for the first iteration of the repeating field (there are 10 repetitions), but I cannot get it to work for any other! Suggestions anyone? Here is the first iteration of the script. The other iterations are identical, except the Loop Count is set to 2, then 3, etc. And the the Set Field is matched to the appropriate repetition. Go to Record/Request/Page [First] Set Field ["Loop Count",1] Loop Set Field ["Month Numeric r", "Case( Ge…

I have created a script to build IP addresses when creating a network. The script utilizes a field called IPserial which is set to auto enter a value starting at 1 and incrementing by one until it reaches 254. these make up the last digits of the IP address. However once all number have been generated i would like to reset the initial value to 1 so the next network i build i can simply run the script. My question then becomes: Is it possible to reset the auto enter serial number via a script step? thanks in advance for any help

I am trying to dynamically display details (meaning in the same layout) for an item in a portal by clicking a button. It is hard to describe with words so I have included a link to a screenshot below with some notes. If anyone has a moment to look at it and tell me what I might be doing wrong that would be just awesome. Thanks so much. http://homepage.mac.com/tjwett/screenshot.gif

Hi all- Wondering if anyone had a thought on how I could make a field's color change based on evaluating another field. That is, if Field A is "1" then Field B turns green (in a specific layout). If Field A is "0", do nothing. Can't seem to find a function in either ScriptMaker or in the Calculation functions. I appreciate any advice.

Hi! here is my problem. i have four files: products, order, customers and line items. this is a simple invoicing system. However, i need to post automatically to all clients an order for existing products. I need a script that would take from inventory of one item (jars, for example) where i have 1000 and divided among some 100 stores/warehouses. it is the same as a regular invoicing only i make the decision of what product each store gets. Once i go through the list of items in inventory i wish to print the client's order (or invoice). i hope i'm clear. thanks

can someone advise how? i need a script which will add new recorde in a portal. the first portal field has a lookup to another file (client list). i need the script to choose client 1, and then go to the second field where there will a calculated value for quantity... new record in portal,client 2, field two....

seems like as it hides the status area, it doesn't adjust properly so that i don't see the whole report.

Can I generate a script to: find all records then email the records to a specified address Thanks, Rick

Hi, Trying to use 7's built-in custom message script step to get two values into a pair of global fields... strangely, it's not storing them. I'm definitely in browse mode, but the fields stubornly refuse to accept data. Any ideas? Is this a known problem? (BTW, I'm using 10.4 - Tiger ... somebody probably wants to update the popup for posting)

i hope someone can help with this. third posting. how to add records in portal using lookup. that is, selecting every record in lookup. i have two fields in the portal the first is a lookup to a client database, the second is quantity which is a calculated value. i simply want to have one script which will add all records from lookup and insert the calculated value in quantity. thanks in advance. ron

I'm really intrigued with the GET(SCRIPTPARAMETER) function, but I can't figure out how to create the scriptparameter in order to GET it. The HELP files discuss how simple it is to Get and use the script parameter but they don't do such a good job of telling how to create the parameter. Can anybody aim me to a discussion of this concept? Thanks.

I am new to scripting and I am trying to create a script that will return all records that have an expiry date less than 28 days away from the current date. I have tried half a dozen different ways with no success. It is the last script I need to creat for this current project. Can anyone please help before I throw my computer off a very high cliff.

trying to use eternal calendar file to set the date in a field. have a layout with calendar icon; click on it calendar layout pops up, select date neeeded, click submit button, adds the date to the date field, script works fine as is, a lot of else if statements with scriptparmeter vaules, issue everytime you add a date field have to add that to script. would like a way to use pattern count or something like that to get the field from the scriptparameter to determine which field to set based of that info, so when adding new fields do not have to add them to script just dynamically added.

Hi. I'm just getting started with Filemaker and scripting, but am already finding the menu-based scriptmaker a bit tedious. Is there anyway to write scripts in a different editor? Thanks for any pointers. -Chuck

Hi can someone please tell me if there is any way to get the current user password that they use to login to the database - I can't see anything in scriptmaker to do it ta!!

I am a newbie at scripting. I need to be able to assign a script to a button that will enter find mode, allow the user to enter criteria, then sort the found records in descending order. I get the find and sort to work fine but no matter how I sort before I write the script I can't get them to sort in DESCENDING order. I'm sure it's simple and I would appreciate anyone's knowledge. Thanks.

I feel stupid here, but Hey I admit to being new. I am performing a script that does a simple find in a layout. Its a subscript and I throw it a scriptParameter. The scriptparameter is being passed correctly (I checked). I want to perform a find with that scriptparameter as the Find Request. Here is the subscript I am using. Go to Layout["Tasks"(Tasks)] #this checks to see if the scriptparameter is being pased Show Custom Dialog ["ScriptParameter""; Get(ScriptParameter)] Enter Find Mode Perform FInd [Restore] When i am in the Edit Find Requests Dialog and I chose the criteria I want to use the scriptparameter as th…

I have a script that sends the user to a pop-up value list. The next step in the script is: (Pause/Resume Script[indefinately]) After the user has made his/her selection from the value list, I would like the script to resume without the user having to engage the blue CONTINUE button on the left sidebar of the screen? How can this be done without additional button clicking? Thanks, Jarvis

Hey, In a search script i want to delimit my search by giving a criteria directly in a script in if condition from field in another related file instead of putting data in the field in current layout, how can i do that. Thank you.

I am working on an office management file for myself (and maybe others) and find that I am gathering too many buttons to launch scripts. Some of the scripts are somewhat related. Some time ago I read about using a pull down menu to do this but I can not find the information again. Anyone have any advise or directions either on how to do it or to the information. TIA

How can you use in a script to go to record via a record ID. It looks like the go to record script wants to use record number, but for my script this is not the best solution since it's based of the # records shown. Thanks Devin

I've asked this question in different forms before and never got a satisfactory answer. If anyone has a suggestion I would appreciate it because my problem cannot be unique. I have a layout which contains fields from a single TO and a portal which contains related records (it is a one to many relationship of client and client phone numbers.) The user wants me to pre-load data into two of the portal rows. Now I would like to automate this as much as possible. The user wants to tab through all of the fields including the portal rows. I have found that if I invoke a script to pre-load the data into the portals, it triggers the validation rules on the main TO. If I…

I have a table Entries, with fields like Title, Body, etc ... and a table Constraints, with Title.length , Body.length, and so on. I want to have a script check the entry records against the lengths specified in the constraints table, and lt the user make adjustments. The necessary relationships are present. The script I worte looks like this: Go to Related Record [ Show only related records; "Entries" ; Using Layout "Entries.by.Body" (Entries) ] Set Error Capture [ On ] Go to Record [ First ] If [ Get ( LastError ) ] Halt Script # because there are no entries to check End If Loop If [ Length ( Entries::Body ) <= Constraints::Body.length ] …

To start off, I am still pretty knew to FM7 and even newer to scripts, so if something is written wrong I am sorry. Anyway, in my DB I am trying to make a report that will list all our open orders at any one time. I have it set up right now with just a simple radio box ("Job Complet Y or N") that needs to be updated manually when a job is completed(which is a little clumsy but best way i could think of; would love suggestions on that). I set up a script that will work(once) but when I would go list all records, run it again, it would list every record regardless of what was checked. I have two expenations I think can explain it. First, is that I'm setting up my l…

From a main file I have a script that initiates and import script in an archive file for a specified table in the main file. I need to move to a new table and repeat the import from the archive file. The concern is posible conflict if the first import process is not completed. Is there a way to insure the import is completed before the main scrip initiates the next import? I'm considering using a fixed delay in the main script. But that is no guaranty. Can the script in the archive send a resume trigger when it completes its import that tells main script to continue? Also can I pass a script parameter such as a table name from the main script to the archive script? …

Any help or suggestions appreciated..I have searched hard and solution is elusive. thanks

i'm trying to write a simple script that allows me to set a field by combining the contents of 3 other fields, all separated by carriage returns. when i try this script: Projects::Current Status Date &

I have a report-generating script that exports data to a temporary FP5 file and ultimately creates another, uniquely-named FP5 file containing summary records. It works fine in a single-user setting (where FM Server 5 isn't involved) but when I deploy it on the server, the attempt to create the temp file fails. I'm guessing this is because the server prohibits the creation of files, at least under some circumstances. The location of the temp file doesn't matter to me; as far as the summary file is concerned, ideally it would be put on the client's computer but it could be stored somewhere on the server for the client to retrieve manually. What approaches have …

Hi, I'm relatively new to filemaker, so please bear with me if this is a stupid question. I've searched extensively online for Filemaker tutorials and have come up with next to nothing. Anyhow, I have a database of part numbers. they are either 30-xxxx or 90-xxxx. In my layout I have the fields displayed with a box behind them. Is it possible to make it so that if a 30-xxxx part is entered, the box turns green, and if a 90-xxxx part is entered the box turns blue? Any help would be greatly appriciated

I have created a radio button value list for our project status (estimate, developement, awaiting approval, in production, completed) and have used this value list to sort the records in a report. I would like to create a report showing all records, except completed, sorted by category. I can't seem to create a script that will do this and am left to performing multiple find commands to do so at this point.

If I am in my working layout on any record and I switch to Preview Mode, it always goes to the first record. How do I write a script to show the current record when I go into Preview Mode? It seems the only choices in Go to Record/Request/Page are: First, Last, Previous, Next, & By Calculation. How do I get to the current record?

I need to create a serial number (unique number for each record), then have the serial number auto enter with each new record added. Your help is appreciated. Maxwell Morlay

I shd know this by now, but i don't. I have a layout with multiple portals. In a script, I need to move through each of them at various points and capture some of the data in them. How do I tell the script what portal to go to?

I need to offer the possibility to re-login into the system in FMP7, because I have a lot of users using diferent computers

Is there a scipt command that will copy the current page when in preview mode? I want to paste this page copy into an email message.

Can anyone explain when does validation occur when one is trying to create a new record via a script. I want to initialize some of the fields in the record via the script, however, there are some mandatory fields. When I execute the script ... which does a New Record/Request followed by a number of set fields (not including the mandatory field,) I get a message that the mandatory field requires a value. If I reply Ok to that message I then get a message that the New Record/Request has been cancelled ... do I wish to continue?. Clearly I am doing things in the wrong order ... but so far I cannot find how this order is controlled. What triggers recor…

How do you get to layout mode from browse mode using a button?

I'm creating a databse with a main menu page. I created a button linked to a script I made. Funny thing is when this button is clicked, it doesn't work right. Whereas, from the same menu window, if I click on the script name from scriptmaker menu, it's fine. I checked the specify button dialog, and the button is correctly linked to the right script.

I find FileMaker Developer 7's Debug Scripts both useful and frustrating. Step-by-step script execution and breakpoints are quite useful. However, having used interactive debuggers in many programming environments, I'm constantly frustrated by FileMaker's lack of two key debugging features: display field values and script parameters watchpoints -- breakpoints triggered by a specific condition, typically involving a field value While waiting for FileMaker Debug Script to smarten up, I've found a couple of scripting techniques to mimic these features. The following script fragment illustrates the techniques. If [Get ( ScriptParameter ) <> ""] …

Hello, I have an order database and an itinerary database - In the itinerary database, I have a field called stop_order and a foreign key field called order_number. What I have is a portal on the order layout that lists the related itinerary stops. I already have the create new stop button working using "if else" and "count" to count the number of stops and set the "stop_order" field to be the number of related records plus 1. On the order layout, I have the itinerary portal sorted by stop_order. . What I need a little help with is creating the delete, move up and move down buttons that will go on each row of the portal. The part I'm stumbling o…

Is it possible to create a script to use the "Save A Copy As" function but add the current date and time to the backup file filename? I want the user to backup when opening the database application and keep multiple copies of the backup file. I would like to somehow limit the backups to 7 and then start overwriting the files using FileMaker Pro7 V3 features only. I tried: Save a Copy as["myfilename`Date + %m%d%y%h%m`.fm7";copy] but the date function doesn't convert to the current date/time. Bob...

I have a checkbox feild which I use to select records for printing. Once I have printed the records I need to find a way to clear the check box. I have read posts that Set Field[field;""] should do the trick. However the only way I can see of entering Feild;"" is through setting a calculation, but when I try this it asks for an operator. Any suggestions would be appreciated, this is probably a real simple one.

I have all the other portions of my script working except for (what I think should be) the easiest. - In the parent script the user enters a year in a dialogue box (Let's say "2005") - It gets passed to the child script- (I know this works, because the rest of the script works and hinges upon that working). - What I want to do here is perform a find on the "f_year" field based on the parameter passed to my script, then delete all the records. So what I thought I'd do is: 1 SetField[f_year, Get(ScriptParameter)] 2 Perform Find[] 3 Delete All Records [] Seems pretty straight forward- however when it gets to the find step it can't find anyth…

Hi all, I've read about how to create a small "dummy" file with a script inside to open a hosted file. But what if I'm the first one to open that file (and therefore will be the host)? In short, when one goes to open a file, they don't know whether the file is already open by someone else, right? Is there a way to have a single icon on everyones machine that will open the file in whatever fashion necessary? Thanks, Evan

Hello all...this is my first post, and actually my first time checking out this forum as I just stumbled accross it today! I love it! This may sound like a ridiculous question but I feel someone here could have an answer for it: LOST PASSWORD Long story short: DB created, running shared on FM Server version 6. Admin responsiblities shifted to someone else Person leaves the company, DB not used for a period of time (likely forgotten) Now they want to get in it, and the previous admin user changed the admin password from what I had (of course). They are now asking me to get in it because they can't get a hold of the old admin person. (I know, I k…

Hi gang, I have a solution that has a Job table, a job line item table, a quote table and a quote line item table. Originally I did not have the quotes separated but had a status field that showed open or quote. My users couldn't be trusted to use them properly (don't ask), so I am separating them. The problem I have is that when a quote (that has already been entered into the Quote and Quote Line item table)is approved, I want to create a job record for it. It was simple enough creating a Job record with all the info. the line items are giving me trouble. I can do a loop setting each field separately but with some of these jobs with hundreds of line items, it c…

I am building an electronic medical record for my clinic. Much of what is involved in an electronic medical record is moving stored data like past medical history, family history etc., into a note which is created for a particular visit date. Some of my scripting seems clumsy. Here are two of the techniques I have been using, but seem clumsy to me. I would like to know if they are sound techniques and if there is a better way? 1. I have created text fields which temporarily holds text while I am creating a note. When the note is finished I click a "sign note" button and the text is stored in a notes table by way of [go to portal row (last)] and then set field com…

Need some help here. Trying to setup a script that will search a value feild for two entries. The entries are in the same value feild. I can get it to work OK searching for just one entry but if I try a search for two entries it says the value feild is in use.

I figured out that you can duplicate blocks of code, but is there a way to MOVE blocks of code? I find myself having to drag multiple lines of code one single line at a time. Its aggravating.

I have 48 check boxes each one is its own field. I have set them up to all be checkboxes with value on or off. But I have also made them all buttons running its very own very specific Script. Here is an example () January Ok when you click the check box above it is suppose to check it and start this script Go to Layout ["Month Setup"(MonthAdvopt)] New Window [Name: "jan05"; Heaight: 300; Width: 240; Top: 50; left:500)] Go to Layout ["Jan05"(monthAdvopt)] Preform Script ["Hide Status area"] Set Field [Monthadvopt::month transfer; "january"] Set Field [Monthadvopt::Year transfer; "2005"] copy [select; monthadvopt::CustID Transfer] Paste [select; Mon…

I work in a lab that does a lot of coding of video tape data. In doing this we like to index our records in FMP with the time of the scene they refer to. We have used FMP 4, 5, and 6 over the years and a program to grab the time off of the VCR called AutoLog. In previous versions of FMP a very simple script accomplished this task of grabbing the time code and pasting it in a field in FMP: The first step would be to "Send Apple Event" Within the Specify Apple Event window, we had the following settings: Send the "Other..." event with: Selecting "Other..." would bring up a window with Event Class & Event ID. We entered ALEV for the Event Class and TIME …

Need help on FM7V3 script to Perform a Find on a date range. I have two Global, Date fields "Report_Start_Date" and "Report_End_Date" defined in my "Main Input" table. I tried this script but it puts the ">" and "<" in the fields instead of passing them on to the PerformFind. Go To Layout [Main Input] Enter Find Mode [] Set Field [ Main Input::Report_Start_Date ; ">" & Get ( ScriptParameter ) ] Set Field [ Main Input::Report_End_Date ; "<" & Get ( ScriptParameter ) ] PerformFind[] Actually the operators are Greater_Than or Equal_To and Less_Than or Equal_To Can anyone show me how to do this correctly? Thanks Bob..…

How do I set up a script to toggle a checkbox?

I would like to make a single script to sort the records I am browsing in list view. I want to mimic the windows GUI where users expect to be able to click on a column header and have the data sorted ascending or descending based on the column clicked. I can do this now with numerous sort scripts but there must be a way to script a sort where the fields to sort by are passed via a calculation or get(ScriptParameter) or something like that. I would prefer not to make a huge if/else list script. Just trying to keep the scripts to a minimum. Any ideas oh gurus?

Using filemaker on windows xp to print to 2 networked printers. I would like 1 printer (laser) to be default printer. However, certain scripts will need to automatically print to inkjet (color). I keep setting it to the inkjet in the script but it does not stick and needs to be manually reset by the user in the dialog box. any suggestions?

Hi all, I'm totally new to scripting. All the scripts I've used so far I've copied from elsewhere. I have a guide to the script steps and understand, to some degree, the step definitions. What eludes me is the syntax used to construct a script. All the nested parentheses, semicolons, etc. baffle me. Any tips on how to learn this? Evan

I have a found set on tableinstanceA that I'd like to also have on tableinstanceB. To be clear, they are the same base table. is there a good way to do this?

i am in a script i am in a loop i work in Find mode i iterate what am i?

(background) As a user I might like to search for "apples" or "oranges". I want the Found Set to contain records of apples, and as well records of oranges. Being a reasonably able user, I find apples, then extent the found set. But, I could perform an OR search. To do this, first Enter find mode, then put "apples" in the field. Next, create a new record, and put "oranges" in the field. Then run the find. So far so good? Okay, here's the question: I've a table, fruit, with fruit::names like "apples", "oranges", "grapes". Fruits come and go in the fruit table. On some other layout I want to built an OR search, based on every record in fruits. I wan…

I have a script tht needs to access items from a value list. For some reason it is not doing that. In my script I have this, to access the value list items: Substitute ( MiddleValues ( ValueListItems ( Get ( FileName ) ; "vlAnyOf" ) ; GetAsNumber ( RightWords ( Get ( ScriptParameter ) ; 1 ) ) ; 1 ) ;

Hi all- Great website here... I've found lots of answers to my problems so far, but it's time to post my own :-) So, I've got a database of students and teachers for a Jazz Dept. I want to make a report of what Studios a student is in (a Studio is taught by 1 teacher, and I've made the name of the studio the teacher's last name). I have a join table assigning students to each studio, so it's easy to go to related records and I get the studios that are assigned to the student. My question is, how can i copy the name of the related teacher name, into a new text field? I have a portal that normally displays this info, but I want it horizontal instead of vertica…

This is my script:: Go to Record/Request/page [first] Loop Go to Field[select/Perform; Time::Description] Perform Find/Replace[ """; "'' ;Replace all] Goto Record/request/page [next; exit after last] end Loop What it is supposed to do is go to the description field and find all quotation marks and make them a single apostrophe. Because when exporting we can't have quotation marks in the comma-seperated file. So instead of seeing Last night I read the book, "The Perfect Storm". it would read, Last night I read the book, 'The Perfect Storm'. BUT it doesn't work!!! Can a field be changed like this or should we just have …

OK I need to import some scripts from another file I have already did all the changes for. In 6 if the name of the field existed in both it just imported and worked in 7 I have found it designates the table as well as the field so when you import it is a waste of time. Since it just puts table unknown all over the script which means you end up rewriting the script anyhow. Is there a way to import scripts still or is it dead now? Thanks in advance Mentairia

Hi guys, (I haven't been around much lately, my job as a FileMaker guy came to an end a while back. Now I only dabble in FM for fun now, instead of dishing out cynical and poorly spelt advise). I'm making this DB that generates a random alpha numeric string. This string is then spoken out using the speak() command. I've got that working great. The idea, is that the user then has to sort the numbers and letters by number and by alphabet position (did tha make sense?). For example: sd4f325 should become dfs2345 or 3abd59si9 should become abdis3599 I can't seem to find a good way to generate the correct answer, short of having a case() position(…

Hi I get the email address adding twice when i use Send Email. I've added a very simple database to illustrate this. (ps emails go to Mail) test2.fp7.zip

I cannot, for the life of me, get the Print script step to save which printer it should go to. I am running FileMaker Server 7 on Mac OS 10.3.X. I am running a POS system that I mostly need to print receipts with, but need to also print to an 8.5x11 printer and a Dymo LabelWriter. I would like to do ALL these things without dialog boxes, but FileMaker ALWAYS uses the last printer used, not the appropriate one I seemed to "save" in the script. Also, is there any possible way to set up a script to print one label is something is true, and a different one if it's not? Example: If Suggested_retail_price = Our_retail Go to Layout X Else Go To Layout Y. How would I do…

i'm trying to set up my database so that if one box is checked in a field, then the box in another field CANNOT be checked (no data entry allowed). is this possible?

I have a field set as a button, so that when a user clicks on that field to edit it, it will run a script to compare Today to the Modified Date. If they choose that they still want to edit it, it will enter that field. Problem is, I need a script for every field on the layout. This isn't a problem, just real time consuming. Is there a universal way to get to the specific field that they clicked on? Here is my code: If [Modified Date <> Today or ""] Show Message [buttons: "Edit Record", "Cancel", "";Data:"This is an existing MWR. Do you wish to Edit this record?"] If [status( CurrentMessageChoice) = 1] Show Message [buttons…

I have a contact database with 20,000 records. sometime the phone numbers are listed with dashes, while others are listed with dots (202-222-2222 vs. 202.222.2222). I want to make the database consistent for aesthetics purposes but obviously don't have enough time (or patience) to manually fix them all. is there a way to execute this by script? Even when i try to do a find request for fields containing a -, it doesn't return all the records that i know have that issue with the phone number. thanks in advance for the help.

I don't know if this is the right room. My question : Is it possible to use enter key for running a script ? Any suggestion,.....

I am learning FMPro 6 on Mac OS X and using the Product Catalog sample that came with the software to see how things work. I want to only display certain Keywords from the external Keywords file when certain text is found in the Description text field (another field in the Product Catalog file). For example, if "DVD" is in the description, I want a subset of certain keywords to show, but if "CD" is in the description, I want a different subset, even though *all* keywords are in this single, external Keywords file (I guess if DVD and CD are both in the Description field, then both sets of keywords should appear, but should not be duplicated). Any ideas? I thin…

I'm having a weird issue with script menus in one of my files. If I choose to edit or create a sub-script, when it pulls up the menu the displayed script title is always one below the actual script selected. Also, if I have scripts already in place as buttons, the buttons work and run the correct script, but if I look at it in layout mode, it shows the button keyed to the script below the one it's actually running. Any clues on this?

hi FM pros! i've tried to work through this on my own with other tips i've found on this (and other) forums to no avail ... please help. i'm in the process of reworking my db which i use for my biz. it contains clients, projects, expenses, invoices, etc. in one db (multiple tables and layouts of course). at the moment all i need by way of searching is to be able to view all records in all tables that have a date field by year (no days or months) ... i only need to view records by year in any given table at any one time ... but if i switch to a different table (that has a date field) i want the "find by year" script to auto update the sort to reflect the year inp…

Hello, I have 2 databses, A and B. A single record in Database A has several related records in Database B. The key field in Database B is the date. I want Databse A to display information from the *most recent* corresponding related record in Databse B. What I have done is made lookups in A but right now they are displaying information from the *oldest* related record in B. The script I wrote does a relookup whenever I push a button and I would like the script to get the info from the most recent record in B. Any thoughts on how to achieve this with Scriptmaker? Thanks, Cram

With all of the databsases I create, I include a field called "FINDIT". This field contains a concateneation of the record number the person's name and street address, and other such stuff as might be commonly searched for. I always set this up to be the second script in my active script list (the one that show in the Script menu pop down). These have worked perfectly for years. Suddenly none of these work. At first I thought "bad keyboard", but changing to a brand new keyboard did not help. Next I tried changing the script to a different position in the list (one that I know is functioning correctly) - no help there. Next I deleted the script, and rewrote with a di…

Hello all I have designed my first database but want to instead of typing in the date (01/01/05) be able to link this to a button next to the field so I can choose from a pop up the date and then insert this into the field. thanks in advance. MJH

I have a DB that is quite simple. It captures name, address, age info. It also captures a lacrosse shot speed. I want to be able to run a script that will return the five highest shot speed results for each unique age group. The age groups can vary between 1-99, there may not be an entry for every age either. What I want to have is: age group X, shot speed (top 5 only). Are there symbols or operators for defnining the highest values from a field? The shot speeds will vary dramatically so using a range is not really an option. Any suggestions?

When running a script that goes into Preview mode and pauses, Filemaker offers two options in the status area: to Continue or Cancel. Is there any way to capture the Cancel in the same way as you might with the Cancel in a Message choice and Status(CurrentMessageChoice) function? What I would like to do is have the script take the user back to the original layout if the Cancel button is pressed rather than dumping him or her on the layout in question. Hopefully, the user won't even think of using the cancel button but.... I would guess, unfortunately, that the Cancel button just runs the Halt Script step, and there is no way of getting around that, but maybe not…

I would like to create a script that automatically creates a new folder with the same number as an auto-generated estimate number. Example... I have an estimate number "5001". I have already scripted opening the folder ("Driveletter":"estimate number") using the open url script, but I want that folder to be created in that drive with the New Record. Any ideas? Thanks!

I have a database which will track "Current Hardware", "Added Hardware", and "Deleted Hardware" and Each of these will have different fields, such as "SerialNo", "aSerialNo", and "dSerialNo". I have 3 separate layouts which contain the separate fields. If I need to add a piece of hardware, I would like to add it using the "Added Hardware (aSerialNo)" layout, which will also add it to the "Current Hardware". These can't be the same fields, because the "Added Hardware" layout should only show the items that were added since a certain time, not all records. If I need to dispose of a piece of hardware, the item needs to be added to the "Deleted Hardware" and removed from …

I'd like to be able to enter a domain name into a field and then have a script do a WhoIs and import those data into the record. Possible? Anyone have a script for it to share?

I am trying to figure out how to perform the following straightforward task. I'll use pseudo-logic to describe my question. loop until count > Max(FooTO::ID) Add New Record to BarTO SetField BarTO::Date of new BarTO record to Current Date count++ end loop BarTO::ID is a "looked up" relational value (I think of it as a foreign key) from FooTO:ID. Any and all help will be appreciated. p.s. I have to say... I'm a newbie to Filemaker 7 but so far it is the most non-intuitive (sometimes even counter-intuitive) data and coding environment I've ever worked in. I have experience with C, C++, JavaScript, Java, J2EE, SQL and AppleScript if that h…

Howdy All, I was wondering what the best way to import lots of excel files was? I mean without the user having to go in and import each one manually. Any ideas?

Is there a way to set a value to the current field? or a field by calculation, or etc etc... anything like: Set Field [ <thisfield> ] ??

I have setup an invoice file that has relationship to my product file. When I enter item # into the Item field (which is a portal) that item's price and description shows up in the invoice file's description and price field. I have to type each item # / copy paste it in. How do I make a script that will retrieve a list of item # from a text field separated by commas(or symbols) and insert each item into a field within the portal list thus making me an invoice? Thanks for any input!

I'd like to offer a vaguely compicated search function to my end-users...actually, it is a requirement. It should treat an entire tree of tables in the relationships graph as a single search field (or else iterate through each field, creating new records in find mode for one massive multi-criteria find)... how do I do that? Example: Tables: tblPeople tblPlaces tblPossessions tsupAddresses tsupTelephone.numbers tsupColors Relationships Graph: rgPeople foreign tables: rgAddresses.People rgTelephone.numbers.People rgPlaces rgPossessions rgPlaces foreign tables: rgAddresses.Places rgColors.Places rgPossessions …

Hi all, Sorry if this has been asked 50 times already, but a quick search didn't help. I would like to have a button on a layout that when shift clicked will run one script, and when option clicked will run a different script. This seems like a common thing to want to do, but I can't figure it out. Is it possible or do you have to resort to something like apple script or something? I am using FM6 in a Mac environment. Thanks, Mark

In my database, I use a script to weed out duplicate entries. It worked well until I started using a "flag" field that I created for the script with other scripts. In the script, I use Set Field ["Flag",""""]. What I wanted this to accomplish (-and thought that it did, until recently), was to clear the flag fields for all records, so that it would flag the results I wanted it to, and keep all of the records that were unflagged after the script. Unfortunately, the Set Field ["Flag",""""] command only clears the first one. Thus, if all fields are flagged before the script, the first record (which was cleared) is the only one that shows up unflagged. To remedy this prob…

I've got a shared solution hosted on FMS7A. I'm running FMD7 and doing some final testing before rolling the solution out to about 20 users who will access with FMP7 and the web. All copies of FileMaker have been updated to v3. The solution has a startup script that uses a Get (PrivilegeSetName) step to route the users to the appropriate layout. It is enabled in the File Options dialog and is also set to Run with full access privileges. The script doesn't work when I test it. I have a field that displays the privilege set name. I can verify the privilege set, but it doesn't take me to the correct layout at login. I really hope this is something simple. I'm stumped.

Here's a challenge. Say you have a fields and any number of records. This is a number. These numbers are not unique. The same number can come up many times throughout the records. Within a found set based on a date range, how would you script (or calculate) the Count of the number that comes up the most (Max), and then display the actual number in a Results field?

Howdy All, I'm fairly new to Filemaker, I was asked by our company to choose and learn a new database program in order to replace older software. I was wondering if it were possible to create a script that would import data into FMP from an excel spreadsheet. Furthermore, would it be possible to make a script that would do it for multiple excel spreadsheets if they were all in the same folder? Thanks, Akira

Can anyone help me with some info where to find a good tutorial of scriptmaker. I use FM3 because it has to run on a low-end PC with Win98.

I am tracking doctors with liablility insurance expiration dates throughout the calendar and would like to identify those with dates within a chosen month. What is an elegant method of performing this find while selecting the month from a pop up list?

The step I need help with. I want to round a number UP to the next whole number. What it is doing, if the digit in the ones spot is 1, 2, 3 or 4, it is rounding down. I want all the digits to round up. For example (73 with round up to 80, not to 70). For simplicity, this is where I am at. Step 1: Add A+B (30+43) Step 2: Round Result of Step 1 What I did: in Define Field - Set Field as Calulation Round(Step 1, -1) I want it to round up to the next tens digit spot and it's rounding down. What can I do?

I have a layout that contains a portal showing a list of related records. I want the user to invoke a script that makes a new related record based on the person whose data they are viewing. Easy enough if the portal is editable but the portal shoudl only be viewable. New records need to be input from a different layout with many more fields that I can display in the portal list. How do I script to go to the new layout and add a new record without it adding a new PERSON to the database. The new record command does not seem to be the answer as it creates a new record and a new blank person too... Simple problem I know... Any help would be great.

I want to be able to use a script to create a new/empty record (and records in a related table/portal.) After creating the record, I want the user to be able to enter data into the record/portal, and then I want to be able to validate the fields. Is this possible via scripts (I assume it is)? If so, do I need several scripts? Ideally, I would like to be able to trap whenever the user tabs out of certain fields and validate their content, and then validate the entire layout contents. Can this be done without using the database validation rules? At present the application that I am working on has a script to create the new record (initiated by a button,) but it doesn'…

I'm trying to omit a record from a found set in ScriptMaker. Enter Find Mode Set Field["codefield","3"] New Record/Request Set Field["codefield","7"] Perform Find Go to Related Record[dumprecord] Omit Record Above doesn't work. I'm guessing "Go to Related Record" resets the found set. I have a specific record, let's say UserID: 42 that I want to omit from this found set. How can I achieve this?

I have an inventory and I would like to be able to have up to three photos for each record. I currently have three thumbnail fields and one large display thumbnail field. I want the display field to show the first thumbnail as a default but I want to be able to click on each photo and have it display in the larger field. How do I do that? Thanks.

i wonder how to create a autocreate script, to add a new time entry record each week, lets say mondays. now my database have only one record for time entries, I can make a new one, but I would like it to autocreate and jump to it, show week number in it, *AND be able to only make entries for the date in that week in that record, but that is a bonus...

I have a fully scripted Find Mode for my users. I'm trying to decide whether or not to allow user abort when triggering the find script. If I do, I want to capture the fact that the user canceled the find mid-way through and direct him or her somewhere...and right now I can't figure out how to make that work. Is it possible??? FYI, I've tried Error Caputre On and Get ( LastError ) = 1 (user cancelled action), but it didn't work. Thanks! -Rob