Script Workspace and Script Triggers

I am new to filemaker! I would like to flick through a picture collection by forward/backward button. There are 3 tables with relationships: picture picture_id picture_link home home_id home_picture home_id picture_id What I would love to have is a script that collects all the pictures which are related to the home_id and shows them one by one in a field "x" by forward/backward button. The pictures are stored locally.

Hi... i want to create a script that copies a date field, adds one month and pastes it in the same field.... can anyone help me please!!!

Is there a script for a back button that takes you back to the layout you were previously looking at? For now I'm using a button with a "go to layout" script attached but sometimes users can access the same layout from different locations and it'd be nice to have a back button to go back to where they were.

this step creates an annoying (to my clients) 'plunking' sound when executed in a script. Other than telling them to turn down the volume, is there any way to suppress the 'plunk'?

I have a field which I am attempting to parse to extract various data to post into other fields. In the first part it contains a 4 digit number which I wish to extract whilst numbers are present in the field later on...there must be a way of extracting the entire number as an integer and then only using the 4 digits on the left? Thx. OK resolved this by using Left(GetAsNumber(DB::Fieldname);4) Simple!

Hi. I have an issue that is so basic and weird, I KNOW it's something silly I'm doing but stuffed if I can find out what it is. In my database one of the table is called SETTINGS. There are half a dozen text fields in this table, all set to Global. The purpose of this table is to store info such as:the client's name, their SMTP server, etc etc. The logic I have used is to have a script go to this layout, set global variables to each of these fields, then return to the original layout and display those variables. Problem is that I can write the values into the table fields, and the script runs, picks up the variables, all happy. If I exit the database and …

We have a status field, and when the status has not been completed after the date it was due we have a script that pops up a dialog to tell the user that that "load" needs attention. That's all fine, but what they want to happen is the user hits okay, but the message is repeated every 60 minutes until the status has been changed. Kind of like a snooze button : Any ideas? Or is this easier than I think. Perhaps if I put the script to run every so many minutes via the server?

I was wondering if anyone had to design a data base for "Double Data Entry" for data accuracy purposes. If so what were some design considerations and challenges to create the solution. I'm interested in how the 2 sets of data were entered, and what techniques were used to validate the data. Thanks in advance.

