Script Workspace and Script Triggers

Alright, I have to word this correctly.... I have a list of equipment with days it is supposed to run and hours for each job that will run that day... again only as a group of unsorted records. Is there a good way to sort the list so that each day is separated and that at the end of the list for each day I can insert a summary field that would show the total hours for the jobs for each day? thanks again.. sorry for my unclear posts!!

Is it possible to replace the dialog boxes that pop-up when deleting a record, or searching for records that aren't there, etc...? I would especially like to replace the Delete record dialog. I know i can turn it off using the scripts, but i just want to replace it, and customize it to further dummy-proof my database. There is a dialog box option in scriptmaker, but i can't quite get it figured out....any advice?

The answer is probably painfully obvious, but if's Friday and my brain is locked. When forming the SQL query in a Execute SQL script step, how do I use a combination of single quotes and an apostrophe? Here's the Query in question : UPDATE tDesigns SET fDescription = 'Hank's Truck' WHERE fDesignId = '495' Here's the script step: "UPDATE tDesigns SET fDescription = '" & Design Description & "' WHERE fDesignId = '" & DesignID & "'" It's generating an error (understandably) when it hit's the apostrophe in Hank's. Any help is much appreciated.

I have a database set up and have included a button to send me an email. Sort of a trouble ticketing DB. The database is hosted, that is it's set up for multi-user but does not run FileMaker Server. Since not all of the users will be using Eudora, is there a way to set it up so that when a user sends an email, the email is generated from the hosted location and not the client location. Thanks!

Here's my situation: I have 3 tables: Locations, People & History. Each record in People will be unique, meaning they are different people. History records all the locations a certain person visits. Locations store the possible locations a person can visit. A person can visit a location many times, creating many related history records. I need a calculation in my Location table that tells me how many people have visited this location...not how many times it has been visited. In other words, one location may have been visited by 3 out of 4 of my people, but each one of those 3 visited 2 times. I need my calculation to tell me "3" people have vis…

