Script Workspace and Script Triggers

Hi, Is there any function or any way to set a field to a value while defining the parameters for a button, like a Set field step inside a script? Example: I have Button1. I have a relationship from text_field1 in TO1 to global_field1 in TO2. text_field1 may have of course have different values based on the values of global_field1. I assign a script to button1. I define parameter1 as text_field1 inside the button. This is the parameter I would like to pass to the script. I need to define several values for global_field1 and evaluate text_field1 according to this values BEFORE passing the value of text_field1 to the script. I have everyth…

Hi all, What I try to do is: [color:red](check the attachment) At portal Date are Lookup to my Form Date,but when I change the Date at my Form they do not change at my portal Date. Can I write the script to change when the Date is diffent? Thank for your help! test_lookup.zip

Hello, I have a check list in Excel and I want to create it in filemaker 8 adv. I thinkt the check boxes would be a good choice. Depending on the check box I would like to have more than onle text showing up on the print layout. Is it possible that a selected check box let a picture appear in the print layout? Thanks, mlewan_ca

Hi everyone, I am trying to script a "save as pdf" file, but would like to name it based on field criteria. Can this be done? I know that I can change the "title" in the options but when I save as pdf the file reference dialog box comes up. Can I propagate the reference box with a calculation or field content? Mike

How might I go about getting an enlarged version of a picture to popup in a new window when I click on it?

hi all, I need to create a script for open the new record by my field is Empty. Field name: Over Limit If my Over Limit field are IsEmpty then pass to open the new record, if Over Limit field are not IsEmpty come out a message "This Customer Are Over Limit". Can this done? Thank for your help! ;)

Hi Guys, Ive created a POS application, which uses one file, but two table occurances, parent and child. I print out from the child records, using the the GTRR nd print option. My users are printing out receipts with about 8 lines per transaction every 3 minutes or so. Occasianally the GTRR + print fails (usually midday) and tries to print out all records in the database even though I have 'only match related records'. Has anyone come accross this problem. What is the best way to print transaction lines quickly? Many thansk for your replies.

I am trying to script the same experience as FM's "Create a new file using a template" behavior. Specifically, this allows you to select a .fp7 file and forces the user to "Create a copy named", then automatically opens this user's copy without altering the original .fp7 file. When attempting to replicate this behavior in scripts, I am only able to use a "Save a copy as" script step which is not as elegant as the former. It does not automaticly open the user's copy without asking them to check the box- and on top of that, I get into some scripting trouble to boot. So far, the best I have been able to come up with is something like this (where my solution is na…

Hello, Why would a working script stop working? I have a script that does a find that used to work in my database and now it doesn't. I have narrowed down the problem to a validation that is in place. How it is set up: I have a value list based off of a field (SampleID) This field is a serialized number that is non-repeating. Here is my script: Enter Find Mode [] Show Custom Dialog ["Enter Sample ID of Interest" ; Samples::SampleID] Here is where the problem exists If [not Position ( ¶ & ValueListItems ( Get ( FileName ) ; "Sample IDs" ) & ¶ ; ¶ & Samples::SampleID & ¶ ; 1; 1)] Show Custom Dialog ["Invalid Sample ID"]…

I want to find club members who haven’t paid their 2007 membership renewals. My primary table contains records of members and non-members alike. For the members, I have a related "History" table with membership history. Manually, the find is preformed by first finding records that contain “2006” then omitting those records that contain “2007”. That produces the desired result. In the Scriptmaker find criteria, I’ve done the same thing. I’ve specified; find “2006” then omit “2007” as two criteria. How do I make the criteria dynamic? Next year the criteria will be find “2007” and omit “2008”. A get “year (current date)” and get “year (get current year -1) will prod…

Is there a way to script the creation of a specific number of new records without using a loop?

Is it possible to use Filemaker to move a pdf from a local drive to the server disk? I think I've got the right idea, but I get an error message when I try to create a file on the server. This db is hosted by a third party server. The script I have is as follows: #IS THIS FILEPATH CORRECT? Set Variable[$filepath; Get(FilePath) & "/Contracts/Contract_" & Invoices:_kp_idInvoice & ".pdf"] # #User selects pdf Insert File[invoices::ContractContainer] #Script saves pdf to server, clears the field, then inserts a reference to that pdf # #THIS IS WHERE I GET ERROR 800, CAN'T BE CREATED ON DISK Export Field Contents[invoices::ContractContaine…

Does anyone know if there was a change in how the buttons work with custom dialogs in a recent upgrade of FMP? I thought you could designate any of the three buttons as your "Ok" button and write information from the input fields to a file. Now I see that you can't. Only the "Default" button can write information from the input fields to a file. Maybe I'm just loosing my mind.....anything is possible :)

