Script Workspace and Script Triggers

Hello! I need an invoicing form that is set to generate its own invoice sequential number but only after an amount is keyed into any of the "amount paid" fields (there are 10 prodcuts with their own "amount paid" and "date paid" fields). If anyone knows how I could create this form or knows where I could get a template designed for the FM 3.0 version that can do something similar, please let me know. Thanks! Vic B.

I am importing several fields from an Access db. Most of these are calcuated fields. So I created the queries in Access and I do not have to worry about the calculations in FM. Issue: However, there is one calculation that cannot be performed in a single query. Question: What is the best way of performing calculations on the fly, during a script that contains several import record steps?. Is it possible to execute an import returning a value, and to store that value in a "memory variable" or an array to be used in a calculation? I appreciate your help. (I am using FM 5.5) Thank you Erol

I need to print label for companies I send checks out to on a monthly basis. What I would like to do is have a layout where I could punch in a paid date and it would only list those companies which I paid on that particular pay date. The problem I am having is I could pay a company multiple times per month so when I perform a find I get multiple Listings. Is there any way to write a script to only bring up the company once in a find.

I need to execute a script that does this: Enter search criteria in field C, have the find look in field A and field B for the results, have the results posted as a columnar report in Field C WHERE: Field A and B are a date fields, result C is a date field WHERE: Field A is in main database, Field B is in another database, result Field C is in main database If needed, the search criteria can be entered into new field D, where results from A and B are displayed in C In all instances, only a single date will be searched, not a range. The results from both field A and Field B MUST be displayed in field C Thank you.

Your Set Field steps aren't doing anything, because you haven't included any formula. Delete the Set Field[Temp] step, and just enter the value before you run the script. Next, delete the show all records step at the end. It will undo any find that you have already done. Your script should look like this. enter find mode set field ["Company name","Temp"] Perform find go to layout ["Main"]

I want to be able to copy text from web pages and paste them into fields in a database. When I do that the formatting info gets pasted too. I've tried to write a script to strip out the formatting info using the Paste without style script step, but I can't make it work. Any suggestions?

I am updating a LMS (Learning Managment System) I developed for my school. In the student note/comment field I would like to color code a entry ie; red for advirse, black for a normal and green for positve comments. the format for entries is MM/DD/YY comment and initials. 9/24/01 Shaffer sleeps in class JOS. (red) 9/24/01 Jones completed Mod 12 with a 75 JOS. (black) 9/24/01 Smith completed the course with a 96 avg. JOS (green) I am setting up the LMS for FM Server 5.5, I will have about 121 Instructors using the LMS and 20 Adminstrative personel. Thanks John Shaffer

Hello: Does some form exist of programming the FM Mobile (Plug-Ins) inside a script to change the synchronization and records options of the dialogue? Thank you for your help.

I am using FileMaker 5.5. I have a script that has several 'Import Records [..]' commands one after the other with different queries. I would like to run these imports without dialogs. Problem: Properties, for example field mapping and the sql statement, of the first import command seems to overtake the others. I cannot have each of the import commands to have their own query setting. What is going on? What am I doing wrong? Thanks Erol

This is driving me crazy. I have button in a portal that is supposed to set fields in a related database. I use the relationship "open cases relationship" for the portal. The relationship matches "name" in this database with "namestatuscombo" in the related record. The button is supposed to change namestatuscombo and two other fields in the related database. "namestatuscombo", in the related record, starts out containing the person's name. My script reads Set Field ["open cases relationship::namestatuscombo",""closed""] Set Field ["open cases relationship::completed",""yes""] Set Field ["open cases relationship::date completed", "Today"] By changing nam…

I am trying to allow an office staff to enter codes throughout the day, and run a script at the end of the day that prints out letters to be sent. For example, in the field "code" the number "1" would print out a letter confirming an appointment date and time for a patient. The number "2" might print a letter to a patient that missed an appointment. The script I wrote is as follows. find all enter find mode insert text (specify "code" field)>0 Perform find loop if "code = "1"" go to layout "confirm appointment" Print (no dialogue) Else if "code = "2"" go to layout "missed appointment" Print (no dialogue) Go to record Next end loop end if …

I am building an FM database that runs behind Lasso and I need to set records that have been created by clients to automatically expire on a date 30 days from the creation date. I must be able to protect records that should not be deleted, so I assume I must begin with a find that searches the setting for a specific field. How should I set up a script to analyse the date status and delete the record when its time is up? What que will start the script in that the file will be running at all times remotely?

