Script Workspace and Script Triggers

Hi all I have an order database with a relational line items file shown in a portal. Now, I need to pull out statistics from the line items e.g.: How many of product number X (about 400 different products) was sold under a given period, specified by the user. How much is the total sales sum of product X, total VAT etc. The result should be exportable to Excel. I guess I have to search for and extract the product numbers for the given period somehow and then loop through them one at a time, but how do you do that or are there some smarter way. TIA Thomas

I'm trying to use the position function to parse URLs. I'm looking for the "." (period) delimiter and I want the position of the one that is nearest to the end of the string. WIth the rawtext = "demos.su" Position( rawtext, ".", 1, -1) returns 0 This doesn't seem right. What am I missing?

I am trying to write a script that checks if one word is nearer the start of the field than 2 other words. I have tried the following but it doesn't seem to work IF Position(Text,"XXX",1,1) < Position(Text,"YYY",1,1) or Position(Text,"XXX",1,1) < Position(Text,"ZZZ",1,1) Set Field ...... End IF It works fine if I am only comparing it to 1 word i.e. everything before the 'or' but does not want to work for multiple words Any ideas? Cheers Nick

I am trying to find a better way of protecting information in fields after it is printed. Various fields must be cast in stone after the record has been printed, I am hoping to write a script which will action the usual print stuff then prevent certain fields from been changed. I hope this makes sense

I am designing a database where any layout can be reached by choosing two pop-up numerical value lists "Stage" and "Batch". If stage is set to 1 and batch is set to 3 then you are taken to layout 13. If stage is set to 2 and batch is set to 4 then you are taken to layout 24. And so on... There is a clever Pause/resume script I am using to move between these layouts as the value is chosen in these two fields. So far so good... When the database I am designing is opened I would like the user to go to the last layout that they were working on. How do you ensure in a startup script that if there is a value in "stage" and "batch" (say 2 and 4 respective…

Question: After designing a database file with numerous layouts, I dumped the very first layout that I had created. Now I want a different layout to be the default layout. I have tried to do a script that runs when the file is opened that will force the database to my new default layout, but it seems this script is only successful about half the time. Anyone have any suggestions as to how to fix this? LR

I can't figure out how to write this script. I'm kinda' new to FM so perhaps this is a bit beyond my scope, but I really would like to use it. It's kinda' involved. In plain english, this is what it does: Part A. Is there some way to have a dialogue box appear upon activating a "new record" btn asking for a name and serial number? Part B. After entering in a name and serial number, then hitting a "create" btn (or automatically), this should happen: 1. go to another database 2. go to layout "main" of that DB 3. copy the "main" layout 4. rename the "main copy" layout to whatever name was entered in the original DB name field. 5. Return to the main …

How do you use two scripts for one button for instance I would like to go to layout 1 Record 2 when a specific button is depressed. Thanks Don

Lacking cut'n'paste, I have been trying to figure out how to use Import script to its best advantage. Any tips and tricks would be greatly appreciated. For example, I paid someone to add some error-checking code into my scripts. He emailed the modified file to me... I was making my own changes to that file as well, but not in the same scripts. Now what? 1) I can just look at his code and manually add it to mine. Since the error checking code was more than half the scripts, and there's no cut'n'paste, that seemed no good. 2) I can delete my script, import his, and rename his to what mine was named. Easy, but all the calls to that script will point to "u…

I implemented the send mail script into my database. It worked great until recently. Now it won't open Eudora and bring up the email to send. I haven't made any changes to Filemaker Pro 5 but I did update to Mac OS 6 and update Explorer. I can't imagine that made a difference but I don't know what happened. Can I fix it without buying a plug-in?

I just learned something and thought I'd share. In the past whenever I wanted to use a field as a toggle (on, off) I would write a script that would check if on/true/1 then set it set it to off/false/0 , else set it to the other on/true/1. This can all be replaced with just ONE set field and no [if's] inside. Lets say we had the field called "Toggle" and it's a number field. Since this technique only uses the 0, and 1 (0=off, 1=on), then a number field makes sense to me. If we simply make a set field command like this: Set Field ["Toggle", "Not Toggle"] This automatically flips the 0 to a 1, or a 1 to a 0. The only problem is if the fie…

Is there a way to use a field value to specify an email attachment filename? Using Acrobat 5, FM 5.5 on Win (NT4 & 2000) and Mac OS X clients. Would like to automate process to avoid confirming PDF file overwrite errors, and to create unique PDFs for future reference. Thanks, everyone! PS. This is my first post.

