Script Workspace and Script Triggers

Is there a way to select a group of fields or objects and move them to a new location through a script? I've been pondering this for a few days and am not seeing the way. Much appreciated, Nati

I have only been working with Filemaker for a few months now and I love it. Now I am starting to delve into scripts. I am in the planning stages of a series db's that will evenutally be web-based, allowing users who will be working out of their homes access to specific job-related information. What I am wondering is, can a script allow users access to a certain file/db then only allow them access to specific records that they create? I am trying to prevent users from having access to other user's information, but I want them to have access to the file to create their own records. Before I delve too deeply, can a script accomplish this? Thank you.

I am looking for a script that would automatically delete all records in the database that are 3 months old. Could someone point me in the right direction?

I am writting my first script. It exports a database to a different name. Then the script wait while I choose which database and it opens it but I can't select in the WINDOWS drop-down menu or figure out which script command will. The WINDOWS drop-down menu has the two database files greyed-out. What do I need to do to be able to choose which database is on the screen?

I have a set of databases which help to determine the numerous "deliverables and deadlines" for my various team members. In order to accomplish this task I have one dB set up for each area with a number of fields and calculated date fields based on a given target date. In order to make these fields and files functional in the larger relational system, I have a script which creates individual records of each of the fields with area name tags in a separate database. I keep both dBs seperate because the date calculations in the first database are contingent upon each other. The problem is, each time I add or subtract a known "deliverable" I have to go back in and rework th…

is it possible to write a script that will note what today's date is, then find all records within a month of today's date? I have only been able to do this if I input a specific date into the script, but I want it to work from whatever date is today. I need it to show all records a month from the day i access the file. Thanks!

I have just started using FM and would like to know how to change the color of a field as data in entered into the field. ex.. If 1 is entered into a field the background would change to blue...if 2 is entered into the field the background would change to red. Thanks for the Help! RJ

i need to find how many field begin by "dem" (dem 1;dem 2;dem 3...) i dont want to use the find mode can you help me

I have a main script and layout containing buttons that call external scripts and layouts, and those scripts and layouts also have buttons that call additional external scripts and layouts. In summary, I have three levels of subscripts. The good news is that all of my data manipulations and layout navigation work as intended. The problem I'm having, however, concerns my use of a Pause/Resume script step in the "second level" subscripts. Once a user is finished with the third-level layout, I want to go directly back to the first-level layout. The problem is that on the "return trip," the user needs to press Filemaker's continue button on the layout, or the Enter key in ord…

I need to search through a rather lengthy record (200 fields) looking for a special embedded delimiter character (hex FD). I thought this would be a straightforward script where I would set a variable to the first field name, examine the data in that field for my special character with the PatternCount function, and then simply

I am developing a cross platform solution that will have a series of global fields which will be assigned a button function. What I want to happen is that when the button is clicked, the contents of the field are copied to the clipboard. Easy with a separate script for each button. I would like a single script that "reads" the contents of the field that is clicked. Any ideas? [This message has been edited by esteshk (edited February 28, 2001).]

I'm trying to build a db to print shipping labels and an issue has come up where we need to display a list of letters on the shipping label. Each product line item has an associated letter and the main label needs to have a list of the letters for products that match the match field. There are a number of problems with the portal: the most significant here is that it lists the letters separately and vertically only. The final list of letters should look like something like: a, c, f, g, g, c Anyone know how to build this list using calculations so that the list will be contained in a text field? This would be easy using Perl but it seems pretty difficult in FileMaker.…

Hi, I was wondering if anyone knows how to seperate something like: 12:00-7:00pm MWTRF into 12:00-7:00pm as one field MWTRF as another field using a script. I'm new to Filemaker so I don't have alot of experiences with Scripmaker. Thanks [This message has been edited by Kermy (edited February 28, 2001).]

Does anyone know of a way to combine two or more scripts into a single one? I've got three smaller scripts that I'd like to execute in "one fell swoop." Any suggestions? Thanks!

Hey all, This is for one of my projects. Been having trouble trying to create a script which will create a new record and automatically set the date field to be 1 day later than the previous record. For example, say I have a record in last week dated at Feb 20. Today I want to create a record which will automatically label the date as Feb 21. And if I use the script again, it will create a new record with date of Feb 22 and so on and so forth. Any ideas will be well appreciated. Note however that by setting the date field to auto date creation will not work.