Dear FM-lovers, Is there any way to make a script run when the user clicks on the filemaker find button when he's in find mode. I just want the status area to close. Thankyou for reading the message and eventually answering this question. I know I can make my own buttons but I was just wondering as this may come in handy. [ October 03, 2001: Message edited by: michele ]

Is there a way to force Filemaker to open files from a FM Server? I have a small db setup that has nothing but a autoexec script in it to automatically open several db's. Since I have switched to Windows XP on some workstations, FileMaker doesn't rmember to open them from the host server. On previous versions of Windows, The script would prompt for the file loacation the first time, but after that it would open without dialog.

I have a script: Case (Stu_CompYear - status ( currentdate ) <= 0, "Graduate", Stu_CompYear - status ( currentdate ) <= 365, "12", Stu_CompYear - status ( currentdate ) <= 2*365, "11", Stu_CompYear - status ( currentdate ) <= 3*365, "10", "9") that converts a 4-digit graduation year into a grade value, i.e. 2003 yields 11, that I want to recalculate on September 30 of each year, so that in 2003 a graduation year of 2003 should become 12. So far, the calculation works for new records, but it doesn't update the existing records. Is there a way to force my database to recalculate values for all records?

Hi! I would like to create an application to visualize drawings related to my items in FM. Does anybody know how to carry it out? Must I program Windows API? Best regards.

Hello, I have a client who produces yellow pages. The art department will create pdfs from their XPress docs with the name that matches a filemaker code of: client phone - heading code - ad size code. All the pdfs will be in one folder. Is there a way to use the code in filemaker to automatically import the pdf so the user does not have use the dialog box to identify the file? i.e. utilize a path name for that record to auto pick up the correct pdf Thanks

Are there other ways to initiate scripts other than buttons or opening or closing databases? My goal is to have a script run automatically at the same time of day - everyday without a user triggering a script with a button. The database file is open 24hrs, therefore I cannot use the preferences to runa script when a file is open or closed. Any suggestions are welcome. Thanks, Steve

I can't get the "send mail" function to work with FM 5.5. It was working this morning, now it's not. I'm using it with Outlook Express 5.02. It seems to think for a long time, bring Outlook to the front, then think some more and stop. Mail never gets into the Outgoing box.

Problem: create a comparison of the value in the same field appearing in 2 records. For example: Each record containd the specifications of different cars. The user finds two machines to compare. I would like to show the specific data for each model (easy) but also to show the difference (+ or -) that exists between, say, the fields for weight, power, length and width. I can think of clumbsy ways of achieving the comparison; is the an elegant method. Thanks in advance. Chris

Hi, I've got a question: Will the extensive use of subscripts within a single database (not the use of external sub-scripts) affect the performance of scripts as a whole? Or in another way: Will splitting a single script into let's say 10 subscripts degrade the performace of the script, compared to leaving the script the way it is... Greetingz, Dodge

