Script Workspace and Script Triggers

I want to give each new company a primary (ID) number such as 161, 162,... incrementing by one as each new company is added to the database. Now as contacts within the company are added to the database, I want to allocate them under the same primary number, but as a decimal number of the primary number, such as 161.1, 161.2, 161.3,....., etc. Methinks this is not an easy task? Whereas in excel it is relatively easy starting with a seed number then subsequent numbers are =ROUND(IF(C5<>C4,INT(B4+1),B4+0.1),1), etc. All ideas and/or solutions accepted.

I don't know if this is the right forum for this question, but I try. I have a customers directory where each customer have a customer ID. This customer is also stored in another directory on internet with the same customer ID. Now I would like to make a script so I click a button in FM 9 and the script takes me to the browser and right URL and insert the customer ID in the right field in the browser. (I use Mac but would like this script not to be depended on platform or browser) Is there any tutorial or help to get?

Hi all, I am working on a script that merges two duplicate records. Currently, I have it setup to go to the merge layout, cycle through each field, and copying the information from the other record to the current record. The script looks like such. Go to Layout["Merge Layout'] Go to the first field Start loop Set $CurrentFieldName to ActiveFieldName Set Field[GetNthRecord ( $CurrentFieldName ; Get ( RecordNumber ) + 1 ) )] Go to Next Field; Exit loop if last field End loop The problem is that the information being returned from the GetNthRecord function is just the value in the variable $CurrentFieldName and not the information stored in that fi…

On my new user layout I have 7 fields that must be entered before the user can continue to the next layout. Each field that must be entered has an "*" by them. When the customer clicks the Continue button here’s what I’d like to happen. 1. If all fields are all entered they go to the Customer layout. If not they are unable to go to the next layout and get a message saying something like “the fields have not been entered”. I would like this message to be a calculation field instead of a dialog box as we may use IWP later. 2. I would like some way to show the customers the fields they omitted. I have not idea how to do this and hoped you may have a good way to do…

Hi, I need to get 2x scripts going, one that can close an open database in FM Server 8 and another that will open it for publishing again. I'm very new to filemaker and I haven't been able to find any examples of scripts similar to this. Any help will be much appreciated. Thanks (ps. it's not for backup so the backup function in FM Server scheduled tasks won't help me)

Hi all, I'm relatively newbie to FileMaker, but I'm struggling with it (basically with the ScriptMaker) for a month now. I've got two tables: products and colours_rel: Products (Id, ProdName, ...), being Id the Primary Key. Colours_Rel (FK_ColId, FK_ProdId, ...), being FK_ColId a ForeignKey to a Colour table and FK_ProdId a Foreign Key to Products(Id). I would like to remove all related records from Colours_Rel and inserting new ones, or at least be able to modify the existant ones. I can read all of it, but only modify the first, because they are not repetitions but related records, so I managed to read them with List: SetVariable[ $colors; …

I have a unique CustomerID in my Customer file for every customer. What I want to be able to do is have a script button from my customer file that will make a new record in the Invoice file for that customer so the CustomerID and CustomerName will show on the invoice and make that invoice unique for that Customer. One other thing that is important is if this button is ever clicked again for a current CustomerID that it “does not” go to the Invoice file and make another Invoice number. If the CustomerID is already in the system, we would like the button to return them to the Home page. I would sure appreciate your help, Carl

Hello all. Please excuse my newbieness. I have a script here that I can't get to work. It's a script that looks up a date in the DB via custom dialog. Once it has gone throught multiple sections (fields) to find this date; I want to take that set found and copy them into a new set of blank fields to emulate those that have been found. The reason for that is because I want to add another condition that if those set of date fields are blank, don't show that row of fields. Anyhow, right now I can find the set of records but it is not copying and pasting with the exception of the first repetition. I have a screenshot of what I have here: http://www.benecab.com/misc/45…

Up until quite recently, the following worked fine in 8.5v2: Open URL [ "file://c:/CameoDevelop/CameoHelp/Appendix17.html" ] [ No dialog ] Now, that does nothing, but omitting "file://" works: Open URL [ "c:/CameoDevelop/CameoHelp/Appendix17.html" ] [ No dialog ] (It makes no difference whether forward or backslashes are used.) The change in behavior may have happened around the time that I installed the fmp 9 trial. (I've removed the trial, however). Any clues in solving this mystery would be appreciated.

I create small in/out reports for different items much like a library or video store (they are created in a separate database but share an inventory number relationship, since I will create multiple in/out reports for a single item in the database), and wish to have them listed in the main database in one field totrack activity and see when something is in house or checked out, but I can't seem to get the most recent one to show up in the field window, it always defaults to the oldest, how can I adjust it so that it shuffles them into order showing the newest on top and the oldest on the bottom?

Hi, I am working on an inventory management system and am having a problem. I have made a mock calculation field that looks like this: IF(IsEmpty(fieldx)=1 and IsEmpty(fieldy)=1;"yes";"no"). This calculation works; however, when I attempt to plug the logical test into a script using the IF script step, the AND operator doesn't seem to work. If I use one of the logical test instead of both, my script runs perfect. Below is the portion of the scrip that is giving me fits. >Else If [Get(FoundCount)<> 0] >>Go to Last Record >>If[isEmpty(Staging::Returned to Warehouse)=0 and IsEmpty(Packaging::Time In)=0] >>>Delete …

I have a script that changes the value of a particular field. I would like to start the script with something like "if this user is not allowed to edit this field, then exit the script". I have seen the "Get(RecordAccess)" function, but not one at the field level. Any tips? thanks in advance.

Hello everyone, I have bee browsing the forum trying to figure out what do I need to do to accomplish this. I just want to use a multiple dropdown list to display records that is based on the dropdown selected. For example,I want show records from canada, I will select canada from the dropdown and FM will display all records that have Canada as country. Thank you for your time.

I have a date field in a Custom Message Box, and I've found that if the user enters "9/31/2007" my script fails (since there is no September 31st). I've tried IsValid(dateField) but this returns true for "9/31/2007". Is there an easy way to test for a well-formatted but meaningless date using a calculation in a script step?

I sure hope you guys are willing to read through all this and help with a solution. We have two types of Users. "Patrons" and "Customer". Both of them come to the same layout when the solution opens and will brows the same layouts. Patrons will look at products and vote on them, Customers buy products, based on the voting of the Patrons. For the sake of this discussion, Patrons are NEVER Customers and Customers are NEVER Patrons. OK, so a person comes to our site and at this point, we don’t know if they are a Patron or a Customer. They will make that determination as they view the site. I guess my sense of it would be, if the person viewing the…

There used to be some freeware around that, instead of printing or creating a pdf file, allowed you to create a Word or RTF file out of an FMP report. I used to use it with fp5 when I was still using a Mac with OS-9. I can't remember the name of the developer or what the application was called. It worked really well and was incredibly useful. Anyone know of something like that? I am sick and tired of exporting things as .tab files and then re-formatting them.

Hi, I am still very new with FM. I just bought the Mail to FM Importer so I can archive all my email from time to time. I also want to expand the capabilities in the future. Here's the question: How can I convert/parse the "From" or "To" field from "John Doe , Jane " into "[email protected]¶[email protected]"? So basically extracting the email addresses only and separating them with a return. If possible I also want to make them automatically inserted to a repearting field. I've tried to seach the forum with no luck. Thanks.

Hi, Is it possible to call a script from a calculation field? This is what I am trying to achieve: I have a dropdown field, and I need a script to run whenever something is selected in this field. My code is simple; I am using several IF and EndIfs. Set Field [Total_Paper;0] If [Left(Items[1];5) = "Paper"] Set Field[Total_Paper; Total_Paper + Line_Total[1]] End If If [Left(Items[2];5) = "Paper"] Set Field[Total_Paper; Total_Paper + Line_Total[2]] End If Since the above is not possible in a calculation field, I coded the above in a script Any help is sincerely appreciated. Thanks.

Is there a script step equivalent to the Control-Home key combination on the PC? When the user tabs to a text field containing a large block of text, FileMaker places the cursor at the end of the block and the first lines are out of view at the top. Control-Home on the keyboard shifts the displayed text back to the top. I need to provide a on-screen button to do the same thing for easy mouse-based viewing. I've tried Set Selection [] with coordinates of 1 and 0. That moves the cursor to the first character, but doesn't shift the displayed portion upward, so the text cursor disappears. I'm drawing a blank on how to accomplish this and any suggestions will b…

Just encountered an issue with a new version of my solution (new file names). I was able to use file references to find all the right sources for updating clients to the new version EXCEPT I use the ValueCount function to determine the number of entries from ValueList("fileName","ValueListName"). My calculation was incorrect because this 'fileName' is not handled by the 'file references' I set up. I stumbled onto this during some testing. My fear is that I have some more of these buried in little used corners of my solution and would like to 'search' for the potential problems before my client sees them. Any way to search the script code for occcurren…

Hi Does anyone know if it is possible to insert a tab using the 'set field' script step. I would like to set titles before data collected from fields and have them all line up nicely in a single text box. Possible? Any help greatly appreciated. Thanks :)

How Do I set a field with the value that is stored in a "variable". Thus, I have used the script step "Set Variable" with a value of 1 and I need to post that value into a field.... say "field A". How do I do this?

Hello All! This should be really simple... I have 2 database tables that are unrelated (and I wish them to stay that way). I'm wanting to pass some data from certain fields in one table into a new record in the other using a script. Using the set field script step or insert calculated result doesn't seem to pass anything - the lack of relation seems to provide no 'source pointer' so to speak and I don't want to copy & paste the data! In the past I have avoided such a problem by relating the two tables in question (which then seems to allow the set field script step to work). What is the best method of passing this data or a way to set some ki…

Is it possible to use GetLayoutObjectAttribute to get the html information from the 2nd or 3rd frame that appears in a WebViewer window? (I also asked this question in the Web Viewer Forum)

I am reluctantly about to incorporate a plugin into my solution. But since I must, I would like FMP to be able to install it on any machine that does not have it. So here are the required steps. 1. check for pluin (do a version check) 2. if error, export zipped plugin from container field, into FMP extension folder. 3. trigger apple script to unzip file. Then I would have a message for the user to quit and restart app. Has anyone seen a solution such as this?

As a novice I'm wondering if there happens to be a pre-written script that would provide FM Pro 9 (not server version) the ability to generate a running log of everyone who accesses any FM databases, showing IP address of PC that accessed the database, date, time, and file accessed, and possibly even whether the file was copied or downloaded.... I've been advised by FM that this capability exists with FM Server but it could be scripted...if anybody knows how to script such a thing.

The original post obviously is in cyber heaven. Here's the problem. I am trying to set up phone dialer to work with Vonage. I have called their tech support and they don't even know what FileMaker is so they were no help. I tried routing a phone line from my computer modem to my phone. No effect. I then tried routing the line directly to the Vonage router. Still nothing. I also tried to run the line thru my Fax machine to no avail. I noticed a choice of "Internet Connection: H 323 Line." But, quite honestly, what I have found online does not make sense to me. Has anyone set up a phone dialer? Any help or direction is appreciated. Can anyone recommend an…

Hello, I'm new to filemaker so this may be an easy question. I can't figure out how to shorten a text field to two sentences. I'm assuming that some how I can split on the second period. Thanks in advance.

Hello, I have tried and tried to get all records from last week to display. I have read this topic probably a billion times. When I do this- it shows me all records that are previous to 5 days ago... I want to see records from 9/21- today (and have it automatically show the last week's worth of records). My test record set has records from 9/4- today. Maybe I am just missing a simple " or something Any help would be greatly appreciated. Thanks in Advance test_lastweek.fp7.zip

how do i do a script that if I have 2 parameter. parameter A is cheek in date and parameter B is cheek out date. how can i cheek that if parameter b is smaller then parameter a it will tell me?

Hi Guys, We have a sign up layout that you have to fill out (11 fields) for you to become a user. What we want to have happen is once the customer is finished entering data into the fields and clicks the Enter button two things will happen. A script will check to make sure fields are not empty and error trap some of the fields where it’s reasonable to do so like. Phone Number: (US only): 10 Numbers Social Security: Number: 9 Numbers Email address contain: (@ and .) etc. If all criteria match they go to the next page. If the criteria is not met a message comes up saying, “You either forgot to make an entry or the information was not entered corre…

HI I have a login script which uses Show Custom Dialog BOX script step. The dialog box has 3 buttons Default button->Continue, Button 2->Cancel Button 3->Change Password. There are 2 input fields associated with this custom dialog box. The fields are from GLOBALS table. g_login and g_password fields Problem comes when I enter login name and password and press button 3. The login name and password do not get input into g_login and g_password fields. They only get input if I press Continue(default button). Since I have a check to see if Login name & Password are entered, I get into a loop if I press Change Password button. Please help me unders…

Hi. I have a variable called $$SelectedUser that is determined when a user selects a user from a drop down list. I am trying to use that variable in a report title. e.g. Results for User $$SELECTEDUSER but it simply prints it verbatim. Do I need to do anything to the variable name in the layout so it prints out the contents of that variable? Greg

I'm trying to use phone dialer on a VoiP. I set the script step fine, but can not get connected. I have a modem set on my computer as well as a wireless connection. Since I am 3 - 4 feet from my internet modem having a direct connection is not a problem, if needed. Has anyone had any experience setting this up with VoiP? Any suggestions, white papers would be appreciated. I tried running a phone wire directly to my VoiP phone from my modem, no good. I tried running the wire directly to the Vonage modem as well as connecting it directly to a regular phone. Still no luck. TIA. Al

Hello, I am making a file to run an "IF" script to compare two fields. In a simple file with just a few tables, it works fine and a comparison is able to be made. But in my file that has many tables, this function is not allowing the fields to ever match. I have contacted the technical support but they say this is a design issue. Any ideas? Thanks so much, Karl

Hi all, In Filemaker 7 pro ... is there a way to export a script as text ? For reasons: 1. To have a printout 2. To do some keyword searches on some long scripts Thanks -T

As you can see I'm new to the forum and need a little help. What I want is for a customer to click on the "New Book" button in the Customer file that will take them to the Book (Invoice) file where a new record will be made for this customer. Each customer has a unique "ContactID". Once a customer has been assigned an invoice number, that is the only invoice number they will ever have. From that time on when this customer clicks the "New Book" button, they will go to the same invoice they were first assigned. Do I also add a customer "ContactID" in the Invoice file? The Invoice has a Line Items portal on the layout and this is where all new books will be a…

I have a problem with one of my scripts. The script does a few things: -Calls a VBScript w/JobKey passed and this script then visits the job folder, and converts the cad drawings to gif images. -Goes out to the TAGS table, searches for a job by JobKey, if there's tags it removes them (delete all found records). -FileMaker then calls an import routine to pull in the tag records from my design software. -Once done FileMaker searches the new tag records and omits out the records w/valid item keys and whats left it deletes (delete all found records). This has worked fine in both locations (NY-Database local, PA-Database through VPN), but lately it se…

Hi -- I'm a little new at scripting..... I've got a portal set up on a Film Title table giving access to a list of Actors, filtered alphabetically based on a global field the user types in to narrow the range of names. I want to put a button in the portal which, when clicked, will run a script that creates a new record in a Join Field that represents an actor's appearance in the current Film. So, I've designed a script that grabs the ID key of the current Film record, goes to the Join Field layout, makes a new record, enters the Film ID and then returns to the Film layout to get the ID key for the actor in the portal line whose button was clicked by the user. …

I have a problem with using global fields in a multi user environment. As far as I can understand a setVariable script step may help me but I am unsure how to use it. basically I have a table T1 viewing records from Table T2.... I currently have a global field that sets the portal row I wish to view then I create a new record in T1 then go to portal row where the global field has the correct value. so sometimes as its multi user this field is not the best thing to use and the script fails. Q. how do I use the set variable script step to go to the portal row that has been set in the record prior to the new one being created. or, Is there another way that I can…

Hi Guys, Got a bit of annoying vista problem: I can't export files via script -> I get a "file could not be created" or some rubbish error, its the same one that you get when you specify an incorrect file path. So I have two theories, 1) Its a security issue which I just can't work out. 2) Filepath's are evaluated differently in Vista than they are in XP 3) Im clueless... I should mention that this script does work fine on XP. Cheers for suggestions.

While is Save as box, I copy, then try to paste, does not work. It's as if FM just does not copy to clipboard. very weird.

Hi Everyone, I know how to go to Accounts & Privileges and set up what I want a customer be able to see and do. That works fine when you open the solution as you would with the office server. But how do you set it up when you design a Filemaker web site where you want the person to be able to look around some before signing up. Once they go to the sign up layout and enter a new “UserName” and “Password”. That’s when I want them to be assigned to our “Customer” Accounts and Privileges. I have no idea how to set that up. Again, I know how to set up from Accounts & Privileges. I just can’t figure out how to implement it from within the solution afte…

Is is possible to create a script that will take the user to "view as table"?

I'm new and know just enough about Filemaker to get myself in real trouble. But here goes. We are designing a Web site run from FileMaker. We have a standard sign up page layout located in our “Customers TO” where the customer set up an account with “User Name and Password and general information. Here is where I need your help. After the customer provides the information. They click on the NEXT button, are automatically assign a CustomerID” and a New Record is made in our Entry layout in our “Selections TO”. This will be the only new record ever provided for this customer in this TO so that every time they come back and enter their User Name and Passwo…

I'm trying to figure out how to insert a picture into a container field. I have been using the "gotofield" and then inserting the picture into the field. But I need to put the picture into the field when the field is not on the layout. I'm hoping this is an easy one. Thanks, Mel

I'm sure this has been asked many times, but it's a hard one to search for. Is there a way for a script to select which field to enter data into, based on a calculation? For what it's worth: I'm doing the old classic parts-assembly database. I want to the script to enter the ID of the current record into the join file either into the "Parent ID" field or the "Child ID" field, depending on the parameter passed to the script. But I seem unable to get FM to behave this way. (And yes, I know I can create related records through portals. I have my reasons not to wish to do so.) Any help?

Looking for a way to create a script that runs daily, without having to restart my database file every day. Want to review a date field, and prompt an alert when certain conditions are met and a date field equals the current date. Only idea I have is a start-up script, but that requires quitting the file every day. Something easy I am missing? Thanks!!

hi how can i make a script that when i have 2 fields and when filled b is bigger then filed a it will give an err massage and then it will go to that filed

is there a way to get the local computer name... Get Hostname only returns the server host name, I need the name of the computer that "clinet" is running on.

I've got a file called Invoices and another file called InvoiceItems. Of course, InvoiceItems holds the items in each Invoice and they are related by InvoiceNumber. I've got a script setup to create a credit memo for the current invoice. I was able to use FM script variables to store invoice data and then insert it into the new credit memo. However, I cannot do that with the InvoiceItem data because it's in a different file. I need to loop through all InvoiceItem records that relate to the original invoice and add them to the credit memo. Any information on how I can accomplish this would be greatly appreciated. Thanks!

I have an FM9 scripted import that imports - FM to FM - each of the tables in a previous version of the solution. Each table import is handled by a sub-script of main Import script. Everything works fine except that for each import I am prompted to enter a Username and Password for the Source file. Both Source and Target files are identical and have the same Accounts and Passwords. I can get around this by asking the user to open the source file first, but I'd rather be able to script the opening entirely and have the pw dialog only appear once or not at all. In order to determine the location of the Source File, which will vary from user to user, I'm using the Troi …

I am importing emails and the "from" field shows up in this format: john smith , I need to strip all the first characters and < > off so that the email reads: [email protected] Is there an easy way to do this?

Hi all, There is one database file that has a layout with a button. When I press the button a new window pops up and the contents of that window should be the layout from a second file (external). So, I go to the second file. Create a script that contains a "go to layout" command. This command invokes the layout from within this external file. However, the result is ... nothing ... the external layout does not show up within the popup of the first file. What am I doing wrong ? Is it a matter of refreshing a window somehow ? A matter of sharing permissions ? ... or ?

I have a client who would like to add a feature to one-click duplication of a sales order. I can think of a few steps in this process, but get stuck. My current steps would be: 1) Go to related order line records (show only related records) 2) Go back to Orders database 3) Create new order 4) Copy order ID 5) Go to Order Lines 6) Create a loop to duplicate each line item and paste the new order ID into that record. (THIS IS WHERE I AM STUCK). 7) Return to new Order in Orders table for final editing. I am stuck because, when I duplicate the first line item, it appears at the bottom of the list and becomes the active reco…

