Script Workspace and Script Triggers

I have a master script which runs many smaller scripts both in the main db and other related dbs. There is 1 particular script that takes a very long time so I have built in a numeric progress meter which works fine, but it is setup in the related db and I can't seem to get the master script to change to the related db before running this script... So I never see it unless I go to the windows menu and manually change files. Any ideas?

I have ongoing trouble with "Print Setup" in scripts. We have 2 printers on the network, a colour bubblejet that we use for Window card photos and a laser for reports. When I setup a script to print a picture on the bubblejet (replace current print setup after exiting script) this doesn't seem to be "remembered" by other users. (The "server" has the bubble jet as its default printer and the other PC's on the network the laser so that when they do a photo it goes to the laser instead. ie in simple terms it appears the the print setup script step remembers the setup but not the printer and defaults to their default printer not the printer in the script??? ditto, we …

I'm trying to get text, date, and time fields into a text single. Everything works fine, but I want time displayed as "hh:mm AM/PM", it comes out in 24 hour notation w/o AM or PM. Does anyone know how to get 12 hour notation? -Heather

I have a field that generates an e-mail based from various fields and a total. Unfortunatly, when it calcs out the total, it disregards my formatting for the dollar, and will truncate any zero off the end. I.E. $4.50 comes out as $4.5. Usually with the fields i can set the number of places after the decimal point to show, but how do i get it to do that in a body of text? Thanks. -j

We are using FileMaker Server 5.5 in conjuction with FileMaker 5.5 clients. To store specific user- and location data we had the idea of storing a local database. However, when we try to open this database the server cannot find it and keeps looking for a database file with that name on the server. Does any1 has an idea if there's a way to work around this ? Thank you very much !

Hi ... Hope someone can help . here is a discription of what we are doing! We are an insurance company that handles medical malpractice. We have a filemaker database with over 4000 doctors in it.. We frequently have to goto the department of health website to check to see if a particular doctor has had any claims filed against them .. This information is only available on the web.. What we currently do now is [1] print out the doctors information from filemaker.. [2] goto the department of health website-- enter in the doctors name and licence number. Hit the (SUBMIT) button. If the doctor has had a claim against them it comes up in our browser. Us…

Does anyone has experience in synchronising filemaker pro with fasttrack schedule? Cause i tried and I still have some problems,... Thanks in advance

Can I display a custom message, say with a value from a field in a Message Step Script Item? For Example, If "X" = 1, then SHOW Message "_________ & Field (field name, field value etc)" Can this be merged in somehow? One More question: Can a script be initiated on Field Exit/Entry? I thought this was an available feature of FMP 5, but I can't seem to find it. Thanks, Chris.

I am having a problem with a script that I am writing as a start-up for some databases. What I am trying to do is make an "Opener" file that will sit on the users desktop and when they double click on it it will 1. ask for the password (same as IEP), then 2. open the IEP databases and then 3. close itself. The script would be set to run at Startup for the DB. Here is the script : If["Status (17)"] Status(CurrentModifierKey) Halt Script End If Allow User Abort [Off] Set Error Capture [On] Open ["Start.fp5 (*)"] "*"=network Set Field ["LastErrorGlobal","Status(0)"] Status(CurrentError) If ["LastErrorGlobal <>0"] "<>" is not eq…

Recently I downloaded a program called "Computer Admin Lite" and one of the features that it had was the ability to switch between different groups of layouts within the same file. The program allowed the user to see 4 different layouts in most of the groups and 2 layouts in the last group. You could switch between the different groups through an icon and see different layout groups. Could someone please tell how to do this? If needed I can give a better description of what I am talking about in an email. I am new to this program and I purchased it because of the "Computer Admin Lite" program that I downloaded. It seemed to do almost exactly what I wanted to do, bu…

I run a script, that automate one of my daily processes. It executes a find, and perform something if there is a found set, or does not perform anything if nothing is found. The problem arise when no records are found. First, 9i get a message box to notify me 1) is there a way to bypass this message The only way i found to count how many records were found was to execute a loop through the found set, and add 1 to a global field for each record going through the loop. However, if i find 0 records, the loop will still run 1 time and set my global field to 1. 2) any way i can use a function like foundCount, or check how many results were found? here are my scr…