In my first database, I probably excessively used copy and paste records (i.e. Relational ID) or replace. I noticed the default of the replace function (I suddenly discovered one time that I had a unique Invoice of 480.000,00 euro as I accidentaly replaced all the Invoice N

Dear All, I have a script like this Freeze window Perform script :external ... Refresh Window Show message. The problem is ...I don't want to see how it perform external script then bring me to that file and show message ... I use Freeze window before external script and Refresh window after external script ...it works but it does not show up the Message window Any body has any idea? Thanks

Is there a way to have a script populate a field with the date or time from the server clock rather than the client computer clock? If not, does anyone know of extensions that do this?

I have created an app that schedules four pieces of equipment. These pieces of equipment are in a seaparte DB with hourly rates etc. In my scheduling app I have a popup menu which lists these pieces. The user will select the piece of equipment and a date. All is well until they click the schedule button. This script takes you to an "equipment" layout.. This script sets the equipment popmenu result to a global field. The script starts at the first record and compares global to equipment pieces (i.e. "set field global to equipment... if global != "piece1" omit record... go to record request next.. and it performs the same tasks. The problem is that it does not omit the rec…

Is there a way to write a script that will allow me to create a button on a F.M.Pro page and it opens a stand alone html file that is not on the web. i.e. I have a help file I have created that is a html file and I want my F.M.Pro (Ver 6) to be able to link to it and open it so people can access the help information. This would make my life a whole lot easier. Has anyone any ideas?:? Cheers, Glennmc

I have a Clients db. It is related to a Contracts db. I want a button to execute a script which opens the other db and goes to the related record. But, when I try to write a script and OPEN another db, it doesn't even offer a place to list the .fp5 related db name? I've searched through all the script options ... oh, come on ... this has GOT to be easy! Of course, FM help says "select File:Open" Well, for goodness sakes, THAT tells me a lot!

Hi, I've got an invoice number in a database and some selected line items in another database. Does somebody know how to set the invoice number on those selected lineitems trough a relationship? I've tried the copy/paste solution with a script. But since that is a bad story for filemaker databases...i don't like to use it anymore! Any help is appriciated... greetz...jeff

Help needed... 2 databases.... 1 containing various contact through our company history with a portal linking to another database of telephone calls and activities with the specific client. I have created buttons that I would like to enable to search the contact database by the Account Manager (only 4 variables). Currently this Account Manager field is a drop down box, listing the four available options. I seem to be unable to assign a button to a single account manager, so if the account manager clicks on his or her name, the relevant accounts will be searched for and displayed. I have been banging my head against a wall with this for about a week now…

If I have a collection of records which contain pieces of equipment and days they are supposed to run, what is the easiest way to create a calendar...(i.e create a layout which list the next two weeks over several pages) that will sort it and place the record in the appropriate day of the calendar along with a totals fiield that may show total hours for that day.... I have created an app which allows a user to select a piece of equipment through a popup menu and select a date whcih to book the equipment - also through a popup menu.... help?

As usual, I'm hoping this vast knowledge base can help me out. Here's my deal: We have reports cards in FM. Many teachers type their comments at home and then cut/paste into the FM report card. Trouble is, it retains the formatting (font, size, etc) of the word processor they created it in. We need the report card to be in a specific size and font, though. I've tried locking the field, merging the field into a text box formatted with our text formatting, but I can' seem to strip away the old text styles. Is the only option to go in and manaully select all, then change the text style? Please say it ain't so....

Newer than I care to consider, I have been struggling with the FM users guide and the tech support team for what seems like an eternity now. I have set up a script that lets me email from the databse which works fine from the host PC but doesn't seem to comply when you try to do it from the Web on other PC's. I only received the empty database yesterday and so know less than nothing, what do I have to do to make the email work? Any help will be much appreciated as I have convinced my boss that I can do this as I fancied a challenge, I am starting to think that sky diving would have been more appropriate.

How do I setup a Popup menu that will have 3 weeks of selectable dates. I understand how to list them individually, I just can't get them to list in a popup menu together..

I can't get a script to work that will allow a user to select an item from a popup menu and have all other records omit whose popup value is not this value... Help!!

I have a file where i have a field named "Actors total" The idea is that the user enters a number here that signifies how many actors are in a screenplay and then hits a button that is labeled "update." The script will then insert as many fields in the record as there are actors. These fields will all have pop-up menus from a value list. How do I do this? I need to be able to do this individually for each record since the number of actors will vary and I do not want extra fields floating around.

How can I get an object to move the front via a script? When I click on a button I want an object to move to the front and then go back after released. I appreciate any input you can give. Thanks, John

I want to write data from a record out to another file before the record is updated so that I can track the update history of the record. I can't seem to find a way to do that in FileMaker. In SQL databases like SQL Server, it's easy: just an INSERT TABLE statement. In FileMaker, it looks like the best I can hope for is to write out the single record to an exported file, then at some point, import the record into the "history" file. Maybe there's a more straightforward way to do this?

Hi everyone! Another newbie question. I have a start-up script that I've borrowed (stolen) from CobaltSky. It has GoTo Layout, Toggle, Refresh Window etc. My question is: I don't see where to attach this script. Or, because it's entitled Start-Up does FM know just to run it upon opening the db? Can anyone give me some input? Thanks much

I like to use a script that will put the following day in a 'date' field, and a script that will put the former day in the same 'date' field. How do I do this?

Can you run a script where a particular task is performed in layout mode then goes back to browse mode. I want to paste merged text << >> into a layout mode because won't show up within a field. Thanks for any assistance

I am making a database in filemaker and i've got 3 files for three different tables which will be related. In one of the files there will be a welcome page layout and in there i want to put a search button. Now what i want this button to do is that when a user clicks it I want the message to come up asking him in which of three tables does he want to perform a search in. I don't know how to do it, so can someone here please help me with this problem

I am writing a calculation intensive relational db. Changing an entry results in a recalculation time of 3-10 seconds depending on machine vintage. Is there a way I can freeze updating of the window while I enter several data points and then recalculate once instead of several times? The data won't/can't be entered in a set order. I might update data fields 1,2 and 5 one time and 2,3, 5 and 8 the next, etc.

I'm an infrequent FileMaker who can't figure out how to do something I hope is easy - I want to select only a certain number of records (say 7) after completing a specific search, so I can export an XML file with just the data from those (7) records. I can't figure out how to do it. I can do all of this, complete the find, compose the XML, etc - I just don't know how to sub-select down to (7) records. I hope this is another step in the script. A tip or the secret or help would be appreciated. - DPAM

I have made a "solution" for a client of our company using FM Developer 6. He made the comment that when you cancel a script (such as printing, by canceling from the print dialog box) that he doesn't want to have to hit cancel again (the script will ask to cancel or continue). Is there a way to have the script cancel box not show up? The solution is bound on a PC (although I would like to know how to do it for PC and Mac). Thanks

I've noticed that a lot of users in this forum make frequent use of the "Case" where I probably would have used "If" Could someone exlain the difference, and why one might be prefered over the other? Thanks! -- Jason Wood HeyWoody.com

I'm trying to use a button on a layout in Find Mode to initiate the find. It's supposed to work just like the Find button in the status area. But I want the status area to be hidden so that people are encouraged to follow the logic flow dictated by the script that's running. The problem is that when the script executes Perform Find, it always returns an error window that says "There are no valid criteria in this request". I was expecting that the search criteria entered in the find screen would be picked up by the Perform Find. But it looks as if I'm missing a step for moving data into someplace that the Perform Find can operate on. The Find button in the status area…

I have a reservation system that has reservations for particular days out of the year. But i would like to have a print out of who is staying in what month. Each reservation has a particular start day and finish day, and i would like to have a combo box for the months of the year that once selected you will be able to click a button that runs a script that collects all the reservations for that particular month and put it into a table format for printing.

I have created an opener file that is opening my project file. The project db has a startup script that opens 3 other files. After the opener files closes, it is brings up the last file that was opened instead of switching back to the projects db. Is there an easy way to switch this? Thanks, John

I have a found set of records. I need to create new records based upon this set. These records are Service Billing LineItems. Each record needs to have another record created as an adjustment lineitem. For example: Service Record: Dept 4000 Debit GL 1202 Debit Amount $85.00 Credit GL 5003 Credit Amount $85.00 New adjustment record: Dept 4000 Debit GL 9300 Debit Amount (ServiceRecord DebitAmount * .094118 Credit GL 1202 Credit Amount (same as debit amount) Is there a way to loop through records and create a new record for each, inserting the proper Dept, Debit & Credit GL & Amounts? Oh, I sure hope so! I guess anothe…

Hi There, So here is the problem and this is a strange one! In the database X I have a ordernumber in a numberfield. This field is combined with a text field in a calculation: (NumToText(ordernumber) & " " & MyTextField) So when the ordernumber is 10 the textfield returns "10 text"! I have a relationship ® between database X and Y. The relationship is like this: textfield(database X) :: textfield(database Y) with the option for creation of related records on, not sorted. And here is the tricky part... I have a script that makes a record trough this relation. It has the scriptstep SetField and sets the textfield in database …

I am trying to create a script that opens a related file and pulls up a specified layout within that file. Is this possible? I can't seem to see a way of doing it. Am I overlooking something? thanks, Slaughter [email protected]

Go to Field ["Find"] Select All Loop Pause/Resume Script ["0:00:01"] Exit Loop If ["Status(CurrentFileName <> "Find""] End Loop If ["Status(CurrentError)=400"] Show Message ["No results match your request"] Go to Layout [Original layout] Else Perform Script [sub-scriopts, "Find It"] End If On the Mac what this does is if I click a button, a pop-up list comes up listing the alphabet a-z. The pop-up list stays up until 1) the user selects a letter, in which a sub-script is run to perform a matching find, or 2) if the user clicks outside the pop-up then the pop-up goes away and the user is returned to the original layout. This does not s…

This is related to another post. I think I already know the answer is NO to this question...but I just wanted to check. Go to Field Loop Pause/resume 0:00:01 Exit Loop If not IsEmpty(fieldname) End Loop More script items from here The question is that on a PC if the go to field in the above script is a pop-up menu then it stays up until the Exit Loop If statement is met. But if the go to field is a pop-up list it does not stay open. In this particular case a pop-up menu does not work very well. Is there a way to have a script on a PC go to a field that is a pop-up list, have the list come up, then have the script pause with the pop-up list still …

Hello all, I have, lets say for simplicity's sake, two databases. One database (X) stores a master list of 100 conferences. I have twenty clients who are interested in going to conferences. For each conference you can attribute two clients or more, for example. Therefore I used another database (Y) to allocate clients to specific conferences. So I pull records from the master and adapt them as I need. But all the time, the master database of conferences in X remains untouched. When I find a conference in X that suits a specific client, I want to export it to Y. I have created a basic script called 'export record found'. This exports records as tab seper…

I have a script that is copying a value from one file and pasting it into another file. It then does a relookup based on the value pasted into the field. When I set this up, it was working flawlessy. Now it is not working. It will not overwrite what is on the clipboard. No matter what record I run the script from it still pastes the same value into the record in the other file. Any idea what might be going on? I didn't know if there was a way to clear the clipboard before coping the field. This way it would guarantee that I am coping the field value from the current record. I appreciate any help you can offer. Thanks, John

Hi there, I have an offer to buy Scriptology Developer's Toolkit for $200. How does that compare to FileMaker Pro Advanced Scripting 5 volume CD set from MAC Academy? Which one would you rather get? Thanks

Is there a script if step that can be used to determine if a database file is being opened on the machine the files reside (host), or if they are being opend via a client? And can this script NOT be based on the name of the computer, in case the files are installed on a different computer? Larry

Okay, I am trying to print my scripts to a PostScript file. This is something I've done many times in the past. But now when I do so, everything proceeds like normal... no error messages, the dialog shows the print progressing through a page or two for each, the dialog says that its saving. But no file appears. FMP v 5.5, Mac OS 10.1.5. I even rebooted the machine and re-tried. I've tried on numerous different FP5 files. Any ideas? Has anyone had such troubles?

Is there a script that can... If I enter a large field of text, insert my curser somewhere in the text, then hit a button, can the script with that button then insert text where my curser point is in the text field? And can the text it inserts be text from another field (I know how to do this part up to here)? And for the part I cant figure out...when it inserts the text from the other field can it maintain the formatting that the other field might have, in particular, the color of the text? The reason I ask is that I currently have a time stamp button that inserts the current date and time at the curser point in a text field. I was just trying to figure o…

I would like to know ...If I have a a field text ...when I enter text field and press Enter and it execute the script ...instead of enter the field and press the button to execute the script? IS there a way to achieve it? Thanks

IS there some way to include a tool tip on a button? That is, when you roll over a button, is there a way to make a field appear where you're at telling you what that button does?

good morning, i would like to export more than 1 text line for a record. i have created a calculated field using the cr character but it does not work in a text file. eg. 1st record to export !col1, col2name, col3name abc, 123, uluvme it's got me baffled.

hi all! I was just wonderin if there is a way to open a pdf file in acrobat from file maker? i seem to be able to open it IE with the get url command but i need to be able to open it straight into acrobat and not in a browser window. This will be going onto a cd. I have very little knowledge of FM so be gentle. Thanks SAQ

I have a number of files linked together. I'd like to be able to create a back button that takes you to the last file you were in. I thought I could do this by creating a global field that contains the last file (updated by putting Status(CurrentFilePath) into the global before leaving the page) and then opening that file. However, the "open" file command doesn't have the option to open a file using a field value; it just asks for the specific file. Is there some way to do this?

not sure if this is the correct forum, but here goes.......I'm attempting to have a flag field switched "on" whenever a specfic field has been modified so that users can easily see which fields have been modified. I only want to flag actual changes. Any suggestions will be greatly appreciated. ...haps

Does anyone know how to get the sendmail feature to work with Netscape Mail as the default mail client? I can get the script to fill in the subject and body of my Netscape message but the To: address will not fill in. Netscape mail has the To, Reply-To, CC, and BCC in a drop down list so I'm guessing this is the problem. Does anyone know of a work around? Thanks in advance for any help you can offer. Lisa

Hi! Is it possible to set up a script (in a table view) to say something like, "If x field = "no", fill color = x"? I want to be flagged when an authorization is not signed by changing the field fill color. Or at least the text color. Am I nuts? (That is debatable, I'm sure)

Is there a script or applescript to open sherlock ?

Is there a way to set the screen size and position of a window upon opening? By position, I mean position in relation to the screen itself. Thanks.

Boy, you close one issue and another opens <g>. Due to changes I've been able to make where I can now enter two types of data into a database and manipulate them, the FIND buttons are no longer good since they deal with ALL the data. I need to change the find to search, I guess, within the already found conditions (?). Here is the current FIND ALL script now (not 100% accurate since my export to text took out at least some quotation marks, and maybe other stuff for all I know, but you get the idea): Go to Field [ "Recipe Title" ] Set Error Capture [ On ] Enter Find Mode [ Pause ] Go to Field [ "Recipe Title" ] Perform Find If [ Status(Curre…

Thanks to Mod, I can now send my documents via e-mail simply using Print to Pdf application. I started manually and this works great. Now I have troubleshooting with the script "send email". Suppose I want to automatically send via e-mail a new order to one of my clients. I created a script that first identify the order, then switch the printer and print it via Print to Pdf and save it as Order N

I'd like to activate a couple of scripts in a related file from the master file. I know can get a script to activate when i open the related file( via preferences) but that only allows me to activate one script. any ideas?, thanks

Here is the script I defined for the operation. Excuse me if my trnslation from french to english... but you'll find out. Mode Use Activate Layout "ORDER" Activate field "N

I want to attach a script to run when a document is closed. Is there a way to format it in such a way that if a user either chooses close from the menu or just closes the window, the script will run, include a If statment to check something, and if the If statement is not met, the file will not close? LR

Hello Forum, I have literally just started to attempt, using the script maker. I have two questions. 1) When I import a file manually I select "matching names" in the import fields dialogue box, how do I script " select matching" names before importing? I can't seem to find a script command that would allow me to do this. 2) Has anyone ever written a script that allows you to print certain addresses on a specific avery label which is set up on sheets of thirty labels? I need to communicate to filemaker that I have thirty labels on a sheet and once an address is printed on let us say label 1 that it cannot print again in that…

I have a master database file which is made up of 20 smaller databases. The unique identifier (primary key?) for each file is the field "SEF", e.g. SEF = TC, SEF = JM, SEF = DM, etc. Frequently, records are moved from one SEF file to another. Is there a way to automate that process. For example, every midnight delete all records from the Master database and merge records from the SEF databases, then search the Master database for each SEF and export their records back to their own database? The effect would be that TC could change the SEF field of a record in her database to JM and when JM logs on the next morning, that record would be in her database. Rick

I know about the scripts for go to browse, find, ect mode. Is there a way to do one to go to layout mode? LR

hi, is there a way to lock a record using scripts? i wouldn't want to lock all the records, just ones that i choose. perhaps with the use of a checkbox to define which records are locked and which ones aren't. to unlock, specify a password. if locked, no fields editable. if unlocked, all fields editable. using fm pro 6.0v3 on win2k. any ideas? thanks, jd.

Tried going through my 100 or so saved templates and demos and nothing comes up so far that isn't just a simple enter find mode and perform find type of deal. Pls and thanks!

I have a database that I only want certain people to be able to run a script that will modify this one field. Is there a status function that will return what password was entered upon entering the database? When I created the passwords, I did only give access to the field to the passwords that I want to be able to modify it. Read only access to everyone else. But I would like a nice way of letting the users know that they cannot modify that field. I would rather not leave it up to FMP. I was hoping there was something similar to the Status(CurrentLayoutAccess) function but have it on the field level or return what password was entered. I would then create the scri…

How do I create a desktop icon that will open a file from a host directly?

OK, so I set the available menu commands to Edit Only in access privleges so as to force users to use my buttons with scripts attached or creating new records and deleting records. The problem now is that this disables a lot of the find features. For example, have a button that enters find mode and you no longer have the ability to add new finds, duplicate finds, omi, ect. By setting menu commands to edit only, these features are gone also. Would you not think FileMaker would realize that Find functions are a feature of editing records, and thus leave them available? LR

Hello, Probably get this note here a lot, but was wondering if there's a tool that would allow me to write the script that I want in text format, and then have it automatically imported into Script format? I have about 100+ files that I need to import into one file, and I am getting tired of having to constantly use the mouse. Thanks!

I wish all functions could take computed text arguments like GetField does. Is there anyway to be able to *compute* or *lookup* the name of a layout to go to? Is there anyway to be able to *compute* or *lookup* the name of a script to perform? Is there anyway to be able to *compute* or *lookup* the name of an external file in which to perform a script? For example, for each file I add to my system, I must add a new Preview layout to my floating Preview panel file and 8 new scripts. The layouts are identical except they call the corresponding scripts. The scripts are identical, except they reference the corresponding layout and the corresponding exter…

I was trying out a new set of scripts, when one of them tried to create a record without filling in both required fields. Up popped a dialog... and since this is mid-loop, many more such dialogs were to follow. In that situation, how do you abort the script? It seemed no matter what I did, I couldn't make it stop. Allow User Abort is just for the script its called in, right? It doesn't carry over to sub-scripts, right? Any tips? What I really wanted was for it to take me into ScriptMaker at the point where the script was at that moment. From there, it would be easy to fix. Does ScriptMaker come with any sort of debug capability? Profiling tools? Trace t…

Dear All, I would like to make a script to find record in portal Enter find setfield (relation:field,"Bill") Perform find It does not work Even I click manually Find mode and type in Portal : Bill ...it finds everything Why is like that? Someone can help me out? Thanks

okay - here is what I have: I need to create some sort of counter. Thought it sounded easy, but I am getting stuck. I am using FMP6 on OSX. I have a script that does a find. On each set of criteria it will find no more then 100 records. On this set of records - I sort by price ascending. Now - I need to take those sorted and found records and break them down by how many there are of each price. For example - if there are two books at $200 - I need a field to populate with the number 2, and then another field would populate with the number 5 if there were 5 books available at $1000 and so on. My ultimate goal is a graph of how many books at the di…

Is there a way to trigger a script when I leave a field? I'd imagine there'd be something like this since FMP does it when you validate something. Or do I have to buy a plug-in and what plug in would be good for this?

I'm stuck writing a script that includes a step to 'empty' or clear a date field. I've tried 'Set Field', but the 'Specify/Calculation' dialog box requires an entry. I have tried entering "" to this box, but this results in the formula Set Field["FieldName",""""] which the field displays as an error. Any ideas?

i am after a calender or scheduler that i can attach to an employee id and track their sick days and holidays. any ideas would be appreciated.

I am trying to make up a script to print records containing one field with a very large text. The length of this text varies per record from one line to a few hundred lines. The problem is that if I design a layout that would for instance be three pages long (for about 180 lines), the printer would print three pages per record, whether the text in the field is only a few lines, or very many lines. I the first case I am left with empty pages. Is there a way to instruct the printer to only print the first pages with text in it?

Can FM do this: 1. Handle records that have a time field (let's call this "LogOutTime".) 2. Always automatically check if the actual PC time is the same or almost the LogOutTime of any record. 3. Blink the record and play a sound when the PC time is the same as the LogOutTime. I've tried a calculation with container results to at least highlight the record whose LogOutTime has lapsed the actual PC time. But it doesnt refresh automatically. It only highlights when I refresh the layout (through a scripted button). I tried an infinite loop that refreshes the layout every second, but it doesn't allow the user to do anything else on the layout.) If I think like…

Does anyone know of an FM Pro script for extrapolating info from a web site log? Thanks! Stephie Smith

What does it signal to you all when a sort doesn't alphabetize properly? Before and after a manual sort, the sort box shows the right sort commands are present. The "perform find" button doesn't change these, they remain the same after the find is done, which signals that the correct set of sort commands are being carried out (versus a change meaning the sort is not the one you want). Only, the results don't come up alphabetically, ascending. I click, to be on safe side, the "replace" radio button instead of "keep" when re-closing the script. Nothing. After performing the find, I can press the manual "sort found records" and everything snaps into proper order bu…

I need to create duplicate records of both a parent record and related child records. The parent dB is "proposals" and the child dB is "line items" for the proposals. My salesmen want to be able to create a duplicate proposal with all the line items and then modify the line items to create an alternate proposal for the customer. How can an automate the process so at one click they can: 1. create a duplicate of the parent records (with a new proposal# auto indexed) 2. Create a duplicate set of all the related line items with the duplicates assigned the new proposal number. I've tried a few approaches, but have hit a roadblock on every approach. Any help …

Hi, it's me again! This forum has helped me every time in the past and I'm hoping it will help me again. As I have said before, I am designing a database where any layout in the database can be reached by choosing two pop-up numerical value lists "Stage" and "Batch". I have created a clever(ish) calculation that will combine these two values when chosen to return the layout number required, then send the user to that layout. I am hoping to use this script sent to me. I am having problems with this. This script starts like this. Allow User Abort [Off] Go to Field [stage] (This is fine. Stop the user from stopping the script and go to the field sp…

All, thanks in advance. I have script to 'open url' with mail to tags.. .it works, but now I have my 'ascii' codes for spaces and returns that appear as text in the body of my composed email in Entrourage. Does this have to do with the UTF-9 vs ASCII encoding? Thoughts,

hi, can someone help ? I am trying to figure out a formula for a field! I have a project number and a band number they are related in a one to many relationship. I want the band number to have the project number + 1 i.e. Project number 02.01 and the band number to be 02.01.1 then the database automatically make the next band number for the same project to be 02.01.2 how do I do this what

If I have a file with a script that is set to run an external script in another file, is there any type of IF calc that can be used so that if the other external file is not currently open, the external script wont be run? Right now, if I run the script with the external call, the other file is opened and the external script in that file is run. I only want it to run if the other file is already opened. LR

I have a portal. I have a button in each portal row. What I want it to do is if a user clicks on it, a field in that portal row is copied, then a find is performed in the parent file (not the file the portal is related to). It is easy enough to to copy a field, enter find mode, paste the copy into a field, perform find. The part I am stumped by is how to have a button sitting in a portal with a script attached know to go the field in that row. Basically what I am trying to accomplish is the field in the portal has a id name. The parent file will have a single record that has a id name that is the same. I want to click on the portal row, but instead of it going t…

Hi, I have a CheckOut database that looks up a value list of Items from an ItemsDescription db. There are more than 1 of some items, so I've created a field that creates a list of consecutive n+1 numbers (one on each line). I then made a value list of that field. What I want to do on the CheckOut DB is use the Items Value list as a lookup and, if there are more than one of that item, activate a lookup of the number list. How do I go about this? p.s. eventually, it would be nice to deactivate any of the numbers on the CheckOut number list that are currently checked out (I already have a currently checked out items list). Again, thanks for all your expert …

Operating system - Windows. Is there a way to script the "x" (close window). I have many related files to a main window. Would like to be able to script the "x" on main window, if user clicks on "x" that all files close. I do not want users to access directly to related files. Currently have related files opened minimized. Does this make any sense???

lol, well, got my db working beatutifully thanks to everyone's help. Just ran across a tiny, little, teeny-weenie glitch I must fix so that people can use it without a hitch <g>. I'm glad that one of the layouts I have in the db hasn't anything entered into since it's new. All along I had just some dummy records I was using to test the scripting. When I was done just now with the filtering issue, I deleted all of them. I was then in the main layout that has 280 or so records and was trying to get back into the new layout when I was stopped by the "go to" not finding data according to the FIND criteria. So it will go to the new layout, but only after stoppi…

When debugging scripts and requesting help (like we do here), it'd be so much easier if we could export the entire script in all its steps to a text format that we can just copy/paste easily. Is there any way in FMP? (I have FMP 5.5).

How do I script the "go to" so that only records of one type (in this case: source = M for MISC layout and source = B in BOOK layout) so that user only sees pertinent records for each layout? Cataloguer (empty).zip

I found <<Total>> in a demo so I researched how to use this. I found out it's based on a calc, as you all probably know, of: Status( CurrentRecordCount) But I am filtering data for each layout and now see that it'd be better to show the found records. Currently, I have this: Record @@ of <<total>> but was hoping to have Record @@ of (found records), Total records = <<total>> something like that. it's the "found records" I'd like to show. How to do?

Does FMP provide any way to find all dangling script calls... calls to "unknown" scripts? The same question for unknown fields? Etc. Thanks.

I'm trying to create a script that does something fairly simple. At least I think it is simple. I want to find all records with the field "Buddy" set to "Yes" And omit all records that have the field "Status" set to "Inactive" Any help would be appreciated. -Kirk

I have a script that has a pause built in so that it waits until a user makes a selection from a pop-up list: Allow User Abort [Off] Set Error Capture [On] Go to Field ["Letter"] Select All Loop Pause/Resume Script [0:00:01"] Exit Loop If ["Status(CurrentFieldName)<>"Alphabet" "] End Loop If["Status(CurrentError)=400"] ShowMessage ["You did not enter any find criteria; all records will be displayed."] Go to Layout [original layout] Else Perform Script [sub-scripts, "find it"] End If Basically it is a button, select it and a pop-up list comes up with search choices. The script pauses until one of the letters is selected, then when …

Hi, First forgive me, I'm a bit of a newbie to Filemaker Pro. However I would appreciate some guidance with the following conundrum. I am creating a leasing package for a law firm. At the top of the data entry screen are buttons for each shopping centre. These are grouped in client groups. e.g ABC Corporation has 123 Shopping Centre, 456 Shopping Centre and 789 Shopping Centre. When you click on one of the buttons the information for that shopping centre is entered automatically into the appropriate fields using a script. Because we're busy little vegemites, I now have some 30 shopping centres I need to have buttons for and as you can imagine it is…

This should be another easy one. I have four navigation buttons, FIRST, PREV, NEXT, and LAST. When i just have them do these simple steps, they work fine. However, I'd like to sort the records every time someone hits the button (so that new people added are sorted instantly). When I put the sort command on First and last work, but next always takes me to record 2 and prev always takes me to record 2, even if I add new people. what did I do (or not do?)?

I'd like to prevent users from creating empty records. What is the best approach. Could I write a script that checks the entry as the user exits the record?

I've been playing with FM 5 for a few weeks now, and am still trying to bend my programmer-trained mind around the FM script engine. I have grudgingly and painfully accepted the fact that local variables, procedure arguments, and return codes just aren't available. After reading through these forums a bit I hear a lot of people saying repeating fields are very limited. I've seen several cases where they were almost useful but due to limitations in the scripting support for them they just didn't cut it. What are the benefits of repeating fields, and where could they be used?

OK, this should be an easy one. I have a field with the calculation: status(CurrentRecordNumber) & "of" & status(CurrentFoundCount) The found count shows me all the records I want, but I don't know what in the world status(CurrentRecordNumber) is showing. In most cases, status(CurrentRecordNumber) is greater than the status(CurrentFoundCount). How is that possible and what am I doing wrong? I just want a counter that shows the record number I'm on out of how many there are in the database (or after the find).

Hi guys, I have a (hopfully) question. I made a Filemaker database that handles injury reports for a company. Now the report section of the database can be any amount of pages, for example, one report might be 2 pages and one might be 100. How do I print ALL contents of a field? I've seen it done once.. in the Filemaker program OptiGold.. Please help Thanks, -Matt

I have a field that receives an "x" if information in several other fields have information in them. I need to change the script FROM: If(not IsEmpty(Art 88to95) or not IsEmpty(Music 88to95) or not IsEmpty(Theatre 96to02) or not IsEmpty(FineArts 88to95) or not IsEmpty(VPAS 88to95) or not IsEmpty(CPAS 94to95) or not IsEmpty(Art 96to02) or not IsEmpty(Music 96to02) or not IsEmpty(Theatre 96to02) or not IsEmpty(FineArts 96to02) or not IsEmpty(VPAS 96to02),