Script Workspace and Script Triggers

I made a script to run on closing that asks the user to confirm before closing. If they click cancel, I want the file to stay open (I used the 'exit script' step unsuccessfully). If they click cancel it closes anyway. How can I stop it from closing if they click cancel. Phil

I have created a script to do a search but when it cannot find the requirements from the search it comes up with a message saying "No Records match this set of find requests" And gives me the option to Cancel, Continue or Modify Find. Is there a script that I can add to my search or to place have that search script, that it would cancel when it shows this message?

I want create new records based on a flag in a seperate table using a script that IWP (Instant Web Publishing) compatible. Normal if I did not need it to be IWP, I would find the flag, and import those records. What is the best way to automate this process, so that it is IWP compatible?

Good Day Faithful FileMaker Friends, I hope your weekends were a delight. So, anyone figured out how to single click on a field to enter and make edits and double click to activate a button? It looks like a standard feature in Access (is it anathema to say Access in this Forum? Feels funny coming off my fingers...) or at least the particular program I was looking at, the programmer scripted it... It would make life go very well in lists... Thanks for any input (or output), Royce

HI all, I have a slight problem and I am not sure how to solve it. I have a table that uses an auto entered serial number in the id field. Sometimes it would save a lot of typing if I just duplicated a record and made changes in one or two fields rather then creating a new recored and typing in all 10 fields. Of course the problem with duplicating a recored is that the serial number gets duplicated and is no longer unique. Basically I would like to duplicate most of the contents of a recored, and have a new serial number auto entered -- Is this possible? Thanks in advance.

I’m making an inventory script that will count the total number of a particular type of item. For example, if it were a automobile database, there would be a car type, a truck type and an SUV type. Without doing a sort based on type, I want to have a running total on the bottom of each record of that particular type. To do this, I have a number of global variables (or fields) with consecutive field names such as fieldType1, fieldType2, fieldType3 so on and so forth. I want to modify all of these fields with just a few lines of code instead of writing a very repetitive, 20-line if-statement to test which field I’m in. So I’m hoping I can write a script that ba…

I’m trying to clear a field every time I run a script. I’m using "set field [field name = 0]" when I do this. However every other time I run the script, it returns a 1. Why is this? I checked the other areas of my script and I even put together a simple test script. Still, every other run gives me a 1. Any ideas?

I seem to have a problem. I have three different printers that we use in the office, each with a different type of media. I have scripts set up to print to those specific machines for specific tasks. I run 8.5 on all the machines, with our server running the Server version. All was well, until a few days ago. Now none of the scripts will call up the correct printers, or if they do, it is only on certain computers. I've had to insert dialogue boxes to allow users to fix the printer. Any reason why this should become so unstable? I've tried rebuilding the scripts with no luck. Any help would be appreciated. Thanks,

I have recently run into a problem when using a global container field in that I can't access the document that is stored there. If I change it from a global container to a non-global container, I don't have a problem accessing the document. I have used this successfully in the past, but for some reason I can't get it to work now. Has anybody run into this problem, or could you possibly shed some light on what I am doing wrong. Thanks in advance.

I'm trying to create what I thought would be a pretty simple script. It's just a button that when you click will create a new record in a related table and fill in the related field's value. The tables are in 2 different FM files and the related data from the table I'm trying to create a new record in is displayed in a portal on the page I'm putting the button. So the script the button is attached to is: Set Variable[$$Control_Number; Value:Purchase OrderItems::Control_Number] Perform Script["Create New Scan Record" from file: "Purchase Order Items"] Go to Layout [original layout] The Create new Scan Record script in the Purchase Order Items file where th…

I have a database with 15,000 names. When I want to add data to one client I run a find request entering a few letters in the last name field and a few letters in the first name field. With so many names, I have several clients that have the same first and last name. What I would like, is a script calculation that would run when I do the find to make visible a container field with a graphic that says something to the effect "Caution - Client with same name exists".

Hi! I am making a database were most of the tables is from another database. I´m reusing scripts and layouts from the old database and all works fine. BUT when I use the go to related post I choose for example my table "offert" and wants to show it with layout "Offert", then in the script step it says: go to related post from Offert with layout invoicerow. I dont have any laout called invoicerow!! But it all works fine and it goes to the right layout.. a presentation bugg?? Regards Jocke

