Script Workspace and Script Triggers

To all, I have written a script for notes to post date and user name in the "notes" field, however I cannot have the next entry automatically entered at the top of the field. Which script command enables this? Thank you for your help.

Is anyone familiar with the problem occuring once you compile a Filemaker Pro 5.5 app. using FM Developer 5.0 under Mac OS 9.0.4. Using FM Pro 5.5 the scriptstep works perfectly with Entourage, in Runtime it fails totally without notifying an error,

I have a database that is "trashed" so to speak. I created a new one and have been copying and pasting layouts to it (I did an export on the original database to get all the fields). I want to know if there is a way to copy scripts to the new database instead of manually reentering them all. I'm using version 3.0v5 for the Mac. Thanks. [ November 20, 2001: Message edited by: Raschelle ]

Is there any way to identify the user group from the password entered at start up so that I can run a demo script that allows the user to evaluate the solution for 30 days. That way I can have just one version to update and not worry about updating both full version and demo version. eg: If Group = "Evaluator" or If Password = "Demo" (something like that) perform script ( initialize demo) else perform script (splash) Endif

Problem - trying to create a SCript which will automate opening up a file - however, when I put the Go To Layout command in box & then go to Specify drop-down box, the file I am looking for is not there - both files are in the same folder & relationship has been created between them. Thanks in acticipation Sean O'D

Hi, Does anyone know if its possible to get a link to a PDF file in a record on the macintosh? I have FM 5. Also, does anyone know how to make a keyword search across multiple records in multiple layouts? Im really stuck on this one! Thanks. kev_800

I have a script that when ran will print different record from different layouts. Goto record 1 Goto layout Print (Show Print dialog) Loop Goto Next record (exit after last) Goto Layout Print (Do not show Print dialog) Exit Loop Is there a way to allow the user to hit Cancel in the Print dialog and have it Halt the script. I have played with Current error status and have gotten nowhere. This may be amazingly simple but I can not figure it out Thanks for any help Brian

Hi! I really need help on this issue.. Will try to explain the problem short and clear. I have a database of documents. Documents are organized into categories. Documents can be categorized by types (just normal text titles, like "Archive", "Accounting", etc). Any document can belong to multiple types at the same time. List of possible document types can be extended dynamically by a user. So, I have soemthing like that: Categories -> Document(s) -> Document type(s) What I need, is for any category, to be able to get list of types of documents which are located in this category. Well, if for any other problem I could at least think of a way to solve it, in thi…

To all, Is there a way to script pop-up dialog boxes to allow user entry to submit to information, say in find mode, in scriptmaker. I appreciate any help in this matter.

I would like to create a "back button" to go to the previous layout is that possible? Ron Bascom

Here's the deal: Database Main has a script (actually many) that will ask a user to input a date. This is accomplished by the script launching an external db's script that brings up a small visual calendar. The user then clicks on a date in the window, the click triggers a script that compiles the correct date based on his choice then pastes it to the clipboard (or sets a global variable in the main database, as in my case). So far so good. The the script in the calendar database continues and hides its db. Now the problem. I can complete the loop by having the calendar script call an external script in the Main DB to continue. That works, but what if I have multipl…

I am in the process of making a filemaker 5 database that is intended to store a large amount of scientific info. I have been unable to create a script that will allow me to open a file in another application, where the name of the file to be opened is the content of a field. The doc to be opened is a string of letters representing DNA sequences and the application I want to open them in is called MacVector 7. I am making this database on a MAC! Not in windows. This seams like a really basic comand and I'm sure it can be done, just not by me. Can anybody help???

Things like form.load, .lostfocus, etc.

I perform a find for Mary in a name field. I create a new script and call it Find Mary. The script works. In ScriptMaker I go to edit the script and the line reads Perform Find [Restore]. I print the script and I see Perform Find [Request 1: First Mary]. I looked everywhere before posting this question, so please forgive me: Why can't I see the details in ScriptMaker and more importantly how do I edit the variable Mary in the future?

Hello All! I am working a db application that tracks conduct/discipline for a school principal. I need to set up a script to print a certain layout dependent upon a text value in a particular field. For example:In the current record IF the Field Punishment_ID = "001" then go to layout "ISR Letter" and print 3 copies using the current record IF the Field Punishment_ID = "003" then goto layout "Suspension Letter" and print 3 copies using the current record...I am new to this so I am not sure what the procedure to do this would be. Thanks [ November 14, 2001: Message edited by: Matt Johnson ]

