Script Workspace and Script Triggers

I have a portal with the list of customers who bought a specific item. I'd like to send a group email to all the customers in this portal. I guess I have to use scripting but how ? When I assign the Send mail to a button in the portal, it only send to the specific customer so kinda stuck. Thanks

Hello I need help I have to files in exel that I imported into FM8.5 One has info of a call center File name is "Call Center.xls" Date "date" Time "time" Phone called "nmber" Phonoe origin "number" On the other file I have File name "Media info.xls" Phone Called "number" Time start "time" Time end "Time" CPS which is basically a number I need to properly evaluate each call that comes in.. comparate to a number on the other table BUT also it has to be in between the Start Times and End times of each phone number.... So I can get the cost based on when the call came in... This is the formula that Ive used in Filemake…

I am trying to make it easy on my users who access the application over the web. Is it possible to have a logon script that finds records based upon the user's logon?

Hi there - I have a script which imports image thumbnails into a field using Import Records command. I have created a button to execute this script, but I would like to have this button bring up a pop up window which will allow the user to browse to the folder which contains the images to be imported. Basically, I need to specify the data source as a folder, and then allow the user to add a folder to the "folder path" list. Any suggestions appreciated!

I need help writing a bar graph script. This bar graph will consist of several fields in which I want to change the color. I will use fields Start Date, Due Date and % complete for the calculations. I want to use a calculation that gives me a number that I can to use to change the color of several fields thus producing a color bar graph. Any thoughts would be appreciated. thanks, Bob...

Hi there, I'm new to Filemaker and this site so if I've posted in the wrong forum please point me in the right direction. We have a quote or estimate section in our office system. One of the buttons allows a user to create a pdf of the quote to send to our customers. By default the "Save Record as PDF" window that comes up will save all the records being browsed as opposed to just the current record. I'm very worried that a user might unknowingly create a pdf that will contain all our quotes and send it out. Is there a simple way to write a script to confine the PDF to the current record? Thanks.

I want to have in my records a continual date that change every day but in a special format so I have made a script that I give you below: Continual date script: DayName (Get ( CurrentDate ))& " " & Day(Get( CurrentDate )) &" " & Case(MonthName(Get( CurrentDate )="January"); "Jan"; MonthName(Get( CurrentDate )="February"); "Feb"; MonthName(Get( CurrentDate )="March"); "Mar"; MonthName(Get( CurrentDate )="April"); "Αp"; MonthName(Get( CurrentDate )="May"); "Μay"; MonthName(Get( CurrentDate )="June"); "Jun"; MonthName(Get( CurrentDate )="July"); "Jul"; MonthName(Get( CurrentDate )="August"); "Aug"; MonthName(Get( CurrentD…

I want to know whether it is possible -and how- to show a message box when the user aborts a script clicking on the ESC key on Windows or using the equivalent combination on MacOS. The sequence should be the following: 1) The user aborts the script. 2) The message box appears. Thanks in advance for your help and happy new year. A.R.

I want to add the day of the week to this string, after the date and before the initials and I don't know how. Would someone please help me. GetAsText(Bailbond::This_Date) & " " & Bailbond::Initials & " " & Get(CurrentTime)& "¶" & Bailbond::List thanks, Mitzi

I want to be able to launch a script with a double click instead of a single click. I have a layout that lists records. I want to be able to click on a record to select it without launching a script but if I double click it a script will launch. I know there are alternatives to this but I don't want to use them. Any ideas anybody?

I need a script to validate two fiels depend on the list value. Example Let we have costumers of two categories. Costumers that eat meat and the vegetarians First list Vegetarian No Vegetarian Second list Pork Beef Chicken Dug It does not necessary for vegetarians to open the Second list and sometimes they do it by mistake and create confusion. So the script must prohibit the vegetarian to open the list or warn them that they open a wrong list. However it must require the no vegetarians to select a value of the list. I think that it is easy to understood is not complicated. Pascal

I'm having trouble getting the Set Field script step to work for me. I'm going to another table in the database, creating a new record which has a couple of auto enter fields, then using three set field steps; One sets the field content by a calculation - that works, Another sets the target field to = a source field from the active record in the table I came from and that works too, another sets a field to = a field (global) from the table I came from, but it just keeps leaving the target feild blank. Source and target fields are number fields. I've tried stepping through the script with debugger, that just shows that all other steps are working except th…

Hi All, I'm trying to figure out how to get a script to launch after data is input into a certain field; Specifically, a radio button field. Can you gurus help? Thanks, Chris

I am using buttons named: A,B,C....so forth on my layout for quick find using the script: set error capture on enter find mode setfield{myoffice::firstname; get(scriptparameter) //which is for example "A"// perform find ................... i do get the found set by the first names starting with letter a. lets say i would like to repaet that to narrow my search by applying similar script but using the last name on the same found set. can you tell me how to do that by usind second set of buttons A,B,C...and doing a second request on the found set by last name

Hello all, I have a column in a layout that is called "Sum Sales". This feild is currently blank. "Sum Sales" consists of "reg sales" plus "other Sales" Which is populated in my layout. Does anyone know how I write a script that will populate the "sum sales" with the result of (reg sales + other sales) Thanks in advance!

I'm trying to pass on several fields into a script parameter to be picked up in another file. One of the fields may contain hard returns which I would like to keep in, so I use & "^" & to delimit the fields. This induces the problem that my usual method: GetValue (Get ScriptParameter) ; 2 ) can no longer be used and I am puzzled how to parse out my fields using the ^ delimiter. So far all my attempts fail to work and I am calling the forum for help. ... and enjoy 2007 !

Has anyone: 1) a time trial script or .fm7 file ? 2) a registration script with a dialog that user can give a serial number that is stored to database and i give it to user 3) a username and password dialog with values from database and NOT from filemaker Account and Privelgs ? any help will needed. thnks philip g.

