Script Workspace and Script Triggers

Scenario: I have a large found set of people I want to send a mailer to. Some have duplicate addresses, and I want to send only one mailer to a household. I sorted the set by address, so any records with duplicate addresses will be adjacent to each other. I want a script that will start on the first record and compare its address with the next record's address. If they match I want the script to mark a field "no" (they all start marked "yes"). If they do not match, I want it to move onto the next record and continue doing this to the end. Then I can ommit all the ones newly marked "no" and create the labels. Any help would be appreciated! -Phil

I need to sort/find the following set of records: Current Year and Graphic Liasons (SB and TA) with hours over 10. This is what I have so far but it doesn't work! Go to Layout ["MM-GD Reports"] Enter Find Mode [] Insert Text [select, "Graphics Liason", "TA"] Perform Find, [Replace Found Set] Enter Find Mode[] Insert Text [select, "Graphics Liason", "SB"] Perform Find, [Extend Found Set] Enter Find Mode[] Insert Calculated Result [select, "Last Action Date", "DateToText( Date( 1, 1, Year(Status(CurrentDate)) ) ) & "..." & DateToText( Date( 12, 31, Year(Status(CurrentDate)) ) )"] Perform Find [Constrain Found Set] Enter Find Mode[] In…

I am trying to write a script that will automatically place an export file on the desktop of the client workstation that requests the script. At this stage I can get a script working only from the machine that creates the script. The set up is FM6 clients connecting to FM5 Server. I appreciate your help.

I have a script that I use send message to activate an application. There is an option that is - bring target application to foreground. If Filemaker isn

HELP! I have 1400 diffrent client IDs which uses the same addressID. I need to create a new record for each client ID with this address ID. Help Please

Ok I have a group of open windows, some hidden some visible. How can I interrogate the Getwindow visible function yet maintain the hidden status of the window. The function operates only on the current window, if I use the select window command, of coarse the window becomes visible. I tried making a calculation for window visible and checking it, but that does not make sense as their may be two windows in the same table one hidden and one not. Its almost like there should be a reference to the window to be tested for this. Thanks Rod

I need to pass 2 variables to a script, is this possible somehow... cause i seem to miss the function of defining custom variables in the scripting of FM7 (used to work with Access which allows this in the VB scripting/programming). Thx in advance

I hope this is an easy script to fix... The script: Go to Layout [Report1] Print [Restore, No Dialog] Go to Layout [Main] The Problem: It goes to the correct page...but then stops...does not print nor does it go back to the main page. I have tried added freeze window...also I have tried adding enter preview mode...nothing seems to work Joseph

I remember reading a while ago (or at least I think I do...) that one could write scripts for buttons that could delete or duplicate files, and that these could be used instead of the menu buttons in FileMaker. When I read this, I got the impression that I could set up accounts/passwords for my users and set them up so that the delete and duplicate menu buttons would be greyed out and therefore they would be forced to always use my delete and duplicate buttons. I'm doing this becuase I have found that some of my users like to duplicate records to save time. I have created some nice scripts so that when they do this, some important fields will get cleared and update…

I have problem getting anything out of the database, and I know that I am the one to blame...lol The table have 10 fields, and only one row has data in it now (for testing puposes). One container-filed with a jpg, the solution on how to get the picture out of of the container will I have to bother you with later :-) Here's a little snip of the script, would love any hints on how to get this working. I would like to print the contents of the array $ReturnedData to the screen. $ProductQuery = new FX( $serverIP, $serverPort); $ProductQuery->SetDBData('personligweb.fp5', 'www', 'All' ); $ReturnedData = $ProductQuery->FMFindAll(); foreach ($Return…

Evening all If I have a CLOSE script which checks with the user to see if the REALLY want to close the database after they have clicked the little red button up in the left corner (MAC) or the X button (Windows), how do I stop the database from closing if they choose "NO" I had it working... and then deleted some stuff in my script and now I can't for the life of me remember what I did.... Andy

hello, I have a bizarre behavior, that just appeared and I can't stand why it's coming... ok: in a portal, I display related records from a table stored in another file. When i click on a record, a script is executed that: - hide the current window - go to the related record: Go to Related Record [show only related records; From table: "SpareParts"; External; Using layout: "Print" (SpareParts)] - upon opening, a script is executed that maximizes the current window What actually goes wrong is that when the user clicks a record in the portal other than the first one, this is that very first that is displayed in the new window, and the user is to use the s…