This first problem is that you are using multiple fields (FA1-15) where you should be using records in another file. You need a related file (Appointments) to store information on each appointment. If you did this, it would be EASY to display the most recent appointment by having a relatioship shorted by date and displaying the information from Appointments in a single row portal. Using multiple fields or repeating fields to store this type of data makes it difficult to search or sort the data. If your two files are Patients and Appointments, create a field in Patients: Record Number (number, auto enter serial number, can't modify) Create fields in Appointments: Pati…

hi can you help? how do i get FM to do this. Sequentially carry out Find requests using the same field (call it field A). So the found set from the first Find operation is used for a second Find operation. Both Find operations use field A. For example, if I save a series of Find commands using Scriptmaker and run them sequentially using Scriptmaker Perform script, I cannot achieve the desired effect. help if you can. it sounds simple. really it's equivalent to a db filter as you get in dear old MS Works for Mac. tom

My Print Script has some fields which are set prior to completion of the Print script after which they are reset.The Problem is if the Print Job fails then the Flags remain set and effects the functioning of the remaining record.How do I provide a handle if the print job crashes??Hope you might have got at what I am trying to get at Thank You

I have built a series of databases that work together to make one complete solution. The application has 3 different contact rolodexes as well as tape database. I want to place a button in each db that when pressed will open up the specified db. I have tried several of the provided button actions and none seem to cover this. Anybody know how to accomplish this?

Thanks for the prompt reply, BobWeaver. But I have set it up like this, and it will still not work correctly. It will omit the records as desired by the if functions, so that part works fine i think. But, it will only set the fields properly on the FIRST record. Specifically, heres the results I get: Records are omitted as desired. Out of a set of 5 records, three meet the criteria. The FIRST record in the filtered set will have the text and date desired in the correct fields, as instructed by the If functions. The remaining two records do not have the text or date entered, as if the Set Field and Current Date functions did not work. How should I fix this? I hope this…

I've been experimenting with the GoToRecord/Request/Page(by field value) script step. I'm assuming that you can set a global field with the ID number of a particular record and then return the user to that record at some later time. I have not been able to get this script step to work in this fashion however. Do you have any suggestions? Mike Fogarty

Three questions: 1. Is there a way to make a script that forces the user to print the current record and not the records being browsed? 2. Is there a script that forces the user to print the records being browsed and not just the current record? My users always forget to go the the printing setup screen to do this, and I want to make it easier for them. 3. Is there a way to make a find script that does not stop and ask the user to press continue once in find mode. I know I'm missing a step in my find script and there has to be a way to do this! New to scripting! Thanks

Hi I've created a database that has all of our users information. The information is collected from a text file that i import into FileMaker. Is it it possible to create a script on a shedule so it does it every month on a selected date, so i dont have to keep importing data manually. If its not possible to have a scheduled script could i just do it from a script button? Cheers Carlos

I am sure this has been discussed, I did a search and no good results- Question- I want to insert text into a field, but instead of at the end, i want it at the beginning. I know I can do this with a new calculation or container field. It just seems to me that it would be an easy thing to do. Can i capture keystrokes, because I would then just select all in the field, and 'left arrow' to the biginning. Thank in advance for replies! Larry

I need to print images via my filemaker database they are approx 2MB JPEG files We backup on 650MB CDs. My file is now 1GB and growing fast. I believe 2GBs is a Max and anyway I can no longer backup to CD. I have a script for inserting my images. The option Store only as a reference to the file is my solution. Can I set this as a default to avoid user from forgeting to select it? Stuart

I'm not sure this is a scripting question, but at this point I suspect that I will need to do this with some sort of script. What I am attempting is to use 2 databases to keep a running tally of sorts to provide updated information and predictions based on past information that is updated everytime a new record is cradted. Specifically, I would like to be able to crate a new record in a second database when I click a button in the first databse. This I am pretty sure will require one script. I then have relational data from this first database record entered in the new record of the second database, add additional data to the new record in the 2nd database, and wit…

Duplicate function duplicates all the field,but I want only duplicate some fields when they press the duplicate function.Do I have to copy & paste those fields into a new record or is there some other way of doing it.? Thank You

I am working with FM 4.0. I have 3 main databases that are interrelated. Customers, Inventory, and Orders. Each database has some data that the other database does not contain. I've been trying to make the system more efficient since I started this job. What I need to do: (I am using a field that has data in all 3 databases as the defining relationship comparison. It is the ISBN number of the inventory) I want the script to tell me which ISBNs are in stock but that the customer has not already recieved. Then I will use this list to define types of items within those ISBNs to determine the shipment. I need a script to: Perform a find in Inventory then compar…

I want to be able to take a found set and within that set sum a number located within a field of all the record of that set. Is this possible? Do I need to set up a script to do this?null

OK, so I have a script that runs perfectly on FMPro 4, but the deal is, I need to run it from the Web. Specificly, I want to have a button on my web page that performs the script in FM. Is it possible to do this? I've tried to do it by specifying a field button and connecting it through Claris Homepage, but it doesn`t work. How can I do this using Claris Homepage or another way. Thanks!

Is it possible to both "specify" a button and attach a script to it? I have around 30 layouts that users can browse through using buttons. For these buttons I have just used the "Specify Button" tool to cater each button to a specific layout. I also would like to custom sort the data before the user views it in some of the layouts. For this I have created a sort script. The problem is that I do not want to have to create 30 scripts, one for each different layout to sort the data then go to the specified layout. The sort is the same in all cases, but the destination layout is not. Through the "Specify Button" tool can I attach a script and tell it what layout to go to?

I have set up a custom layout for find requests in my database. I have had requests from users who, instead of having to click on the "find it" button that I have created, they would just like to type the enter key. How do I have a script that is always looking for an enter key press while on my find layout? Thanks

Hi, Essentially I want to grab all the e-mail addresses from the clients in my database, and then add a ; between each line, and then use that to send a mass mail. example user1 has clientEmail set to [email protected] user2 has clientEmail set to [email protected] user3 has clientEmail set to [email protected] now, i want to grab all those records, and add a ; between then, so i end up with: [email protected] ; [email protected] ; [email protected] ; then I can simply use that in the e-mail script entry in filemaker to output it to an outlook mail. sounds easy, ish whats your thoughts? Regards, Doobeh.

I am trying to create a text field which will eventually be used for xml export. I need to be able to create a field containing a string like: code: <MOVIE ID="M1" Seq="1" RelPath=".transiston testingproduct002.avi" AbsPath="E:transiston testingproduct002.avi" Description="" LogItem="False" Delay="0" OverrideShowDelay="False" SizeAndPos="" Overpaint="False" AutoReload="True" EraseWhenDone="False" ForceUnload="False" LoopMovie="False"/> But the quote marks MUST be intact as above. Is their an escape sequence similar to the " or /" used in many other programming languages? Cheers all, Joel [ September 19, 2001: Message edited by: Joel Lewis ]

Hi, People navigate through my database with a seperate database that acts as a menu. This means that when you start this menu/navigation panel the database makes a new record (so different users can stick to their own menu during the time they work with the database without working on eachothers menu), in other words every user gets a new record This menu also performs searches so you have one text field and a few global fields. Here's the trouble: even though the database creates a new record when you open it (through an opening script) we still sometimes get the 'somebody's modifying this record' message . I just can't understand how this can be?: The 'menu' data…

In binding my file with a runtime solution, I need to have a script to quit. I used a "status of message" function that reads "Are you sure you want to quit?" and gives the choices OK and Cancel. Everything works fine when OK is chosen. But when Cancle is selected, the file quits anyway. Can anyone help me better understand the status function that will make my script work? Allegheny

How many operators and characters does FM Pro 5 allow in one calculation? I know that GoldMine only allowed 255 characters. For example, can I go like this?: If [(Status(CurrentDate) >= (Letters P Date1 or Letters P Date1.1) + 4) and (Campaign1 or Campaign4 = "Auto") and (Letters1 or Letters1.1 = "Intro")] Im hoping this says "If today is greater than or equal to the date in field "Letters P Date1" or the date in field "Letters P Date1.1" plus four days; AND the fields "Campaign1" or "Campaign4" contain the word "Auto"; AND the fields "Letters1" or "Letters1.1" contain the words "Intro". If it doen't meet ALL these criteria, I want it to omit the record, but I h…

A few times a day some clients (FMP5.0 / WIN2000) start rounding up calculated and looked up values. I don't know what causes this problem. All figures behind the comma (decimals) turn to 0. In our situation in Holland we use 2,20371 as factor to calculate from Guilder to Euro. This becomes 2,0. Shutting down FMP on this local machine and restarting it solves this annoying problem. We have to recalculate these records to get them right. They are saved on the server in the wrong way, with this failure. This is a local problem on most machines. We all have WIN2000 clients, FMP5.0 latest update in a WIN2000 server / FMP5.0 server environment. This problem turned up when…

Hello, I want to write a script that "zooms" a text field: It should just copy the fieldname and fieldcontents of any "clicked" textfield (that means the field is defined as a button)in my database to some global fields and switch to a layout which displays that globals. My problem is that the "Fieldname" and "fieldcontents" functions within FMPro only work with the fields where the cursor is in, if You just click on a field which is defined as a button a n d is defined as "no input from the user", nothing will work. The challenge for this is that sometimes the field in the layout is too small: You can

Hello, I have to call a windows programs called "wget.exe" from within filemaker. The program ends by saving its result in a little file that I import in a field in FM. In principle, no problem. However, in order to let wget do its job, i have included a "pause script for 1 sec" command, so that wget has time and FM imports correctly. I realise now that the speed of wget is different from PC to PC (some running Win98, some Win2000, some are slower, some are faster) which makes the "pause script" command set to a constant time senseless. Now the questions: * To be independent of the speed/systems of the various computers I would like to let filemaker check whether or …

I have a Tests.fp5 file that contains multiple test results for multiple students across multiple grades. I have a Grade field containing the student's grade in school (K-5) when Test X was taken. With this info I need to create a Kindergarten_ID, FirstGrade_ID, SecondGrade_ID, etc. so that I can use the data in a variety of portals. I wrote the following script for each grade, then wrote a script which performs each of the six scripts to create the IDs all at once. (I know I could have written one script, but I don't think that would solve my problem.) Go to Record/Request/Page [First] Loop If["Students::Grade="5""] SetField["FifthGrade_ID","Students:…

Hi there, I am wondering if there is a scipt step to create a clone of files that live on the server, without closing the file on the server first? Does anyone use such technique already? Thanks

quote: Originally posted by kattatonic: I'm pretty sure I saw a post about this last year but I can't find it. Sorry for the duplication. Is there anyway to have a script run upon exit of a field? Or entry even? Thanks, Kay The only way to simulate 'OnLostFocus' event is to buy the Events plug in (formerly Script Scheduler) at Waves in Motion: visit their site at the www.wmotion.com. If i remember correctly it costs $ 89 (single user standard version). Regards

Looking for a way to conduct a find within a found set - presumably using a script - and not disturbing the found set the user is working with. I need to do this as there would be various ways that the found set was established, sometimes via various finds and sometimes by omitting records. Any ideas how this can be done?

Hi You guys have been very helpful to me in the past, so I will ask another daft question! ;-) I'm using: <form action="fmpro" method="post"> ... <input type="submit" value="Search"> </form> to perform a search through my web-based database (running on a PC based server). Instead of just the busy mouse icon, I'd also like to display an animated .gif to pretty things up a bit (a la expedia) - is there a way of interrupting the messaging to the filemaker dbase so that I can change the display before filemaker starts the search? Thanks -Andrew [ September 14, 2001: Message edited by: AndrewB ]