I've got a table called InvoiceItems and another table called Scans. These tables are related by ScanID. I'm trying to create a script that will set the Status field value in Scans from InvoiceItems. My script is as follows: 'find set of InvoiceItems records to loop through...this part works fine. Loop If[$RecordType = "Invoice"] Set Field [invoiceItemsToScansByScanID::Status; "Sold"] Else Set Field [invoiceItemsToScansByScanID::Status; "Returned"] End If Go to Record/Request/Page [Next; Exit after last] End Loop When I set a static value for $RecordType and make it Invoice so it should set the status to Sold i…

I have a field named "WebPage" which holds url addresses I also have a field named "UrlHold" which is a global. I have created a script called "Go2webpage" which uses the set field step to incert the "webpage" url address into the "urlHold" field then the "open url" step where the contents of the urlHold goes into the "specify field" dialog but the url never reaches my web browser. Any suggestions?

Hello, I'm working on scripting a button that manages the print functions. I have disabled the print button on the menu bar and I have made a button to click to print. We have had issues with people just clicking print. Then we have the printer spitting out the layout for every record. I know how to change the preferences so it prints only the current record and I would like to automate it so they can click the button and that's all. Does anyone know how to specify the print options. I just need to change the printing preferences to "Filemaker Pro" instead of "Copies and Pages" and then click the current record radio button. thanks js22

I'm trying to export a set of records to excel and i want the records created in the last 30 days to show differently in the excel file (in bold, or in color, or any other way). Is there any way to accomplish that? I don't think there's any control over the conditional formatting in excel from filemaker... thanks

I am not sure if I need to create a script or a button or maybe neither ... I have two drop downs on a layout with the City and under that a drop down with the Month . How do I create a script that navigates to the other layout that matches the same City and Month? For example City SD (drop down) Month : Dec 06 (drop down) once Month is selected then go to other layout that has matching City and Month City: SD Month: Dec 06

Hi all, I am making a database with three types of things. Performances, Performers and songs. There are 10 different ongoing performances. There are maybe 100 total songs and 100 performers.A performance is a collections of songs, performed between a range of dates by a set of people. A performer is someone who has done certain performances during a range of dates and know a set of songs. A song is a part of the performance and known by a performer. I am trying to link all these tables together to create histories with portals, but when I link more than two it asks to add a separate table. If I am in the performance table I want to see all the performers and …

Hi, I am creating a calender type function. The database has a history of performance which someone is doing. The performances may be ongoing meaning stretch into next year. I want to create a way of adding a performer to a performance. But first I need to check availability and check schedule conflicts. I have each performance with a start date and end date and a calculated date range. In essence I need a way of check to see if any date ranges over lap. I am thinking of doing a script which goes thru each day of a performance and see if it falls with any other performance, but this is time consuming. I am looking into self joining with a range of dates, but …

Hi I'd like to be able to display different types of contacts using different layouts. EG, There are 3 different types of contacts, each with their own fields that need to be seen. Instead of having 3 contacts databases (which I've tried), I want them all to be in the one database. Is there a way to automate a script so that it examines each record, and displays it with the correct layout? (There is a field called "Type" which the script could use. eg. "if type=... then display using ...layout") Any ideas would be much appreciated! Cheers Tom

I've recently started using Filemaker and also started with the Business_Productivity_Kit since I was looking for a contact manager I could customize. What I've not been able to do is change the script for emailing so that it will use 1 email for all in the group that I want to send to rather than creating a separate email for each record(email address). I've tried different combinations in the BPS Email scripter - "send mail" options to no avail. Send Mail [To: "[email protected]"; BCC: Campaigns_Contact Management globalID::Email...etc] I also find sending email by found records problematic.

I need a script that when activated will create 12 new records and populate a qty field with a number that is not the same in the indivdual records, but is the same each time the script is called. ............QTY Record1.......6 Record2......12 Record3......36 Record4......72 Record5.....144 etc, etc. ............QTY Record6.......6 Record7......12 Record8......36 Record9......72 Record10.....144 etc, etc. It would be a bonus if the user could predetermine with a related preference file what that "qty" number will be for each of the 12 newly created and populated records. Any ideas would be greatly appreciated. Thanks…

I would like to use ZippScript ( although I am not wedded to it ) to tell a script to continue ( from pause ). I want this to be a scripted event on exiting a field.

