Script Workspace and Script Triggers

Can I create a script that will send fields to the back?

I can't figure out how to tell filemaker to print, or re-create in my layouts ,one group of records (members) in one color and another group (nonmembers) in a different color. (The records are all in one color now.) Any suggestions? Can it be done?

Ok ...i really don't know much about FM but my new job uses it. Here data is extracted from an accounting program to FM for reports. Everytime i run this "Master Import Delete" script it crashes the whole network (i.e. boots everyone off and requires server rebooting). Here is the script: Perform Script [sub-scripts,"Re-Import"] Perform Script [sub-scripts,"Delete V,C,X,0"] Perform Script [sub-scripts,"Sort SO Line#"] Perform Script [sub-scripts,"Apply Territory Correction"] Perform Script [sub-scripts,"Verify BU"] all right, this info is taken from a FoxPro based database program..... Please someone help.....thx

FileMaker documentation seems to suggest that one cannot nest find requests. If this is true, how would I write a script that does class scheduling using the start and end dates, start and end time of the class, the meeting days of class with a limited number of rooms. Does any one have any ideas. Thank you

Hello: I am working on a "game" using Filemaker Pro 4.0 but I reached a point where I am stuck. I have Field "A" with 2 options in a pull down menu ( 1 and 2) and another field "B" with other 2 options in other pull down menu (3 and 4). When the user selects one option in A and then one option in B, the value of a variable increases by 1. Different combinations of selections in A and B increase different variables. Example: User selects A2 then User selects B3 variable "change" changes from 0 to 1. Clear the screen from previous selections User selects A2 then User selects B3 variable "change" changes from 1 to 2. clear the scr…

Has anybody a script for this? I have a solution with 30 databases. One of them is the "HELP"-database, where i have all the help messages. In this database it would be nice to have a button that takes you back to the last database you left, before you went to the "HELP"-database. Thank you very much in advance. [ February 18, 2002, 04:17 AM: Message edited by: Jan K ]

Im using FileMaker 5.5 on windows98, and im trying to create a script that would tell me in which scripts each field is used. So for example if i have a global field gName, and it is used in 4 of my 10 scripts, i would like this new script to tell me the names of the 4 scripts where it is used. Thanks

Given a field with a start date and a field with an end date, is it possible to script a date range for a find ex: 1/2/02...2/15/02?

Does anyone know how to have a script execute when the user changes the value of a field?

Is there a way to record modifications to records in a way that is invisible to the user? Say for instance an authorized user says that they entered information when they were supposed to but they actually didn't until later. Is there any kind of script or plug in that keeps a history of when a record got changed and what it was and what it got changed to? Thanks Shane

Situation: I have a series of databases that fire scripts between each other whenever any one script is activated. These databases are kinda like a package for any 1 project. Question: Is there an EASIER way to change the "Database names" inside the scrips WITHOUT having to go into EACH ONE and change the name? It's bad enough that I have to change the relationships in each one (Due to Database name changes). But I think I can live with that... Does anyone out there have any suggestions? Should I get FMPDEV., is there a plugin'? Thanks! ~Addam~

Please help if you can....... When upgrading from version 4 to 5 on a hosted server environment we are having the following problem. We upgraded the files fine and we define the relationships to all other files and links. When some users go into the file on their version 5 client they get prompted to upgrade the old files again. We re-ran the define relationships and everything is fine from my client. When a user runs the same file he gets prompted to upgrade the file. Why is this happeing? How do you fix this from a global level so no users get prompted for files that areready upgraded? Thanks, Peter [ February 12, 2002, 06:14 AM: Message edite…

I know there must be something simple I'm overlooking, but here goes: when I look for the Send Mail step in Scriptmaker (FM5), it is no where to be found among the steps offered. Any suggestions?

Wrote a little "jump menu" script: When you click on a popup list, it calls a script that puts the cursor in the menu and starts a 1 second loop that waits for status(currentfieldname) to not equal the popup list fieldname. Then it calls a subscript that does something. Similar to popups on the web that take you to different pages after selection without having to hit a "GO" button. It works great on my Mac FM 5.5v2 but not a friends PC FM 5.5v2. On his, he sees the list for a split second and then it goes away but the loop is still running. Any ideas? [ February 14, 2002, 11:51 AM: Message edited by: signal ]

1) I have a very large number of layouts. The layout order list becomes particularly for the programmer too large. Is there a way to make several lists, for instance one for chapter 1, another for chapter 2 and so on..? 2) In browse modus. The reader goes very often from one layout, named A to another layout, C, which gives additional information by using a programmed button. But this additional information is also useful for a layout named for instance B. I therefore use the button: got to layout C. This is very easy. Yet once the reader is in the general information layout C, in one case, the reader wants to go back to A, in the other to B. This can be solv…

