Script Workspace and Script Triggers

I am building a runtime solution so would prefer not to use a third party plugin due to increased cost. I want to have a list of URL's that Filemaker goes out and checks (on open) and passes the value (TRUE,FALSE). Design is to test whether the links are live or dead. Does anyone know if this can be done with native FMPro7Dev? Thanks webber

I have a script that jumps around to several layouts doing searches and then replacing a value based on the result of the searches. Now when I don't put pauses into the script at certain points the value doesn't get changed. When I put the pauses in it does change. Why would this be? I haven't changed any of the script at all besides adding pauses. Is it possible that the script is getting ahead of itself for some reason and isn't running properly? I jump to three seperate layouts and do two searches before replacing a value on the last layout....

I am writing a back up script. How do I detect if the database has been modified or just viewed kevin

I have a vendor table that is related to the product table. Each vendor-product combination has a price. I enter a quote (price)record in a separate table and the vendor product price updates to match the most recent quote, using a lookup. I'd like to update the price also by taking the last price from the invoice items. Should I just write a script to create a new quote record every time I enter a new invoice item? Is this the best way to update a field from multiple different layout/tables?

I may not have understood the problems that are similar and/or the solutions described, so forgive me if this is repetitive. I am using FM8 Advanced. I have a script that seems to work but it only works on one group of several identical groups, time after time after time. I am trying to produce a monthly summary report of attendance at several of our schools. I am using a Get(Scriptparameter) function with buttons so that any month can be printed whenever desired. The script is pretty standard except for the Find section. It reurns the correct result for one school and the same school repeatedly. What I want is the correct result for all the schools on the same report. …

I need to use an id number from a field in this database to open a corresponding file on a network drive. The open file script command doesn't seem to allow you to put any random name in, you need to specifically select a file. Is there another command that I could use to have the filename generated instead of having to select it?

I am trying to change the date on a script for VAT Reports which will not allow report beyond December 2005. Any solutions please. PS I am a beginner

Hi everyone, I have a question about script variables. I fell in love with them when I first learned about them, but I have a problem with global script variables. Are they permanent to a database once created? I know that a local variable only exists while the script is running and that global variables can stretch across sub scripts. I liked this until I noticed that they always seem to have a value in them unless you clear them. Even if I clear them, are they taking up space in my solution. I am moving away fromt the globals but the ones I have used in the past still exist, don't they? Can anyone shed some light on this. Thanks

I made a "health quiz" in FileMaker, and each item is worth one point. How do I make a script for adding up points? Thanks! Alisun

Has anyone successfully worked with DDE and Acrobat? I've been trying the get a database to call an Acrobat file using the DDE Execute command so that I can print the file without the user being involved. I've gone through the syntax over and over again trying different permutations but with no success. This is what Adobe says the syntax should be: [FilePrintSilent (char* fullPath)] with <char* fullPath> being the full path to the document. I've also tried different settings for the Service Name and Topic. Nothing seems to work. Error checking has indicated an error 3 which is "Command is unavailable" Any experienced users out there who m…

I am a beginner so this may be very simple but I am having problems. I have a found set and I want to omit lines that have a single field the same. When I use Constrain Found Set to omit a search for ! for the field, it removes every line in the found set if it has a duplicate anywhere in the database. I am a beginner with FM but have coded in many languages for years. I have tried writing scripts to loop through the data and compare each field, omitting duplicates, but something is definately wrong because my script never ends. I memory and cpu are not eaten so I wonder if something is simply wrong rather than going into an infinate loop... Thanks for any adv…

This should be real easy but I just cant seem to make this work. All I need is the have the last digit of a field to be trimmed off. So... 123245 123 7654 45433 would look like... 12324 12 765 4543 I've tried various combinations of Right, Replace, Middle, Substitute, etc. functions but no luck. Any Ideas? What am I missing? Any help would be appreciated, Thanks! Tom

Hello.... I would like to display Active or Inactive on a layout near the name if the active field is Yes, I would like it to display Active and if no, I would want it to show Inactive. I thought that I should do an If statement... but it's not accepting it I have 2 tables (so far)... 1 is People and the other is Dept. In the People table, there is a field that is titled Active with Yes or No populated for the records. here is what I have: If[People::Active = "Yes"; "Active"; "Inactive"] end if But as I type People::Active = "Yes"; "Active"; "Inactive" Filemaker throws up an error saying An operator (e.g. +,-,*,....) is expected here …

A script I've been using to send email via Outlook has stopped working on one computer, but not any of the others in a served environment. The user gets an error message of "Outlook operation failed." Anybody know how to fix this? Reinstall Outlook?