Hello, all. I need to find some way to duplicate an entire found set of records, changing only the foreign key that assigns the record set to its parent record along the way. Here's the scenario: I work for a large sawmill producing pine boards. Every month, our mill managers use a complicated set of Excel files to determine what their mill outputs will be for the upcoming month. They work primarily with three lists: a list of what they intend to produce, a list of that production by percentage (based on historical averages), and a list of the value of those products (also based on history). The list of intended production calculates volumes based on the li…

Hello, I have a quick question. I have a layout that has two fields on it. Above those two fields I have a button. What I would like to do is have it so when you click the button it unlocks the two fields and allows data entry. Is this possible? Before I converted to filemaker I was using MS Access and you could do conditional fields. So I would have a set of radio buttons and if Field1=0 then the fields are grayed out and if Field1=1 then they are not grayed out. This is the sort of thing I would like to do but if I do it with a script that's good enough for me. Thanks js22

I'm a neewbie so forgive me if I don't give all the details on the first go-around. I wrote a script that looks for a "Y" in a field that is called archive. My intentions are to take this found set and export the records to a new FM table. Can this be accomplished automatically? To be more specific can I create a table, fields, and export the find set from a script with little or no user interaction?

Hi All, Gonna do my best to explain this because I am confused. We have a slightly modified version of the template Lending Library that comes with Filemaker. Some of our items refuse to check in. I noticed that there is a script step in the script "Process Check In", that step is Go To Related Record. When I try to check one of our broken items in, for instance, 0000042, the related record that appears is 0000421. When I step through the script with the debug mode turned on, it kicks back "This operation could not be completed because the target is not part of a related table". So the script goes to a related record, but to me it doesn't really seem related. …

I have an old script for centering a window, but now on an intel mac it is not working, any suggestions? Distance from Top (Get ( ScreenHeight ) - Abs(Get(SystemPlatform) + 1) * 150 - Get ( WindowContentHeight )-35) / 2 Distance from Left (Get ( ScreenWidth ) - (Get ( WindowContentWidth )+14)) / 2 //14 add to width for mac scroll bar

Hello, I'm wondering if it is possible to run a loop with letters. Something where Set Variable $Var = A Loop Insert Calculation Field: $Var Set Variable $Var = $Var + 1 Exit loop if _____ End Loop So that everytime it loops it goes from A to B to C ... If anyone has any ideas that would be helpful js22

How can I specify the sort for the body of a report when report has a sub-summary part? I am sorting the sub-summary part by "day of week" and the body part by "order number" Report Example: ___________________ WORKOUT TITLE (title header) __DAY (sub-summary part) - sort A ___EXERCISE (body part) - sort B ___EXERCISE (body part) - sort B ___EXERCISE (body part) - sort B ___________________ If my question is un-clear let me know, I will try to explain better. I appreciate your interest in my question. Thank you all in advance!

I am trying to insure sales people fully complete a sales ticket. I want to say if field Varnish is Yes, then Coating cannot be empty. Message would need to display when they click button to go from a quote and create a job ticket. ;)

I seem to be having some trouble with the basics - just finding stuff. My goal is to find just the records that BEGIN with 3 dashes ... ( some records have three dashes in the center of the text somewhere - which I do not want)... - using the find command - I will enter: “---“* I am expecting to find records in this field that start with 3 dashes - But I will also find those with 3 dashes not at the beginning Q: how can I search for just those records that BEGIN with 3 dashes only?