In my products file I have a products layout with a Products_Filter portal showing all our products. When you click on any row it triggers a script that shows a picture and full description of the product below the portal in the “ProductInfo” field. Once you have clicked on the portal row you can then vote on the product you selected. Either Yes or No. You don’t have to vote, you just have the option to. Special Note: It needs to be set up so you can only vote if you are a "Customer" as shown in the "Status" field in the "SignUp" field in the Customer file. What I want to have happen once a vote is made is have the field called “Vote” on each row of the Product…

I have a portal that I would like to operate just like can be done in script maker. I would like to have small up and down arrows left of each portal line and be able to grab the arrow and move the line up or down to reposition it. Can anyone point me in the right direction? I've written a script that lets the user click on a line then move it by clicking on another line which works fine but being able to drag the lines would be much easier and more professional. Thanks, Mel

Hi, I have this problem: I have repeating fields with pop-up list with e.g.drugs, group, cost and anmount. After choosing in drugs, values for group, cost and anmnout are looked-up. And I want next: after confirm by button, i want to e.g. copy SELECTED to another field in another layout. my problem is next: i need script which look from 1st to last repetition of the field and if it is not empty do something. And second problem: if there is a drug from group e.g.1, the script would copy this drug to another repeating field on next free position (my problem: i dont know how to tell him, that im trying to paste something in the first FREE repetition of rep…

hi, in case there is no answer for my previous msg, im wonder if there anybody knows IF and in case of yes, HOW can i custom function in version FM 5.0. (i want to use this function: If ( IsEmpty ( GetRepetition ( RepeatingField ; StartingRepetition ) ) ; StartingRepetition ; Let ( StartingRepetition = StartingRepetition + 1 ; FirstBlankRepetition ( RepeatingField ; StartingRepetition ) ) ) ) thanks a lot

I have four tabs in a Tab Object - each has a portal showing the same relationship (just sorted differently). I am trying to script the user going to the fourth tab (called "Add") and going to a specific portal field in the last row. Unfortunately each time the script runs, the cursor jumps to the first tab object rather than the fourth, even though i am using the Go To Object step. If I add a Go To Portal Row [Last] as the final step it goes to a completely different Tab set on the same layout!

Hi, I have a following script and I would like to add a condition to it so that it will check if one or both search fields are empty. Cannot figure out how to add that to it. Set Error Capture [On] Go to Field [select/perform; Global_fields::Product_Create_Search_Criteria] Set Field [Global_Fields::Product_Create_Search_Criteria; Inventory::Item_ID] Go to Field [select/perform; Global_Fields::Product_Create_Vendor_Name] Set Field [Global_Fields::Product_Create_Vendor_Name; Inventory::Vendor_ID] Go to Layout ["Product" (Product)] Adjust Window [Resize to Fit] Go to Record/Request/Page [First] Enter Find Mode [] Set Field [Product::Item_ID; Global_Fields::…

Im trying to create a database for work that will Give me the available printer cartridges for each printer I have created my normal Asset Database and Created fields of the Ink for those printers What i want to happen is for the 2 databases to be linked so I can go into my assets and see what is available for that particular model The Exact Detail I want is (refer to picture below) When a Cartridge Number is Entered in the Assets Database I want it to grab that Cartidge Numbers Availability from the Printer Cartridges Database I dont know where to put a script but it seems like one of those If "Black Field" = "C4550A" ... sort of things i forgo…

I have a script that imports data from an ODBC source that updates a record in an existing found set. There is one record in the table. It goes as follows. Go To Layout ["Globals-Data: (Globals) ] Show All Records Import Records [No Diologue; DSN; Filemakerelite; Calculated SQL Text; etc. ] Import Records [No Diologue; DSN; Filemakerelite; Calculated SQL Text; etc. ] When I run this script it works as expected. It updates two fields in the record. Each import maps to different fields. The "import order" updates records in existing found set. When I call this script from a "control script" that opens a new window just before it is called the impo…

I think I've asked this question on here before, but I have a solution and I'd like to share it and see if others can help make it better. There are a few parts of the script which currently need to be adjusted which I'd like to make portable to any user and any file. Here is the basic script (for use on a mac with built-in iSight and Photo Booth application)... #This script will not work till you specify the user directory under the "Insert Picture" step & the last step. Perform AppleScript [tell application "Finder" delete file "Macintosh HD:Users:crain1jp:Pictures:Photo Booth:Photo 1.jpg" end tell] Perform AppleScript [Tell Application "Photo Booth" t…

I have a startup script that checks to see if the host NIC is the same as the NIC stored in a global field. The idea is to check if the application has been copied to another PC. Problem is, the host NIC changes, depending on whether the host has wireless networking or bluetooth turned on. So, what I want to do is see if the stored NIC CONTAINS the MAC address of the LAN card. ie, "contains" instead of "equals". The LAN card MAC address is the part of the NIC most likely to be present each startup. How do I do that ?

I am in currently trying to do a Set Field from a field in Table A to the same name field in Table B. When I debug the script, nothing happens at the Set Field step. There is data in the field in Table A, and the types are the same. The tables are related also. How can I accomplish this?

I am trying to write a script that will print a file. I have a field that calculates the path: strDIRPath & FileName & FileType (output serverPrint Outtext.txt) I have a button that runs a script that calls Open URL and opens this file. Now I need a button that will print this file (without opening the file). Any suggestions? If there is a better way, please let me know! thanks in advance

Hi, I am writing a script that saves the current records to an excel sheet using the "Save Records as Excel" script. Is there a way to set the Page Layout of the excel sheet to Landscape. I tried Print Setup script but that doesn't help. It seems its only for Printing. Please help. Max

I have a simple db - two tables. The db keeps track of a tennis league. Players may play Singles or Doubles matches. In the Match layout I have a multi-key field that relates to the primary key of the Player field (_fk__Player_id and _pk__Player_id respectively). This enables me to show the match info in a portal on the Players layout for the two or four players involved in the match (depending on Singles or Doubles match). I have a Cartesian join, enabling me to show all the players while on the Match layout. A button on that portal populates the fields Player_1, Player_2, Player_3, and Player_4. At the same time, the multi-key match field is also populated. …

I searched the threads herein but had no luck in finding a solution for this problem: You tell users 'til you're blue in the face to be sure to enable the "Store only a reference to the file" option when inserting an image into a container field. But do they remember? Nooooooooooooooo. Is there a "scriptable" command I can put in an Insert script so the box will be checked automatically after an image is inserted? TIA for your help and replies! Rich

good day! i'm trying to get a script to omit records that have certain values in a particular field. i used the perform find script function with omit records indicated, but all the records continue to end up in the final product. what does [Restore] mean in the script? is it putting the records back in? i'm afraid i'm a bit rusty on filemaker, as i only manage one database which has worked well enough for our purposes for several years. now, i'm trying to do a little streamlining and finding i don't remember much about what i was doing when i originally set it up. thanks

Hi, when I run the "scan to pdf" script, FM crashes. Is there any way of overcoming this? All help welcome!!

I'm not sure this is the right place for this question so if not please let me know. I'm working on a marketing system that allows the user to request a new job and view their current and old jobs. However, I don’t want the user to be able to request a job on a day that is already full with other job requests. So, what I have done is had the marketing unit assign a numerical time to the jobs that they do (ex. Brochure = 12 hours of work). When the user makes his/her request the system will check the day and if the job can be completed on that day, based on all the other jobs turned in, it will allow the request to go through. If the job can’t be completed on that…

Is there a way for a script to position the cursor in any field? I'd like it if the error-checking script could place the cursor in the field containing the error. "Go to Field ($fieldname)", if you will.... Thanks, Chap

Hi, I have a process-heavy database that runs a few local scripts, runs an external script, and then saves up to 6mb of files to a network drive. As it is, I think I can click onto a window and interact with FileMaker at some points as everything is running... how can I lock things down so that a user can do nothing until the scripts, both local to the first database and also the external scripts, are done running?? Is it enough to set "Allow User Abort -Off" on all scripts and subcripts ??

i have three databases: - RM_Songs - RM_Catalog (CD's) - RM_Catalog Items Each record in RM_Catalog contains a CD # and tracklist. The tracklist is made up of 20 or less portal records that are typed up in RM_Catalog...however, the portal records are created and store in RM_Catalog Items. Each RM_Catalog Item record contains a unique RM_Songs ID and RM_Catalog ID and tracklist # etc. WHAT I WANT TO DO BUT CANT DO: I want to create a script where I can dupliate a record in RM_Catalog (a CD) but also duplicate all of the portal records (tracklist) along with it. How do I do this? Please help! Thanks;)

I have a list of items from which I want to remove specific items based on another list of items. So if List A is: Mouse Cat Dog Fish Bird And the items to remove in List B: Cat Fish Producing a new List A: Mouse Dog Bird I can do this with a looping script and a substitute function that would remove one item at a time from List A but thought I would see how others would aproach this as both lists could be very large and looping might be slow. Thanks, Steve

So I am making an inventory database. There are large purchases of identical items. Ninty percent of the records content can be identical except for say an Inventory ID and the parts serial number. I want a data entry person to be able to create one record that has all the identical stuff entered then multiply that by the number of acctual items. If that werent all I also want the script to auto create the inventory Ids for each record basically leaving only the parts serial number empty. To make things crazier the Inventory Ids are comprised of the two digit year of purchase "-" 4 digit incrementing number followed by a letter to indicate what the items is. examp…

Hi, Have been trying to do this for a couple of days but no luck so far. I have a field in my database, when I click it a window will popup and user will do stuff and eventually select a value. When the user exits the popup - that value should be written to the field the user originally clicked. I want to use this on several fields, by passing in the clicked field's name, and having the script update the calling field. I am trying to do this using the Get(ActiveFieldName) function. Here is a test I have tried - have the text field act as a button that calls a script, passing in Get(ActiveFieldName). Script's contents are: SetVariable[$i; Value:Get…

Good Evening. After several hours of web searching, and not finding the answer ... it's time for an email list post. Background: I have a database called "centers" with about 50-100 records. One of the fields is called "numcopies" One layout is called "cover letter" One layout is called "flyer" The two layouts are personalized for each record. Task: I'd like to run a script that goes through each of the records in the database. For each record, I would like to print one copy of the cover letter (the layout called "cover letter"). After that one page is printed for a record, I want to print the flyer for each record ... but I want to print the …

Hi all I am trying to get a second table to appear in a new window. I want this new window to appear in front of the original open window so the user can use the information in the second window as a reference. Sofar no luck. I get the second window to appear with the table but the first window minimizes and when I maximize the first window then this window cover the second window. Is there a way of having to windows open at the same time and view eaach one. I have attached a file to better explain what I am trying to do. Open the file named PQr_entree Thanks in advance. Your have been a great help to me in the past years. Lionel basemetal.zip

Hi, I would like to be able to split a field into two fields. This field contains text see below: Bridge House¶63-65 North Wharf Road I would like to split this from the pilcrow. Important note to consider the pilcrow is literal. I have tried to use rightword in a calculation field but as the number of words vary from record to record I can't get a clean result.I'm not able to see a good text function that fits my needs. Any ideas? Thanks

Gday! I'm having some problems with trying to get filemaker to perform a search (or at least a constrain) for a user entered date range. Essentially all the records in the file have a 'Service Date' (service_date) assigned to them and what I'd like to be able to do is allow the user to enter a date range of their choice that they can search by. I've created two global (date) fields as parameters (x_service_date _low and x_service_date_high). Next, in scriptmaker I've tired to create a find or omit based on: --------------------------- -Show all Records - Omit: service_date < x_service_date_low service > x_service_date_high -------…

I was wondering if it was possible to execute a script without using a button or making it part of the file options as either a start or close script. Is there an "event listener" type of script that executes only after certain fields have been filled out? Thank you in advance, Carlos C.

I would like to create a script that will create a new record in Database_A and then set Field_X in Database_B = to the primary key in Database_A. After Field _X in Database_B is set it will link the two databases. It has been recommended that we should not use the copy and paste script steps, but I am having difficulty getting the script to work without these steps. Is there a better way to script this link without the use of copy/paste? Any

Does anyone have an idea on how I could set up a script or layout that would allow a person to essentially "sign off" on a document that they have read that is in a database? Thanks.

I am trying to create a script that will grab the purchase request number for the current record and insert a link to it in an email that can be clicked on and will take the recipient of the email to that record. The users the email is being sent too all have Filemaker installed and usually leave it open all day. Is this possible? I am using Filemaker 9 Advanced to develop and Filemaker Server 8 for the hosting of the database. Any help would be greatly appreciated.

Hi I have a number of runtime files which I am importing into a master data base. Unfortunately I have to keep entering my Password to do so. Is there someway I can put that into my script so I dont have to keep entering it? thanks

So I wrote a script which searches an entire layout for a letter/word/phrase. How can I generalize this script so that I can run it on any given layout, and not have to make a custom search function for each layout? Currently, you can see (above) I am calling layout specific fields. I think need to use functions I guess to call fields dynamically, as they say. Explanation of script/variables: $search_term is the user inputed search string $search_field is the field being searched by the script in that particular iteration of the search function $end_field is the field the search ends on (it stores the field it started with, then goes through all fields i…

I have just migrated a solution from 6.0 to 8.5 without major problems except one. A script step calls the Duplicate record/request to copy a record. In 6.0 this step works, but does not in 8.5. the error code returned is 3 - unavailable command. The user has full access and is in Browse mode and on a layout based on the table whose record is to be duplicated. Can anyone suggest why the command may not be available?

Can someone have a quick look at the attached file? I have a script that creates a portal record and then "Scroll Window" to selection, but it doesn't seem to work at all. The window is 170 high, so I need to scroll down after the portal record is created. I'm using FM9 A, Mac OSX. Thanks! Scroll.fp7.zip

I am trying to run a script on a field that contains a person last name and first name. I want to copy the last name and put it in it's own field leaving the whole name in tact. I tried Right words. But that removes it from the name field. And I did insert calculated result but that did not place it in the Last Name field. As you can tell I am not very good with calculations or scripts. I am sure this is easy but I am at a loss. Thank you in advance. Cmack

I'm trying to insert a picture into a container (which works) at the same time grab its path and store it in another field. here is my script it works for inserting the picture but only inserts the path to the filemaker db file. Go to Field [table::container_field] Insert Picture [Reference] set Variable [$$Location; Value:Get (FilePath)] Insert Calculated Results [select; table:text_field; $$Location] Any advice is greatly appreciated.

Hello, I am trying to make a logbook to calculate gas mileage. Each record has a to and a from column (I am trying to do this in table view) what I would like to do is when I start a new record, is to have the to in the previous record, automatically appear in the from of the new record......any suggestions?: Thanks, Tom

Hi All Every since I have switch from FM6 to FM 8.5 I notice that the Set Field Command is not as reliable as in FM 6. Today I have spend two hours trying to get a simple set field command to work. The relationship between the two files are valid becasue in the releation ship box I checked the box to create a record and the record is ceated when the script is run but the two fields are empty. I have redone the relationship twice and delete the two set field commands and add them back to the script but I get the same results as before. This script has run in FM 6 for two years with no problem but I can not get is to work in FM 8.5. Has anyone else had this problem? …

>>using Windows XP Does anyone know of a keyboard shortcut to write a field reference into the entry text box? I can select the field by tabbing to the fields, arrowing to my selection and pressing the spacebar to highlight it, but when I hit , it simply closes the window. I've tried any combination of and and , but nothing seems to work. Anyone know the magic? Thanks, Esme

Dose anyone know what the "scope" of a script run in FM is? Ex: I have a script that builds a many to many link table. I have a subset of a table that I get by performing a find in the script. I then loop though and build the link table with a goto "link table" command and set the appropriate fields. My question is do I need to preform the find of data each time I return to that layout. Go to layout 1 Preform Subset Find Loop Go To Table Layout A Get Unique Id A Go To Table Layout B Preform Find Get Unique Id B Go To Table Layout C Preform Find Get Unique Id C Go To Link layout Set Links Go To Layout 1…

I would like to suppress error messages during a script. The script produces a field validation error but then goes on to fix the problem by entering valid data into the field. The Error dialogue box comes up even if I have included the "Set Error Capture (On)" script step. From the help files it sounds like this does not capture all errors. Is field validation one of them?

Hi I have a FM Solution that I use daily to book jobs in, What I am trying to do is have a script that when selected creates a folder on a networked. Each Job has a unique Job Ticket No. I have a Windows File Server that has about 100 customers folders. Filemaker will have to create the folder in the right customers folder and name it's unique Job Ticket No. Is this something that can be done? Any help would be much appreciated. Regards Peter

Found this script in FM Help and I'm trying to implement it into my DB. In the following example, you create a script to clear the contents of a field with five repetitions count=1 Loop Clear [select;FileName::FieldName[count] count=count+1 Exit Loop If [FileName::count=5] End Loop What is [count] at the end of the Clear script? What goes in here, the word count, the value 1? And how do I get it in there, does it go in the Repetitions box? Also count=count+1, there is no script step for count that I can find, I found it in the Calculation box, but how do I get it into a script step? Yes, I know you all hate Repeating fields, a…