Ok, Ive made a script for a procedure described in the post, "CHECKING FIELD FOR ENTRY." I couldn't do it the way vaughan had showed me (sorry). So here is what I made: Perform Find [Restore find requests] Loop If [is Empty (Campaign1)] Insert Text [select, "Campaign1","Auto"] Insert Current Date [select, "Campaign1 Date"] Insert Text [select, "Letters1","Intro"] Insert Current Date [select, "Letters P Date1"] Else If [isEmpty (Campaign4)] Insert Text [select, "Campaign2","Auto"] Insert Current Date [select, "Campaign2 Date"] Insert Text [s…

Hi people, More questions I'm afraid... Is there a possibility that a script that calls an external script which has a create new record step create a record in another database? I'm asking this because I am trying to squash a bug in my script(s) where I am trying to create a new record in a file but ends up creating a record in a different file? Anyone heared of any problems like this? Just incase that I'm looking too hard for a solution where there is "no" solution with the script I've already made. Thank you. If needed, I'll post my script(s) to show what I'm trying to do in detail and to show you where it's going wrong. Steve Griff

if it does my life just got a whole lot easier. this new script step works great, making the FM auto-increment serial numbers finally useable, but i don't know if it will work once we bind under developer 5.0. we would happily bind under developer 5.5 if we could! why is it that we can only get 5.5 client and server but we have to bind under 5.0 ? thanks, jodin

