Script Workspace and Script Triggers

the 'beep' script step doesn't work for me. it's something i haven't used in a while, so i'm not sure if it has ever worked in my v10 copy, but at least it doesn't beep now. all my other alerts, system beeps, and other audio plays fine, so i don't think it has to do with the general audio setup. any ideas? thanks, stefan

Hello guy's I have a question. as you can see on the image the layouts shows the records of current year 2011. i have a script that allows me to go to the next year (script on the image), but if the layouts shows the current year i want to prevent that the scripts stops because there are no records at the moment of year 2012. I tried something but nothing helped, how can i do this? Kind regards, Serhat

Is anyone aware of a syntax variation for using the Minimize Window via applescript? I am able to make "Hide Window" work but not "Minimize Window". The first of the following tell statements works, the second does not. Any ideas? tell application "FileMaker Pro" activate do menu menu item "Hide Window" of menu "Window" end tell tell application "FileMaker Pro" activate do menu menu item "Minimize Window" of menu "Window" end tell Thanks, May the Lord Jesus Christ bless you unto salvation through faith in His work on the Cross!

Hey everyone, I am looking to get some advice on how to define a script-trigger that will automatically delete records that have the "AmountOnHand" field = zero. A little background on the reason i need this solution is that my database manages chemical inventory. Each chemical has a particular lot #, therefore each chemical ingredient needs a separate record. This creates the problem that when we use up all of a chemical the record still remains,even though we are using an ingredient with a different lot #. I've thought about running a weekly report that finds the set with "AmountOnHand" = zero and then deletes the found set, but anyone have any suggestions or a be…

Ouch do I feel stupid. I finally found the 'Open File" step after looking over it for 2 hours. Oh, well I will just chalk it up to age. Hello, I think this is a scripting question? I was given a new database from a teacher so that we can track room scheduling a little easier. We have placed this database on our server in the same folder as our original Student database. What we would like to do is have a button on our Student database that would open the Room Scheduling database when clicked, but we can't seem to find a script step to make this happen. We thought that the Send Event script may be what we need but it seems to try to find a…

Hi All, Originally my solution used a global script to center any opening window on the screen using this calculations: Round(((Get(WindowDesktopHeight) - Get(WindowHeight)) / 2); 0) and Round(((Get(WindowDesktopWidth) - Get(WindowWidth)) / 2); 0) This works great, but my client moves windows constantly and always having New Windows jump back to the center of his screen is a bother. I've been asked to remove this function, which I have done. But, now all the report previews open with their New Windows in a weird way. Is there a way to instruct a new window to center itself on the window it opens on top of? Help always greatly appreciated. Than…

Obviously you need t be inside a field in order to enter data!!! However trying to enter data while not in a field causes filemaker to flash up a massage about needing to tab or entera field etc. etc. Is there a way to capture that error code (I think it might be errorcode 905) so I can replace the filemaker message with a custom dialog box explaining in my own words? Thanks John Before some tells me this is a double post - I tried posting and it said the service was unavailable so I waited and tried again - for some reason it took both posts. Sorry Johhn

Obviously you need t be inside a field in order to enter data!!! However trying to enter data while not in a field causes filemaker to flash up a massage about needing to tab or entera field etc. etc. Is there a way to capture that error code (I think it might be errorcode 905) so I can replace the filemaker message with a custom dialog box explaining in my own words? Thanks John

Hi there, Just wondering other than using a field that uses Global Storage, is there a way to create a dedicated variable to each user? For example user 1 his variable is 10 User 2 does something and his variable is 12.. Variable that entirely depends on what that person does. I know one way to do this is to create a field with global storage...

Is it possible in a script to open another Filemaker file hidden and enter an account name and password without seeing any dialog. I currently have one file that asks for an account name and password when you open it. I'd like to, from another file, open that file that asks for the account name and password and have my original file enter the account name and password to it to open the new file, and then make it hidden. I hope that makes sense.

I have a ton of scripts. I would guess that half or more of them aren't being used anymore. A lot of them have very similar names. I'd like to be able to find out where a given script is being called from. If I think I've found a script I need to make changes to, but there are several similar scripts, I'd like to be able to find out which other scripts are calling the scripts I'm looking at. Is there a tool that can do that for me?