I want to write a script that will use the same criteria for a find (like ">0") but I want to use a parameter so that I can set the find to a different field each time I use the script. It seems like it would be very easy...I think I'm just overlooking something. But I can't figure out how to write the script so it keeps the criteria for the find but performs that find on a different field(that would be assigned by the parameter). Please help if you can...

I've throughly confused myself. I have an oracle database which I import into filemaker. If I want to update filemaker, and only import the records in oracle which have changed, how to I do that? Similarly, if a record is deleted in oracle, how do I tell filemaker to ditch that record so it's just as up to date. My current import reccord script is just a simple sql query I made in the scriptmaker feature. I just import records that match a sql query, but how do I get it to delete records that no longer exist in oracle, while at the same time, not duplicating records already imported into filemaker. Thanks folks, Jake

Sorry if been asked but I didn't have any luck finding my answer with search. I am new to Filemaker and have a general idea of what’s going on in it. What am I wanting to do: I have created a Field with a Radio Button of yes and no. I have some fields that I only want to be displayed only if yes selected and do not display the fields when no is selected. What have I done: I have created 2 layouts one with all the fields and one with the fields i don't want to see. I have set the default data type for the Field to no. I have created a script that works the way I want it to but I have to run it manually. Script: if [layout1::fieldname = "Yes"]…

Is there a way I can create a script that will automatically open the file I have in a container? I am putting word documents and CAD Drawings into these containers and these are files I have already on my computer. All I seem to be able to do is Export the file, create a second copy, and then it opens. All I want to do is open the file from the container without having to save it again. Thank you for the help David

Hopefully there is a simple solution to this that I'm overlooking!! I've got a multitude of scripts that are quite lengthy (read: they take 3-30secs to run), and I'm heavily using multiple windows with different layouts. Here's the problem, while a script is running, if a user clicks on another window (with a different layout of course) while a script is running it continues operating, but on the window that was just clicked -- often with disastrous results. Is there any way to prevent the user from being able to interfere with a script while its running? Thanks for everyone's time & knowledge on this! Running on Mac OS X 10.4, FM Adv 8.5

I use a Send Event Script to delete a folder on my C: cmd.exe /C RD C:Numbers I will like to know how to delete a .txt file from my C: using the Send Event Script? I appreciate any help Thanks.

I made a really big mistake and acidently set the first script step in the "File Load" script to be "Close Window". So, I can never actually open the database up because it instantly closes again. I know that you can hold down "option" to bypass the auto-login otions, but is there a way to bypass the login script? Or, am I basically SOL thanks to my stupidity?

We want a record that is marked 'Completed' to be locked and not editable. Does anyone have a good way of doing this? Thanks in advance.

I am having a bugger of a time with this one script we use for creating new records. I built up some new layouts and imported the button using (copy) and then (paste layout objects). It works on the old page but not on the new. In fact all of the other buttons work on the new page but just not this one. The button is supposed to create a number of records (that we use to print labels of) based on the number we fill into a field called (total_reels) For example it we type in 7, we should be able to click the button and 7 records will be created. THE PROBLEM - It begins creating an infinite amount of records and does not stop until I hit escape. Any sugges…

