Script Workspace and Script Triggers

Hi I have recently written a script that copies data from a bunch of records into another database recordset. The problem is, even though the script I feel is close to perfect, for some reason all records from my Database get copied to the other database, even when I have an 'if' statement to make sure that I am only copying the files over that I want. This is the structure Quote_Database - Quote_Item_Database Order_Database - Order_Item_Database I am trying to copy (duplicate is the better word probably) certain records from Quote_Item_Database into Order_Item_Database and create a new Order in Order_Database to make the relationship intact. Is their any hints any…

Hi, I have been given a mission - to link/embed a large number of pdf documents (in excess of 15,000) to a filemaker database. I have cleverly figured out how to do this (I am but a grasshopper in the FMP world), however I have to do it manually, one file at a time (brilliant). I have been working with FMP 3 but am about to upgrade to FMP 5. So without further ado, ladies and gentlemen, here is today's FMP tadpole challenge: Does FMP5 or alternatively a plug-in (Troi) allow me to import and link/embed files en masse? The pdf file names are sequentially numbered and based upon an id number in the Filemaker database. Is it possible to write a script that will auto allo…

ok, .. so i'm trying to ommit duplicates again, but this time it gets a little more complicated... I have a found set in my database. Field A. Field A has more then one entry, separated by a break. e.g. field A, record 1 can have: eggs bread milk sugar field A, record 2 can have: eggs coffee bread butter Etc..... what i need is a list of all the data in field A without duplicates... I know this is possible if there is one data per field, but is it possible with multiple data in one field? What I am currently doing is copying all the data in the field and pasting into excel one record at a time. Then sorting them in excel to delete duplicates to…

Hi, I am using FM5 and Win2000 and I would like to "print" out my reports via Adobe PDF-Writer. How can I disable the fileselect box? Or better: how can I create a PDF-file taking the filename from a FM-field? Is it possible? thanx Sebastian

Let’s say there is an entry field called A is displayed differently on the same layout. The data of first A is entered by key in, second A is selected from a drop down list. The problem is when I run script "Go To Field (A)", it always point to the field A that data is entered by key in. I want it to point to the A with drop down list. What did I miss? Thank you

Is there any way of specifying to print from Page No no1 to Page No no2. where no1 and no2 comes from the database. Thank You [ August 20, 2001: Message edited by: Jacob ]

Hi folks, I would like to know if there's any way to attach a excel/powerpoint files into container fields in FMP? One of my current assignments require me to attach Excel files into the database. I know the container field method doesn't work as those are just able to store graphics like JPEG. Please help if there's a way to work around this. Thanks.

I need to perform a search across every row in a portal to see if it contains a certain value "ERR". If it finds the value in any of the rows, I need it to return a # value equal to the # of times "ERR" appears. I'll be using this in an If, Else script. If "ERR" appears > 0 a comment window appears, else a text field value is set. I've got a working script that will search through the first row in the portal but I can't figure out how to make it jump down to search through the rest of the portal rows. There will only be approx. 8-10 rows to search. Any ideas?

I am trying to create a script that exports my files to another FileMaker File, but when I include it in my script and try to "specify file," I cannot select the FileMaker file I want to export to. I tried changing the file type to FileMaker, but it is still ghosted. If anyone can help, then I can stop pulling my hair out.

This topic is additional of previous "Go To Field ()" topic. I forgot to mention that these two fields are placed within a portal Thank you

My database is almost complete and I started working on reports. Is there a way to calculate the average of data stored in multiple records that appear in a single report? For example: There are 23 students who took the same test, and I would like them to appear in a single report (done that), and have Filemaker calculate the average score on that test for those 23 students.

I am trying to create a script that exports my files to another FileMaker File, but when I include it in my script and try to "specify file," I cannot select the FileMaker file I want to export to. I tried changing the file type to FileMaker, but it is still ghosted. If anyone can help, then I can stop pulling my hair out.

I have a field that is auto-populated with an "X" when any one of 6 fields are changed. It works fine, but now I need it to pop up a message asking whether to print or not. The X field is set up in the field definition, so I don't know if this can be added to the calculation or a script has to be called.

I have 12 empty date fields named Date#1 Date#2 Date#3 etc. If date one is Aug 10,2001 I would like Date #2 to be Aug 17,2001 by using a script button. I have used this formula Month(Date#1)&/& Day(Date#1+7)&/& Year(Date#1) however it does not change the month if you have Aug 27, 2001 and want it to be Sept 3,2001. Please help!