I have a script that copies a field in one table and pastes it into another corrisponding field in another table. However, the copy does not always seem to work. About 50% of the time, it pastes what ever is in the clipboard. Has anyone experienced something like this? My scripts are set up as follows: (Really the steps in RED are the ones I'm having bugs with, but I'll post the whole thing). Thanks, Bronwyn Create New VFX Scan• ----------------------------------------------------- Pause/Resume Script [ Duration (seconds) .25 ] [color:red]Copy [ Codebook_DB::Key Number Start ] [ Select ] Commit Records/Requests [ Skip data entry valida…

When you click outside of a field or button, Filemaker gives you a Custom Dialog giving you the option to save,etc. Is there a way to disable this? I have "Save" and "Cancel" Buttons in my scripts and this circumvents them. Thanks, Mel

I've got a series of field names (example is TimeCards template from FM)--->day 1, day 2, day 3....). I want to access the appropriate field based upon script parameters passed in from a button (ie., parameter "1", go to field name Day 1). How do I do this? I've tried using Concatenate to put it together with Get(ScriptParameter), which succesfully results in the text string equaling the correct field name; however, it's not being recognized as a field name. Example.. If I output the result of the calculation into a dialog, I see the correct field name displayed; however if I attempt to do a calculation based on this calculated field name, it doesn'…

as a followup question..... Is there a way to get the datestamp to look ELSEWHERE for a date/time (ie., a time/date server), rather than to the system time/date?? I'm trying to use the timestamp in an employee time card solution, but am concerned that wiley employees may elect to change the computer date/time setup rather than have it check a network timeserver. I'm running 8 on a multiuser setup without server..

As a sort of deviation, from the thread "single table structure, why not" are we into encapsulation or reusable code. We have all our hunches and sense of direction, although it's stumbling near to ignore quantum leaps, by this practice. Some weeks ago was I baffled from the reasoning in one single script per solution ...and I'm still struggling with it. It was stated in another debate forum, that the occurrence of script parameters, have made modularization ready for obliviance, and the reasoning behind this statement: From: http://www.filemakerpros.com/Optimizing2.sit ...was made ridiculous old fashion. The poster found it so…

Hello: When "save record changes automatically" is not selected in layout setup, FM displays a dialog box with "Save" and "Don't save" buttons. Question: is there a way to add scripts to these options in such a way that if the user clicks on the Save button FM saves and execute script X and if he clicks on "Don't Save" FM does not save and execute script Y?

How do you script a find in a checkbox or radio button. If I have 3 values in a checkbox or radio button field, what should the script say. I can do this manually, but dont know about how to script it. Thank you.

in conjunction with my other question about the maximum number of scripts, I realized I've missed a step. As well as having the button go to the next field, I want the same button and script to enter today's date in a completed date field. Let's say my conditional field is field 1 and my completed date field is field 2 (is there a convention for naming fields in these questions?). If the answer to field 1 is yes, go to field 3. If the answer to field 1 is no, go to field 4. so even though I've decided to have a script per variation, I was wondering if I could create one script to have the completed date field have today's date. In non-FM language, I'm th…

It just dawned on me how different this forum is to the car forums I used to spend all my time on. I have not yet found one instance of a new poster being chastised for apparently not searching for the answer prior to posting! At any rate, I think what I need to do to solve my problem is to create a different script for each button I need to create. There might be over 150 buttons. Is that too many scripts? :qwery:

Hi I have a record with two fields - fieldA and fieldB. I want to export the contents fieldA as a text file to the desktop AND give its filename the value of fieldB. Can this be done? TIA Chas FM7 and FM8

We've recently switched from CDML and FM6 on Windows to FX.PHP and FM7 on Mac OS X Server. I had a script (called from the web) that printed to PDF and named the file using Affiler. Now, on the Mac, I can't use Affiler. How can I have the file named automatically? I understand FM8 has a way to do this, but we won't be getting that for a while. Thanks for any help!

I had been using a previous version (5.5) and was able to create a script that included the "open URL" function to open a PDF in Acrobat, but I can't seem to get it to work in v.8. Even with the URL dialog open (so I can check that the path is correct), nothing happens. The PDF is located on another drive on the network -- could that be the problem? I've read some postings that refer to 'Events" but that's not something I'm familiar with. I'd be a hero at the office if I could pull this off . . . thanks.

Is there a way to write a script that will run after a selection is made from a pull down menu? Example: Pull down Menu item is selected (Active) as soon as the selection is made a script runs... Thank you, Joseph

How do I add a group to several contacts (or rather several contacts to a group)? I have groups created and right now the only way I know is to add the group separately to each contact?

I have two buttons. One that finds all tenants whose rent is past due. And another that does some administrative work and then goes to the layout where a past due letter can be viewed and printed. I need your help with two script issues. 1. Find Late: If I click on the Find button and there are no records found I get the standard FileMaker dialog box “No records match this set of find request” with the Cancel, Continue and Modify Find buttons that no one ever seems to know what to do with. How do you write a script, when there are no records found, that brings up a custom dialog box that says, “No Tenants found with Late Rent.” And a simple OK button that leaves yo…

I'm a scripting newbie. I'm just not very good with loops, if else ect. But I keep trying. I have a table with 4 fields Data, global_1, global_2 & global_3 I want the global fields to populate with the 1st occurrence of any record in the Data field. In my script I will sort the information first so that it appears as shown below Example Data A A A B B C C So I want global_1 = A global_2 = B global_3 = C The above is just a simple example. I might want to have a many as 12 globals. So I hoping that within the script that there could be a step that will loop and move to the next global record after it populates it…

Is there someone out there who could please give me a sample file {preferably a very simple one} showing exactly how to use the SetField function? What I would like is if say I have a Jobs table and want to copy the job number to a Contractor table without doing a copy/paste or copy other info from one table to another without copy/paste or using a portal. Are there any brave takers please? I have looked at several previous posts here and elsewhere and haven't understood the principle from any of them. I don't understand the use of variables either!! Thanks in advance to any contributors.

Quick question, I'm trying to put a value list into a custom dialogue for display... and comma seperate it etc with no luck... i.e. Let (valueDisplay = Substitute(ValueListItems(Get(FileName);"ValueListName") ; ; ", ") ; Left(valueDisplay ; Length(valueDisplay) - 2)) Yes i am sure i am using a real value list and it's name is correct. Thanks for any suggestions. ~Genx

I don't know why "Go to Next Field" script step is not working in one of my layouts (it works in another layout I tried). I examined (and reset) the tabs, I changed the field behavior to select all on entry, etc....but to no avail. Any guesses?

Is there a way to create a filemaker URL that the system will recognize and then open filemaker to the appropriate record when clicked? For example, is there a link I can create similar to "fm://mydatabase/1234" that when clicked would open up the "mydatabase" database to record 1234? Maybe I could leverage AppleScript somehow? Alternatively, if I setup instant web publishing is there a web url I could create that would open up Safari to the appropriate record? Thanks! -Chris

how i can make a script, that after entering data of all fields in a record , the fields locks and becoming nonmodifecable and new record started

Hello, Is it possible to create a script to change a field in "define fields" with a serial number. In ScriptMaker we can use the step "Open Define fields", but is it also possible to open a field in Define fields? What I want is the posibility to reset the serial number. Like to hear some ideas on this matter. Greetings, Jukkie

In v6 I would add text to a custom dialog box to explain the one word Buttons such as Look at a BIG list Look at a SMALL list and the buttons might be big and small. In version 8 I haven't found a way to make the two descriptions be on separate lines. It always displays as one line. How To?

Hey everyone. What I want to do is export records based on the record number in the current window. For example, I have a window containing 100 records. Without doing a "Find", I want to export the contents of record number 2 through record number 10 only. I want this export based on the record number because the window I'm working in already has the correct records that I should be working with. There is no need to perform a "Find" upon entering this new window. How can I do this? Thanks in advance. J

I am using Filemaker Pro 7 and trying to make some scripts. I cannot locate the "Set Variable" function - is this new to 8 or only in the Developer/Advanced versions? It seems odd that there are all these other functions that do much more advanced things, but I cannot simply set a variable. Here's what I want to do - is there another way? I want to simply set a variable to the value in a field, then be able to use that variable (searching, record lookups, etc). Thanks, Jason

hi I've got two portals in one layout. Is there some way of selecting one over the other. (I'm trying to count the number of records in a particular portal). Thanks

