Script Workspace and Script Triggers

FM 11 Adv. I use two printers in my work: a laser and an inkjet. The laser is the default and I do a lot of quick printing with Ctrl+P. Occasionally, I’ll print to the inkjet. But FM remembers this and the next time I want to print to the laser I have to remember to select the laser in the Print dialog (bummer!). I thought I could get around this with a scrip that prints to the inkjet and then resets FM to the laser My script has two printing steps: Print, which prints to the inkjet, followed by Print Setup which I set to the laser. However, after I run the script I find that the Print Setup setting has switched to the inkjet! What’s going on? Is there any way to do what…

I am a beginner for scripting and I like to do a multiple if statement script like: if "this=x" and "this=y" then "result=z" please find the attached picture of my script. I tryed to do that but it isn't working. Maybe only missed some ( [ ] ) mark or something? Could somebody fix my code or suggest a different solution? Thank you GaborÂ

I've been lurking on this forum for weeks building scripts into this database, but I'm finally no-kidding-stuck and need some help! We have a layout that shows 100px images for reference purposes, but users are dragging giant images into them. I'm trying to create a script that will take an image in a field, resize it to 100px and replace the original. The result would be that the field now has a 100px version of what it used to have. I wrote an AppleScript to run when the field has new content in it, but I can't get it to work. tell application "System Events" keystroke "c" using {command down} end tell tell application "Image Events" set currentImage t…

Hi all, i have a script that I want to use on four different TO's and as part of the script the Table Name is set up as a variable.This works fine if I am working on either all records or just the current record but In part of the script I want to perform a find, the same one in each table, and then perform an operation on this found set. Can the variable $Table_Name be used at all to accomplish the table portion of the Set Field step

Is it possible to populate a field in every record that shows up in a portal with data from a different field. I don't know that I need to constrain to just the records showing in a portal but at least to just the associated records of the parent. Like a portal showing tasks in a todo list for a single user and you want to set a field on each record in the portal to complete. Not completely necessary at this point but I would also like to be able to use this same technique if I am viewing a portal that show a limited criteria say tasks created before 2 weeks ago. In this example I would want the functionality to only change the records being displayed in the porta…

I use FM to store JPGs of sales receipts. I would like to create a script that prints the contents of the current container field.

Hello everybody, I'm just starting to learn FM and this is my first question here. Thanks in advance for your attention and patience. I have designed a read only layout with non editable fields so user can check the values of every field but no change the values. The value of every field is a "id_customer". I need to run an script by clicking on every field and I'll use the field value later in the script. I'm trying to use GetFieldName ( Evaluate ( Get (ActiveFieldName ) ) ) but it doesn't work because the field is not active when I click on it... Somebody can help me, please? I need the field name or the field value in order to run the …

This is my first post. I tried to attach my file but for some reason I keep getting an error saying "No file was selected for upload" I made sure to ZIP the file and it's just over 11MB's....any ideas?

Hi All, I currently have a script which chooses the output layout based on a clients language preference, which works fine, but I wondered if there was a way to just use one layout instead of seven by having a field show depending on which language preference is returned. I would then just create the field contents with the appropriate text merge parts in the various languages and just show the one required for output. As ever, any help or just a "No, you can't do it" is appreciated.

I can't tell which forum this issue belongs under, but here's my problem. I frequently get the message "this record cannot be modified in this window because...", I know the reasons for this error message usually involves the commitment of records. However, what happens is that FM for some unknown reason has opened a new window (It appears in the Widow menu). I do not create new windows while I work and none of my script have this script step. What are new windows being created? This is not the same thing as switching layouts (or is it)? I've tried various tests by entering data on a layout field and in a portal then switching to a layout with the same field. But I can en…

Hello, I have a set of records (Samples) to print. Many of the samples have a child record (Letters). I need to print the Samples from paper tray 1 and the Letters from paper tray 2, and I need to print all the records in order. Something like Sample/Letter/Sample/Sample/Sample/Letter - Each Sample, then the letter attached to that Sample, if present. So what do you guys think? Possible? Impossible? Needing a plugin? I'm looking for any ideas or suggestions you might have. Thanks

We have a large number of hosted (legacy) databases running on FMP11 Server Advanced. Most of the time, our users will open these databases directly as they need them. Under these circumstances any start-up script that is set in the preferences will run automatically. However on occasions databases are opened indirectly as a result of a relationship becoming active or when a remote script in an unopened database is called from a script running in the current database. Under those circumstances, it appears that the start-up script does not run. Databases opened in this way appear in the window > show window item on the menu bar, so users can - and do - select them…