I recently updated to 4.0v3 and scripts that I had written using the 'save a copy as' script step now fail in the Windows environment (MAC works ok). I get an error code of 800 and the message '....copy could not be created on this disk. .....'. I can create a copy directly using 'file/save a copy as' but not using the script I deleted and reentered the script step and it still fails. Any insight? TIA

I am very new to Filemaker. I have a master name file which includes a key field "SSN" I also have several other databases that I want to link by "SSN". I want to display the master name file layout, press a button to select another layout in another database that creates a new record and places the "SSN" in the new record as the key field.

First of all, I want to thank everyone who has helped me in learning the various aspects of FM Pro. I was watching this tutorial CD-ROM for FM Pro 3.0, and the instructor was making a script that included a find request. In the script he used the "Perform Find" function. Prior to this, he was on the layout that had the fields he wanted to perform the find across, and said that when using the "perform find" the Restore command restores that last find criteria on that layout when the script is actuated. If someone performs a manual find on that layout after the creation of that script, does that disrupt the "Perform Find" in the script?? I hope my question makes sense.…

I have a solution developed in FM4.0 on a MAC. There is no indication of a problem on the MAC side. In Win98, under FM4.0, the 'Import Records' script step fails and damages the file (I get the Windows message 'If this problem persists, contact the vendor'). 'Recover' does not fix the problem. I suspect there is some other damage to the file. The import records script step is used to update one version of the solution to another. It is a technique I have used successfully for some 30 previous version updates of this solution and it has allowed me to 'skip' versions when updating a data base. The import records specs are set up to import all fields from a backup of the c…

Thanks for taking the time to read this post. I am making another script that enters "certain text" into either field1 or field2, after a certain layout prints. However, field1 may already have text in it. The text already there could be anything. So, I would like the script to first check if field1 has text. If no text is found in field1, then enter "certain text". If there is text already, go to field2 and enter "certain text." If field2 already has text in it, then I would like the script to omit these records, give a message that records have been omitted,then show these omitted records on a layout of choice. As always, all your guys' help is appreciated!

