Script Workspace and Script Triggers

I'm switching from Eudora to Thunderbird and I just discovered that FileMaker will not run with Thunderbird as the default email client. Now can't send messages generated from Filemaker. Anyone know of a workaround for this?

I have over 2000 contacts in my database and if I send a mass email, I have to click send, one-at-a-time, to send to all contacts in my campaign group. I would like to achieve one of two things: 1. Design a script to automatically save each individual email to my 'Drafts' folder in Outlook 2007 (I've created a script to 'send all drafts' in Outlook). Can I do this with the 'Send Event' script? or 2. Send the emails through Filemaker without having to click 'send' one-at-a-time. I turned off 'show dialog' and now I get an error message from Outlook that requires me to allow each individual email (I don't have admin rights to turn off warnings throug…

i would like to create a script that will auto-email a pdf'ed version of a report to the email address on the report's layout. i have FMP 9. Save record to PDF doesn't give me a way to specify the email address. Perhaps there's a way to combine Print with Mail but manual steps would be required to make the pdf. Surely there's a way.

HI, I am trying to develop a filemaker that can interact with a sms modem. How can I send AT commands to the USB Teltonika SMS modem to send and receive SMS? Appreciate any advice. rgds Jonathan

Hi, I am trying to use "Send Mail" feature from filemaker, but for some reason after I migrate to entrourage the e-mail feature from Filemaker 9 is not working as it was working when I was using groupwise. Any idea what can be wrong

I'm trying to set up automated backup for a client-hosted database, and it needs to be completely independent of user intervention (owner can't afford Server). The database is hosted 24x7 by a OS 10.4 workstation, and has several guests connecting remotely during the day. I'd like to have it run a nightly script to Save As to BackupFile.fp7, then backup that closed file elsewhere. I don't imagine using the Host as a Robot machine (an ever open script on a loop) is going to work. Can I initiate a script via a timer externally through a plugin, AppleScript or Automator Script? I would like to know more about setting up a robot and it's limitations so links to good …

