Script Workspace and Script Triggers

I know this should be a no brainer, but I've tried everything and am forced to ask for help. I successfully created a two step script using ScriptMaker. The script works perfectly and shows up in the Finder bar Script Menu. However, when I try to define it as the script for a button, it does not appear as one of the scripted options in the layout script menu (Layout > Format > Button). What am i doing wrong? How do I connect the two?

Hi all! Script newbe here. I'm having a problem creating a posting comments script. I have comments to add field were the person would type a comment, and I have the comments compiled field were the comments are posted. I was able to write a script were it would post a date and time stamp, and who made the comment, but no luck on the comments. The fields I mentioned are in one database, and their are no relationships to any other database. Thanks in advance!

I've made a custom message with new options that pops up if a search returns no records. However, before this message can pop up, the default FMP one shows up. If I click "continue" it proceeds to my message. How does one go about suppressing the system's default message so that mine alone will show up. Thanks

Hello all Can somebody help me to make a script that removes numbers form a word. I have a database with news articles and a field that contends the news category. The problem is that add the category word there is number. For example:Spo12 ski127 wee89 There is no pattern in the numbers some times there are 2 numbers and than it have 3 or 4 numbers. So is it possible to make a script that deletes the numbers for the words. Configuration: Filemaker 7.0 Macos X 10.3 Suggestions or help would be greatly appreciated. Thanks, Nils

Is there a way to cut-n-paste script steps? I know i can duplicate a whole script. i want to copy pieces of one script into another script. Thanks..

Now in FM7 we can define find criteria. From the window and help files I get the impression that the predefined criteria can only be static. (select the field to be searched, define the equation and enter the value). Can the value be defined as a field, eg: RecordNumber = gRecordNumber (where the later is a global populated just before the Find script step)? Thanks

I'm trying to create a project management database for my company. I have many records, but two main categories, Active and Inactive. I figured out how to sort those into the two categories, however now I have a problem that you don't visually realize if you are looking at the active or inactive files after using the sort option. I was hoping to find a way to make that happen, and the easiest way I could think of would be to have another background color. However, as easy as that sounds I can't figure out how to do it. Is there a step I can put in the sort script that would do this? Or ...is this even the best solution to my problem? Simply having a title that …

Can't remember how to write basic search scripts! can someone write me one just searching in two fields, including the omit button? I use to do it all the time but have recently come across file maker again in a new job, and its been a while! many thanks helen

Hope I'm in the right place. I'm having difficulty believing that the way to show a "found X of Y records: Viewing N" message is by using calculated fields that access the get functions. But the example I have is from what started as a FM4 or older DB. It'd be really cool if could nest some logic and access the get function sort of like you do merge fields "<<field name>>". Any help is greatly appreciated.

Test

I have a database with a File, say "All". This file contains a date field with a wide range (from 2002 to today). I have created another file, say "Older Than" to export the records "older than a given date" and clear it from the "All" file.

When we added a satellite store to our music business, I attempted to set up a second location in a location field. I wrote out a script a long time ago to make reports for our store, and simply copied over the script and changed the location value from "daybreak" to "roadhouse." Even when I perform the script, the "daybreak" accounts still appear instead of the "roadhouse" ones. These values are stored in value lists. Any advice on how to get the "roadhouse" ones to show up instead?