Is there any difference between using: SetField[Field, ""] and Clear[Field] except that the field need to be on the current layout to use Clear?

Don't think it' possible to print a script unless there's a plug-in available. Can't say as I'd want to try editing a script in MS Word -- or any other program for that matter. Either the script is simple enough that you don't need to mess around with programming "on paper", or it's complex enough that you need to be able to test what you've done.

I just want to print a lists and pdf so, when i click on the bottom I need script to print as pdf direct no in the menu print and then ok , direct Thanks everybody

I am definately a newbie at FileMaker as you will be able to tell by my question....I have a filemaker database with a layout I want to view in a webpage. That part works great. On my layout, I have several tabs that link to different layouts. I can get the layouts to change appropriately. However, in the web viewing (while in edit mode), if I click the tab without submitting the page first, it takes me to the next tab but does not retain any changes made in the previous tab. Can someone help me please. I tried to make a script to do it, but I can't find a submit script inside of Filemaker. Any help would be appreciated. I am using FileMaker 5.5. Thank you, synb…

I have written a recruitment database and the user has to manually cut and paste cv's/resumes from Word into Filemaker. I want to try and automate this process by getting filemaker to open the relevant Word document (from a path in a text field) and then activate a macro from within Word that would copy the document and then close it before automatically pasting it into a field in Filemaker. Is this possible? Thanks Nick [ February 05, 2002, 01:46 AM: Message edited by: nelliott ]