another question: how do i create a script whereby it can automatically delete records of the same date. say i have 8 records with the respective dates: rec1 Feb20 01 rec2 Feb20 01 rec3 Feb20 01 rec4 Feb21 01 rec5 Feb21 01 rec6 Feb21 01 rec7 Feb22 01 rec8 Feb22 01 then the script, when executed will delete any of the 2 records of rec1-3, delete any 2 records rec4-6 and delete any record of rec7-8. TIA

Does anyone out there know how to write a script that will paste a (Microsoft Word) document as an icon into a container field? I know how to do it manually, but this is for an automated application, so it has to be a script. Any help would be greatly appreciated. Thanks, Philip Sommers

Database Background: I work in the semiconductor industry and I am trying to track which wafers are processed with which masks. Not to delve into the technical side too much but we manufacture many different wafer types and each wafer type has it's own mask type. In addition we have thousands of each mask type. Currently I have built two databases; Database 1 tracks the mask inventory, and Database 2 tracks the wafer processing. They are relational so that in Database 2 when I enter the mask number it pulls in other relavent information about that mask. Also, when the mask number is enetered into Database 2, I am validating the mask number field against the mask inventory…

Is there a way to pass certain field information to another program without having to export the information in FMPRO first? Currently I have a script that exports the info I need to a data file, then I have FMPRO run a perl script which retrieves the data and does what I need for it to do (actually it then creats a batch file, which FMPRO then runs as the third step). The problem is that when I put this ALL in one script (activated by a button), I think when script is run and FMPRO exports the data my perl script is run at the same time, thus the data file (the exported file) isn't created yet....so I have to run the script again to get the data from the previous run. …

I have similar records in one database that need to be combined into one record without using a portal. For example, db1 contains an ID and Name fields. These can have duplicated values (up to five records with the same ID). There are also fields for five other values, but this information was stored in a separate record for each of the five fields. How can I create one record that contains the ID, Name, and values for the five other fields?

I am new at scripting and would like to create a script that creates a new record and fills in the fields based on field content from other databases. Any ideas?

Does anyone know how to change a field's value based on anotherones? For instance: field:category is set to be a valuelist with 8 entries. field:subcategory should change depending on what the chosen selection in category is. if category is plumbing, then subcategory should then change to valulist lumbinglist or is glassware is chosen in category, then subcategory should be valuelist:glasslist see what I'm saying? Thanks Rich

I am writing a database using FMPro 5 for a school tracking project. I need to convert the actual date into a year range related to the current school year. For example, Jan 22, 1999 becomes 1998-1999 March 1, 2000 becomes 1999-2000 Since the school year runs July 1 to June 30th. I've been trying to do it using a series of IF/THENs in a script after breaking apart the date into month and year. Is there an easier way?

I wanted to know if anyone has created an abbreviation expander with FM. I would like for the user to just enter cp+<spacebar> which would enter 'computer' or cs+<spacebar> for 'consult' etc.

I just can't seem to get it to work. Maybe somebody can put me on the right track. There are 12 text fields in each record in which specific text may be lurking and is required to be found and dealt with, with a subscript.(I want to delete it, hence the subscript (which does a few other little things while it is there)). I need to design a script that will require the input of a query once in a box and then bingo! press a button and it will find the data in one of the 12 fields and act upon it. Seems simple but having tried global fields, related fields, etc. etc., the correct script will not surface for me. (This is a relational db that is up and running, so I can't chan…

I am creating a script that will select a series of records based on one field, and export selected fields to one text file (delimited) and all fields to another text file...I am just starting with it and am using the "get" method, and am getting memory errors (108), and cannot figure out why...any help??? tell application "FileMaker Pro" every cell of current record end tell also... tell application "FileMaker Pro" cell "Description" as text every record whose cell "DiscoveryId" = "JEFF FOOTT.00001" end tell

Hi , I'm a new member, I have a question over email. Does it have any technique to put portal field in email? Can someone help me? My email: [email protected]

I hope I'm doing something wrong but I can't set up script to print to a networked printer and get it to stick as part of that script and allow it's use on different PC's. I now make each user define all parameters on the print dialog (it gets a bit confusing for them because of the use of a Fax and as to the proper choice between current file and files being browsed.) I was hoping to steamline the process and perform the printing without a dialog if possible. Additional related complexity is the use of another shared printer tied to one PC which is used, albeit only occasionally. Looking for a solution and if possible elegance... Any help appreciated. Greg

