Script Workspace and Script Triggers

Are the fields you are pasting into on the layout that you are on when you are trying to paste? If not, then the paste won't work. I tend to avoid copy and paste unless what I'm trying to do isn't possible in any other way, or the other way would take far longer and be far more complicated (so I sometimes use Copy All Records to get all of the IDs for a found set, for instance). Part of the reason for this is that I don't want to eliminate anything the user may have in the clipboard (this is the dominant reason), but the other reason is that you must have the field on the layout to use these steps. Set Field doesn't have this limitation. You can use Set Field to alte…

You can't change the way the menu items work. You can, however, setup a password level for the user which does not allow deletion of records (a script still can). -bd

I have written a script that will find a certain set of records in another db based on a certain job number. Is there a way to find a set of records based on which password is used. Basically, how do I tell FM to use the password used to login to the file in a script?

I'm trying to do a search on a date range, but it needs to be flexible. I have a list of end dates, and each week I would like to be able to run a script that returns projects that are due to end in the next week. I wouldn't have thought it would be too dificult, but I just CANNOT make it happen, with a find or script or anything! Help! Thanks Sam

I know that a FM File can only be a certain size (though i can't remember what that size is. . .), i was wondering how much a script can effect the size of a file... Obviously small ones don't effect much, but if i have a long complicated script that can't be split b/c it's a bunch of If / Else's, how is that going to play on the size. . . What about a whole heck of a lot of small scripts. . . I am just looking into the future of the current project i'm working on so i can't get as specific as i would like. . . any input would be helpful. . . Jeremy

Hi, I would like to copy a field to another field. Field1 is a text type, and I want to copy "01-124" by using setfield[field2,field1]. My result in field2 is "1124". How do I prevent this. I want the exact format. Thanks.

I'm wondering why the clear function only clears the fields displayed in the current layout. I want to clear all fields but only the fields displayed in layout 1 is cleared and not in layout 2, although in my script, I wrote clear [field1]....clear [fieldn] for all my fields. Any thoughts? Is this normal? Should I use cut, or select field, ""?

Hello everyone, Is there any way FM function that looks at the Creation of a record vs Modification? I want to specify, that if the record is created for the first time, then let it be created without an alert. However, if afterwards it's edited, then bring on an alert. In my script I specify Status(CurrentRecordModificationCount)>0, but the alert sometimes pops up when the record is first created anyway. Did anyone ever have this problem? Thanks a bunch for any thoughts.

I've got a script which should open a related database; the windows are positioned so that both databases are visible to the user. However, when the script ends, the second database gets hidden. How do I make sure both databases are visible?

Hi, I am fairly new to Filemaker (5.5) so would appreciate a bit of help. I am trying to turn a flatfile contact db into a relational one. My problem is as follows: I have a master file/record (Record # and Account Name, primary address, phone etc.). Within each record I then have multiple contact details. However these contacts may not be located at the primary address. In some instances there can be up to 15 "sub-" offices and I want to be able to enter a contact name (on a contact layout) and show the specific address they're located at as a field underneath each one. The logic I'm following is to create a child database with these 15 sub-addresses (Record # and Cus…

Hi all, How do I specify a calculated field as Unique Primary Key? Is there a formula or a function? To acomplish this, I wrote an embarassingly long script, that: 1. Sets a global field to equal my key field 2. Goes to next record, compares the key field with previous global field 3. If they're equal puts 0 in Unique column, and if they're not puts 1. The problem is, this does not work, if the key field is not unique, but not sequential either. There has to be a simple way to do this, but I don't know how. Please, help. Thanks [ June 21, 2001: Message edited by: BikeBoy ]

I hope someone on the Forum has some experience with the DDE Execute scriptstep. I am trying to get Filemaker to 'make a phonecall' through 'Call Centre Assistant' which is an Ericsson application running on all FileMaker clients - - - - - - The following information comes with the Ericsson documentation: Command: MakeCall (Other applications can issue a MakeCall command toward CCA to initiate a call on the telephone. Note that no error checking is provided, i.e., it is assumed that the device is in a state where a call can be initiated.) Server Name CCA20 Command : MakeCall Command Type: DDE Execute Return Type : True/False Topic : CallControl Paramete…

In a record I have a text field called "Name" that I want to copy it's entry and do a find by using a script. I can't seem to figure out if this is do-able. Any help is appreciated. Dave

Fellow FMers, I want to write a script, which would be activated when I tab into the field. For example, if I type a duplicate value, and then attempt to continue the record, the warning message will show. I can do this with a transparent button, but this takes care of “clicking” into the field, but does nothing for “tabbing”. I tried "If(Status(CurrentFieldName)= "Fieldname", but that didn't work. Any suggestions or recommendations are greatly appreciated. Thanks in advance.

I am trying to write a script that will get a job number in one db and find info about that job in another db. Basically, I find the job in question, copy the job number in the number field, activate the other db, go into find mode, paste the copied job number from the original db into the job field in this db and then perform the find. The script works when I run it as a standalone Applescript, but when I embed the script into a script I made in FileMaker in the orignal db it stops working as soon as my other file is activated. Any help out there?

I have a script in my db that searches on a name field and then sorts on a calculated field (NAME & COUNTER). After I do the find and get the records I want displayed, I need to go to the last record in the find and use data in it to create a new record. When I use the Go To Record/Last function it goes to the last record in then database and not the last record in the find. For example, I have 5 records in the db and they were entered in the following order JIM 001, JIM 002, JOHN 001, JOHN 002, JIM 003. When I search for John I get 2 records for John. The Go To Record/Last command in the script moves to the JIM 003 record. I need to duplicate the JOHN 002 record for …

Is it possible to activate a script in a calculation field? ie: If(enduser = Gregg, run script "email") That was just an example... I hope you all can understand what I'm trying to accomplish. Thank You!!

I am trying to get FM to draw line graphs but have been unsuccessful I have tried ChartmakerPro but its very complicated to use and the graphs don't look that great I have used easy FM tricks to make bar graphs (I know there are also pie graph tricks)...are there any simple tricks to make line graphs in FM??? THANKS

I can't seem to get the if statement to work for the Status (CurrentMessageChoice). I have created a message with the two responses OK and Cancel. I am using the following if statment: If ("Status(CurrentMessageChoice = "1")") I have also tried If ("Status(CurrentMessageChoice = "true")") I can't seem if satisfy the IF statement. Help.

I am using Filemaker version 5.03 on a windows 2000 Pentium 3 350MHZ with 192 of RAM. On my solution I have a really large calculation on a calculation field that I want to add some more formulas, however every single time I try to do that filemaker crashes. I already tried splitting up the formula into separate calculation fields but it is still crashing. I also tried doing the same thing on my windows 98 installation but it crashes anyway. ANY HELP OUT THERE PLEASE!!!

Is there a way to make sure that the sort script works as set up when the script was created even if the files have been emailed to another machine? I need to frequently email an updated version of a set of 7 related FM5.0 files to a client (from my Mac to his PC). All script steps function fine except those that work on a 'restore' system. The most imporant in my case is the 'sort' script step, which is unfortunately used in all 7 files. Therefore once the files have been emailed to the client, calculations don't work properly because the sort doesn't work as it was set up. Any ideas how to work around this problem would be very much appreciated. Gabriela

I just bought FMpro and I can't figure out how to write scripts. I need a button that can make a list when pressed. The button is on it's own layer like a title page, and there are 2 files(main & home). When I press it, it should find data with similar information from the home file and create a specific list in a main file. I related the fields and used the "Insert from Index" script to try and take the fields from the home and create the list with the fields i need in the main. But it's not listing anything. Is there somewhere to get help with scripting or can someone help me? Thanks.

Hi there, I have tons of fields in tons of different databases that need scripted protection. As of now, I have sapatate script for each field, but the scripts are almost identical. However, because in each of my scripts I need to go to different field, I need sapareate script for each field. Is there a way in FM to "bind" a button to the field, so that when it performs the script, it automatically is performed on the field that this button is on? Thanks

I am trying to write a script to do a keyword search in constantly changing layouts. Is there a way to tell file maker automatically "Yes," accept the current entry (ie - non number in a number field)?

I need to add an auto number for each existing record in an existing database, (for some reason it doesn't have any identifying ID #) to deal with exporting. I need some kind of script to add a unique number to each existing record. I know how to do this for all new records, but this doesn't help me. Do you know a simple script (perhaps with a loop) to do this? Thanks.

My problem is that i am working on a schoolproject with filemaker, and we have to find out the differnece between id and Recid in a link. Exampel. http://...FMPro?-db=first.fp5&-lay=first&-Format=first.htm&-Recid=45&Find and http://...FMPro?-db=first.fp5-lay=first&-Format=first.htm&id=126&-Find In this exampel, the links are same except for id and Recid. Can enyone help me with my problem? What is the difference? Regards Chrisse

Check out the FAQ section of this web site. I wrote one for this a last week. Chuck [ June 18, 2001: Message edited by: Chuck ]

Help, I would like user to create/delete records. How do I prevent them deleting the first one? Is there something with Status(currentrecord)

I have 6 different groups using 7 different databases. Each group has a unique layout for data entry in each of the 7 DB's. I could write a button small script to go to each layout, but that would be 42 scripts, and seems kinda clunky . Is it possible to write a more advanced script that cycles through a set of if/thens, that check what the current layout is when the script is activated? For instance, if in "Transgenosis Group Layout for AAT data" then open/goto "Transgenosis AAT data entry layout"? Does this sound like a good plan?

Got a problem. I need to be able to perform statistical calculations (Min, Max, and Average) on data that appears in summary fields. This doesn’t appear to be possible in FM. It appears I’ll have to write a script that does these computations from scratch by examining the record data that supports the summary fields - yuck, and I do mean YUCK. I can give more detailed information here if need be, but I’d like to get your general comments on this first.

Is there a way to run a FM script from the command line on Windows? I'd like to write a Perl script to assist with batch importing, and I can execute a DOS command line from Perl. If this were on a Mac, I'd use Applescript. Is there anything I can do?

I've built a nice a system for a potential client. They won't know whether or not they want to buy it, of course, until they've had a chance to use it and put it through its paces. Therefore, in order to protect myself, I need to provide them with a trial version of this system that will expire after a certain amount of use. I can think of about 100 different ways to set this up, but I'd like some input on what the best (and easiest) approach is. Should I base it on ellapsed time? This seems rather complicated and seems vulnerable also. Users can just set their system clocks and dates to anything they want and bypass the ellapsed time logic. Is there a way to prevent thi…

Hello, I have encountered a very weird effect using Send mail function in a script (FMP5.03. French edition). If I create a script using Send mail (and only this function!) it will change values in other fields (rounding numbers!). Has anyone been expiriencing the problem? Has anyone have a solution? Thanks Michael

Here is what I would like to do: I have an existing record, and I want make a duplicate of it. But I want the duplicate to add a serial number to a particular field when I click the "Duplicate" button. Let's say the original record contains a control number "AAA123_001". When I click the "Duplicate" button I would like for the control number field in the new record to display "ABC123_002" and so on, everytime I make a duplicate of that record (003,004,005, etc.). Can I do this?

I need to perform a scripted find on a set of records that limits the results to only the current day's date. My theatre reservation database has two operations: A "reserve seats" part which allows the operator to mark seats as they are phoned in; and a "will call" section which allows the operator to mark the seats as occupied on the night of the performance. The first section allows for reservations to be made for any of the performances that weekend. The second section is used as patrons come to pick up their tickets on the night of the performance. I need to be able to find a patron's reservation by their last name, but I don't want to see records from any other …

Hello: How can I make a script run if and only if a certain field has been modifiedi in a particular record? Thanks for your help!

I've got a script which opens a QuickTime movie and two FM databases (all related to the one with the script) and want to make sure the windows are positioned correctly (to fill the entire screen and idiot-proof the process). I also need to hide the page which is executing the script at the end of the script, because it always wants to be on top (sending it to the back would work, too). I know I'll probably have to position the QT movie via AppleScript, but is there a FileMaker command to position the FileMaker windows, and to hide the other FM window?

I can successfully send email to a single user but I can not get the to successfully create new emails in Eudora when I choose the "use found set" option. Any suggestions?

HI, I'm pulling up a number of records each with a unique number by going into find mode, then selecting new request, then entering another number, then slectting new request, etc. . . Is it possible to sort by the order in which I performed the find? The field I'm using is a number field Thanks, Danny

Hi, I am looking for some guidance in building a script that will auto generate a date and comments field. I want the user to be able to enter a date and comment, click a button that says add another comment, and have a new empty date and comment field appear. If anyone can point me to some examples of this I would be much obliged. Thanks for your help! Rosie

We are tryin to move FMP data of from specific fields in one specific record of one specific database to another FMP database. Our goal is to this all using a button. In more simple terms, create a "Add to Cart" button to each product item on a "product catalog" page DB that will send selected products (and catalog specifics including their price group "per 100" versus "per 500") to a "purchase summary" page. Some of the issues we have to deal with include multiple product DB since we have so many price breakdown groups. Nils

I would like to create a script using the "If" Function to search for commas within specified fields. For example if a field contains the value "5510" then I would like to add a comma to the end of the field. If there is already a comma present,(ex. "5510,"), then no comma would be added. My problem is that I don't know how to define the if statement to search the whole field for commas. When I use: If(MyField = ",")...etc. it will only register that there is a comma present if it is the only value within the field, if there are numbers preceding the comma, it doesn't work. Can anyone help me with this? Thank you in advance!

Hello, Does somebody know how to let scriptmaker make an enter/backspace in an active field? I just can't get it right. My mac is making to much hours to get it done thanx already! Jeffrey

Does anyone know if you can have FM Pro 5.0's "send mail" function send out an email automatically anytime a new record is created in a database? I keep looking in the books and can't seem to find a way to do this on the fly. Any help here would be appreciated!

Hi Forum, How can I match the content of a field in multiple records verified by a calculation; so the user gets a message when he/she tabs out of a another field. I've tried the count-function, but can't make work the way I think it should work. Thanks in advance, Bert.

I have 2 problems: I would like to have a preview of how my form looks like before it gets saved as an actual record. (In case I change my mind) What is the best way for this? If I just create new record and then just delete the record, I used an unecessary docket #. Then the next one increments after the deleted on. Example: ID 1, ID 2, delete ID 2, ID 3 =>result ID1, ID3. where is ID2? Thanks in advance!

Help. I have some company names in my contacts d/b. For each company name, I have multiple projects. I have a projects d/b that has all projects for all companies. In the contacts database, I would like to add all project names pertaining to that company. In the project database, I have a field called project::client that can somehow be matched to contacts::companyname Example: (contacts d/: companyname: XYZ projects: constructionproject, realestateproject, engineeringproject (projects d/: projectname: constructionproject client: XYZ projectname: realestateproject client: XYZ projectname: engineeringproject client: XYZ How do I do this?

I have a script that I need to fire about once every six hours. I tried just writing a simple loop and a counter, so I'd have to reset it every couple days as a test. Wasn't tickled about tying up the computer, but seemed a simple fix. However, the script only fires once. Is there a better way to automate a script function? Seems silly to have to purchase a plug-in for such a anticipated task. I'm running FM Server on a Win NT machine. Any help would be greatly appreciated. My backups and notifications are running great, just tied up on this one issue.

Hi, Dumb question for ya smart guys---- I want to define new text field(s) into an already made lots of records database and then "force" text entry into those fields---- I have successfully "forced" text entry into fields using the old IF/Then and Case deal----where I go and look for certain info in another field and then based on that info force "new" stuff into the "new" text fields--- This all seems really cumbersome ...and I KNOW there is a very easy way to do this---but it is baffling me ----- like just say put this text into all of these blank fields in all of the following records ---hmmmm

Don't know if it's possible to select a script from a pop-up field or if there is a better way to do this. Here is what I want to do: I'd like the user to be able to click a "run report" button that gives him a pop-up list of the various FIND scripts (e.g., Find Q1 records, Find Q2, etc.) and then allows him to choose the report he wants for that period out of a list of possible reports that have already been scripted. So, he would click the Run Report button and he would get a message that says "choose Find critera" and there would be a list of those scripts: Q1 records Q2 records Q3 records Q4 records 1st Half 2nd Half Fiscal Year Then once he has decid…

Hello everyone, I have been puzzling over this one for several weeks now, and haven't come up with a combination of script events that will make this work. What I am trying to do is find records in a database based on 2 possible entries into the same text field and a pushbutton toggled on.(out of many pushbuttons). I have no trouble at all setting up a multiple find on the same text field using new record/request, but as soon as I try to do the 3rd step of the find on the pushbutton, results become unpredictable. Either I will get results with records that did not have the pushbutton toggled, or I will get results with records that do not match the 2 possible entries in…

I'm trying to put together a program that will reserve a particular theater seat when you click on a picture of a chair. Is there a calculation to return just the field name (as text) you are clicking on? For example, the layout includes a field named A01, which represents the 1st seat in row A. What I'd like to do is click on A01 (using the field as a button to start a script) and have "A01" appear in a repeating field called "reserved seats." It's a bit more complicated that I have described, but I've got most of the rest of it worked out. I can't find anything about this, though...thanks!

The DB I'm making is intended to be updated through the web page. Is it possible to make the filemaker mail every new entry to a certain e-mail address along with submitting it into the DB? Also, on the page I've created I had to rotate some of the words 90 degrees. However, when I open this page via the network, these words return to their original horizontal positioning, messing up the layout. Do you know what might cause that? Thanks a lot, Luka

Is there a way to close a multifile FMP solution if it has not been in use a specified number of minutes? Is there a way to take a user to the log-in layout of a multifile FMP solution if it has not been in use a specified number of minutes? [ June 02, 2001: Message edited by: GregFM ]

I need to find if files can be shared between Filemaker pro and MS Project. Filemaker currently has the Database info on it, but I need to start running schedules and projects using MS Project. Ihave had this hint below, but don't know much about the two Applications...can anybody help? TIP I RECEIVED. Should be - Does MS Project export tab delimited data? Cuz if it does then you just need to have Filemaker look at the file MS Project exports to. Maybe you have to write a little script and/or set up the correct relationship in Filemaker but it should be do-able. QUESTION I ASKED... Is it possible to link MS Project and Filemaker Pro. If I created a schedule in M…

I need a script where the user Enters the Find Mode, goes to a field called MONTH and it pauses, allowing the user to select the month from the pop-up menu for the records that he wants in his report. He will do this for up to 2 different months and then the report will continue. I am using the "new record request" for the multiple find but I'm doing something wrong because when I run the script and select MAY and JUNE, only records for MAY come up. I've tried various combinations and now I don't even know what I've done--but regardless, just May records comes up every time, and there ARE June records. Can anyone out there give me the steps in the proper order? Thank…

Is there a way to track edits & the user doing the editing keeping memory use to a minimum? I have layouts with multiple fields for all kinds of demographic data for each client. Should a user edit any of these fields, I would like to keep track of these changes. I've thought about a comand to duplicate the record just before the edit and making the new copy the active copy but this saves editted and uneditted info. Also considered: making each field a button that enters that field zas well as copying its data to a global field that corresponds to the selected field, and when the "editing done" button is clicked, copies the the values in the global fields into a fi…

I moved a database which uses the 'send mail' command within a script to email clients. This worked fine under Windows 98 (rev 2) but has stopped completely when I moved to a Windows 2000 Professional machine. I used the 'on error' command to see what the problem was but FM doesn't report any error - it appears sinply to ignore the command completely. I'm using FM Pro 4.0 - all help most welcomed.

I need to print different layouts based upon a fields content... IE: (field=green) print "Green" layout, (field=blue) print "Blue" layout...etc. I tried using different "If/Then" statements, but I seem to be missing something. It keeps all records in 1 view!?!??!?! CAN YOU PLEASE HELP ME! I'm having a hell of a time trying to figure this out! [ May 25, 2001: Message edited by: Addam ]

Dear FM Experts, Sadly someone has given me this job to do in FM5 and I need a little help. What I need to do is (in SQL terms) Insert into INVOICE_LINES(X,Y,Z) as SELECT X,Y,Z from CALCULATIONS where BILL_ID = :BILL_ID In other words, for each row in CALCULATIONS that has a BILL_ID equal to a known value, I want to create a matching row in INVOICE_LINES with the same field values. Can anyone point me in the right direction ? Many thanks, Peter

In my aplication I need print in a two diferent printers... how can I fix one printer in one layout and other in a diferent layout? I try in a script "Print Setup - Restore - No dialog" but work if i have only one printer... I need apply speed to the aplication and less work for the user.. Thank`s for all answers

I've got a whole bunch of records that I need to duplicate and change part of one filed when that happens. I can write the script to duplicate records, get the loop thing going correctly but have a problem when it comes to changing data in PART of a field. The Field's current data is 4200-V-NN-TT(where NN and TT are different numbers in each record), and I want to chance it to 8900-V-NN-TT(where NN and TT are the same from the orginal record) Any help would be GREATLY appreciated.... [ May 30, 2001: Message edited by: Jeffrey T. ]

I can't seem to get copy and/or paste to work via a script. (FMP 5.5) I have 2 global fields, one text the other a number. I wish to copy the info from each (one at a time) and paste the data into another set of global fields, one text and one a number resectively. I have select entire contents active for both copying and pasting. However, it doesn't work. This seems as if it should be simple, but I'm stumped. I have the correct files and fields identified. Help, please. Thanks. [ May 30, 2001: Message edited by: shorton ]

Can some one please explain what a relookup is looking up and replacing? I have taken over an old script and am trying to figure out what he was trying to do. For an import script, he did a show all and delete all records. Then he imports some records and goes to a layout. Fine so far. Then he does a Relookup on one of the fields. Why? It is an access number common to all the files but he hasn't accessed any of them. Shouldn't there be a lookup first? Then he goes through a series of perform scripts, all of which I understand, does a sort, goes to another layout and prints the report. Then he does another perform script which goes to yet another layout, shows all records …

Hello. I would be grateful if someone could please help me.... I have a database called "Users.fp5" and in ScriptMaker I have a script called "TimeIn", which only works for the current record. How do I use ScriptMaker to repeat that script for all the records in my database? Is there some way of saying "perform script for all records"? Thank you for all your help!

Can some one please explain what a relookup is looking up and replacing? I have taken over an old script and am trying to figure out what he was trying to do. For an import script, he did a show all and delete all records. Then he imports some records and goes to a layout. Fine so far. Then he does a Relookup on one of the fields. Why? It is an access number common to all the files but he hasn't accessed any of them. Shouldn't there be a lookup first? Then he goes through a series of perform scripts, all of which I understand, does a sort, goes to another layout and prints the report. Then he does another perform script which goes to yet another layout, shows all records …

I have a very simple file that has proven incredibly effective for me and I would like to automate a search for time conflicts in it to make it even better. Let me explain. My file has a few basic fields - date, start time, end time, who, what and where. I would like to create a script so that I can be alerted of any possible timing conflicts or overlaps since the best part of this file is that entries can be made out of sequence and sorted later, the down side being a manual search for possible conflicts. Obviously, this would involve comparing the date, start and end times, and who fields. Any ideas? Thanks...

Hi, I'm trying to implement an unlimited depth directory-tree structure in FM, and faced a pretty annoying problem: Directory structure is defined as: id - number parent_id - number dir_name - text there is also a relationship which links current directory with its parent directory: parent_id->id and a calculation field targeted to recursively construct full path: fullPath = id_to_parent_id_rel::fullPath & "/" & dir_name As a result I expect to get full path to a directory tree's "leaf", in the form of: "/Level1/Level2/Level3/..." logically, there shouldn't be any loops (of course, if dir structure is intact), but FileMaker tells me that this is a…

Using OSX with FM 5.5's container field, I need to do the following. I have two files, one is "orders", and the other is "products". I have all the products that I sell listed in "products" and would like to place a product brochure (pdf file) in the container field. Some brochures are a single page, most are two or more pages. I would use this mostly as a pointer to the actual file located somewhere else. I use the "orders" file to generate a proposal and then follow the project thru to completetion. Most proposals include several products. I do a presentation via my powerbook and video projector, and then burn a cdrom with a hard copy of the proposal to leave with the c…

Strongly recommend putting the FileMaker databases on a dedicated machine with FMServer. This will speed up your access considerably. The dedicated machine should have lots of ram. The machine I'm using currently has 512mb. If cost is an issue, you can put FileMaker Pro and the database files on a dedicated machine with as much ram as you can afford. We ran our db's this way at a previous company I worked at. It's not as fast as FMServer, but it is definitely faster than hosting the files from your own computer.

I need to back-up my database from a host computer to the server, on a daily basis, and I'd like to automate this. I'd also like the script to add a unique number to the back-up copy's name. I know how to "Save a copy as", but not how to activate it at a certain time each day...advice much appreciated!

Is there any way that i can get a script to recognize the location of the file in a container as a string and put it into a field? and also to do the opposite? i have hundreds of video files labeled sequentially, and i would like to be able to make a script that can duplicate a record and automatically switch the move that is there. I found some help on filemaker.com but it was for 2.0 and 3.0, and i am now on 5.5

I would like to use a script to open and view another filemaker database from the one I currently have open. I have been able to run external scripts, but I would like to actually view the selected database.

Is there a way to write a script to limit the amount of text that can be entered into a text field. Right now it will allow you to type beyond the area alotted for the entry (keeps adding lines) but will not print this info>

I have a db that I would like certain activities to be audited and leave a trail. For example, if a student prints a form, or whoever edits a file, should have a field(?) that their username is put in. This field keeps track of the last 10 names, so that if I am asked who edited the record and in what order, there is a trail. Is there a script that someone can recommend? I've not had much luck creating one myself. Thanks!

Hi, I am fairly new to filemaker and to database development in general. My question is: I want to create a keyword search script in my database that allows me to match to any word or term in the field. As it is right now (or my current understanding of filemaker) a find function call will match to ALL words or terms in the field. Can anybody give me advice (i.e., sample code) on creating a search script? I want it to act similarly to the search function on this forum, that is to give users the option to search based on "all" or "any" term placed in the field. thanks, Alan

Greetings. I have a simple database which requires people to be contacted regularly for follow up. I do this by entering a follow up date. I want FM to do an automatic search when I open the file of all followups due for that day and the next week. I'm not sure whether to go by a calculation field, but suspect that I should (and have tried) to write an opening script to do the search but am not sure how to put it together. Can someone help? Thanks.

Sorry, this is not a scripting question, but I need some advice. I want to create a floating navigation menu (ie. a separate file that will sit outside my other file windows). I have seen this done before. My problem is that I can't get my window as small as have seen others do it. When I scale the window, it just seems to go to a minimum distance in the width of about 3 inches (7.5cm), yet I can scale it as small as I like on the height. Any ideas on how to get the width of the display window smaller? [ May 22, 2001: Message edited by: DubiousAlibi ]

I have two files - one for players and the other for history (stats etc). I want to create a new record in the History when a new player is created in the player file. I'm not using a portal and don't want to. All I want is to copy the new name and the player ID into the History file. Should be easy but I can't manage it. I thought I could just copy it to the clipboard and it would paste in. Any ideas ?

Silly old me has just spent the last 4 hrs making some major changes to a DB and I decided to import in a startup script from another DB. The DB had it's resume/pause option changed to Indefineatly, now I can't get into my DB. How can I break into this DB?? ...and No I don't have a recent backup. (oops)

I have a cross platform database that requires me to be able to allow users to close all of the open files without exiting the application. This works just fine. However, on the Windows platorm is there a way to add code to the script so that after the open FMP files are closed the FMP application then minimizes? On the Mac platform this is not an issue for with no open files, the application is no longer visible to the user anyway despite that it is still running. In Windows, however, once all files are closed users are left with a blank maximized FMP window that many confused novice users then exit, defeating the purpose of my "close files only" option in the script. …

Is there a way to get a script to create a record in an unrelated file? For example, pressing a button in layout #1 of File A and having an assigned script create a record in File C, which has no relationship to File A.

Is it possible to display dynamic content in the messagebox? Such as seom field values of a record? For now I can only show text with it, this is not enough Thanks for any help in advance!

A script that exports all records, does not inclde every field. Why is this? The script finds all, then exports and saves to a file but only the first four records are in the text file. The file is saved as tab-delimeted text file, from version 4.1. Thanks Rich

I'm having a problem with data disappearing and I can only think it has something to do with a simple script. I have 2 layouts in a single, non relationship, database that has 96 records. One layout is for teachers at my school to input test scores, the other is for printing the scores. The data entry layout has color and directions for them, the printing layout is bw and has a header- the teachers never view this layout. On the data entry layout I have 2 buttons. One is simply a "find a student" button so the teachers don't have to go manually go to find mode to find their student's record. The other button is the one that I think might be causing the problem. It …

Forgive my ignorance - I am new to Filemaker . Planning to create a DB that emails a moderator with any new records before they are publically searchable in the database. Does this sound do-able and would it be best to use applescript or lasso etc?

I've got one layout (out of 150+) that has all of a sudden duplicated itself 5 times. By this I mean that it has replicated itself 5 times only in Browse mode. If I look at the layout in Layout mode, it appears to be normal i.e. there is only one of it. If I go into Browse mode, I can scroll down the screen with the layout being repeated 4 more times. The layout only has a Body part and no other. If I duplicate the layout, the problem goes with the new layout. However, if I copy the layout's contents to a new layout, the problem disappears. But then all of the scripts and GoTo Layout commands are undefined when I delete the bad layout and replace it with the good…

Hi is there a way to play a wav file when a button is clicked?? THANKS

Hi there~ I am using FMP5 with PaperPort4.0 I want to create a field that contain the path of some paperport data so that when user click the view button, PaperPort will run. However, the file of paperport4 has many different extensions such as .03f,.047,.02d,.......crazy! Can i write a script so that FMP5 must open the file in the path field by paperportviewer.exe?

I want to use Filemaker to send out an e-mail using Eudora. I have figured out how to put in the To and Subject lines. Problem is I want to personalize the body of the e-mail I send out to each user, I want to pull info (username, state, and other info) from fields in the database to the body of each e-mail which is sent out. I can type the body of the e-mail in the script step box but I am not sure how to customize. I have tried Dear <<Username>>, which is the name of my particular field. I have also tried quotes around the user name, and about everything else you can think of. Then I thought it might be better to create a new layout with the letter the…

Hi, I am trying to restrict my database to only allow for no entry to be duplicated. Either by name or street address preferably both. thanks for any help

I haven't used Filemaker in a while and I'm rusty but running up against a deadline. This may be a basic question but I haven't been able to find the answer in references yet. I have a database (similar to a survey) with about 100 fields, each of which has a value list with 3 possible values. How can I get a summary or sub-summary that shows me how how many value1, value2 and value3 responses I have for each of the fields? Counting the fields isn't enough; I need to count the values within the field. Thanks so much. M.S. Jackson

Hey, I have created a find page with one of the fields being a date field. Now, whenever someone wants to find a record, they will be sent to this page whereby they can specify the date, name etc... now, what happens is that is a person wants to search for a range of dates, he will have to go to the date field and type MM/DD/YY...MM/DD/YY... My next step now is to create 2 more date fields(DateFrom and DateTo). So when a person is going to search for a range of dates, he will just have to key in the 2 dates(from and to) into the respective fields and then click on the Search button to extract the range of dates. Hopefully this is clear enough to explain my problems…

I have a field called "Name" which contains, as you might imagine, names. It unfortunately holds both first and last names, all of varying character lengths and separated by a space. I am trying to write a script that will separate them into two fields, "Firstname" and "Lastname", and remove the space. I anticipate using the "Set Field" script step but don't know how to go about writing the calculation. Does anyone have some advise on this?

I want to make a new record script that is attached to a button but I don't want any users to be able to click new record on the toolbar. Is there a way to do that?

Every day I need to import records from a primary dbase1 into 8 other db's, depending on the record type. I know I can perform a FIND in dbase1, and then open the targeted dbase and perform the IMPORT, but its tedious to do this eight times, and I'm a bit lazy . I know I can write a script to perform the eight FINDS in dbase1, but is it possible to include in that script, a comand that: 1) Opens up the target dbase 2) Commands that target dbase to import the records 3) closes that dbase, and moves on to the next FIND and target dbase Then I could perform all 8 imports with one button click. Or am I going about this all wrong? Any ideas are welcome!

We currently have a mac FMP5 client that acts as a "script server". It runs scripts at scheduled time like: recalculating the today function, doing relookups for 10K's of records. We use MacAT for the scheduling - everything runs ducky. We're going to move this function to a mostly idle WinNT server so we can use the mac for something useful -). I figured I could just call a filemaker script from the command line and then toss it into the AT command scheduler. But I can't find *any* documentation on driving FM from the command line. Sure there must be some functionality like x:yourpathherefilemakerpro.exe -q (quit), -s /scriptname (run this script)? Or am I going t…

I am having trouble with a seemingly simple problem. I have set up a script on file a to find a set of records, perform an external script on file b whose job it is to import those records from file a. There doesn't seem to be any consistency to whether file b imports those found records or all the records. I have restore import order selected on the file b script. Even when I simply go to file b and do a "manual" import, I can't figure out how to make it import only the records found on file a. I know I am missing something simple here. Any help? thanks, mike

In Preferences ---> Application you can set a script to run when a file is opened. To check all the records at once, you will need to script a find that looks for all the client records which meet your date criteria. -bd

Here I am! It is the first time I am on this forum so I give you my greetings. I have a problem: I'm starting to learn FM pro v5.0 and I don't know how to create personal functions (scripts) to assign to bottons of report windows. How can I do? Thanks a lot.