I get numeric results from various outside entities, and for some reason they are unwilling to change the way they output their numbers to save my sanity. Values come in as positive numbers 1,000,000 100,100 1,000 <100 1000J ND -- [] empty etc. basically they come in in all various formats, thousands separator, less than, "J" flags, ND, -- I have the following cobbled together from various sources, but am still missing some possible results: Let ( [ N = GetAsNumber (OriginalNumbers ); GT = If(PatternCount (OriginalNumbers;"<");"<"); - greater than JF = If (PatternCount (OriginalNumbers;"J");"J"); - j flag DD = If(…

I am working with a flat file from a supplier and need to get it into a reliable CSV format. I am using filemaker to port it to this format. One of the issues is that the description field they provide is messy. It has many characters that do not play nice. I am stripping a few using a script to find and replace things such as # signs, commas, semicolons, and other characters to get a clean text. One issue is that I need to remove the " in some fields - but I cannot find a way to do a find and replace on " How can I clean the fields that have these - it needs to be something scriptable since this process will be ongoing.

Hello I would like to find a way to email from filemaker through my yahoo account instead of my mac system. Is that possible and how? Thanks

I have a server-automated script that runs once a night at 11:08 PM central time called 'run_on_cron'. The limited user 'cron' that runs this script has access to several necessary layouts and other scripts. When user 'cron' runs the script, is user cron already logged in, or does cron log in just to run the script and then log off? I have a default log-in script 'Opening Script' and log-out script 'Closing Script'. User cron has access to these scripts. Do they run automatically when the server logs on user cron, or are these scripts bypassed during server-automated scripts? I created a script 'insert current timestamp' that inserts into a field. When I'…

I have a script set to run daily at midnight. It emails me only if there are tasks due in exactly 14 days. I have the script set to find unfinished tasks with today's date + 14. It works fine if there is something to be found. Perform Find [Restore] If [Get(FoundCount) ≠ 0] Go to Record/Request/Page[First] Loop ... do stuff ... Go to Record/Request/Page[Next; Exit after Last] End LoopElse Show all Records End if When I run it as a normal user and the found set is empty, it asks me if I want to 'modify or continue'. I don't see a way to automate 'continue' when the script is running automated from the server. Am I missing something?

I have a database that contains customer information. I need the ability to look through my records in form or list view and click a button next to any record that will include this record in a new table that i am using to produce a mailing list. I know how to edit the layouts and put in the button, and I have the table for the mailing list created such that if I create a new record by hand and type in the account number, all of the fields that I need get populated from the original record. But what I do not know how to do is write the script that will create a new record in the mailing list table and copy the account number from the record i selected and paste it in t…

We have deployed the ability to email purchase orders from within their Filemaker system using the send mail script step. This was all up and running just fine for a period of time (maybe a week or so) and then recently stopped. Strangely, the bcc copies that are being sent to the operator originating the email are getting out, but those going to the actual recipient (always on an external domain) are not getting out. There is no bounce back; no indication of any problem, other than that the recipient doesn't get it. They are running v10. All non Filemaker originated email is being handled normally. Another odd aspect of this, is that this doesn't seem to be…

i'm looking voor a script that allows me to send a record by mail. But al data, including the attachments, are stored into fields. Ex to [email protected] Subject : event 2011 Body : we invite yout event 2011... Attach: ticket 4949.pdf; ticket 4950.pdf The result must be an automated mail sent to the recepient with the attached files. Triggerd by clicking the button JJ

I am using FM 11 03 ADVANCED ON OSX I have produced a report with Sub Summary grouping that works and looks like this: In order to show just the current months 'activity' there is a field called Date_Progress which holds the most recent months activity date. This works unless I go back to the member record and change the date. In the example above, David Crocket had a Date_Progress of April 17, 2011 prior to being changed to Mar 17, 2011. After the change, even though the Date_Progress field shows the correct date, the Find Script somehow still 'sees' the April 17, 2011 date. Huh? Here is the script: Here is an update: IF I MAKE THE DAT…

I have connected FM 11 Advanced to an external database (Zen Cart MySQL) which has a quite complicated structure. For different reasons I would like to make native FM tables as well that will get updated info from these external tables (one native FM table will have info from multiple external tables). Preferably the native FM-tables should be updated whenever the MySQL-database is updated (the MySQL-database might be updated from external programs as well, not only from FM). One of the reasons is that I would like to have a local file of the most important tables and fileds that will work even if internet is down. An other is that I have a value list problem. …

Hi, Hoping you might be able to help with ideas for writing efficient script for a specific task. The current script for the task described below takes 8 seconds when there is not much server traffic but up to 35 seconds when there is heavier server traffic. Three of the tables in my database and their fields (FM Pro Advanced 11), forming a many to many relationship are as follows: Abstracts: AbstractID (primary key), Title, Text, RandOrder, Number of Screen Responses (unstored, calculation field, may be empty for as yet unscreened abstracts). Records in this table are ordered by the RandOrder variable. Number of Screen Responses is an unstored, calculation…

This one has me stumped. I'm trying to create a script that finds a particular record, and for various reasons I'm trying not to use GTRR. I'm setting a script variable: Set Variable [$y; Value:px_CREL_patientID.fk] (at this point, if I set a field to be $y, it comes out as it should - 1089, or some similar number). Then: Go to Layout [Contact_Rship] Then I show all records and unsort all, because I'm wanting to do the find on the whole range of records. A pause step confirms for me that I have the whole range of them. Then: Perform Find [Restore] Where the find command is: ContactRShip::PatientID.fk = $y What comes up then is an error…

I have an invoice layout with a couple of fields, Item_Search and Quantity. Most of the time a barcode scanner is used and quantity defaults to 1. Sometimes I'd like to be able to type in an Item ID, tab over to the Quantity field, enter my new quantity (say "5") and hit Return or Enter, THEN trigger my script that adds the item to the invoice. I've toyed around with the OnObjectKeystroke script trigger, but it's too slow. Running a script after each individual keystroke, even if it exits immediately, is too much of a slowdown. After scanning a barcode, I can watch the characters slowly appear in the field (whereas before, they are entered almost instantaneously)…

I have a solution that I made several years ago to manage (mangle) gobs of data from hundreds of sources for a Print On Demand Solution.. I've got a LOT of work in this.. I have a new client that I can taylor this application to his needs and not have to do literally months of work on. There's one minor snafu.... The one I developed is on the Mac platform. A very important part of it is a script that uses an Applescript to import a WAD of files in one session and do various nasty things to the data during import. Of course this client wants to run it on a Window 7 box.. I plan on providing a runtime solution.. The (borrowed) script I have used (with some mi…

I am using FM Pro 11. I currently have a layout where I can manually put in a "start date" and an "end date", the team members "name", and press 'run report' - the report then pops up. I am trying to put together a script to automate this process further so it will automatically run reports at the end of each working week for each team member who worked at some point during that week. I have a table containing records with staff clocked hours. Records have staff fields "name", "date", and a field saying what they did that day, either 'worked', 'sick', 'holiday' etc. If I search for one week of records I would get something like the following: 'Monday' …

Hi guys, I'm using FMP to manage a conference going on at my school. I'm familiar with basic operations (within the limit of my job), although I am not very experienced with FMP. So far I'm really impressed with it's speed and capability. Anyway, every time I start up FMP, after I log in, and then select the database from the menu that comes up, it shows me a splash screen of a picture (which turns into the browsing window where i can select layout, etc.) and then another window pops up on top of that which appears to be a list of some of the data in the database. If this is unclear, please see pictures below. How do I prevent FMP from opening this s…

Hi, I select OnObjectKeystroke, and it would run a script to add new record. However, it goes into infinite loop even though i put a stop script there. Is there a way i can stop it? Thanks. Kent

portal and attachment of container field Hi, I'm not really experienced with FM and I'm having a small issue. I have a customer table and a product table. In the product layout, I have managed to integrate a portal of all the clients that have purchased a particular product. That particular product has a documentation stored in a container field. I would like all the clients of that portal to be sent an email with the documentation of that particular product. How can I achieve this ? Thanks for your help

Hi folks, I'm in the process of a large archival process. I have thousands of tapes, each with a copy number starting with an abbreviation of the department they were shot for (e.g. AAS, CJS, COE, ETS, it doesn't matter what they stand for, but it's how they're identified). The copy number is in this format: DEPT-YYYYMMDD (e.g., ETS-20110511). All of the tapes are in the database. The tapes are going into large boxes. Boxes are simply named box### (e.g., box079), and new boxes are created in order with no regard to its tapes' copy numbers. I'd like to make a script that takes, as input, a range of alphabetical departments to be tagged, or just a range of s…

Hello, I am wanting to create a script that will "enroll" a found set of students in a particular class. I have a camp database hosted on FileMaker Server 11 with clients running FileMaker Pro 9. This pertains to my summer music camp database that I've been working through some of here: http://fmforums.com/forum/topic/78174-value-list-of-current-employees/ I have a students table, an enrollment join table, and a table of classes/rehearsals. I also have a faculty table and join table to link faculty who are teaching each of the classes/rehearsals. The problem I will encounter is enrolling the students into a rehearsal. This is a band camp, so students audition on…

Hello, Text parsing is not one of my strong points! I need to be able to take tagged text and convert it to formatted text and there can be 0 to many tags in one line to multiple paragraphs. The tags are <RD>, </RD> for red text, <B>, </B> for bold, and <I>, </I> for Italic. An example may look like: <RD>This text will be red.</RD> The text in this line will be black. <B>The text here is bold</B> and this text is black again, then <I>this text is italicized.</I> Formatted it would look like: This text will be red. The text in this line will be black. The text here i…

Hello everyone I'm facing a new challenge. I have 2 FM databases. The first is used by the estimation team and it's all about estimating house construction projects. The second, the Management db, one is used for managing clients, ISO 9001, production etc. and is widely used by the employees. Now I'm working on creating a complete shipping list in the management db and I need to import informations from the estimation db. For example. All the doors and windows and their quantities is in the estimation db. What I need to do is go to the windows and doors Line items layout by using the $$projectID (from the management db) I will need to loop the script to gett al the…

Hi All, I am very new to FM. I am running FM 11 Adv I have a field on my page that is a radio button(paid_yes_no) that is defaulted data to NO. I have created a script that, when attached to a button in another database does the following. Open File["Invoice"] Go to Field [invoice::paid_yes_no] NOT SURE WHAT TO DO NEXT It is defaulted as NO and I need it to change the value in the field to Yes. (It is a radio button) Any help would be greatly appreciated. MG

Hi Everyone. Soon be Saturday!!! Any ideas on how I can amend the below script such that if the output is 0.0 then it states "text of my choice" Alternatively Some other separate sciprt that I can add that with tell a field to state "something" when the field calcuation = 0. Thanks all Let([ start = Cosmet2010::Margin of Safety Baby [zz__kf__Cosmet2009RepNum] ; integer = Int ( start ) ; decimal = start - integer ; decimal1 = Substitute ( decimal ; "." ; "") ; decimal2 = Left ( decimal1 & "0" ; 1 ) ; result = "MoS - Baby 5.9kg: " & integer & "." & decimal2 ]; result )

Community, I have a DB that I'm working on and I'd like to protect it from being accidentally edited. I'd like to have two buttons where I can switch between an "allow editing to records mode" and a "view only mode" while staying within the Filemaker browse mode. I'm guessing this could best be done by scripting but I'm not sure if there are any ways to turn editing on and off with scripts. Would a script that changes users be possible or would that be too cumbersome? Any ideas or help would be greatly appreciated. Yes, I'm a bit of a noob with FileMaker, so sorry if this is a really basic question. Thanks in advance

Hi, I have a test question database (3,000 records) and need to prepare a subset (about 300 questions) for the printed exam. Each question needs to be numbered serially. However, some questions have already been pre-numbered (about a third of the 300 total questions). I can't figure out how to write a script that does this. I've been struggling with setting a variable field to increment, and then compare its value to the ItemNumber field, but I just can't figure out the If statements and loops. So for example, if there are six records chosen for the exam (I can do a Find on a field called Use=1 to find this subset), of which three have already been assigned an I…

Hello all, I'm new to this forum and would just like some guidance on what tools or features are required to make my little project work. I'm trying to develope an interface/script in FileMaker in which one enters some keywords and then records (from a different database) are found and displayed based on those keywords. Any help would be greatly appreciated. :)

In my Solution i have option called letter creating acording to the number which i enter. lets say if i enter "3" in to test_style field, so the test body will fill up the text part i predefined to "text 3" in filemaker i run this via script. But i canot run the script via web. So what i did, i asing the sctipt to script triggers on field, so now i dont have to run the script manually, i just edit the text of text_style , But for some reason i dont see the script trigger work from filemaker end. this happen only i send the command from web. but i f i do the same task from filemaker script trigger works. Using this link you can download the screen cast. http://hotfil…

I am working in FM Pro Advanced 9 and trying to conditionally highlight a record in list view when it is the active record. I have the formatting set up so that when a global variable = the record ID, the row highlights grey. I also have written a script that sets the global variable to the record ID of the active record. However, I cannot figure out how to trigger this script every time a record is active in the layout. Basically, if I had FM 11, I would pick the "onRecordLoad" trigger, but of course, I can't do that in FM 9. Any recommendations? I know I'll probably need to use a plugin, but which one should I use and since I'm not very familiar with how they work…

I have a solution where I need to run reports overnight ( basic search for all entries for today, PDF them, and email) . I am currently using ical and applescript to trigger the reports, but am having issues with this solution. Any little issue will halt the applescript. I tried server side and it says that it ran the script, but it doesn't create the report. Is anyone else having better luck with this??

Hi guys/gals, I have a question, assuming that i have a layout which is like employee database and stores something in lets say Field 1. It works fine, but lets say now it is year 2011. How do i duplicate the employee database and let the field 1 to be New? I know it can be done manually, but i was wondering i could make a script where i just click a button, and the entire database is duplicated and the field 1 is empty again. Thank you. Hope to hear from you soon.

I'm new with FM and I'm over my head with this. I am trying to manipulate the contents of field X. Field X is determined by what is in field Y. Set Variable [$Location; Bindery::Location] Set Variable [$TargetField; "Bindery::&"$Location"] Set Field By Name["Bindery::"&$Location; ***At this point I want to set the contents to "Bindery::"&$Location & Bindery::CustomerName Field By Name is accessed successfully but I can't figure out how to manipulate the contents. Any help would be greatly appreciated.

Hello all, Having an issue when saving from a window. Filemaker just gives the hourglass and stays there. This is a multiple file database. I have changed the scripts to look like this - Set Field [ new_quote_item::quote; MAIN::docid ] Commit Records/Requests [ Skip data entry validation; No dialog ] Set Field [ new_quote_item::authoring; "" ] Commit Records/Requests [ Skip data entry validation; No dialog ] Perform Script [ “Create Item” from file: “quote_item 2” ] Select Window [ Current Window ] Go to Layout [ “Quotation - New” (MAIN) ] Commit Records/Requests [ Skip data entry validation; No dialog ] Perform Script [ “Quotation - R…

Hey! This is my first time posting here, so I'm still trying to get the hang of this. I just started learning FileMaker (my first database program) and I'm trying out simple scripts to perform actions to make my work a bit more efficient. Basically I am writing a database to track part numbers and serial numbers of certain products that get sold daily. Basically I have on text field for input, that after I scan a barcode it determines whether the scanned input is a part number or serial number. It then takes the inputted text and moves it to either the Part Number Field or the Serial Number Field. After that it clears the InputField. What I would like…

Hello. I'm working with Filemaker 11. I have a found set of about 1000 records. I need to replace the data in one field (date)-- with a different date. I have tried the replace field contents script step. I have tried a loop script with variables. They work. But, it is slow with this number of records. It is taking several minutes to do this. I'm hoping there is a faster way to accomplish this. Thank you for any help.

Hi, I have made a couple of buttons which give my users a nice way to deal with managing accounts (creating and deleting user accounts, changing passwords, etc). I have attached scripts to the buttons that do the desired action--for example, the Add Account button provides a prompt for a username and password that the user can specify, and then adds this new account to the list of accounts. However, the problem is that I want my users to have data-entry only account privileges. (I don't want them to have full privileges so that they cannot edit the layouts, etc.) However when I try to run the script from an account with data-entry only privileges, I get an error…

I have a parent table: CUSTOMERS I have a related table: INVOICES and I have a related table: PAYMENTS On an individual Customer detail layout I have portals for both Invoices and Payments In the related table INVOICES I have a summary field SumInvoices and In the related table PAYMENTS I have a summary field SumPayments both show on the Customer detail When the summary fields are in two different tables, how can I find the balance due? SumInvoices - SumPayments to get BalanceDue Thanks Or should I combine them into one table INVOICES_PAYMENTS?

Hi there, I am trying to implement using a barcode scanner with FMP. The usb scanner sends the return keycode after each input (as do most scanners). After each input, I want to move to the next field. My script is quite simple: if code(get(triggerkeycode)) = 10 or code(get(triggerkeycode)) = 13 (both return and enter) Go To Field(Field 2) end if Which has been attached as a script trigger on OnObjectKeystroke. This works fine, however, after moving to the next field, it still sends the return code and the new field gets a new line. Is there anyway I could send null or not send anything at all after it goes to the next field?…

Hello, When we share a filemaker project, it’s hard for non FileMaker developers to setup or import custom functions. Because, they don’t need to know how to do this and they don’t care to learn. So, I’m facing a problem, I have some custom function, for example Combinevalues (special thanks Jonathan Stark, author – source: http://www.briandunning.com/cf/244) Problem: I need to transform this custom function in a script, because I can overpass the first problem (import and learning). First try: Pick up all values in first list, and past all into a field2 This doesn’t work, I don’t understand why, because all seems work in theory.…

I’m trying to save a backup copy of the current FM file to a sub-folder named “backup” in the current directory. The following script steps saves to the desktop with the correct file name (stored in $path). However, I can’t figure out how to configure the Specify Output File dialog box in the Save a Copy As script step. It saves to the backup folder, but names the file $path, not the value stored in the script variable. Set Variable [ $path; Value: Let( t = Get(CurrentTimeStamp) ; Get(DesktopPath) & Get(FileName)& "_" & Year(t) & "-" & Month(t) & "-" & Day(t) & "_" & Hour(t) & Right( "00" & Minute(t) ; 2 ) & ".fp7" ) ] …

Hi people, I need to take a string which contains: TextSize(TextFont("6";"Webdings");8) and change it to use arial char(9658) which both produces the arrow. The computers can't (won't) install webdings (management decision) so I need to change it. This is within a string which sets the arrows within a calculated line so I need to include the font and font size because the rest of the string is calibri and the sixes are mixed. I tried to find out what char(9658) is in key stroke but I just get the arrow lol. I would really appreciate help translating it from webdings to arial. Thank you.

Hi all, Thanks for having this great resource available. I will apologize for the length of this but, have patience and I hope not to loose or bore anyone. After reviewing several other posts here, some where close but, none worked for me that I could understand or get to work properly I feel the more the information the better for a solution to be found. Of course I'm new here and to give a little background It has been a long time since I have really been active with FileMaker. The last time I truly did any programing within Flemaker was probably back with Filemaker3 for a dbase. I have done some minor maintenance for some other clients a long time ago …

Hi, I'm using Filemaker pro 11 to create a database that holds details of clients monthly payments on 12 month contracts. Clients have the option of paying uprfont or paying monthly via direct debit. On their file i want there to be a field called 'Paid', with two possible answers "Yes" or "No." I want the 'Paid' field on the first of every month to revert back to "No" across the board except for those clients that have paid upfront. This would indicate that they need to be debited for this month. To indicate that a client has paid upfront I have another field called 'Payment Upfront' with two possible answers "Yes" and "No" again. Can someone please help me to const…

I have a button that, when clicked, it finds a record based on the contents of the "names" field. If that record exists, it goes to that record and the script ends there. If that record does not exist, I would like it to then create a new record. I would like this all to be done with the one click of the button. I am an extreme novice and any help would be greatly appreciated. Thank you!

I have a database set up to log Disconnected Accounts (I work for an electric coop). I'm trying to make it fool proof for my users as most of them are not very computer savvy! I have a New Record button running the following script: Set Error Capture [On] New Record/Request Show Custom Dialog [blah blah] If [Get (LastMessageChoice) = 2] Delete Records/Requests [] End If Commit Records/Requests [] Perform Script ["Sort Records"] My custom dialog box works fine. It pops up with the 3 fields that I want entered and if I hit cancel, it deletes that record or if I hit OK, it enters the record with the correct information. The problem I'm having i…

Hi, I'm using Filemaker pro 11 to create a database that holds details of clients monthly payments on 12 month contracts. Clients have the option of paying uprfont or paying monthly via direct debit. On their file i want there to be a field called 'Paid', with two possible answers "Yes" or "No." I want the 'Paid' field on the first of every month to revert back to "No" across the board except for those clients that have paid upfront. This would indicate that they need to be debited for this month. To indicate that a client has paid upfront I have another field called 'Payment Upfront' with two possible answers "Yes" and "No" again. Can someone please help me to const…

I can't get the Save As Copy script step to save to a sub-directory that's in the same directory that contains the FM file. Do I type the path in? I can't figure out how to use the Output file dialog box.

I'd like to create a FM 11 script that backups the current open file. It would save the file to a specified folder, and the file name would include the name of the open file, the date and time created. Any suggestions on how I could do this?

Can anyone help,,, I use the Invoice and Inventory start up package that came with FM11, I have over 1000 products in my inventory and I want to set up a printout that only tells me the products that do not = zero. ie If there is a positive number (in stock) or a negative number (i need to order stock) I think the what I am trying to do is 'omit records that = "0" but I cant work out how to .....

I am trying to figure out a way to create a script to loop through specific fields, but i can't use variables in field names. I have a table that contains inventory information for a walk-in cooler, each footprint in the cooler has fields for type of product and qty. They are all named the same except for the number after the end of each field name ex prod1, prod2, prod3, qty1, qty2, qty3 etc etc. I was writing a script to populate another table in the database with sums of everything in the walkin (ie 15 of this type, 30 of this type, etc) I thought i could set up something like a for loop where i have an integer that increments at the end of each loop iteration so i c…

FM 11 Adv, Win 7 Professional I created a new layout, but the script step Go to Layout does not go to that layout. Instead, it goes to another layout and enters the Preview mode! The Continue button appears in the Status Toolbar, but does not work. I have to click the Cancel button to get to the Browse mode. I ran Recover, but it did not detect any problems and the problem persists. I even re-booted the computer, but that did nothing.

When in Find mode, striking the Enter/Return key causes a 'Find' to be executed. I have buttons on my 'Find' layout that will either Find/Constrain/Extend/Show all/Show omitted. I would like FM to ignore the Enter/Return key since there is no way to tell which of these the user wants to accomplish and the Enter/Return key can send the user back to square zero on a complex search. Is there a way to trap and ignore an 'Enter/Return' keystroke when in Find mode?

I’m using FM 11 Advanced, Windows 7 Professional. I have just created a new FM file, and in the File Options dialog box, I unchecked the "Log in using" check box. I did not enter a password because I didn’t want to use one. Now I can’t access the file. I get the dialog box asking me to enter a password and the guest account is grayed out. I downloaded and ran the program FileMaker Password Recovery v1.0e (trial version). It reports the file is not password protected. Is there a way I can open the file?

Can anyone please advise me? I am trying to record a "timestamp" in a database when an email is sent from another database. I have tried lots of script triggers and scripts which I thought may apply the timestamp but nothing appears to work for me, and now my head is shed! If anyone can advise I would be most grateful. Thanks in advance

Hi All, I do my daily planning in iCal.. I am trying to get an ical event into Filemaker through an Applescript... I have found several scripts that work the other way around: place an event based on a FM record into iCal. Is there anybody who can help me with a start to make this possible? Thanks, Kees

KKThe script on the attached zip file does not work, and I can't see why it does not. Can someone help me her? Running OS 10.6.7 on an Imac and using FMP 11. What\'s wrong?.zip

Is there a way to run a script at scheduled time? I don't want it to run at open or close file, i want to be executed at scheduled time. Using FileMaker 11 on Windows 7 Thank you, Toni

Did not know where to post this so I'm posting here because the error "an unsupported operation was attempted" seems to happen when the New Window script step gets executed. I was watching the script debugger and it appears, at least on the surface, that whenever I hit the NEW WINDOW command I get the error "an unsupported operation was attempted". I'm not doing any web development - this is straight Filemaker development. I don't see any reason why this would invoke that error. Anyone have any ideas? I'm on XP Professional. I'm leaning towards XP as the culprit. Dom

This request is to understand variables, related records, GetNthRecord and looping. It is not because I have a real problem. If you don’t want to help because it isn’t real problem I understand but I hope you will because I am learning and probably won’t bother with this issue if/when I ever need it if I can understand this. Short version: I am trying to understand why my start and end dates don’t increment forward when moving through the related records using GetNth. By start of third loop, it should change the start date to 4/1/11 and the end date to 4/15/11. Long version: Perspective: I want to stay on the staff table. A staff may have multiple schedul…

Hi again First of all the calculation result is TEXT. I have tried the Round command but cannot get this to work. Would any one have any ideas on this? At the moment, I have something like 12 decimal places and need to report this on the layout as only 3 or 4 significant figures. It is turning into a bit of a pain!!! Thanks all Let ( val = Cosmet2010::Margin of Safety [zz__kf__Cosmet2009RepNum]; Case (not IsEmpty (val); zz__Tab__g & "Margin of Safety Adult 60kg: " & zz__Tab__g & val) )

I have a script that finds sales based on date or salesman or both with search string done via custom dialogue input fields. I would like to sort by salesman and date if both fields are inputted, but only by date if only date is queried. Is there a script step that would allow me to determine whether one of the search fields is empty? Thanks ken

Howdy, all: I'm trying to create a script trigger so when a user enters lowercase text into a two-letter State (text) field FMP will change the text to uppercase. The problem is users will unconsciously enter the state's identifier in lowercase so it'll "stick" in the field instead of the uppercase ones already set up in the value list. I don't want to change the field to a pop-up menu since that'll be unsightly and unwieldy with such a long list (states plus US possessions and Canadian provinces.) Before tweaking, I had it set up so the user received a custom dialogue message that he or she should use only uppercase letters but that was kinda clunky; I'd rather…

I have looked and found nothing that has worked, seem that most solutions are more complicated than I need. I have to tables - table 1 and table 2 I have a drop down in table 1 with a vlaue list, I want to be able to select a name from that drop down and click a button that preforms a script that will take that name(dropdown field) and create a new record on table 2 with a timestamp. I know this is probably super easy, but I missing something to make it work. Guess that how we all started i hope Thanks in advance!

I have a container field that contains a referenced file, and I have an OPEN button that will open that file by using the Go to Field command. However if the OPEN command is unable to find the referenced file because the user is not connected to our server I would like Insert File dialog NOT to appear. Is there anyway to trap for this, because it is only a one line script? Thanks David

I have a check box on a form that I wish to link to an existing script. Essentially, the script that I have reads the result of the check box—if 1 then it switched to a particular layout. If 2 then it switches to the other layout. What I'd like to have happen is that when you check (or uncheck) the checkbox the script will be activated. Thanks, G.

If I run 'open URL' to mount a volume prior to 'insert picture' the screen stays in Finder and doesn't come back Filemaker. The insert picture script has enacted but the dialog is hidden. Any tips thanks? PS looking for a multiplatform solution as I could run an applescript if just Macs

Hello! I've expanded on a starter solution contact database so my company can "code" contacts with keywords, for example: media, art, entertainment, music, etc. Each contact can have up to 5 codes. I've set up a related Codes table (with key Codetype) and related it to K_ID_Contact in the Contact Management table via join table Code Assignments. Right now, I have a sub-summary report set up to organize contacts by code. I've included a global field in the header "gCodes" that includes a value list from field "Codetype" and enables the user to view a sub-summary report of only one code at a time. This is achieved through a script that sets field CodeType (in ta…

I'm trying to output a concatenated field which is made up of several fields. I don't want to output the decriptors of a field (its contents are zero) if under usual circumtances it would otehrwise return zero (or be blank). I've set up the following but there's something wrong with the formula: Trim ( Case (not IsEmpty (Field 1); "F1 description" & " " & Field 1 & "%" & " | ") & Case (not IsEmpty (Field 2); "F2 description" & " " & Field 2 & "%" & " | ") & Case (not IsEmpty (Field 3); "F3 description" & Field 3 & "%" & " | ") & Case (not IsEmpty (Field 4); "F4 description" & " " & Field 4 …

I can't seem to wrap my head around this one. What I want to do is take a found set of records and use ALL of the values for a certain field from that set to do new finds iteratively - I want to take that field's value from the first record, do a new find, decide to keep or delete the new found set, then go to the next record in the original found set and do that all over again. I have been trying to do this with a repeating variable since the size of the original found set is going to vary. Any suggestions? Thanks in advance!

field1=numer, field2=date stamp How to find max value of number field by this year? Thank you.

Extract the content of word document into filemaker Hello, I have a doubt in filemaker. The actual requirement is, I want to import the contents of Word document (.doc) into filemaker. I have tried lot of methods to achieve the solution. But still the problem persists. I also have another question, I have a word document in container field, I want to copy the content of that word document into text field in filemaker. Is this can be achieved usign any scripts ? If you have any solution, kindly reply. Thank you. Regards, Hari

A system that we are working on generates workflow projections based on the week of year. Jobs are scheduled out over the course of year based on their required ship date, phrased as a calendar week. The script needs to locate records that are scheduled to ship with a range of the current week [ WeekOfyear(Get(CurrentDate)) ] and a variable that represents the number of weeks ahead the operator wishes to look. So...a simple scripted range find which sets the Ship Week field [ WeekOfYear(Get(CurrentDate))& "..." & WeekOfYear(Get(CurrentDate)+ $WeekRange ] works great. The issue that was just raised, is what about the end of year when the addition of the $We…

Hello, This may be more of an apple issue than FileMaker, but I'm hoping to find some help. I am working on a small network with a Time Capsule as the router, all computers are iMacs running Mac OS X Version 10.6.7. I can see a remote computer in my finder window and when I click on it, the disk mounts with no issues. Using the FM Script "Open URL[no dialog;"afp://volume name from get info"] the disk doesn't mount. So I tried putting the afp portion of the command in a Safari window I get the error "Network file permission error" Using an applescript I have proven to work on different computers to "mount volume" I get the same error. I have checked the permiss…

I have an school attendance roster of three entered classes, with a copied time stamp: Billy Kidd Math 4/20/2011 1:21:10 Jane Doe Math 4/20/2011 1:21:10 Al Schmidt Math 4/20/2011 1:21:10 Carole King Math 4/20/2011 1:21:10 Bob Tripp Science 4/21/2011 3:18:05 Julie Tool Science 4/21/2011 3:18:05 Art Deli Science 4/21/2011 3:18:05 Joey Twoo English 4/23/2011 9:28:15 Kay Jewel English 4/23/2011 9:28:15 Daddy Love English 4/23/2011 9:28:15 How can I Perform a Find that results in: ...... Math 4/20/2011 1:21:10 …

I have problems with getting printouts to behave similarly between Windows and Mac FM clients going to the same printer. The margins always seem to be off. I don't see any easy way to make them the same within the print driver, so I am exploring the possibility of having FM send a print job from an OS-specific layout. Is there a function that can retrieve what OS it is operating on? Like a Get (OS) sort of thing...

I have 2 users Bill and Paul. I don't want them to see each others records which I do through accounts and privileges. I am trying to write a script that checks the user name using the Get(UserName)and if say it is Paul sends him to Pauls layout. Any ideas?

I know there are various pros and cons for using field validations over script triggers when validating data, but... In a solution I'm currently working on, it will go to the user with a set of fixed pre-entered preference data in a couple of tables and layouts, to which the user can add to. Edits and deletions are only permitted on the user added records, not the original pre-entered data. A flag "userentered" set to 0 on the pre-entered, and set to 1 on user entered data. This is easy to use in the field validation section, only allowing changes when userentered=1. However the stock validation button is clumsy using the "revert" language and doesn't offer…

Is there a way to resume a paused script by clicking the close window button? I thought it might be possible by using custom menus, but it seems the FM locks the window the paused script is running on. The problem with this behaviour is that the close window icon doesn't grey out, so there's no visual indication that the button can't be clicked…

in windows, how I can save a pdf (with a $variable filename) into a folder that is selected by the user, If I let the user select the folder from the save as PDF dialog the file name is untitled.

Hello all: Does anyone see any problems w/ the following : IsEmpty ($variable) It seems to work just fine but the documentation for this function under 'format' says: IsEmpty (field) So I was just wondering if putting a local variable in this function instead of a field is a good idea. Sincerely, Dom

Hi, not sure if this is the right place to post this, so apologies up front. I have set up account info in the FMP account management area. However I have extra data that needs to be accessed and associated with the accounts or users. I have a table called tblUsers containing varied info like "destNo' ID field that determines a school that user is associated with, their full name (first and last) and other contact details. How do I go about linking the Account Name from FMP security with my table data from tblUsers so their details can be updated eg: update username but changes are reflected in both tblUsers and FMP Account security. Ideally would be a layout displ…

Hi why is the "Save as Excel..." button de-activated when a script is in pause? According to FileMaker help the "Save as Excel..." functionality should only be de-activated in Find Mode. Kind regards, Andries

Is it possible to conditionally hide or reveal fields, labels and rectangles on a layout in FMP10? I'd like to place three or four elements on top of each other at the same co-ordinates. They would reveal or hide themselves depending on the current user's activities. Possible? Feedback much appreciated.

Hi, I have created a custom dialogue script warning the user that clicking OK will send an outgoing email and clicking cancel will not. Can anyone please tell me how to make the CANCEL element work ? When I follow the cmd with "end if" I get a script invalid error. Thanks in advance for any advise.

Hi, Can anyone please advise me how to do the following: I have created an email button, to email data from a single text field which is fine, however I am unable to add the < and > symbols to the text line within the script settings to make the text an active hyperlink. Any advise is most welcome. Thanks you.

Hi Guys, In my database I wish to automatically timestamp a field when data is entered into another field. ie: I have created a "Signed off" field which would be empty, but when a name is entered into this field I would like another field (Timestamp) to show the date and time this was performed. I'm sure this is quite easy but currently beyond me. Thanks in advance for any help offered..

I Have read some topics on "Set Field By Name" but the forums wont let me search for that specifically because the words are not big enough I guess. I'm pretty new to filemaker and basically teaching myself so I appreciate any help. Here is what I am trying to do: I have a table called "Bookings" with a field called "Seat" and another table "Seatmap" with all the seats as fields named for there assignments. All the seat fields are set to be "O" to show that they are available. What I want to do is be able to type "13A" into the seat field. Then using a script trigger that starts when I exit the field have it go to the seatmap and replaces O with X in the f…

I've posted this at the official FM forums, but the scripting section here seemed more robust. Please forgive the repost. I've seen recommendations on how to do this with fields that are blank, but I wasn't able to modify that scripting to apply to my case, although there's probably someone out there who could point out where I went wrong. In summary though, I have a data file (.csv) with values assigned in a random order to a constituent record. The record will have anywhere from 4 to 100 values associated with it. Many of these values are database generated, and not relevant to me, and I would like to strip them out. I was trying to find a way to b…

I have a manufacturing inventory database that stores usage and purchase quantities on random Transaction Dates up to a year from now. I have a series of calculation fields which allow me to determine on what date for a given Stock Code the quantity in inventory turns negative, that is usage exceeds purchases. Because the calculation is quite processor intensive, but I need it to be real time data, I am trying to limit the calculated transactions to only those within the next 90 days. To do so I have an indexed field "Stock Code Date", based on the Transaction Date, which contains the Stock Code for transactions up to 90 days away but becomes blank thereafter. As a result…