I have created a time billing db with an auto create time start and an auto create modification time. How do I script in order to total the time taken between the 2 values and have that as an auto field when the modification field is populated.

In just about every product, there are tips, tricks and "QUIRKS" -- the stuff that isn't in the manual and one only discovers it through trial and error or because someone clued you in on the secret handshake. For example in one DOS RDBMS application, you were never to define a field starting in row 1, column 1 -- It would do srewey things to the application (not in manual). Another: In the same table, if you set two fields to unique, you didn't end up with two unique fields but a concatenation of the two defined the uniqueness (not in manual). If you could offer to me, an FMP newbie, FMP's quirks or hidden traps that one ought to stay away from, I'd b…

I'm rather new - Looking for a way to total the number of field responses in an exported report. How many times did the user answer yes to a question or how many users choose "books" from a drop down box.

I get dates in this format Mar-29-02, FM wants them in a // format. What's the easiest way to do this. It doesn't matter if the 0 is preceeding the number except for the year. thanks. [ March 29, 2002, 03:54 PM: Message edited by: nightdesigns ]

What would be the easiest way to limit a field to 45 characters? I would prefer something that comes up as soon as they left that field alerting them if it's too long. Thanks -j [ March 29, 2002, 08:53 AM: Message edited by: nightdesigns ]

I need to send a 'request' to a URL but I don't want to loose focus from FMPro. Everything I have tried on Mac and PC takes me off to the Browser! I don't want to go off to the browser but I want the hit to the URL to be made. The request causes a field to be updated on my webserver and allows basic comms between the FMPro database and the web server. Any ideas?

Hello Is it possible initiate a script in a parent data that in turn executes a script in a child data base or do I have to navigate to the child data base first and then initiate it there? I haven't figured out how to code "External scripts" that I see mentioned from time to time. Do they require plug-ins? Many thanks

I was about to embark on an attendance (presence at school) database with repeating fields until I saw the discussions going on about how taking it relational is the way to go. I'm still thinking that a repeating field with 31 repetitions would handle it fairly simply and be able to total up tardies and absenses. Is it that bad to head down this road?

I have a text field which scrolls because of occasional length of content. I have a script which includes "Insert Current Date" and "Insert Current Time." I turned of the "Select Entire Contents" feature for this script. I made the text field act as a button, so when the text field is clicked (to either enter or edit the text) the current date is added. Here is the question...the current date is always added to the end of any existing text in the field. Is there any way to have it be added to the front of any existing text within the field? LR

I have a sub summary that was working well that all of a sudden got funky. It is a report that does a summary of my technicians hours and revenue. It normally would print on one page with a line for each tech showing what they produced for whatever period of time I did a find for. Now the subsummary puts each tech on a seperate page, so instead of getting everying on one sheet and on one screen in preview mode, I get 10 screens and 10 pages each with one line showing an individula tech. And, I don't think I changed anything to cause this.

Hello, I have a script that I use in my "Recieving" database that does a find in another database, "Inventory", and then adjusts the levels of inventory. The problem is that when I run this script, the finds are based off of another record in the " Receiving" database. It does finds based on 3 diffenrent fields, and then sets a field in the record that is found. Why is the script jumping to another record when it runs. There is no "Go To Record" steps involved. Thanks, Steven

I need to set up a script that will perform the following search. 1. find ALL aCTIVE DEALERS from THE [ CONTACTS ] file

I do a search that returns X records. I want to run the same script on everyone of those records. How can i do this without going through each one at a time.

Can you create a script to change the format of a field...ie background color/pattern? I want to be able to check a box and if its checked certain fields will become a different color. thanks!