Hi Does anyone know how I can conditionally print records? I mean, when the user is presented with the print dialog and presses the cancel button, how can my script handle this (e.g. EXIT SCRIPT)?

Is it possible when I enter the weeknumber in a field it calculates the first and last day in the week? Like: week = 29 Then it will calculate: first day =13-7-1998 last day =19-7-1998 There is a day to week function in filemaker but not the other way arround.

Hi FOlks, A quick question, is the Scriptology book for FM 3/4 the latest version? or is there another scripting book worth looking at for Medium to high level users. cheers

Is there a way to change the size of the "Show Message" dialog box under control of my script? I use the "Show Message" step in my script with a message that is longer than the space allotted for the standard display. The user can expand the box but I would prefer to do it from within the script prior to the display of the message.

I'm using 4.1 and am very new to this (about 1 week - boss gave me the book, Filemaker for Dummies and said "go"). I am setting up a database at work with our client profile and contacts. I need to log in every time a client contacts our agency so I put in a date field (entitled "date") and made about 50 copies of it (ie. "date copy", "date copy2", etc) for up to 50 contacts per client. 1) I don't even know if that is correct or not. 2)Now I am trying to figure out how I can do a search to find out which clients contacted us, for example, in December 2000. Since I have 50 separate date fields, I have no idea how to go about writing a script that will do this. Help! …

I have a script that searches through my DB for modified records then exports them and calls the same script in another DB and so on, the only thing is that if no records are modified then FM displays a dialog box "No records Match this request etc" which gives the user an option to kill the script, which I don't want them to be able to do, just for it to ignore it and go on to the next script. So how do I stop these dialog boxes from appearing ?? do I have to use something like the if records found =0 then else command ? something something any pointers would be nice

I've written a short FM script that uses an Applescipt to retrieve the filename path of a file and insert that data into a cell on the FM database. Currently the AppleScript will only insert the data into the first record of the found set, and I can not figure out how to make it insert into the current record shown. I would like to be able to have the filename path inserted into a field in a manner similar to the "insert picture" script step. Here is the current Applescript that I have come up with: ------- set RefFile to (choose file with prompt "Please select the referenced file.") as string tell application "FileMaker Pro" activate set data of cell …

My database consists of one file that's organized into several different record types (Customers, Orders, Products, etc.) There's one layout (used for viewing and modifying records) for for EACH record type . Scripted finds are performed as the user navigates between layouts to ensure that they see the appropriate TYPE of records only. Example: When user goes to the Customers layout, his found set becomes all of the Customer records in the file. Other finds can done from within each layout to find more specific subsets of each record type. However, these found sets are not retained as user navigates between layouts. Example: User goes to the Customers layout and finds o…

Would anyone know a easy way to print out all of the relationships I have in my files. Thanks in advance Dean

Is it possible to make a new record in a second file and at the same time insert data from the first file? I expect to get into trouble 'cause there's no ID-number for the first file to relate to. Then the logical thing to do is to use the Set Field command to cover this. Can anyone tell me whether this is possible? ------------------ Yeti

Is there some way that I can get the status of the omit checkbox of a find request? I know that if I am in find mode, the contents of the fields are the find criteria. I would like to be able to access whether the omit box has been checked also.

AAAAaaaaaagh!!! Any Ideas: I have to produce a guidance system from one location to the next using Filemaker for my University project. Any ideas on how I could get Filemaker to direct from one reference point to the next "on the fly" using Scripts? I am at a loss! Cheers James

Does anyone know of a way to trigger a script upon leaving a field without changing the value of the field? I'm using Waves in Montion's Script Scheduler, and it works fine if the value in the field to be exited is changed, but I don't want users to be able to change it. Any ideas? TIA Jerry

I am using a slightly modified version of the find duplicate records script found in the FMP user guide for version 4. My question is this, I am running a script from my original which looks for recordfs in the found set. If it finds any, it sends a message, deletes the record and returns to an input layout. If it doesn't, it enters the record, displays a message, and moves to a calendar screen. Here in lies the problem, if it finds no records everything works except before my message the error message comes up. It is themessage you get whenever you do a find and no records are in the found set. If you click continue, everything is fine but I want to be able to have the …

