Script Workspace and Script Triggers

Hi all, I have: - a database with "n" golfers - a database with "n" tee times - a database with "n" dates The problem: I want to assign "randomly selected" groups of 4 golfers from a found set of golfers that I determine (foursomes!) to tee times I assign ----on dates that I also assign----How do I write a script for this? [ May 07, 2001: Message edited by: Strad ] [ May 07, 2001: Message edited by: Strad ]

I know that FileMaker is keeping track of the name of the file is has imported because it's there as the default file name when I export a record. I'm looking through all of the status functions but can't find one that captures this info. Anybody know how to get this info via a script? Thanks. --neal

Has anyone come up with a way to prevent the current file from closing using the close box on the top of the window? This happens a lot on Windows and is a pain.

Hi I have a document database that I want to be able to by pressing a button locate a document by browsing and when I select it the document link is then saved to the record. Then from that point I can then simply click on a button to open the file. I have previously manually added the document location, but would like to know if there is a way I can select it within FileMaker and then have its link then recorded. I am using FMP 4.1 (PC) Thanks Greg null

I've created a large database with a number of tabbed layouts and now they want a browser type back button - anyoneone know a script that can do this? Thanks in advance

Hi.... I would be grateful if anyone could help me with my problem.... I made a script using FileMaker's ScriptMaker. In ScriptMaker, I used "perform applescript" and this script is called "UserIDFolder". It resides in the Users.fp5 database. The applescript creates a folder on my computer when a new User record is created and the folder is automatically named with the UserID on that particular record. The online form that I use to create a new User record in the Users.fp5 database looks like this: <form action="FMPro" method="post" name="newuserform"> <input type="hidden" name="-DB" value="Users.fp5"> <input type="hidden" name="-LAY" …

The FMP5 database is located in the server as a host and shared for all guests users over the local area network. I want to prevent more than one user viewing a specific layout at the same time. Anyone have idea to write this script?

I have a database of jobs that when completed, the user will check a "Completed" checkbox. I would like to sort a list to show only the items that are not checked (uncompleted). I only want this for this one list.

I have seen or heard about a facility to protect individual records and layouts by password. I am not sure if this is a plug in or script function. Can anyone point me in the right direction please. Oyseka (South Africa) [email protected]

Hi, I have 3 databases: DB1, DB2, and DB3. Relation: DB1::ID Number and DB2.ID Number Relation: DB1::ID Number and DB3.ID Number In DB1, there are two portals: one portal display records of DB2, and another displays records of DB3. DB2 portal look like this: Example: NAME PHONE Smith 256-544-7894 Nancy 256-894-7894 DB3 portal look like this: Example: ORG CODE EST1 EST2 AD01 1.2 2.3 FD32 4.3 3.6 The

Hi, is it possible to set a valid password for a period and then automatically change to a different password for the next period. i.e. if it is June then the password is harry, if it is July then the password is paul and so on. [email protected] Thanks Oyseka (South Africa)

I know repeating fields are evil but part of my solution requires importing multiple line item records into a single record in another file with repeating fields. I can get the import to work by setting a global repeating field with the values from individual records then importing those fields into the other file. The problem is that after import I need to go back and clear all the repeats for the next import. Using set field for "" for every repeat of the global fields works but it seems there should be a better way. There should be a way to use loop but I can't seem to figure it out. Any ideas would help. Thanks, Wayne

I've been working on a database for about 5 months now in my free time. Back in April of this year, I was using FMP3.0 - now I have 5.0 (which is amazing) = and a relationship that worked in 3 is now not working in 5. Let me explain. I have a CONTACTS database that contains customer info, addresses, phone #s, ... I have an INVOICES database that contains new invoice data entry, shipping info and invoice printing capabilities CONTACTS and INVOICES both have a CONTACT ID field and I have created relationships to each other within each dbase. Now, within CONTACTS the user will find the customer they want and they have the option to autmatically create a new invoice. …

I've been working on a database for about 5 months now in my free time. Back in April of this year, I was using FMP3.0 - now I have 5.0 (which is amazing) = and a relationship that worked in 3 is now not working in 5. Let me explain. I have a CONTACTS database that contains customer info, addresses, phone #s, ... I have an INVOICES database that contains new invoice data entry, shipping info and invoice printing capabilities CONTACTS and INVOICES both have a CONTACT ID field and I have created relationships to each other within each dbase. Now, within CONTACTS the user will find the customer they want and they have the option to autmatically create a new invoice. …

