Script Workspace and Script Triggers

Hi, I'm new to the group.. so I'll apoligize in advance if I'm doing this incorrectly. I have FMP 4.0. I would like to set up an if statement the following way: If Field 1 = "alpine" then field 2 = $15. Field 1 will have a pop up menu with like 50 different cities. Field 2 is the price which will change according to which city has been chosen.

Got a bug that's driving me over the edge. Hope someone can help. I've got a script that exports data to a Word file called Master Products.tab. Whenever this script is executed I want Master Products.tab to be created on my desktop but for some damned reason it keeps getting created in a special folder I used to test this script when I first created it. What really determines the destination of an export? When I specify the desk top as the destination in the script editor, the stupid script still puts Master Products.tab in the folder instead. Does the Restore option have something to do with this? Are export destinations somehow stored along with export orders in s…

I have a FM Pro 4 script that loops to tests the value of a field and omit the record if true. The problem is when there are two or more consecutive records that meet the test criteria. In this case, only every other record is omitted because the record is omitted and when the script reaches the goto next record step, it is going-to from the record AFTER the omitted record, not from after the record that was omitted. So far, I've "solved" the problem by sorting by the test field and creating a loop that counts the desired records. I then loop again until I reach the desired field, and perform a multiple omit. But this involves user interaction to enter the value …

Hi, I am importing data into filemaker using .txt this works fine matching current data and updating new records in my solution. However, if when importing my data that is not found in the txt file but is found in my solution how can i get filemaker to check a box ( field ). The reason for this is i can still keep a record of the delete record that is being import, but not want to show it on my monitor screen ( e.g ) Regards, Martin

I wish to be able to calculate a class average for percent attendance in a subsummary part, where I sort by class. The students do not all have the same number of days possible in a month. A summary field that gives me an average of student averages is not accurate because some students register or leave during each month. I can use a calculation field but only if I do my report manually, class by class. I wish to do the entire school, with each calculated class attendance automatically done. (The calculation field will calculate the school attendance properly but will not calculate individual classes that the report generates when I sort by class.) Any Suggestions?

G'day All I have a problem where I have 2 fields (fields "b" & "c") that must be filled in on entry of data in another field (field "a"). Field b is based directly on field a, it's actually the data in field a cleaned up. field c is then based on field b. I've come to the conclusion that I have to use a plug-in/extension for this & have downloaded doScript from Step Up Software as a start. Trouble there is that doScript is Mac only & while that suits me fine the solution I'm working on may need to run under Windows as well. Any suggestions for other plug-ins that may work which are available for Win as well as Mac? ... or any suggestions for non plug-in …

I have a master file of companies and a related file of employees. How can I go to the related employees of ALL the companies in the found set of the master file? My problem is that the master file is large, 10K records or so and will grow. In most cases I would set up the following: 1) Go to a layout in the master file that contains only the Company ID number. 2) Copy all records 3) Go to a layout containing a global field that will act as a temporary match field to the Company IDs in the Employees file. 4) Paste into that global field 5) Go to related records in Employees (via the global field). That has worked wonderfully in the past. However, with a master f…

hi guys. I couldn't be more idiot... I needed a little database that just opens at the start of the computer ( MAC OS START PREFERENCES), and, after relating FM to other 5 DB , close itself automatically. ( I thought was the only way to let the computer in which the database is the host of all the 5 others DB) so, i've done a start script ( start preferences: document) that tells him to close after the opening (and AFTER checking the 5 relationship with others DB, that normally need 6 seconds...). To avoid the impossibility of access to the file i've created a button that activated the script pause. But i can't clic it all happens so fast: it opens and clo…

Here's the situation - Two number fields with the names 'found' and count'. Whenever a sort occurs, this script is triggered. Loop ExitLoopif [count=(currentfoundcount)] SetField [count, count + 1] SetField [found, found + 1] PerformScript [next] End Loop As you can see this will go through the search results and add one to the existing number. This, by the way, is to track what was found over a website. All works well but the last record found gets add whatever the found count was. Why is this happening? Thanks Rich ------------------ Rich