Hi, I am using fmpro 7 on windows 2003 server, I am trying to make the database automaticaly start when the server is rebooted. I am wondering how to do it since if I put the database in the startup folder it will startup but will stop at the login (the I need to remote access the windows 2003 server to login so the database can be available to user since it's shared). And if I put the setting to automatically login with x or x account then when people want to connect to this file then they cannot login whit theyr proper username and password. So I tought the solution would be to create another file with a script that will open my databse and login with whatev…

I'm learning from scratch as I go so please don't laugh too hard!! I have a very small portion of, what I hope will become, a full blown solution some day. I would really appreciate it if everyone in the know would take a peek and let me know how I'm doing and where I can improve. I'm certain there are allot of short cuts I haven't learned yet. The plugin I'm using was too large to upload here. Here's a Link to the plugin on my website. (Trial version of course). It is "Dacons Scriptfire". I'm afraid without the plugin my scripts might be meaningless. (On the other hand, they might be meaningless WITH it!) Thanks a million for all your help. …

I just got a book "FileMaker 8 Funcations and Scripts" and it show the SET FIELD function for scripts in a find. I have tried using this with ScriptWriter but have not been able to duplicate the format. If there a way I can write a script free hand in FM or do I have to use the script writer? When using the script writer I specify the field but can not include the action to take. I go to calculations and can not get it to do what I want there because it is wanting () and the book shows brackets [] around the set. I am trying to find items with a date and time. This is an example of what I am trying to do #Find payments entered prior to 15:00 hrs on the…

HI, Has anyone been able to create a script that opens a window in the center of whatever monitor the user might have? Any help here would be great. Thanks -JJ

I'm building simple scripts from buttons that just change layouts - nothing more. I keep getting a dialog box that pops up in the midst of the script that says "Not enough memory for this operation." When you hit the OK button, the next dialog asks if you want to contiue with the script. When you hit yes, the script completes. This hasn't happened to me before....what am I doing wrong? Thanks.

Well I'm not complaining mind you ... okay, maybe I am. New in vs. 8, many things have been added - YAY to FileMaker! But why in heaven's name did they REMOVE the button CLEAR ALL? It's not like they ran short on space in the Script Maker window - there is room for 10 more buttons! Why do I like Clear All? Because, instead of creating a new script which pops to the BOTTOM of all my scripts and then having to drag the silly thing upwards for an hour to place it in position, I find the location I want a new script and duplicate an existing one - any one. Then I Clear All and begin my new script. Unless I'm half-blind (smile), I see no way to quickly remove al…

When generating a report, I have one instance where it's possible no records will be found. If this happens, they get the "records not found" message. Is it possible to skip that and show a custom message with instructions? Or maybe run a script where they can go to another layout? It's just important that they only see records that pertain to this specific layout. This is for FM 5.5 which will then be turned into a stand alone app with FM Developer. Thanks for the help. Bob

I’m new to Filemaker. I use FilemakerPro 8 on an iMacG5 OSX. I have been able to build a script that takes me to Find mode and even enters data from the clipboard into the field that I have specified. But I still need to press the “return” key on the keyboard to “execute” the find. Is there a script that accomplishes the same thing as pressing the return key? Thank you.

I need to format a field to display a list of codes based on a set of checkboxes in another field. For example, field 1 is called "Tests requested." The user selects the corresponding checkboxes. A related table has tests in one field, and the test codes in another field. I want to pull the test codes from the related table and concatenate them together for printing purposes in another field (Test Code Summary). User selects Purity, Germination and Noxious Weed exam. Corresponding codes are PUR, GER and NOX. I want Test Code Summary to display the text "PUR, GER, NOX" I've tried everything I can think of, but I end up with only the field code from the first…

I'm in the midst of upgrading a database to FM8. The database was first created in FileMaker 2.1 and has been upgraded repeatedly until 4.1. Now I'm upgrading/converting it to FM8. This database has a LOT of scripts and there are many that have accumulated over the years and were not removed or cleaned up... now it's my job to do that. Is there any tools that can show me: Scripts that aren't tied to any buttons or other scripts A full list of the scripts (printable?) not just a ScriptMaker window at a time. Scripts with broken(unknown) references Scripts that refer to other files Many Thanks!

I have written an invoicing package for my company in FileMaker Pro 8. Each line item on the invoice has a Revenue Code ("revCode") and at the bottom of the invoice I would like it to list each revenue code and the total amount that goes in to each. For example: If I have an invoice with 4 line items. Item 1: $5.98 RevCode: 001 3994 994 Item 2: $38.40 RevCode: 001 2993 449 Item 3: $9.95 RevCode: 001 3994 994 Item 4: $11.02 RevCode: 001 3304 299 And at the bottom of the invoice I would like a summary printed that would look like this: Rev Code: 001 3994 994 Amt: $15.93 Rev Code: 001 2993 449 Amt: $38.40 Rev Code: 001 3304 299 Amt: …

After 2 1/2 not totally pleasant months, one of the databases im working on is almost finished (yay). Now comes the fun part, exporting and importing, with 46 tables, the actual export script shouldnt be to difficult, however my query comes about the serial keys. Almost all of my tables have an incrementing primary key. A) I forgot the functions to pull out (and set) the next serial key in the particular field of a table. I have no idea where to store them so that i can restore them after an import. Cheers for help, I really am not thinking to well lately so thanks for putting up with my fun questions. ~Genx