I am a beginner ---please forgive an elementary question. I've got an fmp 11 file with 1,950 people who were members of a college at various times between 1437 and 1960. I want users to be able to get a report on who was a member in a user-selected year: call it $QYear. Then there's a find (each member's YearIn should be before $Qyear, and his YearOut should be after it) and various other little jobs. How can I let the user set the $QYear? I've read the manual; I've read the last 6 months' of this forum. I've got a custom dialogue, ("Enter the year"), but I can't see how to pass the answer there to assign it to $QYear in the Find procedure. All help …

I am emulating a feature I found in a Starter Solution. It's a simple script which is attached to a button: "Go To Record Detail" This takes you from a list view layout to a form view layout. On the Starter Solution, clicking just once goes to the record detail very quickly. In my file, one click selects the record; then the next click opens it in form view layout. In the Starter Solution, these 2 steps seem to happen as one. I have examined the 2 files minutely. What have I missed?

hi. Please help me !!!! how do I dublicate an invoice and have the date update automatically to the same day the following month? I am trying to have a re-occuring invoice system and want to dublicate invoices for the next six months. I have an Invoice table and an Invoice Line Items table related by InvoiceID.

A little stumped over this it seems pretty simple but not working. After I do a find to show in a list I wont to change the list title to "records found". After it finds and changes it seems as if its trying to find again with the value "records found". I am attaching a pic of my script steps any help would be great. Jay

I have an employee database that shows records for three different types of employees. I'm trying to create a script that shows a list of each employee type on different layouts. Scripts are not my strong point and any help would be greatly appreciated.

I am trying to create an on timer script thats sends an email on the date before a bill is due based of of the "Date Paid" being empty and the "Date Due" Field. I can not find a way for the to get it all to come together. The email part I can set up. Its getting the search done properly and the bills that are due in the message field of the message.

Hi, I had a database created for my business for which I have been using since 2002. I had it updated a few years back using Filemaker 8 and have encountered no issues. However, I have a part within the database called invoices. When I print the invoice the invoice closes and I am then unable to ammend it. I have allocated an invoice to the wrong client and they have returned it to me. I have attempted to ammend the details but the following message appears.. This action cannot be performed because this field is not modifiable. As you can probably tell I am not a programmer and I have basic computer skills. Could anyone advise how to overcome t…

I have a database that tracks student tardies. All that works fine. The tardies are kept on a file server. Now I am working on a report that will show me the studentID, LastName, FirsName and the total tardies that they have. I know how to write the script to go to my layout but how do I keep the students from posting on my report that do not have tardies? My student database tracks it using: Count (Tardies::StudentID)

I have a situation where I find many records and they are grouped by salesperson name. I want to copy information from the first record only of each salesperson to another table. I have set up a script to work through the fields and loop until all the records are processed but I can not figure out how to skip records in a script. I tried setting a variable based on the salesperson name and then compare that variable but the syntax of how to manage this is not connecting in my brain. Any pushes in the right direction are appreciated.

Hi all. I think I have a simple scripting issue. I have a table with three pieces of information: places, dates, and names (each record is one kid's name, the place he attended the workshop, and the date he attended). The idea is, we've been holding workshops at certain places on certain dates and we want to calculate the number of people who attend these workshops. I'm sorry I'm a real newbie with scripting. I'm currently working on trying to calculate the total number of children who attended workshops on a certain date in a certain place. I'm trying to set up a script that loops - after sorting the records, it goes through all the records and if the place and date…

I am having a tough time trying to figure out the send mail function in FM 6. I am really new to scripts. I need to send a copy of a current record in a .pdf format. I have the email address in a field that I also need to pull from this same record. Any help would be great. thanks mhburris

I have been trying without much success to write a script to create a number of records in a portal based on a quantity in a related record. Basically it goes like this: I have a portal in which I have a list of “Item” records. Each Item has a quantity of one or more. The portal rows have buttons to expand the quantity of items into individual records for each of the qty of items. So if item A in the original portal has a qty of 5. clicking the button will go to a layout based on a related table with a portal (line items table) and create 5 duplicate records of Item A each with an incremented serial number. I have worked out the steps of navigating to the related la…

Hi I have developed an employee database. One table has each employee and their personal information recorded. Within each record, I placed a button. When pressed, this button should take me to each employees individual schedule. I've developed a schedule layer for each employee. And on each Employee schedule there is another button that should take me back to that employee information record. I want to: 1) be able to press the button on the employee page to navigate me to that employee's schedule. 2) be able to press the button on the employee schedule to take me back to that employee's information. I've made ID #'s for each employee. To help categorize them.…

I have a script that opens a new window and pauses to wait for user input. A continue button resumes the script and closes the window. But if the user closes the window with the "X" the script remains paused on the main window. Clicking continue closes the main window. Is there a way to prevent the user from closing the window this way? Thanks in advance

Hi Guys, This is my first post here so forgive me if im not in the right topic or something. I'm fairly new to scripting and I was wondering if anyone could help me out with my little problem. I am trying to make some sort of Quality Assurance script in which I have a list of people. I am wanting to catch all the typos that were entered. When my list is sorted alphabetically my script will go down to the next entry and verify that it is the same as the above entry. If it is different in any way the script stops and lets me take a look at why they are different. I was wondering if I could somehow add anything to my script for it to highlight how the new entry is…

Hi everyone, is their a way to trigger a script by changing text in a field via drop down/popup list?

I've accidently created a few hundred scripts without setting "run with full priveledges" on for all of them... is there any way to set this all at once or have i got to go and edit each one, one by one.

Hi there! Having a problem! I have data bases that are grouped by years for example 2008/09 there are sub databases that feed of these again by year and this information pulls into a 'home page'. Problem is on one on the database years has suddenly became faulty. The information on the 'homepage' is not showing! The records are still there but nothing is displaying. The sub databases are working and displaying. How can I make the information redisplay! I am a complete novice at filemaker and just maintain the databases, but did not build it, I know how to do basic amendments and operational adjustments ! So need help thanks!

I'm sure this is simple but I can't figure it out. I want a script to do the following; If ( field1+field2 (not equal sign) field 3 ; Message "The sum does not match field 3" ; do nothing

I'm not sure the best place to post this. It has to do with database organization, so I think this is the right forum (Database Schema and Business Logic), but I'm unclear as to the appropriate subforum. Anyways, here's the question: the database needs to track opportunities and projects, and they need to be shown on different layouts. Opportunities can sometimes, but not always, become projects. When an opportunity becomes a project it needs to disappear from the opportunities layout and appear on the projects layout. Projects have almost all the fields that opportunities do (agency_id, name, address, etc.), and they also have a number of other fields (c…

I’m trying to limit the number of scripts I have by using script variables which are great. I have an issue at the moment though which maybe someone can help me with. My script parameters are two field names (ie: Table::Fieldname). These are then defined as variables in a script (ie Set Variable to $$fieldname1 = GetValue ( Get (ScriptParameter); 1). This part works fine, it sets the script parameter as a variable. What I then want to do is set another variable from the contents of the field which was defined as a variable from the Script Parameter above. So I set my field contents cariable to; Set Variable to = GetField ($$fieldname1). However, all I ge…

1. I have three FM 10 privilege set levels, Staff, Admin and Full Access. The auto log-in is set for "Staff". 2. I Logged in with "Full Access" to test an Import records script. 3. The File was saved as Inven Copy.fp7 into a child backup folder (Last MarinaPro). 4. When the import script is run, Filemaker returns error 714 (Password privileges do not allow the operation). This database was converted from Filemaker 5.5 where it ran just fine. I can't seem to figure this out. Please help.

Have run into a "glitch" while testing FM11A Pro on our DB. The DB is FM10A pro. We have a main layout with multiple options for the user to select, basically a menu page. Under FM10 everything works fine, but running FM11A there is one option that seems to go wonky. I select this option and I should navigate to another layout where I have a choice of 3 more options, but sporadically it will drop the second layout behind the main menu layout and I can't get at it. I have to quit FM11A, but sometimes that doesn't even help. I ran the select through the debugger and found that it runs a "OnRecordLoad" option which is not based on the second menu but runs when you…

I'm new to Filemaker and I'm trying to assemble a database which includes 5 identical tables. There are six users -- I'll call the "top dog" the superuser. The superuser needs to open the file and select any of the five tables, then run scripts, some of which include the sort command. The other five users each have a privilege set which allows them access only to their own table. Problem is, when the scripts with sorts are run, the sorts pertain only to the table they were created in and an error message is generated. Since each table has identical fields, is there a way to tell the sort command to sort on the current table rather than the table it was create…

Is there a script so that a quicktime video automatically plays? Maybe something I can put in the layout open? I have a container in another layout that when clicked opens up a new window to play that movie. I'd like it to start playing automatically instead of having the user click on the video again and then on the play button.

I'd like to create a value list of all my privilege sets on the fly from existing privilege sets. I'm guessing that's not possible, and it's not like I have that many privilege sets. I'm just checking -- can this be done? Edit: Sorry I put this in the wrong section. I thought I had put this under 'value lists'. If an editor wants to move it, that works for me. :yay:

I need my users to be able to print the record currently displayed in list view. I made a button that calls a two-line script that selects the current window and then prints without dialog; however, when the button is clicked the current window is selected but nothing prints. The button must be clicked a second time. Is there a way to tell the script to select the current window and then continue to the next step in the script and print the record? This is probably very basic, but I'm new to Filemaker and don't even have a manual yet. I appreciate any help you can provide. Thanks, Kevin

I am trying to write a simple script to copy a bill to address into a ship to address when they are the same. I found a script that does what I want using the set field command. I have tried to reproduce this same script using my database, but its not working properly. When I go to run the script, the data that i typed in to the bill to fields gets erased. I have attached a screen shot of the script. I am new to this so it might be something very simple that I am missing. thanks in advance mhburris

Hello, I'm a student and I'm new to filemaker, we have to make a script that runs (say at 00:00) and checks if there are any alerts that need to be sent. Is there a way to do it like a cronjob or some sort on filemaker (it will eventually run on a filemaker server) Kind regards, Maarten

I have a script that can process one of five fields. What I want to do is use a parameter to specify which field needs to be processed by passing a 1 to 5 and then storing the parameter to a local variable. Then I want to use the Replace Field Contents script step to replace the field specified to a 1 or 0. For example, I have the following fields: Field1 Field2 Field3 Field4 Field5 The field number variable is $FieldNumber. It looks like I have to select the field that I want to change instead of using the following: Evaluate( "Field" & $FieldNumber ) Is there a way around this without using the "Set Field" in a loop.

I have a field set to validate by unique value. If the user enters a non unique value they get the canned filemaker error and the option to revert the record. How can I override this error in my script and have a custom error? Thanks

Hey, Now that FileMaker Go is here I want to set up a solution where workers on the floor can use an iPad but in the back office, we'd have a mac serving the solution. My question is can you write a script or script trigger that would automatically update and bring the newest record made on the iPad to the current record back in the office? Basically I want our workers to be able to make a record on the iPad, and as soon as the record is committed it appears as the current record on the mac. Now I've tried to test it but can't get it to work. It appears, but it isn't the current record (the mac hosting doesn't automatically to the last record). I guess what …

I am in the process of converting my Marina Management Solution from Filemaker 5.5 over to Filemaker 10. It is going quite well and Filemaker 10 Advanced is enabling a number features I have wanted to incorporate for some time now. However, While reviewing a number of scripts I have noted what I feel is a most peculiar event. Where ever I have utilized the script step "Go To Record/Request/Page(First)" or "Go To Record/Request/Page(Last)"; Filemaker 10 has created an extra "Go To Record/Request/Page(First)" script step prior to my original script step. See Attachment. What causes this and can I just delete the extra script step?

I'm not sure where to ask this, so here goes... thanks in advance for any ideas of how to handle this problem. I have a number (in a portal, if it matters) that is displayed to the user. I'd like the user to be able to do various things to that number (but NOT to be able to simply edit it). So what I'd like to have happen is the following: When the user clicks on the number, a drop-down menu appears (out of thin air; there was no drop-down item there before) and provides the user a few choices. The user then chooses something from the menu (and I blast them over to another part of the layout to do that), or they decide not to and mouse off and release. Is t…

I want to automatically play an audio file when a layout is displayed. I have an audio file in a container field. When I click on it manually it plays once. I made a simple script with a Go to field/select/perform command. I wanted to use the onlayoutopen script trigger to run the script. When I run the script, it plays the audio, but repeats it infinitely instead of playing it once, as it does when you click on the field manually. I have tried a million different ways of exiting the script, but none work. I can add subsequent script steps, which run, but the script seems to lop back and play the audio again. Any ideas? Thanks.

In a solutions I'm working on I have to import data from another file. To mark the records in the original file as imported I can either do Replace Fields Contents (needs to be done on 3 fields) or I could loop through the records using Set Field on those 3 fields. Anyone know from experience which method might be faster? On some occasions I could be dealing with thousands of records so any performance gains I can make, I think I should take them.

I recently upgraded to FMP 11 Adv from FMP 9 Adv. Whenever I use my Perform Find script button developed in FMP 9 Adv in FMP 11 Adv, the screen in Browse mode "freezes up" after performing a find because I cannot leave the screen mode to go to other screens. I even copied the Perform Find script example in FM tutorial and still get the same problem. The only way to unfreeze the screen is to click into Layout mode and then back into Browse mode again and everything is then back to normal. This is strange because I am preparing to bind a solution for a client. I am afraid what will happen if my client should do a Perform Find and will be stuck on the screen and do…

SCRIPT TO SHOW OPENED WINDOWS ??

This is probably a real simple fix. When I run a script that requests a new window, the original window resizes itself. Is there a way I can make it so that the popup window doesn't affect the size of the original window?

Hi, I am trying to do a page index script for different layout. I encounter a problem which is on the first page of preview, I cannot fill up all the page number with 1, and on the second page of preview, I cannot fill up all the page number with 2, and so on. Is there any way i can do it? thanks. Kent test.fp7.zip

I want to send a SMS to a mobile phone from within Filemaker, any easy way to do this?? Some of our clients have eMail and others are on the road SMS would be good

I'm not quite sure if "Interrupting triggers" is a correct title,so here's the question: When you have a OnRecordLoad script trigger set to perform a Refresh script, is it possible to trace if another script is already running and avoid executing the command in order to freeze the window and minimize flicker?

I need to create a script that will take all the files from one folder and copy it into 2 other folders. I have no idea where to start here. Thoughts?

i love script triggers i am aware of only onobjectenter() i want to use all to the peak level but i am not understanding plz can anyone give examples for each to check how they work plz plz

I am using FM Pro 11v2 on Windows XP and Windows 7. In one of my scripts I am using the "Send Event" script step to open a Windows Application. Everything works fine after I first set the path to the desired application and save the script. I can even close the file an reopen with no problem, but if I save the FM file to another name, or if I create a runtime app then everything breaks. Neither the copied FM file or created runtime can find the application - but it gets better. The original FM file no longer will work. I have tried all the various ways shown to represent the file path, most recently "filewin:/C:/Program Files/App Folder/App Name" Hope someone ha…

Hi. I typically find answers on my own but this one tops them all. A seemingly typical system: Invoice, invoice lines, Inventory of products (many to many). Products come under Groups, Categories, with three price fields - Purchase Price, SaleRef (expl. further) and Sale Price. All is fine but when products under Category 30 are selected prices are not copied to corr. invoice lines (actually show up as "0" - P, S and total). I tried manual change of Cat from 30 to 32 and all works fine again. The problem, I believe, began with the introduction of the following. Products may come from Inventory or be typed in. A global discount applies when t/s no…

If the file is already open, it is brought the front. If the file is closed, FM says, "The script cannot be found or has been deleted." The only option is to click "Okay." Then, the requested file opens and displays another error: "The previous script step, “Open File”, could not be completed because of an error. Do you wish to continue with this script? Option to Continue or Cancel. What the heck and I doing wrong and is there an error log somewhere that I can access?

In my training diary I am calculating Eddington Numbers. For a given numeric field this is the maximum number X such that there X or more occurrences with a value of at least X. I've got this working for Life To Date figures - this means you look at the full set of values. This has been done by having a script that counts the occurences greater than a given value X and also counts for value X+1. It uses fields in the Top level table (for which there is only one row) to maintain the counts. Now I am trying to do this to calculate the numbers for each year. This means it looks for that value X for the subset of days defined by each year. I have a related tab…

A client has a file of 78 country records. Each record has seven tabs, not layouts. Each tab displays different information about the country (population stats, economic stats, tourist info, etc.) They would like to print a PDF for each country that shows each tab on a different page of the one PDF file. Somehow they created one large document last year by creating seven separate PDFs with a different tab displayed for the 78 countries and dragging them into one file with Acrobat but it was very tedious. Thanks for your help.

i made a calculation z =(x)/(y*y) but z is having lots of decimals , i just want integer by using interger(number) can anyone help me please how to attch next step to above calculation

i made a date field but i want to make a script that auto enters unmodifiable date which will be created at the first time opening of my database

I am working on a database with 20,000 records. I have written a script that performs an action that I need to apply to about 15,000 of these records. What do i have to do with the script to apply it to a set of found records. Currently I have a button that I use on the records as I access them, but I would prefer to apply it to all the records that I need to at once. Thanks. PS: The script currently takes 9 values from 1 repeating variable and places those 9 values in 9 separate variables.

Hi all, I have a script that will send an record via email. I also create a table where a record is added every time an email is sent. On the second table I have a "result" field where I would like to enter either "successful" or "unsuccessful". Does anyone know how do this when using "send mail". Thanks RudyM

A text field, in which you can only enter data into in Find Mode, also has a script trigger: "OnObjectExit", which is also only run in Find Mode. When you hit Enter/Return, which is run first, the find, or the script trigger? I have a feeling it's the find, as I'm having problems avoiding fm's error when no records are found. Thanks, Unkynd

Stuck one more time.... I would like to add a script to the beginning of my “open script” that checks for a file somewhere on the hard drive in order to complete the open script. And can this file be a text file? Any help would be greatly appreciated.

Hi all! I am exploring the potentials of the "Send DDE" script step. I will use it to call DOS commands, and I would like to have a short guide regarding the parameters I can use (not parameters of the actual DOS coomands) - if any. For example, I have seen that I should use a line like: cmd /c .... are there any other switches like /c I should know about? Also, in case of another application, how can I have a complete list of the DDE commands it supports and how they must be called from FM? Any suggestions are greatly appreciated.

Hi everyone, looking for a bit of help please. I'm developing a database using FileMaker 11 Advanced. I have a button that fires a Send Event to open an external PDF document using a network path. This works perfectly on one PC (a Windows XP laptop) but it doesn't work on my Windows 7 Desktop. The 'Last Error' is 3 on the Desktop. This only seems to affect PDF files and not Word Docs, JPGs, etc, which open without an issue on both machines. This makes me think that it could be a file association issue or something? However, I am able to double-click a PDF on the Desktop and it will successfully open in Acrobat. Does Filemaker rely on Internet Explorer somehow? …

I need to re-populate a table nightly but it takes quite a long time to do so, are there faster ways? I'm launching a script that erases all records (340k of them) then imports a new complete list from ERP system via ODBC. My issue is the delete part, which takes some minutes. I remember FMP5 did this in just seconds... Does it really have to iterate through all records and delete them in order when all I want to do is truncate the table?

Hi, I want to be sure: it is not look possible to put a script trigger on record deletion, isn't it? Frank

I have an issue where I cannot set the size of two Windows to what I want. When I adjust the second window then the first changes size. I have tried scripts steps Adjust Window and Resize Window and both affect the two windows and not just the selected window. Surely I have not found a bug !

Hi, I'm trying to script a find that would search for multiple values in only one field. Basically, I have a list of values (230) of them that I'd like to find all at once instead of having to manually add find requests for each of them. The find is limited to one field. Any help is appreciated.

I have a database used to manage all my reptiles i breed. each reptile record includes a "mother Field" and a "Father Field" i drew up a family tree, when i select the parents for that reptile they show up on the family tree. now what im trying to get on the family tree is to show that reptiles siblings...meaning i want all the reptile ID's that share the same mother and father, is this possible? Thanks! any help is much appreciated B)

Hi, once again! My issue today is about the #20 error code and how to get over it. Here's the case: Currently I have a layout with OnLayoutKeystroke enabled for arrow navigation, which is called by a script that makes it modal (Let's call it MAIN). - (Looping until an OK or CANCEL script result is returned) The script running for navigation (called by the OnLayoutKeystroke trigger) also has a definition for when ENTER/Return is pressed, to select the current record and capture some variables. It is scheduled to then exit with an OK result, and should make the MAIN script exit the Loop (By an ExitLoopIf(get(scriptresult)="ok" or get(scriptresult))). But…

Hello, I'm a relatively scripting newbie and wondered whether anyone could get me started with a script that accesses two separate Filemaker database files. One file contains a list of phonathon volunteers (name, email address, and recordID). The other file contains a list (approximately 10 times more names than the volunteer list) of donors (name, email address, and recordID). I would like to assign a volunteer to each donor, and I would like the volunteer workload to be equal. I'm hoping for a script that accurately and evenly apportions donor names to each volunteer. I'm anticipating a script that counts the number of volunteers, counts the number of donors, start…

Hello, In a script, I am trying to set a local variable as one of the fields of the most recently created record. What script step will get me the most recent record? Every record has a timestamp create field but I don't seem to find any appropriate script step that will get this done. Could it be as simple as: :Show All Records :Sort Records (Decending by timestamp) :Go to record [First] :Set Variable [$local; Value:Appropriate field]

For many years I have been using an access database program for cataloguing a database of individual dolphin photo-identifications. The program is called Finbase (http://www.chbr.noaa.gov/finbase/download.aspx) and has a mapping feature that allows the user to see geographically, the location of all catalogued individuals. The GPS coordinates are stored in a field in Access and are mapped using an Access script and an ArcView plugin. I am an avid Mac user and have been modifying the database to work with filemaker pro and was wondering if there is a script that exists somewhere that will map GPS coordinates, either in ArcView or possibly in Google Earth?

Hi, I have a training diary with entries every day for the last 7 years. I want to track several week to date figures across numerous fields. Some as simple as week to date total other more complicated calculations. I've managed to get this to work by creating a self join so I can get at the previous 6 days. This works but makes many of my layouts very slow. I'm assuming it's because all the results are not stored. Since once a day is passed these values don't change they may as well be stored as a number. I'd like to move this over to a script and thought I could by using "Insert Calculated Result" but this doesn't let me reference the table view that gives th…

Hi, Is there any way to trap which field has produced the error code returned?

How can I tell FM11 to send a hex "07" command to our cash drawer? The cash drawer is connected to a Star TSP100 USB printer. The printer relays the command to the cash drawer via a cable with a 1/8" mini jack. FileMaker Stopped opening our cash drawer after upgrading to FM11 and Snow Leopard 10.6.4. It has worked fine for the past 4 years with FM8 and Tiger 10.4.

I have a database to track job numbers. In a layout I have each specific job with a portal that shows the notes I have made for that job (notes are from job_notes table). I have a button "add_note" that has a script that opens up a new window in add mode to add a new note. The problem is that I have to choose the job number from the new window. I'd like it to automatically choose the job number I was viewing when I clicked the "add_note" button. Is this possible?

i created a database then i switched to table view and have set so that only name fields appear in table view , i want to know how to go to the related record in form view when i click on a name in table view

FM10/11 Adv OS X 10.6.4 I need to be able to archive individual records and (on occasion) groups of records from more than 30 tables in a file that has been in use now for 5+ years. I have read the threads on this forum and others on the subject of “archiving records”, and they give some very good insights, but they are mostly from past years when the development standard was FMP 7, 8, or 9. Are there any good resources/example files/papers/articles/etc that might address archiving design and development in the context of FMP 10 and/or FMP 11? Any general or specific recommendations will be much appreciated. Thanks in advance! lpm BTW: The reason I poste…

Hi, I have one more problem I would like to ask you concerning setting a field to one from another table. I have a many to many reltionship between Patients and Doctors tables using a linking table (Doctor_Patient Relation), as a patient can have several doctors and a doctor can follow several patients at the same time. I am also a doctor and I have to make a report on a given patient and this is why I use Report Table related to Patients via "Patient ID". Now, when I create a report, I have to select a doctor in the report table to send him the report afterwards, and I do this via Doctor ID drop down list. As a patient can later change his GP and because I nee…

Hello, I'm trying to create a "splash" screen that will come up and stay up for the duration of my startup script. My Script goes through and verifies fonts, Scripts, Layouts, Etc. I don't want my users to see the whole sequence. So I'd like to just show a splash screen while everything else is happening in the script. Any easy way to add that portion to my startup script?

Hi, I am quite new to FM - 1 month, and it seems quite difficult to find an answer to my question in this jungle even it might well be quite simple for you guys. So thx for you answer. 1)Is it possible to use a variable with a "go to related record" - Something like "Go to related record ($Exam)" in a script? 2)How could I turn my script to get a field content value from a related TO without using GTRR and then come back to my initial layer? Thx

Im a mac user but need to modify a script to allow for PC users. 1.I wish to save a report as a PDF using a field content as the file name. 2.User will decide where to save. 3.Wish to copy a duplicate PDF to fixed location on a server. thanks

I am trying to pick out the third and fourth number from a serial number. I know I can use 'set selection' but can only seem to copy and past with that. Is there something I'm missing to enter numbers from the middle of a field into a variable for a calculation?

Hi, I am working on data separation model concept.according to 1 example file from one forum .i have developed my own file now acc. to forum scripts and value list should be create in DATA file but i am not able to work with this concept . in my GUI file when i put script on 1 button and call that script from DATA file at the step of "Set field" or "Go to layout " it pauses in between . so tell me how to work. if there is any example file where scripts ,value list are working properly from Data file in GUI file .please let me know.

I am using File Maker as an HR front end to active directory on a windows server 2008. I am using IWP for our global offices. When a record is modified I have a script that exports the data to a csv file, then a powershell script runs that updates AD. I have an event trigger in AD that in turn updates our Gmail accounts. My problem is that I need the server script to be triggered when the record is updated not on a schedule. Is there any way to trigger a server side script by an event compatible with IWP?

I've been searching the forum for several days now looking for a way to require a unique value without using the built-in field validation. The reason I don't want to use the built-in field validation is because it is executed on field exit, which prevents me from triggering my own script and carrying out various commands based on the validation. For example, I don't want the user to be allowed to go to another layout if they didn't enter a unique value when creating a record. Users are creating reservation records in the reservations table. The reservation ID is a concatenated text field that combines lab name, date, and timeslot. I'm trying to do so…

Hi all, Hope all is well at your end. I am having a database that is created in FM9 I am having a problem with send mail functionality when the application is run under Mac environment with Entourage as a mail client. The mail gets saved in the Drafts folder rather than the outbox or Sent items folder of entourage and the mail is never sent. I am using the normal send mail script step of filemaker 9. Any help would be highly appreciated. If anybody knows the email ID of the concerned technical staff at filemaker , plz provide it to me, then I can write down this problem to them itself.

I have my database set up to automatically generate a serial number upon creation of a record. The problem i am having though is that if a coworker or myself makes a mistake and inserts and then deletes the record, the next inserted record skips the deleted number and goes to the next. How do i set it up that it does not skip to the next number? I would like to be able to add a new record that then follows the previous record without any conflict with a deleted record. Please Help.

I want to be able to set a boolean field, IsModifying, to indicate whether certain other fields in the record, say A, B, and C, are in the process of being modified. (If they are, I will program my scripts to block certain other operations on the record.) For each of the fields A, B, and C, I set up two script triggers, one to set IsModifying to 1 OnObjectEnter, and the other to set it to "" OnObjectSave. However, it appears that the closing script trigger gets invoked only if the value changed. Exact same problem if I use the trigger OnObjectValidate instead. So if a user enters the field A but in the end doesn't modify its value, IsModifying stays set to 1 after the use…

Is there an easy way to add "field A" from the previous record with "field B" from the current record being browsed? Thanks. Gary

HELLO! Can you format selected text using a script? For example I have a field called [note], I would like user to be able to type in the field and have the options to format selected text to... - bold - italic - color change - larger/smaller font size I would have buttons by field for user to call on. Any help or suggestions? THANKS!!!!

I have a schedule button that goes to the schedule layout. I'd like the button to do a search and return only the results for today if it is before 6:00 pm and for tomorrow if it is after 6:00 pm. Is there an IF function I can use for this? Just to clarify, I mean 6:00 pm actual time right now not the appointment times. Something like If (system time < 6:00 pm ; find date // ; // +1)

Hello Folks! I came back from DevCon very enthusiastic with my iPad and FileMaker Go. I wrote a custom function that I thought would be a great time saver. It returns if the Ipad or iPhone is in portrait or landscape mode (it can be downloaded from http://www.solucionesfilemaker.com/demos.html) The thing is that now I want to attach a script trigger to the function and it does not work On objectModify does not work at all. Any ideas? Best Wishes, Diego D'Alessio Buenos Aires - Argentina (the southernmost FileMaker Developer of the world?)

I am curious how people deal with Record locking with their scripts. Is there a way to kick someone out of a record? So your script can take control of it. Or do you simply test to see if the records are available, then lock them? What happens if someone enters a record, while the script is running.

I use the show custom dialog with a field in it for scanning in bar codes.... That allows the 'enter' after the scan to have the script to continue. Some boxes in the file have a lot of other information in them and at times the box shrinks back down and doesn't show the user there's more info in there. SSsssooooo can they be set to a certain size? I did a search but don't see anything on it. Or Ideas?: I'll be on the road today but'll check back in tonight. Thanks Ps - without using Troi???

Is there a way to display a message for X amount of time then have it disappear or change to another message. I need this to be IWP compatible.

I have three tables Products: id, name, category_id, description Categories: id, html_template CategoryFields: id, category_id, key, value The relationships have all been setup properly. In Categories::html_template I will have something like this {name} {size} {length} {width} now each of the keys (name, size, lenght & width) will be entered via the CategoryFields table. So every Category will have a different set of keys. Inside the Products table I set they key values using a portal. For example name = "T-Shirt" size = "M" length = "50cm" width = "100cm" I have a button that will copy the Categories::html_tem…

Iam on F10 and FM11. Have a table of contacts. For various reasons these contacts may be related to one another. I created a relationship table that contains the record id of a contact and the record id of the related contact and the type of relationship. When a user is viewing a contact they have a portal they can use to establish a relationship with another contact. The issue is that users know about the name of a contact but not the record id of a contact. I want the user to be able to go to the portal, scroll through the list of existing contacts, select one, specify the type of relationship, and establish a relationsip with that contact. Really looking for …