Hello, I am currently evaluating Filemaker Pro 9 to hopefully present solutions to the Executives at my Company. I have been working on different things to show them but I am now stuck. I am looking for a way a Sales person can browse a Catalog of Product and click a button that would add the Product info ( Part #, Description, Cost) to a Quote or Purchase Order. ( Like the way an online shopping cart works) I have created the Catalog and have created the Quote Tables. I also created a table to keep track of items selected as it relates to a quote #. I did also create a portal in the Quote layout and I am able to enter a Part #, press tab and the rest fills in. If …

Hi folks. I currently have a script that finds whatever it is I'm looking for - the following day - just fine using: Get( CurrentDate ) + 1 The problem is two-fold: #1 - I want it to be more intuitive, and react based on the day it is today. Since we only have data for Monday-Friday, I want it to be able to find Monday's data on Friday. This, of course, can be done by using the following command on Friday: Get( CurrentDate ) + 3 However #2 - I want it to pick the appropriate day and "+" number based on what day today is. Does this make sense? In other words, I want a case function that will recognize that if today (the day on which we are …

This is something that seems so obvious I feel I must be doing something wrong but I can't figure out what. I have a field for email addresses. I want to place a button next to that field so that when clicked, it initiates the "Send Mail" script that will copy that email, go to one's email program start a new email document with the email address from the FM database in place ready to fill out things like subject and the letter (by the user) and be ready to send. All I can get is my computer (a Mac) leaves FM and goes to my email client, and stops. Is what I want to do not possible or, if it is, how?

Hi all am looking for some help to make my database force a Re-Login after a certain period of time, say 10 mins, is this possible at all?? Your help is much appreciated. Stuart.

I'm running a script with the debugger running. I reach something that needs revision. I click on the Edit Current Script icon on the top right side of the debugger window. I perform the revisions. And then almost always discover I've forgotten to kill the currently script run in the debugger. Is there a way to prompt FMP's debugger to kill the current script run automatically when I use its Edit Current Script icon? That should surely be its default behaviour. If I edit the script there's surely no point in proceeding further with the current run through the script. Or am I missing something? Kind regards,

I'm fairly new to FMP9. Is it possible to attach a script to a layout, such that this script automatically triggers each and every time the layout is presented? Basically all I want to do is ensure a global field is empty on arrival to the layout. Kind regards,

I have a Text Field and I need to check for a certain word/phrase that may be entered in this text field. As normal find function would work by finding everything within *search* the star marks. I need to be able to do this by using say the IF command... like if "text field" = "*my search*" but obviously this does'nt work.. so is there another way of singling out text without using the find command? I basically need to know if the text field contains a certain word that I am looking for... even if there are more words in the text field.

I have a flat database with, amongst others, a container field called 'Image' and another field called 'Main Photo' which contains the full path to that image (e.g. D:My Documents............014.jpg). I have made a very simple script (attached) which I thought would read 'Main Photo' and insert the image into 'Image' All I get is an error saying that the file cannot be found. I can insert the file 'manually' so I can't see what's wrong. Thanks for any help Photographic_Collection_Script.pdf

Hi, I'm currently working on a offer generator that imports some template text into each field. Sometimes the user needs to erase all info on one given tab. [color:red]How do I identify the fields on that tab and how do I erase text in multiple fields ? (there are different number of fields on each tab - anything from 2-10 fields). I could of course make a script for every tab using "insert text" or "replace text" 2, but since the whole solution contains almost 70 tabs on different layouts it seems silly to make that many scripts. Logically it should be something like this: Identify all txt fields within selected tab Erase all text in selecte…

I have a list of 30 fields that is generated from a database. However, there are not always 30 fields, usually around 15. When I print it for a label, I only want the fields in use to print, not all 30. How do I do this with the script manager? Thanks.

I have a field that already has text in it. I want to use a script to append some additional text to the end of what is already there. Anyone know an easy way to do this other than using a concatenate function to combine the text in both fields.

I'm trying to write a script that will get the date from one field, add 1 to the year and set another field with this new date. It's for an expiration date. When I simply perform a calculation of "date" + 365, it doesn't always work out (leap years, odd months, etc.) Is there an easy way to accomplish this?

What is the easiest way to make the keyboard function keys (F1 through F12) operational to trigger FileMaker scripts? Until now I used a macro software from Macro Toolworks . Thanks for any information in advance. Ralph Nusser, Sogetes Computer-Services www.sogetes.com

I have a script that is designed simply for entering data into an invoice. When it starts, it puts the user in a certain field and pauses. The user enters data and hits enter which resumes the script. They are then sent to the next field, and it pauses again. This continues until they've entered all required data. (Yes, I know about tab orders and field behaviors. This method was chosen for another reason). Here's my problem. I had one of the users test out the system to see how it was working. He did well, but I noticed a couple times where he would accidentally hit enter twice without knowing it, thus sending him to the next field without the prior having d…

I've spent the past couple hours reading through the posts but can't figure out what I need. I'm not a database guy, but I'm using Filemaker to solve a business problem. Currently, I have a backend mySQL database running my ordering website. That works great. But now I need to create a set of tasks based on what products were ordered for internal processing. So right now, using my ODBC connector, I import an exact copy of the customer table and order table from the mySQL db. So far so good. But how do I automatically have filemaker create tasks for me to assign to my staff? We use an application called Daylite for our day to day workflow,…

Hi. Low priority thing here, but is it possible to move several highlighted script lines at once? I find that in long and nested scripts that moving one line at a time can be confusing. I've found no reference to moving several lines at once in Help or the FmPro manuals I have. Thanks, Greg

I'm an old hand at FMP6 and am still in the process of learning the very different world of FMP9 relationships. In FMP6 I could do a self-relationship with a global on the left side, a field on the right and then perform an IsValid(relationshipname) to evaluate whether there was an available match. However in FMP9 I haven't yet been able to find a reliable technique. I've tried both IsEmpty and IsValid. I've also tried both TOs involved in the relationship, and in each TO have tried matches to the global and the target field. In all instances I'm getting negative results both when there should be a match and when there shouldn't. Obviously I'm misunderstan…

I have a very simple script designed to let a user preview an invoice before printing it. The script pauses after entering preview mode, so the user just has to hit Enter to continue the script (which goes on to the printing), since the status area on the left will be hidden. The problem is that it's very easy to imagine a user hitting the X to close the window instead of hitting Enter, and I'm wondering if there's a way to run a script when the window closes in order to catch this 'error.' If there's not, is there any way to prevent the user from closing the window completely? Thanks.

I do not know much about scripts but can somone tell me how to create a script that adds 1 to a number in an edit field so for example iof there was 2 in the edit field it would add 1 onto it to make 3. I have already tried :count field;::count field + 1 to no avail

Hi I assigned to a button a script that open a different layouts in a new window depending on the value of a pop-up menu. The layouts contain different images that i past it directly on the layouts. Since the images have different size i would like to include in the script a step that resize the window automatically so i can see the totality of the image. Any help please.

Hello. I have no experience with FileMaker scripting. I have been asked to convert the "01-May-2008 12:21:55 PM PDT" to a "Month,Day,Year" format. Can anyone point me in the right direction? Or from the kindness of your heart, can someone whip up a script for me?? Thanks a head of time, Joe Young

I'm not a newbie to writing code but I'm a newbie on FMP scripts. I want to create a script that loops a given number of times entering the ID value of the current record into the daughterID field of all the new records. And I want it to put a value into a "phrases" field in each record. Lets say the value of the phrases are "phrase 1; phrase 2; phrase 3; phrase 4". How do put phrase 1 into the first record and phrase 2 into the second, etc? Do I make an array of values in a variable like i have typed above? how do I tell it to choose the (loopcount) item in the array?

I've got a script that performs a find and then prints a record. I've got a find where the Action is Find Records and the Criterion is family::familybalance:[≥.05]. It is supposed to isolate the records where the family balance is greater then $.05, but SOMETIMES it show anyone with a balance. Instead of 20+ records with an outstanding balance, I get 100's of records. Anyone seen this before?

Hi. I want filemaker to send e mails out without using the local email programme on the windows workstation as the company currently uses OWA. I do not want filemaker to receive e mails just send. Each users e mail also has SMTP settings that can be used. However I do need the email to be sent from the specific users account that is logged in, so that any replies come back to that user. There are multiple users on the database at once. Is there any way I can do this, do i need a plug in. Many thanks John

Looking for advice on what script steps I should include in a close file(s) script. I have attached two screenshots: 1. close_script_main 2. close_script_subscript I want to attach this script to all layout in all files that have the word "LOG OUT" on the button. I have over a dozen files, over a couple of hundred layouts and would like one script. The subscript includes most of the files in the system, however, I do not want to have to always edit the list of files. Is there an equivalent "close ALL files" script step? Not all of these files would be open, but in some cases they would be. Also, should I have an EXIT APPLCIATION step at …

Hi guys, I am trying to attach a document (JPeg or PDF etc) to an email using the SendEmail script and then 'Attach File'. The email is created OK in my email client (Eudora) but it doesn't attach anything! Using the Go To URL script and specifying exactly the same file path, I am however able to open the document! The file path I am using is: file:///Volumes/Admin/Booking Documents/Terms of Business/Standard Terms.pdf I am running on a Mac network, if that makes any difference, and the file to be attached is located on the server, as is the Filemaker file, and the Volume is mounted on my desktop. Using ScriptMaker I have tried using the 'Set Vari…

I'd like to store the last FMP account name used on this computer and propose that automatically when logging in. Is this even possible? By default, FMP9 pulls an identity from the computer and proposes that be the FMP account name when logging. Appreciated,

Hello I would be eternally thankful if someone is helping me out on this: As the title line says I need to print on partially covered label sheets. Any Avery sheet for that matter. This is to archive film raw material, which is managed in the database. I understand, that for this I'd need a script. Does anyone have a script for this or could help me out and give me a hint how to do it. Oh and it's for an Apple system. I think it should be possible in Filemaker anyway, as in most cases you don't have to print out exactly the number of labels available on the sheet. I need to print the labels on whereever I want, as the tapes don't come in in 20s or …

Hi, Is there a clean way to check if a file exist? Here is my script: Set error capture [on] recover file [No dialog; "donoterase.fp7"] Set variable [$errorCode; Get (LastError)] Set error capture [off] if [$errorCode = 0] Send Event ["aevt"; "pdoc"; "cmd del "s:donoterase recovered.fp7""] exit script[1] else exit script[0] end if Actually I want to check if a usb drive was connected. So I left a permanent dummy file on the usb drive. Thanks in advance for your help! NB

Hi Guys, Can I get FM9 to resolve the DNS Name of the the Server. I was using statis IP addresses to identify machines, but no we've re-done our network, the techies want me to use the dns names to identify the computers. Is this possible, if so how? Many Thanks Jalz

I have run into an incompatibility between Filemaker Send Mail script function and Lotus Notes v6.5.5. The problem is that the To:, Subject: and Body: data does not map properly to the Lotus Notes email template. This problem has been identified in this forum and on Technet. Several people have suggested using the Open URL script function: [color:red]Open URL["mailto:[email protected]?subject=subjectdata?body=bodydata"] I have tried this and it appears to works but in a limited manner. It appears that the Open URL function limits the number of characters that it will accept. If I have too many addressees or the body text is too long it will not create an …

I would like to build a script that insert a picture into a container field and am unsure on how to specify the Source File in the "Insert Picture" step. The source file exists and resides on a Windows which is accessible via a Mac client. Every format option ( image:, imagemac: & imagewin: ) produces a "100" error. The source file variable is in the format of "//198.16.0.211/INTERFACE/tn_f9ml130.jpg" I'd appreciate any suggestions.

if[Right(fieldname);1)="^"] set variable[$header; fieldname] What I need to do is trim the ^ when I set the variable-- Thus the set variable should look like this-- set variable[$header; ??] If I remember I would use right and trim in order for it to remove the ^. Just can't remember the correct format. Thansk for you help chuck