Hi Everyone, I seem to remember a plug-in that allowed scripts to be exported, edited externally, and then re-imported into FileMaker. Does anyone know if it still exists? (I've been searching for an hour or so, with no luck) To describe the problem a little (as there may be another work-around), I'm currently updating 15 Filemaker 6 files and making them into one FileMaker 7 db. Each of the v6 files contains a number of global fields used as temporary storage for scripts. As these global fields are used in a similar manner across the v6 files, I'd like to put these in a separate table and update all script references to the point to the new fields (i.e. ra…

Does anyone have any experience on working with external functions for remote administration within their own scripts in custom made databases? I'm currently working on a script that will close a relational database for a specific group of users, while allowing administrators to remain logged in. I want to be able to script the external functions for Remote Administration to send users messages that the files are closing within a specific period of time from within my own solution, and then script those files to actually close. Any help will be greatly appreciated. Thanks!

Hey everyone, This question relates to FM7, but I'm sure the solution I'm looking for would work in FM5-6. In FM7, I have 3 tables: 1) PEOPLE (Person ID, gAction, g1) (the g fields are globals) 2) TEMPLATES (Action Type, Description) 3) ACTIONS (Person ID ref, Action Type Copy, Description Copy) The TEMPLATES (#2) table is a list of events that make up actions: Wash Car - Get hose, bucket, soap, sponge or towel Wash Car - Scrub car with soapy water Wash Car - Rinse car Make Taco - Get lettuce, tomato, beans, taco shells and chicken Make Taco - Cook chicken Make Taco - Chop everything and stuff in t…

Hi all I have two databases. One database is the client info database and the other is a tech support database. What I'm trying to accomplish is create a script which would create a new record in the tech support database from the client info database. At the same time populate two fields in the tech support database with the info from the client info database. The two fileds are Client ID field and Serial number field. Thanks in advance

Hi, Do you know if it is possible to run a script automatically when editing a field value (like in Access with the On Event propriety). Thanks for your help, Pierre

Im not quite sure what i need here, so i will do my best to explain... I have my main table layout with two portals. One is a portal to a skills table (Skills) with a list of all skills, each with a unique ID (SkillsID) The other is a table that skills are copied to (Skills List). the skills are copied entirely to this table but not deleted from the 'Skills' table (so multiple copies if the same record can be copied accross. In the Skills List table there is a field called "Rank" I have a button in the Skills portal that when pressed will copy that record accross, but at the moment it will make each multiple a new and separate record, so if two co…

I wrote this in Defining Fields - but I think it should be here I have some fields (used as a relation) which are in the format of: 1). 1234| <cursor here and some in the format 2). 1234 | <cursor here The problem is that If I use the fuction: SetField (InputField"; InputField & "5678" & "

Hi, Can any one advise how to make a script running when the contents of a field gets updated. In other words, after making changes on the contents of a field (entering, modifying, deleting values), a specific script runs automatically. Thanks

I'm trying to export all visible records via a script, and not have the user specify the export fields.. I'm having trouble getting my head around how scripts store things like sort order, export fields etc. Not sure whether to keep replace.. or what, kind of lost on how to let the script do what I want with out much user interaction. Anyone care to point me in the right direction? Thanks! D

I have as an example a Car database with two fields one is called "Manufacturer" eg Ford, Porsche, etc and the second field is called "Model". When I Have a drop down menu highlighting "Porsche" I want the second field to automaticlly let me select the model as being "Boxster" or Carrera", etc. Anyone help me - thanks

ok, once again, newbie blues here. I want to have a script auto find records using a variable input, then enter a new entry in one of it's fields. Example, you enter the computer number, and find will bring up the record for that number. Then, you would enter the job done on the computer. I tried a script that opens the Find mode and then inputs the computer number in the computer number field. You still have to hit enter after this to actually find the record. And, unless i missed something, if you have the computer job field entry run in the script after you input the computer number, instead of letting you run the Find, it has you enter the next data th…

Gang- I have a db that requires the user to enter a Client ID in a dialog that is part of a script. When the user enters a Client ID (unique number), I want to compare this entered value with all the Client IDs in a related table to verify that the user has entered a valid Client ID number. Right now, I have the script switching to the Client ID table, and using a loop to parse the ID field of each record for a match, reporting if no match is found. This seems horribly inefficient. The Client IDs are indexed. Can I script a direct search of the indexed Client ID values? Or should I do a scripted "Find" command and use the results of the Find to learn if a match…

hi, I have a script that creates a "Save as" backup file after every 5 closes of the file. Unfortunately the file is open on the computer server as the host and the save as option is not available. Is there a way around this (apart from buying FM server)? thanks

How do I add related records (to another file) through a portal? Please help!

ok, so the person I'm desinging this database for wants three fields to be "dynamic", in that you'd have to enter multiple instances of each field (for example, if the field was a certain task, they want individual fields for each job performed) i noodled on my own trying to create a script to actually create the field without forcing the database admin to manually create the new field each time they run out of space, but I wasn't able to find anything in ScriptMaker that defines fields. Anyone that can help?

Please, I have a field that I would like to contain the count of a specific value in a specific field. IE > I have a timesheet file and I would like to count the number of timesheets there are for "Jan 2, 2004" or how many timesheets there are for "Dec 3, 2003" etc... does this make sense? cheers all!

I have seen a number of quite nice auditing examples...what I am looking for is a solution which can handle writing a "global" audit which as opposed to one that writes one per record. Ideally as a text file would be nice but I was going to start working on one which writes to a different file, such as: | Record ID | ID | Username | Change Made | Date/Time Made | which would be quite nice as then it could be sorted etc. But are there any Plug-ins out there to do this for me? Thanks

I have a field that is calculated as Get(Current Date). The date displayed is hung on Friday, June 4, 2004. What have I done wrong? TIA

For the life of me, I can find no practical use for FieldBounds(). I thought it might be a hold-over from an old version but it remains in vs. 7. FieldBounds ( fileName ; layoutName ; fieldName ) Since a field's boundaries never change unless the Developer changes it, we don't need this information. All I can think of is that, if a User is given Design privileges, a script may wish to check it to be sure they didn't move it before continuing a script. Does anyone have any practical uses for this function? I have been considering this function's purpose for 18 months and can see no way to use it.

Is there a way to stop a window from being closed? By adding a close script to stop it? Or is there a fancy window control plug-in I don't know about? Anyone help? Thanks

Using a Script Dialog Box, I made the dialog box to accept two inputs: a Beginning Date and an Ending Date. I tried to use the Get(ScriptParameter) function to obtain the two inputs from the dialog box. Then I used a Perform Find to search the criteria of the two inputs from the Dialog Box. However, it is not working. I don't know what else to do and I currently can't not find any additional information on how to implement this. Can anyone help?

I have seen this problem in other posts - but it seems to be for multi-user environments. Mine is only used by 1 person at a time - but still I am getting 'record in use' errors. They have started appearing after upgrading to FM7 - the majority when I am using the 'replace contents' script step. I know there are additional locking features in FM7 - so what would I need to remember to fix this? Do I need to specifically use the 'commit record' step and things like that? Thanks

Hi, I have a new layout template for emailing from our database. However I have it set to preview (i.e brngs up outlook new email dialog with the details - reason for this is that some people dont have outlook on send immediately and hence it will sit in their outbox). If however someone decided to close the email rather than continuing the script by sending I wish to know about it. So what basically is the error capture for script cancelled? The reason for this is that I am creating an audit log and there is no point in adding a log if it has been quit. Thanks

How can i use ODBC in MAC? I know how to use ODBC in Windows using the Execute SQL script step.

I've developed an eBay auction database for myself and I'd like to be able to extract or import the information from my auctions at eBay to use in my database. Where do I learn this? Is this an import feature or a web publishing feature or a script? Where do I begin? Thanks, Nat

On a layout within my database, I have a portal that shows related records. I have placed a button in the portal layout, which will be there for each and every record in the portal (which is what I want). I am trying to code a script that will be executed when the user clicks on the button for any record that is visible in the portal. The script will open the related file and find that particular record. However, I don't know how to access the fields in the portal. Any ideas? Thanks!

I have just started using FMP 7.0. The closet I have worked in is Access. Is there a way to mimic events in FMP 7.0? I was wanting to do an "Onchange" event. When a value changes in a field I want to recalculate the value in another field. Are the "Get" Functions the close as I can get? Thanks for any help. Bob Smyth

I am trying to count the number of lines in a text field. I can count the words by counting the number of blank spaces, but what does FM use for line breaks?

I have a situation where there are 4 Tables. Table 1: PURCHASE_ORDERS Table 2: PURCHASE_ORDER_ITEMS (These are related with the PO_ID. There is a portal in PURCHASE_ORDERS that shows all of the individual products that are in that specific Purchase Order) Table 3: WAREHOUSE_MOVEMENT Table 4: WAREHOUSE_MOVEMENT_ITEMS (Again, these two tables are related through the WH_Movement_ID there is a portal in WAREHOUSE_MOVEMENT table that shows all the individual items in a particular warehouse movement.) I

Is there a script that can separate a block of text and insert in to different fields: ie:text field: apple,orange,banana to : field1:apple field2:orange field3:banana thanks eric

Is there a way of automating the process of opening a shared database through the open host script step?

Hi, I have a field 'x' with 10 repetitions and a global field 'gx' also with 10 reps. i want to make the first rep of x equal to the first rep of gx, the second rep of x equal to the second rep of gx, and so on. Set Field ["x", "gx"] works fine for the first repetition. I thought that Set Field ["x"-2, "GetRepetition(gx,2)"] would do the trick to set the second repetition of x to the second repetition of gx. But it always returns an empty field. Both are set to Number, and there are no relationships involved -- i.e., both fields are local to the file. I've also tried it using an "Insert Calculated Result" step, but no luck. Any ideas? Thanks…

Hi guys Hope this is the right forum fo rthis query. I don't know if anyone can help with my problem involving a scheduling calendar in FM7. I have a bookings/appointments table for my staff. I want to export this information to an FMP calendar and see at a glance what bookings I have for any particular day/date/month. When I click on a booking on a specific date, say June 16th 2004, it says that my colleague 'John' has to be in London between 4pm and 6pm and that he is being paid a fee of $100.00 to do XYZ. The initial entry on June 16th cold be my invoice or booking number. All this information will be drawn into the calendar table from the bookings table…

I have a portal in my customer file that shows credit card information from another file (CDC Credit Card). I made a script in the credit card file so that when the card expires, the field (status) changes to red (from the repeating field expired), when it is <30 days from the expiration date it turns yellow. This way the person looking up the record (and taking the order) is alerted when the card is going to expire. Script runs great if you run it from the credit card file, but i need for it to run from the Customer file. Tried to run an external script and nothing happens. So I mad a script in the customer file that changes the fields in the Credit card file. I t not…

Does anyone know how to convert a FM6 to 7 without prompting the user to rename the old file or where to place the new 7 file? I have tried the Covert File script step but it always asks to rename and where to place the new file. Thanks, Brian

There is a difference between versions I noticed ... In vs. 6, I used Set Field [NumberField, NumberField] to strip leading zeros and alpha. Replace Contents worked the same whether from menu or script. In 7, Set Field (setting a num field to itself) strips leading zeros and text) but Replace Contents (both from menu and script) does not!? I wonder why that was changed. Mind you, I'm not complaining ... just want to understand so I can take full advantage of the differences. I thought I recalled another change about Replace Contents but now can't find it. I don't think it was this issue, however. I have been playing with the new Filter() function and applying…