So I'm new to FMP scripting, and am stumped. Here's my problem: we have a file that holds numerous fields of our products, and we print them out on brochures. The layout is fine if I want to print 4 or 6 items on a page, but when I want to print 5, then I have problems. Specifically, it works if there are 5 fields or less, but if there are 6 or more, all of them print on my brochure. I want to write some sort of script and/or calculation which can count the number of fields and only display the first 5. Have tried variations of If statements with (Count[item] > Int (5), Choose (from Logical functions), Status(CurrentLayoutCount, CurrentLayoutRecord, or CurrentLayo…

I was wondering as part of my attempt to make a real-time filemaker clock to count usage time...how do I view the real time ticking?? I can see the beginning and end of this concept script I have...but I have NO IDEA how to see it as it's counting. Here's my concept script: Set Field["counter", "0"] Loop Set Field["counter","counter+1"] Exit Loop If["counter=50"] End Loop Anyone have any suggestions???

My goal is to activate a script when I check a checkbox. How can I do this? Also, I have a value list that is built from values of a field in another file. Is there anyway to omit certain values from the list without deleting the record in the related file? Thanks!

HI all - I have a script that I want it to exit if the find does not find anything. Here is the basics of my script: Set Error Capture (on) Show All Records Go to Layout Enter Find (find criteria is entered here) Perform Find If (Status (currenterror) = 401 Exit Script Else Go to first record (starts loop) does loop stuff go to next record (exit after last) end loop end if exit script The script is just going into the loop if the script does not find any matches - it is not exiting. What am I missing. Also - just a side - can a Sort script step - make your loop go around in circles on the same record? Thanks fo…

I received such great help with a problem I posted earlier, I'd like to throw one more out there if I may. When we import records, the text is all "UPPER CASE". Can I tell FM to select a two fields [First_Name] and [Last_Name], then format all text within every record to be "Title Case"? Thanks in advance, Kip

Greetings, I am a rookie to FileMaker Pro and am just beginning to learn the basics. I am stuck on a problem I'm hoping someone can help with. We need to have a field which displays the CurrentRecordNumber. I was able to figure this out. However, when I import new records, FM starts the new records out at #1 again. So we end up with records having the same Record ID. Is there a way to fix this so every record has its own, unique Record ID? I'm assuming a script needs to be created? I know nothing about creating a script so please provide detailed info if this is the solution. Thank in advance, Kip

hi, i need a help with import script. let's say i have file A and file B , file A - got name , qty repeat of 3 field. file B - got name & qty field no repeat in file B , i made a import script in file B. IMPORT [ RESTORE, NO DIALOG, FILEA.FP5 ] HOW IMPORT WORK ? 1 record of file A , will produce maximum 3 records in file B. because file A's qty field got 3 repetition. if all 3 repetition field is filled , it will import each repetiton qty as one record in file B. so it will be 3 records in file B. the problem --- let's say i'm importing first record of file A with 3 repetiton qty field and let's say there are 4 records in file A. < i…

Hi, I'm hoping someone can give me a hand and show me how I can parse and email address into 2 fields. I need to get all the data before the "@" sign into the first field and everything after the "@" into the second. I can get this to work if it is a simple email address, but not if it is something like: name.lastname@ xyz.com or name_lastname @xyz.com or [email protected]. Any help is appreciated.

I am trying to write a script that will automatically enter the county name in the "County" Field, when I enter a zip code in the "zip code" field. There are about 460 or so zip codes, and 32 counties. I have tried to use Case, but after I get past a certain number (not exactly sure how many), I get an error that says "There are too many separators in this function", Any suggestions? Thank you!

Hello I recently removed quite a few unused fields, relationships, value lists and scripts from my data base and now it keeps crashing with the message "Filemaker Pro.e.exe. has generated errors. An error log is being generated". I have tried recover, compacting, and saving a clone but nothing works. I do have a back-up before I made the changes. Any suggestions would be appreciated. Thanks

I am trying to send an e-mail with Field A as the body of the e-mail. Field A is a calc field that has a <cr> after every 64th character. If I copy Field A then open a new e-mail and paste the formating holds up. If I have the "Send Mail" script in FM send mail and automatically insert Field A it ignores the <cr> after the 64th character. Is this a funky quirk of FM?

Is there a method where you can place a text box in the header the layout in "View as list" type format and as you type letters the cursor will go to the closest related record in the list below? If you have seen the Palm Desktop, I am talking about the way it deals with Contacts. Sorry if the wrong forum.

I have developed a Budget File and a Requisition File. I would like to link the two in such a way that (1) a message would pop up if someone is requesting supplies from a budget line item that does not have the funds to cover that purchase, or (2) better yet stop the user from continuing with the request, that is, prevent the new record of that request from being completed? This is to become one part of a larger purchase order program. Thanks.

I'm making progress in my problem, but i'm stuck with another hurdle. I'm trying to insert a picture into a container with the filename based off of a prior field. So here's what i have in script maker Go to Field ["Pci"] Insert Picture ["Field goes here"] Right now if i specify i can only pic one file. I want it to pull the record "pic1" and make it go to fileisherepic1.jpg Ideas?

I have a database that automatically opens a 2nd DB and the theory is that it would then run a script and shut the 2nd db down. But I have a password on the 2nd database. Is there a way of automatically entering the password? thanks in advance

I am developing a database which has multiple files, at least four of which need to be included in an export or a backup of a set of records that might be imported to another computer with the solution running on it. (the solution will not be networked at this point in time.) I have included the backup as part of the shutdown script, and have included the option to direct the saving of the files to disk, or wherever the user chooses as a destination as well as the naming of the files. I would like to streamline this operation so that the user does not have to deal with the Save window coming up repeatedly. I'm not sure if this is possible. Is there any other way that I ca…

Is it possible to error capture the error code for a unique field validation.? I know the code is 504 but I have had no luck in capturing the error. What I am trying to do is produce my own error messge for non unique field entries. I don't like the built in unique error message. It still allows the user to input a non unique entry, which I don't want. Can anyone help? Thanks

I use the following script, and it doesn't work, can anyone tell me why. I want to show records in a layout List view where the date is today and no later than a week in the future in date order. The Script Enter Browse Mode Sort Sort Order: StartDate Ascending Pickup Ascending Restore sort order, No Dialog Show All Records Goto Record/Request/Page First Loop If StartDate >= Today and StartDate < Today + 7 Omit Record End If Goto Record/Request/Page Next, Exit after last End Loop Show Omitted Goto Layout Due Out This is doing my head in, the programming to me looks fine, why can…

Hello, I have a tape library database that is a single file. I need to have a "Checkout" layout where the user can enter the tape barcode number in a global find field, press a button, and the find result be placed in a portal window on the same layout and the cursor back in the find field after the find. After entering 10 tapes and 10 "Button Finds" there should be 10 results in the portal window. Is this possible>

Good afternoon - I have a script that is running great - except that it never stops looping. I have a pause step in it - so I can stop it for testing, but I need your advice. Here is an outline of the script - Enter Browse goto Layout (List of Invoices) Preform SubScript (finds overdue invoices - in current db) goto First Record Loop Copy (Invoice #) Preform Subscript (creates finance charge - in line items db) goto Layout (Print Invoice) Enter Preview (pause) Page Setup Print Next Record (exit after last) End Loop Exit Script It all works great - except that it is looping over and over again. I only have one…

Me Once again - I am creating a script to find my finance charges that are due. My three critieria fields are: Terms = Payment Plan Finance Charge >0 Finance Markoff (checkbox - YES) - is checked What I have so far is Enter Find Mode Set Field(Terms, "Payment Plan") Set Field(Finance Charge, ">0") Preform Find This works - my question is how do I have it add the Set Field for my checked box field. I only want it to find the checkboxes that are empty. Thanks for your help on the final step or steps I need to add.

Hi, By using Trim function to remove space of a Text. But how can I remove the character return(S). The reason I asked is because sometimes the user hit character return to move the cursor to the other field instead of using Tab, and they leave the character return in the fields. It seems there is a simple solution for this, but I could not figure out. Thank you

The aim is to have a button which will automatically open a Word document associated with a record in a FMP file. In windows, it is easy - you can use the Insert-Object menu to either embed the word doc in the datbase or create a link - both options can then show the word doc as an icon in a container field. BUT - this option is not available in Mac. So far, this is how I have done it but it seems quite "inelegant" to me, especially because it requires the user to manually insert a full file path name. Fields you need in your database: . A text field called "FilePathText" Scripts you need: . A one step script to open the word document associat…

Is there a way with FMP or a commercil plug in to print a list of layouts and scripts within a file? I've printed script definitions but want to print a list of all scripts to do some housekeeping with huge files.

Does anyone know how to detect with email program is set as the default on a mac?

Anyone know how to detect if a file is being hosted by FM Server? Thanks

NO. You can do everything on Workstation. Server just serves data.

When opening a multiuser multifile solution I like to open the windows on a specific place on screen. On the left the menu window (5 cm width and the whole screen high). On top the navigation window (3 cm high and the whole screen width). And in the middle the window with the data. I like to do this with a startup script. I thought that when I place a window on a particular place on the screen filemaker remember it the next time on start up. Also when I place a window on the whole screen width, the next time on startup it place the window half on screen with scrollbars. Can i script this whole placing, scrolling window stuff ?

I have set up the send mail script on a database but finds it only works when the default email program is Eudora. I am new to this script and look for any advice on how I should set it up correctly. Thanks in advance!

I am trying to export our data to another system (not FM) in order to get our listings up on another web site. In my FM system, we have "property address" which contains data such as "10 Smith Street" or "Lot 1/10 jones street". In the other system (to be exported as comma delimited) we need "property address" split into "Street Number" field and "Street name" field. Seems very simple request but have checked the forums and can't work out how to do it. Help appreciated.

Maybe I designed this wrong....I have a database of survey results. 10 questions (fields), each pulling from a value list (SA, A, N, D, SD) displayed as radio buttons. I would like to calculate the number of responses per field, e.g. for question 1, how many respondents answered SA versus A versus N, etc. It would be easy if I had 50 fields (1SA, 2SA, etc.) but it seems like there should be a way to calculate the count of Field 1 equalling SA, etc. Any thoughts? Rick Metheny

i have a filemaker solution that i'm hosting on a windows xp computer (fmpro 5.5) the solution includes about 15 files that each have a bunch of passwords based on employees... I have found a help message on this forum with the following startup file Allow User Abort [off] Set Error Capture [on] Open["database1(host)"] Open["database2(host)"] Open...3-15 Set Field ["LastError", Status(CurrentError)"] If ["LastError<>0"] Show Message["Sorry End If Close The problem is that each time a database opens, it asks for the password again. I thought that if the password is the same for a group of files, it would only use that password...…

Hello, I have a question, I am making a database with an invoice system. Users should be able to change the invoice, but at a certain moment (when they push a button or when something else happens) The invoice should be frozen, people shouldn't be allowed to change it nomore. What is the best (easiest) way to do this? Should I just direct them to another layout where no fields can be changed or are there better ways to do that? Hope someone can help me, Thanks anyway, Greetings, Thierry

Hello, I would like to setup a script to change the value list that I used in a "popup" field for another value list. I would like to be able to change to switch between those two value lists. Is it possible ? Thank you for your help,

Is it possible to execute a script according to time of day - no clicking on buttons, no cursoring into a field? When the clock strikes X:XX the script runs automatically. Or is a purchased plug-in the only answer? Thank you.

Is there a good scripting reference book I could get? Mindy

Hi, I would first like to thank everybody who has helped me out so far! New question. I am trying to find all records where: Field Finish Date is either EMPTY or falls within this or the previous calendar week. I could try(!) to create a formula to find all records where a date falls in the last 7 days, however by the end of a 7 day week (week 2 Sunday) the calculation would need to look back 14 days. Am I missing something? My formula creation knowledge is a bit limited so any pointers would be appreciated. James

I'm trying to calculate dollar totals with fields that are numbers. it's simple, field A + field B = field C. unfortunatly, it chops off any thing after the decimal place if it's a 0. So $15.00 comes out as $15. How do i set it to keep the 2 places after the decimal point.

I am working on a database that will hold attendance information for 800+ students. I'm using repeating fields to hold the data. They are as follows: attend_date, attend_status, signinout, period I would like to create a report that would do the following... Search the repeating field by a date and report back the students name, and the status from attend_status, and signinout, and possibly period. I've yet to figure this one out.. It has got to be something that says... 'If the date I'm looking for is in row 13 of attend_date, then display the information from row 13 in attend_status, and row 13 of signinout' --- Is this even possible, and is this correct…

Why is it that when I activate the script ''Save a copy as...'' to backup a database, I have the following message: -There may not be enough disk space to complete this operation. FileMaker will not be able to open the file if this operation fails. Proceed anyway?- I have: FMP5,Windows XP Pro, with 512MB, 266MHZ, 80GB. It did not do that on the Mac I had till 2 weeks ago. I am a little bit alarmed. Somebody has an answer? Thanks

FM4 Would like to be able to e-mail a print preview out of FM. We send our listings to our web host by going to a layout, print preview, copy, open WORD, paste, save as, and then emailing the word document as an attachment. It is always to the same e-mail address. Thought a script might be able to do it. Help appreciated

We are using FM4 as our listing system in real estate office - fantastic. I have got it doing just about everything (with some help from the forum). We hold pictures of properties (.jpg)for printing window cards etc (linked not imbedded). When we do advertising in mags, we copy, pase the different text field straight into WORD to make up the add, and send this to the printers along with associatted .jpg's. Problem is that to send the associated photos, I need to have FM open, WORD, and Paint shop (or what ever), look at the photo in FM, find it in Paint shop, copy the file name and then pase into the WORD doc. I would like to hold the file names as well as the pho…

I have two related databases in my costings solution. My BOM database does a search in a costings database based on a search criteria. If the costings quantities for a certain part are, 1000, 2000, 4000 & 8000, how can I cost for a quantity of 5000? How would I write the script to find the next lowest break i.e. based on the costing quantity for 4000? An example script would be greatly appreciated. Thanks.

This must be a very simple one but the solution seems to be evading me. I have a find button in my database with a script that enters the find mode and takes you to a specific find layout. I want to create a button that will take you from find mode back to browse mode and the main layout. None of the Scriptmaker commands such as exit script seem to work. Clicking on the cancel button in the toolbar manually seems to be the only way to exit the find mode. Can any one help me out with a Scriptmaker command that will do the above. Thanks.

In the November issue of Filemker Pro Advisor, Dick Honig writes how to separate your data from the interface file. I have a keen interest in doing this, because everytime I make changes to my program, I have to go through a rigorous process of moving data to install the new version to about 10 users. Can anyone share their experience or know of similar articles? I like to learn more about this and Dick's article was NOT to user friendly. Thanks

A feature I want to build into a current project is sending a message to a pager when a script is triggered. I assume I can just write a script which will parse out the appropriate text & numeric data to the fields in a web service (I've done it for Mapblast and ""Quest), like skytel. I thought I would use a FMP plug-in to trigger time based events...but my question...is has anyone done this yet? Since I don't know anyone with a Skytel pager...I can actually do a test on their site and see what type of commands they are using...so I don't know how to format my script. Anyone who might know the text...I would appreciate if you can share it!!! [ March 09, 2…

Maybe I don't have the right approach for this... in any case, here it goes: I want to go to a related file to a specific layout based on the value of a global field. The value of this global field can be changed by the user. If the file was not already opened, I could have defined a "open" script and tested the global field, but since it is related, it is already opened and the script does not run everytime we go to the file. If this is not clear, here is what is needed: the global field is "language", the user is allowed to toggle, the various layouts are in different languages. I hope anyone of you can point me in the right direction. Thanks!

I have a calculation field like this "40 at a price of

Here is the problem: I have a database with a text field. It looks like this: Record #1: Adam Record #2: Brian Record #3: David Record #4: Eric Record #5: Fanny I want to merge the records for instance like this: Record #1: Adam Brian David Record #2: Eric Fanny How can I get each name on a new line. Is there any useful script for this? Please help!

If the related field indicates that the item exist in the other database make a calculated field in each database case (isvalid(your related field),0,1) then you can do a find on calculated field = 1 if you want to find the records that are not present in the other database.

Is it possible to display a list that only shows fields in a record if those fields contain values and does not show a blank field if they do not Hope this makes sense!? Cheers Nick

Morning all - I have a script that is not looping correctly. I don't want to have to type it all in - so I will attempt to tell you what it does. I am finding finance charges on payment plan invoices that need to be posted. The first part of the script turns error capture on and then preforms a find using set fields. Now if the Find finds nothing I tell it to exit script. That's probably my first mistake - so do I need to create a loop for the find? After the Find I have it go to the first found record and pull the needed information out of it and then it goes and creates a new invoice for the finance charge. This works find. But this is all …

I have a script that copy's values from one field and pastes them into a validation field, the problem is that I get an error stating "End of text block limit". There are 30 fields, some of which are empty, the script goes into each field copy's the value and pastes it into the validation field. After the text is inserted into the validation field it's format is all over the place. eg. J Bloggs j Bloggs Does anyone know what causes this. Obviously it's because too much text is going into the vlidation field. Within a script is this loop, is it ok Loop Exit loop if (Day = Day) Set field (Day + 1) Copy (Curren…

Can someone give me an example script as follows: Clicking on a button on one layout will take you to different layouts depending on your Filemaker password sign-in.

I want to check a field for a number of different variables and insert another variable into a different field depending on the result I have tried If field1 = "A" or "B" or "C" Insert text (field2) "A" End If If field = "X" or "Y" or "Z" Insert text (field2) "X" End If But this doesn't seem to work - Please help Regards Nick

I want my users to view out a specific report in preview mode, which therefore enables sliding/shrinking etc, and gives them an indea of what the printed page will look like. I would also like them to have the option to print the report (or not). To get to this particular layout, the user can press a button from any one of 30 other layouts, which then flags the last viewed layout/record in two global fields. When the user finishes previewing/printing, I want them to go back to the last (non-report) layout. the script goes something tlike this Show all Omit Show omitted go to layout x enter preview mode (pause) /…

Yes, make a button to go to that layout and you can then script whatever you like. You can't script from the layout popup on the status bar

Hi there, I have a field Image Thumbnail, http://foo.com/whatever.jpg what would be the function to change the above path into the following path - http://foo.com/thumbs/whatever.jpg and/or http://foo.com/thumbs/whatevert.jpg any ideas? Thanxs Steve Griff

Hi! I have a button that moves from one layout to another. How can I add a script that will take us to the next layout, but also clear one of the fields IN that layout? Thanks much! Ben

I'm trying to adapt (unsuccessfully) a real neat sort routine I found in one of the Templates that either came with FM Pro, or one I downloaded from the FM website. The Template is Asset Management.fp5. In the list layout, by clicking the column header (a button) the records are sorted in descending order. The next time the header is clicked the sort order changes to ascending, and so on. I've copied the scripts precisely, but can't get it to work. It's as if I'm mising a step. But if I do a manual descending sort, then click the header the records will resort to = ascending, but won't sort descending. Does this Template have some hidden feature I don't see? …

I use FMP on Macs as attendance controller. Students enter ID and FMP stamps date & time. I need to make each workstation export its data automatically at a specified time. I keep getting the export dialog box or a message that no fields have been selected. I can't figure it out.

I'm sure this has been answered many times but I'm somewhat of a beginner and am going to ask anyway. I'm having problems setting up my database (FM 5 on OS 9.1.2) to auto email users when a return by date has surpassed. Can someone tell me where I can find step by step procedures for setting up an email script or email me some procedures? Any info would be extremely helpful. Thanks.

Setup 2 extra fields, one is a text field, the other a calculation which concatenates all of your "actual" data fields together. You start by setting the text field to be the same as the calculated field. During your navigation you will need to find a place where you can script a check between the contents of the calc field and the text field. If they do not match, a change has been made to one or more of the actual fields and you can take appropriate action. However before doing this, take a step back and determine why you need to do this. Make sure that going through this checking process is the ONLY way to accomplish your goal. HINT: This is NOT …

I've been working on shared database and was wondering if anyone knew if it was possible to create a script that will send a message to all other users who have the database open. Thanks for the input.

Is it possible to have a value of a field calculation determine which layout to go to? Not a script but a calculation value. Here is an example: When entering info on a application you put down applying status is alone then at bottom you tab into field and it takes you to the next layout, but if the value was co-applicant it takes you to the co-applicant portion of the layout. [ February 27, 2002, 02:05 PM: Message edited by: vr5150 ]

Hello I'm tying to figure out how I can automate backups of my fm dbs. I wrote a script that will "Save a copy" then I have a different machine FTP in and copy it out but this script has to be run manually. In my current hack I use windows scheduler to run IE everynight, I made IE home site an FM Web url that runs the script then the scheduler kills IE after 5 minutes. However I have little fatih in IE and don't like having the script URL as the home page cause once in a while I like to open IE up and don't want to run the script. And gossh darn it there has got to be a better way. Any suggestions? Thanks Mike ------------------ ======================== Mike…

Hi guys, here is a good one for you. Can anyone think of a way of writing one script to do the following. Diary system. 7 relationships, 1 for each day. Within each day are time slots 8am-8pm. These are stored in an appointments db, 1 record for each day, with the time slots as fields. Who can think of a way to script this using the minimal amount of scripts. I know I can do it by writing a script for each time slot. Not keen I know I can do it by clicking into the field and then clicking a button. Would prefer the time slot to act as the button. I use this to pick a day from a mini calendar on the side. (you've got to love the …

Hi everyone! Can anyone help me with this idea. What I'm trying to do is from one file search a number of fields (named the same thing) in another file, display certain of the results that matcha criteria (between this number and that), and then be able to click a button beside one of the displayed numbers to go to the layout in the other file that contains that number. Every different number would be in a different layout. If that makes sense and you have any ideas, I'd appreciate your help. Thanks! Ben

I have an invoice system that I am trying to create for a receipt for customers. On this receipt (invoice) I have multiple line items from which I select from a value list. When I select a Category in the value list and all of the related information appears, I want to create another line item on that invoice. I am looking for a script that will create another line item that will not repeat the previous line item data. Does anyone have a sample script? Or, can someone e-mail me with the script or post it here? I guess basically that I am trying to create a new record within a record. Thanks in advance! Delbert

Hi All, Is it possible to tell a script to do a find on [FMP-currenttoken:2]. Basically my orderID is token 2, which I'm carrying around and the script has to find a record and print it out on the click of an "order item" button. Thanks in Advance.

I'm trying to debug an application written in Filemaker 5. Because this application uses 12 Filemaker databases, over 400 fields and almost 1000 scripts, I'm finding it difficult to find common references throughout the scripts. Is there a plug-in that I can use to export all of the scripts into a text editor in order to search for variables? Is there another way to search for variables, field names, etc. within fields or scripts? Lastly, is there a way to find out what script is populating a particular field if that field is only defined as a text field?

I am having a problem with my username and password entry. When it verifies the two fields it takes only a partial username or even just a first letter if the password is correct. Here is part of the script which checks the fields. It goes on to tell the user to try again. I would appreciate any feedback. Enter Find Mode [] Set Field ["klc_staff_username", "staff_username"] Set Field ["klc_staff_password", "staff_password"] Perform Find [] If [status(CurrentFoundCount) = 0"

I am trying to re-set a find within a script. I have done the find before I enter the scriptmaker. Then I go into the script and look at it and close it. When I close it - I tell it to replace the Find Requests. What am I missing - it is stuck on the original found set!!! I have tried it with restore find requests both on and off. Help.

My database has about 100 layouts and involves a lot of "jumping about".. The user has to return to a main navigation pge to get around. It would be helpful if I could include a "go back to previous layout " button on each layout. Answers in words of one syllable please, be gentle, I'm a novice!!!

Hello, I have a series of different databases for our buisness. They are all linked to one that is called "Home". From "Home", I link to all of the other databases, "Inventory", "Invoice", "Purchasing/Recieving" ect.. In all of the inidividual databases I have a script to sends the user to "Home" It is nothing more than the step Close[invoice.fp5] For all but one of the databases, this works fine. But in one, the script runs but nothing happens. What am I missing? I am not any advanced user so I may not be using the best tool for the job. Thanks, Steven