Script Workspace and Script Triggers

It seems like a global variable can be passed another script within a given database (e.g. if the parent script calls a subscript with the "Perform Script" step) but not if the subscript is in a related Filemaker database. Is that true? I suppose I'm stuck using script parameters.

Tip: Here's a hugely annoying aspect of the "Show Custom Dialog" script step. I recently wrestled with it and thought I'd post the tip in case anyone else is stuck. When including fields in a Custom Dialog (e.g. "Please enter the amount of whatever you're doing" [amount field]), the data the user enters in that field WILL NOT BE RETAINED unless "OK" is the default button. I had switched the default to "cancel," and kept losing the field info. Switch default to "OK," and option 2 to "cancel," and the info will stick around.

I have a script to get some values upon loading a Record. However, within the script are a few Find()commands. Is there a way to stop the trigger from going when ever the script finds a record? I just want it to load a record, run the script, find the records grab the values required and come back to the original record. Currently instead it loads a record, runs the script, finds a record, runs the script again, etc... Thanks B)

I have attached the script that I have so far. Essentially, I'm trying to set a lot of the fields from the current record and store them as global variables so other records can access them (related fields, but using a calculation field). Logically on paper this should work, but getting this into filemaker is proving difficult for me. The only variable that actually works is the $$RecID. All other variables change. What I mean is that I could start on a record with PatientID = 284, and I want $$PatientID = 284, but afte the script finishes (last line - show all records), the first record's PatientID is now stored in $$PatientID. What am I doing wr…

Is there a way to have the OnRecordCommit script trigger run only once? What i am trying to accomplish is when a new record is added, i would like to copy the phone number field to the PID field and the name field to the SID field. I was planning on using the OnRecordCommit script trigger but i only want this script to happen when the record is created, not everytime a save is changed. If someone where to change the name or the phone number of the record, i dont want it to update the PID or SID. Is there a way to have this script run ONLY when a new record is created? Thanks

Are there any script steps or functions that work with saved finds in FM10? I would like to get the find criteria of a saved find printed on a report. In my solution when a user performs a find, I have a script that loops through each find request and writes the find criteria to a global field that prints at the end of a report. This way the viewer knows what find criteria was used to select records for the report. With FM10 I would like to be able to show the find criteria from saved finds or at least the name of the saved find on reports.

Specifying a name or email address under "User Information" causes an email failure (email(s) could not be sent successfully) when sending through smtp.comcast.net. Anyone know anything about this?

I have a portal, and , if I change the data in the main table, in the portal the value of data have the old value, but if I reselect the data in the portal, iI have the new correct value. How can UPDATE the data in the portal automaticaly by a script? THX andy

When i use Excel i can place VBA code into the Before_Workbook Close event, to establish if there are Other workbooks open. If there is the active workbook is closed. If there are no other workbooks opened, then Excel is closed off completely(exit application). Is there a way to do this in Filemaker? To either Close the file or Exit the Application, depending on whether another file is opened?

Hi pdf files stored on the fms(10) mac server (x.6.2) PDF inserted into container field from local client(s) clients can be either mac or win what syntax should a send event input variable be, in order to open the server based pdf? Local paths send events, and paths from a win server to external win server send events are no problem, but this one is just not working.

Hi all, at first: Sorry for my English. It's not the best. Now to my question. I have a batch file which works correctly. I would like to monitor a folder on Windows Server 2003. FileMaker 10 Server is running on it and I would like to monitor the folder by a scheduled script based on a ScriptMaker-Script. The code is very simple and looks like [color:black]dir c:server_income /b /od > c:dir.txt But I don't know the correct filling of the command "Send Event". How I have to submit the code below to the Script Step? [color:black]cmd.exe dir c:server_income /b /od > c:dir.txt don't work. Could someone tell me how to fill the scr…

I have a single global text field on a layout. The script pauses at that layout for data entry, there is a button there that runs "Resume Script" and it works fine. I ALSO want the user to be able to hit the Return/Enter key to resume the script. That is not working. Depending on how I set-up the field I either get a carriage return in the field or nothing happens... I do this all the time... it works on other layouts... I must have something configured wrong on this layout of field... or is a property of the global characteristic...? Mark

running FM10, I recently pasted an updated script into scriptmaker using a single line "Perform Applescript". It ran for years without a problem, but now I get an error "Parameter is not an object specifier." Why did I get this and how do I get past it? Thanks for any help.

