Jump to content

Search the Community

Showing results for tags 'script trigger'.

More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


  • Custom Function Library

Community Forums

  • Community Resources
    • Community Articles, Tips, & Techniques
    • FileMaker Marketplace Discussions
  • FileMaker Security Management
    • Security Concepts
    • Intellectual Property
  • FileMaker Server Administration
    • FileMaker Server 16
    • FileMaker Custom SSL Certificates
    • External Server Authentication
  • FileMaker Go & Mobile Strategies
    • FileMaker Go for iPhone & iPad
    • iBeacon Support
    • FileMaker IOS App SDK
  • FileMaker and the Internet
    • FileMaker REST API
    • FileMaker Cloud
    • FileMaker WebDirect
    • Custom Web Publishing
    • Other Internet Technologies
  • FileMaker Interface Features
    • Cards & Window Management
    • Interface Design Discussions
    • Layouts
    • Themes and Styles
    • Button, Popovers, Button Bars, SVG Icons
    • Tab and Slide Control Panels
    • Portals
    • Web Viewer
    • Conditional Formatting
    • Custom Menus
    • Value Lists
    • Tool Tips
  • FileMaker Schema & Logical Functions
    • Managing Scripts
    • Calculation Engine (Define Fields)
    • Custom Functions Discussions
    • FileMaker Query Language or FQL
    • Relationships
    • Charting
    • Remote Container Fields
    • Finding & Searching
    • Importing & Exporting
    • External Data Sources
    • Advanced & Developer Features
    • Reports, Printing & Publication
  • Brain Food
    • The Left Brain
    • Upgrading & Migration
    • Data Analysis
    • Development Standards
    • The Separation Model
    • Relational Database Theory
    • Damaged / Corrupt File Problems
    • OS Level Database Automation
    • Hardware & Networking
    • Bar Codes (Printer, Scanners, Software)
    • Accounting Solutions
  • FileMaker Discussions
    • FileMaker Pro 16
    • FileMaker Pro 15
    • Legacy FileMaker Platform Discussions
  • Productive Computing Support Forums
    • Visit Productive Computing
    • General Discussion for Productive Computing Products
    • Core CRM Solutions
    • QuickBooks and Accounting Plug-ins
    • Contact and Calendar Management Plug-ins
    • FileMaker Utility Plug-ins
  • 360 Works Official Product Support Forums
    • 360 Works General Support
    • MirrorSync by 360Works
    • 360Deploy
    • SuperContainer by 360 Works
    • ScriptMaster by 360 Works
    • FTPeek by 360 Works
    • 360Works Email Plugin
    • DocuBin by 360 Works
    • Zulu – FileMaker, iCal & Google Calendar.
  • Geist Interactive Product Support Forums
    • Visit Geist Interactive
    • Visit Modular FileMaker
    • FMPerception
    • Generator
    • fmQBO
  • FM Starting Point - By Richard Carlton Consulting
    • Visit FM Starting Point
    • FM Starting Point - General Discussions
  • FM Forums Affiliate Sponsors
    • Monkey Bread Software (MBS Plugin)
    • SyncServer Pro by LinearBlue
    • ISO FileMaker Magazine
    • Open Source Frameworks
    • FileMaker Plug-Ins
    • User Group Central - Sponsored by FMPug.com
  • FileMaker Classifieds
    • FileMaker Product & Service Announcements
    • Professional FileMaker Training
    • Services for Hire
    • Services Wanted
    • Solutions Wanted
    • Tools Of The Trade
  • The Water Cooler
    • Member Lounge
    • Wants & Wishes
  • FM Forums Operations
    • FM Forums Feedback & Site News
    • Site Instructions
  • FileMaker Platform


  • Captain's Blog
  • FileMaker Weetbicks
  • FileMaker Security Blog
  • The FileMaker Rift
  • HOnza's Bits @ FMForums
  • SeedCode
  • CampSoftware, Hal Gumbert
  • FileMaker Hacks
  • Skeleton Key's Blog
  • Wing Forward Solutions
  • 360Works Articles and Tutorials
  • GoBillit
  • Filemaker - an amateur's view
  • Linear Blue
  • Surya Kanta Mekap's Blog
  • eXcelisys' Blog
  • Manjit Behera
  • Blue Feather's Blog
  • RCC's FileMaker News and Bits
  • Thorsen Consulting
  • DB Services Blog
  • FileMaker Magazine
  • Eye on FileMaker
  • Dev Talk
  • The Philosophy of FileMaker
  • Button Bar Icon - Text Alignment Issue
  • 1-more-blog
  • Productive Computing


  • Samples
  • Solutions
  • White Papers
  • Plug-Ins
  • FMGo