Just a short note to alert FORUM users that ClickWare has many free products available at its www.clickware.com site OR its www.clickworld.com site. Includes their latest "clickquery" product that helps write SQL. Check out the SQL plug-in and their classes too (these aren't free...just so ya know...)

Has anyone used FM to make his/her own receipts or invoices? That's what I'm trying to do. I am trying to get a unique serial number or folio number to appear on every new receipt. I did find the serial number feature but it was no help since it's tied to existing or new RECORDS and what I need is a script for a field that will return a NEW serial number for every INSTANCE a receipt or invoice is produced. Thanks for your help. Vic [email protected] null

Hi there! I have these two files Order and Order_Item database. A script is run in Order database to execute a script in Order_Item database that then does a couple of things. The problem is that the Order_Item database goes to the front of the desktop which is annoying to the user. (It moves in front of the Order_Database that the user is working on) Any idea on how to stop this behaviour? Any tips? Thanxs Steve Griff

I need a script to calculate a file depending on a number in a DB field. Here's a sample of what I have now. Is there a better way to calculate it? http://209.131.233.13/test.fp5 Thanks! Aaron Savka Thread FX

You can do this with the Events plug in (formerly Script Scheduler) by Waves in Motion: their site is www.wmotion.com. Regards.

I recall being emailed a press release a while back describing a plug-in which allows editing scripts without the slow and tedious process of pointing and clicking from the preset function list. Does it exist? Where can I get it?

How can I save a value (in scripts) so I can use it at another time. Now I'm doing this with a global field, but if I'm sharing the file with the other people it does not work on their computers. In other database programmes it was possible to declare a variable! Thanks Oscar

I would like to activate three different kiosk in the same HTML page. Or If It's possible . . . in a "File Maker menu page" How can I do ?

LiveOak: Ok. but do I want to print the classify in form direct SORT(no dialog), so that the user doesn't have to select a field of the database and to make it by means of buttons, can I make this?. Thanks.

Is it possible to insert a picture into a container field (using reference only) using another field as the path to the file through scripting? Thanks! Aaron Savka

Any Help would be highly appreciated Here is my question! I have 2 databases , which have fields called 1) Part# 2) Tracking# 3) Date 4) serial# I like to import Date and serial# to database1 on existing records from Database 2 only if part# and tracking# matches Database1 What should I write in script?

I need to calculate an initial commission fee, then a monthly residual fee for 2 years (as long as the referred account stays open for the 2 years). Can anyone give me a clue as to how to begin? Much appreciated....

I want to do the same thing to every record, and that is to create a related child file with certain fields already populated. The main file is PROJECTS. The related file is ELEMENTS; they are deliverables for each project. I want to create several standard elements for each project record (e.g. Administration, Production Management). Then... ELEMENTS has a related file called TASKS that are all the tasks required to accomplish an element. So I will do likewise to all elements (create standard tasks) because there are several standard tasks that must be done for each element. My brain has gotten as far as seeing I should probably write a one-time script that uses a loo…

I need to make a calculation that will calculate in a field every time the database is opened. The calculation will calculate Todays Date - Creation Date and generate a number of days elapsed result. I know doing a calculation will make the database open slowly because it has to calculate every record upon opening, but how else can you age the records based upon the above parameters. I don't want to have to press a script button every day. Thanks for your help!

Hi all, Does anybody know how to call a FileMaker Script from VB or C++ program / activeX control? I am trying to do it, and I am getting error: *Runtime error -2147417851 (80010105) *Method 'DoFMScript' of object 'IFMIDocument' failed Can anybody help me? - Hrishi

I am very new to scripting and I tried to get this question answered before, but I don't think I worded it right. Here goes, I have 6 text fields that a user enters data into. The user then pushes a button and this sets off a script that takes parts of this data and concatenates a new unique name that is then entered into another field. What I am trying to do is to take this new unique field name and have it compared to the unique field name in other records in the database. Im basically looking for duplicates so if there is a duplicate, I want the user to be immediately warned of this and prevented from using this already existing name. I know I can have some form of val…

I have a db: Employment Oppurtinities, that allows a user to create a Job Order and then view eligible candidates (Full-time, Part-time, Both) in a portal. I want to assign a unique identifier (JobOrderCode) to each order that I can in turn assign to candidates meeting that order's criteria. To keep it simple, I want to combine the order date and the record number into a text value. I tried this calculation: JobOrderCode NumToText(Month(Order Date)) + NumToText(Day(Order Date)) + NumToText (Year (Order Date)) + (@@) where (@@) should be the record number (i.e. 5) thinking that September 4, 2001 (record 5) would become 9420015 However, the calculation does not accept…

