Script Workspace and Script Triggers

My solution is just about to be relished on it first beta test, but I

I hope I'm missing something obvious. I'm working with two database files (eg,A-file and B-file). In A-file (patient information) I have some fields that are used in a B-file script to create or delete B-file records(Representing Invoices). Once the information is entered in the A-file the user hits a button that runs an external scipt in B-file to create the Invoices. This usually seem to work fine. I also have a "clear" script in the A-file to reset the fields (using set commands). Now, here is the deal. After I use the "clear" script prior to entering new data for more invoices, the B-file script doesn't seem to work the first time. If I activate the scrip…

sometimes a Perform Script script step appears in the list as Perform Script [scriptname (*)] i think this may be true for scripts that have been imported, but i'm not sure. when i click the scriptname, the star goes away, but when i open the script up again, it is back. what does the star mean?

Hi everyone, Sometimes some records in my FM database are duplicated. I tried to find why, and witch user was guilty, but I couldn't. So I'm wandering if there is any way to know witch script made a new record to be created? Like a flag or a control field that would tell me exactly what, when and who created each record...I know that there is a field that tells us the creator, creation date, modificator and modification date, but it's not enough I need to know the script that cause the record to be created... Thank's a lot in advance!

Hi. I using FMP 5.5 for a screen with 5 portals. I want to work with records in one of these portals, looping thru the records. The loop runs forever - so I'm either stuck on row one of the right portal or I'm not looping on the intended portal. I think I'm making the right portal active by Going to the leftmost Field in the portal and I think I'm looping thru the rows of that portal using Go to Portal Row(Select, Exit after last, Next. This command preceds the End Loop. Does Going To a portal field make that portal active? Does it stay active until if/when you Go to a different portal? Does FMP lose track of what portal it was using if, within the loop, non-por…

This seems like it should be so easy, but despite poring over the manual and experimenting with several different techniques, I can't get this to work. I have a simple contact database with a check box field "Mailing Dates" with a value list of dates of past mailings. I now want to update the database to check the box next to the value for the latest mailing for a found set of records. I'm a neophyte at ScriptMaker (obviously) and I can get as far as finding the Mailing Dates field, but for the life of me I can't figure out out to write the script to have it check the box for a certain value. Any pointers greatly appreciated. I'm working in FM Pro 5.0 on a Mac. …

I need to find a way to look for related records or skip the step if none exist. What I really need is: If Status(CurrentRelatedRecordCount)=0 Go to Record (Next) exit after last... or something like that. Is there a way around this without performing a find in the related file?

I have a strange problem. I have a repeating field in my master db called _mm_codeholder. I have another repeating field in another db called _dr_codeholder. Both have 12 repeats and I want to use them to hold a number of codes which will eventually refer to other records in the db. Trouble is, I don't seem to be able to get a script to copy the 12 instances of _mm_codeholder over to _dr_codeholder. Only the first gets copied. I am using Set Field, specifying the repetition to be set. That works OK when tested with data from another test field. I am then using GetRepetiton(_mm_codeholder, n), where n is set in each of 12 script steps to be from 1 to 12. …

Hi, All--Hope you can help! I have a "dummy" file I use to collate records from other files, to get them all into the same place. As I use it, I need to delete all records, then import the appropriate ones. No matter how I set up the "Delete All Records" script step--whether as a script in itself or as a step in other scripts--Sometimes it deletes the records, and sometimes it just ignores that step altogether, and imports the new records on top of the old. I have used "Show All Records" first, and "Show Omitted Records" also in conjuction...I've tried a bunch of things. What's happening here? Thanks for any help you can offer, Stephen

What i have done is converted an xls file. There r only a few fields, but the field i'm trying to do a makeover on is the phone #. I have converted the xls file over to FM and there r a couple of hundred files. I want to make a change using a script that will go into the field phone # grab the last four #'s and move them into a new field i have created. Is this possible?? I can use AUTOIT scripting, but i would rather do it in filemaker. Thanx for any and all Help!

I'm using an If statement at the beginning of a script to check if the user has selected a customer: If [ "IsEmpty(CustomerID)" ] Show Message ["Please select a customer."] Go to Field ["CustomerID"] End If My problem is the script doesn't pause long enough for input. What's the best method. Thanks.

I'm impressed at what can be done with filemaker as I read the forum. I'm new at using the program. I'm hoping that the following can be done. I'm using Troi to list the graphic files in specific folders as the user specifies. These folders hold patient jpegs of photos and x-rays. I would like to be able to search with a script the list of file names in a folder to determine which file is the most current. Each item(filename)is named by date and time created. If this can be done,I could use Trio to display the most current x-ray file for the doctor. Can a global field that has a text list be searched? Is it possible to look at each list item one at a time i…

We have a field that we want to force our users to enter a value into it. I have a navigation script that takes the user to a different layout and I entered the following steps: IF(IsEmpty(Field)) Then ShowMessage Else Go to Layout. This works great as long as they use the navigation button. A lot of users will close out of the program manually from this screen without using the navigation button again. I tried using the validation in the field definition but that did not work because I use the field in a portal in a main file that they start from. When they leave the main file it was prompting me to enter a value into the field even though the field wasn't on the la…

I'm just wondering - I'm new to FMPro and am trying to sort out a database that will be used for inventory. I was pointed at FMPro and am wanting to know if I can build a database to do the following 'relatively' easily (I have reasonable programming skills) before I go ahead and purchase the full version? Need to: Set up many different product lists with categories for part, lead time, supplier, parts per product. Make calculation reports that I can input number of products and it will define a separate list for each supplier with how many parts to order for that number of products I want to build. Interface with accounting software at a later date (MYOB if yo…

The strange thing is--it works--but randomly. 1. A contacts db with a city field is related to a city/county/tax rate db by city. 2. The user enters city name in contacts db and opens related record in city/county/tax rate db by way of a button based on city::city relationship. 3. A set field script attached to a button in the city/etc db copies the county and tax rate to the contacts db. 4. Problem is...in many instances it copies the data for some records but not for others; regardless of the fact that the same relationship works with a GotoRelatedRecord script from either db; meaning that both city fields are identical. Yes? I'm stumped by this: if it …

I am wondering if I need to do this in a script. I want the sort function to ignore the word "The" from the Title so that it would sort by the second word in the title. Any thoughts Paul

Hi everyone! I have a General Ledger listing (data import from DOS-based AccPac), which has one GL# on one line and it

Hi there, I got a little problem trying to run a script. Using two databases, I need to update one of my database using the values contained in the other base. So here goes I loop through the records in my first database, let's call it base1, for every record in the base, I have to see if it exists in the other base "base2". So far no problems. So I call an external script from base1 located in base2. Basically, what the second script does, is just looping through every record in base2 to see if I've got a match. My problem is this, when the second script is running, I have to check if two fields, one in each databases, are equal. But, it seems t…

I'm really dumb ... I've done this calculation before ... I just can't get it to work today If the current record = 0 go to "X" layout

Hi. I have two databases (MASTER DB and VOLUNTEER). I have set up a button in MASTER DB, connected to a script (CREATE NEW VOLUNTEER) that, as you would guess, opens the VOLUNTEER database and creates a new record. The script for CREATE NEW VOLUNTEER is as follows: Open ["Volunteer"] Perform Script [sub-scripts; External: "Volunteer"] This subscript relates to NEW VOLUNTEER RECORD script in the VOLUNTEER database and is as follows: New Record/Request Perform Script [sub-scripts; External: "Master DB"] Paste [select, "Volunteer ID"] The external script above is simply Copy [select, "ID Number"]. I've used the same two commands within this script f…

Ok, I want to make a particular layout, but I'm kind of confused as to how I should design it. I guess the best way for me to describe my layout is to show you how I'd like it to look. First off, here are some of the main fields... Song Title, Film Title, Status (can be one of three options...New, Researching, Complete). And here is how I want my layout to look ___________New________Researching_________Complete______Totals --------------------------------------------------------------- Film 1__|___2______________0__________________1_____|_____3 Film 2__|___0______________9__________________6_____|____15 Film 3__|___5______________1__________________3…

I have a creation user field that is set to prohibit modification of value. If I try to modify this field on a layout a message will splash to inform the user it's not possible to modify this field. If for any reason or even a mistake on a script this field is modified by a script , data in it will change. How can this be possible ?

Ok, What I have is a contacts database with info about customers. One particular field that this db stores is sex (male/female/other). I have created a report that will sort and list all my contacts and group them by their sex. But, I want to add a page break between each group (for example, males on one page, females on a 2nd, and so on). How can I set up my report so it will insert this page break? Thanks for the help. Cameron...

I have a field called CompanyName. I'm trying to write a script so that I can find all Records that begin with a certain letter. All I've been able to figure out is to do a Find on words that begin with a certain letter. If I do that, the company ABC Cans will appear in a search for A and C. Is there a way to do a search based on the first letter (of the first word)of a company name?

for some reason the following doesn't work: modify last find set error capture [on] now wnenever i try and do an IF statement (i want to put my own error message and buttons instead of the filemaker one's) FMPRO ignores my error message and puts it's own. . if i put a" perform find" command after Modify last find then the script works .. Any ideas Paul Apted

I need to perform an external script and I need to pass it some parameters (arguments). What I do is: 1. write the parameter in a global field TEMP_A 2. copy to the clipboard the global field's content 3. performing the external scipt. The external script pastes the parameter in a global field TEMP_B then access the data and performs. It works, but it seem to me a very inelegant procedure (a hack). It comes difficult to pass several parameters and the user loses the content of the clipboard. Another solution is to use a specific file for storing parameters. Access to parameters is achieved trought relationships. This work but it is a very co…

I designed a FileMaker Pro database on a PC. It has many Show Message scripts that have 2-3 paragraphs of text each. After installing the database on a Mac, the text displayed when the show message scripts run is truncated to the first 255 characters. Why is it doing this? Is there a way to have all of the text display? Thanks for any help you can offer.

Hi I was reading an interesting post and wanted the opinion of all you wise FM'ers. A new record isn't really *created* until a field is exited, right? This post was a discussion between Andy Gaunt and WhiskeyWolf on FM Cafe' and they mentioned two options when scripting: 1) Exit Record Request at the beginning of the script and 2) "go to field "cursor." I searched on Forum and couldn't find a relevant post. The similarity is obvious but I think it's important to understand the differences. FM (non-HELP) says: Exit Record Request puts the cursor not in a field, Go To Field puts the cursor in another field, and Go To Field "cursor" isn't listed. This is…

Hi everyone, I have a set of records, one field being ClientID. There is a second field called 'Select' which is just a '1' toggle. There may be 50 records belonging to one ClientID, but only one of those records will have a 'Select' = 1. I need to be able to find all of the records for a ClientID if even one is selected. Then I need to delete them. I'm having trouble picturing how to accomplish this. LaRetta

I have working with my app for months and have it working (at least doing the things I need it to do).. However, this was with one user. Now that I have it on the server with multiple users, I find a fundamental flaw in my understanding of storing data... help!? I have a button which shows all scheduled jobs. When the user clicks on this button, I have a loop which looks at all records omits records in which field a is set to "done". The problem is that when this script is performing it is slow (maybe I should have used a find instead). Also, when other users attempt to perform this script it states that records are being modified by other users (I assume becasue the…

Yikes .... Need some help here. I need a script to save a copy of the current file in a folder ... however here is the twist ... I need the file to be named the data from a field called "filename" ... Then I need to attach that same file for a send mail function. I would prefer to have all of this done with our user intervention.... Any help you caound offer would help.... Heck you can even call me at 800-547-6237 ext 13 until 7:00 PM est or tomorrow ...

There's something I'm not doing right. I am importing info from 3 data fields from a related record via script. If I run the script 'with dialog' and set everything up, the import runs fine, I then test run again without dialog and everything is great...until I close the databases then reopen them, the data is now brought into incorrect fields. (I find the 'replace..keep' dialog encountered after the dialog change to be confusing). What am I missing here?

Let me explain. I want to try and extract postcodes (UK equivilent of Zip Codes from a CV field (resume field!) so that I can automatically populate a Postcode field. The only way I can think how to do this is if FM Pro can locate the first instance in which a number is next to a letter (with no spaces inbetween) and then extract from each side to take the whole postcode. Examples of postcodes are B91 3PH, WA14 4UA, M1 2GH etc. Is this possible or does anybody have any other ideas on how these can be extracted? Any help would be much appreciated Cheers Nick

Hi, I want to block or enable the fullfilling of a field, depending on the value of another one. Example: - If training = "done", then enable the field training_date to be fulfilled. - If training = "to be scheduled", the field training_date must be blocked (the date has not been defined yet). What is the best way to do it? Looking forward to any help. Thank you!

Is there any way that I can have a script add 40 new records to my database with out having 40 "New Record/ Request"'s Just wondering

In the "show custom dialog" script step, Does anybody know if there is a restriction on how much characters can be used in the "dialog message" field? It seems like only 255 characters are accepted:( Maybe there is a way to overrule this?

Is it possible to allow the user to abort a lengthy find, but have the containing script still continue? I'd like to return the user to the proper layout and set the status area back if they cancelled the find. Sample code that I thought would work: Allow user abort [off] Goto Find Layout Hide Status bar Enter Find Mode [Pause] Allow user abort [On] Perform Find If[status(CurrentError) = 1] Perform Script [Return_User_Somewhere] End If Perform Script [Display_Found_Results] Obviously this is stripped down, but the concept is there, but apparently if the user cancels the find, the script dies right at the Perform Find step. Leaving t…

I have the simplest loop script that isn't working and I'm tearing my hair out trying to fix it. It goes like this: Loop If ["Field = "no""] Omit Record End If Go to Record/Request/Page [Exit after last, Next] End Loop It's part of a larger script, but for testing, I made it into a script of its own and it still doesn't work. I have 317 records, and in 158, that field is equal to "no". But when I start with all records shown and run that script, it consistantly leaves me with 234 records. Could someone please give me an idea of what I could be missing? I'm used to having to hunt down the little things, but this is ridiculous... Thanks.

hi, I'm using FM Pro 5.5 I want to display the value of a field in a dialog box (like the Show Message) and ask for confirmation? if the user selects "Yes" then i want to prompt him to enter a value also in a dialog box ? Can anyone tell me how to do this ? How can i display the value of a field in a dialog box ? Thanks a lot

Hi there, This is probabbly an extremely basic question but I've been at it for the longest time. How would one make a script to search for for fields that aren't blank? Basically, I have a database with records of shot numbers. I want to do a search for completed shots. Those completed shots would have the completion date in the completion field instead of having a blank field. Any help would be appreciated. Thanks

I am creating a invoice system and on the internal side we keep credit card numbers (i.e. 4412-5647-9568-5423) while on the client copy we want to mask the back end of the credit card numbers (i.e. 4412-XXXX-XXXX-XXXX) for security reasons. Is there a way to write a script to automate the masking of the numbers? Thanks, Ryan

I have one field that has three repetition. I want to set repetition 3 with repetition 2 and the repetition 2 with 1. Set Field ["field"-3. "GenRepetition,(field,2)"] Set Field ["field"-2. "field"] In my tests it will not work in 5.5 OS X or 9.x. Insert calculated result does not work either. Is this a bug??? Help.

I use FileMakerPro 5.5v1 for my mailing lists (which I send as a file to a mailing house who will ink-jet our envelopes & catalogs). I'm a beginner at all this. If someone could please help me with the following task (?script?), it would be much appreciated: I have a primary delivery address field (ADDPRIM) and a secondary address (ADDSEC) field. How could I set up a script that would automate the following for each of the records in a given mailing list file: In each given record of my list file, if the ADDPRIM field does not contain data, then move the data from the ADDSEC field to the ADDPRIM field. (But if both ADDPRIM & ADDSEC fields contain data, …

please help for the sript to email in filemaker

Hi, I wanted to create a single button that toggles between the 75% and 100% zoom level values (I'm working on a Mac w/ FMP 5.0). I know that in both the Specify Button function and Scriptmaker, you can select the "Set Zoom Level" command and specify what zoom level you want the button or script to give you. But I couldn't find anything that would let you click the button once to reduce the document and then click it again to enlarge it back to 100%. I tried making up a script but up till now I've only done very basic scripts. Any suggestions? Thanks, Lee

I have a system working with a server and 10 clients. The files are at the server machine and I'm working sharing the database on a network. The question is when I use a startup script, does it execute on the server computer , where the files are located, or does it execute on the client machine that activated the script ? Does the startup script work the same way the perform script works ? Luiza

I have a row of buttons each which shows a date. When the button is selected the piece of equipment is shown and the total hours are shown through a summary field editable so that when a date is changed. I also have a button that creates a subsummary report that shows all days and hours and works fine... Is there any way at all to have a subsummary report that is not viewed through the preview mode...ie. (in browse mode) editable while viewing all jobs for all days? thanks c

Is there a way to show a button in a container field? I would like to be able to select a photograph of an employee and use this photograph as a button to start a script. As the script develops I would like whichever photograph I select to also show up on the layout. Can anyone help me here?

hi, I am using Filemaker 5.5 When i display reports in FM they are not sorted according to the selection i made when i created the layout. I have used the "Sort" step in the script, but still they are displayed unsorted. How do i ensure that the reports are sorted ? Thanks

How can I have a script run automatically when you load up the layout? I have an opener file sitting on the local desktop, and I want it so when you open that it automatically runs my script that opens the correct hosted file. Thanks

I have the following in a If statement in a script. If[

hi, I am using FM Pro 5.5. I have a script that performs a find on a certain condition and displays a report(that contains records that matc the criteria. Offcourse). How do i revert back to displaying "ALL Records" once the user shifts to another layout. For eg after displaying the report a user shifts to a layout that displays the details of all employees. Currently i see only those records that were retrieved after the "Perform Find" was executed. Thanks

I have a simple script which opens a cash drawer through a receipt printer. Now I would like to keep track of the last 50 (or whatever) times the cash drawer was opened, and who opened it. The current user's name is stored in a global field--so no problem there. I would like the cash drawer log to be in a single field in a single-record database file (my configuration file)--again, no problem. So all I really need to know is, after I add a new line to this field... set field, cashLog, cashLog & "

I was entering a date today and wanted to enter yesterdays date. LSS, I messed up my script and who knows what I put in the field. I found the

Hello Guys! I hope everyone's weekend is off to a good start! I am trying to set something up in Filemaker, but unfortunately my skills are still at a basic level, and what I'm trying to accomplish is a little too advanced for me to do on my own. Thus, I am looking to you 'experts' out there for help. I am trying to set up a contest, and I think Filemaker is capable of doing everything I need. Here is what I want to happen: -Each user answers several different questions where I have specified the possible values. -Then once everyone has entered all of their answers, I can run a script that will tell me who go the most correct. -So, if for question 1 …

Hi everyone! FM6, WinXP: I have a text field (custom Value List) called Status. If a User changes the status of a Client from "Active" to "Terminated", I would like another field (ClientShortcut) to change to blank. Well, I've written a script (see below) but when I attach it to the Status field, the pop-up list no longer functions and a User can't even CHANGE the Status. I tried changing the Status field to a validation by calculation (only if modified) to Status = Case(Status="Terminated", ClientShortcut=""), but that causes more problems ... when User tries to change Status from "Active" to "Terminated" message says 'field can only accept specific values.' …

I was able to create an "ADD RECORD" button that verifies if a user has hit the max allowed record limit. What i can't figure out is how to have the button actually create the record when i have disabled most menu options. It seems like if the menu choice for "new record" is not available then even my scripted button will not create the record. Is there a way around this? Thanks --Dan

Lately I have been noticing that many of my external "Perform Script" script steps contain an IP address, like this... Perform Script [sub-scripts, External: "Line Items.fp5 (192.168.0.108)"] I do have the databases set up as multi-user, but I am currently just developing it on one machine. If I double-click the script step, the IP address disappears, but it returns after restarting scriptmaker. Should this concern me? What can I do about it?

hi, Sorry if I am asking a silly question. But i am new to filemaker 5.5 and wanted to know as to how can i update a single field in all records using a script. I tried using the "Replace" command , but it pops up the dialog box where i have to confirm what i want to do(i want to update them immediately). (i used the set field command but it only changes the field in the current record). Is there any other way to do it? Thanks

My brain is scrambled.. so someone please set me straight... I have four buttons. each button represents a piece of equipment. When a user clicks on a button for a particular piece of equipment it will show all of the jobs assigned to that piece of equipment..great! the user then has the ability to select a date to see jobs which are assigned to the equipment. This is done through fourteen buttons, each has a date (starting today) for the next fourteen days. I do this through find statements.... for example, when the user clicks on the equipment buttons: set field, "equipment a" etc. This works fine and shows all jobs for equipment a. Then, when the user clicks…

hi all, i have this problem: have a global field - number. have a loop that is supposed to add to the global field an amount - another number filed - with each record. it doesn't do it. the loop is more or less like this: Loop set Field ["theGlobalField", "theGlobalFirld + amount"] Go to Rec..... [next] End Loop why it doesn't work? any help appreciated...

I'm a noob with filemaker. How can I make the button goto a layout in a different database? I have the relationships set up, but the goto layout in the script only shows the layouts on the host database. Thanks!

Is there a way to change the style of a given field (from bold to unbold, or red to black) when another field is entered? For example, can a script change my due date (field 1) from bold to unbold when the completion date (field 2) is entered, or when a checkbox is marked to indicate completion? Or can it change from red (when completion date field is empty) to black (when filled?)

I built my FM Pro database with client info (such as name, address, etc). I want to build in a basic letter to send to each client. I cannot figure out the best and easiest way to design this form letter. Can someone make a reccommendation. Thanks.

Is there a way to remove the command key combos in the script list without losing the script? Most of my scripts are attached to buttons, so I don

I would like to go back to a question I asked before and this time I

Hello, How can I disable certain menu options like erase record and add record, but still allow a script version of add record and erase record to exist? Thank you. Evan Cooney

Hey everyone...first time poster here...so HI EVERYONE...hope you're having a great day! Ok now for the reason for this post. I will try and describe the situation my best. One of the girls here is wanting me to create a button that when she clicks on it...it will do a search through a specific layout called Interview Schedule that is on the same databse...looking for whatever college she selected from the pull down menu to find available interview times for that college. I am assuming that I should do this through a script...but I can not figure out how to make it pull from the Interview Schedule list only the selected college that she's chosen. Anyone…

Hello, How can I run a script every time a record is accessed? Thanks. EC

OK, I have a button that is calling a script that exports records. How do I tell FileMaker waht fields to Export. It is exporting all now. I just one a few. Paul

I have a payroll database which divides dates up into different pay periods. Each of the first 14 days are marked as pay period #1, the next 14 are pay period #2. For each record I want a field which tells me the last date in the pay period. Example: 1/1/03 thru 1/14/03 are listed as pay period #3. When I look at the record for 1/8/03, I want to see that it is part of a pay period which ends on 1/14/03. So, all records in this example would read 1/14/03. The items in the next pay period would obviously have a different ending date. It would be great if this were possible through a calculation, but I can't think of a way, so a script would be fine. Any sug…

I'm somewhat new at using filemaker. I've written a feature-rich patient, charting database for an medical practice that has a sizable number of scripts(about 40) and fields(340). I was amazed to learn of the file size of 9 megs without any records. This seems large to me--especially since there needs to be a charting database file for each patient(hundreds of files will be created). This is a workable starting file size, but it would be nice if the file size was smaller. Is it normal for a file with no records to be 9 megs? Could something be wrong with my database file? (It works great.) Thanks for any help. -Todd

Dear All, I have a field text and a field number, when people enter record , I don't want people enter the same text and number. If they do , show a message right away. let's say ..first record Field A = A Field Num = 9 second record ...Field A = A and Field Num = 9. How can the message show right away so that they have to change different text or number? ...IS there a way to check people? Can you guys help me out of this? Thanks a bunch.

I have a script which sends email to a found set using a loop script that inserts the text "email" into a field that is then used in the calculation -SendEmailCalc If(SendEmail = "email", email, "") Go to Record/Request/Page [First] Insert Text ["SendEmail', 'email'] Loop Go to Record/Request/Page [Exit after last, Next] Insert Text ["SendEmail', 'email'] End Loop Send Mail [''"] It works, but if the Found Count is large it can be pretty slow. Any suggestions on a better method?

Hi I need to trigger a script from a calculation field, is this possible or do I have to find other solutions to this?

I

I accidentally wrote a script that added text to the end of a field of every record that I really wanted inserted in front of the fields existing text. How do I undo this? And do it properly?

I have written an online system for doing pupil reports in a Scottish Secondary school. Each 4th year student studies 8 school subjects. I have a script which looks at each subject (Maths, English etc.) layout for one particular pupil. I can pause between each subject layout for the same set time by setting a number of seconds in pause script option. Some layouts require more reading than others, any way to pause the script until say, the mouse is clicked, which then moves onto the next subject layout and then again waits for a mouse click?

Hi, Using FM on a PC/Mac network -- all is fine except for printing... My dot matrix printer can only be run thru the pc (paralel port). Can i program a script to activate the print button on the pc? If this works, I could work on the mac then get the mac to "talk" to the pc just for the printing of some forms. I have tried to "run extrenal" script but it always ends up running in the mac, so the print job is sent to the wrong printer. Thanks --Dan

I would like to create a value list that has, for instance, only the Products sold by the Manufacturer selected in another field in the record. Perhaps there is a way to use a conditional function in a find. Can I store the value from the Manufacturer field in a variable, and then generate a value list of Products 'on the fly' (by doing a find on that variable) to make a pop-up menu for the Products field? I'd like to have this kind of functionality when entering a new record. Any suggestions?

When using the Custom Dialog boxes available in FMP 6, and using an input field (In my case a global), it seems that the only way to pass the changes that the user makes in the dialog is to use the First (default) button. However, I ALWAYS use the first button in any dialogue as the "Cancel" button because in windows they can click the "X" to dismiss it. However, I can't figure out how to make the custom dialogue box pass a value into the global when the user clicks the 2nd button. And worse yet...pressing the escape key activates the default button. That's terrible if the developer is FORCED to use the first button as the only way to allow data entry from the custom…

Is there a tried-and true way to calculate median in FileMaker, or does one have to do this in Excel? Thanks

I

Hi, To calculate the pieces in stock I have a total in stock field (=unstored calculation Purchasepiece-sum(sold)). Because of the fact that we need to search alot on this field, I made a field on the layout that can be indexed. So I made a button that updates the totals that inserts the total in stock in the indexed field I wonder what is best make a loop that goes through the whole stock and use set field or just use replace contents - relookup contents thanx Bruno

Hi I'm trying to execute a database record purge between two specific times but I think i'm getting the syntax wrong in the time calc: IF=Status( CurrentTime) >= "22,35,00" and Status( CurrentTime) <= "22,40,00" I've tried sperating the hrs/min/sec with a colon but think doesn't work either? This is going to be really simple isn't it!!

I need to insert a password once im in the file, but at the moment it shows what im typing could you please tell me how i can get it to desplay * signs when i type a letter, so instead of showing 'pass' it will show '****'

Okay, this one must be so simple they don't put it in Help and I couldn't find any posts on it using search!! This is my first attempt at this, so could ya'all walk me through it? I have a Client db related to a CPMS db. In Client, I have a form with a CPMS::CPMS# on it. Right now, when I want to create a new related CPMS record, I open the CPMS db and add a new record, type in the related ClientID, then re-open Client. Whew! I'm trying to write a script for this. I changed the CPMS::CPMSID field on my Clients form to 'do not allow entry', placed a transparent button over it and tried to write a script that would: 1) Open CPMS, 2) Perform find on Client:Client…

I 'm trying to find if same records exists in 2 files. I use a calc field for the relationship. Firstname & ":" & Lastname &":" & Suffix But it dosn't work. I have this script : File A Show related records Execute script "check existing records" : File B Where the script def is : If status (RecordFound) >0 Show message... End if It doesn't work, even if I set the first relation as a global. I made a portal in File A to see if the relationship worked, and it does, as same records are shown in this portal if they exist, but don't appear if not What's happening doc I must say (may be this could help) that the record…

Hi, I have yet to try and write a script. Can this be done? I want to have my DB clear old data automatically? One time perday, say at 9:00am, I want the script to search all the records and check for any dates that are 1 day past the current date and when found either delete them and/or save them to a new DB. I will have a date field that has end of life of the record. So if today's date is Jan 9th, the script will look for records dated Jan 8th, and when found will either delete them and/or save them to a new DB. I use FMPro 4.0 but may be getting 5.0 soon. Thanks for your help, Wayne

I am new to FM and am running into a problem while trying to understand some older code. While trying to trace down some scripts stored in other I noticed that I can see the name of the FM file, but not the name of script to run. Perform [sub-scripts, External: MyFile.fp5 (*)] I have a script that has a number of these Perform commands in a row. How do I tell, that script the Perform command will run in the secondary FM file?

Ok.. I have say director1, director2, director3 and member1, member2 and member3 (10 separate fields for each party i.e director1address, director1postcode etc etc) I know i can get member1=director1 and so on, but is there a dynamic way of doing it so that the user defines which member=director kind of like a spike where the information is held on a clipboard until the user identifies the target i.e one time it might be.... director1=member3 {new party}=member1 director3=member2 next time it could be ... director1=member1 director2=member5 director3=member2 and so on and so on. I need a query to say a) is director1 a member? if…

hi, I'm new to filemaker5.5 . I have a filemaker database that stores employee details including their passport details. I want to create a report that will display only those employees whose passports will expire in the next 3 months. Can anyone help me with this? Thanks a lot

I have a group of 10 fields whose data will sometimes need to be be the same as another group of fields in the same layout, and sometimes not, depending on the value of another field. These are all within the same database. Is there a way I can automatically have the data copy itself from the first group of fields to the second when required? Very grateful for help! Glenn

I would like to be able to generate bar chart rectangles and be able to affect their color & dimension based upon values in two seperate fields. Field 1 would contain a list of possible work stations Field 2 would estimate how long something would be in process at each work station. For example: If a task takes place in workstation A, color of rectangle = blue. If a task takes place in workstation B, color of rectangle=red. If task takes ten minutes to complete, rectangle is 10mm in length. If task takes twenty minutes to complete, rectangle is 20 mm in length. Is there a way to make this happen in FM6?

Ok.. this is seriously psycho. First off I'm sure I posted 2 posts (incl this one) and I can't find them so I'm going to post again (sorry). I am using FM.6 and Outlook 2002. In FM6 i have a script "Send Mail" which works fine... opens up a outlook mail window addressed to the correct person etc etc.. with the following exception: If an "idiot user" clicked on the button by mistake and then closes the outlook window, it will firstoff throw you into i don't know where (Internet Explorer in my first example) and filemaker will flash on my toolbar. Upon clicking into filemaker an error message comes up "send mail has been cancelled, do you wish to continue w…

I have a script that performs a find... I see that you can expand find requests.. I know this may be simple... but, how do perform a find that looks for records that contain "data A" and/or "data B" in Field1. I have a show all records, set field to dataA and perform find.. but this obviously won't work... thanks c

I'm having a heck of a time getting an "OR" find to work in scriptmaker. Perhaps someone can give me some help. I have four (4) fields of data that I need to search for a date code. Each of the four fields is text data relating to a production date for a given sub-assembly. I want to enter the text string I'm searching for in a field, hit a button that I have on the screen, and have it search the four fields for the text data that I've entered. It is easy to do manually by entering the FIND mode, entering the text in the first data field, then using the Requests menu and Add New Request to clear the page so that I can enter the same text data in the second field to …

OK, without going into a lengthy explanation, I have a field which is formatted as a checkbox. I am going to place a button over each value list item that will enter that value into the field. That way the checkbox shows up next to that value. I am doing this to have a scriopt perform for each checkmark. I thought I was really spiffy, then I realized that I could mark a checkbox, but how do I un-mark a checkbox? I though about clear, but if there are other values, I dont want those cleared, just the one value. I hope it makes sense. If you need more info, let me know. Thanks for the help. Ken

Ok, dumb question here, I'm working on a script that will automatically see if a field exists, and if not, create one (or many). Can you create a new field and enter text into it with a script? TIA. Ken

hi, I am using Filemaker 4.0 . How can I run a script when a filemaker file is opened. I want to display something like an alert report when a file is opened (something like an alert report for expiring Passports). Thanks