Hi all - I seem to be having a bit of a torrid time at the moment lol - just going so slowly. I would be very grateful for any help on how to automatically refresh (within a script) fields on a portal. The two fields are both calculations (which can't be stored) so I figure I just need to refresh the fields from within a script but I can't seem to find a way to do. Many many thanks Simon

Hi all, Hope someone has done this before, seemingly easy to do but just can't find the right combination to get it correct. I have 2 fields, both text boxes, lets call them textbox1 and textbox2. I want textbox1 to be a data entry box when users have something to enter they will type it in, hit the "submit" button and that text will be copied to textbox2. However, textbox2 needs to append that data like a journal (data entry1, data entry2, etc...). I've created a script that copies the data from textbox1 to textbox2, but that's all it does, once someone creates a new entry it wipes out the previous entered data in textbox2. Anyone know how to do t…

I am pretty proficient in FileMaker Pro but I'm weak in scripting. I have a database I'm building but have to import data from 3 separate excel spreadsheets. I've done the first one with no problem; however, I would like to add some fields from the other 2 spreadsheets without duplicating what I already have and would like to add records that don't already exist. How do I do this? Thanks. -Dev

Hi all, I am a complete and utter newbie to filemaker but have extensive experience of other dbms's (SQL Server, Oracle etc.) I am trying to do something very simple in a script but have no idea of the Filemaker syntax. Basically I have added a serial number column to a table that has existing records in it. All I want to do now is retreive all records and loop through incrememnting the value in that field by one so that I have a sequential number in there. I have looked at examples of looping through records on the web and they all start with Go To Layout Steps. What are layouts? Are these the equivalents of tables? How do I do the equivalent of SELECT * F…

Version 5 Having trouble with the logic. Have a POS System and want to take the Sales information (Mulitiple Records) and transfer them into another database (Close out). Each record in Close Out represents a Day. Thus I want to take the sales records from sales (mulitple transactions"Records" and transfer them into one record. Have a fixed number of fields in the Closeout file to drop them into. The logic gets harry for me when it has to take the data from 5 or 6 fields and drop them into First entry fields. If they have something in them, drop to the next fields down. This may be an IF statement or a Case statement. Just having trouble figuring the best wa…

When a field is defined as a drop down value list the user can select from the list.....But they can also enter whatever they want into the field. Is there a way to limit the user to ONLY what's in the list? Thanks, Mel

I have seen this before but I am unable to find it among the forum postings but what I am looking for is the script steps to perform a date range find using global fields. Utilizing the show custom dialog box and its built-in input fields as oppose to making a separate layout. If any one remembers how or have came across a posting, please let me know. thanks.

I am trying to develop a simple chequebook file. One feature is to be the auto entry of transactions [listed as records in the autoentry table] into the account journal table. This would be thru a script that would run when you opened the file. For example, if you have a debit record for your car payment, when the script runs it sets a global to Get(CurrentDate) and if this matches the transaction date for the car payment, a record is made in the journal. I have made a looping script to go through the auto entry records, using a global counter. This works fine. But when I insert an external [journal table] script to make the new record inside the loop, the loop does …

Hello again, I am not sure that this is the correct forum but I am new so would appreciate redirection if necessary. This post is a little long but I would appreciate any insight you guys can give on what is going on. I am writing a business system application for a project based company. I have separated the data into BusSysData.FP7 and the layouts etc into BusSys.FP7. I have a table called "activities". I have another table called timesheets. An activity can have one or more timesheet entries. The timesheet requires a peopleID field to be completed that stores a foreign key to the "people" table as a number. One activity type is receivin…

Hello again i have been looking but have found no topics, in my solution i get the MAC to speak text on certain scripts very kool... now i see there is a Beep command. is there a way i can change the "sound" of this beep. maybe play a sound from the computer..... Just want to polish off my solution thanks RT

Is there a script that could check when entering a number if it has been used? For Instance we assign unique inventory numbers (1 letter then multiple numerals) such as B12345 to each entry. I was hoping there was a script that could alert us when we enter a number that has already been used. My guess is it would have to run after the number has been completely entered in the field so it wouldn't keep alerting us as we typed at B1, then at B12, B123 etc, etc. Any help would be appreciated and if anyone has a solution to my post the other day about the endless new record script problem that would be great Cheers Dino

I have created a script that sets the find/sort criteria according to one of 6 possible buttons, plus a default setting. It works, but just seems clunky and repetitive, and wanted a more experienced person to see if there is a cleaner, slicker way of doing the same thing. I was originally was going to use "Get(lastActiveObject)" to define what button was pushed until I found out that it does not work with buttons! The attached file basically just contains the script file. Date_Calc_Test.zip

Ok, broke down and purchased FM 8.5 Advanced, shezz, the trouble it would have saved me earlier in copying scripts and dealing with them in general! Anyway, is there a way to post a script other then a screen shot, or making a sample file?

Hi, I am trying to bring order to portal. Order id and quantity. There can be one to many order for one customer. I can not make a script that brings ordes from a file to filemaker 7. Example order item_id quantity 2011 3 2013 7 . . Number of items can be 1 to many in one order. Can anyone help, please. Thank you. Janne

I have created a sales database that I need to be able to delete records. But for privacy purposes the record cannot be deleted altogether, the auditor must see it at year end. So I was thinking to create a button that would actually just move the record out of the one db and into another for the auditor and call the new db Deleted Records. But I don't know how to do this. Any help would be much appreciated. Thanks!

Please help a dyslexic with this issue: Problem - I have three tables, email table, leads table and leads newsletter table. The leads table is a portal in the email table. The script action is to go to the first row of the leads portal and send an email, than go to the leads newsletter table and create a record, than return to the leads table and go to the next row and repeat the process. I have been able to have it all work except the last record in the row is not being acted on. The only way I have been able to make it work is to create a dummy record in the leads table with the highest id number so it is the last record in the portal row. Not the most elegant…

Hello cannot get my head around this i want to search all my invoices and if the balance is <0.10 set the invoice state to "paid" i think my script is correct but alas it is not working. here is what i have.. and is this the best way to do this, the script willl load on log in and logout... thanks

Can't find anything on this in the forum but I can't get the input field function of the Show Dialog step to pass the value to the record. I have a record in a portal and wish to change one date field which then is followed in the script by recalculating another field in the record. All goes well until I authorize the acceptance of the new value in the dialog box, the returned value of 1 (right button). This is supposed to allow the input value to replace the original in the field. The existing field value is shown in the input value box so it must be looking at the corrct record and field. But when the script step is completed the new field value is a ?…

[Post 1 of 2] Hi all I have an application with a main script. A key part of the main script or start up script is a loop that I used just to Display the license agreement if necessary. I don’t expect it to actually loop but I don’t know any other way to do this. Its suppose to set a variable then go into the loop. If the agreement has been read, It will set a variable and exit loop. Well, this part works. But if a variable is set to “No”, it performs a script to display a layout with the license Agreement and below it is a sentence that asks the user: Do you agree? With two buttons “Accept” or “Cancel” If the user press the Yes…

Is there a way for a script to tell if a user is in Find mode when the script is executed? I need the script to do something different if executed in Find mode (some of my check boxes are buttons). Thnx!

I'm trying to develop a solution for my company and as a "Newbie" I'm lov'n every minute of it! (I love to learn new stuff!) As my solution grows I have layouts for this and tables for that and scripts for both. The question is (and a VERY general one)..... In the largest solution you've written, how many tables did you wind up with? Layouts? Scripts? Table Occurrences? Just wondering what I have to look forward to. Thanks, Mel

I try doing the self join relationship method described in help, but I get a message in the calculation box either that it cannot find the table or I am not entering data correctly. I want to delete duplicate records but not manually because there are many of them. Please help

This is a real head scratcher: In several solutions, I have a limited "back button" script (FM 8.5. ) that works flawlessly on every PC and Mac I have tried it on EXCEPT my prime user's SONY VAIO 505-01 laptop. When he clicks on the script button, the screen goes to a grey screen with no visible elements in the FIlemaker window. Filemaker must then be quit and restarted. Since the script works perfectly on all other computers and platforms, I'm assuming it isn't the script. Does this makes sense? (Would be happy to post it) Has any one have had any issues with the Sony Vaio? I've seen some mentions, but not this type of problem. Many thanks in adva…

In my solution, the gray Status Area isn't visible so users won't have easy access to go to a particular record by typing it into the white record count window...and I'd like to avoid having them having to go to the Records menu to use the 'go to specific record' choice. So, it got me to thinking that maybe I could code a little script tied to a button on-screen that when pressed, would kick up the windoid asking for which particular record they want to go to. "Easy enough," I thought. "Just code in the ALT (key) + R + G + S and I'm good to go." Well, it isn't that easy: I don't know how to code the ALT key in to script. :S If you have an answer, or a better …

Hi, I have a folder that contains around 200 images which I want to batch import into 200 new records. I have no issues with the process of importing via script but is there a way you can read the folder contents into an array that contains the filenames and generate a looping script. My problem really is working out a way for filemaker to read each filename in the windows folder. Thanks in advance!!! Matt.

(Hope this is in the right place...) I want a way to enter a number in field1, then have that number automatically added to field2, then have the field1 reset to have no value. I'm learning my way around FM, but I'm still pretty green when it comes to scripts. Thanks!

Hi, What is the function that retrieves the connected computer name? Thank you

I have a script which imports a serial number field from one database to the other. The script works well EXCEPT when the first database is logged in with limited permissions...then the import order no longer lines up. I do not want to do matching names import because it overrides like-named auto-enter fields such as CreateDate and CreateUser. Anyone been able to solve this problem before or have any suggestions? Your help is greatly appreciated.

I am looking for a way to time portions of a complex script that involves several loops, in an effort to optimize the code. Is there a way to access current time milliseconds on FM? An Applescript would also work for me. What I would like to do is to assign elapsed time to variables in key places in the script, sort of a benchmarking function. Cheers, Andreas

Hi guys, I am relatively new to the FM world - so please forgive any very obvious errors... The problem I face is probably one that I guess has been solved many times before. What am I really trying to do: When a user enters a sales invoice line they need to be able to select a product code for that line. Because there are so many product items they need to be able (on a separate layout) to search for a range of stock times according to parameters that they enter and then select the most appropriate item (and return that item code to the invoice layout (which has the line items in a portal). Background: I have a table called "products" w…

I have a file number, how do I create a script or option so when click on the file number - it will link to a shared path? Example: FILE12345, when I click on the file, it will open the share link: servershareFILE12345 Thanks

I have an external file (SMTPIT Pro) that sends emails to leads (stored in a separate database). Each email batch I send has a title such as Newsletter 1, Newsletter 2, ect. In the leads database I want each batch title to be entered into a repeating field so I know what Newsletter that particular lead has been sent. I have tried to figure this out without much success. When the new email is sent the previous title is being replaced instead of being entered on a new line in the repeating field. Any ideas on how I can make this work? Thanks in advance for your help - Sam

Hi all I would like to be able to perform a keyword search on a single field that has keywords listed in it. I have prepared a single search layout for this function. I would like to be able to just enter a keyword in the search field on this layout and perform a search for keywords within the single field in the table. I would prefer not to have the user enter any special characters such as wild cards. I have performed a search within this forum but I haven't found an example. thanks in advance for any help.

Parsing an Address This problem is beyond my abilities. Any help will be much appreciated. I would like to parse a field which contains an address into separate fields. Example: LastName FirstName Title CompanyName Address City, State, ZipCode Phone email WebAddress If you do not have time to answer this question, can you point me to where I can find the solution. Thanks in advance for your help - Sam

Is it possible, and if so will someone help me write an open script that will send a user a specific layout based on thier account/privileges. I am almost certain this can be done but I can't find the right area in script maker where I can insert a calculation to make this determination. Basically: On opening database, If Account name = XXX goto layout YYY If Account name = AAA goto layout BBB etc. Thanks in advance for any help. steve

Hello, I'm constructing a database for a chemistry lab that I work in. It is an inventory database and I'm writing a script that will perform a search function. In the database there are three fields i would like to search: "Common Name", "Formal Name", and "Alternate Names". Chemists are not too bright so we have 8 names for everything. All three fields are in the table "Supplies". What I would like is the ability to search all three fields at one. This is my current script that performs a search of the field "Common Name": Enter Find Mode[] Show Custom Dialog["Find An Inventory Item"; "Enter Item Name"; Supplies: Common Name] Go to Field [suppl…

Hi All Newby here. Have a script that duplicates my record but it seems to want to duplicate 2 or 3 times when only 1 duplicate step is put in the script. How do I stop this please thanks Col

Hello, We use a button to import a file to a container. We then have a button that uses Open URL[table::container] to open the file. This works perfectly fine when you test it but if you close out of Filemaker Pro and reopen and try clicking the Open URL button you'll find that it doesn't work anymore. Tech support says it's not a supported method to open up a container even though it does work that first time.. So this brings me to my question, is there a way to open up a container in it's native application? Instead of bringing up that save dialog box? Thanks in advance.

I have a wacky case where the Open URL command does not open the correct URL. This behavior occurs when calling Open URL from a script, as well as a button assigned to open a different address. Let's say I want to go to http://website.com/lets/go/here/ When triggering the Open URL command with either the script or the button sends me to http://website.com//lets/go/here Notice the double slash after .com -- that's the problem. If you remove the extra slash from the browser's address bar, the address is correct. Further, this only occurs on one machine, a Windows XP box running FileMaker Pro 7. The behavior occurs in Firefox 1.5 -- I don't have the neces…

Hi Folks! I am new to the forum and am finding it really useful. My question is as follows. I am have a database that is a doc library type application. I have a container field which is for images. What I am trying to do is extract the filesize of the image and if possible the pixel dimensions of the image. Any ideas. I apologise in advance if a topic is already up for cant seem to find it. Thanks!

I have the filemaker Re-LogIn script step at the start of my script. If I press cancel the script still finishes. I have tried putting in a condition. If "get last message choice" = 1 (or in fact 2) to halt the script. But it does not seem to work. Why can I not halt the scirpt if the log in fields are empty? Or is there a condition that will know if the "cancel" button has been pressed on the standard login function?? There must be a way???

I'm Stumped! (again). I have a pdf document in a container field. I'm trying to figure out how to place a button on a web layout that would open the document with Acrobat Reader on the remote users computer. I've found it can easily be done if on a LAN but can find nothing about making it happen via web. I'd be eternally greatful for any ideas you might have. Thanks, Mel

Hello, I am new to FM and I need to develop an application that produces multiple reports from the same data. I have developed two layouts that will give me the results I need. When I run the script it stops on the first layout and won't proceed to the second layout. Ultimately, after both layouts have been run I need the combined results to be faxed together that is why I need them to be automated in the same script. If I am going about this wrong please set me straight. Attached is the script I have so far: The FaxIt Report merely takes the first and last names, orderid and date and places them in a list format and the FaxIt report lists t…

I am wanting to make a reusable script for a "Quick Find". Basically I want a script that I can pass via a script parameter the value I want to search for and the object names for say 3 fields I want the find to search for. Obviously this would not be necessary if I used the Set Field step, but I want this to be a script I can simply copy into any file and based on the script parameter passed would work on any table without any modification. For example I would pass "Name|object1|object2|object3" to the script. The script would then parse out the four values into variables $Value, $o1, $o2, and $o3 and search for the value in any of the three fields. Where I am a…

I have a need to develop a script that will search for funding records for future years. In my system i can create related funding records, and assign them a fiscal year (e.g. 08/09). I already have a field that calculates the current fiscal year based on the current date. Is there a way to do a search for any funding records that are in the future (beyond the current fiscal year)? I am not sure if a ">" will work since the year is a text field like 06/07, 07/08, 08/09, etc. Thanks for any guidance

I have a database that I use to print 2 sets of documents from 2 different databases by a part number. So you enter in the part number in a field click the button and bam you have both sets of paperwork for that part number on the printer! Well I wanted to add into the script the following, I have 2 sheets of paper I want to print out with those 2 sets of paperwork, however the number of sheets i want printed need to equal the number of records in one of the databases. So database #2 could have 20 records for that part number, I want it to print 20 of each sheet (the extra 2). Incase Im not clear or your confused heres a bit better explanation. We have 2 se…

Hi all. I am new to the list and may ask some questions. I want to create pdf with FMP 8.5 and save them automatically with a custom name (from a field) to a certain folder (path from field). Can I do it with FMP8.5 or do I need an additional plugin? If yes, what plugin is recommended? Thanks a lot Greg

I have an inventory system that I am trying to finish in Filemaker that I originally had in Excel. In Excel, I was able to filter columns so I could see only the items I was looking for (ie - only see all the computers that are iMacs, etc.) I'd like to have the same function on a column layout in my database, but I can't figure out how to make it work and can't find any articles that address this idea. Can someone help?

I have a file that executes one of two scripts (depending on a test) in a related file. At the moment I have to begin this process with a button to execute one or the other of these scripts, then return to the file I am working in. What I would like to be able to do is have these scripts run automatically whenever a new record is initiated. Anyone know how?

Hi this is really beggining to bug me now (put lightly!) : I have a filepath that is set through variables, part of my script does the following... Insert File into container X using variable Y as the filepath. Now sometimes the file may not exist under this exact filepath and/or name so I need to do the following... If file not found show custom dialogue file not found please select another > insert as reference into container X and reset variable Y using this filepath and continue inserting the file elsewhere. What filemaker does is throw up "File blahblah, cannot be found" , then displays the insert file dialogue, which is not acceptable as t…

I need some help. This is complex, but here goes: I have three files on FM 8 server. I have a products table in an inventory fm7 file that is using an edi fm7 file to make a http request and import some xml data into the edi file. That data in the edi file is then imported back into a catalog table (CT) in the inventory file AND into another catalog file (CF). I can import the xml data into to the edi fine. Due to some oddities in the xml feed I have to import some fields into the edi fm7 file in some return delimited fields which must be parsed after imported. I use some scripts in the edi file to parse these return delimited fields out into separate fie…

My solution, started many years ago through 4, 7, 8 and 8.5, works perfectly. I'm starting a renewed effort to rework the database except that ScriptMaker scripts now refuse to reorder and when the script is dragged and dropped to it's new position, the script assumes the name of a script below the dropped script. I can actually have several scripts with the same name. If I click on one of those scripts to open it, it shows the correct script contents for the title but after closing that script, the script below it now assumes the name of the script below it.... and on and on. When I OK ScriptMaker to close and then reopen, the scripts are in their original order...…

How do you check to see if a variable exists before you run a script that is dependent upon that variable having a value?

Hi all, This one baffles me: The initialization script is OFF. (no scripts running on file options Open/close) ... yet, when opening the file the records come in sorted and the sort dialog contains a sorting field. ... I clean up that sorting dialog. Close the file. Then, open the file and again that sorting field is still active. What is it possibly that I miss ? Thanks Thomas

OK, here's something that I don't know where else to ask, or if this is even the place to ask. I work in a college library, and we use Filemaker Pro 5 (will be switching to FMPro 8.5 in the next 6 months). At some point in the past (before I started), a database was created that lists all of our periodical holdings in both print and online. This database is then made available on the Library's web-site so that everyone can see what we have. What I have discovered is that the fields that contain a URL for an online title, will open the URL in a new window. There are currently 8 fields used for URL's; of those 8, only the original 4 will open a new window. Fou…

I have done that script to make sure the appropriate invoice is created and that the invoice will go in the right folder but it doesn't seem to work. When I click on the button, only the If/Else with SP72, SP144, SP216 seem to be working but not the H125, etc...ones... What am i doing wrong ?

Hi All, I've written a script that checks if a related record (R/R) exists for the current record using the find process. If a R/R exists the script automatically goes to it, if no R/R exists (error code 401) the script asks if one should be generated. I would like to use the GTRR script step rather than a find but I can't find an error code to match no R/Rs found in this case? Thanks Peter :-)

I'm sure this is a "FileMaker 101" question so just call me an idiot! I'm experimenting with repeating fields and for the life of me I can't figure out how to set the next available empty repetition. My little test script just replaces the first. How do you populate a repeating field? Thanks, Mel

I just bought a computer that has (unfortunately) XP Media Center. Some of my scripts in 8.0 Advanced crashed the program. (Windows needs to close the prgam now...We are sorry for the incoveniuence) I updated to v3 on the FMPro site. Got rid of one set of problems. Still left this problem: My scripts that call an email field to send an email to, crash the program. Any ideas. Thanks.

I'm working on a MacBook with intel processor and Filemaker 8.5 Advanced. I have a script that beguines with "If[ Get(Systemplatform)= -1 ...... etc. If I start mij FileMaker 8.5 via Rosetta it is working just fine but if I use it native it doesn't recognize the system. Is there an explanation?

We are running FMP 8.5 on Filemaker Server 8.0v4. I have set up a script that logs user statistics (date, time, user computer name). I would like to log the ip address of the user's computer. Any ideas on how to do this? Thanks, patriciag

Hi folks. Quick question. FMP6, Tiger. I have more than one email account in my Mail program. How do I control which one the script uses? It doesn't give me an option, and it always chooses the wrong one. Cheers

Is there a way to script a FIND then delete just the records in the FOUND set? I am using SET VARIABLE command as the criteria for my find. I have been able to get to the scripted find okay but I can't seem to delete just the found set. My options seem to be to delete just one record or all the records. Any ideas how to (via script) delete just the found set? Thanks, Jarvis

I wrote a script in my contacts database that closes the window, when I open the database. Now I can't get into the database to fix it! What do I do?

How do I open an excel workbook to a specific worksheet whose name matches the contents of a field in FM7? I have tried to use a hyperlink but can't get FM to pass worksheet i.e. c:/workbook.xls#sheetname Thanks!

Hi all I would like to simply password protect a layout with a simple custom password using the custom dialog feature in FMPv8.5. Not sure how? Would not want to use the builtin security features within FMP.

I have a script that is fairly lengthy. I have put, at the start of the script... "Allow User Abort" Off However, the script can still be escaped (by pressing "esc" key) by the user during its function. Is there something I need to Add with this function in order to not allow the script to be aborted during its cycle.... Its causing me big problems.... Yes, I have tried it with User Abort ON too... Can Any one Help??

I am not even sure if this is possible (a: being a novice, b:being new to 8) but I figured since I can get it to do this as script for a current record - there should be a way to loop and get all of them exported at once I figured out how to do the current record with a script with lots of help from various posts here in the forum now i am trying to put this function into a loop to export all records - and I cannot get my head around setting the script up -it loops but the variables stay the same any help is greatly appreciated and just a ponder of mine, but why, when they did fm8 didn't they include a simple "export current record" option l…

Dear FileMaker Gurus: There is a FileMaker v.6 DB on Server v.5.5. Each Book, for sale, has 3 statuses: Active, Freebie and "Out Of Print." I want to write a script for the "Status" field: if the status is "active," then the price must be "larger than" "$0.00." Help please! Happy New Year! Everyone! Max NY

Does anyone know of a way to attach two or more attachments using the send mail function? I can include one attachment easily enough but I really need to attach two documents. Both of these attachments are created by FM by the way in a previous script step.

Hello everyone! I am trying to use a custom dialog to set a radio button. The dialog says would you like to do something: default button is no and button 2 is yes. if the user hits no this will end the dialog, but if the user hits yes then this will set a radio button and then insert text into a portal and set a global price in the next field. I have looked at the radio script file that was posted, but that was not working. Any help would be greatly welcomed. Thanks

Is this this script ok ? (it works), but I'm Looking for some advice on the best way to write it. thanks for all your help.

I am trying to write a script that saves a report as a PDF..."Save Records As PDF(Restore; No Dialogue; $wip report; Records being browsed )" I am using a variable ($wip report ) in the "specify output file" as seen above. When I execute the script I get a message that the file "$wip report" cannot be create on this disk blah blah bla. It looks to me that the "Save Records As PDF" is trying to save the file with the variable name and not its contents. Is this the way it is supposed to work?

I am trying to make a script that will find and show the only record that user owns. For example, user 1234 logs in and is shown only his record, if it exists, if not he's taken to a start screen where he can create his record. On subsequent logins,1234 would be taken to his record. I want only a single record per user. This seems like it should be fairly easy but after a couple hours I am now going in circles. Please help (btw, this needs to run under IWP). Thanks.

Hi All, I am wander how can I write a case statement for something that I don't want to show the return blank space if no record in one of the following field. Any help will be good. Thank you in advance. <> <> <> <> <>

I want to automate a copy command between two tables in the same file by using a script. The tables looks as : Table1 : Rec 1 fieldname1 “info1” Rec 2 fieldname1 “info2” Rec 3 fieldname1 “info3” Rec 4 fieldname1 “info4” Must be copied to Table2 : Rec 1 fieldname1 “info1” and fieldname2 “info2” and fieldname3 “info3” and fieldname4 “info4”. I using the following script but it doesn’t work Go to Layout [Table2] New Record/Request //Prepare empty rec. Go to Layout [Table1] Go to Record/Request/Page[1] //Only for sure ! Loop Copy[select; Table::fieldname1] Go to Layout [Table2] Go To Field[select/perform] Go To Next …

I need to create a "History" of jobs held by employees - what's the best tool to use? Bsically I need it to serve as an Audit Log as well as a visible "employment record". Does that make sense? I really have no clue as to where to start. Tips? Too general of a question? Thanks in advance!

I'm trying to pull the name from a field in one table. Go to a report page and perform a seach using the name from the field that i grabbed from the first table. I know this should be easy and i'm trying to use the get (script parameters) function but i seem to be messing things up a little. Any help with this would be great. thanks, Jonny

I have a table named eBay_Auction_Fees with the following fields: Fee_Amount, Fee_Name, ID_Auction. There are times when we post an auction to eBay through FileMaker and it gets double posted (I have yet to figure out why). Because of this I need a way that I can quickly find duplicates. Any time an auction gets posted twice, duplicate fee data is inserted into the eBay_Auction_Fees table for that auction record. So if an auction was charged a Listing Fee of 1.00 and a gallery fee of .35, I end up with 4 records in the fees table: 2 for the Listing Fee and 2 for the Gallery Fee. Of course all 4 have the same ID_Auction value which is how the relationship is m…