Hey there, I am having problems creating a new record in a related file. I have a database of recruits and all of their information that is related to a high school database table containing addresses and other contact information. I do a lookup of information and am able to update the HS DB from the Recruit DB using the "Go to Related Record" script. The problem I am running into is that I cannot seem to create a new record in HS DB file. I want to do this from the Recruit DB if I enter the information and the HS isn't found in teh HS DB. I have tried many different scripts. They usually start with "Open File". When I try the "New Record/Request" but it creates a…

Is this an undocumented "feature"? I just discovered that if you decide to have "Cancel" instead of "OK" as your default button, the value entered in the input field does not get recorded. In other words, if the button you choose to confirm an action with is not the default button, the input fields are left untouched. Troughout my application, I have chosen not to take action "by default": if the users want to create a record, they have to intentionally click on the Create button (that is not the default), or if they want to print, the default is to cancel, the second button is to print. I found that by doing so, records don't get created unecessarily and…

I'm trying to set up a report with a field that will default to last month for a search. I'm using the following logic: MonthName(Month(Today) - 1 & "/1/" & Year(Today)) and it keeps giving me June as the name of the month (testing with March as current month). When I change my system date to: January, it gives me November February gives me August March gives me June April gives me March (this month works!) May gives me January June gives me October October gives me December etc. I must be missing a step in the conversion from numeric date values. When I pull out the monthname function, the date is still incorrect. For example …