I'm wrestling with resuming a paused script. Background: Script 1 checks user-input fields for blank entries; if found, calls script 2 Script 2 opens a window with an explanation of the problem, a field in which to enter text for input into the blank field, and a "Cancel" button [script 3: Close window, halt script] and a "Correct" button [script 3: Close window, return text to appropriate field]. Both buttons resume Script 2. Problem: I would like to have the ability to resume script 2 not only from the Cancel or Correct buttons, but also by a script trigger (on object Save) from the field; this would allow the user to avoid reaching for the mou…

I'm trying to see if this is possible. The scenario is: - I have a record that has a text reference to a file on my HD - I have a small graphic that shows this - I want to drag the graphic into a finder window and have the file automatically copy into that finder window (Drag/Drop). I know I'll need applescript for this also which isn't a problem, but I'm mainly wondering if this is even possible with FileMaker. Has anybody had any experience with this?

First off my background is 20 years developing applications in high level language, less then 6 months working in FM and 3 days trying to use Applescript. My current situation is to try to integrate AS with FM to auto create folders for use in our companys "ERP". The DB I have setup has the AS in a calculation field, there were no errors when I finished setting it up. The DB contains 4 fields... 1. FolderPath Text 2. SubFolderPath Text 3. Program_ID_Serial_No Text Serial Number on creation with Current Value: “PGMR00486” Increment: “1” 4. _cFolder_AS Calculation (Text) Unstored, = "tell application "Finder"¶ If not exi…

I need a script that will allow me to close all active or visible windows EXCEPT the one that contains LAYOUT "XXX". The isssue is the script may be started from that layour or another (depending on usage at the time). If is starts on ano other layout that "xxx" no problem. But, in I am on Layout "xxx," how can a select "any other window" in order to close it??? Any thoughts woule be apprecieted.

I am very new to FMPro, but I have created a pretty basic contact management database with 800 records. I use it for new business, and I want to click on a phone number and have Skype call out. I have tried it 1000 times using Open URL, which is suggested on the internet. Would anyone mind posting a few idiot proof steps for a newbie. Assume I have brain damage. Thanks so much

< form method="post" action="save.php">

Hi all We convert all of our material test reports into PDF format, change the PDF name to a unique name and stord them in a folder. I have a container field on the input layout to link a record of the material test report description to the actual PDF record in the folders. To creat this link, we are doing it manually by chosing the insert command from the menu and then chose the object selection and from the pop up window the user chose the options create from file. Then the user press the browse button and then select the correct PDF for that description. I would like to script this step but when the insert command is chosen and then the specify block is checked…

I've added an 'add note' script to take the username and date and add it to the top of a note field. The cursor correctly positions itself under this entry and all the previous notes are copies below it. However, if the notes field has more text than is visible without scrolling in the field, the cursor stays at the bottom of the text. Also, this feature does not work at all using IWP, so how would I achieve the same result? Any ideas

Hi, I just finished my first script of more than two lines It's loaded with "else if"s and I was wondering whether there is a way to make the script more efficient. Here it is: #Subtract from "From Account/Add to 'To Account" # If [Transactions::From Account Type = "Spending" and Transactions::To Account Type = "Expense"] Set Field [budget::Current Balance; Budget::Current Balance - Transactions::Amount] Set Field (Budget 2::Current Balance; Budget 2::Current Balance + Transactions::Amount) # #Variation for "From Account" being Spending and "To Account" being Savings # If [Transactions::From Account Type = "Spending" and Transactions::To Account Typ…

Hi- I find the perform find script step baffling, and filemaker help is very vague on the subject. Specifically I want to include in a script a search for records where a date field contains a date that is older than today's date. I have a current date field also, but no option seems to exist that allows me to set up this simple search. What am I missing? Thanks Jondb

Hi, all How are you? I have a question on counting function. I want to count a keyword in the articles. Do you know how can I make a script for counting words or phrases? For example, I want to see that how many times "Food" keyword include (or is counted) in each news article and whole news articles(a month or a year. and which one is better either wordcount or patterncount? Thank you small_Converted.fp7.zip

Is there a script call that will allow you to copy information to the windows clipboard? I have a client who in their previous software was able to hit Ctrl-P and it would copy the record's name, address, city, state, zip and phone number to the clipboard, so all they would have to do when they wanted the info would be to open word or their email and paste it in without typing it out. Is there a function that would allow me to create a script for a similar behavior. Wouldn't necessarily have to be Ctrl-P, any shortcut would be quicker than typing the information out. Thanks

I have discovered how to manually duplicate a found set (to the clipboard only), is there a way to truly duplicate a found set & automate it for a script step? thanks for any help in advance ;-)