I'm using the 'Set multi-user=on' script step and wanted the script to verify it. If there's a problem, Filemaker issues an alert which cannot be turned off with the 'Eet ErrorCapture' command. so how do I issue a 'Show message' alert if this file is part of a runtime solution which are always single user? Thanks, Stefan

Sorry, you can't script a go to layout mode. You'll have to make do with a command-L. -bd

Sorry, there's no way to pick a file name on the fly in a Filemaker Script (except with user input). I think the Troi File plug-in will give you the capability to rename your export file. You can check it out at www.troi.com

Hi everyone, I am trying to create script that upon which day of the week will do a calculation. Once I have the code that will allow me to dtermine which day it is such as "Monday" "Teusday" I will be golden. It has to do this with out using a find function also, if you guys can help me out I woukld be in your favor. Thanks

FM4, G3 8.6, Swann V90 Ext Modem Posted this a few weeks ago but didn't get any response. Trying again in the hope that someone can throw some light on it

I am very new at FileMaker I am trying to make a button that will perform a search if a field meets a certain criteria. For example: A field will either be: 10, 9.5, 9, 8.5... I would like a button that will search all the records listed as "10". or all records listed as "9.5"... Thanks for your help and patience.

I have made a database, if a date is the same date as today it emails a mail to me. But now i also want to send atomaticly a sms to my mobile. Is this possible? Tnx Tomba

How can I make a request to FileMaker on the Web to download a MS Word file that sits on the disk where FMPro resides? These files must be downloaded only after the transaction is approved. So their path must remain not accessible par a hyperlink. I built a hyperlink to the file with calculated fields. It works but the path is shown to the user so the security is null. I tried to use the Include CDML tag but it works only for text file. Is it just a matter of changing the MIME type? What would the Mime type be then? Thanks to all

PLEASE HELP I STLL CAN'T MAKE THIS SCRIPT WORK!!! I am very new at FileMaker I am trying to make a button that will perform a search if a field meets a certain criteria. For example: A field will either be: 10, 9.5, 9, 8.5... I would like a button that will search all the records listed as "10". or all records listed as "9.5"... Thanks for your help and patience.

I have very little time left to complete a project. I am new to FileMaker and I apologize for posting a possible novice question. I have just started using FileMaker5 on a Mac about a month ago and have found my way around. I do have experience in creating databases with SQL. However, I am stuck. I need to create a report that when a field it is querying is empty, it will not print out that record to screen. It will only print out records with data in the field. I used the Report Wizard thing to create this report so I could include totals. Here is what I have: Go to Layout ["Report"] Sort [Restore, No dialog] If ["IsEmpty(date_completed)"] Omit Record End …

I'm looking for an automatic way to export multiple files using different file names for each export. Example: I have a database of places. Each record contains the place name, description, etc. I want to create an HTML page for each place. I know how to create the HTML pages by exporting and naming each record one by one. I want a way to batch export the files (there could be 10's of files) using appropriate, unique file names. I can easily specify the file name in each record. My roadblock is that I don't know how to specify that file name in the exported file. Can you help? I use FileMaker Pro 4.x and 5.x on the Macintosh.

Currently have a script in place for one set of info which allows us to enter a number coinciding with a weekly event. (i.e if today + 7...) Would like to assign a new set of data with progression by month. In other words, one set of data assigned a Monday date. When entering "3" in our frequency field means this data is pulled as active next Monday and the following Monday (4/30/01, 5/07/01 and 5/14/01) Need to have other set of info go from May 1, June 1, July 1.

Does anyone know a good way to test for both Date AND Time Modified and then delete the earlier Duplicates after an Import? Thanks! Jeffrey Ellis

There are many text fields in the FMP5 layout including a field called "last modifier" which can records the last modifier's name of each record automatically. Besides, there were some check box fields. Can i write a script so that FMP5 will not treat "check & uncheck the check boxes" as a modification and keep the last modifier's name unchange?

I have one database with 10 fields. On new record entry, field one does a lookup of all previous record "Field One"'s. Upon user selection, the current new records' "Field One" gets filled by a previous records "Field One". Is there anyway I can grab "Field 2-4"'s data from that previous record and autofill the new records "Field 2-4"'s with that data?