Hi All, Sorry if this is basic, I'm pretty new to Filemaker. I've generated a number of scripts in a standalone version of filemaker pro 6 and would like to somehow export those scripts to be used on another stand alone version. Ideally, I would like to email them to somebody who can then import them into their database (identical database copy). Is this possible and if so, what is the easiest way to do it. Thanks!

I would like to create a button for employees to hit so it generates "COMPLETE" when they have completed the data entry for thier timesheet line items. Often they have more than 8 hours to enter, but don't always get it entered every day. The script for the button is set so that if thier total time worked is less than 8 hours, it will give them a message telling them they can't proceed, else it marks the field "COMPLETE". However, if they then go back and change a line item which would reduce the total time worked to less than 8 hours, the "COMPLETE" note still remains and thus is invalid. I need a way to make sure when hours drop below 8 the "COMPLETE" note wil…

Continued form here http://www.fmforums.com/threads/showflat.php/Cat/0/Number/109837/page/0/view/collapsed/sb/5/o/all/fpart/1 How can I make a line of text have breaks in it from tabs ? Please help, I am not to adapt with scripting just yet.

I have a field (repair) that I want to insert an "X" for later use. I want to insert the "X" by clicking on that field. I am having trouble specifying this to work. TIA Ivan

I'm trying to get file maker pro to compare two fields from two different tables to result in true/false. A screen shot of what I have is below. For some reason, I can't get the values in the honoree:hon_lastname to result in a true result when the potentials:po_surname is the exact same. Can anyone help?

