Script Workspace and Script Triggers

Can anyone give me information on capturing electronic signatures with a signature pad in Filemaker 5.5? Thank you

I am having a formating problem. I have two number fields (Num_1 and Num_2). These contain numbers with one decimal place. They are number fields becasue they are used for sorting. A third field (Num_3) is formatted as a calculation: NumToText (Num_1) & " / " & NumToText (Num_2) With the result set to be text. The result is fine until one of the numbers is, for example, 34.0 In the calculation field this appears as 34 What ever I seem to do I cannot get the calculation to return a decimal number when there is a zero after the decimal point. Can anyone help please. Chris

In File 1 there is a two-position alpha code indicating a client code. File 2 is a job number log, which has one five-position alpha-numeric field called job number that consists of a 2-digit alpha code (client code) and a 3-digit numeric code. > When assigning a new record in File 1, I need the system to pause to manually enter the client code, open the Job Number Log (File 2), search the 2-digit alpha code for the correct client, go to the last job number for that client and return the next sequential job number. FM then needs to enter that next job number in the appropriate field in File 1. How do I write a script to…

I am trying to get a field to show a period number depending on what the date is - have tried a script which starts: If (Date to Text (Period Start Date) < Date to Text (Today) < Date to Text (Period Start Date + (7*Period 1)) Insert "Period 1" Where Period Start Date is the start of period 1 Period 1 is a field holding the number of weeks in that period This is then repeated and amended accordingly for the further 11 periods Unfortunately I cannot get this to work - Any ideas? Cheers Nick

Not quite sure how to explain this. I've seen it done, but can't figure out how they did it. In a list view, if you click on the title of a record, it will take you to a different layout. Within the layout will be another list and if youclick it takes you to that info. Ideas on how you can chane layouts with just a click on the title? A "define button" was not used, and nothing is under the scripts. -j

contacts.db and orders.db have a relationship with the field contact as the key. HOw can i create a script/button in contacts.db that will take the current record details from conatcts.db , create a new record in orders.db and leave me with that db in the foreground with the related info?

Hi, This is a problem that I run into with almost every data base I create. In my latest database I actually have 2 related databases. The first is "Clients" and is a basic contact manager. The second is "Policies" which holds all the policy information for all my clients (in case you haven't figured it out this is for an insurance agency). In my Client DB I have a button that creates a new policy. The script is supposed to copy the client id, open the policies DB, request a new record, past the client id and based on the id the pertinent demographic data from Client DB is shown in related fields (like last name, first name, etc.). Then back in my Client DB I have a …

I have a startup script. I hate to bore you with all the steps, so I won't (if this is not enough info, I will post the script). It opens another file, checks if a field is empty, if so then I would like it to maximize the related file. Basically the main file contains client records, and the related file contains producer records. If there is not a last name for producers, it shows a message that says "there are no defined producers." Then I want it to toggle the related file maximized so that they can create a producer record. The problem is that it wont. No matter what I try, the main file eventually ends up maximized. I have tried a toggle window script st…

I have a db which has a welders form that is used to qualified a welder for two processes. I have combined two fields to create a unique ID for each process. The fields combined are the welders id number and the process (ex. 3605FCAW).I have written a script using the set field command that creates separate records for each process in another db to store the data. This works find except that sometimes the form is used for only one process. When only one process is used, the second unique field will only have the welders id (ex.3605). As this number is only enter once in the form, this creates another record in the db since there is no reord in the second db with just the…

Hi all I have not been able to figure this one out. I have two db and i am trying to automatic enter a date into the second db. The first db has a form for welders qualification. A welder may be qualify for two different processes on the same form at the same time. So the date for both of the processes would be the same. The second db has a list of the processes and a field to install the date that each process was qualify. I can do this manual but was looking for a way to do is automatic. Also went the same welder is requalified on one or more of the processes, I would like for the date to change to that date in the second db. The best way to explain wou…

I have two files which I have on server with client computers. One file is logon file which checks usernames and passwords. If username and password are okay, user can go onto main db by clicking on a button which runs a script to open main db. I use a relationship to send info from one global field in logon to another global field in main db (fields hold info I use to direct users to certain layouts based on position and access level). In the main db some users are restricted as to which records they can browse, edit, delete through the FMP access privileges. Problem is when the logon file opens the main file, if the first record is on…

I have a DB of events. I would like to create a script that will take the user to the next event. Given that the records may not be in date order, the script obviously must sort first, but a simple, "sort -> next record" always results in displaying the second record. How can I create a script that will simply take the user to the record with the next sequential event date?

I have a list of "jobs" in a list layout view but what i would like is to have a button next to the job that says "completed" and then when you click this it will then move this record to a seperate "archive" layout... is this possible. thanks in advance for any help... alan

I have two db's. one has five fields in it. one of this fields is a date field. The other db has has nine fields which four of them are dates fields. This dates in the second db represent the original date each welders was qualify for each welding process. I made a relationship between the two db using the welder name and use the set field command to create a new record in the second db. this works fine for the welders name. Then I use the set field command for the date. this does not work. Example Set Field["rlated:Name","name"] this workd perfectly Set Field["related:Date2",Date"] this doesnot work this is in a script I would like to …

I have a database that uses a field that auto-enters a serial number in a field everytime a nw record is created. Would there be a way to create a script that would go to the record where the field named "serial" contains te highest number? LR

I'm trying to take a list of records, each uniquely numbered 2, 4, 6, etc. up through 100, and dynamically change their ranking values if one of the records changes values. What I mean by this is if the record with a field value of "2" needs to change to "16", and then what used to be "16" needs to go somewhere new. I can't figure out a good way to control this change process. There seem to be two issues, one of the leapfrog state where there are two records being affected simultaneously, the one with the current value and the one with the destination value ... I'm not sure if I worded that very well. The other issue is a way to have all t…

We use FM to handle our e-mail, but a problem has arisen (that such a word? anyway...) when we want to "reply" it creates a new record, but adds it to the end of the found records. when we hit queue, we want FM to take us back to the origninal record, what's the command to do that? Thanks.

I am trying to setup an automatic invoice numbering script. The invoice number is made up of the job number and the invoice number. (eg "JOB01-01". the next invoice in this set would be "JOB01-02") So I'm trying to increment the second part of this invoice number. What I've been trying...unsuccessfully: I do a find on the JOB number, get the count with "Status(CurrentFoundCount)", take that number and add 1 to it "Status(CurrentFoundCount) + 1" and then concat this incremented find count for the JOB number to the JOB number. JOB number & Status(CurrentFoundCount) + 1 I can't get filemaker to do it. HELP. What am I doing wro…

I am using send email script step and this step is configured to show dialog but when I am accessing my system from a Mac the email is not shown and it is copied to the Drafts folder of my default email program (on windows it works). How can I show the message that I what to send on Mac OS systems. Thanks.

Hi problem solvers ! I want to use Freeze Window to go to another file without the user seeing it. Although the user does not see the second file, he does see quite a bit of flicker & movement etc, as file #2 opens and the original one comes back to the forefront. Is this the way Freeze Window is supposed to work? Is there some way to prevent the movement? Thanks. Jack

I would like to create a script using either applescript or filemaker to perform the following: at 7:00 , 10:00, 14:00, 18:00, 22:00 perform filemaker script "import" To give you an idea of exactly what I am try to accomplish- We have a in house system here and we have a remote filemaker web server host and we would like to import our new records without having to have a person doing it. So that is why I have times to perform script. Thanks!

Is there a way to automatically open files hosted on another subnet Right now users have to click Hosts - Choose the specific hostname - Wait for the db-list to appear - Select a correct file and click Open. If this could be scripted from a simple opener file it would greatly simplify things for end-users.

I'm trying to find the absolute best solution for scripting the export of a single record from one hosted database and importing into another. I'm trying to develop a single button solution as the majority of my co-workers aren't saavy enough to manually export and import each time. I first created a script that exported the current record to a file on the server, then ran an external script in our Closed Customers database that imported that record. However we have OS X and OS 9 on the same network and we're running into some issues, so i switched the script to simply omit all records except the current, then the Closed Customers script imported directly from the host…

Are there any known problems using global text fields with the send email script step?? I am trying to use global text fields containing multiple addresses in the To and CC sections of the send email script step.

I have a db that has 33 records and each record has five date fields. I would like to displayed only the fields and not the whole record that meets the find criteria. I have made a list view form and install all five dates in it. When FM has found a set it displays all the dates. Is there a way of doing this by script. Example: Criteria date 7/12/02 Field one date 7/12/02 Field two date 7/18/02 Field three date 8/02/02 Field four date 7/12/02 field five date 10/12/02 I would like to see just the dates that meet the criteria displayed. Not all the records will have the same dates. …

I need a script to show container files From database #2 on a record in Data base #1 and Loop through all the container files one at a time ( like using the pause/Resume script for 10 sec. The container file is Picture files we want to show at the botom of page in database #1. (We don't allow duplicate posts of the same question. Please answer in "The Left Brain". I'm closing this thread. -bd)

I would like to create a script that would allow me to make many duplicate records. I want to be able to select the number of duplicates. At the same time I want each duplicate record to have a file number that increases by 1 with each duplicate.

Can someone please tell me how to write a script to move data from fieldA to fieldB. Can this be done? Any help would be great. RET

I am writing in FM 4.0v1 a continuity welder log. Each file has a date that each welder was qualified and another date for requalifying. I have a layout for enter the criteria date and a find script attached to a button. The criteria date field is a global field and I have use the set field date to enter this date in the five requalifying fields. I want to enter the equal to or less than symbol in the criteria field but cannot figure out how to input this into a script. The requlifying date could be five different date and I want to see only the date or dates that match the criteria. Any help will be greatly appreciated. Thanks Lionel

Hi everyone, I want to automate a quick report on Companies, Managers, and their attributes like age and salary. These are found based on some criteria. I have to files that are related: Companies (One side) and Managers (Many side). The report must be on a one record basis to fit on the layout, such as: ------------------------------------------------------------------------------------------------ Company Name| Managers

How do you write the script to "goto related record" in file "A" AND then choose the right layout view in the related file "B"? My app is just returning the user to the last layout viewed in file "B" when I need to specify a layout view. Thanks

I have a field "maturity_date" with the format mm/dd/yyyy and would like for the user to click on a button that corresponds to the month they are wanting a reports content searched/based on. I have a layout that has a button for each month of the year. I just want the report to contain maturity_date for the month and current year. Thanks

Hi! there, another new baby to FM. I need to override lookup field on aselective bases. I should explain here what I am attempting to do. I am seting up a custom manufacturing retail database. With almost 5000 items and prices. I have created a relational database with 12 files. When entering order the "item#"s is selected from a file called Products, which has all the items, as soon as item# is selected all other info( name, unit price, piece weight and ex price and so on) will auto fill in. However, once in a blue moon, well make it a thousand, I need to enter a item # ="other" ( manual entry of all other info, these are the items that are designed for o…

I had posted this over in the portals forum, but didn't get much of an answer there, so I'm goign to move it here and try again. I want to do a split screen between 2 files. How can i tell FM to split the window of the file to 50% horizontal?

I have two files. I would like to copy and paste data from three different fields from file A to File B. I have created a script that will copy the contents of one field in file B then open file A. Then I past this data into the file A field. Now I have to manually go back to the file and do it again. Is there a script that will allow me to copy and past three or more fields of data from one file to another. I know I can accomplish this by relating one file to another, but I am looking for an alternative. Thanks

I have a database with a datefield. I need to find the records that have no date in the datefield (finding =) and those who contain a date after the date of today minus 8 days. So today is 04-05-2002, I need to find > 26-04-2002. It is necessary to perform this find in a script but whatever I tried it does not work. Does anyone have a solution ? Bert

PLEASE can someone tell me why Sorting (by the field button) is only prioritising one field. I've created the scripts for 3 fields. I've gone over them a million times and redone them and still only 'Field2' will sort AND only descending. Once sorted that way, none of them will budge even though there seems to be no error with clicking on the button's on the other fields. If I sort using Sort Menu (which also insists on coming up with the 'Field2', I have to clear it each time) ,but then when I click the buttons to sort any of fileds again, they will only sort defaulting 'Field2' and descending. I hope this makes sense coz it's driving me nuts.

I've seen postings on this, but never a solution... Is it possible to (easily!) script multiple find requests using values obtained through checkboxes? For example, a database of critters is classified by type: cat dog bird snake mouse I'm generating a report. I would like the user to specify (check) through checkboxes which critters he/she wants to include in the report, then script a find to isolate just those records. I (more or less) understand scripting multiple find requests, but translating the "checkboxed" field contents to multiple find requests loses me. Any suggestions before I try to do this the long way would be much apprec…

Can I use the Set Field script step to set a date field to blank? For example, I have a field called birthDate defined as a date field. The field is populated for the current record with a date of 1/1/2002. If I want to remove the date so that the field is no longer populated with data, how would I do this using the Set Field script step? If I specify that the Set Field script step use quotes ("") as its result, the field is then populated with an invalid date. The technique of using quotes ("") with no data between the quotes works with text and number fields.

Beginner Problem here: I have about twenty dbs that individuals work on. As they enter data it, through a relationship, is assembled on a master document. I set up a new quarter today. Doing this exports an alpha list of people and basic information and sets up the new quarter. (The loop script includes the master document.) Works fine. However, because of the relationship the master document does not create a new blank quarter. The new quarter displays the information from the previous quarter. This is only the second quarter I have used this database. I see the problem, but because I am a beginner, not sure how to approach this.

What is the equaviliant of doing an Else If in FM. Most programming Setups you can do a If ElseIf ElseIf Else etc. I don't see that. Thanks -j

I need to define which value list a particular field uses for a popup via a script. Specifically, I am trying to setup a web interface for class registration at the High School I work for. I am using FMP4. I have a database with all the classes in it, and another database with all the students in it. I have setup scripts in the class database that makes two lists of classes for each grade, required and elective. Each student picks a total of 15 classes per year. What I need to be able to do is setup a script of some sort that looks at each students' grade and then decide which class lists to show them on the web interface, in a popup list. For instance, 10th gra…

Interesting question, I have a script in File1 that is setting a global field (insert calc result) in File2 based on values in several summary fields in File1. I am performing this script from File2, and sorting (I know it's important, I'm sorting correct fields in File1). But my global in File2 doesn't get set. If I run the same script locally in File1, changing it to set the local Global (ha ha) field, it works. Is it something about the summary fields that doesn't allow to do that across files? Thank you

I have posted serveral questions about scripts and all the inforamtion has been very helpful, however I need more information. I can't seem to get this script to work exactly the way I need it to. I have created a script that will (with the push of a button)copy the data from fieldA to fieldB.....the problem is that fieldB is in a different layout and I can't get this to work. How can this be done? Please Help! RET

I have 2 separate programs. I have a "welcome" screen that contains 2 buttons. Each button is a small script that opens one of the programs. Each script is exactly the same except for the name of the file it is supposed to open. Here's the problem: One button works as it should. The other button opens the folder where the file is located, but waits for me to select the file . It makes no difference if it is set to relative path or not. It make no difference if it was the last file selected or not. Appreciate any ideas... Thanks. Jack

does any one know a way of getting the initials from text i just need the first letter fromeach word in a product name to put in a chart help please ps i dont want to have to define any more fields if poss

Hi, I have a script that is exporting records from FMPro into a text file (created in the script using applescript) The file creation is fine. I keep having an error saying, "no fields selected for export" - or something along those lines. I have tried putting a 'select all' statement ahead of the export funtion, however this seems to have no effect. The export works if I uncheck the 'perform wihtout dialog' box - It prompts with a select fields for export box, which you then have to manually select which fields are to be exported. Does anyone have any idea how you select the fields for export (preferably only the fields that are in the selected Lay…

i've developed a solution (mac) that includes the ability to import pictures. the script goes as follows: Set Error Capture [On] Go to Field ["image'] Insert Picture [] Exit Record/Request the solution is bound in a runtime (5.0) and the customer has placed the graphic support folder with the translators in the solution folder. jpegs don't seem to be supported (which is odd because the standard FM package supports it). i've advised to convert to pict or tiff, but once the user clicks on the import button in the file dialog, no image appears in his frame. since i've disabled the errors, nothing happens at all. i can't confirm this on my…

I need to make a script that will count lines of text, typed, on a 8 1/2x11" paper, that use the same size font and lines are double spaced so there are blank lines between each other. I will design the application to fit the text, font and size into a sized frame, but how would I go about creating a script that would count the lines of text and report the results? Thanks for the help.

Does anyone know how to write a script that will triger diffent options. I guess what I am trying to say is....say I have a field with the number "1" in it and I have a button that will run a script based on the number entered. So number "1" will triger one script and the number "2" will triger a different script. how can I achive this? RET

I have a script that will import a record from db 1 to db 2. When the import is complete, the new record is given an auto-enter serial number (in db2). I have a line in the script to close the original file (db1), but before it closes, I need the new auto-enter serial number (in db2) to be placed in the original file (db1). I can't think of a way to set up the relationship for the 2 files because they will not have any fields that match exactly (until the import is done). If this is too confusing, I can possibly explain it a little better, in length, by email Thanks,

I can

I need to toggle text format from plain to strikeout and back, based on a script attached to a button. I do not see a script step regarding formatting, other than Proper(). I also don't think I can access menu steps through a script. Is there a way to do this? Advice is appreciated.

We're running a multi-platform network with a dozen machines (mac/win) accessing FM Server on a Mac host. Everything is 5.5 The client machines all have startup scripts - they open the appropriate file on FM Server, run an appropriate script, and then the user is wherever that user should be. On the win machines, this is fine. On the Macs, there are times when the script for some reason cannot find the host (we've had all sorts of power problems during construction, so routers have been down, etc, but not the server) and then the client scripts rewrite themselves so that the "open" statement which pointed to the remote DB now points to the DB holding the startup script …

I am trying to use a script to find client records that have a calculated date (LastService) LESS THAN a date value stored in a global field (NextDate). The LastService field is an unstored calculated field that returns the latest date on record in the Services table that is linked to the active client. The date in the global field is set by another script, which then calls this script, so the global field can change. What I have done is: Enter Find Mode[] Set Field ("LastService", ""<" & NextDate") ... What Filemaker puts in the LastService field is just the date, and I can't figure out what special incantation I ne…

I'm still strugling with FMP, so your help is most appreciated. I've bought several FMP books including Scriptology, but I cannot seem to find my answers. The books seem to deal a lot with Layouts and doing lookups to a related file, but I see little on adding, modifying, posting or deleting records in related files (tables). In my other life (other RDBMS app), If I wished to modify a related table, or post new records to that other table, I might do something like this. For Table_1 with date = current date, enter new record(s) (or modify records) in Table_2 Table_1 (field1) = Table_2 (field1) Table_1 (field2) = Table_2 (field2) Tab…

This is probably really simple for FMP pros but I can't figure it out. Here is what I need to do. A user clicking a button on a record triggers the Show Message step and after reading the question in the dialog box they click Yes or No. I've got that so far. Now, depending on which button they clicked, I need the script to insert Yes or No into a "YesNo" text field. Can anyone help me? Thanks! Joe

I have two files - a main file and a second file with all the data. I need the main file to import from the data file once the user has registered, but I do not want to allow him to do so until he has registered with me. I have password protected the data file, and written a script to import the data, but how do I get the script to automatically enter the password of the second file. I do not want the password of the main file to be the same one for the data file because then the user could import the data before he has registered.

Is there a way to have a script run at a specific time? Thanks -j

I use a Mac and Outlook Express 5. I need to send a Email to 975 records in a found set. The Email address field is limited to 256k in size... not enough room for this many addresses. Any idea how to get around this limit?

Using the save-a-copy script step to create a clone works when the file is saved as <file name> clone.FP3. However, if I modify the 'saved' name to <file name>.FP3, it fails with the message '<file name>.FP3' can not be created.... This step works on other files in the solution, but not on this one file. I've tried 'Recover' and can find nothing unique about the file. For this, as well as the files the step works for, the 'save' puts the result into a different folder. Any insight is appreciated. I'm running out of ideas!

Here is what I need to do, and could use the advice of all of you out there. Fields: Passenger (text), Driver (text); Rank (number); RankAdjust (number) Following a search on driver, I get nine records. I assign each record a Rank number from one to nine. However this rank will change based the users requirements. I need to be able to set a passenger to a different number by entering the new rank in the RankAdjust field, post the change and have the script adjust the other Rank numbers in the list. For example: John 1 Mary 2 Jim 3 Marty 4 Alex 5 Ted 6 Kim 7 Mike 8 Joan 9 Suppose I want to change Kim from 7 to 4. Marty ne…

I seem to be posting to this forum a lot today, well that's what it's here for. Once again, thanks everyone. I'm using a calc field to make the body of an e-mail. I want to be able to put a tab into a body of text. I tried copy and pasting one in, and its there in the calc, but in the final version it's not. Any other ideas? -j

Display all currently found records. For example, you do a find and it returns 4 records, the Status() calc thingy that would show "4" is what I need. Cheers Steve Griff

I want to embed a find into a script, but the find may not always return a result (I.E. No records found). In my previous attempts, when nothing is found, a message pops up, and it leaves you with that. Since this will be running within a script, is there a way to do a "if no records found, skip" etc. Thanks -j

I'm trying to get FM to insert the current year into a clac with a date. Currenty it's Date( 01,01,2002) but i want it to be something like Date(01,01,current(year)) tried that, but doesn't work. I need it to do a current year running total. Other ideas?

My quotes are correct i was just trying to distinguish the field names. As for exiting the script, i don't want it to exit even if the circumstance is true, i want it to keep looping through the rest of my found records.

Hello everyone! I am developing a script that is going to run a find request and is to be activated from a web page via CDML. I'd like to declare the request values by user input from the web page. Does anyone know if this is possible? Please share any tips or ideas you might have. Thanks, Kevin

In FM 5.5 Pro I have created a table in layout and assigned a button with some sript to basically open another layout. The script works fine if I change view to form or list, but not in table view. I can shift the field/button to the header and then it works in table view, but I have other stuff there. Also in table view the fields of course look like cells. In layout a particular cell represents a column so will every cell created within that column carry the same script as the script set up in layout mode

Here's another question: I have layout with four entry fields and another field that I am using to instructions as to what data needs to be entered in each field. I've tried to set the instruction field based on the Status(CurrentFieldName) function, but it doesn't seem to work. So I'm setting them with scripts placed on the fields themselves that set the instructions field. The problem with that is that when they tab (which makes sense on a data entry screen), they circumvent the scripts/ Is there a way of setting a script on the tab? Or better yet, does anyone know how I can get Status(CurrentFieldName) to work in the instruction field definition? -Heather

Show the current record number your on. Show how many records are in the database. Any help would be appreciated Steve Griff

Are there any clever ways of (while running an external script) halting the script in one table and returning the end user to the original table and layout? I know that I've done the a million times in the past, but I don't recall just how, and I remember that it's always been a a hiccup. Anyone? -Heather

I'd like to find a way of using a script step that would have the same effect as "go to field" but without having to specify which field to go to. The name of the field to go to would be in a global. In the same way you can specify this in "go to record" This would save me about 70 scripts... Any idea how I can do this? As I'm at it, I'd also like to use "set field" in the same way - the field to be set is the one which's name is in a global. This must be a tough (or impossible) one, but I really hope a genius among you knows how to do what I'm asking for in filemaker 5.0., well I don't even know if it's possible in 5.5, is it? Thankyou for readi…

Hello I've got another script that I'm having a little trouble with. Thanks to Liveoak I got through the other one a while ago. Basically I'm within the one file that I want to do the find on. So:- 1/ I've got field A (date) and field B (person's name). Put either, both or nothing in then push a button. 2/ Based on that it returns all matching fields otherwise if both left blank it returns all records. Thank you in advance Drew

hello, in the invoicing system i am working on, i am not using the FMP status area, i have made my own. on the Find layout i have duplicated the everything successfully but the 'omit' check box. maybe i am not getting the script steps in the correct order. i have a yes/no field called 't Flag Omit' and when checked i would like my search to use the 'omit' function in the search. i realize i need a if/then statement in my Perform Search script, but how do i go about doing this? thanks.

I needed to run a script on a database on another computer. So I enabled WebCompanion on the remote computer. Then created a script on the host computer which has one action "Perform Applescript". This script uses Applescript's "URL Access Scripting". Here is the script contained within the "Perform Applescript" step: code: set the urlfile to "System:Users:garry:Documents:printlabel.txt" tell application "URL Access Scripting" download "http://10.0.1.6/FMPro?-db=barprint.fp5&-format=printlabel.html&-script=print_label&-findall" to file urlfile replacing yes with progress end tell This runs the script on the remote computer which prints bar…

Excuse again my dumb FMP newbie question, but I'm still stumbling over FMP terminolgy. For example in my previous life (other rdbms application), I would define a user data entry screen for a user to enter some temporary data (e.g. date ranges). From there, the user would execute the procedure to modify the selected records. The user entered data is only temporarily stored for use with the procedure. How would one do this using a script? Thank you.

I'm creating a script to perform a find based on manipulation of some fields entered by the user. This script then calls PerformFind[]. The script is currently attached to a button and works correctly. However, many end-users of the data base are likely to type the 'ENTER' key to start the find going, instead of clicking the button. How can I "trap" the ENTER key in a field so that it also starts the script?

What kind of script do I use to find all names that begin with a letter of the alphabet? What I want to combine to letters... is it possible?

I'm creating an email output from portal row info. Everything works perfectly, but my client wants certain rows to show up bold or in a different color. Does anyone know of a way to do this? -Heather

hey all, i am using (well trying to) the calendar file off of the Everything CD, there is a similar one on databasepros.com. has monday 1, monday 2, monday 3 etc. for the dates. well im at a loss for getting the actual day when a user clicks on one of those squares (monday 1, monday 2, monday 3) etc. its pretty easy to grab the year, and the month, but how to i capture the actual day a person clicks on?? thanks.

Hey there people, take this example for instance http://www.foobar.com/image.jpg Right("http://www.footbar.com/image.jpg"; 4) would return .jpg. Can I get it to return http://www.footbar.com/image instead? Is there a similar function available? Thanxs Steve Griff

Is there a script (either in FM or Applescript) that would create the size of a field's box in Layout mode? The dimensions of a particular field's box would be determined from numbers in a related database. Basically automating the creation of specific Layouts. Thanks, Steve

hey all, please download this file. http://www.meancode.com/services/fmp/window_trick.sit i made this little file in frustration of finding out that the plug-in MoveWindow is $179 for a developer license. ok so theirs works on Windows, but the price is a bit steep. this has been done in 8 fields, and, is free. check it out and give me any feedback you can (can you break it?) i am mostly satisfyed with it, and am going to be able to use it in this invoicing/project management solution i am working on currently for student publications. but i see a little more potential. instead of using Status(CurrentFileName) to get the …

I have a script with a loop, and I want to exit the loop when I 'arrive' in a certain field. I think it's quite simple, but since I'm a newbie, I couldn't find it. [ April 11, 2002, 05:04 AM: Message edited by: ikmattie ]

Does anyone know of a way to determine (then change) sort order mid-script? Is there some way of determining whether a sort is in ascending or descending order? All that Status(CurrentSortStatus) does is say whether it's sorted or not. Any thoughts? -Heather

there are 2 things i would like to do without a plugin. i would like to hide the close box widget (Mac OS 9) without having to pay for modifyWindow. i would also like to be able to rename a file without having to pay for modifyWindow. meaning rename invoice.fp5 to "Inovicing" in the db's title bar. is this possible? is this done with AppleScript or AppleEvents? does anyone know?? thanks. i mainly dont want to have to rely on a plugin to do these things, its not the money for the plugins.

I am developing a db for our web design/hosting company. Here's the dillema. I have three databases. vc_client, vc_billing and vc_server. All of the revenues for design are straight forward. However, we have two people providing hardware for servers. We have a seperate agreement with each one. Each one receives 30% of all revenues collected for hosting ONLY for clients hosted on their respective server. Am I completely confusing you yet? ;-) In the vc_billing db, I have a field for each server that I enter the amount the client has committed to for hosting on a monthly basis. For instance, if I am serving your web site on server1, I will enter 50.0…

FM v5.0 Win NT & 2000, 109 Filemaker databases currently served w/ FM v5.5. Is it possible to give certain users permissions to a single script or even better a single step in a specific script? The sciptmaker permissions that are assigned to a password give access to Scriptmaker itself and ALL of the scripts. What I want to do is give our Reporting Department the ability to set the Export order of a "Report" script. Currently they have to submit a request for it to be set and with 109 db's... Is this possible with 5.0 or 5.5? Or with a plugin?

Hi there, Don't know if you can help me but i'm trying to make a script. I have a dbase with addresses and 3 different layouts. On my keyboard-port i have a chipscanner. After i scan a chip, i want to save the date(9 numbers), and then print one of the layouts (depending on data in dbase). And if it's possible with only one confirmation max to print the active record. Then program should go to the next record. Scan new chip and print layout. Don't know if you understand what i'm talking about but thx in advance if you can help. Siegbert

Hi there, I have this field with: - foobar , textiush etc. I want my script to remove the "," and everything after it. Any help would be most appreciated. Thanxs Steve Griff

My question is when zip codes are entered with 5 numbers and then the new 4 numbers but wihtout the hypen is there anything you can do to automatically enter the hypen without going through all the data? I am self teaching, new and getting frustrated. ex:48825-4801 (?) Thank you

My layout shows a list of records. I need to omit all records on that list that have a certain value in a field. I wrote a script for that: go to first record loop if fieldX = AAA omit record end if go to record next end loop

Hi there i was wondering if there is a way print the defind fields window? or i just would like to know the field names and what they are. something that is simple. if there is a way. Thank you

The company year is split up into periods on a 4/4/5 week basis starting in October. I want to be able to automatically perform a search to show all the records from the last period and also show at the top of the report the date ranges and the year/period that the report relates to. The year would be 2002 for the 2001-2002 year, 2003 for the 2002-2003 year etc... Not really sure where to start with this one. Hope somebody can help Regards Nick

How can i omit records in a found set in a script? Allow User Abort (off) Set Error Capture (on) Enter Browse Mode() Go to Layout inputform Enter Find Mode () Set Field (City, "Brussels") Perform Find() --- i like to omit all the records with City="brussels" If(Status(CurrentError) = 401) Show Message ("No records were found", OK) Show All Records Go to Layout (original layout) End If

Trying to attach an excel file to an email that will be sent through Outlook but everytime I run the script it seems to ignore the Send Mail step - Any thoughts? Cheers Nick

Hello, In a message from April 20, 2001, "dykstrl" presents a script that allows you to move forward one page at a time in preview mode (e.g., to view the various pages of a report more than 1 page long). The script works fine. My question is: is there a way to move forward AND BACKWARD, that is, one key for a page forward, another for a page backward? In other words, can I recreate the functionality of the status area in preview mode (without showing the status area)? Thanks, Ursula [ April 09, 2002, 07:22 AM: Message edited by: Ursula Abresch ]

Hello I'm trying to write my first script and have gotten confused with all the literature. Basically I'm within the one file that I want to do the find on. So:- 1/ I put a date into a field. Then press a button. 2/ Based on that it returns all matching fields and then takes me to a preview of the report ready for printing. One tricky bit is that I want to enter the date once and have it look at two date fields per record. Only one of these fields in each record will have the date in it. In other words it's an "OR" find. Look at date field A and if it matches return the record, then if not look at date field B and if it matches return the r…

FMP 5.5 on Mac OS X - Send Mail script does nothing. I tested it on an existing database that works well in OS 9, and on a simple new database with no complexities - Just a simple, show-the-dialog, Send Mail script. Internet Control panel is correctly set (I think). Default email client is Entourage. Entourage works fine independently. Can anyone help? Thanks. -dp