I am currently working at updating some databases from FM6 to FM9.0 on a Windows XP PC. I have one script that uses Send Event to run a batch file that ftp's a file from a remote computer to the one running FileMaker. It works fine all the time under FM6. With FM9, it worked the first time. Then I closed the program and later opened it again. This time it just flashed the command window very quickly but didn't do anything. After trying several different combinations, I find that if I go back into the script, reselect the batch file to run, it will work until I close the file. Then when I open the file again, it quickly flashes the command window b…

Hi, In a 'price file comparison' solution I have a script which deletes an individual price file and its parent supplier record. Script is as below, triggered by a button on the parent record. My problem is that sometimes there is a delay before the custom dialog is displayed. In this time filemaker is performing a find. The delay seems to be proportional to the size of the price file in question and for long files the 'finding' box is displayed briefly. If you wait for the find to complete, decline to delete the file then run the script again it goes straight to the dialog. This isn't a killer problem but I'd rather cut the delay out of the process, has anyone go…

Hi there! I have just downloaded the myFMButler_DoScript plugin in order to trigger events based on changes in a field. Basically, you call on a plugin script from an auto-enter calculation in e.g. a text field. My question now is: this auto-enter will of course function on all newly created records, but how do I handle existing records??? The auto-enter won't work on old records anymore as this only happens on record creation, am I right? Or have I completely misinterpreted this auto-enter stuff? Please advise!