Found 16 results

  1. Hi all I have a global field that is populated by the end user. When they hit the enter button it executes a script, which refers to the value that has been entered in to that field. This utilises the Get(TriggerKeystroke) and OnObjectKeystroke trigger and function. When a keystroke is made on the field, the triggered script detects when the enter key has been pressed and runs another script. I have set the field to go to next object when enter has been pressed. The only downside of this method is that it tabs to the next object after the enter key is pressed. The only way to prevent this is to untick the 'go to next object using enter option. However when I do this, I am left with a carriage return at the end of the field contents, because the enter key has been pressed. Is there a way around this? Cheers
  2. Perhaps I'm tired...but I would like a refresher on the subtle difference between these two triggers. In my use case, my script enters find mode, sets fields, and finds the target record (a scripted gtrr). Now that I found the record, I'd like to set all the default button bar $$active_segments, and perhaps nav to certain panels. At first I tried OnLayoutEnter, but apparently that doesn't fire in Find mode. I could add all the setting of stuff to the script that does the find, but it occurs to me that perhaps OnRecordLoad is the better approach. Thoughts?
  3. Environment: FM13 with FM13 Server, mix of Windows 7 and 10. Is there a way to set a script trigger on if this portal row is new? IE, a script to run if this new child/portal record is new. We have a parent record, and portal to Children records. The children records have 2 fields: Profile Name and Process type. Our user would like to enter a new child record (profile name and process type). if the process type already exists, we will need to archive the existing record (matching the profile type). There is more bI want to start with this first. I see script triggers to the layout "OnRecordCommit", but no similar script trigger for portals. Any ideas on how to handle this? Or am I going to have to add a button to go to another screen to accomplish this? Thanks. I hope i gave enough info for you to help me.
  4. Hello, I want to create a script trigger which opens a layout based on account name ,create new record and put cursor in first field of the new record Now, I was able to direct user to specific layout and also created new record using New Record/Request function but somehow it doesn't put cursor in the first field , instead it selects whole record . Note: I also have script triggers attached to first and second field which runs on exiting the fields. (I don't think they affect anyways , but just mentioned to give idea)
  5. Hello, I am gonna describe a scenario where total automation needed using only barcode scan, please bear with me: I am creating operator timesheet layout for product lifecycle in list-view. Each operator has a list of unique barcodes(printed sheet) for each production function. Every activity(function) of print production is assigned code (barcode) that represents function type as well as operator name: For eg. if John is working on new plates function for Press he'd scan barcode 301-1 but if Marc is working on the same function , he'd scan 301-2 , Now '301' represents new plates function and number after hyphen(-) represents operator. In John's case 1 and Marc 2. So, on the interface(list view of functions) , when an operator scans barcode of function it will set time-in field value and name of operator in their fields based on calculation from code. I don't want STOP button for each function to set value of time-out (because it requires user interaction), rather, I want it automated. I am looking for some sort of script trigger that runs on every new code scan and search for last record with similar operator name and set time-out value as current time in that record and set the same value as time-in for new function record. Thank you
  6. Hello everyone I am currently working on a database, which HR-Managers can access via WebDirect using login-information, to accede or resign their employees. I have made 6 possible option types for the HR-employees to enter data into, set by an unique ID, but with the use of the same fields. So... X fields with option type 1 (Accede) Y fields with option type 2 (Resign) Z fields with option type 3 (Maternity leave / leave) .. Etc. 6 option types in total. Now, based on my project description, a couple of the fields will have to be validated / not empty, which the HR-manager is prompted to enter before the record can be committed. Now, I am aware of FileMaker has it's own Field Validation, but I think the built in feature is bonkers..... (Sorry FileMaker..) Therefore I was thinking of making a script to each of the different fields, which needs validation, and is this even a good solution Question one; how do I do this, the most easily? Is it possible? I have 8 required fields for validation, fields are global. Fields such as; Company Name, HR-manager name, HR-manager e-mail, employee SSN, employee name, employee surname etc. I don't want the scripts to interfere with the other option types ( X, Y, Z ) which each is set by an unique ID, as well as fields, although the fields used in these option types are from the same table. Please see attached images of my setup. Hope you can help me, for the best possible solution. If you need more information, let me know. /Cheers P.S. The language/text on the layout is Danish, although shouldn't be considered an issue for understanding my problem.
  7. Hi, everyone. I need help creating a script to trigger when a Container field is modified, as in existing contents is replaced or deleted. I would like a custom dialog box to prompt the user if they really want to modify the Container field which has already been populated with content. If they select "OK", the changes are made, but if they select "Cancel", the changes are not made to the Container field. The reason this came up is because I want to prevents accidental delete or replace of a container field's contents via the "drag and drop" feature that FileMaker has. A user can easily hit the delete key while resting on the field or drop a new file onto it without considering the effects that the existing data will be gone forever. Since these container fields will hold important documents and information, I would like to add some pre-emptive warning measures on the user's side. I believe this can be done via the "OnObjectModify" script trigger on the actual container field, but I've had no luck testing scripts steps. Also, I discovered that if one drags and drops a file onto a container field, the field is automatically committed, so the changes becomes final instantly. So, using the "OnObjectEnter" and maybe other available triggers might not work exactly as expected in this scenario due to the default "drag and drop" functionality committing all changes instantly. I also prefer to leave the "Save record changes automatically" option for the layout enabled. I know that leaving this unchecked will prompt you after exiting each field if any changes made should be saved, though even with this option uncheck the "drag and drop" behavior of container fields bypasses the default FileMaker warning message and allows you to overweight the existing content of the container field. I believe this is because the container field is never actually entered or exited, since a file is just dropped onto it to overwrite any existing one, and as mentioned above the changes are committed instantly. Now, if you actually do enter the container field, by selecting it, then the warning message triggers just fine.
  8. onObjectEnter trouble

    Hi. I have two fields on a layout. The first is the id field of a related table. It is a dropdown menu that shows a value list which uses the "Also display values from a second field" option so that it shows "name" values instead of the id itself. On top of that field is a second field. It is the "name" field of the related table (edit box, not dropdown). The top field allows entry in both Browse and Find Modes. I allow it in Browse Mode so that it can change color on hover (I didn't want to make it a button because I also need to enter data into it in Find Mode). The top field has a script trigger (onObjectEnter) that checks to see if the user is holding down a modifier key. If they are, it does a GTRR. If not, it just activates the first field (dropdown) using a Go To Object script step. Here's my trouble; if there is already data in the 2 fields, the onObjectEnter script is triggered correctly. However, if the fields are empty, it appears the script is NOT triggered (when I use Script Debugger, the script never starts up.) Any ideas? Thanks very much, Michael
  9. Purpose: To capture the contents of a field before it is changed. Compare the before to the after. Highlight the after and screen capture then export. I can't get past the first sentence and it's getting frustrating because it seems extremely simple. 1 Field: OnDeck_t (text) - The OnDeck_t field data = On 2 Field: OnDeck_before (Where I want to capture the OnDeck_t before it's changed) I have an OnObjectEnter script trigger on the OnDeck_t field that runs this script: Set Field By Name [substitute (Get (ActiveFieldName); "_t"; "_Before"); Get (ActiveFieldContents)] If I do this it works fine. (But I don't want it hard coded. I will be using it for all the fields on the layout): Set Field [OnDeck_before; Get (ActiveFieldContents)] I have divided the Substitute (Get (ActiveFieldName); "_t"; "_Before") and Get (ActiveFieldContents) into separate lines in Data Viewer and both return expected results. Why doesn't it work when it's part of a 'Set Field by Name' script step? Thanks.
  10. Validation or Script Trigger

    I have two fields: Closed Date & HW Platform. Goal: If the user selects the HW Platform field and Closed Date is empty pop a custom dialog. If Closed Date is not empty then no message. I have tried a few ways to use field validation to perform the check and post a message but no luck so far. I know I could do this easily with a Script Trigger. My question is can this be done with validation? And is one or the other method better? Validation or ST? FileMaker 12 FileMaker Server Adv 12
  11. Hi, I'm new to the forum so apologies if I have put this question in the wrong section. What I am attempting to do: I want to create a 'home page' that each consultant sees when the database opens on an iPad. The home page should have two pop-up menus, Client and the other Contact. For context, each Client with have multiple Contacts (generally employees and contractors) The consultants in the office want to be able to navigate to a Client they select from the pop-up menu on the 'home page'. The same process applies to the Contact pop-up menu. Many thanks if anyone has ideas how to achieve this.
  12. Greetings, I have a global field that is acting as a search bar to perform a find with the data stored in it. I have set an OnObjectKeystroke script trigger to the field to activate a script if the user presses the enter key while inside the field. Since most users are used to hitting enter on their keyboards to perform a search and it's much quicker, I've adopted this method as opposed to a search button. I would like to prompt the user with a warning dialog if they press enter while inside the search field, but happen to leave the field empty. The custom dialog would tell them to type some search criteria in, instead of leaving the field empty to avoid performing a blank search. So far most of the script I came up with works, but for some reason it gets stuck in a loop during the last simple steps and I can't get out of it. I'm trying to have the following occur: - Exit the search field, and make it lose the focus. - Show a custom dialog telling the user of the error and prompting them to press "OK". - Upon pressing OK, enter the search field again and bring it into focus to set the cursor in the field so that the user can retype a correct value. The default FileMaker field validation that is found in the field's Options settings performs something very similar to what I described above. I'm trying to achieve a similar effect, but using a script instead to have more custom control and flexibility with the warning dialogs. Any help much appreciated. Custom validation - Search field.fmp12.zip
  13. In FM 12 Advanced I cannot get the Tab Panel Script Trigger script to return a Tab Panel Object Name using either of the Get functions: Get(TriggerCurrentTabPanel) or Get(TriggerTargetTabPanel) I have used the GetValue(Get(TriggerCurrentTabPanel);2) but it returns nothing. Using the same function GetValue(Get(TriggerCurrentTabPanel);1) returns the Panel Tab Number. I've watched videos of people doing this and I've copied examples but cannot get it to work. Anyone have a suggestion? Thanks, Jesse Filemaker Pro 12 Advanced Mac OS X 10.8
  14. I have set up a database that allows employees to log in and out of tasks throughout the day so that we can track productivity and use the data to better bill. One of the features of the database is an "In Progress" button that allows department managers to, with a single click, see what employees are actively working on. It all works well except for end of day tasks. Every couple of days, an employee will leave without first logging out of their task. So the next morning, the supervisor will have to manually adjust their time. In an ideal world, each department manager would check the "In Progress" task before heading home to catch them right away, but we don't live in an ideal world. What I want to do is, at a specific time each day, send just these select few managers a quick notification that says "there are five open tasks in your department" (and if there are no open tasks in their department that day, they wouldn't need to receive anything). But because of the volume of users, I want the script to run on the client side rather than server side. I think the actual script is pretty straightforward: If [ Get (AccountName ) = "Manager" ] Go to Layout [ "Layout Name" ] Enter Find Mode Set Field [ Task End Time; "==" ] Perform Find If [ Get (FoundCount) = 0 ] Go to Layout [ "Home" ] Halt Script Exit Script Else Beep Show Custom Dialog [ "Message"; "You have two open tasks in your department." ] Exit Sccript End If End If (I do realize that setting it up this way would cause whatever the person is actively doing to be interrupted by this script. I haven't quite thought of a resolution to that just yet.) But how would I set such a script to run on the client side at, say, 4:00 PM Monday thru Friday? Is there a plugin available or can it be done with the tools and script steps FM has built in?
  15. From "Triggered" Script B, I want to "Resume" Paused Script A. But putting a "Pause/Resume" step in Script B Pauses Script B rather than "Resuming" Script A. The only Script B step I have found that will end the Pause in Script A is "Halt Script." But this discards Script A's local context (variables, original layout, etc.), requiring "globalization" of Script A's context if I want Script B to "complete" Script A's steps before Halting. Am I missing another approach (without Plug-ins) to a Script B completion of Script A's Pause? Here is my understanding: If Script A contains a Pause (for controlled user input), Script A is ONLY "Resumed" if the user - clicks "Continue", - presses "Enter", or - utilizes a "Resume" button I add to the layout. Now suppose: - Script B is triggered during Script A's Pause. - Script B "needs" to "Resume" Script A's Pause. Here is my approach: - Separate the remainder of Script A into Script C ("globalizing" context information as necessary). - Use "Perform Script [script C]" as the only step after the Pause in Script A. - Conclude Script B with these two steps: - Perform Script ["Script C"] - Halt Script // (to end/"Resume" the Pause initiated by Script A). Is there a downside to this (other than needing to "globalize" the context information in Script A)? Is there a better approach? Thanks in advance!
  16. To prevent the following message dialog ''Before Typing press Tab or Click in a field...'' on all of my layouts when a user types outside a field. I found this suggestion that appears to work: (I put it as a script trigger ''OnlayoutKeystroke'') If [code(Get(TriggerKeystroke)) = "27"] Exit Script [Result: True]Else If [isEmpty(Get(ActiveFieldname)) or PatternCount( FieldType ( Get(FileName) ; Get(ActiveFieldName) ); "Calc") > 0] Exit Script [Result: False]End If I have no programming knowledge at all so I tried to more or less paste this code. It does not do anything on my layout so of course I'm missing something. [Result: True] and [Result: False] Are these only mere comments or part of the code? My formula builder will not accept these values at all. My script so far looks like this: (but does nothing) If [code(Get(TriggerKeystroke)) = "27"] Exit ScriptElse If [isEmpty(Get(ActiveFieldname)) or PatternCount( FieldType ( Get(FileName) ; Get(ActiveFieldName) ); "Calc") > 0] Exit ScriptEnd If Also, Keystroke 27 seems to refer to the ESC key. I have no clue what it does here. If anyone as the patience to help me on that.

Important Information

By using this site, you agree to our Terms of Use.