I need to add an expiration date so I created a global field that will take today's date and add 15 days. This is the expiration date. The problem I have is with certain days of the month. When I compare get(CurrentDate) to the set date +15 It thinks it's expired if it's installed on those days. Strangly this only happens on certain dates. My script looks this: Set Field [install_Date;Get(CurrentDate)+15] If [Get(CurrentDate) > Install_Date] Show Custom Dialog End program The problem is that this will not work if the install dates are on 2,3,4,5,6,7,8,9 but will work for all the other days of the month. Why is this so strange? It fails if you put i…

Can filemaker receive variables/parameters from Javascript? If so, how is this accomplished?

(Moderator: feel free to move this post to the Define Fields forum if you deem it more appropriate.) Greetings, all, and happy new year. Here's a puzzler: I read that it's good FM developer practice to not let users have access to the Status Area in run-time solutions...which makes sense. However, by making it inaccessible users can't glance at the record counter to see that they're at Record X of Y...though they can go to a specific record if they want to by visiting the Records menu. So, that means writing a script? A calculation? I'm sure this issue has been dealt with before by someone far more wiser than me, so your help would be much appreciated.…

So, I have a script that finds all of the invoices for last month that meet certain criteria. To make the script work every month with no user interaction, in my script, I have a step that does a set field of: Month(Get(CurrentDate)) -1 For example, if I do that find in September, I would get 8/*/06 in my date field. This works for every month but January. When I do that I get a 500 error - it seems to treat it as an invalid date. I would have thought that this would work. Is this a bug, or is this behavior by design? any thoughts on the easiest way around this either way?

Has any of you had experience with the data separation model in FMA 8.5? I have a data file with multiple tables and a file that is my user interface. It has no data of its own, all of the TOs refer to tables in the data file. From the user interface, I want to set a value in the data file. And I want to do this via a script that runs on full access privileges. However, it fails. From the security standpoint this may make sense. But how do I work around this? Thanks in advance for any suggestions!

Greetings, everyone! I've created a demo-type database (in a run-time solution) but want it to "drop dead" 14 days after its hard-coded start date. The date calculation parts works fine, but as much as I've tinkered with the script to have the solution shut down after the drop dead date, I can't get it to work; I'm missing something. Thanks in advance for your help and have a prosperous and healthy 2007! Here's what I have so far: Table = Main Demo_start_date (Type: Date) Demo_expire_date = Demo_start_date + 14 (Calculation Result: date) Demo_countdown = Demo_expire_date - Get(CurrentDate) (Calculation Result: Number) Script: If[Main::De…

Hi everyone, First, HAPPY NEW YEAR 2007 I'm really bad at scripting. I don't really know much of their uses, etc... I have a database with several Tables. In this case, I have a Customer table, an Order table and a Product table. What I'm trying to do (and fail) is having a button in the Customer Layout that will allow me to go in a new window and create a new order with the info of the customer such as his name, id, without me having to reenter these data manually on my order layout... What script should I use ? Any relationship? Thanks.

Perhaps you can help me with a little problem. I have two related tables with more than six millions records. I want to copy the contents of twenty fields of one table into twenty fields of the other. The reason is that operations that involve related data are very slow for my purposes, since related fields cannot be indexed. So instead of making use of relationships I have decided to copy data from one table into the other to speed it up . And indeed the database works much faster although its size has increased. The problem is that this task (copying data from 20 fields of 6000000 records) is very time-consuming although I am working this way: 1) During t…

I see a couple of new script possibilities in scriptmaker but have as yet been unsuccessful in getting any of them to work. I have about 300 records where I want to change the text from Upper to title case. TIA

I have a field that is required to consist of only unique values. I would like to be able to override this validation requirement with a script. Under some conditions I would like to be able to use the same value in one additional record. Is there anyway to change this validation requirement on a record by record basis? Thanks, Jarvis

I am performing a Find on three fields. I want to create a logical OR that will return the record if anything ("*") is in either of the fields. Right now, it just creates an AND. Any ideas?

Hello-FileMakerPro novice looking for some help. I read the whitepaper for novices and am taking its advice and I'm trying to design my database on paper before I create it. Part of my database will determine if case managers met time requirements for responding to a referral for service. I am trying to develop a script that will return either a "yes" if the timeline was met, "no" if the timeline was not met, or "na" if the referral could not be acted on for some reason. What I came up with is listed below. Any advice would be greatly appreciated. Table #1: IntakeReferrals This table will hold data related to intake referrals. It will have a …

I have a script which jumps across tables and files within a soultion. I have given full access to all scripts and have given full modification rights to a password which runs the script. On FM Dev 7.03, the debugger will not function on this script, but will on others. What are the parameters under which debugger will function? (I have a field which claims to be not modifiable, but full rights are granted on all scripts in the sequence. It functions under the master password, but not the lower level one. I need debugger to locate the field.)

I have a few questions about how I can receive variables from external resources. I am running a few layouts via the Instant Web Publishing interface. It is a scholarship application for students in my department. The file is served up with Filemaker Server 8. The student will simply click the link and a startup script limits access to most options except data entry. Currently I have them entering their own Student ID # (which I use as the unique ID), however, this doesn't prevent them from accessing other students records. I have the potential option of receiving information from and LDAP server or via java script...for instance, they would log in using…

I need a calc to base a daily work list from a record creation timestamp. Example: Record of customer is created when he/she walks through the door. 7 days later a reference to that record needs to appear in the daily task list for the sales person to send a thank you card. Does that make sense? Thank you.

Hi to all you there I have a little problem and i hope you can help me i have a script with a parameter but when i enter find mode inside the script that parameter simply disappears, is that normal??? Thanks

FM 8.5 Adv Just wondering... is it just me or does everyone still see for the layout name in: Go to Related Record [ From table: "{Inventory}"; Using layout: ] I use the separation model, and no matter which layout I choose for the "Using layout" area, there is a completely different layout that comes up in the script editor when I go back to check it, but the GTRR still works and goes to the correct layout. (or it says unknown as above) Is filemaker going to fix this? I know it goes back to v7. Darryl

I need to track the amount of wine stored in tanks at the winery I work at. I have three parent tables: One called STORAGE with a portal that is used to enter data about the movement of wine, the date of the transaction and which tank it went into. The next table (called WINES) stores data about the wine (vintage, varietal, etc.) The third table (called TANKS) keeps track of which tanks have what wine and how much free space, if any, is left in them. The three parent tables are related the a third child table called LINES. This table keeps track of the portal records in the STORAGE table. I've created a button on the STORAGE_Form layout which runs the…

Hi, I am creating a database to manage inventory at the chemistry lab that I work in. I have it set up that when we receive in new stock the employee goes to the database. I have a layout that lists all of the chemicals that have been ordered but not yet received. The employee then clicks the checkbox for received. I would like it so that when the "received" checkbox is clicked that a window pops up that asks displays information from another table. This second table has drop downs about storage location and what happens to the invoices. The employee then closes the window and the information is stored in that table and then there done. Does anyone kn…

Is there some way a script can act on a selected word + the following unselected word ?

Hello. I am quite new to FM and am trying to create a script that asks for user input and then performs a search based on that input. From my experimentation I found that the Custom Dialog writes the data to the field you specify, so I... Created a field in my DB called var1, wrote the user input to that field and did a search for where the fields match - but no joy. Any ideas? I seems like it should be simple (well it is in Access). thanks Michael.

I have a script which is meant to copy the field contents if in Browse mode. But I need it to simply enter the filed if in Find Mode. Is there a calculation or script step which can determine which mode the user is in?

I am out of ideas! I have a layout that performs a find of only requests for a certain day. But I want this find to omit the records that have a certain field checked. I named this field "semester request". In other words, this field is a check box and if the box is checked in the record, I want to omit the record from the find. For this step of the script, I tried to put Perform find and then in Specify find, first action is Date Needed [//today's date] then next action is omit records [semester request] and criteria is @ (one character). This didn't work. I can't think of another way to indicate the criteria to omit a checked check box. I also tried adding a scr…

Hi. I need to add the day of the week before the date on this script. The day of the week has to be the correct day corresponding to "This_Date" [color:green]GetAsText(Bailbond::This_Date) & " " & Bailbond::Initials & " " & Get(CurrentTime)& "¶" & Bailbond::List any help is appreciated.

I have a database with a "DaysOld" field It is a calculated field based on the days from record creation to today. I want to use it in a list report. Currently, it only calculates when I access the specific record. Is there a way to globally recalculate this field so that on any given day, the report is correct.

How does one get the value of a field and perform a find on it with a button. For example. I pick a name in a field. Next to it, I want to click a button that will get that name and search for all of the records with that name. Thanks!

I have a script that I am using to create new records in a specific table, Injury. One of the fields in this table is a key linking the new injury record to the currently selected record in another table, Preferences. The overall process is this: 1. Go to Injury layout. 2. create new record. 3. Insert the contents of the ID field from the Preferences table into the appropriate ID field in the Injury table. 4. Return to the original layout. 5. Go to the first field for data entry. Problem is, I can't get the script to copy the key value from the first table and paste it into the appropriate field in the new record. I've tried everything I can think…

HI... newbie here A client has requested that I modify their existing Filemaker project in such a way that their users can click a button in order to duplicate all entries in a given record (i.e. client wants to duplicate record 250 of 500 and then just modify certain parameters). The problem is this: the Filemaker project consists of a layout that uses repeating fields from 2 separate tables: Sitems and Selection Form. The duplicate record function does create a new record, however the data that was in the original record is not carried forward to the newly created record. Can anyone provide some advice?

Hello, i was wondering if someone can help me with this. let say i have 20 records which i want to duplicate all at once. is there a way to do this using script?. i am using FM 6.0. any help would be appreciate it. thank you victor

Quick overview of our system: We have a FM file called Bids which holds of the products that we are receiving. Bids includes fields like PO Number, Item Number, QTY, Cost, etc. Here is a look at our Bids file: http://www.dealexpress.com/products/bids.jpg What you see here are 5 items on the same PO#, 2 of which have a cost of $20, 2 have a cost of $0, and 1 has a cost of $30. The green button that you see that has a 5 on it is a button we click to "check in" these items. What happens upon clicking it is that it adds up the QTY of the items on the same PO, with the same Item Number, and the same Cost (bid) and creates an inventory item in our system. …

Good morning all, I am creating an hour log for members of my volunteer ambluance corps. When a member comes in they enter the time they have started, and they enter their end time when they leave. I have a total field that calcuates the hours donated by that member for that specific day. What is important for us is, at the end of the month, have a total number of hours calcuated for that specific month and specific member. How would one go about creating a script as such? Thank you.

I'm working with XML web services like eBay/PayPal/FedEx, etc. If I have an XML string stored in a variable within my FM script, how can I setup an HTTP post to send this request (including HTTP Header information that I need to add) and then store the response in a separate FM variable in order to parse out the data? In our current FM solution there are a few scripts that others have created in which they do exactly what I'm talking about with FedEx rates. However, they're using the External function like this: Set Variable $$RateResponse_FedEx Value: External( "JAVB-Command"; "NETT-NewForm") Set Variable $$RateResponse_FedEx Value: External( "JAVB-C…

I have a quick scripting question: I am looking over someone elses script and they have a line that reads: Go to Layout["table1"(table2)] The specify checkbox has table1 selected. Can someone explain this code for me? Thanks in advance!

I'm a newbie and I'm having a problem and I hope someone can help. I'm creating a database with basically a customer table and a table for all the contacts I will have with that customer. The link is the customer ID field. I want to be able to click on a button on the customer record and open a new contact record and prepopulate the customer # field from the customer record I was just on. I would then add my notes for that contact session and then upon enter automatically go back to the customer record. I have a portal on the customer record that displays all the previous contacts and that is working fine. I just want this nice automated way of addin…

I've got a script that should do some very simple record creation work. I have a Students Table and a Programs Table. In the Students Table I have a portal that shows the Programs Table information related to the record in the Students Table. I've created this script to, once you're looking at a student record, add a record related to this student in the Programs Table (therefore having it show up in the portal). My script creates a new record and somehow misses the step of Set Field piece and goes right on to the next field. Can anyone offer a little insight? Thanks so much. //ichael -- Script: New Window [Name:"Enter New Program"] Go to Layout…

I have just discovered that with FM 8.5, if you are running a script in a window and you click on a different FM window the script starts running in the other window. Can some one help me to solve this behaviour?

Can anyone give me advice. I'm trying to find a clean way to launch and close my database. I have a window that I use to select from a projects list that always needs to be open. And I want the database to always close down and open up with that window as the only one there. Are there any best practices people use to get in and out of a dbase? I'm trying different methods but it seems pretty messy and inconsistent. Any help is greatly appreciated!

Let we have a list with values and two scripts. How can we tell the FM to run one or another script when a particular value on a list selected? explain when list value is this run that script else if list value is that run the other script. Pascal Learning FM fast

I apologize if this is in the wrong area, I tried looking for the "sandbox," but didn't see it. We use filemaker where i work to ring up items we sell in our gift shop. The problem is that we sell both taxable and non-taxable items, and our invoice is set up so that you can either charage tax on all the items, or none. How we have gotten around this is to create two seperate invoices, one of the taxed items being sold, the other for the non-taxed. This gets to be a hassle when we need to ring someone up twice because they bought both a taxable and non-taxable item. What we were wondering is if there is a way to set something up like, "If the case is that a nont…

I have a Contact layout (table Contacts) which also displays a portal (table ContactTypes) allowing the user to enter many contact types for a Contact. I need to make sure that at least one record is always entered by the user in the portal for each contact that is created or modified. Where should I put this validation on the Contact layout, and what would be the commands ? Similarly, I would need to create a script that would scan all Contact records, and create a record in the portal (ContactTypes) for this contact if none was found. The new record created would be assigned a static contact type value (ex: "General"). Thanks

I am a beginner to using the Filemaker program, so forgive me if this is a simple question! I am in the process of developing a Filemaker database for our company (relatively small contracting company) and I have several requests from people who want me to add alerts that will warn them if they are making a change to an important field. I have a Filemaker manual and I understand the basics behind a Custom Dialog; but I am having trouble with the If statement. I basically want to say IF (Date Start) changes, Run Custom Dialog. Is there a calculation or tool I can use that will determine whether a date has changed up or down? Thanks so much!

I am trying to write a script that will insert a scanned signature graphic into a container field once a user selects the container field. I need it to ask "Do you approve? Y or N" and then if the answer is Y then insert graphic. If N end script. I am using a user table that is related to account name which is required to login to the database. The user table has Account Name, Title and Scanned Signature fields. Please help.

Hmmm - have a strange fear that this is either impossible or ludicrously easy...I've managed to totally avoid learning about script parameters so far... I have a main DB with two buttons - both buttons are scripted to open the same database but I've added a Parameter to each button, which is used to open different layouts in this external db. The external db has an opening script which would theoretically then determine,using this parameter, which layout to open. (Now I know I could just create multiple dbs to overcome the problem ---- I just feel there must be a more elegant and less obvious solution). I'm not going to bore you by describing my naive att…

I have a layout whereby amendment/s to the record will create a new record. The old record is stored for reference but not displayed. Currently, when ever a new or amendment record is created, i used a field to display 'new' or 'update' to notify another user. But the downside is that it will still alert the user if the amendment done is not required to know by the other user. Thus, is there a way to alert the user which actual field/s is amended? I am thinking of assigning addition field to each main field but then it will be very messy that way.

I am trying to figure out a way to close a file from another file without having a File Reference defined for the file I want to close. The Close File script step requires a static File Reference instead of allowing us to specify the file reference dynamically using a variable to specify the file to close. The Perform Script[External] script step is the same way which makes sense. The reason I am trying to do this is because I have a client that uses Terminal Services to access the application. The application is designed to have a local GUI file on each workstation while the data is on a server. Essentially, each user has their own GUI file. In a …

I'm running FileMaker 8.5 Advanced on an Intel iMac and running the "Save Records As PDF" script step seems to without fail crash the application. I read about a fix online at GoFileMaker.com (http://www.gofilemaker.com/search_np_detail.php?id=50) that said "remove any periods from the name of the file being exported" but that doesn't work in that the files I was saving didn't have any periods in them in the first place. Anyone else know of any fixes for this problem or do I just wait and hope that a future update takes care of the problem?

Hi, I need to extract a bit of text from a field and move it into another field. Here's what I've got. My field "Source" contains a long file name for the image which I have imported into that record. I would like to copy part of this file name and paste it into a field called "Album Name". The contents of the Source field look like this: file://C:/British Aviation Sqn Markings/Thumbnails/05 - BE2e - test aircraft - camouflage.tif I would like to take the text between "C:/" and "/Thumbnails" and copy it to the Album Name field. All help and suggestions appreciated!

Hello forum so i have made a script and most of it works, but it only prints 1 invoice even though my find criteria shows 4 records, here are my steps.please see picture. the aim of the script is to find all invoices that are closed, go to another layout that shows my finished invoice layout (report_invoices) and print them. i have tried many methods "loop" "get" etc but no luck so far. thanks and sorry i could not type the text in my post not figured that out either yet.

I would need to create a small script where the field name (1st argument) in a Set Field command in the script would be passed by a parameter when calling the script. Something like: SET FIELD [ Get (ScriptParameter); 0) ] I can pass the 2nd argument (value) as a parameter and it works ok, but I can't figure out how to do it for the field name. Is this possible ? For the moment, I'm passing the field name as a parameter, and doing a CASE with a SET FIELD for each possible field I'm going to need, but I'm hoping there is probably a "cleaner" way of doing this. Thanks

I have a field set up to show a value list as a checkbox set. My client for whom I set up the database would like one of the values to be automatically checked when a new record is added (on most of the records they would manually check the value themselves, so this would enable them to simply uncheck it on the rare occasion that they'd need to). Is there a script step that would do that? I can get to the field, but can't find where I could select a value in that field.

Dear FileMaker Gurus: I have a FileMake DB, running on FileMaker 5.5 Server/Windows 2003 Server, accessed by FileMaker 6 Mac/PC clients. I got a request to copy 6 separate and unique field content to the clipboard and also insert 3 commas in between fields, such as: [FieldA],,,[FieldB],,,[FieldC],,,[FieldD],,,[FieldE],,,[FieldF] The content will be captured and managed by custom HTML Applications. I use “101Clips” shareware, which can remember up to 30 recent entries, to check on clipboard content. When I use Script Step”Copy” to copy the desired Field Content to ClipBoard, only [FieldF]’s is there. What is the best way to copy the whole thin…

What criteria makes a Layout Object active (is that more correctly called "Focus")? For I project I'm working I have a button that appears on every single layout so that any of my clients users can click on it and it will send me an email telling me about a bug or feature they would like related to where they are in my application. The send email script step send me a message using the following: "Hello Jerrald. I wanted to report a bug or suggest a feature that I thought of while working in the" & ¶ & ¶ & "File Name: " & Get ( FileName )& ¶ & "Table: " & Get ( LayoutTableName ) & ¶ & "Layout: "& Get ( Layou…

I've got a little script setup that marks an auction paid on eBay when we mark it paid in our local FileMaker system. The script is actually an external ASP script that gets run within a Web Viewer in FileMaker. The paramaters passed to the URL are dynamically generated like this: "https://domain.com/eBayApps/eBayMarkPaid.asp?eBayItemID="&Invoices::Web_Order_Number&"&eBayTransactionID="&Auctions::eBayTransactionID Invoices::Web_Order_Number is the eBay Auction number. This field is in our Invoices table, however, this field is also included in our Invoices_Items table which actually holds item information for each invoice. In instances wh…

Is there a way to move a batch of scripts en masse within ScriptMaker without losing their connections to the buttons that trigger them that I don't know of? I want to reorganize how my scripts appear in the ScriptMaker to make them easier to locate and find when I want to work on or with them and dragging them one at a time into a new order is just too time consuming for the number of scripts I want to move.

Is this possible? I have a development copy of a database I'm using to write and test scripts. Once everything is working the way I want it to, I'd like to move the script over to the database that's in production. I can't figure out how to do this. Can I?

Does someone know which errors the Set Error Capture [On] script step will suppress?? I am simply trying to provide a custom dialog following an export records step, but I am unable to suppress the Filemaker error. Also, I could work around this if someone knows of a basic file management plugin (that is free or real cheap). Something that will simply check for a directory and make sure the disk is not full etc., or if there is a way from within fm to check for this?

I'm dealing with two different databases here for good reason, so please no advice of "just combine them into the same database". The databases are both on the same server, and are linked perfectly fine for reading data from one to the other, and referencing tables in each other. But now I've got a problem. I've got Database AAA, currently at record X where a script will be run. I want this script to create a new record in database BBB, and copy certain data from record X. What's the best way of doing this?

I have a script that is responsible to (once a found set of records has been created) send an email to every contact in the found set. I seem to have everything working and when I run the script, I receive 3 emails created for every contact waiting in my email clients outbox (Entourage). I ran the debugger and it worked perfectly, correct number of emails and all. Any thoughts? I am using FMPro 8 Advanced on a PowerBook G4 running OSX 10.4.4. Thanks in advance.

Can I import a text file via the Import Records script step? So far I don't see how I calculate the filename I am going to import. I have a file, I know where it is, its path is stored in a global variable, I even copied the record into a variable but when I enter filemac:/$g_variableName in the file area FileMaker Pro complains: The file "g_variableName" could not be found and is required to complete this operation Is this possible?

Only way I can see of doing this is making the field a button, have it launch a script, then prompt the user for the value they want to change the field to. Then add an entry to another table that will track the change. But when I prompt the user I can't do it in a drop-down list format? Is there anyway to make it auto complete or show a list on the custom dialog box?

Hi Everyone, I'm trying to concatenate a string of text using a calculation, but I can't figure out how to get Filemaker to insert a tab character. In PHP I can just do "t", but that doesn't work here. What do I do? Thanks, Tony

I have a Receipts table joined to Invoices on the Invoice Outstanding amount. When a payment is received (Net terms) and the check entered, it fills the Invoices portal with any unpaid Invoices which match the amount. User has other critera they can filter(using globals) which include -All- such as specifying a Chain (who pays 20 different store's invoices at a time). User then selects the proper invoice to pay. But Receipts also receives imports of payments from other sources (credit cards, COD and more). Most of these payments can be paid automatically (termed Auto-Pay) if the Receipt invoice number matches an Invoice AND the amount matches the outstanding Invoice am…

I'm trying to do some calculations and the way I figure, I want to make a new find request using some of the data in the current record. But maybe I'm going about the whole thing the wrong way -- I'll outline exactly what I'm trying to do. In my database, people enter a System and Subsystem and number -- where the number should be one more than the current count of the records in the database with that same System and Subsystem. Right now people have to manually count (or manually do a find) to figure out how many matching records already exist. The only way I figure this can be done is by making a new find request, using what the user has entered so far into …

OK - this is driving me nutty. When I submit the contents of a field (webURL) to the Open URL script step, it insists on converting any "#" characters to their hex equivalent of "%23". Unfortunately, this breaks the URL, because neither Safari, Firefox or Mac IE seem to understand that hex value as equivalent to "#". I cannot link to anchors in an HTML document without this working, so any advice would be appreciated. typical field value: www.somedomain.com/file.html#anchor

Hello All. Let Suppose I created 2 Tables, named by Movies and Rental Repectively. And Suppose the Fields are for table Movie Movie No. Movie Genre.(Action, Romance & Adult In it) Movie Name. (10 Movies belong to the genres mention above) And Table Rental. Rental No. Movie Genre Movie Name So I want When i enter in RENTAL TABLE And Select Genre as Romance, And when i enter Next Field (Movie Name) Then It Show me Only the Names of that Movies that are Romance Genre, As well as I Select Genre as Action, And when i enter Next Field (Movie Name) Then It Show me Only the Names of that Movies that are Action Genre. Tell me any tip about it …

I have layout for data entry and a "commit" button that details the data via script-- is there a way to change the access to the record from data entry to read-only (by adding to the "commit" script, for example), so that no additional changes to the record can be made once the "commit" button is used? I explored the option of "install menu set" elsewhere in this forum, but I did not find what I was looking for. Thanks

Try it with two tables — one of which lists products and categories, and could consist of only those two fields (although it could certainly have more). A list view might look something like: Kitchen Appliances*****Blenders Kitchen Appliances*****Toasters Kitchen Appliances*****Coffee Makers Garden Tools**********Rakes Garden Tools**********Shovels Then you have your second table, which is the one in which you want to specify a category and then pick products from a value list constrained to those products in the selected category. Let's call that table "Invoice Line Items" (i.e., pretend each record is a line item on a sales invoice or something). …

When entering a value into a field, is it better to use Set Field or Insert Calculated Result? I've always wondered.

I'll try to give a quick example of my goal. First the relevant info: field01, field02, ..., field50 - each has a drop-down menu where you can choose null(default), qty5, qty10, or qty15. What I am trying to do is, for example, if I select 'qty10' in 'field25' it would fill in the value 'qty10' in field25-field34. Now my thinking was along the lines of a PHP type program, using variables to address the fields and some sort of i++ loop. But I am finding out Filemaker doesn't really work that way, or at least doesn't seem to make it easy. My attempt thus far has been: Set Variable [$i; Value:Right (Get (ActiveFieldName) :2)] //gets numerical value o…

Hi, I have a database in FM7 that has a lot of fields with default values auto-entered. When an existing record is duplicated, these default vales are entered, not the values from the record that I'm duplicating. Is there a way to set auto-enter off in a script so that a record can be duplicated 100%? Is there another approach to this problem? thanks!

I have searched FM's own help took and this website to no avail. However I may be mistaken and the answer to my question is indeed here somewhere, so I apologize in advance if it is. What I'm trying to do: I have a layout that shows multiple portals. I was wondering if there is a script or an automated way to select a particular portal (by user defined criteria) so portal script commands can be executed within it.

Hello All. I created tables 4 movie rental system. Now Once a movie is on rent then how i check it is on rent so its not sent again on rent. Unique value is solution of this But when movie back then how i check its back And then Now this can be sent on rent. I have have Issue Date And Return Date Fields Is it possible i Check this with Return Date With comparison of System Current Date. Plz Tell me If Script or Function available then Tell me. Thanks Mian Umar

From a script, how can I determine what type of graphic file is held in a container field? (a container field defined to hold a graphic and not a file reference to the graphic) From the help file: If the user drags a graphics file from another application and drops it in the container field, does FileMaker keep it (internally) in its original format? -- or does it convert to some internal representation and, if so, what is it? If the first case is true, is there a script operation that can read the file type currently in the container? And a related question: if the user drops a file into the container and drags it out to another application, what…

I do hope that I have I am posting this question in the correct folder... One function of my company's database is to keep track of the proposals requested of us. Each proposal has a due date. My goal is to run a script when the database opens that alerts the appropriate personnel to an impending deadline. Each record in the proposals table has a corresponding "due date" and "lead analyst" (i.e.the person writing the given proposal). Is it possible to write a script that searches all of the proposals for ones due within, let's say, three days, and then alert the corresponding lead analyst? We don't want to miss deadlines after all... Thanks for any help…

I'm new to this forum. Hope I am in the right place. I spoke with a tech guy at Filemaker. He thought a script would be the answer to my needs. I want to make something similar to a GIS (Geographic Info Systems) set-up using Filemaker, but on a small local scale. I need something to help me manage the parking at my apartment building. Here is what I would like to do ----- In one layout of Filemaker, I would like to have an underlying diagram of a parking lot showing 60 parking spots, and have each of these parking spaces linked to its' own record on a different layout. The info in a typical record would be such as the tenants name, apt. No., phone…

Hello All. I want to run a script file On a Field (when User Move to Next Field) How is it possible in FILEMAKER 8.5 And Also Is there any Funtion in FIleMaker That We Check Is This "ITEM" already Exist in this field u cant enter. (Remember SCRIPT Fucntion not Field Options) Thanks Mian Umar

I am trying to creat a movie rental system. SO lets suppose 4 fields in one table. Movie No. Movie Title. Issue Date. Return Date. And UNIQUE VALUE option check on both Movie No. & Movie Title. And I enters Data As u say Its Uniquly saved. Now the problem is that When One movie (Movie No.2 And Title is "XYZ" Issued on 12-11-2006 And Return on 15-11-2006). So Date is Saved If I again Sent this movie on rent Then Because of Unique Value Is Check Its not accept This Title Or Movie No. Again So How I Handle This Problem. I want Sent this movie Again on RENT. Thanks Plz Reply as soon as possible. I am very Thankfull to u. MIAN UMAR

I would like a date field were I can press the key 'T' and todays date is inserted. If I then press + or - the date will step up or down by one day - any ideas anyone

I am running a script on a hidden window. I do this by freezing the window, selecting the window and performing the remaining actions on the script. When the script is finished, it returns to the original window. Is seems that I need to add a pause step to the script (for 1 or 2 seconds). When I pause, it brings that window active (into view) Does anyone know how to pause for 1 second without bringing the window active?

Hi, I'm trying to export some embedded images to files. Some images are in jpg and other in pict, these pictures are exportable. The problem is that some are not exportable. The "Export field contents" sends an error popup saying: Container fields cannot be exported. This error cannot be Capture even with "Set Error Capture[On]. I want to capture this error, so I can set a field saying the container can't be exported. Does someone has a solution for this problem?

Hi all, I'm fairly new to Filemaker (and I'm not technical) so I hope this query makes sense. The database I am using has a script set up to send an email to students (it is a database for student administration). The script works fine except I want an email signature to appear at the bottom of the email. There are multiple users on this database so this email signature would change depending on who the user is. The email program used is Microsoft Exchange Outlook though I'm sure the principle would be the same regardless of which email program. I am also using Filemaker Pro 8 and Windows XP. Any suggestions on how I can achieve this? Thanks in a…

Hi all, Is there any way to delete a file via scripting?? I´m using a file for storing temporary during an importation and i don´t need the file after the import is done. Thanks

In FM Pro 6, is it possible to execute a script by exiting a field? I want to test the field data and based on the test, execute a script. Thanks, Daryl