Odd little problem. Corporation upgrades from Lotus Notes 6.0 to 6.5.5 for Windows XP clients. Breaks a little ScriptMaker script used to compose canned email. Something like... "send mail" To: "[email protected]" Subject: FMS7Table::Some_Subject Message: "Some static text." When the script is executed, Lotus Notes properly generates a new email. LN 6.5.5 properly fills out the Subject: with the correct data. The problem is the other two fields. Nothing is entered in Message:. And the To: field is very odd... [email protected] static text. [email protected] Behaves properly under Lotus Notes 6.0. Nothing on IBM's t…

In FM you can create a script that will open a file. But how can you create a script that will take you to a folder, a path say on a network, a type of "Go To" action, as opposed to opening a file. As of the time of this edit, there were 39 views and no replies, am I to interpret this as this is not possible in FM?

2 files-- Both File Maker Database: Main, Table: Main Database: Export, Table: Export If Database: Export Table: Export Field Name: DESCRIPTION = Database: Main Table: Main Field Name: DESC Set Field Database: Main Table: Main Field: Confirm = YES I would think I would need to do a loop to loop thru table to look for the match. I believe I understand the logic. I am not sure how to call the other database from within the script. Thanks for you help

I created a list of ID's. As the script processes it removes a value then repeats the process til there are no values. During the process 3 values near the end, change their ID values to entirely different number. see attached.I show the step on which the problem occurs and the beginning list and a list in process. 205 135 100 change to 1205 1100 and 135 disappears. I am using variables and wondered if the problem is related to that.. I have varied the script step several ways and the problem still occurs. It also occcurs in other records so it is not the data. It occurs when there over 39 records. Less records being processed there is no prob…

I have not had this happen before and can not understand what is going on. I made a few tweaks to two of my scripts this morning and now every time I click on the button(s) the script debugger opens. I am trying to create a new record within a portal. Why/How is this happening? Has anyone run in to this before? HELP! TIA Al

I find the error codes and particularly Get ( LastError ) quite frustrating. Why? Because Get ( LastError ) can only be used when a script runs. If a script action actually produces multiple errors, which one displays? Example ... you want to set a field by the value in a related table. It could produce error 10 (requested data is missing), 100 File is missing, 103 Relationship is missing, 106 table is missing and ... do you see where I am going here ... there can be multiple error codes for one script action. But Get (LastError) doesn't produce a multiline of error codes; many times it produces none! Oh, I know we can just look for errors > 0 or boolean true on …

Im a newbee and its confusing as to why when i use GTRR single step, to go to a related line item record in a different DB it works fine. Going to the related record in the correct layout(as chosen). However if i try to do the exact same thing with perform script and write a GTRR script with the exact same parameters the script, when viewed with the script debugger seems to do nothing at the GTRR step ? My reason is simply to add a resize command in the script. Am i missing something ? Thanks Ben

I need to make a solution to show the results of a Martial arts tournament. All I want to do is be able to click on the field of the contestant who wins each match and have that data copied to the appropriate result field. I can do it by a simple copy/paste script but that would mean writing 62 separate scripts. I have a feeling it could be done with 1 script and script parameters but I am not clear on the whole parameter concept. Any help greatly appreciated as usual. Thanks Fred WKO_Tornament.zip