Before a new prospect is added, FM 8.5 does a find comparing two fields (name and company. If comparison is found, then a message would display that entry already exists and a new record would not be created. thanks, Jim

This script searches the "Order Entry" layout for Order Numbers for a current Run Date and exports the File. It then goes to a "SearchResults" Table (which is not linked to the "Order Entry" Table). Deletes Records from previous Searches and imports the the files containing the Order Numbers. Then it goes to "TeamEimages" (which is not linked to the "Order Entry" Table). Deletes Records from previous Searches and imports the the resulting text file from the Send Event command (it reads a folder of images). The results are compared on the SearchResults layout which is linked to the TeamEimages layout. Problem: 2 out of 8 weeks the script has deleted a few…

Hello, I recently began using file maker, however, I am not yet used to the format of the scripts; I used to program in Visual Basic, therefore, the scripting in filemaker is still a bit foreign to me. Anyways, I am working in a database that was already created. The script I am attempting to make needs to recognize text in a field, and change the color of other fields based on what is found. For example, the "Status" field ranges between 9 steps; Case (Date Quote Dead;"LOST"; Date Contracted;"WON"; Pricing Submitted;"7 PRICING SUBMITTED -"; Price Approved;"6 READY TO SUBMIT -"; Take off finished;"5 NEEDS MANAGER APPROVAL -"; Estimating Accept;"4 P…

We have an Inventory table that, of course, holds our current inventory. We also have an Auctions table that stores all of our eBay auction data for inventory that we have posted. My goal here is to highlight the ItemNumber of any item in Inventory (list view) that needs an auction posted. Any item could have a bunch of auction records created for it. Auction records have a status field with values: Current, Winner, Loser. I know how to use the TextColor function to change the color of a field's text based on an If/Then, for instance. But what I need is a calc. field that will be a 1 or 0 based on whether or not there are any current auctions for that …

I thought I was quite good at problem solving but this one has me whacked… I’m trying to write a script whereby I can refer to “the current field” without using its specific name. The database is a school report for each student in which teachers will put “ticks” in fieldA, fieldB, fieldC etc by clicking on the relevant fields. So a simple script would be: Allow user abort [Off] Set error capture [On] Insert text [select; S1 Reports::FieldA; ü] # “ü” in “Wingdings” font converts to a “tick”. However, this means I have to write individual scripts for each field. Is there no way of introducing the equivalent of a “CurrentField” variable or some other solu…

Hello, a script runs the "send event" the dos-command xcopy ("cmd /c xcopy ....."). When xcopy has finished the next script-command should start (import files). Because the time xcopy needs differs from 1 to 100 seconds, a delay is not nice. I hope you can give me some advice for a better solution. thx

Hello, I've been trying to use Set Field rather than Copy and Paste script functions but cannot get both the field to be overwritten and the field value that will be placed into the former field into Set Field. I can only enter one or the other. This function obviously needs two fields to operate properly, but I cannot make that happen. I have seen examples where the author's have used: Set Field [ "x"; "y' ] or Set Field [ x; y ] I am not able to enter either of those by selecting either 'Specify target field' or 'Calculated result'. Any help will be greatly appreciated. Phillip

Hello, I would like to be able to auto-populate a container triggered by the filling of a another field, but cannot seem to be able to get it right. Here is my script code: If [ "not isEmpty ( Cards::cards_caption )" ] Go to Related Record [ From table: "Cards"; Using layout: < Current Layout> ] Copy [ Select; Cards::cards_image ] Go to Field [ Invoice Line Item::image_from_caption ] Paste [ Select; Cards::cards_image ] Else Beep End If What I mean to say is: If the portal field 'Cards: cards_caption" of this record is not empty Go to the related 'Cards' table Copy image from this records container field Go back…

Hi guys I´m very newbie in File Maker, and I´m using the 8.0 Advanced version. I´m creating a very simple database to organize my clients. This is the right place to ask newbie stuff? I have 2 questions. 1. I´m using "Checkbox Set" to select the areas which our Design Office works (like web, branding etc) for each client. But when i select some options for the first client, the second has the same options selected... how I unlink that options ? 2. I save all of my clients e-mails in a office document, how I just link that docs to open like a button to me see and edit in Office (Open Office for me). It´s simple... but impossible for me... Thanks guys, …

I though this would be easy, but it has turned out not be more difficult that I thought. How can I exclude certain groups that don't meet specified criteria? For example, we maintian a simple time-billing system and we invoice quarterly. However, any customer with less than £100 of billable time on his account gets rolled over to the following quarter. I can produce the reports with totals for each customer (a sub-summary specified by 'customer') with no problem, but how do I then exclude those customers with a total of less than £100 from the quarterly billing report? Thanks

How do I prevent entry into a field if another field already has data in it? I'd also like to display an alert that says "You cannot enter field X because this record is being used for data types described in field Y. Please create a new record." Appreciate any help you can give! JT

Hello, I am quite new to using Filemaker Pro. I am currently imputing phone bill data for my company. I am using drop downs for two of my fields. The first is a drop down are all the vendors we use(example Verizon, At&t)which is being read from another table . The second field below it is the account number, which is also from another table. How would I write a script for the account number so when I select a vendor, it would only drop down the account numbers for those vendors? For example, if I select Verizon from field 1 then all the account numbers will show and if I select At&t then all the account numbers will show. Thanks [color:blue]…

I'm working on a solution which need differents teams to connect to a running database with a usb stick containing a related table. Is it possible to recognize if the stick is connected without to restart filemaker using a script? Thanks

The database system that I created just went live in my office. I have gotten many requests for something resembling a browser's back button. Users want to be able to revisit their previous screens without have to go through their initial navigational process. Is there a simple way to set this up? Thanks.

Does anyone know if you can change an object that is named on your layout, (not a field) such as the color of a line of text typed directly on the layout? I have a few items I would like to change based on conditions in scripts, but most of the operations you can choose in a script have to do with fields and do not seem to effect the named object (named objects being the latest feature of 8.5)

I'm looking for a way to automate the process of creating a Table and defining its Fields. Purpose is to be able to take a CSV file where Record 1 contains column names, and to create a table with those fieldnames (all Text fields) and then import the CSV file. I'm doubtful it can be done (there isn't an AppleEvent to create fields) but the ingenuity on this list knows no bounds. Thanks, Chap

I have a checkbox field that contains the names of all the people who sit on a board of directors. For each meeting date, I check off the ones who are present. I'm trying to write a script that calculates how many meetings each board member has attended in a specified date range. I want the script to perform a find for every member in sequence: the number of found records will indicate the number of meetings they attended. Is there any way to use a variable or field as the target of a find request in a script? For example, can I make the script look for "John Smith" if that character string is stored in a variable? The only workaround I can think of is to e…

How do I request start and end dates in script and then use those fields to select those records that fall in that range. I also have another criteria after those records are selected

Hi, all - This is sort of an add-on to my last topic. When you use the Insert File script step, is there any way to access the file name/path name of the file specified in the input dialog? I want to store this information, hopefully automatically, as part of the file information in the record. I'm wondering whether there's some undocumented variable that FM uses with the insert, that might be available to me in a script. Thanks for any ideas...

I am trying to do a script that will duplicate a record and keep some fields but empty others for new data, my problem is that the Replace Field Contents option then replaces the fields in the original record too?? Is there a way to do this? Help!!

Does anyone know of a way to capture "distance" between two points from yahoo/google maps and input in a FM database? I'm trying to create a script that runs multiple addresses and then returns the distance between points.

Is there a script or set of options that allow me to Save a Records as PDF with a specific file name? I would also like the file to go in a specific folder ? What kind of line should I include in my script ? For example, when I create an invoice, I want the file name to be the invoice number from the InvoiceID field and that file to go to my Invoice folder... Thanks for your help !!!

I have a single table layout and I want to transfer a calculation field's Data to new record using a new record script. Thanks

OK - new to FP. Hoping someone can help, since I'm overdue on solving this problem for our group. attached is the file i'm working on. my main problem at present is that the first layout, called "PEPFAR_POS" allows the user to select a country from a pull-down menu, and then select on POS (clinic) within that country. (this works OK, although for some reason that I can't figure out, after selecting the POS, the focus goes back to the country select menu?!?) then, the user clicks the button to go to the data entry on a specific patient, and i tied that to a script that should do the following: go to the layout "PEPFAR_PATIENT" enter browse mode create a…

Hey there: I have built a fm/sqlserver synch module for a client. On a layout, they are able to select the fm tables to synch and the fields within the tables that will synch. Based on their selections, I script the generation of the necessary sql statements and off I go. On the export (fm to sql) it works super. My obstacles are on the sql to fm side (we're using version 8). I am auto-generating the sql "select" statement as well, according to the fields they've selected to import. I'm using a sql plugin to make the sql call. My problem is the inability to dynamically tell filemaker which fields to populate when creating the new record. I have also tried to aut…

Hi, I have a date entered and now I want to calculate another date 12 workdays before the entered date, what would be the best way for this please? Thanks Robin

I have a database with a 2 text fields: (animal_name) which contains 1000 records and (photographer_name) which can have up to 4 people in it (photographer 1, 2, 3, 4). All I want to know is which animals are only represented by the first 2.

Hi, I'm working on a script now that is supposed to look through all of my records, find those with a particular characteristic, duplicate those records, then copy and paste certain fields into other fields and clear the originally copied field. It looks like this...abbreviated. Show All records Perform Find Duplicate Record Copy [select; Forms::Field2] Paste [select; Forms::Field1] Clear [select; Forms::Field2] Enter Browse Mode The copy/paste/clear function works great. The problem is that it only performs the script on the first record it comes to that fulfills the Find requirements and I'd like it to go through and handle all records that mee…

I would like to know how I change two fields (both with drop-down menues) whenever I run the copy event script. First field is "Show Status" which has 8 choices. The one I want to display on the copied event is "Need Info" Second field is "Show eng status" which has 3 choices. The one I want to display on the copied event is "Need techs". Anyone know how to do this?

I’m struggling with one little detail of my database, please help! I have 2 tables set up, one to receive orders, and one is the client profile which also tracks orders via a portal.c clients. In an attempt to uniform the information I want to automatically insert terms of sale and company name directly into the Order Form from the Client profile. How do I do this? Nothing seems to work.

I'm trying to develop a script that passes a value from one field to another field in a different table. I have two layouts, one for each table. The tables and their fields are: Layout1 ID Layout2 Layout1_ID My script as it is right now changes to Layout2, creates a new record and then quits. What I need is to somehow pass the Layout1::ID from the record that the script is executing from and have it filled into Layout2::Layout1_ID after creating a new record. I'm thinking this might be possible with the script parameter option, but I don't know how to accomplish this. Any tips would be greatly appreciated. Thank you.

Hey! I'm trying to show in a field how many record i have in a table. I only know how to show the current record, but not the total of them. Any idea? Thanks!

I have a database that tracks exhibitor orders for tradeshows. I need to add a new feature that would allow a user to choose items from the customers orders and create a work ticket. The work ticket would be used for items that "need to be done". Example customer ordered 3 tables and only has 2 in their booth. The work ticket should only show 1 table. As that is all that "needs to be done". Currently the main screen that is used to track customer orders contains a portal showing all related records on a layout that is connected to the customer. I plan to use Genx's "select multiple portal records" (http://fmforums.com/forum/showtopic.php?tid/180278/) solution to …

I have a solution consisting of 5 files. I would like to give my users the ability to 'save a copy' to a file path of their choosing by specifying it once and me applying it to the 5 files without their intervention. I don't see any way to pass the file path as a parameter to the 'save a copy' script command. I'm using developer 7 cross-platform. TIA

Hello, I've been trying to figure out how to get my script (which determines whether a customer is within credit limit) to run based on the customer that is presently being selected for a new invoice. Even if it was a separate button that is selected to determine credit limit status, how can I get run determine a certain customer. Right now the way the script works is it always uses the first customer in the customer table, the script seems to work otherwise. Code is below. Any help would be GREATLY appreciated. Thanks Dave Find [Over Credit Limit Invoices] Copy Perform Script [ “Allow User Abort” ] Perform Script [ “Set Error Capture” ] …

Hi guys, just joined. Sorry to annoy. I'm trying to set up a script to print with no dialog. I'd like the number of pages printed to be defined by the contents of a field in the database. I'd also like another field on the printed form to contain the page number printed (the form is a page long) so that each page has it's own number from 1 to however many pages are printed, based on the contents of the total required field. Any ideas how I do this on Tiger? Can I do it with FMP scripting or do I need to look at Apple Script or Automator? Cheers and thanks for your help. Bettsy

In my script, I am looking for a method to skip a record if the email field contains data. For example, IF email = NULL then proceed. What is the best way to do this? Thanks.

I know Filemaker has been this way ever since it was introduced: When a script is running, I can't go work in another window within my solution. I have to wait for the script to finish running before I can access any menu options or do anything in other windos. Is there any way around this problem, i.e. to get scripts to run "in the background" rather than monopolizing my entire FMP environment? Does anyone know if Filemaker, Inc. has plans to change this behavior in a future release? Thanks.

I am distributing a catalog of university courses on CD-ROM. Users can use the runtime solution on the CD to browse, search, and sort. But I also have a feature where they can add courses to a "collection" (like a shopping cart, but without any transactions). I've set up appropriate privileges for this field. This "flags" the course record. Obviously, they can't do that while running from the CD because they can't modify the "flag" field if the solution is on read-only media. So I would like to be able to detect at startup if they're on a non-writable volume (the CD). I can't figure out how. I've tried writing a random record in the open script. It gives the error t…

In order to set up email marketing lists, I display a list of all the contacts in our database. To add them to an email list I run a script to create a join record. The script Freezes the Window takes the id from the presenter and a global value (the campaign being worked on) as two values, it then goes to the join layout, searches for a record with the two variables, if it finds one it returns to the original window, if not it creates the join record and returns to the original value. Using the global value I have set up a relationship to indicate if the join record exists (i.e if a customer is on the particular email list) This all works great. The problem is…

Hello everyone, I am a beginner. I am pretty much clueless. I want to set a field only if the radio button is set to "yes". This is what I did: If[Property::Inspection="yes"] Set Field [Property::Repair; Property::RepairCost*1] End If Can anyone tell me what I did wrong? Plese help. P/S: I am trying to have the value in the field(target field in the set field function) changed when the scrip is executed, but only do so if the radio button is set to "yes". Am I missing something here?

This is probably a easy one, stops returning false on color after I add the second color condition. For example always returns true if either "Make" is true. If I take out one of the color conditions, then works fine. If [((Car::Make = "Geo")or(Car::Make = "VW")) and ((Car::Color ≠ "Silver")or(Car::Color ≠ "Black"))

I have a served file on server 8.0v4. I opened the file using FileMaker Pro 8.5 and updated a script. I then ran the served script from my client machine and it worked. However another user logged into the same file ran the script and had problems because the changes I had made were not being seen by the other user. We were definitely both in the same file because when he was looking at the script through the script editor it wouldn’t let me in it. The script steps he was seeing through his script maker were different from the ones I was seeing. I re-logged into the file from my machine and I saw the old script steps, as if my changes hadn’t been saved t…

Hello All, I wrote a script using script maker that performs a find, but I need it to only find items with the most trecent week. My DB is set up to set items with an ID for each week number, each week ID being higher than the previous. Is there a way I can insert a symbol in the "perform find" part of the script to only return the MAX number of week IDs? Thanks for the help!

Hey! I was wondering if it's possible to change the login page when you access your db with a browser. Thanks!

I am trying to use the Last function in filemaker V8.5 Mac. I have a repeating field which records timesheets and I want to run a script which will find the next blank (available) repetition in that repeating field. I have looked up the help menu, and followed what they have said: Go to Field[select/perform;DATABASENAME::FIELDNAME[Last(DATABASENAME::FIELDNAME)]] It doesn't seem to work - it does nothing. Any ideas?

Hello Everyone. I'm sorry if a thread for this specific topic may already exist, but I did a search and didn't find what I needed. Accounts and privilege sets are set for these my db. Is there a way a message can show saying "This username and password is currently being used" to ensure that people aren't logged on at the same time with one username and password? Here was my problem. Pat log ons with her username and password. While Pat is logged on, Paul decides to use her username and password and is able to log in also. I don't want that to happen. Thanks!

I'm new to FileMaker's TOs, having jumpted from version 6 to 8.5. When I ran a script in v6, from the current file to a related file, I would have to start in the current file, and run and external script in the related file. However, when I run a script in in the version 8 file, but in a different TOs, it works properly in one TO, the one that I created it in, but not when I try to run it from A Related TO. It doesn't completely work properly. The script is opening a related file, and going to a layout on a choosen TO, that is furnished in the Current File. However, when I run it from a Related TO, it doesn't go to the correct layout in the Related …

I have a table "Inventario" and table "Ventas" need discount item if is sale, the field "cantidad" need be modificated auto...Please can you help me?? Do you have a script for stock control??

Hey Everyone! I'm new here and am hoping that someone may be able to provide me with a solution. I have a database that I'm developing for a touring dance convention. The main reason for the database is to quickly sort the competition (where studios bring routines they choose to compete) so that there is the maximum time between routines that studios compete so that the performers do not have quick changes. Here's the Structure: 1) A Studio Registers all of their dancers and their teachers who are attending. 2) The dancers and teachers are all linked to the studio thru studioID 3) Multiple dancers are assigned to various routines (a single dancer …

Hi All, I need create a new purchase order line item from a request for quotes line item record which already exists in another table. Currently I'm using the set field script step but because of the large number of fields that need to be copied this seems a bit long winded. Is there some way that I could easily create a new P/O line item record from the RFQ record detail. Most but not all of the field data needs to be copied across. I tried searching the forums but didn't find much, maybe I specified the wrong criteria? Thanks for your help, Cheers Peter -)

Need someone's experience here. I am trying to use a very simple application of a second window. By script, a small window will open from a button to display a reference table. The problem is when the second window opens, the overall size of the original window (width and height) is reduced about 10% and stays that way even after the smaller window is closed. What is this all about ? very annoying. Also is there any way to lock the over all size of the second window, not allowing users to expand it or minimize it. ?

I am not even sure if this is possible but is there any way to open an application using a script? I am trying to use open url but i can't get it to work. I am trying to open an .exe file. Thanks! Dina

Hello, i have a database of songs. each song entry has a container field with quicktime audio. I want to be able to create a script that will go to the quicktime audio for a selected entry and play the audio (using command+any #). Does anyone know if this can be done? Thanks!

Hi, I've been searching for a way to show a custom dialog box where users can enter a search field (string), which I can use later as a variable to do a search. I've found this http://www.fmforums.com/forum/showtopic.php?tid/185536/post/244928/hl/insert+dialog+box/ and some other things but nowhere the code on how show an insert field that can be later used? Thanks Robin

Hi. I am in need of some help with this one. I am needing some ideas on how to create new records based on a found set of contacts and update them all with the same info. For example: I have a contact database and I will find a group of people then I will have a button that will take me to another layout where there will be a couple of fields such as "Date" and "Comments" and I would like to enter the data once in each field and press a button and have it create all new records based on the found set and auto enter the data from the fields in the records and in the 2 fields that I updated. Can somebody come to my rescue?

Hi, I was wondering if it's possible to check if a window is already opened (by name)? I couldn't find a function for this.. Thanks Robin

Built a looping script that decreases a field. I wish to see the field decreasing as the script runs, (Actually I want to film it, it is a mock count down screen for a video) The problem is with a "refresh screen" line in the loop it it will refresh but with a momentary flash or blink as it does it. How can I avoid this? Have tried switching to different layouts but too slow.

I don't know where to put this post, so I thought I'd start in scripting.. so I have two tables, a MAIN and a EMPLOYEE... and basically here's what I want to do... I want to be able to do a search for a name, which returns all employee info (not a problem).. but then I want to insert info from that record into another table, but I can't get that part to work. Currently I can get the two things I want to do to work separately.. that is (1) do a search (easy part).. and (2) separately I can get a record info to insert into a notes field based on criteria. Why after I find the record I want, can't I get the SetField calc to work? The fields are related, so sh…

Hi! A strange thing is happening in our scripts menu. After all of our files that are linked together open up, if you go under the scripts menu, all of the normal scripts are gone and only one shows up - which doesn't even exist in the file we're looking at, but DOES exist in one of the other files that opened up. If you go to a different file then come back, then the list shows up correctly. We've been using these files for years and have never had a problem, just started showing up, but not on everyone's computer. Any ideas? Thanks!

I'm trying to work out a scripting problem that is a typical "can't see the forest for the trees", I believe. I have a calculation field (ordertype) that looks at another text field (orderid) at the last two characters to determine how ordertype gets populated. the specific values I am evaluating of orderid are: L6309-00 L6390-00* L6390-00** L6390-00~ The last two numbers can be anything from 00 to 99. The case statement to find the "tilde" {4 above} works, the statement to find the "**" works, but not the one to find the "0*" sequence.. Case ( ( Right ( IDCode ; 2 )= "**" ) ; "M" ; ( Right ( IDCode ; 2 )= "@*" ) ; "C" ; ( Right …

Hellow again... Thanks to everyone who helped me solve my last problem! However, since I solved it so well, now my boss needs to know one more piece of the puzzle that was eluded to by several of you as you helped me solve the last problem! In the table below my boss now wants to know if we can capture the "dead time" between the machine start and stops. Machine..Date.....Start.....End 132b.....2/1/07...11:32.....[color:red]13:53 132b.....2/1/07...[color:red]14:24.....15:17 142a.....2/1/07...10:45.....[color:red]11:16 142a.....2/1/07...[color:red]11:23.....13:54 153b.....2/1/07...09:08.....[color:red]10:11 153b.....2/1/07...[color:red]11:…

Hi All, at the moment I use an "If" statement in the "Set Variable" script step to utilize the same script on several different layouts. If ( Get(LayoutName) = "Stock Requests" ; Stock Requests::StockID_SK; Purchase Order Records::StockID_SK ) I would like to make the layout name change dynamic so what ever layout I am on is part of the value = set variable script step, is this possible? Eg. The value part is Stock Requests::StockID_SK on one layout but it is Purchase Order Records::StockID_SK on another. All the other script steps are the same for every layout. Thanks Peter :-)

Hello, I have a problem with a script that I use to flag records that need to be deleted. Because I need the records to be displayed in a preview mode I am using a nav bar script I found thru this forum. My problem is when I go to flag a record thru the nav bar it flags the previous record and not the one currently displayed. If I run the script without the nav bar it flags the correct one. I need the nav bar to display the pages correctly. And I need the operators to not have to memorize a bunch of commands for each operation. I have attached images of both scripts the nav bar script and the one without. Please tell me what I can change to get th…

Does anyone know if its possible to create a script that would change the number of repetions that are showing on a layout. for example, if a field is defined to have 5 repetitions but only 2 are showing, the user could then press a button to show the more fields?

I am trying to write a script to check for a word in a field, and perform a task if it exists. The field contains several words from a value list, for example days of the week, these are selected by check boxes. So the field might contain Monday, Wednesday, and Friday, or Tuesday, Friday or Friday, Monday (no particular order). I want the script to run if it sees the word Wednesday else end. If I use the script step IF Days = "Wednesday" this only works if only Wednesday is in the field. So I guess I want the script step to do the same as a find (without the = sign). There is probably a really simple answer but spending ages on the forums hasn't reve…

Hello, I want to create a report that takes a date and sorts it by a range (like 3/1/2007...3/31/2007) and sort it. Sounds easy, but I want it to prompt the user for the date range. (popup window) Is this possible. I'm trying to create a one click and click OK, then it creates the report. I can't figure out how to script this? Any help..