Script Workspace and Script Triggers

I have a file that contains a coded field for identity of an event (in the case I have, I need to distinguish between the code PCN, and other codes that may be PCN1, PCN2, etc.) The records also contain a Date of Event field. I want to find the records that exactly =PCN, and that have occurred in the past 6 months. I created three calculated fields each specified to return a text result: (1) Six Month Today, defined as DateToText(Status(CurrentDate)) (2) Six Month Date, defined as DateToText(Status(CurrentDate)-182) and (3) Six Month Range, defined as Six Month Date &"..." & SIx Month Today The third field then returns (for today

Hi All, Does anybody know of software or other "trick" to map the ENTER key of a usb numeric keypad to act like the standard keyboard numeric keypad enter. (i think it's behavior is CTRL-ENTER instead of just ENTER) My IBM USB keypad does a plain "enter" on my Dell laptop!! Thanks for the help. --Dan

I'd like to generate the "Top 10(or 20, 30,...etc) Bestsellers" from LineItem DB given date ranges. Working with date range is fine but I can't seem to figure out how to sort the Top (10,20,..30..etc) items. How do I sort through the summary field "_SubTotal" and Omit records? Thanks in advance.

Hi All, Any ideas on how to speed up calcs??!! I added 3 calc to my app and just slowed everything down!!! They are some time calculations (elapsed time to get duration of events). I think it's because the "new" calcs use calc fields themselves. Is that possible? (one set of calcs needs to finish before the other can process) Also i use some TimeToText function are they known to be slow?? A couple of If statements & Case statements. Thanks for your thoughts --Dan

I need a script that replaces blank fields in a repeating field of 15 with a "-".Does anyone know how to do this ? Thanx

Is there any way to automatically re-size a layout depending on what size monitor it's being viewed on? I'm making a database that will reside independently on a number of different machines. No server, no Web. Any thoughts would be appreciated. Thanks.

Hi there, just want to ask how to perform a cancel or rollback function in a file contain portal, let's take the example, files invoice.fp5 and lineitem.fp5. The invoice.fp5 will contain a portal link with lineitem.fp5 which can let user to key in item information. If i delete the item on the portal, how can i perform cancel so that it will change back to normal. Regards, Henry

Hey there, Is it possible to generate a report that will ignore lines that contain blank fields? I have a DB with records that contain a project number and 4 different fields of billing codes. I'm trying to generate a report grouped by project # => date => billing codes 1-4. The way FM does this now is by grouping down to date and then laying out billing codes 1-4 across horizontally. I'm trying to get Billing codes itemized vertically under date,which is easy enough but these fields aren't always populated which causes a high amount of white space on my reports. What I'd like to do is have FM ignore any lines with fields that are empty and then shift th…

Hello everyone. For my first post here's something I've just encountered. When in a portal you have a text field with option "auto enter calculated value", a script including script steps "Loop, Go to portal row, specify next, [exit after last]" does NOT actually exit. It will just get you the spinning wheel and a corrupted related file. The reason is, the script never meets a very last ported record, because each time it selects the last row, a new record is created by the auto-entering of the calculated value. It seems this doesn't occur with the serial entries. Tip: starting by the last but one row with "Specify previous" works fine.

Hi, I have the following script which is supposed to create a keyword list from a long text field. Where it is failing is that certain times either a letter or series of letters, not only comes up to be replaced in the text, but also comes at the end of other words in the text. For instance, I have the script replace the word "MB ", but then when "dumb " appears, it becomes "du". Eventually, if the text is long enough, it all starts to deteriorate, since then "du" is a two-letter word to be deleted, and so on, until there's little but garbage left, not keywords. Here's the script: Go to Record/Request/Page [ First ] Loop Set Field [ CommonWords_Holder, C…

Can anyone point in me in the right direction - I have a task.fp5 db - in a defined field "status" a value list of "Yes", "No", "In Progress" is linked to it - when "Yes" is selected for the record I want to instantly omit the record from the list view How do I go about this

For background, I've created a multi-page questionnaire with a script attached to a button on each page to determine whether the answers given are "correct" and therefore allow the user to continue. If any answer is wrong, then the questionnaire terminates itself. This has been working fine, except for a couple scripts that always evaluate the IF criterea as False, even when they are true. The result is that on those pages, regardless of the answers given, it will let you continue with the questionnaire, even if you shouldn't be allowed to continue. I'm stumped as to what's going on, since I have basically been duplicating these scripts and just changing the field names t…

I have a dB set up for my all of my clients. Each time they order a product, I can print off a label for each record. Now, suppose they order 19 units and I have to print off 1 label for each unit. Now, suppose I have 20 different people that all need 19 units. I would like to be able to enter in a quantity of units for a certain group of clients and have FM print off the number of labels that I need. Is there a way to ask FM to copy a record (client info) into a new dB, then duplicate it as many times as I need? Then, do the same for the remaining people. In theory, this new dB would only contain all of the records I would need for this round of shipping (assuming …

Frustrated Funny Fellow Feeling Flabbergasted - say that Five times Fast... I really felt like using another word that starts with "F," but instead I used all of the other ones that came to mind. To those out there who know what they are doing and have a few extra minutes to lend a guiding hand to someone in desperate need, I would appreciate it, big time. This is such an easy problem to solve and, for that very reason, is why I am driving myself CRAZY. I just can't see the solution. I don't know file maker pro, but I have figured out a lot in spite of this problem. My boss fired the only person who knew how to run our File Maker Pro 4.0v1 and appoi…

I would like to set a client password that when logged on by the client they only see that particular clients records. (The db currently contains many other clients records) How is this best done?

I am trying to sent a simple email (just populate the address) from FM 5.5. My default client is Outlook. I have a button with the Send Mail (without dialog) script, but when i click it nothing happens. Outlook is open and running ok. I'm new to Windows, and am not sure if I need to configure Outlook. FM help gives this information, A [Mail] section in the Win.ini file. Microsoft Exchange or another email applications that is MAPI compliant installed and configured properly I presume that Outlook fits these requirements? Ger

I am using NT4. I encounter problems with the Send Mail step not working properly (i.e., not attaching file or sending mail) when I tell it to attach an Excel sheet or even a .htm containing an Excel sheet. I get the same results with v4.0, v4.1 and v5.0 of FM. The only workaround I've found is not a good one at all--perform with dialog and manually attach. What am I doing wrong? ddort

Hi there, I have a problem with summing the content of one text field of several records in one single (global) field (all of the same database). I have one database with a field named Products. When I perform a find based on a certain criteria, I receive x nr. of records. I would like to copy the data of the field Products of all the found records into a global field, so that in the end I receive a list separated by a return ("

I have just purchased filemaker 6 and I have been told that phorographs in container fields can be exported. Unfortunately I have as yet managed to successfully export anything. I imagine that the export will be created by a script but unfortunately I am not sure how to do this. Any help would be greatly appreciated.

Hi I don't really know what I'm doing but I've managed to bumble thru and make a little project manager that I'm reasonably happy with except........ I have a database of "Projects" and a separate database for "To Do" stuff When I click the "To Do" button (in Projects db) its supposed to open ToDo db, relookup related fields in Projects db and find tasks and omit tasks were progress = 100%. In other words uncompleted tasks in proects db = To Do. the trouble is it won't update and show new tasks I have entered or remove tasks I have set as Progress=100% I realize it is difficult to picture exactly what i'm doing so I've attached the whole mess if anybody has the ti…

--- or maybe it's me who is very simple. In my properties database, I have a "find" layout set up so that a series of records (for which you already know the property ID) can be located and displayed in a list report. I've already got a self-relationship called "multi-key for find" and there's a global field on it gPropertyIDs into which you can type: 1286 1157 etc (with a carriage return between)and then a "find" button with the script below: Set Error Capture [On] Allow User Abort [Off] Go to Related Record [MultiKey for Find] [show only related records] Set Field [gError, Status(CurrentError)] If [gError=400] Show message [button…

hallo! probably someone has experiences with that. i

I have a script that goes like this, send male, pagemaster, the send mail needs to look at email fild and if anything is in the email field send mail, but if email is empty it needs to look at field alphnum and if any info in that field use pagemaster. also i need to place a 1 in my flag field if email is sent and if pagemaste is used to place a 1 in a different flag field, this is done for sorting purpose. the problem is i cannot seperate my flag fields when send mail is used or pagemaster is used. thanks

I need to be able to search date fields for the current (today's) date and also be able to tell if there is no date (the field is blank). A little help would be appreciated. Thanks I am using perform find[request] and manually entering the find. Ken and Lee where are you...

need some help please, I have 5 fields in db 1-message,2-closed,-3-will call back, 4-on property, 5-patched call. I needs to be able to have a count for each field and a total. I use these numbers for billing, after i have printed the monthy report i will need to 0 out the subtotal and the total to 0 to start a new month. thanks

I have what I thought would be a very simple task. The last step in my startup script is to run a zoom window script which goes to Layout#1 and then sizes it to the correct size using the toggle window (zoom) I have built the layout#1 using the usual tricks of placing hidden lines at the furthest right and lowest points of the required window size. In fact the zoom script works perfectly - It resizes the window exactly as required. In fact if I run the startup script from scriptmaker then it also zooms perfectly BUT..... It DOES NOT ZOOM CORECTLY WHEN I OPEN THE PROGRAM and the startup script runs automatically - The window only zooms to half the required screen…

Hi all, What I'm trying to do is insert a new record immidiately after the record on which my condition is based. The script step "New Record/Request" seems to be appending the new record to the end of the file, then I need to go back to my previous place in the file. It's like this, I have a long column (73 rows) of numbers, like: 1245323 1245342 12453710 etc. The first 6 digits are OK, but based on the last number (3, 2, or 10, etc) I want to create new records, and print the numbers spanning from 1 until the existing number (3, 2, or 10, etc). for instance: 1245323 1245322 -> newly created 1245321 -> newly created 1245342 12453…

Using FM6 I have a file that can contain one or more records with the same key. I need to concatenate one of the fields in this file into a single field for display in the related file. I'm not sure exactly how to do this given that the number of records is different in each situation. It doesn't matter which file the concatenation happens in as moving the resulting field to the master file isn't difficult. Any suggestions on how to loop through a number of iterations when the number of related records varies? Thanks, any help is appreciated!

Hello. I have a FM database on the web and I need a script that will go into the Updates field, click at the start, insert the date and a " - " and then let the user insert his weekly update at the top of the list. The problem, of course, is getting the insert at the top of the list rather than at the bottom and then placing the cursor after the new line at the top (currently it jumps to the bottom of the list). It would be a nice touch if, at the end of the update entry, the script would add "<br>", but I'm not looking for miracles! Anyone know how to do this? Another nice touch, if it's possible, would be to have the user enter his login just b…

I have an Access database that I've created but need to move it into filemaker. I have most of it created, but need help with my monthly report. When I run my report in Access It asks for the date range. It then gives me all the accounts and the detail for that range. I have a subreport imbedded that gives a total of all prior entries as a beginning balance. I then add the beginning balance and the range detail for an ending balance in the group footer. How do I recreate this "subreport" for the beginning balance. Can someone point me in the right direction? Cin

Greetings, We have a database with multiple scripts that are accessed by clicking buttons on the layout. The scripts have different "FIND", "SORT" and "PRINT SETUP" criteria. The scripts work fine the first time. After that, each time we use the scripts the above settings do not do what we want the scripts to do. We've tried using the "KEEP" and "RESTORE" settings in the "Script Maker" dialog box differently but that doesn't seem to help. Does anyone have a suggestion? Cheers

Hi, I have a Phoenix 2 barcode reader, and I need FM to send a message to this bcode reader; this message will tell the bcode that an error occures in the script, and the barcode will do a sound, to confirm this error( this because who will use the bcode scanner will be far from the computer, and the internal sound is too low). Can anybody help me? Thank you all!!

Does someone know how to use DDEExecute to send a command to another application to execute a series of commands available in that application. The other application is excel and I also need to execute a macro in that excel file. The idea is as follows: I have an address filemaker file and I need to export the records to an excel file. Then this file should be open by DDEExecute command and an excel macro should be activated.

Okay...I'm rather new to this, so I need all the prompts I can get! I am a teacher trying to create a database for my students, all who have failed some part of the Alabama graduation exam. Basically the information I have received from the state consists of 5 subject areas: social studies, science, math, language, and reading. For each subject there are between 19-24 objectives (like social studies objective V.1 might be the causes of the Civil War and V.II might be the effects of the Civil War). Now I have 70 students times all those objectives and that leaves me with about 2-3 thousand records. I have already created a database "ge_scores" in filemaker,…

I have several records in inventory.fp5 that I want to link to invoices.fp5 by invoice_id. I want to be able to run the script to do this within the database purchase_orders.fp5. The records in inventory.fp5 that are to be updated with a new invoice_id must satisfy two conditions, 1) inventory.invoice_id is blank, 2) inventory.project_id = purchase_orders.project_id I've never had to update fields within multiple records using filemaker before and I'm not sure how to go ahead with it. Thanks for any help.

I'd love to incorporate the ability to go back to a "last page viewed", if that's possible, without hard wiring the button to a specific page. Is this possible? Navigation similar to a website? Thanks

Here's what I need: I need to end up with a list of donors who have not donated in the past 12 months. At first I used a calculated result that can grab the records (via the "date of donation" field) older or newer than 12 months. But I need to use that found set to eliminate everyone (by a unique donor id) who hasn't donated in the past 12 months. I have assigned each donor a unique id called "donor id" and I believe I need to somehow incorporate this field in order to eliminate those donors who have given in the past 12 months, leaving all the rest who have not, but I can't quite put it together. Any ideas would be appreciated. Thanks

hi! i

Hello, I have imported data which includes a 12-hour time field. The imported data is not referenced as am or pm, but they refer to business hours, so the times always refer to 9am ... 6pm. I want to sort these into correct chronological order. Sorting ascending puts am times like 10...11...12 at the end of the list. I don't want to work with 24-hour time. Is there a way aorund this?

Okay I have our guys putting there pics in pictures file but they've already named them. Then they open Sales and create new record for the sale then I want them to do two things. rename picture same as new record and they can't do that until they've created the new record then they have to switch back to picture and rename it before they inser it, darn. and click a checkbox saying that only a 'rference' is stored. They neglect to do both regularly. And I also know they sometimes just paste the pic and I don't want that. i want the pics named unique as ID record for imports and other stuff ive probably not even thought of but it seemed a good idea and maybe cu…

I am having trouble opening a specific file then going to a specific layout. As far as I can see, I can only the default, or original layout after opening a file. I want to be able to open a file (after clicking a button) and go to a SPECIFIC layout. Can this be done?

Hi How do I go about setting a script up to search for work that is required for tomorrows date. I would need to search using two fields I have created, Date Required and Cust.ID. Any ideas??

Hellow everyone on Forums, I have a problem. I've created several buttons with scripts and some of them don't work right. I really need some help figuring out the problem, please. User creates a new record by clicking a button. If, instead of working on new record (which requires the first field in tab order (Division) be filled in (via Validation Not Empty), User instead clicks the Menu button, nothing happens. No error message that Division can not be empty, nor does it run the Menu script. Two of my buttons (if clicked immediately after creating a new record) will produce the Validation error message (delete and list scripts) just fine. But three of my butt…

Hello Gang! I was just wondering if this is possible and if any of u have have some experience: Based on a condition or a field value to place an object (button or image) in the layout - on the specific position?! eg. using a coordinate system (x,y) =========x | | | | .........X pleace an image on loaction (10,5) It does not have to be an image....perhaps an FM design object such as a line or a square shape.... any thought?ideas? Thank you all!

Hi All, There is probably an easy way to do this but i can't think of it. I have a db with dates all sorted by ascending date order. When i create a new record (enter a new date) i want to re-sort my db and point to the newly created record. (Which might not be the most recent date ie: Goto last record does not work) I tried doing a find, but that only gives me one record in the found set so the user can't navigate to other records. I thought of comparing my "new" date with the first & last date to determine if i should use a loop that goes to next record from record one OR start at the end and loop to previous record with exit when newDate m…

Hi How do I go about creating a script that will perform a find on a particular cust ID for tomorrows date. I will need this script to do this on its own twice a day at say 12.00 and 4.00 and export its results as html. Any ideas??

I ought to post this to the Filemaker Cretins list, but I can't find it... ;-) I don't know why, but I'm having a hard time figuring out how to attach a script to a button to activate a popup menu. (Yes, I'm a total beginner.) Given a custom value list called Skills, a field called m_skills formatted as a popup menu, and a script called SkillsPopup_1 (out of 15), the popup menu works when one clicks on the field, but the button does nothing. Is there a specific order in which I should've set up all of the above? Am I missing a step? The script goes like this: Exit Record/Request Go to field [select/perform, "m_skills"] Thanks. dolphy

I created a runtime solution with FileMaker which performs an XML import using the HTTP request to another FileMaker that has Web Companion enabled. The problem that I have is that the FileMaker app that I created, when I perform the script within FileMaker, the import works perfectly without any problem. However when I created the runtime solution and ran the script for the XML import using the HTTP request, I got an error of 711 which is "Import translator can not be found". How do I get the "import translator" being mentioned included in the runtime solution in order for the solution to work? Is it possible or am I forced to have to run my solutio…

My scripts were working fine until late yesterday, when I continually started to experience error messages when opening any and all external scripts in another filemaker file, resulting in a crash every time. I tried uninstalling and re-installing, but still the same result. The errors are in the following files: CLLNGENU.DLL and MFC42.dll Any info would be appreciated, becaue it's brought my progress to a standstill. Thanks Todd

I can'T get the lookups to work with FM 5.5 It was so easy with the old version of FM. Anyone has a good link or document to explain how the relation works now? Thanks guys

hello!!! Is it possible in Filemaker to capture a keypress event? I mean, can a script run only by pressing a key? I know that a script can run only by pressing buttons, and I need to run a script only pressing the enter key, because I use a codebar scanner, and I want to run a script after I have scannered a codebar! I hope this is possible... Thank you all!!! p.s. excuse me if I made some errors in the text...

Hi All, I thought using the "Esc" key with Allow User Abort would make it possible to halt a looping script that runs in a portal in browse mode. After testing i know i was wrong!! Any ideas?? I tried trapping the error # 1 (user cancel..) but that does not seem to work either. Thanks --Dan

Hi ! I need to pull out records from a database based on professor name. I have created a layout for that so when the script is executed I will get the professor names in that layout. But the problem is I dont want multiple records. The mySQL query could have been something like: SELECT DISTINCT(prof_name) FROM mytable WHERE 1 Could anyone please help me how to do this in Filemaker ?

I'm trying to use the IF function to trigger one of two scripts. Currently, I have: IF [isEmpty(Field 1)] Perform Script [script 2] ELSE Perform Script [script 3] End If Scripts 2 and 3 work fine when I trigger them independent of the IF function, so I know that it's a simple case of my IF script not working. Basically, I want it to look at Field 1, and if that is Empty, trigger script 2. If field 1 is not empty, it should trigger script 3. Help, please! Todd

Hi All, When running a script does the Status(CurrentPortalRow) "stay" updated?? I am trying to use this in a script to see if the user has clicked outside the portal (CurrentPortalRow = 0) to stop a looping script. It does not work my script is stuck in a loop, if i click outside it just resets my script to start processing from portal row 1. I also have the same type of question for Status(CurrentFieldName). If i am in a portal on field-a when my script starts & TAB my way to field-e the Status(CurrentFieldName) function still point to field-a. Why?? Thanks --Dan

Hi, I'd like to make a button on a layout that a) enters the Find Mode, allows you to select a value list item from a pull down menu, and c) automatically returns the found results, without one having to press "Find" on the status bar or having to hit the return/enter key. I saw something about a calculation involving the carriage return operator in a recent post but I couldn't follow it. Thanks, Lee

OK, I can't find somewhere that it's already posted how to do this . . . I'm trying to automatically set the age of a person on a set day by entering their date of birth. The calculation I figured out that isn't working is: Focus Group::Focus_Group_Date- Respondent_Date_of_Birth I know why it isn't working -because I'm subtracting the serial number assigned to the date and not the number date, but I can't figure out an alternative. I tried searching for a previous post, but I can't find one. Can anyone point me in the right direction or help me come up with a formula that works? Thanks all!

1- how many fields can you use in a db/file. 2- how may scripts can you use in a db/file

Hello everyone. I am developing a pretty extensive filemaker solution for a church and they do not want to be forced to use the mouse during data entry. Basically I want to create a new record without having to use the mouse. I also have a verification script that I want to run to verify if two calculation fields match. Is there a plugin that does this or a way to program the function keys to do this? I know I can leave the scripts under the scriptmaker menu and use Command -1 etc. but I was wondering if there was another way. Thanks in advance. PS. I really appreciate all of the great feedback. This forum is very impressive. Regards, Adrian Mcma…

Anyone know how I can make my message box auto resize? I'm putting some 'help' buttons on my various layouts to aid users for the different functions. Each button has it's own script that's basically a 'show message' and the message. Some of my descriptions for the things are a tiny bit too long, and they hide the text unless you resize the box (which no one will think of doing). Any help is appreciated!

Hi everyone, i have built a bibliographic database, and i would like to export records from it (one at a time?) and insert them directly into say a Word document. The exported record should have an RTF format (Author, Title [cursive font!], Place: Publisher, Year Pub). Does anyone have a good advise on how to do this (in FMPro 6 / MSWord 2000)? (Eventually, i would also be satisfied if I only get the RTF (!) record on clipbord, and paste it later manually in the Word document). Thanks!

I'm trying to use a layout like a warning box. I need to use a layout so that I can have a couple buttons to perform a script depending upon the users choice. I am trying to have the layout open in a much smaller window than the full layout and then when exiting return to the full layout size. Can anyone tell me how to do this?

Hi, I have a bit of a silly question. When I first started developing my database I didn't really know what I was doing, especially when I started using scriptmaker. Now I have made my db larger and have heaps of scripts.... But is there a way to print out a list of all scripts in a file and where(if) they are attached to, as I don't know if all my scripts are in use (some of them may have been testers), but don't want to delete anything in case I have got it attached and doing something important and have forgotten.

Since i have a bunch of stuff that's automated, i'd like to create an error log. Something that basically after a script executes (or fails somewhere) it'll add an entry to the log. I'm looking for ideas on a quick and easy way to do this. Fields wanted Add date and time Current Username Current Script (is there such an action or do i have to do it manually) Current Error (i'll have a related DB or error codes) And what's the best way to do an add? Relational with a common file? THanks -ja

I know this is probably simple, but I can't quite get it.... I have a script that copies two date fields to a global text field. I'm using a text field because I need to separate the two dates with "..." in order to do a "between these dates" find in date fields in 3 other files. The problem I'm running into is that if dates are entered as single digits (1/1/2003), the finds do not produce exact results. I tried to fix this by formatting the fields to represent as 2 digits (01/01/2003), and while they display correctly, when the script goes to copy the date field, it copies it as originally entered, not as formatted. I need to add the "0" before I paste the dates into the…

Hi, I want to count records grouped by the value of a field. So the output should by something like value1 12 records value2 20 records value3 1 record ... How should I do this ? Thanx for your help

Hi All, Is there a way to allow users to design new layouts... (lists & forms) for printing only? But at the same time not giving them access to the ones already created? (that way i would know that the original lists & templates are protected) Thanks --Dan

I have about 100 scripts that do various tasks. My client has just asked me to incorporate an additional field that tracks an attribute of my database. In order to do this I have to adjust the new field in almost all the scripts I have. The "adjustment" requires that I do an IF statement that has about 3 lines within it. Is there a plug-in out there that will allow me to copy the 5 lines of code from one script to the next? You know, Highlight-Rightclick-"copy"-next script, Insert-Paste (windows users). This is a huge deal for me if I have to rewrite the same code for every script...."AHhhhrg"

I am trying to make a simple address book. There is one layout that captures all kinds of data about this contact. We have their email address, home phone, dog's name etc. A second layout is in columnar format and has a field which concatenates first and last name + phone number. I would like to add the alphabet script at the top of this layout. When I hit the letter "C" it should find all the permutations that start with the letter "C". I would like to be able to do this without having to re-enter criteria into a find field. Is there a way to script repeatable finds? Thanks, Jarvis

Hi All, Is there a way to test (see) what the system date format is?? (yyyy/mm/dd, dd/MM/yyyy or even in french: aaaa/MM/jj etc.) I was able to test for language, but the user could still have a different set-up for dates. Also if i want to add 6 days to a date, will the system format affect how my calculation is done?? (date + 6)--> or will this give me 6 months or 6 years later depending on the system date??!! Thanks --Dan

I have a form action tag that I got through PayPal and it is supposed to go into a html page. I wonder if it is possible to assign this form action tag to a URL scriptstep button, so I can go straight to PayPal based on the values from the form action tag? I know I can assign an URL to a html page where the form action tag could be placed, but I would like to exlude this middlestep. Thanks! ------------ Eh, I just saw that they offered an email link also. Sorry!

Hi all, I am new for filemaker. my question is, is there any scripts to change password? for example: I have 3 files, a,b,c all use same password for admin and user, so what i want is to find a script that will change the password automatically for all files. thanks in advance

I want to keep track of writers and photographers and their assignments for a newsletter. I envision a contact screen and an assignment screen. Then I want to be able to display the info in a variety of ways: by writer, by issue number, by deadline date, finished assignments, unfinished assignments, unassigned stories, etc. It be nice to be able to create an assignment in the application and email it to the writer but this isn't necessary. I have purchased FM Pro 6, but never used it. I know it's supposed to be easy, but why re-invent the wheel unnecessarily? It would seem that this (or something similar) has been written hundreds of times before. I've searched but can't …

I'm at a loss as to how to script this: I'm using two separate text fields with first and last names to find names in a database. Exact matches and close matches are no problem. I want to disable the generic "no match" window in Filemaker with a script that takes the user to a new layout when there is no match with any record in the database. I have the script built up through the "Perform Find" function but then I'm stumped. Should I be using a different kind of field other than text to perform this? As of now I'm pasting user-entered text from text boxes into the first and last name fields of the actual database records during a find and looking for a = match.

Is it possible to execute a script upon content changes in a field?

Need some help here! Could someone please give me an explanation of the "save relative path only" checkbox in the open file script step? I cannot find an explanation of this in any manual. Im sure this is simple but it escapes me.. Thanks Stuart

I want to have a script that will create a new record in a related database and put the ID in the ID field. I tried Copy Record Open ("RelatedDatabase") New Record/Request but this creates a new record in the database I'm in. And the RelatedDatabase flickers on the screen suggesting that somehow the script is touching it. BTW this will not be the only file in the RelatedDatabase with this ID. I'm storing multiple notes about the ID in the RelatedDatabase. The information shows up in the main database through a portal. I got this working (and it seems more complicated than what I want to do, but then it's not scripting). Can't be that hard. Seems lik…

Does anyone know how I might do this? Frequently, I want to create a complex search in a script, such as: "Find all records on 7/14/2003 with either status code of 7 or 8" In SQL-speak, this is easy: "Select * from FILEV WHERE ( ((MyDate = '07-14-2003') AND ((STCODE = '7') OR (STCODE = '8'))) );" But I can't figure out how FM's logic works on this.

Hi All, I use the field exit scripts as user types manually in the field and when users clicks outside (exit the field) the script automatically continues to run without clicking button "continue" at the left side and i am using pause/resume given by field value. I don't specify time duration since I don't know how long the user finishes type in the field. But I don't want people clicking butoon" continue" at the left side each time like that. IS there a way to achieve that? If you have an idea, I am really appreciated it. Anh Tran

How I can write in a text the qoute ascII simbol without filemaker don

I am trying to replace quotation marks in fields. The "substitute" function does not appear to work with this string: Substitute(City, """, "") I want to substitute a single quote mark in the City field with no character. Filemaker keeps telling me that I need an additional quote mark. I think it's reading the text I want to replace (a quote mark) as a quote mark used to surround text. Any ideas?

I am trying to find a method to: Take a quantity field in a Source file Use that field to make that quantity of records in another file So if the Quantity field = 10 I would end up with 10 records in another file I would also be using related information from the source file, another file and adding a unique serial # to each of the records(I'm fairly confident with creating serial # part of this) Thank you very much for your help.

Hi all I do not understand why the custom message appears in the script when the a welder record for archiving is found. The script is as follows: Enter find mode Insert calculated results: preform find If S_total>0 exit script else show message"No record for this welder was found" endif This message appears regardless what s_total is. s_total is define as a calculation field that result is number s_total = count(relationship:w_status) + count(relationship:o_status) + count(relationship:ov_status). Storage options for s_total is "Do not store calculatoins result- calculate only when needed. Storage options for the other three fields …

Hi All I search three db from a fourth db for inactive welders. I would like a message to pop-up when the search reveal that there are no inactive welders. I have made relationships for the three db to the fourth db and have tried using the status(currentrecordfound) function to have message pop-up. In the fourth db I have a define a unstored calculation field as such: w_total = O_status + W_status + OP_status 0_status has 15 records, W_status has 20 records and OP_status has 22 records This should give w_total a total of 57 records. But this displays 0 until a new record is added to one of the three db then it displays only the number in the recently used …

How can I perform a default sort everytime my database is opened? The "Sort" script step seems like the best it can do is repeat the last sort, but if the database is just opened, it doesn't remember the last sort. Also, what is the default sort order? Regards, EMC

Hi, I'd like to write a script which can open all files of a given name set, for example all files named 'abc*.fp5'. Is there any way to have wildcard expansion (or to read a directory) in a script? Thanks in advance! David

#1: Is there a way to copy scripts from the dialog box to post here or move elsewhere?? #2: I am using customer dialog box for a report, if I go to find mode before custom dialog srcript... does it then automaticly find those records???

I'm thoroughly stumped - here's what I need to have happen: On an extended column layout, I have a list of donors along with their donations. Each donor is automatically assigned a unique i.d. when their data is entered, so that all donations made by this person are connected by that i.d. What has stumped me is I need to show a "total donations" for each donor on the layout where all donors are visible. A summary function doesn't work, because that pulls up the total of all donations by all donors. A find function won't work either because that takes me off the layout. What I need to do is isolate donations by the i.d. field, but I can't think of a calculation script or a…

This is a little difficult to describe, so I hope it ends up clear enough: I have a database with the following fields f1, text f2, text f3, text f4, text f5, text G_Temp, global text Serial, a unique serial number RK_First, calculation containg "1" There is a relationship (FirstRecord) linking RK_First with Serial to give every record access to record 1. The database has two records. f1 through f5 in record 1 contains column headings f1 through f5 in record 2 contain random text. What I need to do is write a script that steps through the fields in record 2 and sets G_Temp to the data contained in the corresponding column heading co…

Hi, I've inherited a database to which I need to do the following: search for sales people find associated invoices display: sales person one their associated invoices (sorted) sales person two their associated invoices( sorted) sales person three etc. I'm fine with filemaker sorting, but any ideas on how to do this sub-sort and grouping in a single report? Thanks for any tips! Chris [email protected]

I'm not sure how to word this, but I'll try my best. I need a way to setup an interface so that the user can create it's own equation. This is what I need: Field 1: Name of equation Field 2: First entry - beginning price Field 3: Second entry - ending price Field 4: Fee Entry Name of equation [Field 1], if price < [field 2] but > [field 3] charge this amount [field 4]. Is there a way that I could set this up so that the user can enter these fields and create their own equations? So that at a later time they can select the name and have the equation already setup and run by itself.

This is probably a very easy question, but Im about to pull my hair out trying to figure it out on my own. I have 2 relational databases. Horse.fp5 and Horse Tasks.fp5. In a run time that I have compiled. Horse.fp5 opens up. From there, I want to take them to Horse Tasks.fp5 when they click a certain button. I have accomplished this much. But my problem is the window size and bringing them to the front. In short I want to know what is the proper script steps to change from one Maximized window to the next file being maximized and when they want to go back, bringing the other back maximized. Any help would be GREATLY appreciated. Thanks

Hi People! here is the scenario: -------------------------------------------- IF { condition_1 AND condition_2} OR{condition_1 AND condition_3} THEN GOto [Layout_1] OR [layout_2] --------------------------------------------- is this possible?shold I just make another script and separate the "OR"s condistions? thanx_again!

Is there a way to cause a script to run based upon some pre-determined value in a field. What I would like is if the field value = (X), run script (X) and if the field value = (Y), run script (Y). If the field value = something other than (X) or (Y), do nothing. Is this do-able? [

I am attempting to select records where a particular field falls between two dates (defined in other fields). Yet I can't seem to get it to work. I have used several different versions of PurchaseDate > BeginningDate and PurchaseDate < EndingDate inside an If construction. If this is true, I skip to the next record inside a Loop. It it is not, the record is Omited. Any suggestions would be appreciated.

hey all, I'm trying to relate two databases. One is a contact list, and the other collects information from 5 separate databases. So far I have created a button in the contact db that opens the other db. Now I would like to have a field in the "collection" db that shows selected fields from the contact list db, namely the name and address fields. The way I would like it to work is that when I click on the name and address field in the menu db, a pull down or pop up menu appears with just the names in the contact list. I would then select the name I want, and all the name and address fields for that record in the contact list db show up in fields …

Hi all, Is there a way to use the up/down arrows to navigate to the next/previous line in a portal and stay on the same field?? In Access i can monitor the keystrokes that exit a field and write proper code to go up or down to the next record. Do i need a plug-in to do something like that in FM 5.5v2 on a PC? I thought of a loop with a Pause/resume step then GotoNextLine but the <<Enter>> key generates a new line in my text field instead of re-starting the script!! What am i doing wrong?? Thanks --Dan Thanks --Dan

Hi all, does anybody knows a way to pause or wait the execution of a script-step for a short time (say 30 seconds)? I'm using a FM plugin that I call through external functions, but for one of those functions I do not get feedback if it is finished or not, neither can I test it (the plugin is controlling hardware), but I cannot proceed before it is finished. I thought putting a dialog in between to pause the script until the user sees the device is ready, but this interrupts the execution of the external functions. tnx hank

I have 4 fields, A, B, C, and D. Sometimes one or more of them is empty. I want to make a script that shuffles them around so that the empty ones are always last. That is, if A is empty but B has a value, I want to move the value to A and clear it out of B. Anyway, the caffeine isn't helping today, and I wonder if someone has a semi-elegant way of doing this, in a loop maybe -- but Exit Loop If ... what?

Hi, We have a number of different filemaker database files being created. We would like to store the file names in a field in a 'master' database, and have a button/script called 'open' which would open the filename specified by the field. Is there any way to do this? Thanks in advance!! David