This applescript insert filename and picturefile into a text- and a containerfield and adding new records to the db. And the great thing about it, is that it use only the reference to the picture. Is there anybody out there, who can "convert" it to work with a single picturefile and only on the current record? --choose a folder with picture files activate set folderPath to (choose folder with prompt "Choose a folder with pictures to import

Is there a way to customize an import through ScriptMaker? I would like to preset the field mapping and options, instead of going through the dialog box every time. Any ideas?

I have a database with a field that contains licenses numbers. There are a limited amount licenses that we have purchased. I have created two related files: a "used license" file and an "available license" file that contains the availabel licenses. I have written a script that displays only the available licenses in a pop up menu when entering license numbers into the records. The script then creates a record in the used license file containing the selected license and the current user name. The problem is in deleting the selected license number from the available license file. I've tried three different external sub scripts and each time, the wrong license record …

I would like to avoid a printing accident such as the users printing all of the records in the db because they forgot to input print limits. Creating a default with the number 1 being inserted in the Print dialog box From: & To: fields seems to be the approach. Can this be scripted? If not, options please. Thanks. L.

Any recomendations for how- to books on advanced scripting or calculations. I have filemaker Bible and Companion. What about Demysitfying Scripts or Advanced Companion or ???

Hi there, Does anybody know a way of triggering a script other than explicitly clicking a button or selecting the menu? Specifically, I want to be able to trigger a script after a user has created a record, entered data and then moves from the record (either by going to a previous record or to a different layout) Any ideas are much appereciated. Andy.

I have over 3000 records with 10 fields to archive from 2 different layouts, however some of the field names are different. The archive file name is unique for each day and I have written the script to generate the name from various elements of the records. Is there anyway to automatically set up the field export list so that it is correct for the records I am exporting and also automatically allocate the file name and path to the dialog box. Phew, I hope you understand that. I have only been working with filemaker for 3 months here in the UK Many thanks

I have created an attendance program for students in a school. Each day I create a new set of records for ten students showing whether they are absent or present. At the end of the month I select the month's date range, then use refind to pull up each student individually and print a report that shows the dates he/she is present and absent for that month. This works well, but pulling up each student individually is labor intensive. I would like to create a script that would allow me pull of all of John Does' records within a specified date range, this could be 20 records per student, print the report and then go to Mary Smith, pull up all of her records within the same da…

I'm trying to write a script in FM5 That will first save a copy of the current file then create an e-mail with that saved copy attached and mail it using Outlook as the default client. I have been able to make the script work except that when I attach the .fp5 file it doesn't send. If I attach virtually any other type of file including .fp3 files it works great, but .fp5 files (tried several different ones, not just the recently saved copy) seem to make it baulk. Has anyone got any info that could help me?

I understood you up until you said "I want to have an resume similar this". (I'm guessing English is not your first language.) Do you mean "result similar to this"? Then I'm really confused. What to you mean by "Total of 2 is 1" Why don't you describe in words what you are trying to do (the overall concept). -bd

Im trying to get FM5 to send out e-mails on our macs, mainly using outlook v4.5 and 5, but I'm having a bit of trouble!! I have tried with some sucess using the applescript version which someone posted here a while back, but unfortunately it keeps falling over for no good reason (I get a token error?) sometimes it works, sometimes it dont ? but it's not stable enough. heres the script "tell application ""Outlook Express""

I have a script that uses a pasted keyword to "Find" all the records for each component of my database. Downstream, I need this same script to change to the one of several layouts that matches my pasted keyword/component. For example, I want to go from artifacts to documents. My script uses the pasted "documents" keyword to find all documents and now needs to switch from the artifact layout to the document layout. Is it possible to have a (single) script switch layouts based on the pasted keyword? Thanks. L.

I have a sales summary report that is used in the following manner: In Browse mode they click on a button in the header labeled "Specify Search Criteria". This causes a script to run that puts them in Find mode and pauses. At this point the user can enter their search criteria for every field in the body of the report by selecting values off of pop-up lists attached to each field. I want this search criteria to be disaplyed in the header of the report when the report gets rendered so.......when the user clicks "Continue", the script copies this search criteria from these fields into a set of global fields displayed in the header using the Set command. Example: Set (Sal…

Hi All, I have a script which exports records to a file which is then imported by another database. My problem is that I want to delete the export file before I run another export. i.e.: > Run Script > Delete old export file > Export files to new export file Does anyone know how I can delete the file from within the script. I'm running FMPro5 on a Windows PC. Thanks

New position at work... Took over FMPro "STUFF"... Right off the get go I have run into script problems due to Non-generic names throughout the systems... (None of the finds work due to everything being labelled wrong...) We have exported and Pivotted the names and there is a "HUGE" amount of change from one convention to the next... Is there a way to run a find and have it Omit all those that match a Value list? I would run the finds by hand (will in a few days if no other options arise...) but I am working on a file maker database's that is larger than any others I have ever seen and there are alot of them... We wnat to run a script in them that Omits and than com…

I use a small Filemaker db that keeps track of client contacts. There are fields for name, date of contact, reason for contact and result of contact. The contact layout is set to view as list and we scroll through it like a rolodex. What I don't like is to scroll through and find all 20 contacts for one client listed one after another. It's cluttered. I'd love to rescript so that only the first contact record for each client displays. To review contact history for any client would simply require a find and a find report layout. Is there a way to script so only the first record for each client is displayed?

Can you Force FMPro to run an excel script? Or Vise Versa? Can you force Excel to run an FMPro script? Use VB? ------------------ Thanks, Ken

I have 8 different fields set up in a database, and need to create a new field that uses the highest value of these eight. Can anybody tell me a nifty way to calculate this value? Thanks in advance.

I need to create a report from my invoices. Each invoice is assigned to a sales lead. I need a report that list each lead and the sales generated. The catch is that I would like a total number for each product, the product name, and the total price for that product. The report may be generated for 5 invoices or 1000. Example: (this may be the result of 40 different invoices) Sales Lead "Trade Shows" 25 Software X $12,500 10 Software Y $ 5,000 15 Software Z $ 5,235 Total $22,735 Sales Lead "Direct Mailing" 17 Software X $ 8,500 5 Software Y $ 2,500 10 Software Z $ 3,490 Total …

I have three layouts. Layout "A" contains records with a start date and a finish date. Layout "B" is a find layout. Layout "C" is a summary layout. On my "B" layout, I have buttons that find records within a given range from the current date (ie. "within 30 days", "within 60 days", and "within 90 days".) Let's say I click on the "within 30 days" button on the "B" layout. I want a script that performs the following: Go into the "A" layout, find all Start Dates of the records that are within 30 days of the current date, and show those records on the "C" layout. The date format of the "A" layout is mm/dd/yyyy.

O.K. I'm a little frustrated... Does anyone know anything about every 32nd script in the menu greying out as if you don't have the privelages? We have a HUGE number of HUGE databases and one extremely annoying glitch... Everytime we add scripts we get the 32nd and then the 64th and then the 96th script greyed out??? Any IDEAS??? Figured this would be a known problem as we have it in a few places??? ------------------ Thanks, Ken [This message has been edited by dmack (edited November 21, 2000).] [This message has been edited by dmack (edited November 22, 2000).]

I'm a Mac user and have never really used underscores, but I often see other FM files with underscores in file and field names. Do you need to use them for a file to work on a Wintel? Or will using a spacebar in Mac translate just fine in a cross-platform environment?

I have a script which uses dates entered into 3 repeating fields (10 repeats each) to create up to ten new records, each of which displays one set (ie 3) of the dates. Those three dates appear in the new records in a repeating field as well (with 3 repeats) Sounds easy, right? But: With "set field" dates are only copied into the first of the 3 repeats. Although the script includes instructions to copy dates into repeat 2 and repeat 3, they remain empty. Nor does the insert calculated result function work (result equals date), even when I change to the appropriate layout in the script. The only thing that does work is copying and pasting, which is an enormous hassle…

Hi All, I'm trying to write a script for a file that contains sum 100 records. I'd like the script to select all records, go to 5 different fields, and then clear the contents of the fields. I need the script to do this for all 100 records. I've written the script so that it performs a "Find ALl", then a "Go To Field" and then a "Clear Field". It does this for each of the 5 different fields. However, it is only performing this script on the 1st record and then stops. Can anyone tell me how I can get this script to repeat the process on all 5 fields? Thank you for your assistance and comments. Joe T.

I am a week-old fmp-man and I have a problem I have several fields in my database that are not shown in the layout. There is a set of radio buttons. Depending on which is clicked, I wish to display a given field. Is this possible? What are the script steps? I'd be grateful for any guidance

Hi, Can anyone tell me if it possible to actually define a field in Scriptmaker. I know you can open the define fields menu, but I'd like to go one past that and actually modify and define the fields right in the script? ------------------ AA

I am working in FMP 5 and need to create a script to Find records of all jobs, which have 5 or more separate records -- e.g., 00-1234 has 6 records, 00-0123 has only 2 records. I can create a value list from the Job Number field, but I am stuck as to how to select the first value, perform a Find, check status, set flag for the Find and then go on to the next value in the value list. Any help will be appreciated. I searched the ScriptMaker forum, but did not find exactly what I am facing. TIA

Best To All! Developed db in Accsess that must now be converted (improved some may say)to FMpro5. Not being a seasoned db veteran, I hope to find info to help me transfer concepts/terms learned in Access for application in FMpro5. I have managed to import my tables, establish relationships, and am now learning layouts/scripts. 1)Scripts=Macros How about VBA equivalant? 2)Events equivalant? 3)I assume storing master table in same "folder" as related tables (2)equivalant to storing these 3 tables together in Access db window? tia yellowpike