I am trying to get the names of all the fields in a database into a single global text field. I use Set Field for the global text field and try to specify FieldNames (Status (CurrentFileName)). I get an error message that there are too few separators when I click OK. I thought that it was acceptable to use the FieldNames function with the name of a database as a single argument.

Hi, I want to create a script that when it is launched will extract the label of the button that was clicked and use this information as the text to search with in the new layout. Basically I have several floor plans with buttons representing the desks. Each button has a label reflecting the unique desk ID number. Instead of writing 300+ seperate scripts for each button I want to write one script that extracts the label and enters that value in the find request part of the script, and then assign this one script to every button. Is this possible? Thanks in advance

My problem is surely quite simple, but I am a newbie at scripting. Here it is: I have two files: main and second, and a simple relationship on one field. A have another field with the same name on each base. I have a portal, on main db, with a button to go to the second db on the related record, select a field (container with graphic), copy to clipboard, select field to main db, paste picture in it.Manually, everything works fine. When I script it, it doesn't work. Where is the trick ?

Anyone know how to spell "Techniuqes"?

nt

My database has layouts that contain what I refer to as Quick Find buttons. Each button performs a simple find operation based on a specific field having a specific value. For example: The "New Orders" Quick Find button finds all of the order records that have the value of "New" in the Order Status field. I have about 5 to 10 such buttons on each layout in my database totaling about 40 Quick Find buttons. The problem is that there is a script associated with each button therefore I have to maintain this huge list of 40 find scripts. What I'd LIKE to able to do is have just ONE find script for each layout that conditionaly performs the appropriate find operation base…

I'd like to be able to have portals resorted by clicking on header fields just above the protal. Example: A portal contains the following related fields: F1, F2, F3. Above each field is a text header: "F1", "F2", "F3". When I click on the F2 header I want the portal to be resorted on F2. It appears that portal sorting is completely determind by the sort option setting in the relationship definition dialog and that this can only be set by interfacing manually with this dialog. Is this true or is there a way around this?

How about a little more information about the structure of your files. There are seldom "universal" answers, we need more details! -bd

I'd like to be able to set two sizes of paper in the page set up. I've got two lay-outs in one file. One to make faxes and one to make adress-stickers. Both differ in size. My collegues get annoyed 'cause they have to change the papersize manualy every time they make a fax or sticker. So I was wondering if anything could be done about this HUGE problem ------------------ Yeti

I would like to test the contents of each field in a layout. I can get the names of the fields by using the FieldNames function. I can separate them out in sequence. But then I am stuck about how to use those names to access the contents of each field.

code: New Record Request Set Field ["Begin Week", "Week Start Day"] Set Field ["First Name",""John""] Set Field ["Last Name",""Doe""] New Record Request Set Field ["Begin Week", "Week Start Day"] Set Field ["First Name",""Jane""] Set Field ["Last Name",""Doe""] New Record Request Set Field ["Begin Week", "Week Start Day"] Set Field ["First Name",""George""] Set Field ["Last Name",""Smith""] is there anyway to do this in a loop instead of the way i have it and then connect it somehow to my employee database that has a record for each employee.. and create a new record for each employee so i don't have to write those four lines of co…

i was wondering if this is possible.. might take some doing... i am creating a time card database.. and i was wondering if it would be possible to create a script that on Monday morning would move all the records from the previous week into an "archive" database (and maybe aslo export them into an excel spreadsheet so that they can be printed out easily)... and then create a new record for each employee for the current week.