Hi friends - Back here again after many years to ask some of your first-class advice please.... I have a very old solution which I recently converted from fp7 (can't even remember which version I originally created it on) to FM12 and am checking performance. Windows Vista on a trusty old Dell laptop. There is a script triggered by a button, which pauses indefinitely for user input. Many moons ago, the script would resume when the user pressed Enter on the keyboard. Now, it will only resume if the user either 1) clicks on 'continue' in the status toolbar, or 2) presses Ctrl + Enter 3) clicks out of the field, then presses Enter So if I have the button…

I'm trying to set up a new tracking database within our current database. Currently I am setting up a new script to pull info from one layout and to create a new record in another layout. Here is theh script so far. Copy [select; ADS::ITEM NUMBER] Go to Layout ["Tracking" (TRACKING)] New Record/Request Paste [select; TRACKING::ITEM Number] Insert Current Time [select; TRACKING::Time out] Set Field {Activity::User Name; Get ( AccountName )] Go to Layout [Origional Layout] I am tyring to insert another field that pulls it's info from a Value List in "ADS" and just records what that item is in the "Tracking" layout. The value list in "ads will be changi…

Hi y'all, I am having trouble with a script. I need to omit a lot of things but this script just omits the 90 Closure and then leaves 03 Dead and 02 Hold in. I am obviously doing this wrong. I tried doing "90 Closure" or "03 Dead" or "02 Hold" but that didn't work. Is there a way to do this that will work? Â Thanks!!

Im trying to create a report that shows all unpaid invoices. I was trying to find all records that have a balance that is not equal to zero and have tried few different approaches, but i am not getting the desired result. Any help would be greatly appreciated.

hi,  Looking for a kind helping hand from the community,  I have an email alert script that runs as part of the Startup script.  this script looks over the database and finds dates that are nearly about to expire (30 days before the date) and triggers a pre-set email alert if this criteria is met.  However on FMGo the alert is not properly taking the information into the email that gets generated.  The script was designed to pull related information from the users account information (same user who has the date) and then pull other fields into the email such as 'First_Name' etc.  Issue:  This script is running fine on FM12, but is not working at all on …

Hello, I am using FM to manage data for an event management company. I am looking for a way to auto-populate Estimate Lines for an Estimate of a particular Event. I have found that certain Event Types (Dinner, Cocktail Reception, etc) will have same/simliar Estimate Lines (i.e. the same same collection of Items, with same/similar Quantity, Hours, etc). I am currently doing this by having a separate "Estimate Template" table that mirrors the fields in the Estimate Lines, with quantity and hours values inputted. I run a script that will find the appropriate Template records that match the Event Type. The script will then export these found records and then im…

hello, i hope someone can help me with this. I am creating a field that is a concatenation calculation, the purpose of which is to combine multiple pieces of information into a unique number that will be used on our contracts. One of the pieces of information to be included is the date of the contract. I am picking that up from a Creation Date field and trying to GetAsText so it will appear in the concatenated number as just a string of digits (say, 021513.) Currently that is how I've formatted it to appear in the Creation Date field. But when it gets picked up, even with GetAsText, the date formatting returns" 02/15/13." Here is what the concatenation calculation…

Although I still consider myself a novice, one thing I've learned over the years of developing FM applications is the importance of frequent backups and testing. While developing a new program, I like to maintain a history so I can look back and see what I did in the past. I also like to test scripts that create delete or modify records without the fear of altering the original records in any way. I have written two scripts to do this. Backup script creates a copy of the current file and places it in a folder named Backup located in the parent folder (the folder that contains the development file). The scrip appends the word BACKUP, a backup number and a date to t…

Poject compiled by FIleMaker 12 Pro Advance on a Windows 7 not working on Windows XP? Is there a solution for this problem?

my solution has multiple windows that open out of a "main menu" window. the user can only close the database from the main menu window. i want to make sure the user has closed all of the open windows before exiting the file via the main menu window (window is called "Main Menu") - if not, a simple dialogue saying "there are still windows open" should be displayed. as i'm not looking to check for a specifically named window, what function will return whether other windows are open? this script should not consider the "main menu" window. this is the first solution i've developed that is using multiple windows, so help is always appreciated. cheers!

Hi guys. I have two ralated databases named Invoices and Products. The Products database has a list of different types of products but only some of them are new. My Invoices database has a portal to show the products that I am going to bill under each invoice. Now, sometimes I have to include in an invoice ALL the products that are new, and I want to import them all at the same time by clicking a button instead of selecting them one by one in my portal. How can I do this? Thank you.

I have a field (days) that I want to trigger an email if days <31. How do I get the script to run when days <31?? TIA

I have a script that performs applescript on database A. At the end of the applescript, it does a "tell application Filemaker Pro" and sends the result back to filemaker pro to be stored in a result field. It works fine when I run the script from database a. I try to run the script (containing the applescript) from another script in database B from a different machine (script on database b runs the script on database a. The script/applescript run fine, but it doesn't return the result to database B (or A). Any ideas on how I could obtain the result?

I copied a filemaker database "Data 13" and renamed it "Data 14" with all of it's scripts and layouts. I needed to change the name of the database in the script to "Data 14". Here is the script: tell application "FileMaker Pro" tell document "Data 14" set spotPath to cell "SPT_PTH" of current record end tell end tell tell application "QuarkXPress" set spotPath to spotPath as alias activate open spotPath use doc prefs yes end tell Now I keep getting this error: "Expected end of line, etc. but found identifier." on the word "use" in the script when I hit ok. The script still works in the "Data 13" Database. Any help? Thanks Rob

We are wanting to send emails to a group of emails based on a search. For example, we want to run a search (custom each time) based on a particular criteria in our Customer table, then send a email to each of those Customers within that search. We have a Email table, which will keep track of the emails. So in my head, it would be something like this (after we performed the search): Allow User Abort (Off) Go to Layout (Customers) Loop Send Mail: Subject Email Table::Subject Message: "& Email Table::Body &" Go to next Record End Loop But I feel like I'm missing something in my logic. Or is this even possible?

FM 11 Adv; Windows 7 Professional. I want to use two scripts for printing to a HP OfficeJet Pro 8600 printer, one for portrait and one for landscape. However, when I set the print step in one script and then the second script, the setting in the first script switches itself to the setting in the second script! For example: I set script A to landscape and then set script B and to portrait. When I check script A the setting has switched itself from landscape to portrait! What can be causing this?

The task here is to extract thousands of jpeg files in container fields and export them to a particular folder. I'm guessing I can use the script: Export Field Contents [; ""] ... and loop the script with variables set. The field name is Clinical::LabReport. I would like to set the to the field contents of the PatientID field, that is unique in each record. This is where I need help; defining and implementing the variables, and the script steps to loop the found set. Hope this is possible. ~Dennis system: MacG5, FileMaker 8.5.

Hi,   I have activate keystroke to fire the script,as i press p for the print preview,it shows message which i attach as a screen short,i want to remove this message,how it can be done i have attached script also which i put it on layout setp,script is fir from the script trigger onlayoutkeystroke.

Hello! Thank you for this very helpful community I am using the OnLayoutExit trigger on one of my databases. On the same layout I'm using a go to related record script that goes to another layout. 1. With OnLayoutExit ON the Go to related record button doesn't work properly 2. With OnLayoutExit OFF the Go to related record button works properly I searched around and I didn't find a solution for this. What do you recommend? Getting rid of the OnLayoutExit script reduces efficiency in my database, I want to avoid having to turn it off. Do I have to create a specific script for each GTRR button and suppress the triggered script?

I had thought that when you attempt to delete a Record that has child records set to also delete upon a Parent deletion, Filemaker responded with a prompt that said something like "Do you want to delete this record and all child records?" Did I imagine that? I guess it might be that when I made layouts with the Status area hidden and only allowed record deletion via a scripted button, *I* had included that warning in the script. But now that I generally leave the status area open and in cases where I want to allow users to delete using the keystroke or standard Delete Record button, is there any way I can include a warning such as this? All it says now is "Perman…

I'm a fairly new, but quick-learning user of FM 11. After performing a search, I would like the user to be able to select a record from the found set to edit by simply clicking on a field of the record, which would then select that record and switch to the layout used to do the editing. For example, searching for all people with outstanding balances, clicking on the name of a person with an outstanding balance, and being taken to the layout that allows their account to be edited. I can get the search done, but the clicking to select a record and change layouts is causing me issues. Any suggestions?

Hi all Apologies if this is way to trivial for all of you seasoned experts. I have wrote this script but it does not work. Any ideas of I can get this to function. The field for carbonvalue works fine and all I need this to do is bring up in red text the below warning if no value is added in to the field below. If (IsEmpty (carbonvalue); "WARNING! The field for carbonvalue is empty. Please inset appropriate value before proceeding." ; "" )

I am trying to gather stock data from websites, such as yahoo finance. I've tried using the insert from url script step, which gives me the entire source code, but appears to have some irregularities between the source code and the actual site data... i am capable of using this, and parsing it to find the appropriate values i need, but the values are inconsistent... i've done some research in extracting from XML sources, but literally have 0 understanding of how this works... i tried copying an example I found, but it didn't work... does anyone have any advice on how i can gather this information from such sites, easily... (it doesn't have to be yahoo, just an…

Can script triggers be used to prevent fields from being modified? I tried returning false (based on certain conditions) on keystroke, but it doesn't work with checkboxes and menus, and it doesn't prevent pasting. If not, and I have to use the security settings, is there a way to customize the error message?

Hi everyone, Is there any technique to fire the script through the right click on mouse.on clicking the right click the option of script comes. on choosing the particilar script it fires

I have a database with a date field called "Received". By default, my users need only see the last six months of records, only occasionally needing to see beyond that. I can't figure out how to script this find. I intend to use it in my startup script -- unless there's a better way. I've Googled it and nothing seems to work as I was hoping. I am using FileMaker Pro 11 Advanced. Any help would be appreciated. Thanks! Kevin

Hi All, I have a script to either email or print data to a client. The data consists of a letter from one table and client Installation data from another table. The script runs fine until the Send Mail when I get the error 1506. It actually sends the mail but only attaches the first PDF. Script; Update_Letter_Current_Record_mail Go to Layout [ “Installations” (Installations) ] Copy [ Installations::Inst_No ] [ Select ] Go to Related Record [ From table: “Clients”; Using layout: “Clients” (Clients) ] [ Show only related records ] Go to Layout [ “Clients” (Clients) ] If [ Clients::Language_Pref="Eng" and Clients::Send_Mail="Yes" ] Go to Layout [ “Update_L…

Hi I have been a .Net and other programmer for many years but only just started doing some work withFM. I am tasked with writing an import routine from a tab delim file. I have started an import script and set up filed mapping but many of the fields will require massaging after import. I am loading the ones that need work into temp fields and want then to run a further script to manipulate the data to clean it up and make it more suitable for the new database. What I can't see is how to get to use all the FM functions I see in the doc files that allow me to do things like string manipulation etc (Right, left, replace etc). Is it possible to do such thing…

Hi, any help here greatly appreciated ... Â I have a simple table that has the fields: Job Number(Number), Start Week(Number), Job Interval(Number), Job Description(Text). Each job can start on any week (up to 52) and can have an interval of any weeks (up to 52). Â So a job with Start Week =1 and Job Interval = 1 will happen every week and a job with Start Week = 8 and Job Interval = 12 will happen on weeks 8, 20, 28, 36 etc. Â I am trying to write a Script that will print out a year's jobs to a PDF file for printing later. I have broken it down into 2 Scripts as shown in the screenshots. It's not working so if anyone could point me in the right direction, then…

Hey All, At my company, we ship on twice weekly schedule. Therefore we usually know our shipping dates well in advance. Our shipping guy inputs the shipping dates into a FileMaker table so that the salesmen can assign their shipments to a particular Shipping ID, to ship their sale tomorrow or, if they like, next week or next month. So basically the "Shipping ID" table is 2 fields, shipDate and shipID. We've got past, present, and future dates in there. On a layout used by the shipping dept, I have a portal which lists all the ship dates in descending order by date. To see what's shipping for a particular Ship ID, the shipping guy scrolls to the ship date he's int…

We have a database for our cabinet making business. For each estimate created, there can be several items costed (ie Kitchen, Laundry, Vanity). Each item is assigned an item ID (_pkItemID). There are two parts to the costing - time and materials. I want to be able to import a profile into the costing time section rather than having to enter each task in individually. So I have created a profile table - and created a template of task records that get used for costing time required to complete various tasks for each job. There is a global field called _fkItemID for the actual __pkItemID value to be pasted into prior to import. For some reason the script - which con…

I can not seem to get the script step 'Save Records as Snapshot Link' to work when running this script via the fmsever (via schedules). Filemaker indicates that this step can be run on the server. It will however run when the database is open on fmserver computer via filemaker. Â Attached is a screen shot of my basic script. I am sure this is a better way to display this. Â Â Â

This is my first, what I would call, complex script and was hoping to get some feedback on its' efficiency. It is used in a timeclock solution for a filemaker GO "app." It is intended to perform the following actions (same order as in script attached): 1) Verify all records from that date are marked as complete. (eg: Cases::Complete=1) 2) If okay, go to time clock, sort based on "time out," making sure the most recent record is empty. If not empty-->display error, unsort 3) If empty, time out as current time 4) Email copy of entire DB. It performs all of these actions without error, but I'm sure there's a way to make it better. Thanks in advance for…

This is my first, what I would call, complex script and was hoping to get some feedback on its' efficiency. It is used in a timeclock solution for a filemaker GO "app." It is intended to perform the following actions (same order as in script attached): 1) Verify all records from that date are marked as complete. (eg: Cases::Complete=1) 2) If okay, go to time clock, sort based on "time out," making sure the most recent record is empty. If not empty-->display error, unsort 3) If empty, time out as current time 4) Email copy of entire DB. It performs all of these actions without error, but I'm sure there's a way to make it better. Thanks in advance for…

I am looking to increase performance on a search script I have built. I have a layout in list view. I have a button and script that is preforming a search(s). I believe the search is taking along time due to searching related records via a portal. I am looking to preform a search of a field in the main table I am working from, then only search the related table for records within that found set. I have tried preforming a search then omitting records with the constrainFoundSet script step then showing only omitted records. However it seems to take just as long as just preforming one search with all my criteria in a single step. Are there any known best pr…

I've got a library with 1000's of books so to make it easier I have placed letters A - Z for the user to click on and bring up only those books starting with that letter. I really don't want to write 26 different scripts to do a Perform Find for A, B, etc..., so each of the text letters which have the script button attached to them, I gave an object Name A, B etc. and used the script; Set Variable [ $abc; Value:Get(ActiveLayoutObjectName)] and then used the variable $abc in my Perform Find.....But it doesn't work! I did some tests but it seems that Get(ActiveLayoutObjectName) doesn't work when clicking on buttons. Am I mistaken? Is there another easier way…

Hi, I am trying to write a login script that works by username. If adnin logs in he goes to an admin layout and if a user logs in they go to their layout. I was using Get (username) but its not working properly. Any ideas?

I could use some assistance with a script that would export the records to an excel file for each sales rep in my attached sample file. My sample file has 3 sreps and I'm including 3 excel worksheets which contain the records for each rep which I manually created. I'm sure it will involve a loop within the script and I always struggle with that. Any assistance is greatly appreciated whether that be updating my sample file or pointing me to a spot on this forum where this issue may have been posted before. Thanks T.J. SrepLoopScript.zip

I have a client who wants to be able to store screenshots in container fields in an existing database hosted by FM Server. Ideally, I'd like to script the process so the following occurs: 1. Client saves screenshot to clipboard in OS, then clicks into container field. 2. Container field is a script button 3. Script does the following: a. navigates to an image storage folder located on the server. if the proper folder (based on record number) does not yet exist, one would be created. b. exports the original screenshot image to the folder c. imports the screenshot back into the container field as a reference Since the client does not have the serv…

I have heard of a store's point of sale system being able to scan a driver's license using a regular magnetic strip card reader and have the name / address automatically fill in to their system. I would like to do this for our store! Here is what results from a scan of my drivers license into TextEdit (information altered to protect my identity) %MNOAK GROVE^MARK DONALD LARSON^1234 STREET NAME DR S? ;012345678901234567=01234567890123? Has anyone ever scripted this into FileMaker? Would I have to pay attention to different states' formats or are they all the same?

I need to have a start up script. I am trying to find a student with a code on then go to that person's record in one of three tables. The database is called BHS_Registration. I have a special unique code for each student with the field name: Reg_Code I want the database to find the student based on the code and then go to the correct table based on the students grade level. Here is the script I have so far. It goes to the Students table, it finds the correct student, but it stops there. It will not go on to the correct grade level table based on the students GRDE field.. Go to Layout ["StudentFind" (Students)] Show all records Enter Find Mode [Paus…

I have the following script: Set Error Capture [ On ] Set Variable [ $filterDate; Value:Get ( CurrentDate ) - 2 ] Go to Layout [ “SecPrices” (SecPrices) ] Perform Find [ Specified Find Requests: Find Records; Criteria: SecPrices::date: “≤$filterDate” AND SecPrices::secPriceValid: “Invalid Price” Find Records; Criteria: SecPrices::date: “≤$filterDate” AND SecPrices::secPriceValid: “Ccy Mismatch” ] [ Restore ] Set Variable [ $lastError; Value:Get ( LastError ) ] Set Variable [ $foundcount; Value:Get ( FoundCount ) ] Send Mail [ Send via SMTP Server ] [ No dialog ] If [ $lastError ≠ 401 ] // Delete All Records [ No dialog ] End If The script wor…

Hi all, I'm working on a hosted FM 11 database that all of a sudden couldn't find its startup script. The script still exists, has not been renamed, file options haven't been tinkered with, and there's no history of any of the usual suspects that would cause file corruption. The script resides in the same file calling it at startup. Has anyone seen this behavior before? Thanks in advance, -Kent

I want to scroll down the page a little bit after a script step of return to original layout. I have tried set selection to a field where I want to scroll too then scroll window to selection I have tried go Go to field scroll window to selection Neither do anything. It just go back to the top of form. Thoughts? Thanks Thom

Hi, I have a layout with 2 portals on it. I'm trying to write a script which loops through the second portal but when I use "Go To Portal Row", it automatically takes me to the first portal. If I click on a field in the correct portal right before I run the script it works fine but I'm wondering how I can specify which portal I want to use from within the script? I'm fairly new to fileMaker. Thanks in advance for any help

I need to place arrow icons on screens which drive script steps to allow users to scroll right and left. Any ideas? Thanks

I am trying to copy the contents of a container field from one table to a new record in another. Is there a way to do this without finding the specified record, then importing that table into the second table?

I recently had to switch to a new Mac, how running 10.7.5, and moved my copy of FMA11 over to the new machine, then updated it to the latest 11.0v4 version. The new installation works normally in every regard EXCEPT there is no menu bar in the Manage Script window, and when editing a script there is no script copy/paste option shown. In other words, it seems to have installed as standard FMP11, not FMA11. The CD is correct, the serial is correct, and it is only installed on two machines, and the other installation is on a different network (my home). The same CD was used to install into my home Windows XP machine and the prior Mac 10.5 machine, and worked perfectly…

Hallo, I would like to ask, it is possible to create a new Record without step go layout in the script, ...and subsequently insert the value of variables to field SetField(). For solution to create relation table. (Table contains only id records) ... in the background. Thank you.

I am trying to compare the modification timestamp of records in a FM database, vs those in a SQL Database. The FM timestamp is formatted: 6/13/2011 10:55:11 AM The SQL timestamp is formatted: 2012-04-26 14:57:03 As a result running a calculation on the two timestamps fail. It appears I have to format the SQL timestamp differently. Does anyone know the easiest way to parse 2012-04-26 into values that I can use inorder to use the "Date" Function?

For some analyses, I have a script that is working fine determining the number of records meeting various constraints, but the finds seem to slow things down. For example, out of ~3500 total records, I can narrow down the found set to the ~40 records that correspond to one parameter (determined through some related tables) and then the ~20 of those that meet a second criteria, e.g., a field called due priority contains "Overdue". The script uses combinations of finds, extend finds, or constrain finds to count the various subsets. Am I just being lazy? • Should I just add a calculation to each record and then sum up the new field to determine the counts for the s…

I have a script that finds set based on Field: Date Ordered, where (based on a LaRetta solution) Field: "C_Tax Period": Calculation: Indexed: Year (Date Ordered)"." (Month (Date Ordered)/100) Field: g_Tax Period: Global - this appears on the layout with a List Value attached based on c_Tax Period result with a button, Perform Script: Find Tax Period, where Enter Find Mode Set Field: c_Tax Period; g_Tax Period Perform Find This gives me all Orders within a defined date range. Question: How can I constrain or modify this found set to all Contacts: Country ="Canada" It seems like I have two Finds but I cannot find the right syntax to constrain…

I created a pdf file via the 'save records as pdf' script step and now want to display the contents in a container field. What do I do? On the Mac, I use 'Insert Picture' script step and see the contents. On Windows I've tried 'Insert Object' but just get a reference. What's the Windows equivalent? How do I display the contents of a pdf file?

Hello I am trying to script a search - Search 'Date Ordered' (date field). My steps are Insert Calculated Result - Target field, Financial Year Result, Case ( INVOICES 2008::Financial Year = "Year2011";Date ( 1 ; 1 ; 2011 )&"..."&Date ( 12 ; 31 ; 2011 ); INVOICES 2008::Financial Year = "Jan2011";Date ( 1 ; 1 ; 2011 )&"..."&Date ( 1 ; 31 ; 2011 ); INVOICES 2008::Financial Year = "Feb2011";Date ( 2 ; 1 ; 2011 )&"..."&Date ( 2 ; 28 ; 2011 ); INVOICES 2008::Financial Year = "Mar2011";Date ( 3 ; 1 ; 2011 )&"..."&Date ( 3 ; 31 ; 2011 ); Financial Year is a Value List, Year2011, Jan 2011, Feb2011 etc. I am trying to d…

First of all, I hope everyone here along with your families, friends and loved ones have a very safe and prosperous new year. Now, I'm not really sure where this belongs topic wise. It could be either layouts, portals, tab controls or scripting. I have a layout that contains tab controls, outside the tab controls are fields that pertain to all the info that belongs within the tabs. Static info if you will. In the attached example, the static field is the TourID field. Contained within the tab is the Tour Expense information. It contains two portals, one for cash received and the other for cash spent. No problem so far. The problem I am having is this; …

Hello! Wonder if anyone has run into this. I have a layout, and within, a portal showing related records. (Parts for a particular job) When an update for a part occurs, I need that field, the user name, date and time to be logged - like an audit. The script I am using works fine, HOWEVER, from inside the portal (where the changes occur) it keeps logging the changes for first record in the portal or just repeating it into the audit log - not the one being updated. If I update the first record in the portal, that works ok... if I take the table/layout out of a portal, it works just fine, logging individual records. It's being in the portal that appears to be the proble…

This seems like it should be very easy. But, I'm not seeing the solution here. I am creating a filemaker script that creates a variable of a list of files. a.jpg b.jpg c.jpg d.jpg e.jpg I need to be able to loop through that list and do something each time. is there a way within filemaker to specify item x of the list (similar to applescript)?

I need help. For some reason the Perform Find I am currently doing does not work. However, the records do exist. I did a Show Custom Dialog to view the content of the $FactureNo variable and it displayed "214321" which is the correct information. However, the find does not find any records with N°Facture being equal to $FactureNo. Why, am I missing something ? I've attached images showing different outcome while performing this operation. I am really lost here. Many thanks for your help! Daniel 1 - Faire CommandeCLient_Facture.tiff 2 - PauseResume Script.tiff 3 - After Perform Find.tiff 4 - After Find - Show All.tiff

Hello, I am using FM12 and one of the new features is being able to drag-and-drop images onto container fields. My question is how am I able to script when someone drags an image onto the container so as to run some backgrounds operations? Another issue, is that the default storage for drag-and-drop is to include the image in the database, rather than a reference (which I prefer to do in the solution I am working on). Thoughts on how to use drag-and-drop with scripts? Thanks, Stephen

I'm not sure if this is a scripting problem or a layout problem. I have a related file that only contains one record of a map. This one record has numerous layouts showing different areas of the map. My problem is when I access the map from the related record it populates a layout field and then a script takes me to that layout. If someone else tries to view the map it won't let them because it says I am editing that record. I can have duplicate records of this map because it's only used for viewing. There are no changes made to the map. I was wondering if there is a way the system can see that the first record id locked and just go to the next record. I only have…

I have two databases. The first one is an eCourse where the user interacts and gets information. Then at the end of the course they go to a testing database. I have scripted for the first database to close and then the second one to open. But I am getting a hestitation where the monitor goes back to the first database shows it closing with the window looking like it froze and then it closes and goes to my next database. How can I get it to do it seamlessly so the user does not know what is happening? Open File[firstdatabase] Perform Script["GoToFirstRecord"from file:"Haltfirstdatabase"] Close file[Current file]

Hello All I would like to create a script (that displays a message) that is activated at startup when the current date falls between two specified dates. I tried the following: If Get(CurrentDate) >= "01/12/2012" & Get(CurrentDate) <= "08/12/2012" (DD/MM/YYYY date format) Beep Show Custom Dialog ["REMINDER NOTICE"; "Begin buying Christmas presents"] End If .... but it is not working! Any suggestions? Frank

I have a button that has attached to it a script that when clicked, updates the database. However, when users enter Find mode, if they hit the button instead of perform find, it updates everything inappropriately (YIKES!). Is there a way for the button to know what mode the user is in and either inactivate when in Find mode or to add an ignore statement within the script if in Find Mode? I didn't see where I could "If in Find Mode, end, end if". Appreciate any and all advice!

I have viewed many tutorials and asked many developers to help me get to what I have already. What I have not asked is the following question: How do I populate my portal? Ok, here's what I have. An Attendance Solution that has three tables: NAME: _kp_name_id name enable DATE: _kp_date_id _kf_name_id _kf_status_id date STATUS: _kp_status_id status They are joined by the obvious keys. Lets say that the NAME table has four records: Bill Enable Mary Enable Steve Laura Enable What I am trying to do is get all of the names that are enabled in the NAME table to appear EVERY time in a portal under the…

Hi all, I have been 'lurking' for a while and reading the many informative and interesting posts on the forum but I thought it was time to get involved. I am very new to FM and have enjoyed getting to grips with it. I do have a problem though and since googling has returned little of benefit I was wondering if what I am after is actually possible! So to the problem... I have two field Colours (Red, Green, Blue) and Size (Large, Small, Medium). I would like to produce a layout where checkboxes allow multiple selections to be made from each field and then to allow a find of those records. So for example I could search for -Red OR Green AND Small -Red AND Smal…

Can I script to have my database open another database then close that database when finished so the user is back in the primary database? Example: Building an eCourse in the primary database. I want the user to be able to take a quiz. There is a free quizzer that was built in Filemaker Pro 12 advanced. So when the user gets to the part to take the quiz, that database opens and when they are finished with the quiz that database closes and goes back to the original database at a layout I define. Is that possible? Thank you.

Howdy, all, and season's greetings: I'm stuck: In FMP v12.x Advanced, I'm trying to create a script where, upon clicking a field, its contents will be copied the clipboard so it can be pasted outside of the file into a web-based form or Word document; there's a theme in place in the FMP file where the fields' text color is white and I want it to be black when pasted into the form or document. I tried the TextFormatRemove, TextStyleRemove, and TextColor script steps but still, the text remains white when pasted so I guess I'm coding the script incorrectly. That, and I want it to be a "universal" script so whichever field I click its contents will be color-processed…

Hello, How to simply.... "remove the last carriage return and all text right of it ? thank you for your time. disable vet rob

Redit  to attach image file   Having problems with sendemail to client mailer, so reading appears everyone suggest the mailto route Whats wrong with my mailto: line? After send.. viewing the mailer window the subject line, has both the Subject & the Body of text? SUBJECT=   Looks like this..... Text Msg?Body=Recurring alarm  $subject  = "Text Msg" $strip_msg = "Recurring alarm" $emailTO  = "[email protected]" $sendline = "mailto:" $emailTO  & "?Subject=" & $subject & "?Body=" & $strip_msg $sendline  veiwed in debug= mailto:[email protected]?Subject=Text Msg?Body=Recurring alarm Open URL( $s…

Go to Record/Request/Page (first) Loop #do something here with the current record Go to Record/Request/Page [Next; Exit after last] End Loop I found this code but cannot seem to figure out how to use it for my purposes. What I have is a quiz with about 20 questions. I have a button called "Next" to go to the next question. On the last page I want that button to exit the quiz and go to another layout. But if I put go to next layout, it is on every button. I hope this makes sense. So the next button needs to go to the next record until the last record and then exit to another layout. How do I keep it from being global where it affects every button on the layout? Th…

I have a quiz that I got from www.soliantconsulting.com . How can I have the answers to the questions cleared after the database is closed?

After importing a several hundred files from Textwrangler Latin1 encoded, they become UTF-8 in Filemaker as there is no "Latin-1" import facility as I understand it I need to extract the last word of the first line in a text paragraph This is the simple file I am dealing with and all others are similar as they hae the student name "ID: " and the number. "Jack ID: 2389526 Dear Sir Could you please give me your opnion on the short film I show in class today' Most classmate didn't like the Black and White, but I think is appropriate for the story. Can this be because Colour is what they always see? Thanks Jack" My script is as follows Middle ( Mai…

Hi Forum; Im using filemaker Pro 11 advanced , and I created a boutton with a script in layout A wihch allow user to go to the layout B and display record finding in this layout . Enter Find Mode[Restore] GoToLayout [ " Layout B " ( TableB)] GoToRelated Reord [ "Show onlu related records; Match found set from table: "Table B"; Using layout <current layout> ] When I want to change the "<Current layout >" by "<Layout A >" ; It's not possible to do that , filemaker don't allow me to select layout A to display found records !! How I shoud change my script and what function can I use to display record in layout A with records from Table A and T…

Hi, I have a script that finds records and after write a text in a field with: - Perform find... - Insert text... But text only write in first of selected records... please, how I do to write text in ALL selected records? Thanks, Sorry Filemaker Mac 11

Hello, I hate to ask a question that has been answered. I always try to find the answer by searching but just havent been able to find one for this task I need to accomplish. What I am trying to do is write a script that will search fields on a report layout in several fields then omit those records that have the found values. Example: I have two fields. Department and Status I have a report with my records sorted by Last Name. I need the script to search for records that have the value 'Service' in the department field and omit all records with the value 'Service' from my report. At the same time I also need that script to search the Status fi…

I am using FileMaker 10. The script that is causing problems is the open and create folder script. An example is a script that will open a jpg file in PhotoShop. Before the upgrade (from 10.6 to 10.8) it worked perfectly. Now when I start the script I get the spinning beach ball and than the script times out with error code $$-1712 (time out). Could this be a permissions issue in Mountain Lion? Any suggestions will be greatly appreciated. I also tried a demo version of FileMaker 12 and tried the LaunchandReveal solution and get the same time out error. Thanks in advance - Sam

dear forum,  i used this script in fm11 (image attached).  i used my database on my iphone with filemaker go. i had a button, when pushing it, it rans this script. opening a barcode scanner software and then returning the scanned result into the filemaker database in the search field. this way i was able to find a product in my database by scanning it with the iphone camera.  now i am using fm12. i pushed the SCAN button, but i get this error (error.jpg)  anybody has a idea why this error appears now?  sincerely, raitis   Â

I am new to scripting and looking for a little help. I have a set of radio buttons in the header of a Table. The fields are global, I would like to filter a list with the following selections. Active, Inactive or All I can do the Acitve and Inactive, but what should I add to the script to see all records. I am using, for just Active and Inactive only selections the following script. The xStatus is linked in the Global table. Enter Find More[] Set Field [Products::Status;Global::xStatus] Perform Find[] I assume I need an If or Case statement somewhere? Related question, what would the script look like if it were an AND situation, Check…

I have two fields, Note and Log. The way I have it now is if you write something in the Note field, it puts the note along with a timestamp in the log field. I would like to make it so the timestamp part is red. Any ideas on how to do it? Right now it looks like this: P=new line Set Field [Log; Get (CurrentTimeStamp) & P & Note & P & P & Log] (So it writes the note at the top) Thanks!

OK, I've done it - again! I have to take full blame for this mess (you always do as a developer). Without going into a lot of sordid detail, my Child table is in need of adjustment. Seems on a large percentage of records, the ChildLastName and ChildFirstName are reversed. I now need to swap them. So here's what I thought would work. Create a calculated field called LNameSwap. In calc, make it equal ChildLastName. This works. Simple Script: Set Field ChildLastName = ChildFirstName Set Field ChildFirstName = LNameSwap Assign Script to a Go button Create second button with "Next" to move forward to the next record. Note: I can't do this more automated …

Hi I have attach a FM file in a zip... And have snippet that does nothing but show my problem, for step through with debug Basically I have a HTML page or my Invoice format And , then through substitution command, I fill the format with data This might even be a Html question.. not that familiar with its side <div neither </div> All the previous older lines of code work.. in my script except the last 2 new lines. Code was written long ago by another. still does except added new fields for counting 'Texting' or displaying new field counter to invoice format Testing, debugging, I add this new texting field by cut pasting the 'paging code…

My guess is that this is a fairly straight forward issue, but I have little (if any) experience with text functions. Any help would be greatly appreciated. I have a license database with a name field (individual) that over the years has had extra data added on many, but not all occurrences. Often the field will contain the company name as well: john smith / ABC plumbing company In all occurrences, the individual name is separated from the company name with / -- My goal is to loop through the fields, find the / and everything after and populate a new field, say (companyname) Then, go through and delete the / and everything after. Suggestions?

I'm sure this is basic, but I'm trying to create a command button inside a portal that when clicked, triggers a popup menu list of command selections. I want the portal row to be editable and I also want to hide the empty portal row below. I have been able to create this set up by using a global field with a conditional value list that executes commands based on an OnObjectMod script trigger. On top of the global field I've placed a non-enterable calc field that displays text identifying the button; something akin to the grayed out "Goolgle" text inside a search field in a browser. What is bugging me is that if I press the global popup without actually selecting a co…

Hope this is the right place for this question. It's been about 5 years since I've done any scripting in FileMaker and I'm afraid I've forgotten more than ever knew. I'm attempting to make a simple tool for work. I need to count things -- as you would with a sports thumb counter. The idea is to have a big buttom I can click that will advance by 1 each time it's clicked. The current count will be used by other fields for caluclations. I know it should be simple but I just can't figure out how to do it. Any help? Usually I can figure out things by searching for examples of someone else's scripting and reverse engineer it but google has failed. me. The…

I think this is just a text parsing question as I know how to make this work when extracting a value when there is only a single row of values in a list by way of the following script steps: 1. Set var: $MySingleRowListofValues 2. Set var: $List; Value: 1 3. Loop 4. Exit Loop If [$List > ValueCount ($MySingleRowListofValues) 5. Set var: $ValExtract; Value: GetValue ( $MySingleRowListofValues;$List) 6. ExecuteSQL[insert value from $MySingleRowListofValues] 7. Set var: [$List; Value: $List + 1] 8. End Loop What I want to do is create a multi-row list of values via a single SQL step, then extract each value in the looping script to be insert…

I am trying to design a security script that will prevent users from switching to a tab that they do not have permission to use. I am using the OnTabSwitch script trigger to capture the value of the tab that they are on but I am having trouble capturing the value of the tab that the user has switched to. Other than setting transparent buttons over each tab, what's the best way to capture this value?

What's the best way to design layouts when you don't know the user's screen resoution? I would like to design a solution that any one can use (PC computer) reguardless of the screen resolution. Certainly when you load other PC programs (Word, Excel, Utilities, etc.) screen resolution is not an issue. Why isn't FM the same? I don't think MS Access has the same problem.

I have a script that I pause to receive input from the user. The script takes the user to a layout where there are two buttons, and they must select one. However, the problem I am having is I cannot receive the input, and resume the script. I can have the buttons either set the field I want, or resume the script. If I create a new script that contains both functions, then it cancels the initial script and in turn, uses the pause instead of resume... I looked into using script triggers on the buttons to do one of the functions but couldn't get that to work either?