I have a db to keep track of counseling sessions. It can be sorted by client name (default) or by date of session. There's a layout to enter records (view as list), another for search criteria and a third for reporting the found set. The Find Report layout accommodates printing. At startup, all records are found and displayed but when I return to records from my find layout (using my startup script), the records displayed are always minus the number in my found set. Even though the startup script is set to "restore sort order" and "show all records", total records aren't displayed until I manually hit a sort button on the records layout. Any idea why a "restore sort or…

i'm trying to find the total number of months in a payment database. i have created a "Payment Begin" field (Date) and a "Payment End" field (Date). Also have a "Months Remaining" field (Calculation) which is PE - PB. However, the answer is in years and i'd like to convert it to months. I tried to multiply it by 12 but that didn't work. i should also mention that there could be 5 to 10 years between the PB and the PE. so what i really want is to know based on the PB date and the PE date AND the current date (Today), how many months are left on the payment. any ideas?

i've accidentally poseted this in 'define fields', so here it is again: i'm trying to come up with a way to quote text. i've done the following: SetField

I am the music director for a small-college radio station, and we use fileMaker pro for all of our database work; for example, each DJ creates an instance of "playlist" (a pseudo-template), adds new records with the artist/song/album (text) and newMusic/request (boolean) information, and saves a copy in the "this week" folder on the desktop. Each week I need to compile a "master playlist" which contains all records from each of the playlists in "this week", and until now I've been using a somewhat primitive script which asks me to specify from which file I'd like to import records at every step. Could someone please give me a hint on what kind of script I can use in ord…