I want to start a script with a long pause and allow person to hit [ESC] to cancel the script during the pause. Once the script begins running (in this example at the Show Custom Dialog[] portion, it will be too late. You will see there is option to Continue or Cancel shown in the status bar (attached) but I cannot reproduce this option within the script! I have tried looping; I have tried attaching Halt to the button; nothing seems to work, even with Allow User Abort [ On ]. I even tried two scripts but a pause is a pause is a pause. I cannot use other methods (it is tied to another post and when connection is lost, I cannot trap for errors). So I want to giv…

I have a script that creates an ad-hoc report. Based on global field selections, a user can select what data they want to appear in a report. It works very well, except in a multi-user environment. If two users try to set the global fields and run the script at the same time, the correct data may not come through. Is it possible to pause a script if it is being run by another user on the network?

I use the following script steps to create a backup my FM file that includes the date: Set Variable [ $DateAsString; Value:Right("00"&Month(Get ( CurrentDate ));2)&"-"& Right("00"&Day(Get ( CurrentDate ));2)&" "& Right("00"&Hour(Get ( CurrentTime ));2)&"-"& Right("00"&Minute(Get ( CurrentTime ));2)&" "& Year(Get ( CurrentDate ))&" " ] Set Variable [ $filename; Value:"BACKUP "&$DateAsString&Get ( FileName )&".fp7" ] Show Custom Dialog [ Title: "Create backup"; Message: "Do you want to make a backup of this file? It will be located in the parent directory."; Buttons: “OK”, “Cancel” ] If [ Get ( LastM…

I am try to create a calculation that will give me a report of student count based on the value list of their college level. (freshman, sophmore, junior, senior). I am have trouble trying to work out the equation. Please help.

Is there any way of calculating if a use is connecting to a DB via instant web publishing( IWP )? Get ( ApplicationVersion ) will tell me if the web engine is being used to connect to the database, but doesn't distinguish between IWP or CWP/PHP.

How can one create a carriage return in a script?

I am trying to create a script that will "perform a find" based on the value of a field in the current record. The find criteria will be based on the whatever record is currently "on focus" pardon my access lingo. How do I do that? What do I type in the criteria box?

hello, I wonder if anyone can help - i want to create a script which goes through a set of account balances, identifies which account is overdrawn (ie with a number of less than 0) and then email the account holders - i have the email working, but the script is failing in that its not finding accounts that are overdrawn, its just pulling up all of them - any ideas? : i'm getting a bit confused! thankx

Hey all, Hope you're all well. I am currently trying to schedule a script that will run a script which will find a set of results, create a pdf of the results and then email out the pdf. Easy! I have created a script which can do this with no problems but when i create the scheduling part of it the save as pdf and email functions go. I know i can create a mailto weblink to create the email but i need it to be automated. Has anyone got any ideas?

I have a script that records some information and includes the date (and time) of the recording using 'Insert Current Date". It all works fine when I trigger the script manually. I want to set the server to run the script automatically but I have discovered that when the script is run from the server, the "Insert Current Date" does not work. How can I get a Server Script to record the current date?

I have a database on FM Network. The users access the files by clicking on the FM icon on the desktop then choose "Open Remote" from the File menu. Is there a script or an easier way to access the files? I would like to have an icon on the desktop and when clicked it accesses the files. Thanks.

My question is an easy one, but I am stuck--Newbeeeee : Below is my code, but in short [color:green]I have a variable that I assigned this number--($Counter;)=0000001 I want it to count up one number to 0000002. It counts, but strips out the 0's and just gives me 2. [color:red]How can I have it give me 0000002? Thanks for your time Chuck P.S. How do you copy a script to paste into this board? I had to print as a pdf then do a copy and paste Show All Records Sort Records [ Specified Sort Order: zipcodes::StateandCityCalculation; ascending ] [ Restore ] Go to Record/Request/Page [ First ] Set Field [ zipcodes::StateandCityID; "0000001" ]…

I have a layout with a button that adds a new window that shows a field with a scroll bar. Is there anyway to keep the cursor where I left off in the pop up window when I then click into the other layout? Thanks.

Hello everyone... ...working on a bunch of things at the same time... I have a table PERSONS and a table ORGANIZATIONS. The records of both tables are connected via another table called MEMBERSHIPS. Example: _pk_ID_MEM0004 has the foreign keys _fk_ID_PER0006 und _fk_ID_ORG0003. The foreign key _fk_ID_PER... from the Memberships table has the same entry as the primary key _pk_ID_PER... from the Persons table. When you are on a layout based on Persons you can start a script that takes you to a layout based on Memberships where the script creates a new record. The user has two fieds, _fk_ID_PER and _fk_ID_ORG, and with a drop down list in each field …

I inadvertently opened a file that I was working on in FM 8.5 Advanced with FM 9. When I opened scriptmaker is when I realized I was in FM 9. I immediated closed out of FM 9 and opened FM 8.5 Advanced and the solution. I entered scriptmaker and created a new script. After adding a few script steps I exited the script and then attemped to move the script up the list. When I released the mouse button I did not see the script in the new position. What I did notice was a duplicate of the script that was above where I thought I placed it. When I dragged the "duplicate" script down to the end of the list it changed back to the script I just created. When I move a script…

Okay, so after solving various input issues I'm now focusing on the problem of output. Goal: To be able to print x number of labels off the same set of data (take the information in 9 fields and output into "one label" that prints multiple times on the same layout). Problem: do I really have to duplicate the data for every "duplicate" label I want to print? There has to be a work around, right? Any help or ideas are very much appreciated. -megan

I have a (hopefully) simple problem in this example script, in which I want to copy 3 fields from 1 record in table1, to create 3 new records in table 2.: Set Variable [$counter; value:1] Go to Layout ["table1" (table1)] Go to Field [table1::tab1field1] Loop Set Variable [$currentfielddata; value:Get (ActiveFieldContents)] Go to Layout ["table2" (table2)] New Record/Request Set Field [table2::tab2field1; $currentfielddata] Go to Layout ["table1" (table1)] /*Now FM has forgotten that I had selected tab1field1, so the next command goes wrong. In my mind it should have gone to the second field that I wanted to copy.*/ Go to Next Field /*Now…

Situation: I'm trying to make a series of price summary "templates" in one table and it it to: create a new record, apply a serial number, and copy the desired data to a new record. From this record, a price summary will be made for a prospective customer. I'm trying to make a script using the Create Record function but cannot get it to make the new record in the other table. The template table holds non-modifiable fields. The data table holds the modifiable fields (to change Client name, tax, shipping costs, etc). The field names in the Template table are the same as the field names in the Data table with the exception of _data being added to the Data Tab…

I'm trying to retrieve the active fieldname in a script. Basically I want to record which field the client clicks on, not what value the field holds. Can anyone help? Thanks

I am trying to parse out values from a field called entire_name formatted as (last,first middle suffix). For starters, I want to extract the last_name data but I cannot use the left words function because the last name may have one or two names, ie Smith Jones. What I would like to do is extract everything to the left of the comma for the last_name field, then the first word to the right of the comma for the first_name field. The second word after the comma would be the middle_name unless it is Jr., Sr, II, III, IV, etc, in which case it would be the suffix.

Dim myOpenFile As Object Set myOpenFile = FMDocs.Active MsgBox (scriptPara) myOpenFile.DoFMScript (scriptName) Above is a simple VB code which executes a FileMaker Script. Is there any upgrades made to DoFMScript() to accept parameters as well, which we can pass to the invoked script.

The text of a couple of my Show Custom Dialog boxes have more text than is shown by default, and making it worse, it isn't obvious to the user (that s/he needs to manually resize the dialog). Is there a way to force the dialog to be larger? Ken

Hello, I have a page with several portals. When I run a script than does something in one of the portals ... As the pages reloads, the web browser always going back to the top of the page. As I have several portals, some of the portals are locate further on the bottom and you have to scroll if you want to get back on them. Is there a way to reposition the window on a specified portal/object ? (like you would use an anchor in HTML) Thank you

I have a number of files that I will be importing via ODBC. With each file I need to execute a script to do two thing in another table; create records for new data and update a modified date on existing records. On top of all this a .Net application will be controlling the ODBC import operations. My thinking is that after each import I would have the .Net application create a file with some value that represents the specific import. The .Net application would also call a FMP driver database that upon opening would execute a script that would get the value from the file and run the appropriate import validation script. Is this possible and if so what is the best way t…

First thing is that this script is working fine in OS X (10.5) FM 9.0v3 and fine On Vista when Script Debugger is active. It only fails to work on Vista if I let it run automatically. The issues is with setting a global field to a specific value. Here is how it supposed to work (and works most of the time). From a drop down a person chooses the name of a letter to be printed and presses a button I've defined to print. It the script sets 3 local variables $LetterName, $Contact_ID, $Researcher Opens a new window Goes to Letter Layout Sets Field for $LetterName Sets Field for $ContactID Sets Field for $Reseacher Enters Preview Mode (no auto…

I have a script that replaces the number in a field with with the first 4 and last 4 number with *** between. Unfortunately, it is replacing the numbers in all the records being browsed and not just the current record. How can I, within the script, have it choose only the current record to change?

Hello, Here is the situation I have a script that goes to a layout, checks alls the records to see if a defined field is equal to "1" (number field) and if it is it should delete this records. After it has checked all the records, it gets backs to its original layout. The problem is that it seems that the line : 'IF [my_table::my_field = 1]' is working fine in FMP 9 client, but is not working in IWP. So it always gets to the "Else" statement. I've tried different writings such as 'IF [my_table::my_field = "1"]' or : 'Set Variable [$selected, my_table::my_field] IF [$selected = 1] etc, and none works in IWP. If anyone can help me,…

Hi, I am trying to create a script that displays the records that have their checkbox checked, but am not having much luck. I have created a Field (MSDSCheckbox) as a number field and a Value List (VList1) that shows only the number one (1). I have placed the Field (MSDSCheckbox) on my layout and made the Number Format as Boolean (with non-zeros = Yes; and zeros = No) and told it to get it's value from VList1. I then use the following script: New Window[] Go to Layout["NewMSDSIssue"(MSDSRegister)] Perform Find [Restore] Action: Find Record Criteria: ProductMSDS::MSDSCheckbox:[=1] Enter Preview Mode Print Setup [Restore; No Dialog] Set Zoom L…

I have 5 fields ( f1 - f5) with 10 repetitions (r1 - r10) each that looks like a table. I am trying to move (cut) the info in r3 ( or whichever rep I choose) of all of the fields to a single text field with a couple of spaces between each field's info. I made a script that works for r1 but can't figure how to get the info from a certain repetition across the range of all the fields. This can't be too hard, right? Thanks

Is it possible to skip dialog in a script when a Find doesn't find any records ? (resulting in an empty "found set" but not interrupting the script, Instant Web Publishing compatibility required) Thank you.

Hey all! So Ive been trying to revamp / rebuild a new database and this time I am using separate files to store different information. Most of the things I have learned are self taught by trial and error and I have recently gone over some online tutorials and have a fmpro9 book. I dont really know what to call what it is i am trying to do so im kind of stuck... What I am putting together is a road manager system. Ive got a bulk of this put together with the new things i have learned but here is where i am stuck: Id like to create a new record (show advance) which auto enters a new show id but when i do, Id like to also create a new settlement record (sett…

I'm new to FileMaker, have had some experience with SQL in the past. Because I'm the only one with programming experience at my new job (a fund manager), I was asked to create a FileMaker database to store and valuate informatione about equity titles. I have set up a database with one table holding basic information about the titles. In a related database I store information about the daily values of each of the equity titles (values are only stored for the days that the specific exchange was active). Now I want to calculate performances for a quick overview of the porftolio. I need to calculate things like the stock performance of the last day, the last mo…

Using this http://fmforums.com/forum/showtopic.php?tid/99166 as a starting point I tried to integrate letter printing into my solution. I didn't want to clutter my Contacts table with fields for the letters so I moved the field "LetterMerge" and "gLetterName" into my globals/utility table. Using a Set Varibale script step I take the Contact ID from the contacts table and place that in a global field in the utility table to get the related contact info. Everything is working great when I'm printing a letter for one contact. But I now need to figure out how to print letters for the found set. I thinking using a Loop is the way to go but each time I try…

I have created a simple database by modifying a built in template. I have deleted all scripts in the Scriptmaker window but when I open the file I get an error message that says "The script cannot be found or has been deleted". How can I delete this message? The database requires no scripts. Thanks.....

Please help... Is there an elegant way to gather field data from multiple records and get them into a single variable. I want to move through multiple records for equipment that has been checked out by an individual and what I am trying to do is put the names from all of the equipment records into a email message field. I am currently using 3 variables, 1 to grab the name from the record and the other 2 to bounce back and forth compiling the list. Thanks for your help.

I have a multi user, multi table solution. I am having a problem with users being locked out of running a script because of other users being in the record. In fact the other user is not in the record, and there does not seem to be a reason why the user would have ever been in the record. The problem arises intermittantly. The solution uses only one window. I have put a CommitRecord script step after every SetField script step. Is there something else that could be causing the problem?

A question (perhaps the first of many) I want to be certain that a script is processing the table of my choice. So, Is there a way to "point" or "use" a table that I want a script to affect? Let's say I have two tables - unrelated. ALPHA and BETA. I process all of the rows in ALPHA by entering an "X" into a field called "TAG". Now I want the script to do the same thing to all the rows in BETA. How would I do this in a script? Is there a script step (or series of them) that would help?

I am using Filemaker 8 Pro on OS X Tiger. I am wanting to reference only (with a thumbnail image in FM) images held in a folder on a windows server automatically. The filenames are not sequential. I receive large amounts of data from another DB and flow this data in to FM (so mimicking the DB - the DB the data comes from is unable to embed the images).

Posts 0 07-25-08 08:06 AM - Post#25842 hi, im new to the forums here and new to filemaker, im using 9pro adv. and editing bits of code from the supplied business packages, i have been having a hard time solving an issue i have with moving portal data. I have a jobs database with a portal that displays line items for salewithin a "lineitems" table: quant, item, description,..etc taken from a stock database. the portal has a checkbox at the end of each line to demote that the line is required in an invoice that is on a seperate invoice data base. i have a looping script that reads through the portal and can recreate the desired fields within its own "line items"…

Hi, I'm fairly new to Filemaker, so I might have overlooked the obvious... My goal is: to be able to have the user enter a set of numbers that will generate an output like this: 123°456'789" This will be used to display coordinates (lat/long). So far I can get the "123°" part to work but filemaker won't let me use ' or " as characters and not code. Is there a work around or will I just have to make that a manual step? Thank you. Megan

I have a client that needs to put a music CD into a workstation CD player, and be able to read the music CD metadata (tracks, artist, song title, etc.) and populate that data into a Filemaker file. Then possibly "rip" the song from the CD, store as a MP3 file, then sometime in the future burn it onto another CD. Can this be done within Filemaker natively. They are a Windows house, so AppleScript is not an option. They are record producers, thus process is done for internal research, so there are no copyright issues. Any ideas or experience would be appreciated.

I have created a field which I set up as a button to run a script. Basically when the user select the field the script pops up with a window that asks them if they intend to change the date. If the user select yes, certain data from the record is copied to a separate table because changing this particular field changes dates for several other fields via calculations. The field they originally click on is then blanked out and they can enter a new date. If they select "no" when they click in the original field then nothing happens. The Question: How do I keep this script from running when the user is in Find Mode? Is there a way to say "if user is in Browse Mod…

I have a test field and want isolate only the first characters before the -. ex: 120-1 to 120 or 30-3 to 30 this should be simple but for the life of me, I can't figure out which function to use.

I have a one to many relationship between "main_page" and "Policy_page" (There can be many policies per Main_Page). I have made a script the uses XML to export to word for printing contracts. The problem I am having is when there is many policies under my main page it exports all of them to the contract (I end up with the same number of contracts as policies). I have tried using the Omited script and then show omited but it shows all of the policies in the whole database (17,000 or so). I have broken down where I think I am going wrong -- I have tested the Omited script by it self on the policy I wish to print and yes it does get omited (does not appea…

I have the following script: Go To layout Show all records Go to Record/Request/Page Loop Set variable [$ADDRESSES; value: $ADDRESSES & "; < " & Managers:: Email & ">"] Exit loop If[if( Get ( RecordNumber ) ≥ Get( FoundCount ); 1 ; 0)] Go to Record/Request/Page [Next] End Loop Go To layout Extend Found Set [Restore] End If Go To layout Which yields 77 records. If I add as a new final script step: SendMail (BBC:$ADDRESSES; message: " xxxx") There are only 49 email addresses in the BBC. I am puzzled by this one but I have tried it a couple of times and it must be something basic -- thank…

As a building block for a larger script meant to replace a "find": Go To layout Show all records Go to Record/Request/Page [First] If [Managers::reference = "yes"] Omit Record End If Loop Go to Record/Request/Page [Next, exit after last] If [Managers::reference = "yes"] Omit Record End If End Loop Show Omitted Only A "find" for all records where reference = "yes" yields 20 records in the found set. Using the above script yields 15 records in the found set. What am I missing in this script? Thank you in advance:)

Page is clearly displaying 1 in Preview Mode. When printed it displays as 0. Any ideas? It was working fine a few weeks ago. G5 PPC - OS X 10.4.11 Brother HL 1650

I've searched and cannot find the function of the black dots which appear to the left of fields in the Data Viewer when using the Script Debugger. I have a lengthy script and sometimes they appear to the left & sometimes not. It's a repetitive script and sometimes values don't appear which should. It appears that the Get(FoundCount) function doesn't always produce the expected results.

I'm not getting any replies so I'm guessing my problem wasn't stated clearly. I'm going to try to explain what I need, but please be patient as I'm not that good at this. I have a report that has a summary field of all the pmts taken in for a day. We are adding the form of payment being taken in; cash, check, credit card, money order, or other. This text field is being added next to each individual payment. My boss wants a total of payments taken in by each individual method. So I need to create a field for cash, credit card, money order and other individually to give him a total for each method. I am at a stall as I don't know how to define the fiel…

Good evening everyone..... I have struggled with this one for a while and need some help. I have figured the part below between the << >> now to get this to work. When I am in the "Specify Find Request" dialog how do insert a previously set variable in the "criteria"? I am putting $OrdNum in the criteria box and FMP Literally puts "$OrdNum" in the field instead of the variable. This is driving me nuts becuase it seems like it should be so easy yet I cannot get it to work! I know I must be missing something basic. Thanks, Steve < My Fields are "pkOrdNum" and "PrdID" I want to be to find all Records with a …