Hello I have found an error when i updated my database to FM 5.5 from FM 5. I have an script that update the links from a master file to a related file like this: Cut[select, #Operacao] Paste[select, no style, #Operacao] Go to next field #Operacao is the field used to link the master file to the related file, and using this script I am forcing a relookup. Why does it work at FM 5 and doesn't work in FM 5.5??? Does anuone have any idea to solve it??? Thanks

I'm trying to write a script that will print all the script definitions for my database which is composed of 17 related files. I'm not sure how to automatically select the "print script definition" for all scripts in the Print dialog box. I want to do this automatically without the dialog box showing up. I plan on creating a basic "Print Script" script in each file that prints the scripts for that file. Then I can use another script that will activate those. I'm just not sure how to script my basic one. I know I'm missing something here. Is there a way that the script will remember the Print dialogue box settings like it does for the Sort, Find and Page Setup dialogues…

I don't know of any way, however I get aground this by creating a layout with the field(s) I want and buttons to do the actions such as continue script or exit script. I put in a go to layout step in the script and it works just like a dialog box. And looks better. [ August 16, 2001: Message edited by: bobsmith ]

I'm still working on my student database, and have created an interview database to track and evaluate students who are seeking employment. Senior (grade 12) and Junior (grade 11) students are tracked in separate db's. I want to import subsets of records from the master db into each of these db's by script. Can I create a script that will allow me to set criteria/find (Grade = 12, or Grade = 11) to match and import records?

I have a One->many relationship. In a script in the one file (activated by a button called, say, "New Line Item", I want to create a new record in the many file, then set some field values in this record using SetField This is driving me crazy, as I cannot see how to do this. The "New Record" script step only applies to the current file.

ok, say i have 2 fields, NAME and DATE. Let's say record 1 has name: ABC and date: 1/1/1. Now, I want to create a script such that it will check that when a person make record 2, 3, 4.... it check with any other record to make sure that ABC and 1/1/1 are not reused. If it is reused, it will not allow the user to create the record and make user abort or re-enter the data... Thanks in advance for any advice.

I am an intermediate developer that has been asked to create a database program for our production lines. On our production lines we manufacture automotive parts. During our production the assembly workers enter data on sheets of paper. The data that they enter on these sheets is as follows: date, part number, rev level of part, production per hour, total production for shift, total number of hours worked for the shift, and fallouts (per hour and per shift). Fallouts are parts that have failed a certain test. The assembly person runs each of the parts through a number of tests during production and what "area" or "sub part" fails the test needs to be tallied. There …

Is there a way of doing that? Once you "mouseRelease" the mouse button after selecting a drop down list item, to run a script? Any ideas? Thanxs Steve Griff

I have some scripts to Import and Export data to Temp files. The script imports/exports data and saves as Tab file on the desktop. Another script would be used to put the data back into FMP. The script used to work fine untill now. Recently our systems were upgraded to Win 2k and they dont work now. Please HELP

I have a relational database that tracks consumers enrolled in 15 different programs. In the “Program” database I have the following fields for each program: Enrolled (calculation, number) = NotIsEmpty(Enroll Date) Active (calculation, number) = NotIsEmpty(Enroll Date) and IsEmpty(Cancel Date) Cancelled (calculation, number) = NotIsEmpty(Cancel Date) Total Enrolled (summary, Total of Enrolled) Total Active (summary, Total of Active) Total Cancelled (summary, Total of Cancelled) On the main menu of the “Consumer Main Database” I would like to have a button/script that displays the name of each program. When the Program Manager clicks on the name of the…

Hi people. I wish to share some ideas and hopefully will recieve some handy hints on setting up this little process that I will now tell you about. Well, firstly, we've got three databases, Products, Suppliers and Product-Supplier. The Product-Supplier database is there to solve the many to many situation between Products and Suppliers. What happens is, when someone needs to place an order to the supplier, you can choose between more than one supplier for each product. To solve this, by next each product is a drop down list of all the suppliers you can buy that product from. Once you have made your supplier selection for each product, you will be able to press a "next"…

Hi people. I wish to share some ideas and hopefully will recieve some handy hints on setting up this little process that I will now tell you about. Well, firstly, we've got three databases, Products, Suppliers and Product-Supplier. The Product-Supplier database is there to solve the many to many situation between Products and Suppliers. What happens is, when someone needs to place an order to the supplier, you can choose between more than one supplier for each product. To solve this, by next each product is a drop down list of all the suppliers you can buy that product from. Once you have made your supplier selection for each product, you will be able to press a "next"…

I'm programming a database for high school students, and I want to automatically increment each students' grade by 1 year dependent upon the year of graduation. The field Stu_GradYear accepts the year of graduation as a four digit year only. The value list Stu_Grade contains these values: 9, 10, 11, 12, Graduate For the 2000-2001 (last) school year; 2001 = 12, 2002 = 11, 2003 = 10, etc. For the 2001-2002 (coming) school year; 2001 = Grad, 2002 = 12, 2003 = 11, etc. The school new year starts in September. On September 30, I want class of 2001 to change from 12 to Graduate, class of 2002 to change from 11 to 12, etc. Is there a way to automatically make these change…

We are using filemaker over our network here and everytime we sign on we have to enter a password to access our filemaker database. I was thinking, isn't it possible to make a logon script that enters this password for you? A login script that contains the password and that you could store in your own home folder on the server. Meaning that you only need to be verified once through the server and then you can run filemaker as well. Any help, most appreciated.

Hi: I've got a solution that I'm about to start marketing. Does anyone have any experience with any plugins (or available script samples) that can be used to automate under script control the process of authorizing credit cards? Does anyone have experience with the Waves in Motion product called ccAuthorize? The plugin needs to be Windows based. Thanks [ August 13, 2001: Message edited by: Steveinvegas ]

I don't know if I have asked this earlier,but I need to have some word doc with my standard filemaker output.The word doc is a legal doc which changes time to time.It has to be printed below some out put from file maker fields.I tried Container with Object Linking but the results are disasterous as the formating gets lost.Please help me know a solution to this as its urgent.Is there any other way like puting the filemaker fields into word and printing from there? Thank You

I have a problem I am performing a find to update some records and what is happening is that the find is finding all the records with the find combination in it so this is updating them and I do not want that to happen I know this is not explained very well so here is an example I am trying to udate a field with a code of 12, so I do the find and try and find this but at the same time it is finding 12, 123, 1234, 3123 and i only wanted it to return the first one. Is there away of using a strict find for matching only the exact value Thanks SImon

Hi, I have a layout with 6 fields: 3 color codes and 3 color names for each record. When I enter the color name it shows the correspondent code, included in another data base. After entering the names, could be shown like this: fields 1,2: 100, White filed 3,4: 001, Black field 5,6: 250, Khaki Is it possible to make a bottom that sort them by code after entering the names? (switching the content of each field) field 1,2: 001, Black field 3,4: 100, White field 5,6: 250, Khaki Thanks in advance

I have two date fields d1 & d2 and I want to find records in between d1-d2. This has to be pasted in a feild called proposal date and searched.But I am not able to correctly copy d1 and then .. and then d2 and then perform find. Please help me with this script. Thank You

I have a problem, I have a scanner to read barcodes... The problem is that I'm not near the computer when I scan the barcodes... so is there any way to run a script when a field changes ? 'Cause I often scan about 5-6 diffrent things and wanna save in separate places... Is there any free plugin that can execute a script when I change or exit a field ? Or do anyone have any other good solution ? [ August 07, 2001: Message edited by: Nordis ]

What to show last several sales for a customer on customer database. I have a file that each salesperson fills out by phone number that lists sales for each customer. These worksheets (in filemaker) are filled out twice a month.They are connected to a customer database and will input customer name (after # entered). (The customer database has all the customer info and call dates that they use to call.) These twice monthly files are then imported into one database file. I what to include in a section of my customer database for each cutomer a list of last 12 sales made to the customer. How do I get this info to my customer file and listed in one file.The 13th sale w…

Within a scripted loop that validates a user-found set of records, I'm trying to maintain a list of the records which fail the test, then later generate a report based on the list, kind of like this: LOOP If (Field A is empty), Add its Record# to the end of an Omitted List (a repeating field?) Add 1 to Omissions Count Set field Reason Omitted to "Field A was empty" Omit the record from found set End IF Next record END LOOP Now we process all records not thus omitted, then here's that list again: Find each record# in the Omitted List (by accessing successive repetitions X number of times by loop?) Sort Go to Exceptions…

Hi, I am not good at scripting so I am looking for an example I can look at to use. The sample I am looking for is a regular invoice db, with a portal of multi items, found on a relational db with multi records. of cource it will not print correctly, so I am looking for a script that will copy the informaion of the portal and paste it in to another layout for printing. Looking for a very simple example, since I am new to scripting. Much appreciated Mark

This is an easy one I'm sure, but... I have a field called Case Status w/ a value list of Active, Closed or Pending. I want to write a script that will omit only records that = "Closed"

Hello, Is there a script step equivalent to the "Case" function, something more than "Else"? Or a way to use a script step to approximate the "Case" (or the "Choose" function? TIA.

Does anyone know of a way to create an incremental auto-backup script within FM Pro 5? If it's not possible, is there an existing x-platform plugin or script (Applescript and Windows equivalent) that will handle this? Any thoughts would be appreciated. Thanks. Marc [email protected] [ August 04, 2001: Message edited by: mgb99 ] [ August 04, 2001: Message edited by: mgb99 ] [ August 05, 2001: Message edited by: mgb99 ]

I'm setting up a "comments" field with a scroll bar. I want to have the most current comments to be entered at the top. Using a script, I know how to start a new line and input current date, but I can't figure out how to get the insertion point of this new line to be at the beginning of the field instead of the end after the field is not empty. I want the program to set the cursor instead of the user. Can this be done? Thanks.

Users in my database can print a number of lists on the fly (names and addresses, names and centres, names and goals, stuff like that). They will print these list after entering a variety of search criteria. My question is, can I somehow isolate, or capture, the search criteria entered by the user so that it can be printed on the list (e.g., centre="xxxxx" and age=<25). Thank you. Ursula

I have a situation where our "Customer" DB is on a server and everyone at the office run the DB over appletalk etc. Sometimes though we have to take our laptops, palms etc and go see a customer on the field. So we need a copy of the "customer" DB on our own HDs in order to update it on the field (TCP/IP connections only work for a handful of people) so I'm looking for a way to easily sync the database on the laptop HD and the server when one comes back to the office. The problem is that the DB on the server changes a lot and if our consultant has been on the road for a few days he can't just import his DB on the server. One problem is that each customer has a unique ID an…

I have invoice and line-item databases related. To print the invoice, I was advised to create the printed invoice layout in the line-item db (header contains invoice fields, body contains line-item fields, summary contains totals). That seems to work, but I noticed invoices do not print if there are no related line-items on the invoice. An acceptable work-around for this would be to automatically create the first line-item when a new invoice is created. How do I create a new line item record from script, whenever a new invoice record is created? I only want to fill-in one field in the new line item record from the script. Also how could I script the invoice db to always…

I am able to see what invoices are outstanding? fields: inv_date inv_datePaid invElsaped calculation > If(inv_datePaid="","", inv_datePaid - inv_date) My terms are net 30 days,so an invoice is not past due until 30 days have past. This is what I have tried so far: field: day_outstand calculation > Today- inv_date days_PastDue calculation > Today- inv_date + 30 I'm doing something wrong...please help

You can't include a Word file as a containerized object in FM. There are a couple of options. Bring the text into a field in FM. If you have a lot of special formatting in Word, this will be lost. Use the scripting languge particular to your OS to automatically open and print the document. Neither of these approach may do what you really want if that is to integrate highly formatted text in Word in the middle of a FM layout. -bd

Hi, Is there any way to check if I send to an incorrect email address. My script look like this: Set capture error (on) Send mail() Setfield gErrorNumber = Status(currentError) where gErrorNumber is Global Number The result of gErrorNumber is always zero even I did send to an invalid email address Thanks in advance HP

I am trying to use an e-mail script that allows me to e-mail a message that has a layout that I create. It is now just letting me e-mail plain text. I want to e-mail a letter with each persons name, address ect enclosed in it. Can anyone help? Thanks Jeni

Is there a way to navigate to a Layout via a field that contains the layout name not the layout number. Right now I have a calculation set up to determine if field = "Ladder" then 5, if the Ladder layout is the fifth in the layout order, then I gotolayout via the field the layout number field. Can I do it without the coversion calculation or do I need a plugin or am I just wishfull thinking. Thanks Brian

In a very complex Invoice validation situation, I need to avoid all field-level validation. Therefore, I am collecting and validating all the data by script. One of many validation parameters is: The part number entered in the temporary gPart# field must be a number contained in a field in the Parts database. In field-level validation this would be easy. But in a script, how can I say something like: If(Part# is not a member of Parts::Part#), ShowMessage [This is not a valid number] End If I can't find anything in the manual that I could do, short of scripting a full-on Find request and error message collection.

Hi, we would like to access over IP to an image database in Filemaker Pro. In this database, the thumbnails of images, made with the imago-plugin are stored, combined with pathes to the original files. In the local net its easy to get this images with the troi file-plugin to clients workstation. The condition is, that the user has also access to the folder, where the images are stored. Our Problem now is, that we would like to use this database over IP without making that folder accessable over appleshare. Can anyone of you help me solving that problem? I

Hi, Which one is faster? When do I need Setfield and Replace? Thanks

I have a large number of URL's stored in my database. I wish to know if they are still valid and require to set an automatic routine to confirm any link is valid at periodic intervals. All or specific links are to be checked in the routine. If an error code is found, be it a Filemaker error (-1 to 978), an ASP error (0100 to 0246) or a URL error (100 to 505), I want to look up the error code (stored in my database) and record this in a field related to the URL. Furthermore, a counter will be incremented each time a link is found not to be responding, so, the higher the value in the counter the less reliable the link. Once the link is re-established the counter reverts to …

I have a 2-part question: 1.) Can anyone point me in the right direction in order to figure out how to export container fields via a script? I'm looking for the ability to export QuickTime movies from a container field in my FMP database. 2.) This will probably be an AppleScript thing but would appreciate suggestions -- Using Entourage as an e-mail client, how should I go about attaching an exported container field file to an e-mail? Thanks, -Eric

Hi all. Being new to ths forum and fairly new to Field Definition and Script-Maker in FM-Pro I'm stuck with a probably very old problem: For a database-based printed publication I need to create a "real" index ('got nothing to do with FM-indexing, I know), like in any ordinary book, which lists the topics, persons, places and the documents (pages) it is mentioned. Like: Nero: 12919, 12949 New Wales: 12999, 13001, 13090 New York: 12800, 12999, 13091 etc. The information is to be extracted from only two fields: The (however generated, individual for each document) "number" and the field "Index Entries", where each Document (the whole thing's a research biblio…

I have several files related by a master ID. I want to import data from one file to another. When I run the import script I want it to check that the records being imported are not duplicates and stop the if there are duplicates. Is this possible and how would you do it?

Hi all, I'd like to create a pop-up text(aka.dialog or message) box that only appears on the layout when a scripted button is used. The text box will contain helpful hints on data entry for the user. Can this be done? Thanks in advance!

I have a layout as "View as List" with a header...in the header I have two Global fields in which the user can input info to do a search... the problem is that the buttons work in the header but data cannot be entered in fields that are located in the header... is there a way to activate these fields using a script or an FM trick?? THANKS

A couple of things have come up that have me baffled.. new to FM 5.5.. i have created a invoice db. (permits) wish goes out to a value list from another Inventory db (rooms).... how do i indicate to the user that the "room" has been booked/SOLD for that particular date ... also how do i Clear the "SOLD" status on the check-out date/time automatically..? i am thinking of tagging SOLD rooms some how but not sure if that is the way to proceed.. any thoughts would be appreciated..

Here's the problem: I want users to be able to post fields into another layout, but then not be able to return and edit those fields. Additionally, I would like the users to be able to search the fields at a later time, but not change them.

Another likely easy question (I'm new to FM) I have 2 fields, today's date and date of birth. How can I calculate a person's age based on these 2 fields? Thanks [email protected]

I am currently working on a database for our production line. One of the features that I need is to have Filemaker Pro read the system clock to run the database. The operator will be looking at a screen with 4 fields on it. A "failure" field, a "reason" field, a total production field, and other fields that will have automatic information entered from their log in screens. The failure field and the reason field are hierarchical drop down menus. They will choose the failure and tab to the next field and choose the reason for the failure. Once they make their choices I need the fields to clear out (send information to another file) for the next entry. Besides getting…

I've been given the job to create 30,000+ usernames for our School System (teachers and Students). I've downloaded their id numbers, surnames and firstnames. We want to create a unique username, using the surname(first 6 chars) and firstname(first 3 chars). However, I have many duplications. Is there a script available that can assign a number to the duplications (eg)smithjoh1,smithjoh2,smithjoh3...etc)Thanks.....

How do u convert a set of found records to output to a pdf file?

I need to create mailing labels that have the usual: an address, city, state and zip. I also need to have the label print a sequential serial number that starts at some given number and increments by 1. I've got an FM 5 file that contains a list of customers. I need to produce the SAME label for a given customer repetitively 20, 30, 40 times, etc. with only the serial number changing. I've thought about building a FM file with the number of records= the number of labels, filling in the fields thru a script. How do I handle the serial number. I'd really like this automated as much as possible. Does anybody have a better idea? Thanks. Steve.

I have a runtime file of FileMaker which I hand it out to many guys of the Sales team.They have a Pwd which I preset for them when I send the runtime file to them .They want a user name which is there sytem user name or windows user name to be displayed when they click on the runtime file to open it.They have now a pwd,they want a user name along with it to be displayed which is there Windows User name.Please help me on this.Thanks in advance.

Portal Navigation Does anyone know of a good way to navigate through successive portals within the same file? I have a file of parts. Each part can be made up of other parts, which in turn can be made up of still other parts. When a part is ordered, the number in inventory must be deducted for itself and for all its sub-parts and their sub-parts and so on, however many levels deep it goes. The following wouldn't work, but if it would, it's what I'm trying to do: Script: Deduct Items code: Set Field [ Qty_In_Stock, Qty_In_Stock - Qty_Ordered ] If [ IsValid( Sub-Parts::Part_ID ] Go to Portal Row [ First ] Loop Go to Related Record [ Sub-Par…

Hi... I make my Script to recognize the user to work in the database but just I can make 2 Nivel Acces and I need all my passwords and Groups, they are in FMP, can I make this with my script?? Thanks for your help

Is there a way to get the current time? like a clock? i would like to have a script that runs at a preprogrammed time. like every day at 9:00am the script will run. so if i cant get the time can some one point me in the right direction of how to make this work?

Hi all, Is it possible to execute the script when layout is changed, is there any event like that where we can specify it ? The only way, I could find out, was not allowing users to change the layout and use buttons and assigen them script to change the layout and run the script. But is there any other way too thanks Aditya

Hi, I'm using filemaker 3 on a Powermac 7300 under 7.55. I'm gradually learning scriptology. I am creating a database, where I can keep track of people and write encounter notes about each person. For security reasons, I would like to lock the text fields to not allow any modification after a certain time or date (i.e. no field modification on a note about a client after 24 hours or after I click a button shortcut). The field is a text field that I have typed about a client. I know that this is possible, as I have seen commercial demos with this feature, based on FM3. I can't find a reference as to how to do this. Thanks in advance. [email protected]

I leave my files pretty open so my customers have a great deal of flexibility when using my software. I have navigation system of buttons that take them from one level of the program to the next. There are menus with buttons they can click to go to the layout of their choice. Every layout has Main and Sub buttons that take them to the Main menu or to the one they were just in. In addition to this I have an alphabetized layout Index of Layouts they can go to from any layout and then click the button for the next layout they want to go to. I thought it was pretty handly and worked for both right brained and left brained folks. :-) Lately I am getting requests to have …

Seems to me that FileMaker announced that 20 new script steps would be web-accessible via the built-in web companion. I can't seem to locate this list anywhere. Any help? thanks. [email protected]

We have recently upgraded from 5.0 to 5.5. I have found that you cannot copy a field and paste it in Layout Mode. When the field is pasted, it is treated as a graphical image. This seriously affects our design productivity. Is this a bug found also in the Mac version? Does anyone have a workaround for this problem, and has anyone heard of a fix in the works from FM? Thanks a lot - just thought I'd throw this out there for those of you who have not yet upgraded as a "heads up."

I need to have my serial numbers update with a special designation at the beginning of a particular record. I have several categories of video tape that need to be put into a database. We would like the different types of tape to be designated with a certain code at the begining such as DV- for DV tapes and MINI- for MiniDV. I deally the client would like to be able to select the type of media either from a radio button or a pull down menu, at this point the serial numbering system would auto update the beginning designation to reflect the type of media selected.

Hi Experts, I have two databases, I want to perform the find request in one database based on given conditions and want to populate the fcount of found records in second database. Whenever I try this everything works fine but instead of populating the records found in first table I get the records in the current table. Please help me Thanks

I am doing a database for a dinner theater. it is split up into two databases. the first has; location of show, date, time. the second has all the customer info, along with related info from the first DB(the cust info db has pulldown menus of the choices of location, date, etc..). I also have summary fields to keep track of people attending the show(along with a few other sumarys). as it stands now, when i do a find for a paticular show, the summary fields are all correct in what they show, since its only caculating the matches for that show. What id like to do, is make a script that will run down each of the shows in the first db, use the info from each field, and u…

Hi, I am hoping someone can help me out with this caculation I have a db with a number of different layouts. One is for xx part numbers and the other is for yy part numbers. I have a button that brings you to a list view layout of both part numbers, since these are both in the same db. From here I want to let the user to be able to click on a details button which will redirect them to the part number selected ( and the key issue )have it be directed into the layout for that particular number ie. in the list view you can: -click the details button for part number xx-123 -have the calculation direct to the xx layout. -and from there you can make chan…

Hi all, Is there any way I can create my own function in FM. I have a very long calculation and I repeat that calculation in many files and many fields, although I am writing same code each time whenever I need that calculation. I tried but could not make out how can I create my own function. Any help in this direction will help me a lot. Thanks in advance.

I am running a website for a business and we are trying to allow a search by product manufacturers names (i.e. GM, Chrysler, etc...) The question I have is I have over 100 manufacturers to choose from all laid out in a table, each cell has the name of one particular manufacturer and it links to our inventory of their product Now say I do not have any GM cars, is it possible to make the cell on the table and the text link that it contains only appear if certain conditions are met, namely that GM is in the manufacturers field and that the GM records in the database are marked inventory. Is this possible or would I need to set it up to either display or not display a g…

quote: Originally posted by BikeBoy: Hi everyone, I wrote a script, that is supposed to loop through the records, and insert dummy line items where needed. My logic is to first loop through the employees only within certain company, and then loop through all records. The problem is that this script sometimes works and sometimes doesn’t, and behaves very naughty. Lets say I have following fields: Company# (Text) Employee# (Number) Company Count (Global, Text) Created? (Number) Here’s the script: Sort[] # sort on Company# and Employee# Go to record[first] Loop Set field[“company count”, “Company#”] Loop Go to record[…

As there was no reply to my last topic, I'll try and make it more straight forward: Does anybody know of a way to define the 'sort' script step other than by first performing the sort and then setting the 'sort' script to restore? Any suggestions very much appreciated. Gabriela

I have a Problem in which I have to Print a repeation field each which is a combination of many other fields,so its a big field,it will come to an entire page,so even if I enter one of the rep fields and remaining blank it will go and print all the blank fileds.Hope my problem is clear.I want not to print the fields which are empty but only the one which have data in a repeation field.Please help.Thanx [ July 13, 2001: Message edited by: Jacob ]

I am creating a database for our production line. One of the features that I need to implement is the capability of the operator to click in a field and hit an increase or decrease button. I have about 100 fields right now that the operator can enter numeric information. How do I get the script to recognize the "chosen" box at the time they hit the increase or decrease button? Thank you in advance.

Hi. I'm making a db, and my boss wants to receive an e-mail with the new information entered into database as soon as it is updated. Is there a way to make a script, which would grab the information from the new entry and mail it when the client hits the "Submit" button? Thanks a lot, Luka

I know this is possible and simple, but for some reason I can't get it to work. I have two dbs, A and B. I have a key field in B that I would like to set via a script in A to create the relationship. Therefore the script in A says: Run external script in B (which creates a new record) Then it says to set the Keyfield in B with the value of the Keyfield in A. The problem is that it doesn't work. Maybe this isn't possible or maybe I've made a mistake. Any thoughts?

Is there a way to format text (make bold or italic) within a calculation? I have a calculation which compiles a list of entries from a number of different fields and I have placed a "name" in front of each entry (the calculation only compiles fields that have data in them). I would like to make the "name" bold. Is there some sort of formatting code that can be entered?

Hi, i'm new to scripting...well new to FM...anyway, I have a database with a quantity field and a form on the web that allows the user to remove X amount. Now, I don't want the quantity to be edited, but instead the result of a subtraction. Would calling a script be the right direction?

Hi everyone, OK, here's my question. In database1 I have created a layout in which users can search for records associated with a particular species of insect. In another database, database2, all of the insect species are cataloged and contain additional information concerning the insects biology. What I would like to do is enable the user to search for a species in database1, and then access the biology info on that same species in database2 by using a scripted button. So far I have figured out that this would require copying the contents of the species field from database1 and pasting them into the species field in database2. At this time a subscript in database2 coul…

Hi, I cannot find the "perform External Script" in either specific button, or other place. Thank for your help!!! Kent

I need to generate 3,000,000 random unique numbers, each number in a separate record. I can set up a loop to create new records and exit loop when the record count reaches 3,000,000 based on a sequential number field. What is the best way to generate the random/unique number though? I would prefer to do this in one pass, but if necessary is there a way to completely randomize the records then use a second sequential number field so I end up with a sequence control number and a random number?

Hey All, Quick question, is it possible to set more than one checkbox in a field with the SetField command? My value list has 3 options: Mailing list, Lead, and Client. The Mailing list option is always check but I also need to be able to set either Lead or Client when the script is run. Any ideas? Thanks.

Is there a CDML resource guide on the web anywhere? Thanks

I am getting the following error when attempting to delete a field - FILEMAKER PRO caused an invalid page fault in module KERNEL32.DLL at 017f:bff9db61. Registers: EAX=c00309c4 CS=017f EIP=bff9db61 EFLGS=00010212 EBX=0541fe28 SS=0187 ESP=0531fdf4 EBP=05320090 ECX=00000000 DS=0187 ESI=00000000 FS=8477 EDX=bff76855 ES=0187 EDI=bff79198 GS=0000 Bytes at CS:EIP: 53 8b 15 e4 9c fc bf 56 89 4d e4 57 89 4d dc 89 Stack dump: Reentering the file after this error gives a 'closed improperly' message , then on the second attempt to delete the field I get the file needs to be recovered message. The field I first attempted to delete was a calculated field - I can…

Hi, I am new to script but found it very much interesting. I have two questions that I can't solve from Help or Manual: 1. I want to combine a few text fields in a database1 so that I can copy the combined text into another field in databse2, how can I combine text? 2. I managed to copy and paste the text of a field from one database into another, but when I need to add the text into the field, I want to add into the field but not clearing out the original text in the field (becuase it's a field to hold both historic and new notes of communication). I also need to add the new text at the top of the field but the default in FM will add the text at the end. Any trick in …

G'day, Feel like a Galah however I need to kick this problem into touch before sundowners this arvo. Could someone explain the following which I have cut and pasted from another post. (Tried that UBB stuff but was out the back with a didgeredoo). It would help a lot if I could have the lil nipper version as obviously I have a lot to learn WRT jargon & FM "Actually you're close to what my other method would be, which is to use what I call a relationship pipe. Basically, I create a relationship such that it is never valid. In my local file, I use a constant field set to 1, and in the foreign file I use a number field (usually called Temp_Relationship) set to auto ent…

Hi, I'm new here and am thinking about using FMP. I am a little confused about this product though. Can I design an html page that will "talk" with my FMP DB using SQL commands or do I need a separate SQL server? I've used Alliare's Cold Fusion before and was wondering if these two products are similar. Thanks.

Is there a way to show the sort order on a layout without having to type it in before I print?

G'day, Some assistance please. This subject has been covered a number of times in this forum. (Went thru 10 pages and found at least two hits a page) However, despite printing out a number of relevant posts, I am unable to apply the information presented. I have a database "Flight Data" which records ten or so parameters. These are identified by a auto entry sequence field (no modification allowed). I want to transfer this auto sequence number onto a minimum of three and upto five seperate File layouts ("Landings", "Route", "Instrument Flight","Fuel","Oil").A single flight may involve mutiple records in "Landings" (due to different Locations) and "Fuel". Any ideas? S…

I have a question. I have a messagebox if user clicks on something wrong. Then I have another button clicking on script to duplicate the record. Problem is when I use status(currentmessagechoice)=1, the status changes depending on if the user clicked on wrong button or not. Does the the status(currentmessagechoice) keeps incrementing? It works when I don't click on the wrong button. Help!