I previously posted this elsewhere, sorry if any of you get deja vu. I have a DB with a field, used as a key, that is set as not empty, unique, strict. However, I find that a script is able to change this value into a non-unique one. No error is trapped in the process. I created a tiny example FM database and script to demonstrate this. If anyone wants to give it a try, please contact me off-line at [email protected]. Thanks in advance for any help. -- Mark

I am finding that when I go from one script to another with an IF step I am still being led back to the originating scripts when all the conditions are met. Is there a way to halt other scripts while in the script I want to remain in. The perform script step acts as a GOSUB instead I want a GOTO as I don't need to return to that script. Thomas

So here's what I'm doing. I have 10 fields, numbered s1, s2,...s10 On a web page, I want the user to submit a number the database recognize the number and pulls the corresponding field into another field manipulates the new field and returns the manipulations of the new field to the user. I don't want to do this in AppleScript because it ruins the cross platform aspect to it all. Here's how I do it in AppleScript. Keep in mind field "q" is the submitted number from the user, and field t60r is the common field that the value will be put into. set currec to current record set activeQ to cell "q" of currec as string set activeS to "s" & activeQ se…

<// I have used this function in scripts for years, and all of a sudden it doesn't work anymore, and the script don't work anymore. The function worked to find all records before today's date. Why doesn't it work anymore? After it stopped working, I updated from 4.01 to 4.03, but it didn't help. Is there another way to find records before today's date that I should use instead? Thanks for any help. MV

I want a script to tell me if a date field is less than 2 years older than the current date. I've tried a few things and can get a year to work but it's not a full 2 year difference. It just checks the year so it could be 1 year and 1 month and not a whole year. All help appreciated! nati

Write a script to perform "Find" in a text field is easy. However, if the field is a radio field, how to write the script?

I have a script which searches for an employee and a date range (the work week). This script also sorts that found set and has a sub-summary which sub-totals the total number of hours worked by day for the found employee. I am having a tough time trying to figure out how to add additional calculations once that sub-total for each day is found. These employees are paid on a per-day overtime basis. I am able to extract this information and perform these calculations to another database which just show totals but I would like to have this done in the original database. Is there a way to calculate the per day overtime charges and show them in the same area as the sub-total?