AGH! THIS IS FRUSTRATING!!! I'm using Filemaker 6 on OS9.2.2, and I enter in my script name, hit create, and it comes up with the script definition window. This is where I'm having trouble. I want to MAKE my own definition, type it in manually. I've looked EVERYWHERE! How can I do this? This this something that's driving me CRAZY! HELP!

Hi all, Does anybody knows if it is possible to grab the absolute path of a file and store it in a field of a document archiving database with a script? Ideally I would like to drag 'n drop a file onto a field (maybe a container field?) and some other fields (file_path, file_size, file_last_modification_date, file_type etc) to take the correct values automatically. I have to do that for a project that will run on Mac OS X, Mac OS 9.x and Windows and for now I am using FM Pro 6, waiting my upgrade to FM Pro 7. Any ideas will be very helpful Thanks nlo

In my Time database a Login script, which is set to run when the file opens every day, verifies a user, finds their existing records and helps navigates based on the Status(CurrentMessageChoice). I want to be able to have the script also determine if a time record already exists for the current date, and then go to that record if the user chooses to edit. If one doesn't exist, a new record for the current date is created. I am currently getting duplicate records for the same date with the script (for example when the user has to restart their computer in a day). I've attached pdf's off my Login script and Entry Prompt subscript. Can anyone help me see where I'v…

I have about 15 users of my database and for each of them I would like to setup a favourites listing. My initial thought was to have a hidden field so that I have a script which writes to the cell who that is a favorite for. So for instance "Anna" click make favorite and that adds here name to the favourite listing field and a found set for this can be found...great! BUT what if more than one user wants to have the same contact as their favourite? Any ideas? thanks! Simon

Windows 2000, Filemaker 5.5 and 6 I would like to learn how to use Send DDE Execute script step (Windows) Does someone know a good tutorial ? I checked using Filemaker help, but it wasn

I have 125,000 records with a keyword field (up to 50 words each). How do I automate the process of building a "keyword" database and "join" database to create an efficient index for the keyword field? Thanks for any input.

Hi everyone, sorry, this is a bit of a newb question but I appreciate your help greatly! If I see the opportunity to help others I will be sure to do so! Anyways, I have a bit of a scriptmaker problem, and was wondering if anyone could help. Basically, I have an interface that allows the user to enter certain find criteria in, and list the results. From there, I want to be able to go to another screen that constricts those found results in a certain way (basically, I am going to be showing only ones of a certain currency.) At present, I am just performing an additional find which I did in advance and placed in a script. However, when I am done constricting, I…

Is there a way to have the ENTER key run a script?

I have a bunch of scripts which allow the user to either print a record, or create a fax or email of it (Pagesender is king) which work very well. It does this with a combination of scriptmaker and applescript ( which polls the name of the real printer, stores it in a text field and reverts to it after the fax printer (pagesender) has done its stuff. My problem is that if the Pagesender Print dialog is cancelled then the pagesender print driver ends up being the default printer which then has to be reset manually to the real printer. Is there a way of detecting the fact that the cancel button has been pressed in the print requester window so that I can force the correc…

I have a normal billing system /with portal and a lot of items in it/. But I want to introduce a method that change the regular price of item depending on partner. I mean, generally i have only 3 type of partner and would like to differentiate the price for each type of partner.

Hi there, I do my cashouts from 4pm to 4pm opposed to daily. I developed a script that searches in part the sales. Fields: Date (Date): Creation Date Time (Time): Creation Time Yesterday Today(Calculation - text): DateToText(Today- 1) & "..." & DateToText(Today) Four Oclock (Time - Auto Enter data): 16:00:00 Four Oclock Minus one Second (Time - Auto Enter Data): 15:59:59 Four Oclock String (Calculation - text): TimeToText(Four OClock) & "..." & TimeToText(Four OClock Minus One Second) The Script: Copy (Select "Yesterday Today") Enter Find Mode() Paste (Select "Date") Go To Field (Time) Pause/Resume Script() Ins…

Hi everyone, I search a lot over the Web, but find nothing... I would like to know if it is possible to call a macro stored in the Outlook session by using Send DDE Execute or Send Message function, and if it is I would like to have an example of the syntax we have to use. Please don't tell me about plug-ins, that's not what I am looking for... Any help will be welcome, thanks a lot! Version: Developer v6 Platform: Windows XP

When you assign a script to a button you get the option of having it so that it exits the current script. However if you have these setup on shortcut keys what command can you add in to the script to make it exit the current script? Thanks Simon

Hi Does anyone know what "exit Record/ Request " becomes in filemaker 7. I need to use it and I am not sure what to put in the script. Thanks

Hi guys, Having seen a recent post about using the Open URL function, I thought it would be cool to use this facility in my database to look up the destinations of our deliveries via www.multimap.com. I have used the following syntax but it doesn't work and I get the equivelant of a 404 error on MultiMap's website. Can anyone see what I am doing wrong? ]http://www.multimap.com/search?&q=[zip_code] Cheers,