I am looking at setting up a College registration system using FileMaker, were students swipe their ID card and then details (ID, Date and Time) would be recorded on a central database. My problem is that I want the FM Clients to detect when the server is down and switch recordings to a local database. I envisage a client file running a permanent loop script which pauses waiting for a swipe. The barcodes on the cards would have a <return> at the end, so that the script would continue after each swipe and transfer the details to the central registration file. The problem seems to be in the detecting when the server goes off line. Anybody any ideas? [ Feb…

Is it possible to get Filemaker to open a Word document and automatically run a macro within the file? Cheers Nick

Hi, I have a field (invoice serial number) that I have to fill out automatically with the following criteria last two numbers of the current year two numbers for the type of invoice determined by a lookup table last three numbers are sequential. For example, I have a hardware invoice, software invoice and service invoice. The hardware invoice should be coded with 01 given that the type field is set to HW. The software invoice should be coded with 02 given that the type field is set to SW and the service invoice should be coded with 03 given that the type field is SR. This is easy enough but the last three digits are to be sequential for each type. eg: Hardwar…

I'm trying to devise a script/calculation that will look at 8 date fields (DO1, DO2 etc) and if the value is 1/1/02...12/31/02, a value in a corresponding number field (AO1, AO2 etc) will be added to a total figure. In other words, there are 8 quarterly payments scheduled over 24 months, but I want to get a total of just the payments that will fall in a certain date range. It seems as if it should be simple, but the only thought I have requires a script with 8 different subscripts. Suggestions appreciated. Chuck

Hi guys, I have been working on a script that reports any changes made to records. I.e the number of modifications done to a record by a user. I have been quite successful in achieving this, problem is the most recent change replaces the one that was there before, making it hard to track the original values. I would like to make it possible to store all modification values. say. Modification(a) name-"john" ( name-"jahn" © name-"jhn" Any ideas? anita

I have 4 password, one master and 3 others. There are 3 groups, each password is associated with one group. The master password is associated with all groups. I have a calculation field currentgroup, Status(CurrentGroups). No matter which password I log in as this field shows ALL groups as current. My understanding is the Status(CurrentGroups) shows the groups for the current password only, which should be one for all but the master password. Thoughts? many thanks, nati

I'm just starting out, and I'm working with a pop-up menu. I have three fields, one of which is a total of the first two fields, and which is affected by the pop-up menu. What I can't figure out is how in the total-field to have whichever choice from the menu affect the total. Basically, if you choose "Boston" from the menu it has a number associated with it, and should be placed in the script on the field which holds the total. Ifall that makes sense, I'd really appreciate any help on this! thanks! Ben

I know this is somewhat of a common problem but I would like to duplication a record AND it portals. I ran a search for old post but none had a solultion; except a dead like to a FAQ that isn't here anymore. Anyone help?

Hello! I've been working with FM for about... *counting*... one day now. Naturally, I got stuck. I want to print several records from another FM-db on one page. In a way like the table view, but in the form view. Is there a way to easily loop a certain amount of records to a page?

Is there anybody who can help me give a hint how to solve this problem: Every time this button is pressed on a ceretain layout, a different script shall start to run., For example: first press runs script 1, next press runs script 2, next press runs script 3 and so on. When i leave the layout this button should be

I'm still a Newbie to Filemaker but I did use it a couple of Years ago in my Year 12 IT class. I've made a Database for a Physio Practice. They hire out Items to customers. I remember doing a Video Store Database in Year 12 but I can't seem to remember how to get the Overdue thing working. What I was thinking of doing is to make an Overdue field and for a 'Yes' to come up "IF Date Due is > Current Date and Date Returned Field is Empty." Then I could do a find button to press for a list of all Overdue items (ie. when Overdue Field = Yes)? Thing is I can't remember how to do the Overdue Field to Popup with a 'Yes' if it is Overdue. Should it be a calculati…

The following script should do what you want. It may not always produce the optimum page arrangements, but it should be reasonable. Field names that begin with lowercase 'g' are global fields. Your print layout should should have a sub-summary part sorted by pageNo that pagebreaks after each occurrence. code: #Before running, all records (including the omitted ones) must have the PageNo field cleared # and the current found set should be the songs that are to be printed. Set Field [gPageNo, 0] #Sort the file by number of lines per song in increasing order Sort [sort Order: NumLines (Ascending)] [Restore sort order, no dialog] Loop #If ther…

Greetings -- I'm looking to delete a specific set of charachters from a field in about 2000 records. I've tried writing a script to do this, but can't get it down, can anyone help?? Field is a date field and has "0.00" which I'd like to remove but leave the date before it alone completely, field looks like "01/01/01 0.00" I'm trying the substitute function, but keep getting errors while trying to write it. Any assistance would be a start.

Dear All I am in need of some assistance in getting FileMaker to report the age champions from the school athletics carnival. I have summary fields that total all of each athletes points that they accrue and have got as far as making FileMaker 'highlight' the person who has the most points. That's in one layout. My problem is - I want to have another layout/report that only shows the top 3 age champions in each age group (opens, u17, u16 and so on). This is probably as clear as mud, but I think it's a fairly simple and easy thing to do. Is anyone able to give me some assistance in doing this? I can send the FileMaker file over to anyone who is able to help, it's smal…

1/ i have a script that import records from a db to a db 2/ everything works fine 3/ i delete a field from the table i import the records from(not an imported field, just a field that i do not use or need anymore) 4/the import script does not work anymore, because the field i deleted changed the field order. it my not be an issue for 1 script, however i have dozens of script that perform subscripts, that import records. I would have to check my scripts 1 by 1. Anybody knows how to keep the field in the matching order i put them even after i delete a field. (the field do not all have matching names)

Hello again, It looks like I might need to post this again. My apologies to be repeating my question.... * * * I have an email button in my contacts file that opens Outlook with Applescript and enters contact information in the email: tell application "FileMaker Pro" set strURL to cell "email" of current record set strFNAME to cell "First" of current record set strLNAME to cell "Last" of current record set strMAILTO to {strFNAME & " " & strLNAME & "<" & strURL & ">"} end tell tell application "Outlook Express" activate set theMSG to make new draft window with properties {to recipients:strMAILTO} end tell …

Is there an easy way to access a global field in another file? I have tried various Relationship tricks but they are fragile. For example, I have created a global in the current file, filled it with a value I know will exist in another file and set a relationship on the match. Unfortunately this can break down in a number of ways. If the global match field loses it value, or the external file has no records, or at a later date I change the external file so the it doesn't contain that value, the connection is lost. Any ideas?

Hi. I have a problem when I'm trying to make a script that opens pictures (in IE5) in a container field. What I do is that I open the picture in IE5, copy the url into a field that I name picture_1...picture_N, then I made another field c_url_picture_1, that adds "file://"&picture_1. The script is then OpenURL(Fieldvalue:c_url_picture) When I perform the script nothing happens. What do I do wrong? When I do this with "http://"&company_url, everything works fine. Regards, Reynir. Iceland.

Hi all, I have an email button in my contacts file that opens Outlook with an applescript and enters contact information in the email: tell application "FileMaker Pro" set strURL to cell "email" of current record set strFNAME to cell "First" of current record set strLNAME to cell "Last" of current record set strMAILTO to {strFNAME & " " & strLNAME & "<" & strURL & ">"} end tell tell application "Outlook Express" activate set theMSG to make new draft window with properties {to recipients:strMAILTO} end tell It also enters a date and some other information in a log in the same file. This all works fine. We also have a r…

Hi, Is it possible to update a field in the same database but different layout? For example, 1)I've one database named Invoice. 2)Inside Invoice there are 2 different layouts,Delivery order(layout 1) and Quotation(layout 2) 3)Inside these 2 layouts,there is a field call "Job no". 4)I want to write a script to update the job no fr Delivery order and Quotation at the same time.i.e if i enter 1234 for job no in Delivery order ,1234 will automatically appear in the job no for Quotation. Is that possible and how to do it? Thanks you [ January 30, 2002: Message edited by: Mandy ]

Hy guys, I have a little (big) problem. I need to export my products seperated by the product-categorie. I have about 1400 articels with 120 categories. My idea is to do this by a loop with AppleScript. But there is the problem! Can anyone help me with this problem?? It isn't very funny to do this on foot...

Help. I'm trying to perform a find based on a value that's in a text field in a related database (a preferences db to be exact). My code is: code: Enter Find Mode [] Enter Calculated Result [select, ""==""] New Record/Request Enter Calculated Result [select, ""==" ] Perform Find [] I keep getting two requests with "==" the related field doesn't get entered. Yes there is a value in it! I've also tried set Field [] without success either. Can related field values be seen in find mode or do I have to bring it into a global field in Browse mode first?

Is there a script step to play a quicktime movie that has been imported into a container field?

I trying to create a script that will automatically find only the records from my status field "active" and omit the rest upon opening. I already know how to set a script to run when opening, but I can't seem to figure out how the script should read. RET

I am new to scriptmaking and I want to create a script that will change a field with a radio button, from "Yes", to "No". then I would like to create a button that will perfom the script when pressed. I guessing this might me pretty easy, but I'm having trouble. Can anyone help? RET

just a few questions on when and how to perform a script. * can i perform a script when a field value changes ie. when user changes fielda script performs: if fielda="option1" goto layout "1" if fielda="option2" goto layout 2 * can i perform a script before i exit a record. used for exteral error checking. * is it possible to modify a calculated record? i have lookup fields that use a field that may be changed later so i need to 'relookup' the result. if i could modify a calculated field it would be simpler. thats all for now. any help will be greatly appreciated.

Hi, I am new to File Maker Pro 5 and I am doing a production status for the silkcreen shop I am working in. We get our shirts in the shop and when printed they go to the customer. Here is were I need the help. I want to know what formula or how to tell how many days the shirts have been siting on the shelf waiting to print. Please let me know if you can help me in any way. Thanks for reading this. Todd

Hi, new to scripting for FM so rather confused about this. I was wondering if anyone can show me a script that can go to a specific field and do a find for all the records with 014 in that field. Then for the the field that contains 014 (Note: This is only for this one class that contains 014, there are other fields with 014 which I want to keep) I want to go to another field and copy that information within that field and then go to another field and replace it with the copied information. Here's what I THINK it should be: Show All Records Go to Field [" ARCH 217 Quarter"] Loop If [" Arch 217 Quarter = 014"] Go to Field [" Arch 217 Grades"] Copy [selec…

Hi, I want to set up a script that will change layouts from browse to preview and bring up the record that was being browsed. Every time I set up a script, the record that the script previews is the first record in the database. How do I tell the script that I want the current record to be previewed? Thanks, Constance

I'm trying to write a script that will change the number in a field to the next consecutive number. I would like it do do it to a found set of records. So, i created a script with a loop. It works when the number is "1" - it will change to "2". However the next time i run the script it stays at "2" - it doesnt' change to "3". It also skips the last record because i couldn't figure out how to make it do the last record and then stop. Anyway, here's what I have: Loop Set Field ["A", "Count(A) +1"] Go to Record/Request (Next) Exit Loop If [status(CurrentFoundCount)=Status(CurrentRecordNumber) End Loop

Does anyone know of an easy way to, at the end of a script, go back to the record, that the script was launched from. What I do now is set a global field to Status(Record Number) at the beginning of the script and GotoRecord(byFieldValue)[g_rememberedRecordNumber] at the end of the script. The problem is that it doesn't work if the script has rearranged the records. I don't want to use a Find since then I'd end up with only the record I'm on, found. Oh, I just thought of this now: What if I save the record identifier in a global field and GotoRelatedRecord on a relation on that global field. I'll try that. ------Trying it-------- It works! Thanks for you help …

For somereason I found that Abs(T) returns 1 and TextToNum(T) returns 1 as well which is wrong. It should return empty.:?? But Abs(Any string except) or TextToNUm(Any string except)returns empty. I think this is a FMP bug or do I miss any thing? Thank you

I would search but I don't know what to searth for. If anyone can tell me where to look I would be most appreciative. I have a database of about 5 FM files with generate webpages. Called Sections, Pages, Images, Links, and Thumbnails. It works great. This database generates all the webpages for a website, maintains all the links, etc... However, I have a bunch of different websites. I have one database, a folder with the five files, for each website. The problem arises when I write or modify a script, define a field, or change a layout. I want this change to take place on all of my website databases. Does anyone know of an easy way to deal with this situation? I kno…

I am trying to create a calender in FM. I have a seperate layout for each month, and each layout contains a text field for each day. It's going to be used as a kind of Holiday Board. On another layout I have a field "go to date", if I put in 1.1.2002 how can I get the script to go the specified date?::?:?:?

I have a database set up as a basic ledger. Credits, debits and a total. It is used to keep track of company money given to employees on a monthly basis. Both the credits and debits fields are repeating number fields. There are about 1400 employees grouped into many different departments. Generally all employees in a department are given the same amount of company money per period. For example, all shipping employees get 50.00 while all stocking employees may get 39.00 for the month of July. Instead of going through an adding a credit to 1400 individual records I would like a script to add a credit to all records in a found set (such as finding all employees in t…

This is a rather simple question I'm sure someone will be able to answer. I have an "Insert Calculated Result" step in my script that inserts a date in a field. When the script is executed, the field has the proper date in it, but it is selected for entry. I went in and unchecked "Allow Entry into Field" so that hopefully it would just display the date as I want it to immediately. However, even with this box unchecked, it still allows me to edit the field when the script is done. Does that make sense? When I unselect the field, the date format finally changes to the format I want, and doesn't allow me to enter the field again. How do I get it from initially allowing one…

Hi all, I need a way to compare all the fields(about 100) in database A to the fields in database B. Both databases are the same except in content and related by a common field so it should be something like: if field1 == databaseb::field1 do this if field2 == databaseb::field2 do this and so on. Due to the number of fields I would really like to be able to do this via a loop. the only other catch is that i have to be able to append the name of the field to the end of a flag field if it doesn't match. I am new at this and this is really stumping me. I am hoping there is an easy command I just don't know that I can use such as Status(…

This should be easy but I've looked through all the help documents I have and don't quite understand it. There is 2 DBs. One for the first time the patient comes in (Plan of Treatment) and one for each time they come in afterward (Updated Plan of Treatment). There will be multiple records in the second DB for each record in the first. Right now this is what I'm trying to use but I can't figure out how to connect it to the first DB. It is executing from the second DB through a button in the first DB. New Record/request Copy [select] Paste [select] Copy [select] Paste [select] Copy [select] Paste [select] I don't quite understand the relationship feature, is t…

I'm new at this so please give all details if possible. I have a registration database (FMP v4) that tracks if people are registered for a particular event. The field ACTIVE_CODE is used to indicate if they are "PAID", "PENDING", or "NOT REGISTERED". These are selected from radio buttons and the field is defined as a value list. I would like to have a script that will show me only the PAID, another for only the PENDING, and a third for only the NOT REGISTERED. Can someone show me a script(s) that will do this.

You could make the field into a button (in Layout mode, select the field object and format as a button) to run the script. The script would have to check whether the field was empty before opening the url... code: Allow User Abort [off] If [Not IsEmpty(URLfield)] Open URL [urlfield] End If I'd also validate the field to make sure it is a good URL -- no spaces, begins with http:// etc. --- Err, there is a problem with this scheme: it will be difficult to edit the field contents! Maybe put a little button next to the field that says "open url" that runs the script. [ January 23, 2002: Message edited by: Vaughan ]

I have performed a number of searches of the the FM Forums looking for an answer to my question, but have not hit the silver bullet. I am hoping you all can lend a hand. Whether I perform a Send mail[ ] (Eudora 5.1) or OpenURL [mailto: ] (Outlook Express) script step, I get the same result. The msg is composed, but not sent. I am assuming the message should also be sent automatically. Is this not correct? I have played with all the settings in Eudora (Immediate send, send with check and told it to check every minute), but cannot get the msg to go off on its own. I am using FMPro 5.0 Unlimited on an OS 9.1 Mac. Any ideas out there why this is happening? RM

Hi, Not sure that this is the place to ask this question, but here goes: I have a field with a value list of Names of employees. On a separate layout I was the database to: 1. Calculate how many records have been created by each user (Employee name provided by value list) and place the result in another field. 2. Display the data in a table format - Name (first in value list) #of entered records Name (next in value list) #of entered records Name (next in value list) #of entered records etc... Name (last in value list) #of entered records. Please help. I am just starting with FileMaker.

Hi Everyone! I am wondering if there is a way to add stopwatch capability to a FM file. I would like to diplay a running clock within a layout. The clock needs to be accurate to at least a 1/10th of a second and should display such. Does anyway know if this is possible? Does anyone have any experience with a plug-in that would do this? Also, I'm trying to find a way to attach a keystroke (F1,F2,etc)to a script. If anyone has any experience with this could you please post? Thanks!

Ah, yes. I should just do a search for all records that have letters printed for that day, and set them to print. I think the script could be quite extensive, though, because I have over 38 letters. Each letter has its own print date field. I just thought that someone might have a little shortcut. Thanks for your help Ken

Am I missing something?: How do I create the script step to go to layout mode. I don't seem to be able to see it anywhere. Is there some reason for this??

Hi guys - belated happy new year!! I need Filemaker to do one simple thing that has been driving me nuts for weeks. I thought I'd found the answer buy nay!! After hours searching on the net I found a program called iDo Script Scheduler to execute an APPLESCRIPT at a certain time the script I am executing is called RUN REPORTS DATABASE which looks like this tell application "Finder" activate select file "auto reports.fp5" open selection end tell the file "auto reports.fp5" is an empty database with a script that runs upon openng of the database which looks like perform <external script> sales database ; print sales report exit applicat…

How can I have the export script step pick up the contents of a field and use it as the filename of the exported file? It doesn't seem to be an option. I'd like users to have a "hands-off" approach to archiving data. (dates and extra info, maybe usernames, etc as exported names).

Can anyone give me an example of how I run a DOS copy command from a script. After I import a text file I want to rename it for achieving purposes.

Hi everyone, I have a question (who doesn't): I want to make a serial number field that increments by 1 every time a new record is created and resets itself when a new year starts. How can i do that? GreetZ [ January 16, 2002: Message edited by: nowayback ]

Is it possible to get an external script to Loop? If so are there any specific script steps you need to include.

Heya people! I just installed filemaker developer and created a run time solution with an empty database that just contained a script to open hosts and a file on my server. However when i run the solution it will not open hosts on the server....... bummer huh! Anyway, why can't my script open hosts using a run time solution and what can i do instead?? Kerrin

Hey all! I have a question about showing a message. Perhaps you can answer it for me. One script I have does a loop through all the records to change contents of a field. I put a "Freeze Window" command in while it makes the changes. Right now, there are only 10 records in my Db, but if there's hundreds or thousands it may take a while to go through all of them. I want to put a message up just before freezing the window to say "Please Wait," but without the OK or Cancel button of the Show Message step. is there a way to do that? Thanks, Ken

Here is what I want to do: I have 3 files: Lists, List_Items, and Tasks. Lists has 1 field called List_ID which is the match field for a relationship to List_Items. In the Lists file I have a portal that accesses List_Items. Everything works great. I can create records, delets, etc. from the portal. Here's the challenge: I want to create "quick add" buttons in the Lists file that automatically add a new record to the portal based on a task ID. I can accomplish this fine if I hard code the task_ID into the script. However, doing this will force me to create a script for every button (there are going to be at least 50 buttons like this, that's 50 scripts). What …

I am making a invoice database that has repeating filelds for itemid, quantity, price etc. One of the features i want to add is to be able to subtract the quantity from the number in stock; which is in another database. I have a script that should work. but filemaker doesn't allow coping it so i can't show what i have. but the basic idea is that it loops through the every repetiton with getRepettion and then does: SetField["items::quantityOnHand", extend(items::quantityOnhand) - GetRepetition("quantity", extend(loopVar)] that above line just takes all the quantitys off the first Item. How can i get around this? Thanks

The "Insert Picture" ScriptMaker step is used to import a graphic image. There is a similar script step for movies. HTH Old Advance Man

I was wondering if someone can help me w/ this problem? I have a db to track letters sent to ten magazines. I generate a report every two weeks showing how many letters were received during the previous two weeks for each magazine. Sometimes only a few of the magazines receive mail, so they don't show up in the report. Question: Is there a way to include a statement in my magazine sub-summary report like, "BirdWorld & DogWorld received no mail this period"? FIELDS: magazine name (text) mail received date (date) Maybe looping in a found set to test for the presence of a magazine name? Or use of a related databse containing all ten magazine names? A self-rel…

I need a filemaker script that will allow me to seacrh a field for all duplicate numbers and then delete all the duplicates but leave one of the records. Thank you

Hello everyone!! I want a script to clear certain fields for ALL records. Then I want to attach it to a button. I want to be able to keep personal information (such as name, address, phone, etc.), but have it clear campaign information (letter print dates, appointment information, etc.) I wrote a script that looked like this: Go to Record/Request/Page [First] Loop Clear [select, "Letters1"] Clear [select, "Letters2"] Clear [select, "Appointment Date"] blah, blah, blah.... and so on and so forth Go to Record/Request/Page [Exit after last, next] End Loop ...but it doesn't work. It only clears the fields of the current record. It seems to loop, because I c…

I need to convert a field with numbers entered with multiple dashes to a number with no dashes. There are thousands of records. Is there a way to script this process? An example is 0-375-41616-1 to 0375416161. Some numbers have dashes in different places. Please help! Mindy

Hello- Is there a script or something that i can use to set a portal to retrieve all rows of a DB based on a critria? For example, the SQL would look ike this: SELECT Speaker, Quantity, Cost FROM JobInfo WHERE OrderID="Current records OrderID" I am not running an ODBC source on my computer, otherwise i would probably just write the SQL for it. When i am in the "order" DB it works fine, but what i am hoping to acomplish is when i look up a contact,(in the conatcts DB) i can pull all the PO's that they have on file with us, click on a PO number, and it takes me to another screen where it shows the details of that specific PO, all without switching databases. I can g…

Hello- I am brand new to FM and woudl like to know if ther is a way to join two fields into one on another DB. For example, i have a representative database, and a contact database. I am using a portal to show all the representatives that work for a specific contact, but instead of adding the first name and last name field, i would like to use only one field showing the complete name. is this possible? Uno Mas... Is there a tutorial that i can read on this subject? I have been looking, but havn't been very sucessful.

I have been trying to find out how to create an opener file. The file that exsist on the clients computer and lanches a bunch of hosted files from FM Server. Now I have done a lot of searches on this site and all replies point to a file called Opener Files in the FAQ Forum. But I have tried to find this and the FAQ Forum but no luck. The only link to FAQ on the site is at the top right corner of this page, but that does not lead to any helpful info. Could someone help with a step by step for creating this opener file, so I may make it easier for the users to lanch their FM files without going to the remote file menu. Thanks FM 5.5 FM Server 5.5 Macs and Windows

Is it possible to set the 'allow entry into field' on or off by a script?

Hi there I have this calculaction field. Is there a script step I can use that loops through the records of a relationship as in: - for(i = 0; i < num_rel_rec; i++) { rel_rec.name } got me? Thanxs Steve Griff

hi...i'm new to FM...i'm running 5.5 at work if that helps. i've got a master DB consisting of a sequence number (arbitrary number as primary key) along with a 'CourseID' field (foreign key) and an (EmployeeID) (foreign key)...each has their respective associated fields from displayed as well. i'd like to know if i can somehow cut down on data entry by having the DB automatically create each combination of courseID & EmplID for me rather than entering each individually. from here, the sequence number increments for each new record. for instance, courseID 1-EmplID 1, CourseID 1-EmplID2, CourseID 1, EmplID 3...etc. i have about 100 employees and 50+ classes to cons…

Hi, I am new to filemaker. I use FMpro 5.5. I am trying to write a script that would perform the following: on a Purchase order layout, i have a portal that relates to some shipping information. For the same PO, there can be many shipments. However, when the user would click on a certain shipment row in the portal, the script would get the shipment number from this particular shipment portal row, paste it in my shipment layout, and find the particular shipment info. This ship info is then printed, and the user is taken back to the PO screen, where he was at the begining. I have a couple problems in my script: How can i select and copy a field from a portal? If …

Does anyone know how to send a remote trigger script to all computers on the network (or more than one computer on network) at the same time? I'm not that great with scripting and the activator plug-in user guide is kinda hard to follow... thanks gary

I have been having problems de duping my database. I want to find the duplicate records but I only want the duplicates to be found, providing me the option to delete the found set. I have tried to use a script with a global and mark field however, this is not bringing up all the duplicates. For example, when de duping by email, not all duplicate records are found. It appears that even though I speciffy to search only the email field, it searches the entire record. And then if the rest of the record information is different, both records are not recognized as duplicates even though the emails are exactly the same. Please help!!!

I have a data base that I imported, that has many of the same record. All the records are IP address,(65.112.149.100) I want to delete the duplicates. How do I do it? Thank you for any help that you can give.

Will the CurrentUsercount script step show the amount of users for a FM file if it is hosted by FM Server?

Call me dense, but it seems to me that most of the "find duplicate" scripts I've seen posted (as well as in the FM Pro 5 User's Guide - see pg 10-13 ) really only find duplicates which are next to each other, i.e., concurrent duplicates. Right now, I'm trying to write a script which will find all duplicates (regardless of whether they're concurrent or not) and show them in a layout. In my case, the unique field is a calculation field and thus I cannot simply enforce it's being unique (like you can with a simple text or number field). I'm using the "create a Mark and Global field" approach used in the User's Guide modified to also find non-concurrent duplicates. Here'…

You can do both. Select Edit references ocument and select the layout and script you want. Jenni

ok, i have a loop that runs through some record and does a few things. but if someone else is modifying one of the records i get the error that "this record is being modified by so and so." how can i test for this error and use an if statement to make it skip the record...

Hi peeps Quick question I have a date field. Basically I want a Calculation field to look at the date field and add up all dates that have 2002 in it. Therefore if there are 3 dates that contain ??/??/2002, the calculation field will add up to 3. Hope that's a good enough description Thanxs Steve Griff

I've created a loop that checks for new message every five minutes on our message database and performs a show message if there is a new message for someone... however, i now realize I can't do anything else in filemaker while the loop is performing? It grays out all other windows (other dbases, open, new record, etc. are all grayed out) Is there any way around this? thanks

Is it possible to error capture the error code for a unique field validation.? I know the code is 504 but I have had no luck in capturing the error. What I am trying to do is produce my own error messge for non unique field entries. I don't like the built in unique error message. It still allows the user to input a non unique entry, which I don't want. Can anyone help? Thanks

is there any way to loop a script to run every 5 minutes or so...automatically... i can't seem to get the right scripting thanks

i am SLOWLY learning how to build my phone messaging system with all the help I've received here... I have the troi activator plug in... Is there a way to trigger a script on a file on ALL the computers in the network at once...I have been only been able to trigger a script with one ip address at a time... Each time I create a new message for an employee, I need to let them know they have a phone message (only NEW messages that have not been read will be found and displayed). The script will only say you have a new message if you the message was for the particular person but I have not been able to figure out how to trigger the script on all computers at the same time…

I have a db with three required fields. I want to use a script to allow a user to cancel a record add. As is, I keep getting the error that fields are empty... how can I cancel the add. (Related, maybe...how to postpone save of a record?).

When I create a new record? I wrote a script that takes a list of dates from one database and creates a new record for each date in another. It all works fine, but each time a new record is created, there is about a ten-fifteen second delay while the program checks the floppy drive THREE TIMES! I haven't seen anything in the documentation about this...but it is driving me crazy, not to mention wasting several minutes as it compiles these records. Any suggestions to get around this would be appreciated. Thanks!