I have a script that syncs two databases (a & by just importing and updating the new records. I have two questions. 1. How can I get the script to delete a record in database "A" if it does not exist in database "B". 2 How can I get the script to run every hour to update records. Thanks. j

I've tried different suggestions. They either didn't work or I didn't fully understand the instructions. Given a birthdate, I want to find the consumer's age in years-just years.

Hi all, How to write a script so that no more than 1 user can action in a Layout (e.g. company list)

Hi all, How to write a script that can clear a field in all records when users close the FMP5?

I've got 2 files in FM 5 that are joined thru a join relationship: File A contains the data records, and File B is a mini calendar that pops up on top of a File A layout through the use of a couple of scripts. The user clicks on the mini calendar which sets a global date field in File A to the date the user selected. I then run a script located in File A (while still in File to copy the date into the appropriate field in the current record. This seems to work fine, but I would like to move all of the involved scripts in File A into the File B mini-calendar. Since the files are joined, I tried the following which does not work: In File B: "SetField(File A::Date1,Fil…

Here is the problem: I perform a find and then the script pauses. I would like it to continue. The trick is that the perform find is in a portal. Script: Find Mode "The Portal opens with some fields and a button(the button = Perform FIND)" GO TO Layout PRINT GO TO Layout The pause happens after the button is pushed. In the toggle window, a continue or cancel button shows. How can I get the script to continue without any interaction from the user? Thanks in advance

I have a field called programs. It's value list comprises all the agency's programs (departments.) I want to have a user be able to click a button that will find all records associated with his/her program without having to perform a find and then having to check the boxes of the applicable programs in find mode. Help please.

I am trying to create a script that will do a FIND on a text field that will result in finding two different words, in this case, City names. I would like to find and show all records with city x AND city y from the same database. I know how to do this with menu commands, but can't seem to find the right combination of script steps to accomplish this. I either get an error, no records found or end up with only the results from the second search city. I have read through the Filemaker Help files and found nothing covering this kind of script. FMP5, if that makes a difference. (I am VERY new to Filemaker, please forgive if I missed something very basic)

Im new to Filemaker but Im learning it very quickly but even after searching through help I am stumped. Im making a Baseball database with hitters and pitchers. I have 3 layouts 1. Menu with option to go to hitting or pitching 2. hitting stats 3. pitching stats. My problem is is that I need to be able to exclude fields like homeruns and stolen bases from the pitching layout because that does not involve pitching. And vice versa with wins for batting stats. Im creating this for practice so I can learn FPro. Please help..if you need more info please ask. Bobby

Our office recently purchased FileMaker Server, and I have transferred all of our FM files to the server. My IT people told me that in order for them to do backups over the network, I have to close the files before I leave the office daily. That's not the problem; the problem is opening them again before the first users arrive at 7 a.m. (an hour before I do) and need to access the files. I use Timbuktu to remotely administer FMServer and haven't yet found instructions on how to write an open/close script for the server. We use Windows NT on PCs. I found information on scripting with AppleScript, but since we don't have MACs anymore, that does me little good. Any help…

I am trying to write a script that changes one value to another, but only in a condition. here is the script: Go to Record/Request/Page [First] Loop If ["state="california" "] Set Field ["state" , "state="CA" "] Go to Record/Request/Page [Next] End If Exit Loop If ["Status(CurrentRecordNumber) = Status(CurrentFoundCount)"] End Loop This seems to go infinitely and when I cancel, all the values are zero. Also, How do I set a variable? As this script shows, I need to change the parameters each time I want it to find a state, or write a script for each state. I would ultimately want to write a script with each state set as a variable, and loop through…

I am writing a somewhat complex production database. I have to use scripts to manipulate the user into different choices depending on the state of a particular field. Many IF statements force different scripts to run depending on conditions. A script is always running. It's cyclical. It would be nice to be able what script is running to troubleshoot the IF conditions. Would appreciate any feedback. Thomas

Hi I'm a newbie to this forum, my first post. Wow! Broke the ice. I am developing an application. I'd like to preview a layout of multiple pages. I want the user to be able to step through the layout one page at a time. I don't want them to have access to the status bar. Is there a way to do this? Have I missed something really simple? Cheers Rob

Hi, you guys have helped before - I hope you can now I have a field with a full name eg Mr Rodney James Jones. I want to be able to sort alphabetically and of course it sorts based on "m" for Mr. There are over 5000 records. I need to take out the last name and place it in its own field, then sort is simple. I think I need to write a script - something like, go to the name field - take all letters from the right - when you come to a space (between the last and middle names) stop and cut - then paste into a new last name field, but am at loss how to word it correctly for Scriptmaker. Can anyone enlighten me. Thanks

I have a small calculation, using case obviously, that tells the user whether the project is on time, due today, or past due. I need to know if I can write a small calculation that changes the text color like if the text in the field = past due. Thanks again. j

I have a multi-file solution that has an update feature that I find incredibly difficult to maintain, and wondered whether anyone had a better solution, and/or information about how to document and manage the path of the Import Records and Save File As script steps. The new database files are loaded into a subfolder, and then are opened. They automatically import the client's data from another location, and then the newly-populated files are saved in the client's base folder. The problem is that I cannot see what the actual path settings are for the old data, or where the new data will be saved. Moreover, Filemaker 4.1 doesn't seem to store the path settings with the scri…

I have stumbled across a problem. I need to "lock" the records if they are marked complete. I created 2 separate layouts (1 viewing (Lock), 1 editing(Entering)). Here is my script: Enter Find Mode (Pause) Go to Field (Substrate Number) Perform Find If (Completed = "X") Go to Layout(Lock) If (IsEmpty(Completed) Go to Layout (Entering) End If End If "Completed" is the field that the user checks with an "X" if the record is completed with it's run. If there is no "X" in the box I need the record to go back to the Entering layout because they will need to add to this record. I have this …

I am creating a form where the requestor needs to isert an object. I want to add a button to the form so that when hit, it opens the insert object step and allows the user to enter the path to their file. As far as I can see, if I write a script that inserts object, it fails becuase I need to specify the file myself.

This question maybe asked b4 but I can't find it: How can I print out the script? If I need an add-on program to do it, what is it and where can I find it? Thanks for any help in advance! -jimi

We have an inhouse network running FMpro on Win and Mac systems, and instead of having each user type in his or her password when opening a file, it would be much easier to just have the host use the login username directly as the password. It would eliminate all visible password processing, and users could just open files normally without worrying about it. I've been wandering through the manuals and help files for some time and haven't found a way to do it yet... Any help would be greatly appreciated.

Folks, I created a data base with multiple part number files related to the same project (D0, D1, D3, ...,S0, S1...CL0, CL1, CL3,...etc.) Each project could contain up to 50 different part numbers. But since I need to create the same number of working folders I would like to use our Dymo laser printer to print labels using the information keyed in our data base. So far, I created the layout for the Labels with <<Description:>> and <<Cat. No. Series:>>. How can I add the part number info if not all the field have the same name? Could I use a script to gather all part numbers related to the project and then print only the files that contain data an…

Can anyone help me? I have been racking my brain to get this script done. The environment: Panels in Mac Manager Script: From current record and network printer, switch to be able to print to adobe pdf, save pdf to user's documents folder on server, open Entourage, attach pdf as attachment, send email, return to network printer. After, yell out "who's the man?" to anyone present in the room. Thanks for those who will attempt.

I am trying to write a script that checks an email account every 5 minutes. I am not sure how to do this, more so, I am wanting to have the email that is gotten from this import into my database as a new record. Does anyone have any ideas or examples? I am new at this, and know I have to get much better at scripting.... Thanks Mitch

Good Day All I need to parse some text that came from an HTML page (see example below). Each parsed text needs to be in a seperate record. I can get it to grab the first line but beyond that I am having difficulty. I am still learning to use the Loop function properly. Thank You Rob Example: <p>Some text</p> <p>More Text</p> <p>Crazy Text</p> etc

I'm having trouble completing what (I think) should be a simple script, and can't figure out what's wrong. Any help would be appreciated. I've created a database for our afterschool program where students need to log in and log out. What I'm trying to do now is create a script which "resets" all students to a logged out status (this will be used by the program administrator at the end of the day to start fresh the next day, as many of the students fail to log out properly) The database identifies a student as logged in or out by the contents of a field called "action" (0 = logged out; 1 = logged in). My script is: Enter Browse mode Go to Layout "list" Set Field "a…

I have recently created a mail merge function in my fmp database. It works fine, but I need to keep a record of the sent mail. Is there any way I can create a new record in another fmp file for storing these letters.

The default size of the "Script Definition" window (the window where the script steps are on the right and the commands are on the left when you are editing a script) is rather small. Is there a way to make this window maximum size without stretching it each time it is opened. I've read back for a year and did a search...without success. Respectfully Eun Mi

I have four database files; Customer Information, Item Entry, Sales Order, and Sold Goods. I assign an arbitrary number to each item entered when we receive it into the warehouse. We use that same number in a field called Item Number in Sales Order. I need to set up a routine so that when the Item Number is entered into Sales Order then the information about the item is copied from Item Entry to Sold Goods and then deleted from Item Entry. Is this possible? Thanks.

I am using a Mac Laptop, FileMaker 5 v 3, System 9.1, with my standard LaserWriter setup normal. Wanting to number certain reports with a "Page n of x" page numbering scheme, I set up a global number field, "PageTotal." In the footer of the report layout I entered the text "Page ## of <<PageTotal>>" and then set up a script, "Set Page Number" to set the field but it does not set the page number. The script reads like this Enter Preview Mode Go to Record/Request/Page(Last) Set Field (PageTotal), Status(Current Page Number) This did not seem to be a big deal but for some reason it does not work, and having a Senior Moment, I am not figuring it out. I hav…

FM4, G3 8.6, Swann V90 Ext Modem Trying to merely dial phone via FM instead of doing it manually, to talk to someone. Everything works except 'Hanging Up in 60 seconds' appears and a repeating sound occurs. It appears it is trying to connect to a fax or similar. Is it possible to use FM to dial phone in this way and, if so, what setting have I got wrong? Thanks for any help. Keith Shelton

Hello all. I have a ScriptMaker script that shoots off an AppleScript event to open a Photoshop file in Photoshop on the mac. My problem is that I need it to work on Windows machines also. I know that Win does not support Applescript, but does make DDE calls, but have not found enough documentation to start this quest of what to call and how. Or if there is another roundabout way of doing this I am all ears. Also...I have an AppleScript that copies the file(s), so if there is a solution to that one, I would appreciate it.

Is it possible to dynamically create fields in a database according to the number of fields from a form? I am trying to dynamically create fields in a -db after posting a form.

How can I create a script that add new record in my database for each single field (in a form) after posting a form? For example, I have field 1, field 2, filed 3, in my form. I want the script to take the value of the field1 and create a new record and so on for each field in the form. help will be much appreciated. Cheers. fred.

This one is either so easy that the simplicity of it bewilders me or so complicated i am bemused - either way i need help. I have two db's a simple relation... based on the fact that the product description can change alot... so the description is built in the second db out of fields containing the elements of the product... with me ?... using a calc... SLength & "'" & " " & "x" & " " & SWidth & Inch & " " & Weave Type & " " & "Recovery Strop" & " Rated at " & Rating & "kg's, or double that rating for towing." Then ... in the invoicing db... i perform a lookup based on the selection of the product field... [which is a…

I've seen this before, but trying to figure it out has gone beyond me. I have a layout that displays a few fields for a record. I also have a layout setup to help in finding records based on cross reference numbers. If the user looks for a certain number and finds more than one record, I'd like to have a list that a user could choose from to view in the main layout. The only thing I can't find is how to do an "If" if the "found set" is more than one record, so I could instruct FM to either change to the list view or even to another layout that could accomodate the user for making their choice. Anybody got any ideas? I've seen this in another FM database a couple of …

I have a database that I would like to have it e-mail me everytime a new record is created. I think this can be done? If anyone knows how to do this please let me know how the scrpit needs to read. Thanks, RET

I am creating a database with two different types of e-mail discussion lists. Both lists contain all the same fields. But I need to seperate the two lists into diff layouts based on a field in my database called Field Type where I name one list type A and the other type B: I want all of field type A to come up in Layout 1, and all of field type B to come up in Layout two. Can anyone help with this, thanks in advance for your help.

I apologise if this has been covered before. I am using Set Field to input the name of the person whose individual report is being printed. I want to know a quick and easy way of keeping an historical record of all the names of people whose reports have been printed as the new name overwrites the person who was there before. Is there an easy way ?

I'm not sure exactly what you want to do, but the import feature in FMP isn't too sophisticated. Then again, there isn't that much to importing either: just suck the data in. Any other processing that needs to be done should be performed within FMP itself with the data as records. You can script import so that the user has full control as to the import order and which fields are imported and choosing the path of the file; or it can be canned; but there is no in-between. Many of your challenges might be met if you think more about controlling the data being imported at the beginning, rather than trying to get FileMaker Pro do do something it cannot. That is, if the data …

Is is possible to have a script or subscript executed a number of times based on the value of a field? IE - if you have a portal with 14 records and you have another portal that looks up from the first portal

I need to script an email automation. Now when I want to be able to email a certain group of people in records, I have to do a look-up then export a .csv file and copy and paste from excel. How can I automate this so that I can cut the cutting and pasting out? Any ideas?

I have a script which is run upon opening my solution. The solution is password protected with a master password and "No password" for the user, making the password transparent to the user. "User abort off" is the starting script step. Upon the opening the solution, if one strikes the Esc(ape) key at just the right moment, the script is bypassed. Any thoughts? Respectfully, Eun Mi

I am still woring on the jury pool script and I thank everyone who has helped. The number of potential jurors will vary from trial to trial. Is there a way to define a variable that represents the maximum number of jurors? Right now the closest is: Exit Loop If ["TotalSelected = 100"] where 100 is the maximum number of jurors.

I am trying to dynamically go to a layout depending on the value of a global field, but I am limited to jumping only to a layout number, rather than a name. I have a clumsy solution, which involves generating keys in a layouts database, but was wondering if anyone had anything more elegant. Part of this is a simple script that loops through the layouts using Status(LayoutCount) Status(LayoutNumber) and Status(LayoutName). I think what I'd really like is to be able to set several Global repeating fields, use the script to do a sort of PutRepetition of the LayoutName in one field, and LayoutNumber in another; then whenever I need the layout number, I can just loop through…

I created a database for student records by modifying a Filemaker pro template for student records. I have added fields and scripts, then deleted many. Now when I open the database, I get this message:"Script cannot be found or has been deleted." The data base works, how can I get rid of this message(I created the database in FM 4. The problem appeared when I converted it to FM 5.

I need to write a script that loops through a string of words and creates a multiple OR find, but have stumbled on something irritating . The script (which is incomplete) goes something like this. The field G_PLZ is a string containing Postal Codes, sparated by spaces e.g.(1234 6675 7785 12989) Set Field [ G_Number1, 1 ] Set Field [ G_Number2, WordCount(G_PLZ) ] Enter Find Mode Loop Exit Loop If [ G_Number1>G_Number2 ] Duplicate Record/Request Set Field [ PLZ, MiddleWords(G_PLZ;G_Number1;1) ] Set Field [ G_Number1, G_Number1 + 1 ] End Loop My question: where can I insert the Perform Find? The problem is that the loop increment counter becomes par…

I've got a little calendar database that I call with the click of a button that will allow me to select a date, then goes back to the original database and enters the selected date. I created a script that when you click a little icon, FM stores the field name and portal row in globals, opens the calendar, waits for the selection, then goes back, steps throught the fields until it gets to the one I was in when I clicked the icon and enters the date. Problem: I have many date fields and you have to be in a field to set the current field. It's just not very elegant. You should be able to click the button and it knows you mean the date field it is next to. Solution: Some s…

I'm new to this I am trying to understand what Filmaker can do - so here's a brief assessment of what I'm up to. What I have - two files - one that contains main 'Job' information and one that contains detailed 'Parts' information for the job. I currently use the 'Part' file as repeating lines for the 'Job' (i.e. 1 job may have 10 different part items) What I want to do - run a report that will list the part items for all open jobs, sorted by due date. My question is - can I, as part of my 'Job' file run a report that utilizes all the records in the part file. With the ability to sort and find specific records in that part file. I would assume that I …

The generally accepted way to do this is to put your line items in a separate related file, and then display them in you main invoice file using a portal. This gives far more flexibiliy than repeating fields.

Do you know any script routine to convert numerical quantities to words in Spanish language (very different from English syntax rules).

I have 2 files: Advertisers and Contracts. In the Advertisers I have a Contracts button. When this button is clicked on I would like it to open Contracts file, Create new record, Copy the acct #, salesperson information from the Advertisers File. I would also then like to have the two records from the two files to be linked afterwards. I can get the button to open the Contracts file and make new record, but can not get the info to copy and link. Any ideas would be appreciated?

Okey, Office 2001 is more integrated with FileMaker then ever before. But what happend to the "Send Mail" funktion? With Office comes this great E-mail application Entourage, there for I

Ok. Here is hopefully a simple question. I have an automated script that I want to use in conjunction with a web page. I have entered the -Script line, and all I get is an error. How does HTML or rather CDML deal with a script?

I have been using FMP for awhile and recently took on the task of creating a simple reservation/checkout database for AV equipment. I need to page through the current reservations and checkouts and see if the proposed checkout/reservation conflicts with any of the current checkouts & reservations. I am having trouble getting the script to work for both multiple day checkouts and hourly checkouts. Has anyone else done this? Examples? Help? Thanks, Cian

Hello, can anybody give me a suggestion how to automize the Quicktime file insertion option. I

I want to use a set of alphabetical buttons (A,B,C. ...) to navigate through a list of contact people. I thought I'd seen an article about a good way to do this, but now I can't find it. Does anyone have any leads or suggestions? Thanks, Keith Silva

For email, I prefer to use a FM plug-in such as SMTPit from www.comm-unity.net. It doesn't require a separate mail application. You can implement a complete send and receive mail systems from within FM. -bd

Hi everybody, Can some want know a technics script to convert a number to a text. Ex: 120 - Hundred and twenty I really appreciate that.

I have a scrit that is set to run on startup, it exports info and closes. How do I stop a scrit from running on startup? I need to edit the database. (actually this is a co-workers database) hehe ------------------

I have created a script (and layout button) to activate image file of imaged documents. However I cannot get the image file to close automatically. Does anyone know of a script to achieve this?

I'm new to FM scripting, but an experienced programmer...here are the things I hope to script but cannot figure out: (1) how to sort on a particular field (2) how to import a graphic into a container given that I have the file name and path (3) how to export a text file which combines the contents of fields along with my own text To be clear--I know how to do these things in FM but I want to automate the tasks with scripts without the user needing to specify anything (just click the button).

Sous Mac OS 8.6, l'action de script le script envoyer courrier "" marche pas. La boite de dialogue n'apparait m

Desperately hoping for help... I have 20 class lists - each class list is stored as a a seperate database, with each record within the database representing a student (by name). I need to create a script that will count the number of students common to each class. For instance, it will compare Class A and Class B, and generate a number based on which students are common to both. I know this must be possible, but it makes my head hurt trying to figure it out...thanks!

FMP 5 can export as html table in one step...