I'm using a script to control access to a data-only file to insure that data is entered through the interface file. If a user opens the data file instead of the interface file, they find a blank layout with a brief explanation and a button to take them to the interface file. The script for this button is in the interface file, not the data file. Since I have several such data files (each storing quite different info used by different persons for different purposes), I'd prefer to have only one such script to keep track of in the interface file. So my question, Is it possible to specify that the file from which the script was called (via button click) be closed *witho…

I am very new to scripts and i don't understand much about them. How do you enter in your FIND parameters into a script. I know how to get PERFORM FIND [ Replace Found Set] into a script, but how do i enter in a specific search parameter?

Hey folks So I've got this database, that has a layout on which there are fields, portals and related records... each record shown through this layout (an instance,if you like) is a Long Term Teaching plan... once teachers have filled out the plan (or the record/instance) I want them to be able to lock that record so they don't accidently trip a value list or other such thing. (i'm aware that such a question has no doubt been posted before, but the search function on this site seems to be so date biased... so forgive me) Basically I have a dynamic container that the user clicks - it activiates the lock script, and shows them a lovely little picture of a pa…

This is probably a seemingly simple script step i'm missing, but it's driving me nuts. I'm using FM7 I have a layout with merged fields. The user clicks on a button to amend the address which opens a new window (editing) (520x420 positioned 100x100). I have inserted all manner of maximise, lock status area etc, and yet for the life of me, when I call the "editing" window in the script, I cannot stop the original layout from resizing which looks ugly. Any ideas? Biggest problem is, no matter where i position the command to maximise my screen, it is before the open window command which thus again resizes it back down when run. Calling the maximise screen …

I am trying to get the first 40 records of the field "id" into a new field "id_numbers". I bulit a script to do this with loop and set field for id_numbers but I do not know how to script or define a calculation that would take the first 40 records and put it into a new field then grab the next 40 records and put it into the next id_numbers record. I have been trying the omit multiple and then delete all records but how to get the 40 records into the one record is beyond my FMP level. Any help would be greatly appreciated. Thank you

I've seen a few discussions on window management in FMP7, but haven't found an answer to this question: What is the best way to check if a window is already open, so that you don't open another just like it? The best I can figure is to create a loop to parse WindowNames with LeftValues, in conjunction with an If / Else / End if section. Is there a more simple way to do this? Thanks Chris

What's the correct syntax for specifying a relative file reference to a file that is one level *higher* than the current file? I figured out how to go deeper (file:dataFolder/data.fm7), but if I'm in the data.fm7 file, how do I reference a file in the folder one level up? I tried file:/interface.fm7 (and also with a dbl. //), but that doesn't seem to work. This is primarily Win, but eventually need to go cross-platform to Mac. Thanks, decker

I am trying to create some sort of script to change the layout after I tab past the last field in my record. Is this possible? I know a hotkey would work but I would like to make it so almost a monkey can do it. Is there a way to write a script to start after the last field is tabbed by? I think there is a way to have a new record created after the last tab has been passed but can't find that either... Any help would be greatly appreciated. Thanks a lot! Chris

Hello all, I'm new to these parts, but old to filemaker. I have a script which searches for sales based on multiple criteria. Assuming all goes well, the script searches in my sales history database based on the find criteria and populates a field with the answer. When there are no sales based on the criteria, I get an error message. Until I answer the error message, the script won't continue. Is there a way to get filemaker to automatically answer the "search criteria not found" error message so it will move on to the next record? (I'm doing this using a loop) Thanks in advance to anyone who can offer advice!

I am trying to remember how to get a relookup to run after exiting a field when a new choice is made from a drop down menu. I vaguely remeber trying this in FM6 and having to use a drop down list instead, but I still can't get it to work : How do you pause the srcipt and then execute it after a selection has been made ? Thanks

I need help in writing a script that compares the value of a global field and checks all records in the table to see if any of them have that value. If the value exists, then a dialog will cancel creating a new record in the table. If the value does not exist, then it will perform two set field functions and then end. Can anyone offer suggestions on the checking value portion?

I have an invoice database, and when an invoices balance reaches zero or less, the sales rep who owns that invoice receives their commission. In order for me to track the date when Sales Reps earn their commission on each invoice, after a payment is posted against an invoice, if the new balance is <= 0, then the current date is recorded within it. The Balance is a calculated field, and the date is a simple date field. I have an add payment script, which adds a new payment, calculates the new total payments sum, records it, and then sets the 'CommissionEarnedDate' field to the current date depending on the new balance. The problem is that it does not seem like…

Hi, I have a script that activates on closing the file. Is there a way to offer a cancel script that will by pass this? Thanks

My first relational database - three files - students, colleges and applications. I was trying to create a opening screen layout with buttons that the guidance counselors could use to get to either the students file or the applications file. I then tried to write a script to open and also one to close the files and was not successful. Now when I try to close the file, I get an error message. How do I start all over - it keeps telling me script has not been found or has been deleted....The script is still there, it's just not written correctly. Please help - this is probably a simple thing, but since I am so new - it seems imipossible to me. thanks FileMaker Version: …

I posted the following script and didn't get a response so hopefully if I expand more I will find some help "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" I'll expand further......... I have a file where I need to have 3 fields, one for engineer, one for sample number and one for sample entry id. When I first generate a new record I select the engineer from a drop down list from a value list (i've done this) and the sample number is generated from the auto enter_serial numb…

Lets say we have a field (check boxes) who takes values from a value list Lets say that the result in the field is 2 values a Dog and a Cat (2 check boxes) Is there a way to check not the one but two check boxes "Dog and a Cat" with a Script?

Hi, Using an import script step to import from an ODBC link which requires a password, i changed thesource that it uses, and changed the old password to the new one, this was done whilst performing it, then i went back to that script step, selected replace import order and checked perform without dialogue, then running the script, it still uses old password. Any ideads as to what i am doing wrong? Cheers!

I am trying to come up with some sort of script (probably loop) that will show duplicates as they are entered on the fly For example as you type in "John Smith" as a new record and as you get in the surname field it will list some possible duplicates in a portal? Any one have any examples of this or any other ideas to solve this?? Thanks Simon

Hi, Currenly the database I' working on has about 10,000 companies and 20,000 people. I am trying to work out a script for reducing each one to 5,000 so that I can sync to a pocket pc. 1. I was originally thinking of doing a script which will sort the last modified 5,000 record but what I really want is the last 5,000 accessed files? Any ideas on this - I dont have a field "last accessed" and how would you add one of these? Ideally i would want the found set to find first the last accessed files (which will be less than 5000 until this functionality has been running a while) then do a record count on this and if it is less than 5,000 add in the rest with la…

Have three files - students, math scores and report cards. I want the teacher who logs on to go to report cards and do a find for their students. Then I have a button that I would like the teacher to click and it opens the math scores file with the same students already found - how do I write this? I think this is scripting 101, but I haven't passed that yet - THANKS.

Hi guys On creation of a new record I need FM to generate a unique random password with the format of four numerics (0-9) and then six alpha characters (a-z). Can anyone suggest how I might go about doing this? Seems like something so simple but cannot think where to start. Thanks.

Hi, I created a layout that has around 15 fields in it, and a script to go along with it that automatically creates an e-mail message in Outlook and pastes these fields into the body text -- one per line -- so that it can be sent to a vendor (it's essentially just a parts list). Everything works very well, but my only problem is that I don't always fill out all 15 fields, and thus when FileMaker pastes them into the e-mail, there are gaps between the fields. Again, it pastes one field per line...so if I don't fill out fields 8 through 14 for example, then there's a gap of six blank lines between field 7 and 15. Is there any way I can tell FileMaker to only pas…

Hi there, Edit: The basic question is: In FMP7, Can I create a loop that will go through and process on fields in the same table with names that are identical except for a succeeding number? (For example the fields are : Value1, Value2, Value3, etc) -------- Lots more details follow in case the above isn't clear as to what I'm trying to do. I'm hoping this is easy enough to do. FMP 7 - Basically, I have a selection of related records listed in a portal. I'm trying to create a script to copy the values from a single field in those related records to individual fields. I know I can make it work like this: -…

Hi people... Does FM provide this function whereby i can hide a button, then after the button has been clicked, the page will refresh then show another button which is initially being hidden? Looking forward to your replies! Regards, Pris

Is it possible to run a script everytime a new record is made? A script that runs on command-N.

Hello- New to all of this and trying to figure out the best way to add a call log to my layout? I am using Pro 7 and have developed the layout with all the contact info. Just need a way to type a comment and have it record date and time etc. and have it embedded in the original layout. ANy help would be GREATLY appreciated. Thanks in advance....

Hi, Another newbie question: I'm trying to create a Find-script (and a button on a columnar layout), which would perform a search using the contents of the clicked field (CardID) as the search criteria. (This has probably been addressed here before, I just couldn't find any posts about this, sorry about possible repetition...) I've read the tutorial and tried out dozens of scripts, but they just don't find anything - any help with this is greatly appreciated. JariV

I am trying to setup out database for deduplicating. What I want is to be able to link all the duplications to a new master record. Which I have kind of done for example ID | Master Field 1 | 1 123 | 1 234 | 1 But what I want to be able to do is to be able to search for ID 234 and it returns all records with the same master field. Any help would be appreciated

I expected that I could use the "Insert Text" command in a script to insert text into a global field that appears in a Title Header. Is this not possible? It doesn't seem to be working for me. I intended to use that as a means of specifying varying data in the header so that I could use the same layout for multiple reports. Is there some other way this needs to be done? Decker

Is there a way that I can perform calculations on JUST the records in a found set? Here's what I want to do: input a begindate and an enddate into their respective global fields. Input a few user-defineable constants. Run a script to filter out everything before and after those dates, leaving behind only the range of dates between them. I'm fine with the loop to filter out to just the records i want, but then I don't know how to perform calcs off of just those records. This will allow me to create custom reports on a per week basis, or a per month, or whatever range of days I specify. I suspect I might be going about this in the wrong manner. Should I no…

I am new to FM. I wonder if there is also the possibility in writing scripts. Does FM Pro 5 include such an ScriptEditor beside the ScriptMaker where one only can create scripts by clicking with the mouse. Else is there a possibility with the ScriptMaker to comment the scripts? So that I will also know in future what I have done? Thanks

Hi, I'm a new user just getting used to FM. I am trying to create a database that records donations for a charity. The senario is that people give either irregularly and/or varing amounts. At the end of each month I need to print receipts to be sent out to the donors from that month. For each donor I have Jan - Dec fields with values of '0' if no donation or a value if they made a donation. What I am trying to do is create a script that looks at the current months donation value on the donors layout and inserts it into a current month donation on a receipt layout. But nothing I am doing seems to work. HELP please! -JB

I am trying to build a script, that would allow the user to import multiple records at once. I have a field, where the user enters the file names, that should be imported. All files have the same format, the same import order and would be in the same folder. My problem is, that FM ScriptMaker does not allow me to put a field of the database in the import records function to specify the data source. Is there a way to do that? Any help highly appreciated. Joern FileMaker Version: Dev 7 Platform: Mac OS X Panther

Hi all, I have a simple company database and want a button which when clicked will search in Google for the company name. I guess the URL will be http://www.google.com/search?&q=company name , but I can not work out how to join the field name onto the end of the URL using OpenURL in the scriptmaker. I don't want to create another field to do this, surely it is simple to do ? Any help is much appreciated. Matt

I'm writing a script to find a set of records of people who all have email addresses. The checkbox for 'Has Email Address' is one value in a list of three, which are all contained within one field. One way round this would be to split the field into three, and in my script just use a 'Set Field' on the field that contains the 'Has Email Address' checkbox. Is there a way of leaving the 'Has Email Address' data in the field it is in, and writing the script to find only those that have this value checked? Many thanks for any help. Donal x

Hello...I have created a script using a Search Data field which is an entry field on its own layout (Search Form) to search for criteria in multiple fields in another (Entry Form) layout in my database. I've anticipated and scripted for most scenarios and everything is working well except, when user hits continue when nothing been entered into the Search Date field, it returns all records. I'd like to I Set Error Capture [on] with a message that says "you haven't entered anything" and have it go back to the Search Data field, but anything I've tried isn't working properly. When Set Error Capture is [off] and modify find is chosen, the script moves onto the Entr…

Hi Everyone...Is there a way (Script) to check some fields for a value before going to a report... I would love a script to pop up a message with what fields I need to fill out for a report. Just a making sure a value is in each required field for a report...and a message that says which need to be filled out...or make the fields turn a color if not field is in them for a report.? HELP FileMaker Version: 6 Platform: Windows 2000

Hi, How do I do a calculation for the number of month between 2 dates Thanks Simon

Hi All I am having a problem creating a script to remove a Carriage return in one field which is on 38,000 records. Any information on this problem would be helpful. Thanks

Hi Guys I have a lookup script that wont break the loop and keeps on evaluating my data. What it is supposed to do: I have two related databases, the 'order details' database and the 'invoice' database. When an order/record is created the invoice date (in the 'invoices' database) isn't created until I print the invoice (a script sets the invoice date field with the current date). Therefore this look up from the 'orders' database checks against the invoice number to see if an invoice date exists in the 'invoices' database. Can anyone tell me what is going wrong? Show All Records Go To Record/Request/Page [First] Loop Go To Field [Orders::Invoice…

Hi guys, Another one gotten me puzzled.... Is there a script or way of deselecting all the fields in the layout. I have a script I wish toactivate on depressing a button, but when I go to hit the button the cursor is still in one of the fileds and until that field has been exited and the calculation in that field displayed, the button/script doesn't work. Currently after entering the last filed I have to click elsewhere on the layout to deselct the fields before hitting the button to activate the next script. Is there a way around this? Hope to have explained the problem sufficiently (I know what I mean) ;-) Cheers.

Hello, all. My wife is an elementary school teacher, and she's asked me to create a way for her to generate "bingo cards" with varying contents. That is to say, she'd like to replace the numbers on a traditional bingo card with vocabulary words, simple math equations, etc. So I created a simple file that has a "card printout" layout and a simple data entry layout with 25 fields (b1, b2, b3. . etc. . . i1, i2, i3. . .etc), for the 5 across and 5 down on the printed result. Now for the tricky part (for me at least). She'd like to be able to print a selected number of cards, each with a different arrangement of the entered data. For example, let's say she enters "…

Is there any way to trigger a script to start running based on the value in a field? What I would like to do is have a script start when a specific value is selected from a Value List. When the script is complete the Value would be changed. [color:"black"]

I am desighning a report for our marketing department, what I need is to break down how each person contacts us. In out file we have a drop down list that list Phone Call, Website, Search Engine ect... How do I create a field that will summarize how many peaple reached us by Phone today, how many reached us by Email ect.

Hi there, if i have a text field that contain a message more than 100 characters without "

Hi everyone, This is my first post and I am equally impressed with the forum I have just discovered so far. I hope someone can help. I vigorously use "Send Mail" script for about 20 of my FMP databases set up here at work. It's terrific and it saves a lot of paperwork and printing. Using FMP5.5 and Emailling with Eudora v6 - any date field that appears on the email from the script, translates as a 6 digit number. Usually beginnng with "7" Has anyone encountered this problem and got a solution? Many thanks in advance

Can anyone put me on the right track please. I have 2 tables and have tried various lookup options to no avail. The sample number in TVC Pass layout is a lookup based on all the Sample Numbers in the Sample Entry Layout. The script needs to be able to auto insert the sample details in TVC Pass which matches the details associated with that sample number in the Sample entry layout Hope someone can help and my description of what I am trying to do is clear. Thought attaching the file would be best as it is easier to see what I am trying to do rather trying to explain. Won't accept the file so if you think you can help I can email the file to you to have a …

I have another file showing the related records of the "constellation_join" file. Say I get 3 matches. The script in the "constellation_join" file is supposed to loop through all the results, make a duplicate of each record and change two fields on each record. The script is as follows: Goto Record/Request/Page [First] Loop Duplicate Record/Request Set Field ["Ongoing CY ID", """"] Set Field ["CPS Investigation ID", "relationship::CPS Investigation ID"] Goto Record/Request/Page [Exit after last, Next] End Loop What is happening is it only goes to the first record, duplicates it, and then exits the loop. I've put pauses in, and it …

I think I finally found something Filemaker can not do.. There are two fields Truck Run and truck Stop I want to make labels, or make a list layout that will print, that: 1) has each Truck run (there are 8) a different color 2) Within each Truck Run, each Truck Stop a different color (there are 10) Any ideas?

I have two separate fp7 files. One is a popup calendar, the other is just a form w/ a date field on it. I have a button which calls the popup calendar, from the calendar I am copying the selected date. I then return to the other form and I attempt to paste the copied information. I am returning nothing from the copy. Any ideas? I cannot figure out how to pass the selection back to the other fp7 file. Any advice would be appreciated. Thanks, Rob Kantor

Ok - I am new to FM 7 and this maybe a basic question, but I am stumped. I have two tables defined within one fp7 file. Something like Table 1 PKey Name Address City State Table 2 FKey Field misc Field extra I have relationship PKey = Fkey. I have a script when executed that switchs to table2's layout, adds a new record and setfield of FKey from table1::Pkey. This does not work. I ended up having to swith to table1 set field of a global value from table1::Pkey and then switch to table2 and setfield table2::FKey from the global. Why??? Is there no direct way to move data from one table to another directly? …

Has anyone used file references successfully in FMP7 to track photos/images? I have just started to play with them, but some of the issues are a) They only seem to be able to be manipulated using AppleScript (on Mac, not sure how on Windows), so cross-platform solutions are difficult : I can't figure out how to control whether the contents of the file or a reference is stored. Of course, when you set the field directly, you get to choose, but how when automating a process? It appears that the applescript step: set cell 1 of record 1 of table "playing around with file refs" of database "ABH Photos" to file "Assam1:Users:aharper:Desktop:91.tif" assigns a…

I have a script that sends out an email to several people. We recently switched from using Eudora to Outlook 2003 as our email client. Now when the script runs, it creates a new message and fills in all the fields correctly but does not send the email. I have to manually hit the send button. Does anybody know if there is a way to have the email sent automatically? Thanks, John FileMaker Version: 5 Platform: Windows XP

Hi there, just want to ask how can i exit the pause script when click another button. For example, i have a script that go to a layout and enter find mode pause to waiting use key in the find word, if user want to cancel the find action, they can click a cancel button on the layout. But the problem is when user click cancel button, it can go back to previous layout, but the layout still in the pause mode. hope some one can help me on this. thank you Regards, Henry

I originally posted this under FM7 gen. disc. but think this is the better forum. I am using 10.2.8 and FM 7 upgrade from 5 and updating a 24 file solution. With FM5 one layout = one window and hiding made window management easy. With FM7 there can be multiple windows. Instead of using hours to find the best way to keep windows from multiplying like rabbits in springtime when going from one layout to the next, I decided to come to the forum. Originally the navigation used "make new window" for the desired layout but after some use of the solution I had 2, 3 and more windows for the same layout. Then I discovered that I should make all my windows new at the fi…

I have an excel export that uses specific fields from a file. I would like to sort and only show certain data from the file in the export and agian in another export with different information. For example: Name Bob Bob Susan Susan I want to have all Bob's information on the excel spreadsheet only and then have another spreadsheet with only Susan's information. Than I want to e-mail to the appropriate person with only their information. How do I accomplish this? Thanks, Shari

Okay, this sounds easy, but apparently not for me: In a FIND script step, how do I designate a text field as having no data? I've started with SET FIELD (field name), then what?? Nothing I've tried has worked.

Good morning, I'm a new member and I'd like to know where i can find free resources: guides or manuals of "scriptmaker". Thank you

I am running a script to do multiple substitutions of text in a global field running fmp 7. I was told that it could be done but I have been unable to get it to run. My script is: Go to Record/Request/page[First] loop Set Field[completed_template; Substitute(template; "the_item_name"; item_name)] Set Field[completed_template; Substitute(template; "the_item_id"; item_id)] Set Field[completed_template; Substitute(template; "the_item_case"; item_case)] Go to Record/Request/Page[Next; Exit after last] end loop item_name, item_id, item_case, completed_template are all text fields template is text global The script runs but only substitutes …

How can I create a new record in a table that is not the main table for a form? Script outline * Denotes fields that need to be inserted into a new record in a linked table. Loop Go to layout Print no dialog go to layout print no dialog * insert current date * insert current time * insert current user name * set field go to next record end loop FileMaker Version: Server 7 Platform: Windows 2000

I figure there must be something cool to do this this but ... don't I already know what the name of the script I am in is? ... or does it return the parent script name so you know where you came from ... but that is what passing paramenters is for. Anyone know a great trick for this function? Charles FileMaker Version: 7 Platform: Windows XP

I wonder if anyone can help? I have tried to use the normal lookup function based on various relationship configurations to no avail. Looks like script with perhaps a Script Run button to run the script is the next course of action to try I have 2 Tables Table 1 Fields Sample No. 1 Sample Details No. 1 Sample No. 2 Sample Details No. 2 etc up to 10 sets Table 2 Sample No. 1 Sample Details No. 1 Sample No. 2 Sample Details No. 2 etc up to 4 sets In Table 2 the Sample Details field is set up as a pop up list based on a concatenated value list of all the Sample No. 1, Sample No. 2 etc records in Table 1. The list of matche…

I hate creating a bunch of global fields as a replacement for script variables. I can be a real problem if two people run a script at the same time. I haven't seen any mention of this yet though... any one know? Looks like an awesome update though. I've been frustrated with FM for a long time, but I think they've fixed a lot of what bothered me.

Simple question. I have a file of records that have groups by numbers range. Like 8400's I want a script button that will search for a range like I can search in find mode. Like so: 84 ... 85 will pull up all 8400's- 8499's Can anyone hep me with this ? I looked at the if and end if, but not sure quite how to prase it. FileMaker Version: 6 Platform: Mac OS X Panther

Hi, Please help me! In my database I have one field which I am exporting to an html file, and another field which I would like to use as the filename - does anyone know how I can do this? All help is very much appreciated! FileMaker Version: 7 Platform: Windows XP

I have a db that has names, comments and a status for each. Looking to run a script that will ommit the records that do not have any info in the comments or status fields. help would be great FileMaker Version: 5 Platform: Windows 95/98

Hello People! Perhaps I am just not lookint at this from the right perspective...the logic should be simple but yet it does not quite work. Scenario: Drop List [---------v] initiated by a 2 separate scripts: _____SelectListScript______________ Go to Filed[select/Perform,"g_field"] Perform Script [ RunChoice ] ___________________________________ ______SunChoiceScript___________ If[g_field="One"] Show Message "you selcted one" End if If If[g_field="Two"] Show Message "you selcted Two" End if ___________________________________ It shold be just a simple reflection to what have users just entered/selected.... but I am did I…

I was wondering if someone could help explain the proper syntax for creating a script where the user could select a month to search for from a dropdown list(ex: February) and the database would find all contributors who had given money in that month by searching the contributor table. I figure there is a simple command for this but I havent come up with anything in the scriptmaker because all dates stored in the contributor table are in ##/##/#### format (ex: 02/01/2004) which is different from just the spelled out word "February" found in the drop down list. Hopefully I'm being clear on this... thanks for any help, I greatly appreciate it!! PS: Later down the road…

Hi, I'm new to Filemaker. Now that it's more relational I want to use it to develop a database for the department. I downloaded the trial version 7 and have some questions; 1. I need to run some external scripts (.vbs) as part of a db application. Do I need the developer version to do that? In any case, what's the command to execute a .vbs script? 2. I assume I use SQL to manipulate tables, are there any issues with Filemaker's implementation I should be aware of? Probably a lot more to ask as I get into it. Thanks, Jerry Parlee Psych Dept UT Austin FileMaker Version: 7 Platform: Windows XP

Hello, I have a database that has 2 fields. One field is a value list and in that list is Small Medium and Large when I select Small I would like the other field to automatically enter 1 and when Medium is selected I would like it to enter 2. I am trying to create a IF statement to put in the auto enter calculation. But I have no Idea how to do this. Could someone please help. Thanks. Chris. FileMaker Version: 7 Platform: Windows XP

Can anyone help me. I am trying to figure out how I can change the field color or text color of a particular cell depent on what is entered. ie. If "No" is selected from a pull down can it be red...or "Yes" is selected can it be blue? FileMaker Version: 6 Platform: Windows 2000

I have a database with several buttons...These buttons all are linked to other databases on my computer. I would like to find some kind of way to open all of the databases when I open the main database. This way I can make sure I did not forget any. Can anyone Help. FileMaker Version: 6 Platform: Windows 2000

I use Windows and Filemaker 5.5 The situation I need help on is the following one: Filemaker will receive a new record , activate an application and send a message with the parameters to the users. e.g: the new record: ID- 001, name