Hi all, I have created a n event registration DB based on the template that ships with fm 7. I am a newbie at fm. The db holds events - up to 51 of them - and only some of them the participants are issued tickets which I have setup in a layout. What would be the best way to generate unique ticket numbers for these few events when a person is registered for them? There are at the moment 4 events that require ticketing the rest do not noe ever will. Cheers Craig

How would I check a text field to see if the text in it is formated correctly? For example: I have a text field titled Index1. I have a script that puts text into that field. What I need to do is write another script that checks to see if the first letter is a "b" or "w" and the next character is a number. I now about the left function. But how do I test for a non-specific number?

I have a many to one relationship between two of my tables. Specifically, I have one person that can have multiple letters associated with them. I have a script that sends that person a letter as long as they meet the following: they have not been sent this particular letter before. As I loop through my people table I want to run this check. How do I handle this? Should I do an IF statement like: if(not(Letters::ID = Contact Info::ID and Letters::Description = "Initial Letter")) I have been unable to get this to work. Thanks for the help.

By dialing I would like to accomplish the following. All calls will be made via a computer headset and fax modem: a. Create a Dialing Log b. Dial a Phone Number (via record information) c. Automate the Dialing Log and actual out going call from a single button Any help would be greatly appreciated. Thank you

Has anyone noticed that, sometimes, the script runs faster than the actual record update. Occasionally I'll have a script change a record (Especially "set field") and if I don't put a .25 second pause after it, the script seems to keep on truckin, oblivious of the change. I discovered this when my script wouldn't do what it was supposed to but when I stepped it through debug IT WOULD! Thanks, Mel

Has anyone noticed that if you have a custom dialog in windows and you press the escape key, the dialog is dismissed but the script acts as though your pressed the default button just like if you hit return. If you actually click the cancel button, the Get(LastMessageChoice) works as expected. This doesn't happen on the Mac side as the escape key doesn't dismiss the dialog. Is this a recent bug, because I could swear I've used the escape key before w/o a problem. My script is pasted below. Show Custom Dialog [ Title: "Enter the Chembiz Sale ID"; Buttons: “OK”, “Cancel”; Input #1: sample::gt_tempSaleID, "Sale ID" ] If [ Get ( LastMessageChoice )=1 ] …

Hello: I have a standard Invoicing DB with Customers-Invoice-InvoiceDetails-Products tables I am on Invoice layout with InvoiceDetail portal. What script do I need to get the following result: when I click on a line item (say, product P1255) in the portal I want FM to show all the instances where this customer purchased product P1255. I can manually go to InvoiceDetail enter find mode, type in customer Id and product Id and get the desired found set. But I am having trouble in a script getting the customer id and product id over to the InvDetail layout starting from the Invoice layout. Any suggestion will be much appreciated.

I have a solution for diagnostic studies in health care. I am migrating from 6 to 8. Among others, there are two related tables, studies and images(this is an ultrasound application). The studies table has a unique serial number for each study as a primary key. The images file uses this number as a foreign key to link to studies. The idea is to create a layout with a portal in the studies file to view all the images that are linked to it by the primary key. I am using the import folder script to import the images into the study file. I am currently using a script that sets the serial number as a global variable and then goes to the image file and sets the serial number fi…