Has anyone had a problem with scripts following upgrade to 5.5? I manage a property DB (20000+ entries in masterfile + 3 primary related files) and am finding an entry dup. script only completes part of its instructions for about 3-5% of use. This seems to mostly occurs if run soon after waking (PBook G3 500 256/10G,OS 9.1)but has also happened ramdomly. Basically the script should do the following (button 1) - isolate required record ,Dup rec,return to original and tag as archive, find related Imp file set,calls external scripts to duplicate that set.Then (button 2) updates match field code suffix on the copy and Imp file copy set . This allows for a valuation hi…

i have records that have fields: name, location, etc. and computer1, computer2, computer3 -under each computer box are 3 more fields: serial1, serial2, serial3. what i want to do is click on a button (script) that will return computer1 with serial1 always... and so on for computer2... and 3, etc. further what i REALLY want is for all 3 computers to come back with their serial numbers. ultimately i will search my database for either a person's name to see what computer(s) they have or i will search by serial number(s) and return the person and all of their computer(s). can someone PLEASE tell me how to do this! Thank you in advance.

I don't know if this is a possible script solution or if a plug-in needs to be acquired.... I am trying to have filemaker draw a picture based on some user input. For example, I would like filemaker to draw a rough layout of artwork on a page based on each piece size and overall page size - if the user enters 3-up of 1 piece of art, I would like filemaker to go to a layout or insert a picture of a rectangle (overall page) with 3 smaller shapes (artwork) inside.... Is this possible using filemaker...?

I have an existing DB that was developed on the Mac but now it is being used on a PC. I am trying to create a script that will allow the users to create a PDF file using Adobe Acrobat PDF Writer as the printer. I also have an identical script that prints directly to a network printer. I can not get the printer to save with the script. I want one script to print to the printer and one to print to PDF Writer. I can not get it to work. Each script will only print to the last "printer" used. Any ideas?

