Script Workspace and Script Triggers

Hi All, I know many of you are aware of the "Clairvoyance" scipt from the Sciptology book as I have seen reference to it here before. IN one of my databases that was originally developed in FMP 6 I used Clairvoyance and loved it. I am in the process of developing a new DB in version 7 and no matter how hard I try I cannot seem to make it work. Everything seems to be identical to what I did in the other application, but it just doesn;t work. I don;t get the parsed name results in the portal, and even though I do get a NAME MATCH in the portal, if I click (the script is apprpriate) on it, it will not paste it (set field) into the target field. I am so frustrated r…

A word to the wise, programing while on Nyquil is not a good ideal! The reason I know this is because while on Nyquil I was working on a client's database and mistakenly put a close window statement in my startup script. Now I can't get back into the database because all the windows are closed. In Access you can prevent the startup scripts from running by holding down the shift key while opening the file. Does anyone know of a simular "escape" escape for Filemaker? Thanks for the help

Ok, this post has a decent ammount of background before I get to my question. I wish I could find a more terse way to put this, but ... I've got a fairly complicated dataBase (for me at least). In it I must keep track of people such as program directors, primary contacts, consumers, etc. Each person has similar information, but not always the same -- So I've a schema that limits data replication, something like: [telephoneNumbers]+[telephoneNumbers]+[addresses]+[basicPersonsInformation]=>[programDirector] or: [telephoneNumbers]+[addresses]+[basicPersonsInformation]=>[comsumer] All telephone numbers are in the telephone numbers table. …

is there anyway to perform a find within a script where the condition is the value contained by another field? for example if i want to search where field 1 = the contents of field 2? Thanks, Anthony

Is it possible to write a script to create a new container field in a selected record? I want the user to be able to create as many container fields to import pictures for a selected record on an as needed basis.

i have tried using open url in Filemaker 7. Seems fine until however it will not open a non http:// link when i use IWP. My link in the field is mms://ttsetav01/bodybeautiful.wmv (It's a video streamining file). when i click open URL button in IWP It becomes http://mms//ttsetav01/bodybeautiful.wmv (It replaces my link) What is happening? Has anyone found a way to solve it? Thanks.

Is there an easy way to launch scripts based on the system clock, like an update script at 3:00am each day?

First of all I want to thank Moonshadow for aal the help that has been provided in getting this databse up and running I have a couple of other smal issues that I need assistance on. I am devoleping a Dispatch database for a small ambulette company. I have a field that is a time field to cancel a call, When they click on the box to timestamp the field it omits the call but what I want to do is setup a Message script box. The box will say "Are you sure you want to cancel this call?" The user will have the option as "yes" continue on with he rest of the script to omit the record or "no" go back to the page you were on. What is each step to do this? Thanks for the help…

I just ran into an interesting problem, and I have a work-around, but I think it is clumsy and wonder if one of you pros out there can help me. I have a DB that uses Get(CurrentDate) to populate a field that is then used in a script that updates a production schedule. Basically when the production schedule is called for a given day the DB goes to the global date field, copies the date in the field, enters find mode, goes to the appropriate layout, pastes the date in the "order due field" performs the find and then sorts the records. This worked great. However, today when I went to test the Script again it didn't work because it was posting "yesterdays da…

I need some help seeing what I am doing wrong with a duplication script that I have. Here is the database layout: 4 tables: Project;KitCode;EventCode;ProductCode The project table is related to each of the other tables via a ProjectKey. ProjectKey is automatically entered number. On the main layout (Project table) I have 3 portals showing records from each of the other tables. Often our users want to duplicate a project because a new project they have is very similar to the old one so they need to just change a few entries as opposed to entering all the info in again. I have a main script (Duplicate all codes) that copies the old projectKey to a global fie…

Hi all, We're working on a solution internally here at my employer to get around the features of Outlook that now prevents third-party apps from sending an email automatically through and Outlook client. We can accomplish this by allowing "trusted" DLLs to access Outlook. Does anyone know what DLL communicates between Filemaker and Outlook when the Send Mail Script Step is executed? Thanks, Kevin MacHeffner

I created the script and everything worked fine with Entourage but it will not work with Mac Mail. actually, it only worked some times with Entourage. Can anyone help me trouble shoot this? I tried using the script accross FM Server 5.5 and that does not work either. thanks for any help!

is there a way to exit out of all running scripts from a script that is called within another script?