hi all i want to open a local html document and am using the open url step. however, i need to give parameters with the link, so the url is e.g. file://HD/folder/index.html?&123&45&678&9 where 123,45,678,9 are values processed with javascript. unfortunately, only the link without the parameters will be transmitted to the webbrowser, everything behind the "?" is lost. some ideas to get those parameters to the browser?? (without applescript because of platform independance ) thanx

Hi I had a beautiful DB with about 6000 records and someone imported about 4000 duplicate records that I need to get rid of. I need to write a script (i think) to lookup the duplicates and then delete them Can someone give me some clues? Thanks

Lets say we set up a field that will update the date/time every time a record is modified. Is there a way to have a script run every time this field changes, or as the case really is, every time the record is modified? One step further and even more specific. Is there a way to have a script trigger anytime a specific field is modified. Say we have a text field. Can we have another field that maybe contains a number based on a calc. And every time the text field changes the number in the calc field is updated. And when this number changes it triggers a script to run. Any thoughts? LR

This is kind of like the other post "by Number"... SINARIO: I have a database where I've locked up the navigation so I can create my own (security reasons). Now, I've got it down to where I have a value list that is displaying the contents of a filed that I have called "LayoutNames" (List of Layouts in the database). Instead of me building a nav bar full of grapic reps of the layous, would like for them to be able to pick one from this particular drop down list and go. PURPOSE: I have given my users rights to create layouts BUT they can only do so in another database. I've figured out how to get a list of layouts in that database, but in the scripting portio…

Ok, I have a solution that has multiple layouts in one db. It is keyed on the ARF#, category1, and category2. When you enter the ARF#, I want a script that will go to that particular layout based upon the ARF#, category1, and category2. Thanks in advance!

Is there a way to have a script that will copy the word that is in a field, go to another field, and delete that word from the text in that field? LR

Dear All, I have tried to write a script to find data from portal, but it does not recognise? soneone has an idea? Thanks

I have been using a script that: 1) changes to a different layout 2) page setup 3) print 4) returns to a default layout The question is that if at step 3 when the print dialog box comes up and the user chooses cancel, then they halt the script, they are left on the new layout from step one. What can I do if they cancel during any of the steps to then force the record back to a specific layout? LR