I have a database that tracks a Psych. study's follow up interview statuses for the study's subjects and need FileMaker to update a subject's status to "WITHDREW" OR "DECEASED" if the subject drops out of the study or dies. Each subject is assigned an ID number and the way the database is set up is to assign a record for each round of interview follow-ups. So subject XXX99 has related records: XXX99MO06, XXX99MO12, and XXX99MO24. What I need to happen is if subject XXX99 dies at Month 12 all subsequent follow ups need to show a status of "DECEASED" but not any previous follow ups ie. (Month 6). I don't know if I should run a script (there is already a script running…

Try this script: code: Enter Find Mode Set Field [YourDateModifiedField, Calculation: Date( Month(Status(CurrentDate))-1, Day(Status(CurrentDate)), Year(Status(CurrentDate)))] New Record/Request Set Field [YourDateModifiedField, Calculation: Date( Month(Status(CurrentDate))-6, Day(Status(CurrentDate)), Year(Status(CurrentDate)))] Perform Find Make sure "restore find requests" is un-checked. Also see this topic regarding calculating with dates: http://www.fmforums.com/ubb/Forum15/HTML/000282.html [This message has been edited by BobWeaver (edited January 30, 2001).]

This whole container thing has me confused. I've followed the steps on pasting into a container field, but it never works. I see container fields in other programs but can never tell how to see what's in them. Can someone help me out here? Thanks much! Nati

I have the following scripts set up to generate numbers 1-15 automatically - (eg., XXXX-1, XXXX-2....XXXX-15) set field["gCounter", "gCounter=1"] loop duplicate record/request set field["gCounter", "gCounter+1"] set field["number of forms",'gCounter"] set field["agency and number", "numToText(AgencyID &- "-"&number of form"] Exit loop if {"gCounter=15"] End loop How should I change the script so that for first 1-15 numbers (gCounter), 1 to 9 will start with a leading 0 (ie, 01,02,03...09) and no leading 0 from 10-15? I'm quite new to FMP, so will need specific directions and scripts. Thanks!!

Two ways to go. First, in the Projects file you can create a portal based upon your Project No. relationship. This portal will show all the invoices belonging to that project. Another option is to create a script in the Projects file with the following steps. Go to Related Record (Invoice relationship, show only related records) Perform Script (external, "layout selection script in Invoices") The external script in Invoices needs to take you to the desired layout. The found set will be the invoice records related to the project record you were on when the script was run. -bd

I work with schedules a bunch. I have "Date_Due" & "Time_Due" fields as well as "End_Date" & "End_Time" fields. I would like to create a calculation that compares the end date & time with the due date & time and returns one of three responses: On Shedule, Completed On Time, Completed Late. I know there are plug ins that help with this, but I'd like to do this without them, if possible.

I need to add 3 months to the date in a date field. I've tried lots of things, but I can't get it to do it. Grant Fitz

I'm trying to start/close the FM database at specified time. I'd some ideas to do it, but I run into some problems that need to be resoved before I can proceed further. 1) I can use window task schedule to start a FM database with a default password specifaied in the application preference, but then all users will use the same default password to access the database, i.e. just like the database without a password at all. Is there a way to login FM with password to FM database provided in the command line i.e. "C:PROGRAM FILESCLARIS CORPFILEMAKER PRO 4.0FILEMAKER PRO.EXE" "%1" or enter the password automatically from the keyboard o…

I am having a prolbem with adding interstto my overdue accounts. I have an aging field and an orde total, but is there an easy way to automatically add interest to an invoie that is out 30 days and then keep updating the interst with each statement?

Hi! I am new member. I would like to know if anybody knows Flash and can help me to find a solution. I have got a FM database of about 1500 files. As Flash can read and display information provided in a txt file, I have converted all my FM files in txt one. I want know make a search engine in Flash. That way Flash sends the user input as variables and connects to a script which reply to Flash what is the corresponding txt file. I am sure what I am doing, but I am trying, does anybody can help me to find a script ? Thanks

Hi, I am building my first database and am having difficulty figuring out the sort script. I have a list layout that displays all records. The list shows three fields (first name, last name and company name). How do I create a script that will sort the list by each respective field? I can't seem to figure out how to correlate the sort script with the respective field. Thanks for any help.

Dear All I developed a database for a school athletics team about 6 months ago which they have put to great use and got a lot out of it. It is a relational database, with seperate files for Athlete Information, results, etc. The date of birth (DOB) of all 170 odd athletes is entered in the database in an appropriate field. What I need to be able to do, is make a script to take this DOB information and classify athletes into age groups as follows: Under 13, Under 14, U15, U16, U17 and Opens. Basically, I want to be able to specify a particular cut-off date (for exampe, 30th May) and have the script work out which age bracket each athlete fits into. I probably havn't…

This must be a classic Data Base problem. I have inherited 13,000 records of very useful data and have imported it into FMPro. The original data was transaction data and not meant to be information managed, so it lacks consistency with regard to the way names were entered. I want to search and sub total and sort by name so the name field is a stumbling block. One person may have 20 records and across those 20 records their name could be presented in 5 or 6 different ways. Eg. Fred Bloggs, then F Bloggs or F. Bloggs, Bloggs Fred, Fred & Jenny Bloggs, Fred A. Bloggs, FA & J Bloggs etc etc etc. Without re entering all 13,000 records (which I must admit I though…

I just inherited a tracking database with some reporting problems. I have a report that needs to display records with statuses of Pending, Due and Overdue but only returns the Pending status in the report. The script is set up as follows: Enter Find Mode[] Set Field ["Actual Status", ""==PENDING""] New Record/Request Set Field ["Actual Status", ""==DUE""] New Record/Request Set Field ["Actual Status", ""==OVERDUE""] and is set up to layout into repeating fields. If you go into the report layout and look at all records the info is displayed correctly but when you run the script only the PENDING dates show up on the report. I thought I had tried everything b…

I'd like to be able to have a filemaker script save a filemaker report as a PDF file then email it as an attachment. I'm new to this PDF / Adobe Acrobat thing so I'm a little confused. How should I expect Filemaker to save a report as a PDF file? Is that what a "PDF writer" is for? What is a PDF writer? If I have a PDF writer on my machine does that mean that this will be one of the driver options on FM's print dialog? Where do I get a PDF writer for windows 98? I only see PDF writers available for NT and 95 on the internet.

I have 2 databases (CustomerDB and JobDB) related to each other. In my CustomerDB, I have a Button that when clicked, I want it to bring the JobDB window to the front, find the related records and Sort (descendingly) by JobDate. (and of course, go to a particular layout too) The button I currently have brings the JobDB window to the front and manages to find the related records. But it does not do any sorting (that I can tell) and does not go to the correct layout. I have a script attached to the button. And the script just has 1 command to it - Go to Related Record [show, "JobDB"]. If I try to add a Sort command after it (in the scriptmaker window), it doesn't do wha…

I am trying to create a conditional button based on this script that it plays: If ["Status(Currentfoundcount) = 0"] copy[select, "chartno"] Enter find mode [] Paste[select, "chartno"] Perform find [] Else Show all records End If I can't seem to get it to see the Status(Currentfoundcount) argument. I want the button to act as a togle of just the Chartno related records or all records. Thanks

I have an one address field that sometimes contains more than one line. instead of wrapping it, there is a carriage return. for instance: Bailey Building and Loan 1234 Main St. The problem is, when we send out our newsletter, the company who mails it requires the address info be sent to them in an Excel file. Once i export this information, i loose the carriage return and everything is on one line, and often times that line is too long and some of the information does not show. Is there a script I can write to find a carriage return in the address field and cut and paste that second line into a newly created field called Address 2?

Is there a way to get an invoice into Word without a screen capture (on a PC)? Emailing invoices seems to be a growing request and I can't find any way to do this. Thanks, R

Help. My scripting is a little rusty. I have a text field that is only inhabited by 5-digit numbers. I want to write a script that looks at the first 2 characters in the field and fills in another field based on what they are. I thought I could use the "Left" Text function to return the first 2 characters in the number string. Doesn't seem to work though. Anyone suggest a method for doing this? I can post the body of the script thus far if you want to see the exact functions or syntax. Thanks in advance. Chris

I'm tempted to order the Famous Book Scriptology. I browsed on the web somewhat to find out what the comments of the users are (there is no way for me to see the book before ordering) I found different comments, ranging from Hallelujah-statements to overrated ****-book. But I can't tell the worth of these statements. Has any of you any experience with this book? Please tell me about it. I trust members of this BB more than any Nono from Neverland... ------------------ Yeti

I hope someone can give me an answer to a problem I am having. What I am trying to achieve is a serial number script. I have 4 fields (all global Numbers) 1 field is for leading zeros 1 field is a start number 1 field is a previous number and 1 field is a new number. I run the serial numbers from a script and they work fine on one computer but when I network the file the serial number will not update on the server but it will update on the computer it is being used on WHY?

I'm try to paste in the last empty repeating field, I want cut from a field and paste in the last repeating field, but I want a script how can I do it?? My field have a 30 repeating fields, and I cut from a 1 field. Please help me, it's very urgent!!!!

Have built a database of clients. For the sake of the exercise the DBase has 2 fields. A name field and an amount field. There are about 6 records for each name and my task is to write a script that firstly finds and groups all the records with matching names, then adds up the amounts in the corresponding amount fields for each client, placing them into a new sub total field. Finally I want to sort high to low based on the sub total field. The result is that whilst we receive various amounts from clients (single records) throughout the year, I will be able to group and get a complete total for each client, then see who pays us the most over the year. Can someon…

I notice on some solutions that the sizing fields/side bar hide and show buttons on the lower left of Filemaker are grayed out. How does one do that? I've looked hi and low in the manual but it eludes me! Thanks, R

Is there a way to setup a database to dial numbers on the phone and then speak text? I have a client that is looking to create a way to have a phone list and then enter a message and have everyone paged and then message relayed over the phone. I know there are script steps for dial phone and speak.

I have 352 entries in a FM file for a photo contest I ran in 2000, most of which will be entering again this year. I have been trying to figure out how to set up this years FM file so it can look up the information(address, phone, etc) from last year after I enter the name. I cloned last years file with no records and set up the desired relational fields but that doesn't seem to do what I want it to. Do I need to write a script to do that? Please help.

I'm designing an application that will be distributed to peole with different screen resolutions. I created a calc field with status(currentScreenHeight). I then created another calc field, using "IF", that returns a "0" value if height is 480 and a "1" value if height is not 480. Now I need to have a script that takes me to the form that I set up for 640x480 resolution when the calc field has a value of "1" and takes me to another form if the value is "0". Well... this is where I'm stuck. Any suggestions?

Is there any way at all to have FM create a folder or directory? For example. Lets say one of my fields has the value "DataFolder." Is there anyway to have FM create a folder titled "DataFolder" in some directory? Thanks in advance.

Hi: I'm a novice at scripting, but so far I've been able to solve most of my problems. Here is a problem, however, that I can't figure out. I have the following simple one-line script that works correctly in browse mode: Set Field ["Notes", "LastName"] When I change this script to the following, however, it fails: Enter Find Mode[] Set Field ["Notes", "LastName"] When I run this second script, FileMaker goes to Find Mode and the cursor is in the first field on the layout. It appears that the Set Field script step doesn't run. Does anyone know why this isn't working? When I created the second script, I received a confusing dialog box asking me whether I want to kee…

Help - is anyone able to point me in the right direction?? The following script is not working for me in FM, we recently added the last loop for new staff. The same script worked before the additions: Case(Request Number <= 99 and assign rep ="yes", Case(Mod(Request Number,12)=0,"Karen", Mod(Request Number,12)=1, "Lon", Mod(Request Number,12)=2, "Lon", Mod(Request Number,12)=3, "Romy", Mod(Request Number,12)=4, "Lon", Mod(Request Number,12)=5, "Lon", Mod(Request Number,12)=6, "Alexandra", Mod(Request Number,12)=7, "Lon", Mod(Request Number,12)=8, "Lon", Mod(Request Number,12)=9, "Ruth", Mod(Request Number,12)=10, "Lon", Mod(Request Number,12)…

Has anyone come up with a really robust way of preventing more than one user in a multi-user database from running a particular script at the same time? I have a few ideas based on having the script test and then enter a particular field in a separate file which would then lock out others, but was wondering if anyone has experience with this before I spend a lot of time and effort testing the idea.

hi I know how to export in pdf but my problem is that i don't know how to have a nice exportation. To be more self explanatory, i want that when i export multiple records when print after one another witout blank space between the fields and witout od course, scrapping some text between pages. i hope this explain well, what I need. thanks ------------------ Philippe Waterloos Webmaster

I have a portal containing 1 to 10 related records. I need to copy the information contained within this portal and append it to a text field in the current record. I've tried using the "go to portal row / next" and manually copy and paste the information. The first portal row copies and pastes just fine, but after the next portal row command, it doesn't work. I've tried referencing specific portal row numbers since there can only be a max of 10 related records in the portal, but no dice. I've tried referencing the related records in the external file but don't really know how to do that properly without switching to the other file, which would be bad for the GUI opera…

I am working on a script that will send to a large list of email addresses and I want to mask the addresses from recipients. When sending email from Eudora Pro, I just enter all addresses in the Bcc field. However, the Filemaker Pro script function doesn't seem to allow me to automatically send a list of addresses to Eudora Pro's Bcc field. Does anyone know of any fairly basic work arounds to this? Thanks, Todd Shays

Hi, I'm a FMP for Mac 4.0 user. I've been trying for the longest time to figure out how to set up my database to search all fields for a text string I input and return all records that have a match. I've tried both scripting and the use of a relationship/portal, and I'm just not getting anywhere. I would guess that this is a fairly routine type of exercise for someone a little more familiar with the application. Can someone tell me if scripting is the way to approach this problem? or is setting up some kind of relational DB / portal the way to go? Perhaps some combination of the two? I would be most appreciative of any advice. Thanks

Hi - I am brand new to this forum. I have been scripting off and on for a few years with FM and have just moved to FM 5.0. I have a script where I am looping through a set of portal rows "x" number of times. The first time through the loop, the script advances through the portal rows correctly, however, on any subsequent loops, the script skips the last portal row and double copies the first portal row. I have a counter set up to equal the number of rows in the portal and have breaks in the loop to ensure that the counter is advanced correctly. Any ideas? Thanks a bunch Danny Gillespie

is there any way to have a field that will display todays date.. actually i just want it to display the month.. for example in january i would want the field to say 1, in february it would say 2. i assume this would have to be some sort of calculation field because it would change every month...

I have a repeating field in which I want to store a list of randomly selected values from another repeating field. I have the random calculation sussed but when I try to put the GetRepetition calulation in any repetition other than 1 it does not appear?! script step is: Set Field ["repeatingField1" -2, "GetRepetition(repeatingField2;(random calc)"]

I have a report that I inherited to group employee birthdays by month. The subsummary section of the report uses the birth month (calculated from the date of birth) as the "sort by" criterion. The name of the month is supposed to be displayed, followed by the list of people with birthdays in that month and the actual date to be celebrated. Problem is that the subsummary never shows up. Nor does the report make any attempt to order by birthday. I have to sort the list by birth month in order to get it to sort, but the headings never show. I don't know what I'm missing.

I've been playing around with using Winfax to send reports to fax machines using FMP 4.1. So far it works great if I want to send just one report at a time - click a button and BOOM - a report shows up in the customer's fax tray. What I'd like to do though is have this be more automated. When FMP launches Winfax, you have to interface with winfax manually before anything is actually sent (i.e. you must select a fax number, etc.) It seems that the only way around this is to have FMP send a DDE command to Winfax. Am I barking up the right tree here? Can I have FMP have Winfax send a report to fax machine without having to manually interface with Winfax. I've never done DDE …

ok chuck let me give you more info i have 2 records i am dealing with at this moment in file #1i will insert data from 1st record into a column in the 2nd file then i will go to 2nd record in file #1 and i want it to see there is data in 1st column in file #2 and insert data into 2nd column etc.upto 10 times if needed I hope that helps Dean [This message has been edited by MDPRES (edited December 28, 2000).] Chuck heres what my script looks like now. When I run it the 1st time it works fine, the 2nd time around when I click the button it replaces the data that is already in the 1st field of the 2nd file it is ignoring the else steps.Am I not understanding th…

I am definitely stumped with a problem using the SetField command. I am trying to use it to "push" the data in a text field from the Master File to a text field in the Related file. The command works when there are no records in the Related file (as discussed in the Scriptology book), but does not work when there are records in the Related file. The Related file has a script that simply creates a new record. The script in the Master file has two commands, first it performs the external script in the Related file to create a new record, then it executes the SetField command. I'm sure I've specified the options for the SetField command correctly. The result however is a new…

I am making a form for my email users. Now i have made an calculation field in wich I achieve that iff I make a new user, the name of the user will be implemented in the email field. For example, new users name is John Smith his email adress will be [email protected]. This is done by the calculation Left( Voornaam, 1 ) &"." &RightWords(Achternaam , 1 ) &"@" &InternetDomein But nuw I also have edresses for departments. For example the department prepress the email adres will be [email protected] Now I want to complete the calculation that if the user is prepress the email will be as above. How do I make this calculation in this field?

Can you give us some more information? While I can think of a number of ways to do what you need, my first thought is to wonder why you would need to do that. It may be that there is an easier way to get your job done. Why does Tutee need this information? Chuck

I had tried that already and it didn't appear to work but then I tried it again and everything is honkydorry. Question: If export destinations are determined by last destination that was actually used, then why on Earth does the script editor allow you to specify destinations for the export command? Did Filemaker just make a big design booboo here?