Hi, I would like to filter static values within a portal. i.e. If file A and file B have a one(A) to many(: relationship, and I have a field in file B called status with values containing "active" or "inactive". I would like to display ONLY the "active" records within the portal from file A. Can I achieve this?

Windows Platform FMP5 On a record I have an engraving number. There are items(numbers) associated with the engraving number. I have duplicate engraving numbers. I need to eliminate the duplicate engraving numbers and place all the items for the one engraving number on one record. I have a list of records that has to be searched through. At this point everything is in order because the records are being imported from …

What is the maximum number of script in a file and how script work with Windows in term of ressources used. tks

I have a 5 file relational db with all 5 opening to the same password. I assumed if I had the main file open all the others, hidden, I would only have to enter the password once. I could even swear I've done this successfully in the past but it must have been by accident because I can't remember how. Is there a specific order for script steps to open related password protected files by entering the password just once? Thanks.

I'm importing some data from a Simple Text file, into several fields including company name, ammount owed and due date. I have 3 letter layouts which I want to show information from the imported records depending on the date of some of the records. The field; due date shows when a bill should of been payed by, if any of the records are over 30 days due I want them to be put into another layout; letter one. If any records are over 45 days late then I want them put into another layout; letter 2. If there are any records over 70 days late then I want them put into another layout; letter 3 I'm a bit unsure on how to acomplish this although I'm hoping it should be pret…

I'm a filemaker novice and am having difficulty setting up a script to send emails from a filemaker pro 5 database. any help would be greatly appreciated. I use both a PC and Mac, so the script should be usable on both platforms. generally, I use netscape communicator for email, but have installed eudora because filemaker's help tells me that's what i need, but I still can't seem to get it to work. must I have my internet connection and eudora up and running before running the script? can a script connect to the internet, send an email, and then disconnect?

Firstly is there any resources were I can get a "dictionary" on scriptMaker? Secondly I need a script a script that takes a user to a certain layout depending on the password they entered on opening the file. Any ideas of how this could be done?? Thanks

Hi there Hope i can get some help. I have an import script running on filemaker, but when I search in the database from the web using CDML the script i shut down :? Why is this, and more importaint can i do anything to prevent it ? Eske

What is the trick with dialing the phone? When I use that script step it only counts down to when it will allegedly hang up the phone --but it doesn't even take the modem off the hook, much less dial in the first place. I've never been able to get that script step to work on my Mac and the "Help" file betrays its name. I've resorted to sending apple events to outside dialing applications to automate phone dialing. Am I missing something incredibly simple? Thanks, Dave

Hi All Is there anyway to get a checkbox list of values to scroll? This is so that in a new record, to save time I want to check off items from this field looking at previous records and add to it as well. I can do it using a normal scrolling field but cant check items in this field and the check box formatted field wont scroll as the list grows. I'm still using FMP 3. Thanks in advance

first, i know very little (that may already be obvious). i'm on a trial version and have no manual. i'd like to have a pop-up menu with calendar dates for the entire year available to select. how do i do that? do i have to run a script at all? if so, where? i don't have to manually enter these bloody dates in a value list, do i? thanks for whatever help you can offer--i'm on a deadline and am up blank's creek.

Hello, I am creating an inventory database where I need to save an inventory history. I need to be able to duplicate an existing record (simple enough) and then lock the original record so only the duplicated record can be edited. How do I lock the original record after creating a duplicate? Any info is greatly appreciated. Thanks! Tom Bardenwerper [email protected]

hi guys i need a little help here. i'm new to the scripting in FM. please if it's not too time consuming somebody help me with the following: i have a field f1 like this: [empty] [empty] 123 234 345 and then a filed f2 like this: 123 234 345 456 567 what i'd like to do is a script that checks if f1 is empty - if it is does nothing to the f2, but if f1 is different then nothing set f2 to the value of f1 iguess it's not very difficult script to do but i couldn't get it to work. help please. franz

How can I use scripts or other mean to desable some items in the general menu of FileMaker. Thank you.

I've just started developing with FM 5 and i need to know if FM enables me/users to track documents. More specifically, i'm creating an app package that must enable a network of users to sequentially circulate records/documents while knowing (which IP address) where each document is. Is this possible through scripting or must i use some kind of interface to accomplish this? Complex but please try... and hurry. thanx

FM4 G3 Mac 8.6 Quotation file with Repeating fields and Product file linked via a Relationship. Entering Product code into Repeating field in Quote brings in details and price via Look Ups which works fine. Now trying to have a different discount entered in Quote depending on quantity of goods entered, i.e. quantity breaks and discounts. LiveOak (Auto Disc ... 22.10) has kindly suggested a calc whereby the discount Quote entry refers back to the relevant Product breaks and discounts. This is basically working except the discount calc is referring to the wrong product and therefore calling in the wrong discount Is this a fixable problem with Repeating fields or have…

Does anybody know of a script or function to convert regular time into twenty-four-hour-clock (example: 1700=5:00 P.M.)

Is there a way to tell a script - When you perform a find and the results are "no records found" to continue automatically or to otherwise continue to the next step?

Our school district is a mixture of Macs and Windows machines so any db we design has to consider cross platform issues. One particular print script is giving us fits. It's a simple Go To Layout "xx", Page SetUp Restore, Print, Go To Layout "xy", Page SetUp, Restore, Print. Since they are 2 parts of one large 11 X 17" sheet and always printed together, it's less time consuming to do it this way. Works like a charm on the Mac. Running FM 4 on Windows 98 and printing (via USB) to a HP DeskJet 932C, it prints the first page only. Any idea if this is a platform issue or something unique to my machine or my script design?

I have a rather long script that's initiated from a web page. It seems that the script can be interrupted in the middle by any other action initiated from the website. For example, the script is running, and someone creates a new record at the same time, then the script is cancelled. I have a 3 second pause inserted into the script. I thought that might be the problem. I tried to insert a user abort off into the script but that doesn't seem to help. Any assistance would be greatly appreciated. ------------------ ~~~~~~~~~~~~~~~~~~~~~~~~~ Tom Beidler Orbit Tech Services tbeidler@mindsprin g.com ~~~~~~~~~~~~~~~~~~~~~~~~~

ok i'll get straight to the point. i'm trying to make a script that will have you enter in something for a field and it finds all the records that have that in that field and then sends them to an archive of all the records and then deletes the ones that you sent in the current file. I havent been very successful so far and any help will be appreciated.

FM4, Familiar with very simple scripts but not calculation scripts etc. Have a routine quotation file using repeating fields containing usual Product Code which calls in Description and Price (from Product File). All works OK but what we wish to do is have a discount appear automatically instead of having to look it up and enter manually. For example, if we enter a Product Code and then a Quantity of 100 which attracts a 10% discount, is there any way of making the discount come in automatically with perhaps 25% for 250 and 50% for 1000 etc. We would still need the option of changing the discount figure manually if necessary, i.e. it would probably be no good if t…

i have a solution which hides the normal menu commands. now the 'print' command is issued with a button, but this means that selecting a fax print, which is usually accessed by holding down option when choosing print, is not available. i've heard that this can be emulated with an applescript. does anyone have such a script of know where to get one?

OK, how about this one: Is there any way to create, in a script, a new find request that has the "omit" box checked... ...without restoring a find request?

I know how to restrict access to features, fields and layouts, but is there a way to prevent a user on a network from viewing specific records?

I am designing a database in FileMaker pro ver 5 and need help with the following. I want to be able to select records over a periods of time, in a random fashion. For example, one field in the record is a color. There are 4 colors, with each color having a different frequency of selection. Red might be weekly, on average over a 6 month time. Blue needs to be randomly selected on average once every 2 weeks, and so on. I also need to be able to restrict the selection to monday - friday, and exlude dates based on a list of holidays. My talents lay outside programming, but hope to give this a good try. Please copy any responses to [email protected] Thanks for…

Thanks everybody for help on the last two postings. I had a "duh" moment but got'em. Now, I'm wondering if there is any way to allow a user to create a script or edit a script without having access to ALL the scripts. Anybody know? Thanks, Dave

Hi, Situation: I have a value list with 5 countries (United Kingdom Germany France Denmark Switzerland) When I select the appropriate country, ie Germany, I want only the cities in Germany to appear in the cities Field (check box formatted) Does this make sense? Is it possible to dynamicaly bring up the Germany City Value List? Any help for a new user would be appreciated. Regards, Chris

I'm new to this, so thanks for any help you can give me. I'm trying to create a script that copies ALL the contents of a repeating field and pastes it into another repeating field. It seems like it would be easy, but for some reason I can't seem to copy ALL the contents. I can copy the data in the first line, or I can specify the script to copy a specific line of the repeating field, but I can't copy everything. Unfortunately, each record has a varying amount of data in the repeating field (i.e., one record might not have anything in the repeating field, and another record might have 10 lines in the repeating field.) I can tell that the repeating fields are going to be a …

quote: Originally posted by sboard0599: I am trying to write a simple script or calculation that will match an CSR's name with her email address. i want to choose her name from a list and then have her email appear in another field. I have entered all of their names in one value list and entered all of their email addresses in another. I am trying to write a calculation (if csr name =xxx, then email [email protected]). I cannot get this to work. Any ideas for me? It sounds like you need to have a file dedicated to people which has fields for their name and their email address. To get what you want done, it would have to have at least two fields: Name, Emai…

I have several fields which have sliding up set to them, so if there empty they move up. I want to have a small graphic by the side of each field, but if the field is empty I want the graphic to be hidden. Like in; "do not print selected object." So I'm trying to creatre a script but I can't find all the info I need; I've got the following so far. if Background_bullet1 = IsEmpty(0) Background_bullet1 is one of my fields. Am I going a long the write lines

is there a way to do an if/else/endif with two alternatives depending on which password the file was opened with? thanks, stefan

I guess what I am really stumped on is how to get a script to run when a cursor enters a specified field or fields. This way, I can store the location of the cursor, run some calculations and then paste the data. Any sort of buttton to activate the script makes filemaker lose the cursor location.

Hi! i have 2 files. From first file i use GoToRelatedRecord[showOnlyRelated] to go to the related records int he second file. HOW DO I LOOP thought ALL related records ONE BY ONE ( in order lets say to add up the total price ):? Is there a way to do so only from file two?? or do i need to have a script in file one ( that goes goToNextRecord ): The reason i need the script to run in the second file - is to keep the database as flexible as possible. Plz help.

I need to make a history field in our bug database. Right now, it keep a history of 'comments' by putting the date, time, and comment at the bottom of the field. What I want to do is add what fields have been changed in the record. For instance, I'd like it to say something like: 9/28/00 7:56AM Fields changed: status owner description Is there a way to do this with a script? When you submit something, it has to know what fields have changed and what has stayed the same, how do you get that information?

hi im new to all of this and have a problem thats why im here I am trying to right a fm doc that will keep track of american airlines customers who we give mile credits to so for what i am able to do is enter customers their id codes and all have that refer to a payment page which is by the month and year and have a running total for each of the customers the part that is the prob is that each month a payment is added and i need to have a voucher code that is in order per each transaction for each of the customers accounts so if anyone wants a problem to solve ill be checking this every day thanks fc

Does anyone know of a way to automatically select a printer on the Mac (Adobe PDFWriter) and then reselect the original printer when finished. I am writing a database that has a "Print to PDF" button on the interface. The idea being that the user can click on this and not worry about swapping printers in the chooser. As far as I'm aware the chooser is not scriptable, and an fm script will not restore the PDFWriter as a printer choice. Any ideas would be gratefully received.

what you are trying to do exsposes some of the weaknesses of fmp. Plug-Ins are the only thing that will currently allow you proceed. go to filemaker.com or fmfiles.com and browse their Plug-Ins section for the descriptions of those available.

When I use a find command and come up with, say, 10 records in my found set. How do I perform further finds that utilize just this 10 records? If I do another basic find for another record, then this record will show, but if I want to search for other records, they won;t show, since the ensuing search was on the found set of 1. Am I missing anything? ALso, is there a way to customize my find view, so that only certain fields appear on the layout as searchable fields?

Please excuse the imposition. I have talked to both FM & Metrowerks. I have had trouble with FMP5 Dev & Code War 6.0. Took new computer, installed FMP5 Dev. Installed Metro Code War 6.0 Tried to compile the Fmexample and got many illegal implicit conversion errors. When I compiled the Fmtemplate no problem. Fm tried to help but the tech who knows about this was already gone. At MetroWerks they heard of this but not exactly sure of what to do. They gave me some Pragma code but didn't work. Thaught you might have some insight. Tried with these just to check out compat. before we resume writting code with the new products. Thanx Greg Valen…

Is it possible to have a related file that contains a defined number range which could provide a text result. i.e. >100 and <200 = "Print this text" So if 150 is entered in another related file, the above TEXT result is given. To my knowledge, the AND,OR,XOR only return a logical 1/0 result. Is there another way around - I'm probably overlooking an obvious answer!

My job tracking file has a repeating field for due dates of various tasks. I have another Filemaker file that allows me to select dates from a calendar. How can I write a script that jumps to the calendar file, allows me to select the date, and then pass that date back into the repeating field my cursor was in (in effect, creating a little popup calendar)? If I create a button to perform the script, my cursor position gets lost when I click the button. Any help would be appreciated.

I'm aware that I can't "fix" the length of a field (eg., allowing only 5 characters for a zip code)in FMP. I saw suggestions re: using a validation message. But I'm not sure how to put it together. Should I use the length function eg., length (field) = 5, then what script should I use to pop up the message if validation fails?

I am attempting to have a script be called as son as a value as been chosen from a value list. Script: open another database Can it be done?

how do I write script to allow me/user to go to a certain layout in a related file, print a certain set of records in full (eg, all records assigned to a certain staff, assuming each staff has a his own set of records). Better still, the script will allow me/user to enter the staff name, and finds those records, then print...etc

quote: Originally posted by jjhill: I have a folder called Photos, in it are folders with JPG files from a Sony camera (ie disk1, disk2, disk3, etc.) ? Is there a way or script that can be used to start at the first file, import a picture from the file name (disk1.mvc-001.jpg), move to the next record and loop it until all files are loaded into the FM database. I have to do this with about 2000 photo's You cannot do this directly with FMP, as FMP cannot directly manipluate the file system. You need to use some external application to help you out. You can use something like Applescript or WinBatch to help grab the files, by manipulating FMP Import Pic…

I am attempting to have a script be called as son as a value as been chosen from a value list. Can it be done? using FMP 5, windows ex : I choose from a list containing customer names and IDs, and as soon as one is selected I want a script to copy all teh data from that customer into the fileds. (customer data is in a separate file, I know how to make teh list, and the script, but not how to get teh script be called as soon as a value from the listr as been chosen)

Can anyone troubleshoot this Script? I want to merge all the rows of portals into one field, ending automatically when I get to the last row. I can't seem to figure out how to get out of the loop. Script Go to Record/Request/Page [first] Loop Go to Portal Row [first] Set Field [field 1:file B] Loop Copy [select entire contents] Go to Field [field merged:file A] Paste Go to Portal Row [next, exit after last] End Loop Go to Record/Request/Page [next, exit after last] End Loop Thanks in advance. Steve

I am importing data from excel which includes a column containing dates. The problem is that the date is not formatted & is required for a letter template: '260900' instead of 26/09/00 Is there any calculation i.e. texttodate( ) etc that would format the data correctly for me. Cheers Mattc

Is this possible in FM 4.1 to write a script that will create 100 records with field values from "1" to "10" and "A" to "J". i.e. to have 100 records that are labelled 1A, 2A, 3A

I have my portal within my solution. From the portal i only want certain information imported into my fax. Total of 3 fields. I have tried a few ways of doing this using copy and paste. The other way was creating new file and using another portal within the first database, selecting fields from database and coping into other portal, however when doing this my problem was that if i was using line 3 of the portal when coping information it would not copy information into the other portal unless i was coping from the first line of the portal and in order. I only need to copy certain lines of the main portal. This is a very hard one to explain. Please, please help. Regards…

Is there any way to remember the active (currently selected) record in your current found set, then create a different found set (inclusive of the earlier found set) AND THEN use the GO TO RECORD script command (or something else) to move to the remembered record? I know you can use the status(currentrecordID) to find the unique ID of a record, but you can

Is it possible to show a value from a database field in the "Show Message" script command? Or, can you only have fixed text in these messages? I would like to display a message like, "Are you sure you want to delete the record for 'Joe Smith'? " where "Joe Smith" is a field in the current record.

Hi. I working and creating a Filemaker database and I would like to be able to validate 2 different fields (ie: date, name) when inputting a new record. Is this possible to do just in the Validation screen or do I have to create a special script for this? If I do have to create a script, any ideas how to go about doing so? Thanks alot in advance for any responses.

Hello All, I have a relational database with a form and a find layout in file1 and a list form in file2. After performing a find using the find layout in file1, I want to switch to the list layout in file2 but only display the found records. Can anyone help me on this one? Greetings, Eric

i think i screwed up on writing scripts in a file. Now the file is not letting me exit (unless I close the application all together). I can't go to Scriptmaker (since it's not available anymore). The script seems to be looping indefinitely. I tried pressing "Escape", and didn't work.How can I go back to file and delete all those scripts?

Is/are there a site(s) on the web where pre-written scripts can viewed, downloaded and uded? Something like a Script Encyclopedia? Thanks Gary

Can you give me an example of a script and how to set up the global field. In other words, I need more details because I'm new to Filemaker. Thanks... Greetings, Eric

This should be a simple thing...somehow I just can't grasp it. I have 6000 items defined by a unique ID in my items list. Each item is placed into use a varying number of times. These uses are listed by date and time on a Schedule. I need to know which use I'm on at any given time. That is, when I look at the schedule I need to know if I'm looking at the first use, second use, 50th etc. I'l be looking at items that have been in use for years but I want o know that during a selected time frame I've used itemxxx for the xth, xth and xth time. Please help, I'm stumped and thanks.