The "if and else" portion of my brain doesn't seem to be working today. I need a fresh set of eyes to find the error in my script. if (secretword="fred" and global counter <=5) go to layout #2 end if if (secretword="ginger" and global counter <=10) go to layout #2 end if if (secretword="mikhail" and global counter <=15) go to layout #2 else show message (Sorry, you can't enter) close file end if The secretword will never be "ginger" when global counter <=15. I understand, however, that when global counter <=5, the secretword "mikhail" would work. When none of my three conditions are met, I want the program to quit. Right now so…

I've never used looping in a script before. That's for repeating script steps, right? When i add "Loop" to a script, does it repeat the steps above it or below it? I only need it to loop part of the steps i have, (omitting the first two steps of my script), so, I'm hoping it's below so i can just add it before the steps i need looped.

I created a billing database which creates patient charge sheets for surgical procedures. I created a handheld DB on HanDbase which I have successfully ODBC linked to the FM billing db, such that all non calculable fields can be entered on the handheld, synced, and transferred into FM for calculation and printing of charge sheets. I am trying to configure a script which will know which records are new or updated and then only print those records. I thought of using a range find from the "insert from last record" (date)to "insert current date", but I fear it will use the last updated record since this is the last active field and I will get one day of records printed inst…

Is there a way in Filemaker 5.5 (Windows) to have one window maximized and another minimized? I'd like to achieve the effect of a pop-up window.