Hi all, I have a multi-file solution that I'm trying to write a Re-Login script for. All files have the same user accounts in them, so when a user logs into the Interface file, all other files are logged into also. But when the script (in Interface file) runs the Re-login step, only the Interface's current user is updated. Can anyone offer a good solution on how to change current user in all files when the user re-logs into the interface. Thanks in advance!

I want to display a custom dialog for the period of a minute and if no response, close the dialog and continue with the script. Is this relatively easy to do? (I am triggering the script on a schedule, so if no one is in front of the box, i don't want it holding up the script, but if they are, i don't want the script interfering with what they're doing.) -- Chevell

I have an created an AppleScript email that is run through Perform AppleScript and in Perform AppleScript Options, Native AppleScript is selected. It runs fine on one mac, but does not create an email in another mac. Both Macs are using the same database hosted on a third mac that is running Server 7. Anyone have any thoughts on this. Script is below. Thanks in advance - Sam set theSubject to cell "emailSubject" of current record set theMessage to cell "invoice_email" of current record set theRecipient to cell "dentist_info::emailandcc" of current record set theSender to cell "emailSender" of current record tell application "Mail" set newMessage …

Hi, is it possible to resume a paused script from another script? At the moment I have a script that opens a new window related to postal information and then pauses. I presume pausing the script is the only way of locking the first window indefinitely, is that right? I now want to be able to work in the new window without being able to enter to first window. I want to be able to click a button to set a global variable and then resume the script that opened the window (to close it). I'm sure this has got to be straightforward but at the moment I'm ending up with lots of hanging script ends. Any help much appreciated.

I am very much a novice at this, so bear with me. I am using search and replace in a script to copy a sum (from a number field that is set to round off at the second decimal) in to a text field, replacing a part of the text there. My problem is that when the number ends with a zero (ie 123.40) the zero is missing in the text (ie 123.4). These are prices, so it's confusing for users without the second decimal; an unacceptable situation. I have the feeling there must be a very simple solution for this, but I can't find/think of it. Help!

I inherited the attached filemaker calendar program from someone who left my company. When I try to go to view and print calendar -- it leaves things out -- specifically on sept 15 JA-Class Parents Meeting. The info is there - but why isn't it showing it? User and password are dataguru. Thanks Hey how do I add the file?

I have a script that searches for a Y or N criteria, once it gets the search results it switches to a different layout then "save records as PDF", creates an email with that PDF, then loops back and visits the next record and does the same thing till the end. The PDF file thats getting attached is the same as the first record. Anyone had this problem before? I tried putting a pause statement in thinking that maybe it doesn't have enough time to create a new one before the email is created, but that didn't help.

Not sure I'm posting this in the right place or if a function is what I need to do what I want, but here goes. First, I'm new to filemaker. I am building something at work and would like to be able to have a button next to a website field that launches the url in the website field. The open url field requires you type one in. I'm also aware of the right click feature but would prefer to use a button on the layout. Thanks in advance oh yeah, I have filemaker pro 7

I want to pause/resume a script for a certain number of seconds. Problem is, the user can just hit enter and the script resumes right away. I'm sure there's a way to lock this. I tried "allow user abort" OFF and "error capture" ON, and even hide and locked the task pane, but no luck. Any ideas?

The attachment should just about explain everything! The layout I specified in the GTRR step is in the CURRENT FILE, although the table references an EXTERNAL FILE. I am deliberately not using the external files layouts for other reasons. You can see that the script step in the background shows "Using layout: < unknown >", whereas the edit box has the correct details. Amazingly the script step functions correctly but the ScriptMaker listing is wrong. I tested a bit further - to my horror it also managed to produce layout names from the external file with no obvious pattern even though I had not specified "Use external table's layouts", but once again …

Hi again, guys and girls. Two questions this time. I'm studying the Business_Tracker demo database (well, actually pulling it to bits with the enthusiasm of a kid pulling the legs off a spider). I'm interested in using container fields to make graphical elements change on screen, such as darkening a button graphic ton indicate it's "on" and soforth. I've run accross this calcualtion which has thrown me completely. Preferences::gSortHeaders [ Case ( SortField = 1 ; Case ( SortOrder = 1 ; 3 ; 4 ) ; 2 ) ] [ Case ( SortField = 1 ; Case ( SortOrder = 1 ; 3 ; 4 ) ; 2 ) ] It appears the field should be set with the contents of Preferences::gSortHeaders, but what happen…

I am hoping there is an easy way to do this that I am overlooking. What I want to do is set a certain script to run at night because it takes about 3 hours to complete. This script checks balances due each day for every invoice and fixes a larger problem that we had. I would like to know if there is an easy way to trigger the script at 5pm every day. Filemaker Pro 6 Windows XP

Could I please ask for some help with a script issue. I have a DB to hold copies of records like liability insurnace certificates for clients. These need to be updated on a regular basis. I would like to write a script to review the records and everyone with a Date of Next Update that is greater then current date plus 60 an email message is sent as a reminder. This is what I am trying: Show All Records IF: DATE OF NEXT UPDATE > (Get(CURRENT DATE)+ 60) SEND EMAIL END IF This is not working for me. Any suggestions or help? Thanks, Scott

Hi guys and girls (if any girls like databases, I don't know!) I'm new to FileMaker but not to databases in general. It's been some years since I used to write programs in FoxPro, but once I'd got into the swing of things, I found it quite pleasurable. So I think I have a reasonably good aptitude for relational databases and writing programs for them (don't know how many of you know it, but FoxPro Basic wasn't like FileMaker's scripting language - in FoxPro you HAD to include screen logic programming if you wanted your records to pause after 25 lines etc., you also had to rebuild indexes manually!) So the principles behind relational database operation aren't a …

I am working on a table called Personal_Device that has an Owner and a Serial field. What I want to happen is that when a value is entered into the Serial field, you either click out of the field or a button to make a script run. I would rather do it without the button, but if I have to, I will. I want the script to take the value in the Serial field and compare it with a Key field in another table called Device_Info. If the value does not exist, I want the script to create a new record in the Device_Info table that autofills with the value of Serial in the Personal_Device field. Any help would be much appreciated.

First time FileMaker Pro developer so pardon the newbie-ness. Bashed my head up against this for five hours yesterday and searched forums but couldn't find the solution. Basically, I'm trying to set up "Table::Field" variables so my script can be used on multiple fields. As it currently stands, I would need to re-create this script 96 times with slight variations (tough for updating and testing). Getting Issue 1 fixed would drop that to two scripts and fixing issue 2 as well would drop that to one. I've added comments to the code below. Any help would be appreiciated. Thank you, shyhavoc ----------------- ISSUES ISSUE 1 Attempting …

Ok here is a little something im comused about ive got a invoice file that im working on. The customer wants to be able to print in 3 different formats. Some customers get billed weekly some get billed monthly and some don't get billed cause they payed up front. So ive got the print file sorting according to if they are weekly or monthly no problem. now im just haveing a problem scripting that if they have a ze3ro balance not to bill them at all. any ideas?

When I set to auto enter a time and date,(Define Database) the time is 14 hours advanced from my system time. I've looked for any kind of setting in FMP and can find nothing. Anyone know what's up?? Thanks, Mel

FMP's "Format" menu allows setting font, size, color AND Line Spacing. But I've only found script functions for TextFont, TextSize and TextColor. Does anyone know of a way to change a field's Line Spacing with a script? Thanks.

First off, I wish there was a better place to post this. I ended up deciding on ScriptMaker, but I could've posted in Layout also, I suppose. Why not have a UI-related forum dedicated to issues related to creating advanced interfaces? I've attached a file that contains my implementation of row highlighting--not for portal rows, but for the records in the layout itself, when viewed as a list. To see it in action, click on Build an Image or the Record a Purchase. You'll probably see the behavior I'm annoyed about pretty quickly if you navigate around in my modal window selecting the software titles. Basically I'm using a global field to store a user's session key,…

As I toggle thru records within a database (using the record icon in the upper left), is there a way for Filemaker to run a script (automatically) as it goes to the next record? example: I have an "If" script set up to "switch layouts" when a certain "field" has a certain "value". But as I toggle thru records, how can Filemaker check the "If" statement everytime I toggle to the next record?

Hi everyone, I am new to filemaker and this forum. anyways, here is my question: I have a drop down menu, I wnat to open a new window by clicking/choosing any tiem of my drop down menu one new window for each item I know there is a script called New Window but do not know how to specify for the script to run when i choose anitme of my menu in the new window I want to have fields and that I know how to do basically it is an inventory, the first drop down menu is a Class of reagents and then by choosing each class you open a new window and you have subclass reagents and other stuff appreicate it a lot if anyoen could please help ame and give me usefu…

I am having a hard time creating an "If" script. All I want to do is: IF a particular field equals "copy that is part of a drop down menu"; I would like to switch layouts (to a layout within the same database). I'm sure this is easy, but I'm having a hard time.

I'll try and describe this as best as I can without all the un-necessary extras. I'm building a small database to contain customer information and some notes but the important feature I want to add is the ability to book adverts in a magazine. I have several tables linked by serial number and things seem to populate correctly. There are obviously multiple magazines over time so I created a table with magazine details in and linked this to advert booked. So the table with the relevant info in links customer and magazine together. Basically I want to be able to create a report which shows all the adverts for one specific magazine. So to cut a long shorty short I w…

Well if I have a list of numbers, something like: I then want to perform an SQL query where a field is one of those numbers, but as the list could be a lot larger, I can't just list the numbers in the query as I'm guessing there would be a limit. So what would be the way to programatically create a 'smart query' so that its something like: If anyone has any ideas how'd I'd go about it or about the limits of SQL queries to an IBM machine then please reply : I'll be doing this in FileMaker scripting, but if really necessary I could add it to our existing VB app which is also part of the system. But any advice even how'd you would do it…

Is there a way to widen the buttons in a custom dialog so my text doesn't get cut-off? Ethan

Ok, i'm using event script to react to the value of a radio button field. The field is empty on a new record and then i am using the value list (approve; deny). I want the plugin to fire off an approved script if its contents are approved and another if its denied. I have it reacting to the field by using a validation calculation as follows (I only have the approved in there so far) If ( watched_field = "Approved" ; S4HU_EventScript( Get(FileName) ; "HelloWorld" ; "" ) ; "" ) Its working and triggering "HelloWorld" but after is says that the field is only allowed to include validated content. I can't figure out how to get rid of that message. The docu…

Ive looked everywhere and can't find this: In Filemaker 5 Its it possible to have a script that will print a blank record? This feature is not available in the "Page setup" menu, but in the "print" feature. I'm not sure how to script this... Thanks.

I'm working on a order entry system in FM6. I'm trying to handle taxes automatically. My logic will review the following in sequence: - tax status for the customer - tax status at the product level based on the province (i.e. State for our U.S. readers ) My idea was to first check the product to see the customer has tax exempt status, if they do, I set the tax status for the line item to zero. If not, then see what the tax status and rate is for the product for the province, then set it accordingly. My script works but not all the time. I have the following databases: price list client req_hdr (order header) req_dtl (order detail or line item) …

Good Afternoon, Im trying to delete Repeated Records, but can't seem to find the right script. Does anybody know how to do this.

I was wondering if it's possible to move a contact from a filemaker database to entourage without exporting to a text file. This is something that would be used for only certain contacts therefore just one at a time. Does anyone know if applescript can do this?

One for discussion maybe? I have a portal that shows records. Based on Month and year. This is for invoicing. I need to portal to show me one of each customer that requires invoicing for the particular month. At the moment I can only get the portal to show all records for each customer, whereas I just need the portal to show one record for each customer, regardless if there are 1 or 10 off. Is it possible to do this? I thought about setting a field in my clients table to say "Invoice" when an order is placed on that customer. Then showing a portal to the clients table which shows clients that have orders against them. I will then only show one cus…

Hi I have a very simple loop. The layout has 110 fields and the script copies the first field and pastes into the next field. It loops 55 times using a counter and exits. It works fine with FMP8 advanced, but when I use fmp8 it crashes. Privledges are the same. Any ideas?

I created a patient database for my wife. I would like to create a backup script that would run on closing the database. Ideally it would keep backup1, backup2, backup3 in a folder and would replace the oldest backup with the next backup. That way she would have the three most recent backups in case the database became corrupted or she accidently erased data. It would be great if it was time stamped so you would know when the backup was made Any ideas? Thanks for the help in advance

This may be one of those "so obvious it's painful" questions, but here goes. Is there a way to easily duplicate a group of records? I tried a looping script, but it was very cumbersome. I also tried finding the records, exporting them and importing them back in, but that's slow.

Hi I tying to figure out if it posable to link to an out side file directiory i.e. in "documents" For example if I have a project sheet (with an Project ref no) and on there I have button link to an file directory which has number folders but only one of those folds has an matching project number to the project ref in FHP project sheet. so FHP finds the related file and opens it...... so the out come is I am using FMP as interface to by file directory structure in "doucment" hopfully this is right forum to direct this question? Cheers Hacky

Hi Folks, I'm deploying a pen based mobile solution (running XP) to handle maintenance. Each Maintenance File uploaded to the mobile has a field called "Status" which will be preloaded to say "Incomplete". To help see what has and has not been done, I would like the status field in the mobile to automatically change color to say, orange as a conditon if contents = "Incomplete". How do I program this so that a.) the field color shifts to orange as noted, b.) and when the tech completes his chore, he (pen based-clicks) on the status field and it automatically changes to the color green and loads in the text "Completed" and while I am asking-- generates a time/date…