Hey, since you guys are pretty savvy with this FM Pro stuff, I need some advice: I don't know if I've explained this before, but I am making a marketing database which our insurance business can use to send out a series of letters based on a certain strategy. What happens is this: The prospects are filtered based on certain criteria (e.g. having homeowner's or auto policies, etc.) and a series of letters go out. First, an intro letter, then in increments of four days apart, a follow-up and second follow-up letter go out, followed by a phone call by the agent. And since I will not be the only one to use this program, it must be very simple to use (insurance agents are no…

I need a particular layout to only show records that match a certain criteria. Is there a way to run a script whenever a layout is viewed? That would do the trick. I am new to FM but I am proficient in SQL and very comfortable with writing various types of code if that helps my options at all. Any suggestions? Thanks a bunch. -wald

Hello, Is it possible to open a specific database file based on a users entry in a popup list. i.e. I have a list of people: Barry, Sandy, Gary, each has a seperate database. I have set up a main page with a Popup list of their names once they choose their name I would like to switch them to another database ie. barry.fp5 Thanks

I have a database that holds records about what desktop printers a user is logged into. This database and a few others are hosted by a FileMaker Pro 5.5 Server running on MacOS X. I have to import periodically new reports into this Desktop Printer database

Here's the deal: I had to create a FileMaker app that provided an audit trail--that is, where every change, including its substance, time, date and connected person, is logged in an audit file. So I've done this with a very elaborate set of scripts and layouts. Basically, people create new records, enter what they need to enter and then "commit" the record, so that no further changes can be made without taking them through the audit log scripts. Now, the users want to have more than one record "open" at a time. (Give them an inch...) So my question is, has anyone done something like this and how did you do it? Is there a way to make FileMaker capable of being opened in …

Here's what I have done in the past to count the number of lines in a field as formatted by filemaker: 1. Set up a special "Test" layout that is completely blank except as follows. 2. Copy the text field in question from your original layout and paste it into this new layout. That way, you know that the field is exactly the same width and the font, style and font size are identical to the original field on the original layout. 3. Create a really big header that is the size of your printed page less one line. If you have the "show page breaks" option selected, you will see that you get a whole bunch of page breaks spaced one line apart throughout your body part of the…

Hi there, In my database of contacts, each 'person' has a dateRemind field and a remindNote field. The idea is that you enter the date you want to be reminded of the remindNote. So I need help creating a script that launches upon filemaker being opened, then searches all the dateRemind fields for ones that match the current date, and upon finding any puts up a little message for the user showing the remindNote. It sounds easy in my head, but I'm a newcomer to filemaker to putting it to practise is a bit harder, any help would be most gratefully recieved I've been trying to get it working but I just am at the bottom of a learning curve and im not sure how to climb it …

is there any way to write a script in Fm 4.1, that, on submission of a new record would check if there is already a record associated with that person and that document number but doesn't contain a review, and if so, to overwrite it and if not, create a new one?

Looking for a way to conduct a find within a found set - presumably using a script - and not disturbing the found set the user is working with. I need to do this as there would be various ways that the found set was established, sometimes via various finds and sometimes by omitting records. Any ideas how this can be done?

I have put together a script that will check the user to see if he/she has the appropriate permission to a particular layout. The script is great with the one exception that IT DOES NOT WORK. Am I on the right track...? If["PatternCount(Status(CurrentUser), "Joe")"] Show Message ["You do not have the appropriate permissions to access this layout."] Else Go to Layout [secret Layout] End If Why does it not work?

First; thanks to Carey Beall and JPaul for your help in getting me up and running. The calculated grade field works great, but I'm still having trouble with my scripting. Are there any books/manuals out there that cover scripting solutions in depth? I'm still trying to create a script that will open and search the master database and then import the found set into the secondary database issuing the script. Thanks.

I have a database that holds records of seat reservations for theatre performances. After a reservation is made, seat names/numbers are assigned for each person. For example, John Doe requests a reservation on Aug. 26th for four seats. He is assigned seats A01-A04. A01 is entered into a field called "seat01" A02 is entered into "seat02" and so on. There are 12 possible seat fields per reservation. It would be useful for me at a later date to find out who has been assigned a particular seat. Since the seat name could be in any one of the twelve (seat01-seat12) fields, how can I write a script that would search all twelve fields of my found record set and find t…

i was trying to do a script that searches for text strings that contain certain character. for example if i want to find if a field contains an email address how can i do the comparison: [if f3 "contains" @] how can i put this into a script... any help will be appreciated..

I have two protals Portal 1 and portal 2 linked to a file. In portal 1 I have the values a, b, c, d and in portal 2 I have the values 1, 2, 3, 4 I need to combine these portals in another file so that I will have a 1, b 1, c 1, d 1, a 2, b 2, c 2, d 2,..... I cannot hink of a way to both sources of data for this. In the main display I have a job number which allows me to link the 2 files. Can anyone help my brain is now fried with attempts. Simon

I am new to Filemaker Pro 5.5. But, not totally new to databases. What I am looking for is a way to shorten the process of finishing a record and going to a new record. It would help me if I could get the best way to lessen the response needed to do this. I know about command-n but, I would like a way to just use a single key and not a key combination to attain this. Now I have some idea of how the scripts work but, have never really tried it before. Since my database is extremely large and requires a lot of typing to get things entered each day, I am trying to attain a more automateed way of doing things. Is there a way to get where I am headed or is the script pr…

Hi All! I asked this question in the "Left Brain" forum, but I thought it wouldn't hurt to ask here. I am making a marketing program that selects groups of people to send them insurance marketing letters. I have created a script to define the filter criteria (e.g. homeowner's policy, auto policy, smoker, age,etc), then I print the letters for them. However, in the marketing strategy I am using, I must send out four letters. Is there a way that, after each letter prints for a person, to mark that letter as "Sent Out", so I know where the person is in the marketing strategy? Does that make sense?? Any help would be greatly appreciated!

I want to prevent some items from prining on a layout based on some criterias. Is there any way to do that.It involves text and also data from the database.I want to write a script for it,is it possible? Thanks

We use FM to create our estimates and some people want us to e-mail it to them - I have used the Mail to" method and pasting the page as a jpg - but some people can not see or read it.... is there a better way? can you make a PDF - or something thanks adam [email protected]

Im a beginner when it comes to scripting so please bear with me. I am trying to validate a field for uniqueness, but I want to do it using a script. I know you can validate fields using the options under Define Fields. What I currently have is a button that sets off a script which copies text and numbers from various fields and paste them into another regular field to create a unique name. My problem is that I need to verify that this name is not used in other records before the rest of the script can proceed. If I validate it using using Define Fields options the current script halts and allows the user to enter jibberish which is then accepted as a valid name (because i…

Hi people, another question... I want to use a checkbox value as a basis for a relationship between two files (it's actually the same file). The Value List for the checkbox only has one value "Order Placed". I want to know, how do I set up my field as a calculation so it checks my Order Placed checkbox and I can tell my portal to only show records where the Order Placed checkbox hasn't been placed. I'm looking for the Calculation Value for the relationship It would probably be along the lines of Order_Placed_Calc = SOMETHING BY HERE Any suggestions? Thanxs Steve Griff