I am hoping someone can help me and that I can make some sense. I am trying to create a script that will do finds based on a range of numbers. Basically, if the record is part of group 13. I need it to find all records in groups 1-15. If it part of group 23, i need it to find all records in groups 16-30, and so on. I tried an If function like so- If (1 < House Number < 15) then go into find mode, paste 1...15 in house number, perform find, then I have else, If 16<House Number<30, go into find mode, etc, etc. (And I'm using greater than or equal to, not just greater than) The problem seems to be in the if functions because everything else seems to work ok. H…

Want to know if this is even possible... I have created a button with a value list pop-up. Is it possible to incorporate a script that, when a item from the value list is selected, it is added to another field. Now the other field will have items already in it, so there needs to be a way were it goes to the last line in the field, does a carrige return, and then adds the value list item. Pretty complicated, and I have not a clue. Any ideas? LR

Anybody has an idea as to how to do that when you have thousands of records showing? I have been using a global field to which I Copy All Records' IDs, but I started getting the "Sorry, this operation could not be completed because you have reached text block limits." I guess this means I've hit the 65,000 chars ceiling of the text global field. Any alternatives? Thanks people.

I think this should be a simple script and I am pretty sure that I have done it before but I can't remember how to do this. I have one central database with one field. I have this field formatted as a check box list with three fields available to check. Each field corresponds to a separate database file. In each file I have a script that simply creates a new record. What I want to happen is for the user to check the boxes that they want to create a new record in and then hit a button that is attached to a script. I want this script to check to see what is checked and then fire the external script in the corresponding database. The script that I have in the central d…

I am trying to set some text in a text field to bold by using a script. I have to concatenate many fields into a huge text field and I whish to make parts of it bold. The script goes something like that: Set BigTextField to ("Name Number" & "CR" Loop Set BigTextField to (BigTextField & "CR" & Name & " " & Number) Go to next record (exit after last) End Loop This would create a table like Name Number Mike 45 July 76 etc... I whish to make the column header in bold like so : Name Number Mike 45 July 76 etc... Any i…

Hi guys, I'm back to plague the forum with more connundorums than the prophecies of Revelation! Imagine an APPOINTMENT SYSTEM for doctors which allocated appointments for certain dates in certain treatment rooms (1-4) What I want to do is ensure that there is no double booking for either the doctor or the treatment room. At the moment, it can be done visually but you can never depend on human analysis to spot when either a room or doctor is being double booked! I want a CONFIRMATION script that flags up a message saying "It's ALL good" or "uh uhhhhhhhh no way howzay - Double booked Room" or "uh uhhhhhhh no way can the doctor do two things at once" No…

Portal containing a button. Script is: If["Last Name>0"] Go to Related Record ["Names"] Go to Layout ["Personal"] Else Go to Related Record ["Names"] Go to Layout ["Company"] End If The problem is the script is looking at the field "Last Name" in the record layout. How do I have it look at the field in the portal row where the button resides? LR

When you specify a Button to Perform Script, there is an option to choose to Pause, Resume, Exit, or Halt the Current Script. The FMP help is silent on this option... so, I am left guessing what it means. Does it mean, if a script is running, and someone pushes this button, then you first either Pause, Resume, Exit, or Halt the running script, then you Perform the Script specified by this button?? If so, what are the issues with choosing different things? For example, if I have a button that is supposed to take me to a new top-level entry point in a new file, presumably I wouldn't want to keep performing whatever script I was performing before. So, should…

I have a Sales Lead contact DB (FMP v6.0.3). I have created a field which I can set a Follow-up Date which could be two weeks or a year from the record's modification date. I am trying to find a Script that will 1) Find all of the contacts in my file where the current (Today's) date is greater than the "Follow Up Date". Basically create a list view of all of the contacts that require follow-up. I know that I will kick myself because it sounds easy. I just can't figure it out. thanks.

Is there a script that when run, no matter what layout you are on, will go back to the previous layout, no matter what the previous layout may be? LR

I have a script which is supposed to insert a picture. Go to Field [NoShowPict] - a container field Insert Picture [Reference, "DayOff.jpg] The image is in a sub-directory. It works great on my machine (mac), but it gives an error message about a filter on another machine (PC). What am I doing wrong? Thanks.

My Student database has these fields: stu_Class: holds the 4-digit year in which a student is expected to graduate: Number; indexed, strict, numeric only, maximum 4 characters Grade: calculates the equivalent grade of the student based on the year in stu_Class; Calculation, indexed Case(stu_CompYear - Status(CurrentDate) <= (0*365), "Graduate", stu_CompYear - Status(CurrentDate) <= (1*365)+1, "12", stu_CompYear - Status(CurrentDate) <= (2*365)+1, "11", stu_CompYear - Status(CurrentDate) <= (3*365)+1, "10", stu_CompYear - Status(CurrentDate) <= (4*365)+1, "9") After November 30 students need to be promoted by one grade; I need to f…

Can I use a CASE statement in a script using the SET FIELD command instead of a series of IF statements Cheers Nick

I have spent too long on this already but I just can not see the problem. I need your help. I have two databeses one a stock master and one a tags database. I need to create difrferent quantities of tags depending on my stock level and how many items I have in stock. My tags database has the information Item reeference Price (Lookup from stock master) Qty Information (lookup from stock master which can be changed) Next qty to print (Qty-1) Copy Tag? (Y/N) (boolean Calculated on creation yes if Next Qty to print is greater than 0 ) Sart Printing Loop My problem is I am trying to create a script that will duplicate the label records untill I hav…

When precisely do startup scripts run? They run if you explicitly open the file from the File menu. But what if the file is opened by another file? What if a file does "Open Hidden" on another file? What if a file just calls a script in another file? What if a file just uses a relatonship in another file? What if a file just looks at the definitions in another file? In each of those cases, does the startup script run? I thought a file with (parens) in the Window menu was opened, but hidden. But I am noticing that many times such files have NOT had startup script run. For example, *all* my files have Doc prefs set to run the script "Startup" at st…

Dear All, I have two layout ...I want to know if I could change the label of one layout and it changes automatically change the label of other layout? Since I don't want to retype in labels in two layouts? Thanks

Okay, based on the STARTUP thread, I have a Begin file that takes care of opening everything properly. If you try to open any other file, you just get a message telling you to use Begin. Works Great! (thanks again) Given that, the only way to get a file opened improperly is to close it... then it may get auto-opened without the startup script. Soooo, the obvious answer is to add SHUTDOWN scripts to ensure if you close one file, you close them all. Sounds easy. All my files have a script Shutdown that simply goes into Browse Mode and then calls Close("Begin"). And then Begin has a Shutdown that calls Close on every file that it Opens in its Startup script (…

Is it possible to simulate clicking on the layout or layout background (i.e. clicking outside the field into which data was just entered) in FMP 6.0?

I want to open JPG files from my FMP database. I have posted under other titles but this is another idea. I saw someone suggesting this: ("prebledesktopkathyswork"imagefilename".jpg") for the Open URL step. I am on a Mac. When I perform this script from a button, a little window comes up wanting me to put in a URL. I HAVE a filename in the ImageFileName field. What am i doing wrong? Kathy

Anybody has an idea on how I can make certain fields appear in place of others (ie on the same screen real estate) depending on the value in a certain key field? I have worked out some relationship which can make portals appear and disappear together with the fields they contain, but if I place one on top of the other, even if it's the one at the back of the screen to appear and the one at the front to disappear, the one at the back won't show. I have to place them side by side, which is a bit awkward, since the inactive portal looks like a waste of space. Thanks in advance!

Rather than using the Sort dialog to specify the sort criteria, is there anyway to build up the sort criteria programmatically? I'd like to implement a button on each column header that *adds* that column to the top of the existing sort order. In that way, you can build up a three-field sort by simply clicking on the three column headers in the opposite order that you want them sorted. Any way to do that short of having a separate script for each combination of columns?

I am using FileMaker 5.5 on a Mac If the field "Total Material" is empty or less than 1 (this is a calculation number field) I should to be able to enter a number in field "Other Total" (this is a number field) If the field "Total Material" is NOT empty or is greater than 1 (this is a calculation number field) I should NOT be able to enter a number in field "Other Total" (this is a number field)

Hi every body... I'll try to make a script to move data from global repetitive fields to a text field.. For example: I have 2 global fields (gdiente,gdano) with 10 repetitions and another field calc to make the field name (field_name - the same repetitions like another-) I created a script to found the field name: Loop Set field ["gtemp","Field_name"] here take the first repetition Set Field ["gtemp2","Status(CurrentFieldName)"] End Loop If ["gtemp = gtemp2" Go to Next Field End Loop But now I want paste in the field found from the another global field (gdano) this depends the repetition, and check all my repetitions (10) I hope you can…

Hey Y'll I want to send some information to Filmaker tables from via web interface. I got Linux web server and I got filemaker server 5( Windows NT seerver 4) is there any way I can connect these two machine and pass insert data in filemaker tables. I love to use php. So, any body know how to connect these machine useing PHP scripts. Please let know. I'll really apprciate it. I'm in uurgent need. Thanks. Sunder

I have a script that's scrolling through and running a test on 73 found records of a 78 records set. IT runs in a loop, and it has a step saying Go to Record (Next, Exit After Last), but it just runs, in an infiinite loop, on the last record. Ideas why?

Ver: FMP 5.5 I have a menu db that launches sets of databases by opening them when needed. The down side is I need a Script for Each Database I wish to open. The file structure of my Main menu is one record per database, FMP doesn't allow you to reference an OPEN Script step to a global, you have to "HARD CODE" the open step to the script. I was searching FMI web site for information to be able to dynamically script an OPEN with out hard coding. Thus the value of the fields in a record will open a hosted file. Here is the answer: code: FMP 5.5 installer registers FMP5 as an Internet protocol. Users can remotely open a shared database using a URL. Th…

I have a user that accidently duplicates the record she is on all the time. She does this by hitting the apple + D button. She needs to be able to edit the records and it would be nice for her to able to create new records but definetly not duplicate records. All users are logged in using the default password. I am using FM Server 5, from what I understand you can have only one default password. How do you turn that feature off? It would also be fine if all users couldn't duplicate records, I just want a way to turn it off.

Hi there. We need a good critical path software made in FileMaker. We have developed a Project, Order and Activity manager system in FileMaker, and will need to integrate the two systems. We want the new system to enable a project team to answer such questions as:

I have a program that has package numbers in it, i want the customer number to go in serial number based on the package. In other words when i hit New Record, I want the "Customer Id field" to wait until a package number is selected in the "Package Field", when a package is selected, ex. Package "1A" I want the Customer ID Field to look up all the records that are 1A and look at the last records Customer ID number and add 1 to that new record. So in other words, if I have 360 records on Package 1A and 210 records on package 1B, when i hit new record and then hit package 1A , i want the Customer ID field to show 361, if i hit package 1B i want the customer ID to show…

How do you loop through all records in a file without munging the found set? The user is in layout A or B or C. He clicks to go to layout D. Found set and the current selected record should remain the same. But before bringing up D, I want my script to loop through all records in the file making some changes. Writing the loop is not a problem. Writing it such that it doesn't eliminate the users found set and leave him in the last record in the file is another thing. Hints?

when using the sendmail script in os9 and using outlook the new message ends up in your draft box, why won't it leave the new message open?

Hi there... When you are in "table" view in your database, you can navigate through your records with the PageDown and PageUp keys as well as with the Home and End ones. Is there a way to establish the "arrow" keys to work as the "goto next record" and "goto previous record"?? Is there a status function that returns a number/value of each one of the keyboard keys?? Yorch Using FMP 5.5

To insert a swf file in HTML is very simple but in FileMaker ?

My office shares files through Filemaker Server and it seem to be working great so far. However some of our users are MAC and some are PC. In my database I have a script that will send an e-mail to the record that the user is currently in and the PC users seem to not have any problem use this script. It pulls up the defult e-mail program and sends it fine. The Mac users (Using Microsoft entrouge) nothing happens. Is their a way I can get this to work on both platforms? I think someone once told me that I needed a Filemaker extenion to make it work? Any Ideas? RET

I have developed a system comprising 6 files in FMP5.5v2. The user starts off by a shortcut to the main file, which opens up all the others, initializes variables etc. When shutting down, I include a ShutDown Script with the main file, which closes the other 5 files (by calling 5 times the external ShutDown Script in each of them) before closing itself. In the 5 files, the ShutDown script is a simple Close[mainfile] command. Problem is, the system doesn't work. It behaves erratically, leaving some of the files open when you would expect to only be left with the application window but no file open. Some of the 6 files are related - would that be a problem? Th…

Hi, I am run FMP 5.5 on Windows 2000. I have a button called CLOSE, the script behind this button is to check some validation/mandatory fields, if it found some invalid data, it will prompt the user to correct it, otherwise it will CLOSE the application. But when the user click File>Exit, it will quit the FMP without checking validation/mandatory fields. I asked FMP to execute the CLOSE script if the document is closed by checking off the Perform Script of "When Closing Menu" box from Edit>Preferences>Document. It runs the CLOSE script, but after that it quit FMP without checking the data. Here is some script steps in my CLOSE script ShowMessage: "I…

I have this list of names that I want to run a calculation on. Basically I want to start with the first name, preform a script, which will return a result, and insert the result in the name's record. I have thought of some ideas but there's got to be an easier way. Any suggestions?

Hello ! I have links to pictures from a main page. I would like to open theses picture beside my main page. Until now I wasn't able to find a way to do this. I stored my pictures on layouts and when I click on the button (go to layout xx) the layout replaces the main page. I would like to open the picture layout in an other window. Does someone know how to open a layout in a different page ? Maybe with a script ? Thanks for helping. Polopo

I'm using Filemaker 5.5 on a Mac OSX 10.1.5. I have a database for collecting payments. I want to be notified when payments are past due. While I can go in and perform a find to locate this information, I'm trying to make my life easier by automating the process . I'm actually trying to do 2 things here. 1. have an alert in filemaker come up everytime the date in the "due date" field matches the current date without anything in the "paid" field. 2. Send an e-mail to the customer alerting him of the late payment (ideally CC:ing the info to me) Not sure if these are easy fixes or age-old problems, but would appreciate any help.

I have a rather large relational database and have to create a rather complex report to show information from records that are related by records that are related by other records (goes 3 levels deep). In order to do this, I have a few scripts checking certain criterion and copying appropriate fields and pasting them in a "report" field. this works fine - if nobody else is in the record that I need to copy data from, but if someone is, the pieces of information I need do not show up in the report. Is there a better way of doing this? I thought of creating calculated fields, but that would not go 3 levels deep appropriately.

Continuing in my quest to avoid cut'n'paste scripts... Is there any way to get the text label of a button in the script that it invokes? That way you could write one script that behaves appropriately for a large number of buttons, where all you need to do is give it the right label. For example, I could have a script like this: If [Mod(Status(CurrentModifierKeys), 2)] SetField(G::HelpText, GetField("HELP " & ?ButtonText?)) Else # do something else with the field with that name like set a default End If Without that, I end up writing a cut'n'paste script for each and every button. Thanks.

I have a client information database that I set up the ability to send emails from through outlook 2000 and everything was happy and working. I set that feature aside for a while to work on some other parts of the project and came back to enhance it. I now am using Outlook XP. When the script executes, everything works great in Filemaker and then I get a message from Outlook saying that there is a program trying to send mail through it and asking if that is okay. If I say yes, the script ends and control flips back over to Filemaker, but the messages have not been sent. Microsoft's help says that there is a edit message flag that has been set to NO and that …

I imported a script for launching an external file and I keep getting a "file not found" error when I try to use it. I guess I just don't know what I am doing. THis is how the script looks: If ["ImageFileName = """] Show Message ["Please select a file to launch first."] Exit Script End if Set Field ["ImageFileName", "External("TrFile-Launch",ImageFileName)"] What I want to do is this: I have a different JPG file associated with every record that I want the user to be able to open. For now I would like them to open it in Explorer. I have a field called ImageFileName that I put the name of the file. The file lives in the same director as the F…

Do sample scripts work for lower versions of filemaker. Currently I am using 4.0. This is the only version available to my unit at this time. Will scripts for filemaker 5 work on 4 or will I have to do major modification. Does anyone know of some sample scripts that may work? Thanks

If I make a field a button, then it'll do the button command rather than enter the field like normal. Is there any way to make it do *both* enter the field *and* perform the script? If not, can you write a generic (not field-specific) script that will behave precisely equivalent when performed by the field button, as if the field was not a button and you clicked on it? Why do I ask? Because, I want to write such a script but then add a check for the Shift key and if so do one added thing. But otherwise, I want it to behave just like you had clicked on a normal non-button field. More specifically, I want to do: # Enter field like normal (this part I…

Can I create a scrpit that will automatically open a certin user to a certin layout? For example: If I am "bob" and I am a accounting guy, when I logon to my database it will bring my to the accounting layout. If so how would this script read? Thanks, RET

Is there a SetField version of GetField? Just as you can get the value of the field with the specified name, I'd like to set the field with the specified name. For example, for setting Boolean fields: If [ GetField(prefix & name) ] SetField(prefix & name, "N") Else SetField(prefix & name, "Y") End If The GetField part works fine; but SetField requires you to specify a field, not a field name. Any way?

We have UPPER( ), lower( ), and Title( ) case commands, but no Sentence case. I want the first letter of each sentence in a field to be capitalized. I.e., there will be a period (.) and one or more spaces, or a paragraph before each sentence, or even other things I'm forgetting. Does anyone have a handy script or calc to do this? I'm feeling lazy. (This is my first post that wasn't responding to someone [color:"purple"] else's request for help!)

With function GetField, you can compute the fieldname, and then GetField will get the value of the field with that name. Very useful. Can you do the same with Go to Field? The normal interface seems to demand you directly specify a field. Is there any other way to do "Go to the Field whose name is in the global gFieldName"?? (Again, I am trying to avoid cut'n'paste of a long script; but rather simply set gFieldName and then call the one long script that performs the feat on the field named in gFieldName. Huge maintainability win; esp since FMP doesn't even support cut'n'paste!)

How do I set it so I can have a button on the screen that, when clicked, opens an associated JPG in a folder on my harddrive? Just Open File script makes me have to select a file, but I put the file name into a field in the data. I am new at this.

I am trying to automate sending an attached data sheet that is a pdf within a container field. If I select the container field as the message, it send it blank. The users don't know how to find the data sheets to make the attachment manually which is why I am placing them in FM. Any ideas. Thanks.

Hi there, I need to be able to open and print pdf files which were linked to the records previously. I use Troi file plugin to allow users to select the file from their hard drive and save it to a mapped shared network drive (so that every body can view/print them) and stamp the file name in the that record for latter viewing/printing. I have accomplished both of this in windows using the Send Message script but I not sure how to do it in the mac. I tried to use send apple script but no luck. It opens up the Adobe acrobat application but it does not open the pdf (using the field values) Also I have no idea how to print them in the mac. …

one layout, two portals. above each portal a delete item button. How can I script each botton to check that the slected row is in the correct portal?

I have used FileMaker Pro for a few months, but still have lots of questions. I've created a file, A, which's used as a search window. I can trigger a script in file A, then go into a bunch other files to do the search. After the search, 2 scripts in file B, are being triggered. First script deletes all the records in file B. Second script imports the search results into file B. The import order is predefined manually. And the files I've mentioned above are in FileMaker Pro 6 format. It works fine until I change the search criteria or make a print in file A. Then I will receive a message from FileMaker. Basically, it tells me that file B is damaged. And it gives…

From my [Contacts] file, I want to be able to perform the following search. 1. Find Active customers (from the "ContactType" field) located in the [Contacts] file. 2. Omit customers that are on Maintiance (from the "Maintiance field") located in the [Maintiance] file. This field is shown on the [Contacts] file. 3. Find all customers we have not done business with in the last 45 days. This information comes from the

I have a "PrintTitle" field that is normally hidden on-screen, but appears in the header when printed. I have a button "Edit Title" that does Go to Field "PrintTitle", which raises the field and puts you in it so you can edit that title. It works perfectly when you View as Form. It doesn't work at all when you View as List. Is there something odd about "Go to Field" when in List View rather than Form View? How do I make this work in List View? Thanks.

Hi gang, I've got a field called "stuff" which contains text that has been formatted (underlined, bold etc.). What I want is to set the field contents of another field, with formatting intact. Any idea on how to do this? I can't seem to find a way to do it, Cheers Steve Griff

I am doing 3 reports , they start with a diferent field at the beginig ,so if a start the report with date first , I assign to sort the report by date when i am in the wizard, and do the same to the other reports , I did a simple script to sort the list but it sorts using always the firts sort that I did in the firts report. Why this occurs ? If in the wizard I Did a diferent Sort criteria to every columar list . Thanks..

I have 12 different time fields that I need to display in chronological order. That order may change record to record. Is there a script I can create that will put the fileds in order and display them?

hi everybody,... i need help to make the following script: 1. find all the duplicate records - this i know how... 2. delete all the duplicates but keep the one with the most recent date... 3. if all the duplicates have the same date keep only one... any help will be appreciated.... thanks...

Hi Everyone! I need help with a script that's just not performing. Basically, I have 13 fields that go as follows: Last Name or Business LNB2 LNB3 First Name I. FNI2 FNI3 Accts A2 - A7 Currently, if I wanted to find a particular account number I would have to do 7 finds, a find for ea. Acct number field. The same goes for a last name search, I would have to input the last name in the Last Name or Business, LBN2 & LBN3 fields to ensure that I have checked all fields. What I wanted to do was create a "quick search", where all you would do is type in the information in one field (i.e. Smith) then click on…

Hi - Not sure if I can do this. But - when the user goes to a new record either manually or by a find - I need a script to run. Guess - I could do this by creating buttons to move from record to record and to my finds. But - is there a way to do this with the script be triggered just by changing records? Also - if they do a find and find more then one record - it would need to run the script for all the records found. (LOOP) UGH!!! Thanks for your advice -

How can i make a Sort:ascending and sort:descendig script ? The command " sort(Restore, no dialog)" sort in one way ( I think ) , how can i make it to order ascending or descending... thanks... Thanks LiveOak , now i get the idea....

I have a Filemaker database which runs on several terminals, some of which are dedicated to database operations and others that are used personally as well. I have a Send Mail script in the database which works well, except that I want the emails to always show up from the same (general) email address. That way all replies will come to the same email address, and all messages sent will be from the same address/name. The problem is that when the script runs on a computer used for personal emailing, the Send Mail (and OpenURL, as far as I can tell) will send from the default email account on the computer, which is usually the personal account. In addition, if the us…

Hello All, I have a find script where I am using global fields to simulate a find in browse mode(do not want users in find mode). I am using the insert calculated result function to find a range of dates. Which is only one set of fields to be used as find criteria. The problem comes when I try to initialize them. I have tried "" or TextToDate("") but these generate invalid find errors Any help will be greatly appreciated. Thanks for you help. Paul S. Cuscione [email protected]

Hi all, I am having the following problem. Have a number of files. Lets say I open file A. From there i go to file B. No there i have a portal with records from file C. I have button in the portal that directs you to the child (= file C). (the script is something like : Go to related record perfom external script (this external script , enters browse mode and opens the right layout) toggle window (hide) No I want to hide file B, when leaving file B. So far so good. When I push the button in the portal row, file B, gets hidden and the file C appears BUT for one breave moment it shows file A ! Hope you can still follow, and hope s…

I have 2 number fields, Main_Number and Change_Number. Main_Number is validated by a calculation to allow only certain values and does not allow overrides. I'm developing a script which replaces the data in Main_Number with a user-entered number from Change_Number. So, simply enough.... ....(other script steps) SetField[Main_Number,Change_Number] Clear[Change_Number] Go to Field [ ] Halt Script If the validation fails, the Revert Field/OK box pops up. If I select Revert Field, the field doesn't revert and instead allows the 'incorrect' value. There is no problem if I use Insert Calculated Result or Copy/Paste instead of the SetField script step, but shou…

I am new... and I want to make a "ascendig descendig order" script in a list, ex : order ascending or descendig a list of items but I dont know how can i doit , can you people gime some tips or an advice how can i do it, thaks . Dennis

I have a task list database...multi user i have created a script that when a user logs in it searches for open messages for that particular person... If(Status(CurrentGroups)="User1" Enter Find Mode Set Field[assigned1,"User1_initials" Set Field[status,"Open"] Perform Find End If Now, my employer wants to have two assigned fields so that we can assign the same task to two people at once...the problem is if I add the following under assigned1 set field[asssigned2,"User1_initials"] it searches to see if each record has both value true when i need it to search if each record has either/or true and display those results any sug…

Hi. First I must specify that I am mostly script illiterate. I have recently created a database to house client info, etc. I would like to know if it is possible to create an email list from the database. I would like to pull up a list of people (i.e. board members) and send an email to all of them without having to type in all of their addresses each time and/or keep updating email address books in another program. I did figure out how to send an email by clicking a "button" but it would send the email immediately and it was blank with no subject heading. I need to know how to set it up with the option to edit the email each time. Is this possible? I appreciate a…

I created a database that has positions and companies on the same page. There are multiple positions for each company, thus when I run a report to access company information, it pulls up the same info multiple times. For example, the City of Brea has 10 positions. The company information is the same for all 10. Lets say I need to make an e-mail address listing. So when I run a report (layout), it lists the e-mail 10 times for Brea when I only need it once. I understand that I could have two seperate databases, one for the companies and one for the positions, but that is what I initially did and that created many other problems. Does anyone know how to write in the script …

When a script step callls an external subscript I don't understand 'which' specific script in the external file is called. I know this is a general question and am assuming it can be answered without an example. If examples are needed I can pull those together and re-post. TIA Steve

This one's got me. I've written a script that does not work quite right. There are two search criteria's, the first works and second doesn't (set fields). The second set field is going into a field that is date formated and used as a record modification date field. It is inserting from a global (gSymbol1) ">=" and the current date - 2 This field, if searched manualy works OK, but the script fails here. I've tried using a calclation here and insert text or insertcalculation without luck. Any suggestions? Thx ------------------------------------------------------------------------------ If [ Status(CurrentMessageChoice) =1 ] Enter Find Mode Set Field [ …

I'm not sure if the Scriptmaker area is right for this, but I'm scripting my way into to it, so why not? I have a customer db related to a backorder db. The latter contains many line items. I can isolate "shippable" backorders (stuff that's come in) and generate a list view report by customer of all their shippable backorders. I am using a subsummary part that contains a calculated value summation for these backorders. The problem is, I would like to omit from this report all customers (and their line items) for which this calculated value is less than an arbitrary amount, say $50. In general, two-thirds of customers & their line items will be omitted if I c…

I have a client that has an office 400 miles from mine . My office developed a system for him and we have a support contract with this client. Sometimes he asks for some changes and I am looking for an update manager so that someone from my office doesn't need to go to his office each time we have to include the changes into his system. Does anyone know if a "manager update" exists ? Does anyone have an idea about how to send these changes in order to make these changes as easy as possible to be implemented not needing a programer to do the update work ? Thanks, Luiza

Looking for some wisdom from you experienced guys... Where do you OFTEN find that you need to add 'set error capture [on]' and handle the errors yourself? I know *how* to do this... but its not clear to inexperienced me where there will be errors that I don't want to just let through as-is. Or worse... places where there are errors that cause misbehaving *without* any error messages (e.g., Modify Last Find just fails to work when it has an error... no error message, just nothing... ick!). From searching the forum, it appears its often used with: Modify Last Find Perform Find (when doing canned finds, rather than user-specified ones) Opening Files …

Any clever way to simplify this: I want SHIFT-click on any field *label* to display help info on that field. For every field I have a "HELP fieldname" field that is a constant calc returning the help text. Now, I can write a HELP script for each field... but I'd rather cover most of the fields with a generic HELP FIELD script... SetField [ G::HelpText, GetField("HELP " & fieldname) ] ... where 'fieldname' is the code I am missing... its the text from the text object that I just clicked on. Any way to do that? (You guys have amazed me before! ) Thanks! P.S. This is where parameters to scripts would be sooo nice... to where the button cou…

Each customer in my database has a unique 4-digit customer number. In an invoice number, the two numbers preceding this customer number change based upon when the order was placed and how many orders have been placed in a given year (for example, Invoice #224567 would indicate the second order of 2002 for customer 4567). I want to be able to change just the second digit to reflect a third order for the year 2002 (in the example, the new invoice # would be 234567). Using "Replace" in a script doesn't seem to be the right way to go. Any suggestions?

I'm trying to put a halt on a script if the user is not "Administrator", "User 1", or "User 2". My script looks more or less like this: If ["Users::User Name != "Administrator" xor "User 1" xor "User 2""] Beep Show Message ["You don't have access priveliges to perform this action"] Halt Script End If <the rest of the script> This configuration works, but only if the user name is "Administrator". What am I doing wrong?

Hi everyone! I've just been bitten by the FMP bug and love this stuff! But I need a bit of help... I'm trying to create a db for my band. I have a layout for entering musician's info (instrument, address, phone, etc.) I use a pop-up menu to choose the instrument they play. I would like to find a way to have this person's name added (automatically) to a pop-up list of other similar type instrumentalists. Example: Joe is a pianist. While entering his contact info, I use a value list with different instruments (piano, drums, guitar, bass, etc.) and choose piano. In another layout, I have pulldown menus that help me input the musician's names quickly (along …