Im wondering if anyone has any thoughts on the best way to stop a user importing the same file (via a script) more than once. The file is a .csv type.

I'm looking setup a shortcut on a windows desktop with a URL pointing to my IP and database, eg: fmp7://0.0.0.0/Database With this in mind, I would also like to pass it parameters such as a record ID. Is this possible? If not this way, another? Goal: Open a FileMaker database remotely, pass it a parameter and run a start up script immediately processing that paramter Example: Open Client database with parameter ID=1, query record where ID=1 on open. Thanks for any feedback!

hi everyone i am a doc i dont understand filemakers 98 percent scripting and about algorithms it will take another life to understand i want a script that can create keys based on mac address of the system using my database and so that i can use this script in my database so as the client who buys my database can access only when he enters mac address and corresponding key pls help me is it possible :(

Hi there, I'm new and not sure how to properly say this, but I have a drop down value list that i want to be able to display multiple choices from in one field. ie. drop down-choose, drop down-choose again, repeat "x" times. I want all the choices to be displayed together in a separate field comma separated. Does this make sense? Is there a scriptable way to do this? Thx "LIT"

I have layout with a portal and if you click a record in the portal you will see another layout (to change record). In "normal" Mode I'm using "go to related record[other layout]", no problem. Now I had to modify the script for IWP mode: Write Records/Request[] go to related record[other layout] And it doesn't work. It shows always the first record in the table and not the record I've clicked on. But if I remove the "Write record/request" it does work. I don't understand why my script doesn't work! by ChiSao

is it possible to change the passwords predifned within a script at a predefined period pls help

I’ve got a client who, when creating emails directly in their email program (Apple Mail), includes their logo after the textual part of their signature line. The client wants to do the same thing when using emails are sent from FileMaker using the “Send Mail” script step. I’ve been putzing with the Send Mail step with no luck. The file attaches easily enough but doesn’t appear at the end of the text in the email. I’ve played around with the signature settings in the email program which can easily include the logo in the signature IF the emails are created by (or within) the email program, but the FileMaker-created emails don’t inherit the “automatically apply m…

I'm updating a contacts database to have portals for each contact to display his or her local weather and time. Currently, I have an update button on each record that updates correctly. I would like to use the OnRecordLoad trigger so when I move forward, backward or a find, the record will update the weather and time. The problem is that when I set up the OnRecordLoad trigger to launch the update script, when it is completed, the screen refreshes which triggers again. I end up having a hourglass sit and blink until I hit escape and get out of the layout. Is there a better way to update this? Am I using the trigger incorrectly? Please offer any…

few days back i saw expiry script in this site now where it is i forgot i want auto expiry script pls help me i forgot script steps :(

Hi all I would very much appreciate some pointers on how best to achieve the following: I would like to be able to produce a "proposal/quote" document. In my db at the moment there is an "estimate header" table and an "estimate line items" table. A proposal document has the following sections(structure) Intro Restatement of customer objectives (text - this could be more items in the line items table) Summary of costs (a table with 3-5 rows)eg: Software----------value (total of software line items) Hardware----------value Services----------value Development-------value Total-------------value Not all sections appear every time …

Hi, I'm not able to solve a simple problem, due to my lack of experience. I have tree tables: Table1 --< Table2 --< Table3 I would like a button on layout1 (table1) which looks for the latest record on table2 MAX(table2::Date) returning the ID of this latest record. Or in other words: GET/RETURN table2_id where Max(table2::Date) Why? With this button I would like to create an new record on table3 which is related to the latest record of table2. So I need to know the table2_id Thx for any hints by ChiSao

I want to be able to have the layout change if the user picks a choice in a drop down menu. I tried to script it but can't figure it- Pseudo script: If (custody = "Non-Custodial"); Go to Layout [Referral] Else Go to next field **in the current layout's tab*** End If But I can't get it to work? The trigger is choosing the answer in the drop down menu? I looked up script triggers for layouts-but the layout setup did not have a Script Triggers tab Thank you in advance.

I am wanting to set a value list to a field on a object exit when selecting another. A small example scrtipt would be really appreciated. This needs to happen on the fly as the value lists could be one of many depending on the value selected. This can not be done via relationship driven conditional value lists. If this is not possible I think it may involve changing layouts dependant on the value selected.

in a found set i want to replace the value of serveral fields with a value tha in in the paramaters ($para1; $para2,$para3,....) what is considered as best practise (works faster) working with a loop function: loping trough every record in the foundset and replace the value with the "set field" scriptset example: Go to Record/Request/Page [First] Loop Set Field [Table1::field1; $para1] Set Field [Table1::field2; $para2] .... Go to Record/Request/Page [Next] Exit Loop if [Get (RecordNumber) = value] End Loop or with the "replace field script set? after i have sorted the found record set example: Replace Field Contents …

I am wondering if it is possible to write a script for this... it is pretty cosmetic really, not too important if I can't get it to work. When viewing a layout in Table view, you can click the "modify" button and uncheck several fields to hide them... this is temporary, I know it returns back after you close and open filemaker... which is fine. What I am wondering is... in a script can you have it uncheck these boxes for you. I want it to have the same behavior... temporary... I just need a function, based on certain conditions (probably using an "if" statement) will uncheck a field box in that tab. Possible? Thanks!

The previous version of our filemaker application runs on a single amchine ( Filemaker v10) in this application we had a script who made a selection of records and saved this pdf file on the harddisk of that PC (in the scriptstep we had the relative path file:kitchenprojects/$filepath which saved the pdffile in the folder kitchenprojects on the hard disk of that PC; $filepath is a variable that gives the pojectnumber. so far so good. Now we installed a server who linked together the PC's from our store in a small LAN. On this server we had a "common" drive on which all the pc's had access to and were files of general interest were placed. On this ser…

I have a script that opens the "Insert File" window. I'd like to add the folder the file can be found in. "Specify source file" doesn't work, because I need a designate a file there. So what I want to be able to do is to specify the source folder. Does anyone know how to do that? Thank you!!

Host has inserted a masthead pic in Illustrator (vector) eps format and printing/PDFing works fine for this user. However, any other user cannot see the eps image nor print it. Why? The host is using FM 8.5 and the remote user (either on a network or via internet connection) is on either v8.5 or v10. Jpeg format seems to work fine but does not output text as crisply, so I would like to get the eps option working. Any ideas?

Hi Everybody, I need to "throttle" a server side script by somehow inserting a Pause for X seconds into a loop. I see that the Pause Step is unsupported server side. Any ideas?

I use a script to compile the previous weekly report info. Is there a way to make it change the excel file name when it exports so that my data in excel isn't lost? Ideally i want a separate excel file for each week.

I have written a small invoice solution in Filemaker 8.5 Advanced. There is a description field for each job that's shown and when they appear on the invoice layout, the sliding/printing means the rows only take up as much size as they require. However If there are too many entries or too many lines of text on some of the descriptions, the final invoice page can go on to a second page. I don't really want this to happen (filemaker doesn't seem to deal with headings well on more than 1 page) and would rather a warning appears as soon as the descriptions go above a certain amount of lines of text. Is there any means of easily calculating the number of lines …

How can show a page count for mulitple reports in the same found set. I have a script called "Quote", I have it so user can choose to print Current Record only which would just produce one quote report, or user can choose print Current Found Set which would produce a quote for each record in found set. I'm currently using (PAGE ## OF <>) for a page count, this works for Current Record only, but NOT for the Current Found Set. Sense glb_page_count is set via script; go to record; last set field (glb_page_count);## go to record; first So of course this will not work when there are multiple reports. Sorry for any confusion caused do to my poor t…

I want to use Open URL to open a pdf file. It works fine if I use the complete, absolute path name. But it fails when I try to use a relative path name. I want a relative path name because the pdf will be a help file in a runtime solution. I want to have the pdf file in the same folder as the database. Can someone tell me the correct expression for this.

I am writing a db to analyse our company's itemised billing for mobiles and I want to provide a flexible search on period (i.e. month, not between dates), user (or number) and call type. I have created Value Lists of these and defined Global Vars which display as Checkboxes of the lists. So idea is create find, select one or more month periods, one or more users and one or more Call types then execute the search. However, as there are quite a few users I wanted to be able to set the global var for users, say, to everyone. But I cannot find a way to SetField g_Users to the contents of Value List "Users". Any ideas? Or am I making this difficult for myself? …

I have a pull down field that has a calc trigger using that ziffscript The next field is also pull down with zippscript that gets triggered It seems some how, if I select wrongly in the 1st pull down field or use its default the 1st selection Then I click on next field it also has a trigger to a different script The previous script is still active viewing the debug stepping menu How would one close an active script from another script or window.. like the Close Window... I can choose the window from somewhere else TIA Then clict

According to FM Training Series "if you specify a file path/name for output (either explicitly or by a variable reference) and do not select a field to export, that file, if it exists, will be deleted from the user’s workstation" Does anyone know why the DeleteFile script in the attached sample file does not work? The file path comes directly from the original import file path. TestDelete.zip

First let me say that I am using FMDev 6. I need a script step that checks the current found count and then either runs the script or shows a message. I only want the script to run if there is one record in the found count. otherwise I show a message that tells the user to refine their search. I am using an If/else statement in my script, that's easy enough and I tried to use "setfield" to grab the number from a field called "currentfound" but after reading the help on "setfield" that isn't the one to use. Any ideas? remember, I am using FMDev 6. thanks Todd

Working for years in Filemaker up to V5.5 I have now jumped to V10 and am failing at my first hurdle. In am combining everything into a single file using tables where I would used to have used several different files. I have a file with a table called 'clients' and a table called 'Policies'. There are three different layouts to display different policy types depending on a field value. Policies for each client are displayed in a Portal view, a button on each row runs a script. I am using the GotoRelatedRecord step to show the record from the policies table and selecting the layout from a calculation based on the contents of the policy type field. I have used case as wel…

Is there a method within Filemaker 10 that will allow me to display the contents of a folder (Windows platform) that might contatin word documents and PDF files and then double click those objects to launch the associated application? I would like to maintain a folder for each 'client' in a database and be able to access that folder from with the Filemaker database. I have seen some plugins available for earlier versions of Filemaker but am wondering if there is a 'built in ' method in Filemaker 10?

Hello, We had a FM database running on Filemaker 10 Server Advanced (but the problem also happens in Filemaker Pro 10 Advanced on another computer. It was sending e-mails through SMTP in some scripts. Since last week-end, the scripts display error "Mail could not be sent successfully" ? (code: 1506 if I remember well) The network admin says he hasn't changed anything to the mail server. How can I get more details about this error to know what's going on ? Thank you.

I currently have a phone number field in my database which is in the standard phone number format = xxx-xxx-xxxx I have a script that will copy the data in the phone number field into a PID field which works, but i was wondering how i could script this to remove the hyphens. So for example the phone number field would read 123-456-7891. Once copied, it should read 1234567891. Thanks

I have a database that has a notes database attached to it that is viewed through a portal. This database is used for a help desk so they record their notes as they are on a call The notes database records the creation date, time, user, followed by the users note. What i would like to do is keep track of the length of the call using the notes. I know i can do this by creating a timestamp for the start of the call, a timestamp for the end of the call and have a 3rd field that will calculate the difference which will work, but i have come across a snag. If a user is entering a note and needs to go back and look at something on the record that requires them to…

Sorry if this is a dumb question but I couldnt find the answer on my own. Is there a way that as soon as filemaker opens up i can make all the databases that I use open up on their own? Like is there a script I can add to filemaker on start up that open up all my files?

I'm creating records in FileMaker via JDBC using a Java Applet . After the record is created and populated - which works just fine - I need to trigger a script to do other processing of the record. JDBC and the SQL query language does not appear to offer any way to do this. FM10's Script Triggers are object specific so that appears to rule them out. I can think of work-arounds like using a timed script, but I want the post processing to happen immediately before a user get ahold of the record. We're using both FM9 and FM10 with various clients who have this solution so ideally the answer would not be 10 dependent, but if there is a way to do it with script triggers …

TableNames ( FileName ) will get all of the Table Occurrences. Is there a function or method to get the Table Names?

Hi, I've created an offline 'cut-down' version of my db so users can wander around with their 'Netbooks' collecting data before coming back to the office or any wireless connection where they can synchronise with the server. I've created this 'huge' script that steps through the various fields that have to be copied to the 'offline' db and I have used variables to store the data from the online db and then 'set field' to copy the data to the offline db. Does anybody know of quicker way to do this? Perhaps have some kind of label to denote which fields require up date to the offline db and have a loop to work through them. I suppose I'd need some kind of t…

Is there a way to select which script to perform based upon the results of a calculation. For my cabinetshop I have various scripts that are germane to specific cabinet styles. Script B6, for example, lists all the parts for cabinet style B6. Script B5 lists all the parts for cabinet style B5, etc. Is there a way to have scriptmaker call a specific script based upon the particular contents of a field?

HI There, is there a way to capture a get(lasterror) to use it later in a script? want to put the error in a log of errors for the process... Thanks in advance for any suggestions. Constance

Hello. I have a Filemaker script which basically does two things: 1) runs a calculated applescript to create a PDF of a web page showing information specific to the record being viewed in the DB. 2) uses the Insert File script step to put the PDF into a container field. Usually this works well. But sometimes, it takes too long to create the PDF, and step 2 gives an error saying "This file is locked or in use". When that happens, the only button in the dialog box is OK, and when the button is pressed, the script proceeds without having inserted the file. I want to prevent that from happening, but I haven't been able to find an acceptable solution. I've tri…

Hi, could someone please tell me if there is a script or plugin available which will calculate the longitute and latitute of a specific location based on the postal address fields. # I'm happy to pay for this solution if necessary. Thanks Laurence

I have a script where the last step is Go to Field. The field has a scroll bar and contains more info than can be seen without manually scrolling. Is there a way to have to have the script automatically scroll to the bottom of the field? Thanks

Is there a way (inside FileMaker rather than going out to a VB shell) to specify a variable script name. For example, I want to have a field in a table that says if Record 1, then run the name of the Script in Field "Script"... and so on for Record 2, run the Script in the Field "Script". I could build an elaborate VB script to do it... but is there a way inside FileMaker? Thanks, CCB

Hi, Not sure if this belongs in this forum or the find forum (mod- please move if necessary). Ultimately, the purpose of the script is to eventually return census data based on the postal code of a client (and in turn other clients in the same area. To broaden the postal code search foreventual web search (a potential question in the future), this is done by stripping the last 4 characters from the postal code...this is easy enough (eg. using the left function with 3 characters specified, postal code Z9Z 9Z9 would become just Z9Z). The big question is the proper process to copy the original postal code from the original postal code field, apply the left function (s…

How do I have a script run x number of times a day. This is in filemaker 9, importing via ODBC to update our parts list. I know how to have a script pause a certain number of minutes and then continue but I want to it to do this in the background. Thanks, Caroline

One of my automated scripts are stopping when no records are found during the search phase. From time to time it will not be able to find records and is normal. But is there a way to set in the script to continue on even if nothing is found instead of giving me a screen where I have to manually select continue? Script image attached.

I am helping our local community theater company with publicity. I have entered all of the publicity contacts in a database and set up a script to print a personalized letter to each person. Everything is working fine except that the letter is two pages and the script only prints the first page for each database record. The database has two layout pages: one (called Master Database) that includes all of the records for those we want to send publicity announcements to. The other layout is called SnailMail and includes fields used for the contact name (pulled from the Master Database layout), the date, and the body text of the letter. The text of the letter is physica…

I am wanting to remotely open (on FMServer 9) a variable file name. I start with a VB Script opening a shell FM9 database on the local PC. Since a VB Script can't open a remote file, the VB Script is designed to pass the local shell database file the name of the remote file and the ip address of the remote server. I then build the name in a variable called $OpenFile. One of my names looks like this: fmnet:/10.8.30.100/ArtaCustomer ...problem is, I am trying to put $OpenFile in the File Path List under Edit Data Source... and it does not accept it. Any ideas?

Hi All, super newbie to FM Pro I've created a very simple sales database by modifying the contact management template to suit my data. However, my sales lady wants the functionally of putting in Outlook Reminders via a FM Record based on the date/time she specifies? Is this even possible?

I have a button beside an email field set up to run a script to send an email to the email address contained in the field. The button works fine, launching outlook and a blank email form containing the email address from the field and the subject I have specified. However, it doesn't pick up the signature I have set up in Outlook. Is there a way to instruct the script to launch an email containing a specific signature from Outlook - either by using a particular email account, or by calling the signature itself? Failing this, is there a way of putting a signature in the script itself? KB

I have a applicant table and want to move the resume out of the applicant table. I solved that problem. But now I need a script that goes through every record and goes to the resume field copy and paste that and then pastes it outside resume table. I assume I have to use the record id number and use the corresponding id number for the resume record. Can anybody help me? Thanks Frank

I have a layout currently that has a field on it, that if that field has a value in it, the user must click on a button to open another layout and enter all pertinent information for that record. Problem is, they forget to click the button. Can I use script triggers to ensure they click the button if the field has a value in it. Or should I post this question in a different forum category? Thanks

Hope you can help me out on this one. The script below generates a new record in a child table (i.e, Consultas) and automatically inserts a matching ID field, allowing the user to cancel the request, if necessary. So far, this works fine. However, I need that serial numbers of records in the child table are sequential for any given record in the mother table. The script is working fine in sequencing the serials but for ALL the records in the child table. I need to find only the related records with the mother ID record. The script is not able to find the defined set of records to perform the FoundCount function. I am really stuck, I would appreciate your he…

I have the following script. This is my first attempt to create a Play/Pause toggle. I can get it to Play, of course, but Pause not so much: If [ jotts::playPause ≠ 1 ] Go to Field [ jottmp3s::mp3Play ] [ Select/perform ] Set Field [ jotts::playPause; 1 ] Else Set Field [ jotts::playPause; 0 ] ? End If

Yes, I can import html files by using the Import-->File...-->Tab-Separated. But when I try this with a folder, FM gripes it isn't the right file format. I need to automate this process, as I have several hundred pages to import and parse out. Is there a way to do this?

Is it possible, through script, to move an object (up, down, left, right) on a layout. For example if a text box is located 2" from the top of layout form, I would like to be to move it to 2.25" using a script. Is such a item possible?

Hello everyone, I would like to start off by saying that this is my very first post and I registered here specifically for this problem :. Here's my situation : I access a certain website through a web viewer. This website has a lot of numerical data on it that I would like to import into my solution. It would be too much of a hassle to use the GetLayoutObjectAttribute (objectname ; "content") approach because I would have to loop through hundreds of records and scrape all the data off the website for every single one of them. However, there's a link on the webpage to a csv file (aha !) containing all the necessary data. Clicking on this link automatica…

I have the download url's I need, but I now need to download the actual file and then add it to a container field for use. Is there a way to do this? Thanks.

Is it possible to set a script to run on a specific date and or time delay from last script run. I would like to set a script to run at the end of the week showing me a report of data entered into Database and if possible emailed out. Would this be easier or possible to tackle thru FM Server?

I need to make a script where I can switch between 2 printers. The first print should come out our color printer and the second should come out of our black and white printer. When I use in my script the commando print and I selected a printer and later on in the script i use again the commando print and I select they other printer, both settings become the same? Is there anybody who can help me?

I have a number of files on my fm server. On workstations I have icons, each that has the ip address and file name to open (that's how they get open remotely through clicking on an icon). What I would like to do is have a small routine where a listing of a number of files come up, the user clicks on the file to open and the script translates that into a filename to open remotely. That would obviate the need for multipme icons on a screen. Click on one icon and then choose the appropriate file to open. Ideas? Mike

Hello, I have a db that tracks the hours worked for “hourly type” employees. My goal is to have the data entry populate a form. The problem is I can’t get all the entries on 1 form, when I do the script- it creates a form for each entry. Attached is “watered down “ version of the database. Any insight would be greatly appreciated. Thanks in advance HoursWorked.fp7.zip

I'm trying to get the status of the Get(LastMessageChoice) after performing a PRINT SETUP command in my script. I've tried to accomplish this two different ways 1] An IF command testing the Get(LastMessageChoice)as the script step following the PRINT SETUP command 2] An Insert Calculation operation of the Get(LastMessageChoice)following the PRINT SETUP command Both tests always result in a value of zero [0]. I'm expecting a '1' if OK and a '2' if CANCEL. I have no problems with this approach when using a custom dialogue box, only with the system provided PRINT SETUP command.

I am using the following script: ignore the commented out parts - those I will turn on once I figure out my issue below... // Set Variable [ $found; Value:Get ( FoundCount ) ] // If [ Get ( FoundCount ) > 250 ] // Show Custom Dialog [ Title: "Over 250 items to be selected!"; Message: "You are selecting " & $found & " records to add. If this is correct please click Add, otherwise click Cancel"; Buttons: “Add”, “Cancel” ] // If [ Get ( LastMessageChoice )=2 ] #run if they choose ok to over 250 Set Error Capture [ On ] Enter Find Mode [ ] Set Field [ Art Database::selected; Get ( AccountName ) ] Perform Find [ ] Show Omitted Only Replace …

Hello all, yes, I am still new to FM10, and I get hooked on it. I have developed a collectors database, and like to make a demo available. BUT, I want to be able that a maximum of 10 records can be made. Is there a script ? or is this function within FM10 ? I am a little stuck and I am thankful for any help. cheers,

Hi. I am looking for help writing a script. I have 3 fields in my database: "job number", "ordered qty" and "finished qty" Each of my records automatically generates a job number, everything else is filled out. I'm looking for a script to do the following: If the "finished qty" is less than the "ordered qty" capture the job number from the record, create a new record and insert the job number plus an hyphen 1. Then take the finished qty minus the ordered qty from the past record and insert it into the ordered qty field in the new record. If the finished qty is equal to or more than the ordered qty then do nothing. Ideally, i would l…

I'm trying to have a script that prints a variable quantity of labels I have a field quantity Copy [select; Back Label Entrv::Quantity] Paste [select; Back Label Entry::count] Loop Exit Loop If [ Back Label Entry::count = 0] Print[Restore; No dialog] Set Field [ Back Label Entry::count - 1] End Loop The loop doesn't end. It just keeps printing. If I take out the Print step it counts properly. I'm stuck! Any ideas?

I'm running a FM back end with a relationship to an external MySQL table, in this case users_mysql. Is there a way to trigger a FM script whenever a new MySQL user record is created? All I've been able to think of is to have a get( found count) field and then run this throughout the day: If $$recordCount < $currentRecordCount and run the script if it's true. Thanks for any thoughts...

I've attached a test file which shows multi-user tests on record locking. I've modified it for stand alone by using a new window to signify a different user. The script shows that Get ( RecordOpenState ) can be deceptive in what it produces and I now understand that its purpose is to test the CURRENT user's possession status and not the actual state of the record itself. In script called TEST, it produces a 0 to the current user (in the new window) but shows a 2 to the original window (1 being they are creating new record which isn't yet committed and 2 being they are modifying a record which isn't yet committed). I am posting with two related questions... Questi…

I have a layout, which is pretty basic. By choosing some global variables, then clicking "save" it will increment a count in the table for that day. Multiple users will be using this... where I am seeing some issues, is if 2 or more people click the "save" button at the same time... it will still execute, but give them an error message about locked record, until the other person finishes. Is there a command or step in the script that can accomodate if multiple users try to run the script at the same time, without flagging any errors?

Is there a way to include a scriptparameter with the script "go to field"?

I have script A. Is says: .....Process New Window Goto Layout ["Review Data"] Pause/Resume Script [indefinitely] .....Continue to Process I execute Script A. It gets to the Pause. Now I am on the "Review Data" Layout I have A Button on that Layout. Button A Prints the Layout via a new script called "Print Layout" I really want Button A to Print the Layout, Close the "Review Data" layout and resume Script A. If I add: Close Window Exit Script to the Print Layout script, it does close the window, but it only exits the Print Layout script (which would happen anyway) Script A is still paused. How do I automatically …

Hi there, I have a solution in which a user is brought to a found set upon startup. I'd like to inlcude a search box that constrains the found set as the user types, and reverts back to the found set as the user backspaces or clears the search box. I want to constrain based on all the fields on the layout. I've seen examples of this done with a full data table but I'm not sure how to approach it if my starting point is a found set. Could anyone suggest how I should approach this problem? My thinking is: 1. save the found set somehow in a variable? (?? how) 2. as the user types perform a find/constrain by finding across multiple find cr…

What I'm trying to do a s part of a larger function is get filemaker to save a .txt file with a name that is generated by the contents of a field. For example: I'm tracking vehicle license plates, I input a license plate "ABC123". What i want to do is have a script save this as a content as a txt file, and name it as ABC123. Is this at all possible with filemaker scripting? I know I can save the contents, but naming the file is the issue. Thanks, Ron

I am in the darkness of trying to use Send Event to trigger a .bat file and I am humbly begging for a torch. Here is what I am trying to do.. I have get_filelist.bat file located at Server Namec$Program FilesFileMakerFileMaker ServerDataScripts that triggers another .bat file and performs some file manipulation on the server. get_filelist.bat works perfectly when i remote desktop into server and trigger the .bat file or trigger it via server scheduled event. The last step of get_filelist.bat is to produce Server Namec$Program FilesFileMakerFileMaker ServerDataDocumentsfilelist.xml. I have a script in an .fp7 file served on the same FMP server called get_fileli…