Hello, I have a database form which needs to automatically fill out some fields according to the value specified in one field (Employee #). I need someway to automatically pull out those information (ex: Name, Phone #, email, etc) from Ldap.company.com. I already added the Ldap to my directory services. Thanks for any help. PS: i am using FileMaker Pro 5 and the platform is NT.

Is there anyway to bypass the "no records match this request" message? I have built scripts whose functions are to display a list of a sales reps' scheduled follow-up calls. I have 2 databases; "sales leads" and "comments". A script in Sales Leads calls an external script in Comments Go to layout ["login"] Enter Find Mode[] Insert Current Date["Call back"] They then see a screen with the fields "sales rep" (drop down menu) and "call back" and a button that calls the script Perform Find [] If [status(CurrentFoundCount)<>0) Go to Layout [CommentbyDate] Else Show message ["No reminders scheduled for today"] Perform Script [sun-scripts, external:"Sales…

Hey kids. I'm looking for something like a Set Field script step to use to sort a return delimited list that is contained in one field. Example: I have a field called ListOfInvolvedEmployees that a script keeps adding names to. Each name is separated by a return, looking like this Andy Nonymous Noah Boddie John Dough I would like the script to make the list look like this Andy Nonymous John Dough Noah Boddie or sort by last name, but I'm sure that this is easier. I know that I could create a separate file viewed through a portal, but I want to be able to index the field for possible relationships. The list could have anywhere from one to twelve names in i…

I have a script that calls upon a number of subscripts that do a bunch of finds, then change the data of the found sets, then do some importing and exporting. The whole process takes about an hour and a half. I've been working on setting this up so it happens automatically in the middle of the night. My problem is, if one of the finds happens to return a zero set (which could normally happen), then I get the error box that says "No Found Records", and it waits for me to click "continue". The next hour of the script hangs waiting for this. I've been playing around with including a "Set Error Capture-On" script step. This seems to work, but if I include an If statemen…

Hi!, another post from me Does anyone know if it is possible to write a script that will open a file AS A GUEST? And if so, could you explain it to me? Thanks!

hi there, I think i

My DB calculates a value. This value is based on 100% utilisation. But it would be nice to have a popup menu ranging from 10%-100% utilisation and the calculation then based on that choice. How do you create a script that calculates based on the choice and updates the value. Thanks, Peter

Dim FMProApp As FMPRO50Lib.Application ---------------------------------------------------------------------- Private Sub Command1_Click() Set FMApp = CreateObject("FMPRO.Application") Set FMDocs = FMApp.Documents 'FMApp.Visible = True Set myOpenFile = FMDocs.Open("c:PriceIt MasterOrderEntryM.pit", "") myOpenFile.DoFMScript ("Test1") End Sub This visual basics code works to activate a script in FileMaker, however we cannot get it to work in the runtime. Any help would be awasome Thank you Ron Bascom

I have put a button in a portal set to perform a script that goes to the related record in another file. I want the file containing the portal to toggle to hide when it goes to the related file/record, but the script only seems to work correctly when "go to related record" is the only step in the script. When I try to add toggle or enter "go to related record" as a subscript, it goes to the related file OK, but goes to the first related record, not the one in the portal row I selected. What am I doing wrong?

This is probably an extremely stupid question, but here it goes- I work in a business that produces video games. We have many team members that view the databases I create for the projects, so contact is a good thing. Mostly everyone that is needed to keep in contact with uses ICQ. I have a sendmail icon that i am using for users, but since mostly everyone is using ICQ all of the time, it would be great if I could have an ICQ link to a UIN or somthing similar to that. Can anyone help me out here? [ November 08, 2001: Message edited by: THX ]

A parent file shows a portal. I want a script in the portal line that finds related child records ( easy enough with Go To Related Records ), but I want this set of records to be sorted in the same way as in the portal and the current record to be the one that was clicked in the portal. I get the found set OK but only in creation order. If I do a subsequent sort, I end up in the first record, not the one that triggered the script. This would be useful as I often want to scroll though records in a defined order but starting at a predetermined point. Thanks in anticipation, Andrew Bruno

Hello... The following script pastes the contents of 'gname' at the end of the data already in the 'comments' field. However I need to be able to paste the data at the cursor position in the 'comments' field. Any suggestions would be appreciated. Copy [select, "gname"] Go to Field ["comments"] Paste [] thank you. [email protected]

Hi! sorry for posting this here - I didn't find an adequate section for such kind of probs.. So, the problem is the following.. My database has 2 levels of access - guest and full. And there are fields on my layout which can contain lots of text, and therefore be scrollable. Scroll bar is functional when a field is editable (full access mode), but as soon as I turn the editable flag off (for guest mode), the field can't be scrolled anymore, so in guest mode the information is just cropped, and this is definitely not good.. I have my own access system, so per-field access feature of FileMaker can't be used in my case I'm afraid.. Anybody faced this problem? Please sha…

OK - probably the wrong place to post this message - but its worth a go. What is the main diferance with Filemaker Developer and normal filemaker - is it just that you can create stand alone versions of your database or is there more to it? If for instance you have a database thats used by five people is it better to buy developer once and create the database application which each user could use or buy seperate filemaker copies and publish the database via filemaker server? OK. Thats question 1. Question 2.- Has anybody played around with developer tools in OS X - I would love to use the layout features this gives you - ie Aqua buttons etc and build a proper looki…

I’m having some issues trying to populate a repeating field from a repeating field. Example field “s” repeats 4 times and field “j” repeats 4 times I want to set field “j” to = field “s” via a script I’ve tried the Set Field [“s-3,Get Repetition(J,3)”] and I just cannot get this to work except for the first reparation. Can someone please try and see if they can get it to work, I’m totally at my wits end, and thinking this maybe a bug in the program. I’m using ver5 Thanks Ron Bascom

I need to create a script or calculation (not sure which) that will look at the number in one field, and then enter a value in a second field. For example...If the number in field A is 8,7, 75,25, 40, 8, then in field B enter "Z". If the number in field A is 54, 56, 64, 34, then in field B enter "Y". I have 28 of these sets. Right now, I can get it to work for one set, but then it keeps putting the result for the first set into all field B's, regardless of the numbers in field A. (Make sense?) Thanks for your help!

I have a button which activates a script to retrieve a lengthy phone list saved on my hard disk as an html file. The script works fine, in that the correct file opens - but there is always an error message that appears: "phone.htm could not be found and is required to complete this operation", followed by another error message "the previous script step "Send Message" could not be completed because of an error. Do you wish to continue? etc. etc. What can possibly be the problem with a one step script? These pesky error messages are getting on my nerves! All suggestions appreciated.

Since ScriptMaker is based on Pascal I would hope that there is a way to use the hash mark (#) or some other way to comment a script. Is there a proper way? ~Dennis

I have a FM Developer runtime solution with 2 files. The main file has a script that opens the second file, finds and deletes all records, and imports records from the main file. This script works great on machines running Win 95 and 98. On the Win 2000 machines with Service Pack 2, the main file works fine, but freezes the machine every time this open/find/delete/import script is activated. Both files become damaged and need to be recovered after rebooting. The same file transferred to a Win 9x machine works fine after the files are recovered. On a Win 2000 machine with Service Pack 1, the main file works fine, but the machine hangs for 30 seconds when moving between t…

I'm new here, a fundraiser for a school for Tibetan Buddhist kids in northern India. I wouldn't call myself a developer but Filemaker Tech Support says what I have is a script problem and referred me to these pages. I'm running FP 5.5 on Mac OSX, both of which are quite new to me. (Used to 5.0 on OS9.) I have one database with donor records, and another linked database with donations. I want the latter to print me out lists of donations for each month. I created a "month" field in this database, which calculates itself from the date and seems to work fine in the data entry layout. I then use the "New Layout/Report" helper to create a layout and script to report w…

hi, I

is there a way to create a script that fires everytime any field is entered? I want to create a global field that always contains what the curent field's data is upon entering that field (before the data is modified). I have a history field I'm creating that will record any and all changes to any field. I want it to read "so and so changed this field's data from X to Y. I have OaziumEvents plugin that fires a script upon exiting a field, but not upon entering? It all works except for setting a global field to hold the old data (X) before its changed to Y. I think I could make it work if EVERY field had a backup global field, but that gets dirty fast, cuz I've got ov…

ok i have this script, what it does it loop through all the records in a relationship (Orders_) and e-mails someone the Order ID Number. then it stores the Order ID Number the "hold" field, so it know that the record has already been e-mailed. NumofPortalRows is just a field that tells me home many portal rows there are. gPortalNumber is a global that keeps track of what portal row i am on. Now the script works most of the time. However, sometimes the script will skip a record. Its totally random when it does it, sometimes it will skip the first record, sometimes one in the middle. Most of the time it won't skip a record at all. If it does skip a record i can run through…

Hey kids. When was the Go to related record script step added to Filemaker? Version 3 or 4? Thanks. Paul

I've been stuck all day trying to build a script that will sort records by date, then omit the records that have no date. It seems the "ifEmpty" function will do the trick. So my script looks like this: Go to record/request/page [first] Loop If ["isEmpty(year)"] omit record End if Go to record/request/page (exit after last, next) End loop Sort (restore) I've got the sorting part down, but why won't this script omit ALL the blank records?

Ok....I just got Filemaker and am trying to do a simple script. I am doing a database to organize my photos and keep track of what markets I have submitted them to. The script I want is....I have a drop down menu of the categories for the photos (sunset, flower, animals, etc). I also have a field that has possible magazines to submit the photo to. I want a scipt that will see the category and then automatically input the possible magazines in the other field. What would be the best way to go about that? Sort of a If, then script I suppose

Hi I am just learning filemaker pro ver 5. I am tyring to create a button that performs the following task 1.enter find mode 2.auto enter some text into a specified field 3 perform the search I have been playing around with the scriptmaker, I can do 1 and select the field but cant enter the text. I have been playing wiht the "insert Text option" but I cant get it to work. Help!

I have a report that needs to be run base on information in two different fields. The two basic fields that have the data in them is a text field and a date field. I need the user to input the information in the text field and then the report takes that and finds every record that has that but has the date field empty. Any help would be great. Kuku

Dear Forum Gurus, I am trying to perform calculations based upon the number of records whose field(s) meet a specific criteria. For example, I want to know how many males (of males/females) that like chocolate (of chocolate/vanilla/strawberry) enjoy horror movies (of horror/drama/comedy). Can someone direct me in this case? I should admit that I'm not fluent in the use of global fields, which may be of use here. thanks, --keith

I' Like to show records in a portal that match a relationship, but only if they also are marked as active in a field called STATUS in the related file. Is there any scripted way to do this? (I'm going to call this a duplicate post, which are not allowed, and close this thread. See my answer in "Portals". -bd) [ October 31, 2001: Message edited by: LiveOak ]

Has anyone come across a method to have scripts be executed on and by a remote machine (server), but initiated from a local system script? Currently I have to execute the script across the network by the local system and it is very slooow. Many thanks for any insights Michael

I am creating an order tracking database. When an order is complete I need to print a shipping label. (I use UPS Ship. ) Anybody know of a way to automate the label printing process (so I don't have to ender the name and address into ups for each order). Thank you. -wald

I'd like to write a script that generates an alpha numeric serial number that is only one higher than the last record. When I use the auto enter function from The "define fields" dialog box, new records show the next absolute serial number (from some library I suppose), not one higher than the last record. Help, and thanks

I have to do a series of finds, and then print different letters (layouts), to patients. But, if one of the finds in the script does not match (find) any records (and the foundset=0), then the print command interupts the script and says something like the the print command can not be completed. Is there a way to have the script skip the print command when no records are found, and there is nothing to print? So, the script does not stop and another find is performed as per the remaining script steps. And, then if records are found, prints appropriate letters.

I tried to write a script to loop through all of the items in a portal, setting a certain field based on the value in another field (the field I am setting is visible in the portal, the field I am testing is not visible in the portal, but it is accessible through the same relationship). My first question is, how do I choose which portal I am working with when I use the portal navigation calls? But, my real problem is in making a loop that runs through portal rows. The problem I have is in setting the field. The test that I have if (relationship::field = value) always uses the value in the first row of the portal to set the subsequent rows. So the loop is working …

I'm looking for info on a new script step in FMP 5.5 . I believe the name of the step is "Execute SQL". I'd like to get more info on how it works. And if anyone here has used it, could you please provide some feedback? Any helpful responses are welcomed. Thanks-

Has any one come across a fast method to copy a record between databases, without resorting to copying each field in the record individually, or exporting. I am trying to keep a synchronised copy of the primary database, offsite and copying fields is very slooow, especially over dialup! Many thanks Michael Dalton

I have a membership database where I track different types of members. Each membership type is listed as a radio button (ie, Basis, Professional, Supporting) in the membership field. I need to create a report that tells me who is what type of member. In my filed I have the following script If(IsEmpty(Membership Type 2001), "no", "yes"). Instead of returning the answer "yes" they are a member, I need to know what type they are. How do I get it to tell me which radio button is selected for each individual? Thanks!

I am trying to write a script that gets a product number for a record by using a file that generates numbers and pastes that number into a blank style number field. I don't want the user to be able to get that number unless the field is blank, so I thought that this would be a good place for an IF. All I want the IF to do is see if the target field is blank before it pastes. How do I do this? Thanks Shane

Can anyone tell me if there is a function in FM or plug-in to get the drive letter of the CD-ROM drive in windows? thank you!

If the status area is tagged as "Hide & Lock", one can not move from one record to another in a list layout using the Control key + arrow keys (up or down). The feature to trigger a script on exiting a field requires buying a VERY expensive plugin (especially a developer's license). Why doesn't Filemaker provide users with such a feature: The ability to trigger a script on exiting a field. The requirement to either use the mouse or press the CTRL/Arrow keys to move from record to record in a List layout is cumbersome at best, and downright crappy at worst. Surely, FM can give us better navigational tools. Perhaps there is another solution to allow users move …

Does anyone know what's wrong with this script syntax? (No value is entered.) Set Field ["repeatingField" -2, "GetRepetition (globalRepeatingField, 2)"] Thanks, Stefan

Is it possible to create a send mail script in FM? I have tried to use cgi and asp with no luck. I simply want to create a form on a web page and have the user fill in the form and submit it and have it mailed back to my e-mail address. Is it technically challenging to do this? If not, can someone point me in the direction where I can learn how to do this. Any help would be greatly appreciated. Mike

I have two related databases, A and B. A is my main database and one record from here can be related to many files in B. I can see all the information I need through a portal. I need to be able to export the most recent "amount" and "date" from B (both on the same record), from the main record in A. If I try to do this from A now, it exports all the related dates and amounts. The way I proposed to go about this was to create two fields in A that show the most recent date and gift, and then export those fields. But I'm not sure how to write the script(s) to get the most recent record isolated, and then bring that information into A. Make sense? Thanks for your…

Config: FileMaker Pro v5.0v3 Windows 2000 SP2 Outlook Express 5.0(also tried 6.0) I'm using A Send Mail script, utilizing the MAPI feature of Outlook Express. OE is set up to use IMAP with the mail server (running Ipswitch IMail). When the script executes, the mail is sent, however, the message is unable to be moved to the Sent Items folder. I dialog box displays on the screen stating that OE is attempting to move the message to the Sent Items folder. Every 1 minute, it asks if you want to wait or stop the process. Clicking either button has the same effect...it continues, unsuccessfully, to move the message. The only way to stop it is to kill the FMpro process. I…

Hi y'all, I have a script with an IF loop in it which stipulates something like:- IF ("Status(CurrentError)>400 Show Message ("The payment method field must be completed") Exit Script ELSE IF ("Sta........... Show Message ("............. bla bla bla bla ELSE IF ....... End IF End If End Quiff (bla bla bla) The above is not exact but the ideas there.. It all works and comes up with a box with the message and option OK or CANCEL. QUESTION... If I click OK it all works. If I click CANCEL it still carries on as if I had hit OK. How do I set the Cancel button on the message to work? Thanks in advance. Matt

I have two databases that need to be linked or related. My first and main database is a BOM (Build of Materials) database which needs to be linked to a second database which has all the costings of the different parts which make up the product. The problem is that the costings database does not have any directly linked information as it is just basically a comprehensive list of prices (2000+ records). As a result I need a script which says; if Supplier in BOM database = Supplier in Costings database and Part in BOM database = Part in Costings database (there could be more than 2 variables involved!) then copy cost from Costings database to BOM database Is it p…

Unless I make the checkboxes 2 points or greater, they are invisible at normal zoom levels. However, you can see the boxes when you zoom in. If I make the boxes 2 points, the lines are too heavy and almost obscure the "X". The radio buttons display normally at any zoom level.

I have a solution in which I need the ability to create new layouts on the fly via script. I want the ability create new letters to send to individuals in my contacts database. The only way I can think of to do this is to go to layout mode, duplicate the layout and edit the text the way I want it. I don't know a way to make this scriptable. Alternately I would like to create a "letters" file where each record is a different letter. Is there a way to create these letters via field manipulation? Within these letters, I want the ability to do merge fields for names, addresses, etc. Any thougts would be appreciated.

I am trying to find a way of changing from the paper tray to manual paper feed during a Filemaker script on a Macintosh. I want to print paper from the tray and labels from the manual feed. Do you have any fixes? Thanks in advance. (We don't allow duplicate posts of the same question on the Forums. Please answer in "Outputting Issues". This thread is closed.) [ October 20, 2001: Message edited by: LiveOak ]

Does anyone know a way to print layouts exactly as they appear in layout mode? With field names etc. Thanks

Is it possible to keep track of what the last key pressed is with FileMaker or perhaps what was the last button pressed?? Is yes can you use it in a script like IF "this button" do this task ELSE do that task. Thanks --Dan

Functionality problem: I'm trying to add a value from a pop-up list "departments" into a separate list "selected departments". I've had some limited success using a box behind the pop-up list field that runs a script like: Go to field "departments" Pause/Resume Script Set field "selected departments" Case( IsEmpty(selected depts),departments,selected depts & "

In looking through the scripting section of my FM 5.0, I didn't find a script for separating a text string (three words) in one field, into another. Does anyone know this script? The next script problem is to add a word to an entire field (without replacing the text contained in it. The final script is a script that will compare the similar (but not exact) contents of a field in two distinct files, and return information from one placing it in another field. (I tried linking the files and then looking up the info with no luck!) Thanks for y6our help, Rick

I am using Set Field to set the contents of a related field but it won't work. I have used this script step in the same way in the same script in several instances and it works OK. I have checked thoroughly and can't find anything wrong with the relationship, field definitions or the script step itself. Can anyone shed any light ot seen this problem before? My script is fairly long (50 steps I guess). Thanks a million

I'm trying to run a script after a field has been exited (e.g Someone has changed the value of a field and after they are finished and move to the next field or click of the field I want a script to be run.) I searched the forum and found a similar question where a Script Scheduler (can't remember the exact name) was used to do this. So my question is, do I need a plug-in to accomplish this or does FM already have this function and I'm just missing it? Thanks in advance

In reference to the script I described in the post "Scripts that Run Automatically" It appears that the date calculation in the if function: If ["Status(CurrentDate) >= Letters P Date 4 + 4) and (Letters4 = "Action WS") and (IsEmpty(Action List))"] is not working. I know this because the date in field "Letters P Date 4" has yesterday's date in it, so the current date is NOT at least four days from the date in field "Letters P Date 4". The other conditions seem to work. The interesting part is that the if function here is very similar to ones that I have in other scripts that DO work. Any suggestions on what to look for or fix?? Thanks, Ken

How can I find records within a date range and omit some of those found records at the same time?

Ok here's what I wanna do. I want to be able to click a button in database A and have it open database B, create a new record in database B, and copy specified fields from database A to the new record in database B. I have set up a relationship from A:B and have played with scripts but cannot get it to work. Thanks for helpin'! Garrett

I have too quick questions: 1. Using scriptmaker,is it possible to open a db file to full size of the screen or at least make the window go to the top left of the screen? I'm guessing that Status:Screen Height and depth may be a solution but not sure how to implement it. 2. Is it possible to add a script to a layout so it runs when the layout is selected e.g.from the left hand grey bar (I know it's possible to have a button attached to a script that will select a layout as part of the script. Many Thanks

The sign (*) stands for OPENED ON HOST: this occurs when you open shared files connecting to an HOST COMPUTER. Regards.

Hello, everyone!! Ok, I am having yet another script problem, and now that I have written a couple of these, I have a question. This script is suppose to look at a field that is attached to a value list, and see if a certain box is checked (an item in the value list selected), see if a field is empty, and print a letter to these people. It looks like this: Go to Record/Request/Page [First] Loop If ["(PatternCount(Action List, "Appointment Obtained") > 0) and (IsEmpty(Letters2.2)) Set Field ["Letters2.2","Appt. Thanks""] Insert Current Date [select, "Letters P Date 2.2"] Go to Record/Request/Page [Exit after last, Next] Else If ["Status(CurrentRecordN…

Is there a way I can show the path of a file in a field. OS WIN 98 FM5 Example: Insert photo (works just fine), how can I show the path to the photo in FileMaker Many thanks in advance Thomas

Here's a problem I'd like to solve with FM. Imagine you have two databases. One contains a list of, say, zodiac signs. Each record would contain a sign like capricorn and the dates that define that sign. Another database contains a list of people and their birthdays. I'd like to write a script that goes through the database of people, and adds to each record what sign each person belongs to. Can anyone think of a way to do this?

I need to document several related FileMaker Pro databases, each with many scripts. I would like to export all the scripts into a Word file or Filemaker Pro database so that I can search them and print them out as I wish (more than one script per page). The only way I have found so far to do this is to use Acrobat PDF writer to create a PDF file of all the scripts for one database, and then paste each of the scripts one by one (page by page) from the PDF file into a Word file. That is very tedious. Has anyone found a better solution?

I don't know if I have a problem yet because I haven't tried this on a network yet, but, here's the scenario - I have a point of sale database which has a portal to look up the stock availability of an item (via relationship using field::"Product Code", then I have a portal that writes into a "Sales Bridge file database" when I click on a button entitled 'BUY'. The script then requests the STOCK ALLOCATED amount in the STOCK DATABASE and adds it to the QTY REQUIRED in this order, then pastes it back into STOCK ALLOCATED and then performs a new record request in the SALES BRIDGE FILE database and writes that this product has been ordered also listing product code, qty, d…

Hi, What you need to do is define some "self join" type relationships. Think about what pieces of information actually tie the records you want to perform math on together, and then have your calculations "look" through these relationships. Here is a simple example of this: Take an invoice file that has multipe invoices for a single customer. Let's say you want to count the number of invoices in the system for that customer. What you do is create a relationship to the same file using the customer ID as the key field. (NOTE: Make sure that the relationship is set NOT to create or delete related records!) Next create a calculation field that uses the "Count" funtion and …

This is, I believe, what could get to be a rather complexe issue I want to solve: I have a FM Pro 5 Database that I want to both leave on a DeskTop so as to share it with other colleagues at the office, and also be able to take it with me on my LapTop so as to be able to work outside. How can I Synchronize both copies when I get back to my office ? I trust I can do this using only FM's built-in scripting, but I can't seem to figure out what would most simply do the job. One of my defined fields constitutes a unique ID number for each record. Of course, I'm expecting to add at least a "Date" and "Time" fields in order to be able know which record was last modified. …

Hello Everyone: I realize I am being somewhat persistent, so forgive me. I know very little compared to the think tank of this forum, and I would like some more information. I am running a script that runs several sub-scripts. It looks something like this: Perform Script [sub-scripts, "Certain Script"] Perform Script [sub-scripts, "Certain Script2"] If ["Late Notice Print Status = "Disabled""] Exit Script Else Perform Script [sub-Scripts, "Print Late Notice Sheet"] End If Blah, Blah Ironically, the sub-script that performs if the IF function is false, is the script that I'm having trouble with and posted in "Ignoring my date calculation." Regardless, …

Hey All! I want to make another script where it looks through all the records and checks one field for ANY Value List Entry. I have set up a Value List , attached it to a field and gave it checkboxes. The script I want to make searches the Value List field and look for ANY checkbox that is checked. The name of the field is "Action List." So my question is, in my calculation, what would I set the field Action List to so it will accept any checkmard as valid? Also, how would I set the calculation to search for only a specific box that is checked. (Action List = "Value List Item"): Hope this makes sense. Thanks for all your help! Ken

While working in browse mode, if the user accidently hits a button to add a record or to find a record, what's the best way to cancel the operation?? (Cancel or Escape button) I can't seem to get anything to work... In the layout i use, the first field is a number field with validation to prevent it from being empty and must have a unique value. So i end up stuck with an error message that will not let me cancel, i can't even go from browse mode to layout mode. Thanks --Dan

I have 2 databases both with an 'Order Number' field. What I am trying to achieve is this: On the first database,there maybe a record with '003' in the 'Order Number' field. When a button is pressed, which is linked to a script, it will open the second database, bring it to the front and locate the record with the order number of '003'. I have tried various scripts but none are working. I am guessing that I need a script on the first db attached to a button that will open the second db and run a script from from the second db. Somehow get the value of 'Order Number' from the first db and insert it into a 'Find'.Or am I way off? Thanks, for any help.

I am having a problem working with duplicated records in FM4 for Mac. I am create a class schedule. Each record in my DB contains class info including class name, class length, start and end times, etc. I need one record for each 1/2 hour that a class runs. For example, if a class runs from noon to 2 pm, I need four records, each identical except for the start times (which would be 12:00, 12:30, 13:00 and 13:30). I need a script that will create these records when it sees a class whose length is greater than 30 minutes. I am trying to use the following script: Go To Layout [Refresh window, "ShowAll"] Find All Sort [Restore, No dialog] Go to Record/Request…

Hello, Most likely an easy one.... I have 3 files (all related with various ID fields) From file_1 (say InvoiceHeader) how do you get a button to open a layout (in Browse mode)in file_2 (say CustomerInfo), to show the related customer BUT still have access to ALL the customers (so the user can decide to modify any record he wants) thanks for the help --Dan

I got so excited about making zero records show in the global fields, now if there ARE records they won't show. What in the world am I doing wrong? I have tried this with the "Else" statement and without the "Else" statement, I can see the count being put into the Summary field but it refuses to be put into the Global field. Here is one of the short scripts. Show All Records Enter Find Mode [Restore find requests] Perform Find [Restore find requests] Sort [Restore sort order] If [status (CurrentFoundCount)=0] Set Field [summary field, 0] Go to Field [global field] Paste [summary field] Else Perform Find [Restore find re…

Can you write a script that will look at the file name of an imported graphic and compare it to text in a field in your filemaker file. I don't see a function that will give you the file name of a placed graphic. Thank You

Please Help!!! How can I make appointments in which the hours can't be the same used for a same day?... and When I go to another day I can make the appointment normally without receive any message like this: "It cannot have an appointment with the same date". I'd appreciate your help a lot!!! YMJ

we have a client who is going through switching through records and then adding a related record via a portal on given records... they are telling us that some times the record they add in the portal is being added but its causing the ones that were just added to other records portal disappear.... they were initially using filemaker server and said the problem went away when they switched to just using a workstation share to access them... though they now say they're having the same problem... i reproduced the problem two times.... and can't see any logical reason why its doing this, the only fix i can find is to restart filemaker... once, when I had the problem stil…

I’m putting together a series of scripts to do finds for various criteria. The end result is a bunch of summaries and calculations that go into a mess of global fields for storage to be exported for a scorecard. Everything works just wonderfully unless there are no records found for a specific search, at that point that field will show the previous find results. My problem is that I need to have “zero” or a blank field or the previous number erased when no records are found.

Hi, I'm trying to a write a script, part of which is to sort on a specified field. I see plenty of info about splitting sorts into separate sub-scripts but I cannot figure out how to get the sort bit of the script to get rid of any existing sort fields and just use the one I specify. Probably being completely dim, for which I apologise. FM4 on Mac by the way. cheers

You need a plugin. See Troi's plugins at www.troi.com.