We switched form os 9 to os x and we have a script that enables us to view a pdf file that is named according to the record number this is how it reads set field {"GBL Resume URL", ""http://ip address/"&Right(applicantID, !) &"/"& Applicant ID".pdf""] Open URL [No Dialog, "GBL Resume URL"] if the file holding the pdf's is on the os 9 system and designated as the web shared folder it opens fines but If I put the file into the public folder of the Os x computer and change the script from http: to afp: it can't open it. what am I doing wrong. the goal is to get rid of this iMac that has os 9 on it and just host the resumes on our G…

Basically, i am tryin to find student that are part of program but also that had the status Enroller. There is a field call Status which is drop down menu. it contain Enrolle, Applied. my Set Field [

I keep thinking my first database is almost finished and then I start working on the layouts, the buttons and the scripts and pretty soon the day is half-over Two questions: Is there a really good print resource (book) on scripting that is relevant to FMP 7? Something with explanations in plain English and with good examples would be very nice. The help file is not bad, but I can't really read it in bed..... Is there a limit on how many scripts one can create in one file? My list is growing and I find myself wishing for folders like in my browser application......

i have about 100 buttons in layout 1, each of the buttons need to lead to a certain record in layout 2. how do i have button 3, in layout 1, bring up record 3 in layout 2. i can't figure this out, and much appreciate any help. in case you're wondering, this database will be for a resource only, after it's completed, it will not be changed. thanks

Hi i'm trying to write a script creating a report and i need somewhere some steps to pull information from several portal rows into 1 or many fields horizontally in my report... Let's expand: I have a layout (labreport) where i enter results from tests in a portal (from Result table) My report is showing records mainly from an other table (testdetail) so i need to get the results related to each records and fill them in the report. So far i've been told that i should use 1 field in my report and Concatenate, so here i am trying to do this but i'm having trouble scripting the fact that the results are coming from portalrows What i have is something like: …

Hi Everyone, I have this basic script written and I do not understand why it pauses in the middle and request that I hit either <enter> on keyboard, or click the Find button that displays on left side. Go to Field [Production Order::Current Date + 1] REM:(this is a global field on this layout, provides correct return) Copy [select] Enter Find Mode [] Goto Field [Production Order::Order Due] Paste [] Perform Find/Replace [No Dialog] Sort Records [Restore; No Dialog] I do not understand why this script is pausing and waiting for a key stroke or a click to finish the script. Can anyone provide insight? Thanks, Steve

Hello, I'm referring to an old post about returning to a specific record - in my case, after having conducted searches and omitted some records plus created new records- and to the following replies: You may want to try the simple expedient of stashing the record ID in a global at the beginning of your process, and then finding the record via that global at the end. In a very large file this can be a bit slow, but it's guaranteed to work, at the least. and the incomprehensible: Indexed finds are very fast, even with large databases. However, it may be easier to use a self-join relationship between the global field you are storing the last record ID in an…

Please help! I am creating a music database library. I want to be able to play a track (a quicktime) and then hit a button and have filemaker save the quicktime to my desktop (or a folder). I know how to get it to play the track, but I have no idea how to write a script that would save the file to my desktop. Would someone please give me detailed instructions? I'd really appreciate it! Thanks!

I want a button that gives information when selected. I tried making a field and using popups, but the information presented that way is untidy and to make it legible I had to break the text (a couple of paragraphs) into groups which then became selectable. There is a limit to the size of the text that way as well, so that I was losing a lot of what I wanted to present. I only want the full text to show in the same field (button) or maybe a popup field nearby. It is simple to do in Excel, just hovering the mouse over a mark on the page brings up the information box I am talking about. It would be nice to have that in FP as well, so that the user could put the cursor…

Hi everyone, I have a portal with a button inside the row that will delete that portal row (in theory). The button uses just the delete portal row step without making it a script. When I click the button it brings up a dialog asking if I want to delete this related record, then deletes the row and then when I click anywhere else, the master record vanishes!! What am I doing wrong? I have changed it to delete record and it pops up a dialog box asking if I want to delete the master or a related and the same thing happens. this is driving me crazy.

I want to be able to duplicate a number of found records in one of my databases. I am having trouble setting it up so that after the first record it finds the next record to duplicate. Right now it find the first record, clears the seleted info, and stops because it puts the duplicated record at the end. Anyone with any help? Thanks

I don't know anything about VB and have to adapt a script to use it with Filemaker 7... following details found of different sources and adapting what I had from version 6 I get the following in VB: Dim FMDocs As FMPRO70Lib.Documents Dim FMDoc As FMPRO70Lib.Document Dim FMApp As FMPRO70Lib.Application Set FMApp = CreateObject("FMPRO70Lib.Application") Set FMDocs = FMApp.Documents Set FMDoc = FMDoc.Open("C:AcredSysfoto.fp7", "", "") Somehow I get an error at the line of CreateObject. I have tried with Set FMApp = CreateObject("FMPRO.Application") but it won't work either.

Is it possible to have a script runnubg that closes the application if there is no activity?? I try do get a solution to work that closes the app after 10 min idle time. Is this possible?? Thanks TMAS

Here's the situation. I have a database that basically runs monthly. Each month has a certain bunch of layouts created all starting with the month "Jan05" "Feb05" etc. For example we might have a layout called "Jan05 statement". All the fields on these layouts are also labelled "Jan05" etc. so on the "Jan05 Statement" layout there might be a "Jan05 Balance" field. What I'm trying to do is write a script that modifies a field where that field is different each month but always has a similar 5 digit code to start without having to re-write the script every month (cause it's a long long script as it is). To add to the mix, the field is a repeating field and I nee…

Hi there, Is there anyway I can use the 'unique' validation idea, but dependent on a combination of two fields, for example, say I've got two fields, ' Title' and Language' I will need to create a new record for each new title, and it's corresponding language, but I want to make sure that I cannot create two records with the same title and language. Would i need to write a script in order to do this? Many thanks

I know this should be simple but I can not seem to get it. I have DB of customers and a portal that displays related jobs. In the jobs DB I have an auto number field set up. From the customers DB I have a button that takes me to the related record in the jobs DB. I would like to go to the related record from the customers to the Jobs DB and go to the most recently created record, yet showing all records. Any suggestions?

Hi, I have a contaniner field on a layout that I have attached a script to. The script is to go to another layout to show a larger version. What I want to do is if the container field is empty I want to give the user the option of inserting a picture. I looked at the insert picture script step but it seems to require the file to be specified. Is there a way to allow the user to browse to the file where the picture is? In other words, by attaching the script, the user can't just right click and insert the picture and I would like to allow them to

I'm working with a rather large database with many fields. My "price guide" field will contain either the letter A or B. If "A" is in the "price guide" field then the following will be true for that record: starter price = $1,000 maintain price = $1500 If "B is in the "price guide" field then the following will be true for thet record: starter price = $1,250 maintain price = $1,750 The "price guide", "starter price" and the "maintain price" fields exist in all 23,000 records. At my discretion, I place either an A or a B in the "price guide" field. I want the two other fields in each record to populate automatically dependant upon the "price guide"…

Hi everyone, I think this is the right category -- I'm new to this whole thing and really need to create a database. I will be organizing a career day at my scool and students have a choice of 4 sessions that they can attend (i have made 4 fields -- session 1, session 2, session 3, and session 4). For each of the sessions, I must be able to determine how many times the SAME Value (i.e. Careers in Medicine) is repeated. This would be used to determine the amount of people attending each session. Is this something that could be done? Thanks so very much for all your help guys

I want to create a script that allows me to zoom in to 125% rather than the standard 150. I am unable to edit the script step and wonder if anyone can give me some direction.

Hi Guys I want to execute a script when the user saves changes to the current record. How would i go about capturing this event? Cheers b

im trying to run a script that uses a loop and im having some problems. here is the scenario. i enter a product number as a line item in an invoice and if there are any required products then it makes new line item for each and copies the required products into the new line items. it works great until your required product requires another product. as soon as that happens your global field that is used as a counter(exit loop if)starts getting used by a second instance of the script. any help or suggestions would be greatly appreciated Anthony

This one is killing me because it is so simple but I am having erious brain blockage.... Basically looking to write a script / calculation that does the following. If (Field name) starts with "UL" then (Client) = "Ultra" If not then "Unknown" Here is my current entry that is not working correctly. If (Field name=Left ("UL"; 2) ; "Ultra" ; "Unknown" ) Someone please save my brain from the fog it is in. thanks Brad

Hi everyone, Well, I need to change our inventory structure. Originally, there were only two 'expirations' of stock (Current and Old) so I created fields for them (in the Product table) instead of another table. As inventory is pulled (entered in LineItems), it summarizes in the Inventory table (using SecureFM event trigger). From there, system checks the Old field (in Products) and pulls from there until exhausted. New stock added (in Inventory) first moves the New to the Old and then writes to the New (we never had overlaps). My reasoning for the constant writes? Size of the files and slow searches and summaries. And we post every day (our orders ARE o…

Hi- I've made a timer script which has a loop structure with a 60 second pause, to count down an alotted time period in minutes by referring to the system clock. The problem is that while the script is running, the window from which it was triggered remains in focus and no other Filemaker window can be selected (except by using expos

I have three databases: - Users - containing all student information, including the subjects they take in 6 separate fields, which are chosen from a value list (group 1 value list shows group 1 subjects, etc). - Calendar - containing upcoming deadlines. The "subject" field for each deadline is chosen from a master value list (which contains every single subject from the value lists 1-6). - Default - where the login page layout is, and where students should be able to see their upcoming deadlines according to the subjects they've chosen. I want it to look something like this: I'm really unsure of how to go about it so any input would be grea…

I have a recipe database that I am making for a school project, i am working with FMP 5 on windows version and FMP 7 on Mac. The problem is I have pop up menus on the start page and I would like to search the database with them. This is the script I have so far but it doesnt display them in the table view: Enter Find Mode [Pause] Go To Record/Request/Page [PROJECT::Name] Enter Browse Mode [Pause] Go To Layout ["Table View"] I have tried moving the order and everything but it just doesnt seem to want to work. If anyone could help me I would be so greateful, the project is due the end of this month !!

Hello Filemakers, I am using Filemaker 7 and would like to create a script or a calculation that would enable me to find a string within a field containing large amounts of text and then, after it's been found, replace it within the text with a different color. It's important for me that the changes done within the text remain permanent. Could anyone suggest me the easiest way how to do that. Thank you

I have a database where I have a related file to hold payments for participants. I would like to print a receipt for each entered payment. I have a layout in the main file with a portal to the payment file to enter payments. I can print a receipt for the first record only. I need to have the receipt print for the current payment entry. Receipts will printed as payments are entered. How do I get the script to default to the current entry? It seems to print the first payment only. I tried to have it go the the last portal line but it still prints the first record. Is there a better way to handle this?

Is there a function that will express any number in time format, eg 2.5 (hours) or 150 (minutes) or even 9000 (seconds) returns 2:30:00? Also, does anyone know of a timer that works with Filemaker, that can count down (or up) in realtime from a particular timestamp?

I have a script which inserts a signature and timestamp into a textbox containing several lines of text. Is there a command/calculation that will allow me to make sure this is always applied to the last line of the textbox?

I am trying to make a script in scriptmaker to send images from FileMaker Pro to iPhoto. I have my pictures in a FM database and want to create a button which would take the image and send it to iPhoto's library. Any ideas on how to do this?? many thanks!

Hi! When I Script a Containerfield with a File Reference it all runs perfect until the File is renamed or deleted. Then I've got a problem with it poping up with its own window wich brings up the Insert File Window that offcourse dosent make a reference, it inserts the hole File. Do you follow ? Thanks in advance!

This is a little odd. I'm trying to integrate an old mailing list into a new one, but the people who maintained this list didn't stick to a standard. I have the following fields for a contact: "FirstName" - Betty "LastName" - Smith "FullName" (this is for mailing labels and if there's more than one person) - Betty Smith "Salutation" (for form letters-this field automatically copies the first name) - Betty "Organization" (for company names) But the old list is as follows: "LastName" (they also used this for company names) - Smith "FullName" (they just threw in the first name here) - Betty Smith "Salutation" (sometimes they used this...sometimes not) …

I'm pretty sure this is a bug in FMP7. I have a Print All script that opens a new window, performs a find, loops through all the records and prints each one, then closes the window. The problem is that FileMaker then switches my original window to another layout. It's always the same one, and unfortunately, it's a utility layout that's of no use to the users and completely takes them out of the navigation system I built. I remembering having this problem before, but i can't remember how I solved it or worked around it, I also can't find any threads here about it. Has anyone else had this problem? It's kinda a big deal over here. Thanks

I'm relatively new to FM so this may be easy or it might not be possible. I have a script that finds and then sorts data for a report. What I want to know is there any way to use a script to change header text? Ideally this would be for a label only, I don't have any fields in the header.

Ok, first I'm going to simplify the problem down as much as I can: I have two tables: "Course Admin" contatins grade and a text field for the grading scheme. There are several records for several different courses in this table. "Calc" is a customized virtual calculator that I created to facilitate the creation of the grading scheme. There s one record, with one field called calculation which is set global. There is no relation between the tables. I have script set up that when executed: 1. passes the grade scheme of the current record to the calculator (uses "set field") 2. opens the calculator file 3. switches to the proper layout for the course Now, o…

I'm completely new to FMP. I'm creating a DB for my company's mailing list. I have a fields for "First Name" and "Last Name" but I also have a "Full Name" field that I would like to automatically enter the data from the "First Name" and "Last Name" fields. Just cuts down on data entry. Can this be done? How?

Simply I have a popup window (new layout) that is opened by script called "OPEN" at the end of the script is the step "pause resume script {indefinitely]". This is intended to insure the window is closed properly before continuing, or that multiple windows are not produced if exited otherwise. A close button is used to execute the script called "CLOSE". This script is simply "close window (nameOfwindow)". The problem is the script step returns to the "OPEN" script waiting for the user to click on "continue" in the status window. How can this be avoided.

I am new to Filemaker and I am looking for a way to have filemaker run a script everytime a record is created. I was told that this feature was added in FM7 but I haven't been able to find it. Thanks in advance for any help.

I have a portal within a layout containing medication name, dose, frequency etc. The final field is whether the medication is active(1) or inactive (0). I would like to write a script that if the active value is 0 (unchecked) then it would change the color of the fields (medication name, dose, frequency etc) in that one record to grey to distinguish it from the active meds. Is this better performed with a calculation field or a script.

I want to have a new window open up to a specific layout (easy to do) and I want the new window to be static. I don't want the user to be able to change the record that they are in or the window size. They do however need to be able to change the field values in said record. I can hinder record navigation by hiding the status area, but navigation is still possible using keyboard commands.

I am very new to scripting and would appreciate input to help me do the following: What I want to do is create a button with a script that copies a value from one field in the current record in Table 1 and performs a find in Table 2 on a field in a portal to a separate table occurrence of Table 1 (and then returns the found set of records for which the field value in the portal matches the value from the original record in Table 1).

Hello all, I'm having trouble returning to a particular record after leaving to perform some calculations on a group of other records. When I try to use Go to Record by calculation script step, I haven't been able to determine what value I need to make it actually find the record in question. I've tried serializing my records, using the record number, recrod ID. Can you help? Thanks for any help you might provide on this.

Is there any way to make a search on unindexed field so that the search does not take an hour? I have a database of 40k records and I have to search a calc field(unindexed). I have tried to do a set field of the calc field with a regular number field but the setting of the field takes about as long as doing the find. Does anyone know how to help? Thanks

I am looking to make a script to find all the duplicates for a single field (name) so that for each occurrence of "Jen" it would count the number of "Jen" in all the records and set that count into a field for all those records. I have been working with a duplicate script(I attached it as an image to this post) to get this done but I

Hi. I have a school alumni database which, among other uses, we use to publish a quarterly newsletter. I would like to generate a report that would tell me the total occurances of certain zipcode values which reside in a zipcode field. For example, after sorting the database to show only those records who recieve the newsletter, I would like to know how many 95060, 95062, 95066 values occurred (both individually and in aggregate) and, ideally, output it to a report. Would anyone mind pointing me in the right direction (I'm assuming I should start with Scriptmaker)? thanks, Teresa

I want to include a script to insert the current date. But I want it to a field and then go to the very front of any text in that field and insert the current date. Is there a way to force the insertion point to the beginning, not the end of the existing text? LR

Hi, thanks to lots of help from this forum and others, i managed to build my database and get the logic the way i wanted it.. Many THANKS Now i need a little help writing a script as i am not very familiar with all possibilities of filemaker. Here it is: In one of my layout(Project Detail LAB REPORT), results are entered in a portal (storing them in layout "Result") Now i have a button on the layouts that trigger a script to build a report of all the tests conducted with the results (10 different fields each rows) What i want is to have the scripts filling in these fields automatically Thanks for any suggestions on how to do that, so far i've tried t…

Hi, i want to write a script which i can Use from one layout to perform a find in another. I First make a Perform Script Parameter: Table::Table_Name Then i go to layout, go to Find Mode, set Field Get(ScriptParameter) and then -- I dont found out the possibility to send a CR (Carriage Return) or Enter by Script. So the Find stands by, with the field filled out with the right Variable, but gives no conclusion, every time the user has to Press Enter manually Thanks a lot for Answer, Mike

I have come across a simple and disturbing bug in FM7 and would like confirmation from other users (or some advice to correct the error if im making a false claim). Here goes. Bug Number 1 I) I setup a Filemaker Script 2) Inserted a perform native Applescript step. 3) Applescript works well EXCEPT when attempting to alter data from the FIRST record in the current set. Seriously, just a simple Applescript attempting to set basic data fails to the "Record in current use" error on the first record, but works on all the other records. Is this a bug? Bug number 2 When revising said Applescript for a runtime solution, setting field data fails for AN…

Any help really appreciated - have been stuck on this problem for last 3 days! Have a basic script when user peforms find, that takes to new layout showing find. Now want to show message in this layout if the end users find = '0'. I have this script: Set error capture (on) Show all records Peform find (constrain found set) If [status(currenterror) = <>0] Show message [custom message] End if Go to layout["full record"] Set field ["Total no of records'] I have changed it around, with Go to layout & set field above IF command. But it either just takes me to new layout and not show message or always shows messgae when found some records…

I would like to know if it is possible to display a fields contents within a Show message script step. also can a fields contents be used to label the 3 buttons in the Show Message script step? thanks

Here is what I would like to do but I don't know how to script this: I have 6 global fields on a screen they are layered one on top of the other. I have six buttons - I would like to click on a button and have a specific field come to the top. Then I would like to click on a different button and have a different field come to the top layer. I do know how to script - just not how to do this in FM Pro. Thanks for any help you can offer. B

What I would like to do is create a script attached to a button which copies data from a portal into the current layout. Here is what I am trying to do. I have created a multi key for business names. The portal shows the matching names. If the name I am looking for is in the portal I would like to press a button and have the information inserted into the respective fields on the current invoice. I would also like for it to work in reverse. If there is no match then I would type the information on the invoice press a button and it would be inserted into the related file. Scripting is new to me and I am getting in a little over my head. I would still like to try and g…

I have a script that finds records by looking at a "date" field that are less than 3 years old. After the find, I want to be able to color the text red if any record that will be older than 3 years 6 months from now, blue if it will be older than 3 years 3 months form now, and yellow if it will be older than 3 years one month from now. Help is appreciated

I am trying to create a script to print box labels. I want the user to enter in how many boxes of "a" quantity, how many boxes at "b" and how many boxes at "c" quantity. For example; 3 boxes at 1000, 1 box at 950 and 1 box at 275. This would create single shipment of 5 boxes. I need my script to create 5 box labels with the following information; "box 1 of 5, quantity 1000; box 2 of 5, quantity 1000; box 3 of 5, quantity 1000; box 4 of 5, quantity 950, box 5 of 5, quantity 275" Any suggestions??

Please excuse my ignorance, but what does this symbol mean

I'm trying to create a field my workgroup can use as a "commentary" field - where we post our comments to each other. I'm trying to get a script to enter the current user name into the field above the current contents of the field, to make it look something like this: -------------------------- Username: PreviousUsername: Comment -------------------------- I've been trying to copy the contents of the field, then paste in the current username, then paste the previous contents of the field into it. The only problem with that, is the cursor is at the end of the field when the script completes, and I'd like it to be after the new username it entere…

Ok, here I go again with another "newbie" question... I have a running amount of Layout Pages that I need to create for a project and need an easy way for the end users to navigate to each page easily. I was first using a button method at the top of the pages themselves but the buttons are starting to add up and it makes the interface look cluttered. How can I create a

Hi, This is a fairly simple question (for all of you), but one I need an answer for. I have several hundred e-mails I'd like to capture into FM. I need to parse unneeded lines and put my field info into FM fields. Here is a sample below of one of the e-mails. Any help will be appreciated. Please excuse my newbeeness. The following is the contents of a form submitted on 20-Jan-05 at 03:11 PM: FIRST_NAME: neville LAST_NAME: ribeiro ADDRESS: 4254 renoak ADDRESS2: CITY: mississauga STATE: ontario ZIP: l5c 4k1 COUNTRY: Canada PHONE: 905 275 8285 FAX: EMAIL: [email protected] ENG_MAKE: o320 h2ad ENG_MODEL: ENG_SERIAL: AIR_MAKE: …

Hi, I'm using FM Pro 6. I'd like to import a small text file (couple of lines only) into a global text field. How can I tell "Import Records" script which field I want to import the text file into? I do not want "Import Filed Mapping" dialog to be displayed. (Perform without dialog) Is it possible to do something like: Import Records[From "c:input file.text" into FieldName]?

Hi, I can launch from Filemaker script a VBSript that shows File Open dialog. FileMaker continues execution of the script and doesn't wait the user to select a file or close File Open dialog. How can I pause FileMaker script and resume it only after FileOpen dialog box is closed? Thank you for the help!

I have a set of databases connected through different relations. Each database has a startup script that is launched when the database is opened. So fa so good. Now i have one database (it is a child database) of which the startup script is not launched when the database is opened during a relation calculation in my main database. All other child databases work perfect. If i open this database directly the startup script is launched. I have tried 1] renaming the script and resetting the document setting 2] recover the database 3] pulled out my last hair (that wil not do the trick anymore) Please advise on this thanks Jitse

Hello all, I have been pounding my head against a wall that looks like a bug in FM 6.0v4 and I was wondering if any could shed light on the situation. It's a simple situation that has only two possible outcomes but I am getting a third outcome. Here's the script code that's not working as expected: Loop If[ IsEmpty(Related Table::Text1) ] Delete Record(NoDialog) Else Set LocalField1 = Related Table::Text1 End If Goto Next Record[ Exit after last ] End Loop Before the loop, LocalField1 is empty in all records. According to the above code block, after the code finishes, there should be NO r…

This problem is related to a script, portal and value list, so I hope I'm posting to the correct forum. I have a layout where I'm using a pop-up menu (field name: StandardInfoRelatedPages) to populate three fields in a portal. The pop-up menu is populated by a value list. The value list is kind of complicated because each "value" actually contains three bits of information, which are a title/headline, URL and description (for example: My Site^http://www.mysite.com^Generic description). These bits are separated by a "^" character. Once a value is selected in the list, you may click a button that triggers a script that parses the value list and fills in the title/…

I have some people that creates records in browsers. I would like a mail send to the same mail adress when a new record is created. My plan is to setup a filemaker client that looks in the file when a record is created. How should the script look like. Loops? Any suggestion or script examples.

Hi, I'm using a simple script to run a report - the user presses a button to bring up a custom dialogue box in order to input the Company Code which limits the report to one company. The attached script does just that. However, one of our companies needs a report which omits one person's details (Contact ID); it also needs a report which will run a report based on just that one person's details. I've tried adding another custom dialogue based on "If this particular company code is entered bring up another dialogue box asking whether the report should be run just for the individual" but this doesn't work. I've either attacked this in an illogical way (quit…

Hi. I have an "Open" script that gives a legal notice. The user is asked to press OK if they agree. If they don't agree and press CANCEL, the application exits. If they press the escape key, however, it exits the script and they are in the database! I tried Allow User Abort (Off) and it didn't work. Any suggestions? Thanks much!

I am trying to show on my database: 'number of current record (to change dependent on overall found in set)' of 'number of total found in current searched set' . For example, database contains 104 records and if i make a search, it finds 24 matching that criteria. I want to show on each record as '1' of '24', next record '2' of '24', '3' of '24' etc. I am using 'Current recordnumber' and 'Currentfoundcount' to try and do this. Problems so far are: 1. current record number always relates to a predefined record number. For example, it could be no 4 of 24 found, but shows as 75 (as this is where it stands within all of database) 2. current found co…

Hi, I'm using FileMaker 6 on Windows XP. 1. Is it possible to create script that calls a BAT file or Windows Script ? 2. How the BAT file or Windows Script can retun a string back to FileMaker? (the result of the execution - failure code or string if succesful) 3.How do I store the returned value in a FileMaker field? If possible, could you please post some sample scripts? Thank you for the help!

The script Opens a file. If the user hits the Cancel button during the log-in, the script will never open that file again until the database file containing the script is closed and reopened. The FileMaker application does not have to be restarted. I have tried Get(Last Error). It returns the error, but does not "reset" whatever is going on. Any suggestions? Lynn

Hi every-one I am creating a touch screen system but with a fmp7 dtabase as the backing I have setup a touch screen system so for example you press drinks it brings up a new layout with different types of drinks then for example you press beer it adds beer to the protal record of drinks which is attached to the table and meal id's and then goes to the brand of beer you then select a brand and it places it in the portal it then moves the screen to a qty layout and adds this quantity to the portal then gets the price from a lookup and multiplies it by the quantity, the system works, but I need it be more effecient and at current the scripting i have done is horrible as i ne…

Hello, I need to create a sript that creates a new record and automaticlly enters a number in a certertin field. Everytime I want to create a new record the number needs to change to the next numerical number. Thanks.

Ok. i have a very simple print script set up in my database. Show All Records Omit Record Show Omitted Enter Preview Mode [Pause] Print Enter Browse Mode When this is run there should always be 1 record in the found set when it gets to the Preview Mode step. What could possibly cause it to have no records in the found set when it gets to the Preview Mode step? Filemaker 6 on Windows 2000

I am a total newbie to filemaker pro, and I'm desperately trying to set up a login page (without assigning privileges to users, just by creating a user database where new usernames are saved - this & the 'new user' layout work fine). However, I had been working in filemaker pro 5.5, where I had written a login script that did what I wanted it to. It was something along the lines of: If(currentdatabase::username = userdatabase::username and currentdatabase::password = userdatabase::password) Go To Layout "logged in" But when I upgraded all the necessary files to fp7 & checked that all the relationships & everything worked okay, I noticed that t…

I'm a newbie... Pls help me how to: I have 2 or more container fields for photo storage. So how to: 1. Make a script to aquire image from digital cam and put captures images into these fields one after another, automatically? or 2. Make a "file browser" field next to these fields, and drag-and-drop images from the browser into the fields? 3. How to sync EXIF info of original photos into File Maker fields, and edit these infos directly in File Maker? 4. Actually, I'm making a Medical Record database. Many patients will come back for follow up visits. So physicians need to exam and enter patient's infos just like the first time examination. H…

Hi. I setup a custom dialog script step. I added input fields, but when I execute the script step and add the data to the input prompt, it doesn't appear in the input field. Any suggestions? Thanks.

I have a problem with a script that I wrote. One of the steps is a print step. The problem is that when it stops to ask how many pages to print etc, if they click cancel it asks them if they want to continue with the script. The problem is that lots of people click cancel and then they get stuck in find mode or somewhere that they don't know how to get out of. Is there a way I can use an If statement to just go back to a layout if they hit cancel in the print window? I was thinking Get (LastError) but I'm not sure about that. Thanks

if I use the import records script step and chose folder as my "data source" I can no longer select the "import order". Nothing happens. Is this a bug and is there a workaround?

The situation: I have two tables in a relationship together linked by a "date" field. Table 1 has a portal in it linking to the "date" field in table 2. The date field in table two is a calculation that does not store itself. It is simply a Get(CurrentDate). The problem: I have realized that you will always get an index error when you link via a unstored calculation. So here is the problem... how would I get "date" in table 2 to change whenever the date changes. What I have done: I have tried a "start-up script" to set the date but it simply doesnt work. Another issue I have is the fact that table 2 is instanced 37 times. Thanks, Jacob

I am using version 4.1 of FileMaker for Windows and have created a script that needs to print to two different printers. I would like to write scripts so that the printer setup is restored so that the program automatically prints one layout to a dotmatrix printer, then the script continues and goes into another database and prints another layout to a laser printer. However, I cannot seem to get the script(s) to change the printer it is outputting too. It seems that all the script are automatically changed to the last printer used, even though I have checked the "restore" box in the script printer setup function. Can anyone help me determine how I can have a script change…

I used to use a very easy technique in FMP 5, 6 etc to move between databases and for some reason it does nto seem to be working in 7. I would write a short script in target DB that said: Goto layout "xyz" and call it move to xyz. then in Original DB I write a shorts script that says: perform external script XYZ and all worked just fine and dandy. Now in FMP 7, this no longer works. I am just stubbornly stuck and not able to move into the other DB. Can anyone please help? this is freaking me out. I am getting so tired of having to relearn everything that used to work do well for me in the past. All I want to do is move from one DB to ano…

I have a main switchboard which links 7 other databases via buttons and scripts. It works well to take me from main switchboard to individual database. In individual database I have another button that say exit, which is supposed to take me back to the switchboard (which it does) -- here's the problem. I tell the script to close the current database before it goes back to main switchboard, but it doesn't close the file - it does return to the main switchboard, but when you exit the switchboard the other database is still open and you must close this separately. here is the script I have on the exit button: close file [current file] open file ["switchboard…

Is there a way to dynamically specify a field in a "Set Field" script step? In other words, can I "Set Field [calculated field name; calculated/stored result]"? I have come across one solution that loops through fields on a layout that is not visible or modifiable by the end user: http://www.fmforums.com/threads/showflat.php?Cat=0&Number=138056&an=0&page=0%23138056 Is there any other way to do this? I have 13 scripts that are all 3 lines long each. These scripts are very similar and just use set field commands to set values in particular fields in several different tables. I would like to bring this down to one script and use script paramet…

Just recently upgraded to OS X (10.2.8), and from FMP 5 to 5.5. Now I cannot find the Dialing preferences setting. Where did they put it? Version: v5.x Platform: Mac OS X Jaguar

I have written a script that looks at two fields and if they aren't empty then it it runs a set field step to check a check box. I would like this to run automatically. Perhaps when someone type something into a field, then it runs this script. Is that possible. Can I do that as part off a calculation?