how can i add custom shortcut key (eg F5) to my scripts?

I have records with a "first name" field and a "last name" field. The problem is the "Last name" field has the whole name in it. To make matters worse some of the names are like "John H. Doe"! How can I bring the first name AND the middle initial to the "first name" field? Do I even need a script?

I have a string of text ("AAA1000project1", "AAA1001project2", etc.) that is used as an identifier for projects. This field is a text field. I need to write a script that checks the triple letters and the number but drops the rest of the text in the field and compares the new entry (which is done manually) to the existing records so that the number is not duplicated. I do not want to create more fields and break this one field up, unless there is no other way to do so.

I would like to be able to script having an item in a layout move forward or backward in the layout (e.g. a button or field becomes visible or is hidden). Is it possible to script this?

I currently have two windows. One window (the main) is just a portal. When they select the portal it pops up the related record in another window (child). Then they are required to fill out 3 fields in the child window and it saves with the save button. Everythign works fine now but I have one minor problem. Is there a way to keep the child window open and have the main window untouchable until the child is closed? Im having a problem with people clicking on the main window by accident (while the child window is there and the child window just goes behind main and becomes invisable until you minimize the main window..

I have a script using the print setup command and it was working fine. Then someone decided they wanted to print in a different area and change many of the layout while connected to a LaserJet 2300. Now they print Landscape on the 2300's but don't on InkJet 2200's. I am guessing that One script can not save the print setup for 2 totally different types of printer. Is that correct? Would I have to create a seperate script for each printer type? It seems to hold the orientation if you print on different model LaserJets. Does that make any sense? Thanks for any insight you can give me.

I need a table that collects mailing addresses and email addresses from product registrations other sources. This needs to happen automatically, for example when I import a text file of registration information from an external source, each address needs to be added to the mailing list table if it isn't already there. Big need for this. Thanks.

I have a vendor file and I want to do the following: 1. The value list is tied to the vendor name field. 2. scroll to the vendor I want. 3. Vendor data to open in the layout boxes. Sounds simple, but I cant make it work. TIA Ivan

Hi guys, Is there a way of allowing a user with only data entry privleges alter the sort of a portal? Failing that, is there someway of saving sorts for a portal and script it for a user? Cheers

I am having trouble finding the steps to run a script when an open layout event occurs. I have already written my script and it works (I can trigger in manually.) I just need for the script to execute when a layout is opened. How can I set this up? Thanks

Well, it may not be slow - not sure how to measure such a thing but it looks pretty bad. I have a Search file and a Customers file. The Search file displays three portals to display found Customers, Prospects, and Associates. Yes I know, they should be together (and they will be) but for now, this needs to function. The Customers file has three portals of Products, Invoices and LineItems. After people are done in Customers, they can click Search and it takes them back to the Search file menu. This works fine as it a simple Close File. But when they click the portal row in Search to jump to the Customer file, the Customer file opens from the bottom right u…

I am trying to make a relational database. I basically have the Following, one table for reseller info, one for sales records and another one for stock levels. The whole thing is working quite well, I can see how much of a particular product each reseller has because I have a table with a key of resellerID_productID' to which I can have a stock value and know when I need to restock. I have over 200 products and over 100 resellers so my stock by reseller table is quite long. I need some help with a script to make it that when I add a new reseller, my 'stock by reseller' table writes new lines of 'newResellerID_productID' for however many products …

I'm trying to script the creation of new "job numbers" in a 'job order" database. I have client codes like, APA-, JAS-, EAG-. The numbering system that I want to create is sequential and goes; APA-1, APA-2, APA-3, APA-4, JAS-1, JAS-2 etc. I just want to create a new number in sequential order for each new record within a client code, when the new record is created. Each client code will go from -1 to -999 at most. Ideally, the user will create a new record, type in their client code, hit tab, and the next consecutive number for that client code will pop-up and be un-alterable. I am new to Filemaker, and I can't seem to get this working through scriptmaker.

Hey folks, I have a solution written originally in OS 9, testing it out on OS X. Working fine except for the Open URL script step. I have a script that opens a GIF in the browser by passing ["file:///" & FilePathCalc] to the Open URL script step (FilePathCalc is a text calculation that takes care of spaces ":" vs "/", etc in a FilePath field; obviously I set a global equal to the above then open the URL with it). Has worked great in 9. In X however, rather than opening it in the default browser, it launches Photoshop. I tried dragging the Photoshop app to the trash and the script just doesn't open anything. No error, it just skips the step. I thought i…

Hmm... I have a large database solution (not in terms of records -- not yet, anyway; but it has over 50 layouts, several of them fairly complex; I have separated all but one table's data from the interface and access them through file references, and there are numerous scripts. Two of my scripts (which were working just fine until recently) now exhibit this behavior: When I use the script step "Go to Related Record", I specify both a table, and a layout based on that table. The popup in the Options box for the script step lists the layouts, but when I click OK after choosing one, the script itself lists it as <unknown>, as in: Go to Related Record […

if i'm in a layout for one of my solution's many tables, and want to execute a script that needs to be executed from another table, is there a way to execute the script without having to change the current layout to the layout for that table (from which the script must be executed)? i am clicking on a row in a portal, relating to another table which is a join table, and executing a script from that join table which first brings up a dialog box. the trouble is - while switching layouts to the join table in order to trigger the script with the dialog box, the join table layout just sits there until the dialog box is evaluated, and then the script returns me to my origi…

I had a client ask if there was a way to enter an expression in a field like 10/2 and have it return 5, or 10*2 and have it return 20. I see no way to do it even with a script and button to process. Am I missing something easy here? Anyone have a clever way to do that in a single field? I need to do this one in both FM6 and 7

I am having a problem printing with the right page size set up and on the right printer when I use my script (which worked before the computer crashed multiple times and the systems preferences files were pulled out and put back in days later...) I'm using a Mac OS 9.2 G3 which also acts as the network server. Program: Filemaker Pro 6 v 4. I use page set up to pick my paper size and then I chose the printer I want to use. Then I write a script to find various files/pages and print them. After writing the script I say OK. It asks me if I want to KEEP or REPLACE the existing printer setups and I say REPLACE. If I activate my script just then, it works fine, beca…

I have a auto enter field that enters the creation date.... I need a script that I can run that will find the all records for the previous month .... so if I ran it today it would find all records created in March, If I ran it in June it would find all records entered in May,,, ect... : :

Hello, My question is quite simple: I have a script in the Client database that create a new memo in another database. So, this script calls a sub-script from the Memo database. How can I pass the ClientID from the first script to the second one? Thanks in advance (and sorry for my poor English), Pierre

Me again ... sorry to be so needy right now. vs. 6, WinXP - I just looked at a field I need to clean up. New system will validate, but this is old DOS data. I am unsure whether to write several scripts and run individually or group them. And I am afraid of the mess I might make of it ... Text field CCExpire contains these varieties of information: MM YY (01 05) M/D/YYYY (1/1/2005) YYYY (2005) ... oh geez ... MYY (105) ... good Lord ... I assume I should leave this as a text field. In 7 I will use auto enter calculation and validation but I need to clean this up before migration. How can I script this? What calculation(s) will fix this mathem…

Hey all I came across a problem when passing multiple parameters I am currently working on a data base that logs errors when they occur, i use the error capture function and call a script when the error occur. A whole heap of parameters are passed to this script like get(username)... just a whole lot of stuff to tell me about the error and what type of environment it occured in. here is a sample of the parameters passed to the script "accountName = Get ( AccountName ); fieldContents = Get ( ActiveFieldContents ); fieldName = Get ( ActiveFieldName ); tblName = Get ( ActiveFieldTableName )" I then use the evaluate function to split this up so i can get …

I have a database of patient

Can it be done to store a page setup script on the server(in a remote DB)? i mean: I have a single file that i've distributed to many users, and all of them have different printers. They need to prints layouts that are in the file I distribute, with different resize% for each user/printer What i want to avoid is to have to go back to each user's office and edit all the printing scripts on location for this user if I change the master file (or user have to reformat and need a new one.) So that all print scripts will stay the same since they are stored on the server.Even if Print request comes from local file? Can i call this getting print parameters from re…

I have a situation where I need to perform a find in a script, but in case the user was already working from a found set I would like to return to that set when my script is done. I can't find any functions that would do this, andy ideas? Thanks J

Can it be done to have a variable add to the script name that will be called from a button, without a whole bunch if IF statements? I mean.. i have a field that is based on STATUS(CurrentGroups) named GROUP that sends one of the following result: bor cap int sar And a bunch of scripts all with the same beginning print bor print cap print int print sar so what i want to do is something like: (button called script) set the variable to GROUP field (one of the above) then call the script prefix and add the variable to the name so that the script called will be "print (variable)" Server is on a MAC, but most users are using PCs…

Can anyone help with a script to generate 10 new records. The records in 2 fields are to be a sequential increase in value by 1 from the previous record but the record in a third field is to be the same for all the new records. Thanks

I have a Layout based on a table "Projects". The layout has a portal which shows scheduled tasks via a relationship to a "ScheduleTasks" table. Each Schedule Task can have several Comments associated with it via a relationship to a "ScheduleTaskComments" table. (Each comment can be marked as Resolved in a "Resolved" field.) Each Schedule Task row in the portal has a "Complete" field which can be checked when the Task is complete. Instead of simply checking the "Complete" checkbox in the "Complete" field to mark the Task as complete, I run a script to mark it as complete. I do this because I first want the script to check to see if the Task has any Comments …

I'm having a problem creating a script that would insert a value from a value list to multiple records. If anyone has a good idea it would be really appriciated Thanks

I have just migrated to FM7 and my find scripts dont work. 1. I have a button that I want to get me into find mode. 2. Manually Enter my part no. 3. Continue the the script to Find the part no. I have tried everything but just cannot get it to work. This must be silly simple. Me thinks I havent drained the swamp. TIA IW

HOw would I do this? If any word in "selected text" contain 1 letter then ignore For example A & B CompanY or Company A & B or A company B would return simply "Company" Any help would be great

I posted the following on the container forum . I'm hoping some of you scripting experts may be able to help me: I'm having a lot of trouble with calculations involving global containers. For example: If I set up 2 global container fields and paste small graphics into the first. the script: set field ("field2"-2,"GetRepitition(field1; 1)") just returns blank despite the fact field 1 contains a number of graphics in successive repetitions. It all works fine for "field2"-1. But i cant set anything beyond the first repetition of field 2. I dont understand it.

I am using the open OpenURL() script step to send emails - using mailto: I have 3 problems in using this and wondering if there are any workarounds. 1. All text loses case formatting. (ok seen a fix here using applescript - but applescript is not web compatible) 2. Special characters not displaying correctly. i.e. apostrophe displays as

Hi All, I have a very annoying problem. I have a FM solution made up of 50+ files. The solution models a very specific business need. There is now a need to duplicate this solution on the same server but to keep the two instances seperated. Do i have to go through each and every file, every relationship and every script and update the new file names?? There must be an easier way. I need to make this happen as quickly as possible. And i also may need to make more copies and run them on the same server. More info: Initial instance of solution running on server has files name: file1.fp5 file2.fp5 file3.fp5 etc. New instance running on s…

Hello people! I was just wondering if this approach is even possible. All of the image paths in field are constant: -----------fields--------------- ItemID: xxxxx ImageName:xxxxx.jpg Image_Path: M/xxxxx.jpg"]file://X:/images/M/xxxxx.jpg -------------------------------- how to set field to the same string but altered? c_Large_Image_Path: L/xxxxx.jpg"]file://X:/images/L/xxxxx.jpg My inital though was to : c_root= TrimRight((Image_Path - ImageName),3) to produce a "root" value: file://X:/images/ and then c_final= (c_root & "M/" & ImageName) but the problem is "subtracting text strings" Anyone has ideas? Much Obl…

hi there, we have 2 databases, where one is the "frontend" (users can input data via the web). the other "backend" should handle the datasets by applying timeconsuming scripts. we'd like "backend" to loop through the following: 1. catching new datasets from "frontend" (identified by a marker, named i. e. "new") 2. setting the marker in "frontend" to i. e. "handled" 3. applying a "timeconsuming" script on each catched dataset in "backend" 4. deleting these datasets 5. if "backend" contains zero datasets: start over again from 1 since these scripts are really timeconsuming, the "frontend" would be blocked while executing. so we decided to give thi…

I need more flexibility in moving between fields. (I know this sounds weird.) I have created a field validation/script combination (using a plugin from Waves in Motion) so that if a field is modified an "x" is put into a field that indicates that the record has been updated. This is rather nifty BUT the cursor disappears from the screen once the script has gone to the modified field to insert the x (the field doesn't even appear on the layout, but the cursor disappears nonetheless). The people using this database don't want to have to click on each field before entering data. They want to be able to just press Tab to move between fields, but they can't do i…

Edit: FM7pro on Max OS X Panther Okay this is the situation 1/ table with an offer, this one has an OfferID, a Car ID, MotorOption, a Date etc., the CarID points to the car in question 2/ table with the car/motortype price list, CarID, MotorOption and Price 3/ table with rows on the offer, so this one has OfferID, RowID, OptionID, totalprice, quantity 4/ table with Options, has OptionID, OptionSpecs ans Price I want to make a new offer, by pressing a button new offer, then i select wich car it's about and select the motortype which sets the baseprice by choosing from a portal (that connects from table 1 to 2). The button sends the CarID to ta…

hope this is the right section.... in my invoicing/line items setup i have a whole bunch of different views, layouts, etc. for printing or previewing. i was thinking of adding a field which could be populated with the invoice amount (copied from the totals) while i need to run a script anyway. the reason for this would be that an overview of the master file could probably much more quickly displayed compared with a local field compared to a live calculation of the type Sum(lineitems::netValue). just wondering if you think this is an advantage, or if calculating a bunch of line items for display in the master file wouldn't be a big deal.

In FM7 clicking on a button in a portal performs a script where I want to Freeze Window then go to a related record in another file. The record actually being the one I'm clicking. But while in scriptmaker I insert GoToRelatedRecords, the right table and layout shows up for selection, however when I OK the input in script shows relation "unknown". I cannot check for the external layout 'cause it makes a new window pop up.

I recently tried to interface my filemaker database with a visual basic aplications but came across a problem when trying to run a scrip from VB where i need to pass a parameter.... Does anyone know how i can pass a parameter to the filemaker scrip from VB i have tried passing "script001('test')" to the DOFMScript but that doesnt work here is just a little snipet of my code myOpenFile = FMDocs.Open("c:Hollands.fp7", "Admin", "") myOpenFile.DoFMScript("script001")

I am trying in FMP7 to turn a set of global fields into buttons. I want to set the active field in each case to be the button field being clicked so that I can retrieve its contents for layout navigation purposes. Is this possible?

Ok, I'm working on importing some files for our database and pricelist etc etc. I've got this parsed out into seperate fields. We want to find on one field and replace the contents in another field limited to what we found. We've got 11,000 records with multiple fields and want to seach on a SPECIFIC field. It will then cough up the results of the search. We want to then go and replace (on mass) the information on a DIFFERENT FIELD in the search results. BANANA TIME!

Hey, I'd like to create a script that remembers or retains criteria for one field (Status) but pauses to allow the user to input the data into the Name and Date fields. How do I script this? Thanks jana

I have a script to find a class and sort by manager name. The file contains multiple data fields with multiple managers. I want to send each manager a file with only their employee's information. So the report looks like: Class date - Student Name - Manager Name - Entrance score - score 1 - score 2 4/12/2004 Paul Mary 100 98 87 4/12/2004 John Mary 89 98 98 4/12/2004 Tracey Steve 99 87 100 I want to send Mary the data on Paul and John only; and I want to send Steve a report on Tracey only. How do I divide to automatically send m…

Hi everyone, I had a generic/text only printer that I've used in < 7 versions to print my scripts, selecting 'Print To File'. I then open them in Notepad and can copy them. In FM7, scripts can be printed directly from Script Maker. But when I print this way (to text printer and print to file), the screen turns into the text itself (goes a bit whacko) - displaying and scrolling in approx. 72 pt. and the resulting text file is just rows of boxes. I have been unable to print it out as text. Has anyone else experienced this type of problem or do you know a way to print to file (text) from Script Maker? LaRetta

Hi Group, I already have a script that attaches to a button, that when performed crates a new record. At that point the user enters a "customer name" and all of the look fields do their work. One field "terms" is looked up and can possibly contain the words "CREDIT HOLD". What I would like to happen is that if the field is populated with "Credit Hold" after the look up fields populate the record that the DB then switches to a layout that advises the data entry person that this person is on credit hold and not to proceed further without speaking to finance. I can't figure out how to script this. Can anyone help? I know this should be easy but I am missing so…