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

Community Forums

  • The New FileMaker Platform
  • Community Resources
    • Community Articles, Tips, & Techniques
    • FileMaker Marketplace Discussions
  • FileMaker Platform
    • FileMaker Interface Features
    • FileMaker Schema & Logical Functions
    • Brain Food
    • Legacy FileMaker Platform Discussions
    • Command Line Data Migration Tool
    • FileMaker Pro Advanced 17
  • FileMaker Go & Mobile Strategies
    • FileMaker Go for iPhone & iPad
    • iBeacon Support
    • FileMaker IOS App SDK
  • FileMaker and the Internet
    • FileMaker DataAPI
    • FileMaker WebDirect
    • Custom Web Publishing
  • FileMaker Server Administration
    • FileMaker Server 17
    • FileMaker Server 16
    • FileMaker Cloud
    • FileMaker Custom SSL Certificates
    • oAuth and External Server Authentication
  • FileMaker Security Management
    • Security Concepts
    • Intellectual Property
  • FMForums Affiliates & Sponsors
    • Productive Computing Support Forums
    • 360 Works Official Product Support Forums
    • Geist Interactive Product Support Forums
    • FileMaker Vendors
    • FileMaker Training Resources
  • FileMaker Classifieds
    • Announcements of FileMaker Product, Services or Resources
    • Classifieds
    • Tools Of The Trade
  • FM Forums Operations
    • FM Forums Feedback & Site News
    • Member Lounge
  • FileMaker Friday Night Chat's Topics


There are no results to display.

There are no results to display.


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

Product Groups

  • Site Donations
  • Site Advertising

Find results in...

Find results that contain...

Date Created

  • Start


Last Updated

  • Start


Filter by number of...


  • Start







Website URL




OS Version

Found 356 results

  1. I've added a script trigger on entry to a specific field. If the user does not have permission to edit, they're provided with a dialogue and can't enter. However if they do have permission the field is selected and then exited. How do I let authorized users remain in the field and continue editing? Here's the code: If [ Get (ScriptResult ) = Null ] Show Custom Dialogue ["No permission to edit!"] Halt Script End If Much appreciated.
  2. Im having trouble with a script that involves calculating a month. I have a field called "Assigned" that contains a date. What i am trying to do is create a script of all records that were assigned 1 month ago, 2 months ago, 3 months ago. So far, i have been able to figure out how to get the current date and take the month to subtracy by one like so: Month (Get (CurrentDate)) - 1 Now if i were to set that calculation as a variable of lets say $1_Month, how would i tell the program that i want to see all records whose assigned dates meet the criteria of the current month - 1, which would be July? Thanks
  3. I hope this question is in the correct section, please move if not. Is there a way to have a script to Open a file and then using the 'When opening this file perform script' so i can do some stuff, by use of a PC Clock/Date? Say the file will open at 12:00am on the 1st day of each new month. Can this be done, or do i need to use windows Scheduled tasks etc Corey....
  4. Hi. I am looking to achieve a realtime filtering process whereby I have a drop down list displaying records of a field, and as the user types something only records with contents matching that in the field are displayed. For example: 100 records with a field called "name" (very original I know). As I press "j" only records that have "j" in that field are displayed - not just the first letter but "j" in that records field. I then press "a" and the list shrinks as it finds "ja" etc etc. I have seen a plugin demonstrate this (Fusion Reactor) but Im damned if I can get it going. Whilst I now use FmPro 10 Advanced, many clients of mine still have version 9 so will stick to this version for this question. Has anybody written scripts or functions or the like that do this? Please advise. Greg
  5. I have a dropdown that I'd like to be able to change with the arrow keys, then you press enter, it commits the value, and runs the script. Instead, when I press enter, it uses whatever the value was before I chose a new one in the dropdown, and runs the script. The script adds a line item at the end of an invoice portal, currently with the wrong value (unless I click, but I'm trying to get around using the mouse). I'm sure there's something simple I'm missing here? The following script runs on keystroke: if(get(triggerkeystroke)="paragraph (symbol)") Commit records/Requests [No dialog] Perform Script ["allocate] Exit Script [result: False] So, to summarize, I want "enter" or "return" to commit the field and run the script.
  6. Howdy, all: I'm trying to create a script trigger so when a user enters lowercase text into a two-letter State (text) field FMP will change the text to uppercase. The problem is users will unconsciously enter the state's identifier in lowercase so it'll "stick" in the field instead of the uppercase ones already set up in the value list. I don't want to change the field to a pop-up menu since that'll be unsightly and unwieldy with such a long list (states plus US possessions and Canadian provinces.) Before tweaking, I had it set up so the user received a custom dialogue message that he or she should use only uppercase letters but that was kinda clunky; I'd rather have FMP automate the change. I tried using the command, Upper, by itself but it "masks" the text to look like uppercase--the original text remains in lowercase. I'm close but not quite there. (See the attached) The first letter is changed after I enter the second letter of the two-letter abbreviation but the second letter isn't changed unless I enter a third letter. Not good. What do I need to tweak the script so the second letter is automatically capitalized? Pee Ess: I thought of using OnObjectModify instead of OnObjectKeystroke but since there's a tab order set up in the layout what happens is that the following field's (ZIP code) text is changed to the State's text. Not good, either! TIA for your help. test.fp7.zip
  7. Hello, I would like to match records from one table with records from another one. The problem is that all records in both tables are products with different names, packages, e.t.c. I have created a relationship and manually enter the record id of table1 to products of table2 and then with portal table view the match, but I would like also to perform a search to find similar records from these two tables based on some criteria that I established. For example, I created a field in each table with mixed information from various fields of each table and I would like to see whether there is any match or not. Thank you very much
  8. 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?
  9. I have a portal, and , if I change the data in the main table, in the portal the value of data have the old value, but if I reselect the data in the portal, iI have the new correct value. How can UPDATE the data in the portal automaticaly by a script? THX andy
  10. Might be a stupid question but how can I execute a script from a calculation function? Thomas
  11. 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.
  12. Does anybody know by which priority script triggers are run? And also, if you set a default menu set for a layout, does it apply before or after the OnLoad layout script trigger? I would like to have ordinary FM menus if admin logs in but defined ones for normal users.
  13. 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. Does anyone know how I can create this to happen? Is it a script I need. How can I say it with a script? I'm using an old version FM6. But the language is pretty much the same.
  14. I'm trying to do something that seems like it might be pretty common and ought to be fairly simple. Let's say I have a Table called Artworks and another Table called Keywords, which holds 1000's of records, a big lexicon of Art terms. I'm building a system where I can tag various artworks with any number of keywords. The tags will be kept in a join table between Artworks and Keywords. So, I would like to have a little textbox where the user can begin typing a keyword, and in a portal underneath, the Keywords beginning with the typed characters are displayed, and this list will get smaller as the user types. For instance, if the user types "pa" the filtered portal might show parade parrot pastel . . . and then if he types a further "r" the word "pastel" would disappear. My thought was to (1) create a filtered portal when there relationship betyween Artworks and Keyords is defined as: Artworks::Textbox = Left( Keywords::Word ; Length ( Artworks::Textbox ) ) and then (2) set a Script Trigger on the Textbox field "On keystroke" that simply performs a "Refresh Window; Flush cached join results; Flush cached external data". So, this isn't working. Is it the right idea but I'm missing a detail, or is my approach just wrong?
  15. The Missing Man

    Find Script

    I know this is simple but I am missing something and therefore cannot figure out what to do. Everything I try doesn't work. I want to create a script that will transfer me from Table A to Table B staying on the related record. That's it. I have a relationship that works between the two tables but just cannot figure out how to move from Table A to B. I am assuming it would be a find script with a set field by name? but I cannot get that to work. Any help would be appreciated. Thanks in advance
  16. Not sure if this is the right forum. What I need is a way to capture the date and the exact time in a field. Here is what it is for. It is a tardy calc I am trying to build. I have a field with a value list and a drop down box. The user can choose between 1st - 7th period. Then there is another box that the date and the exact time needs to be put in. Can this be done automatically? In other words the user clicks on the field titled "Date/Time" and the date and the exact time is inputted in the field. Then I need that field saved forever. Because that same student could come back tardy again but on a different period. So I would need to be able to use that "Date/Time" field again.Hope this makes sense. Please advise.
  17. 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.
  18. 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.
  19. My apologies if this is in the wrong area...I am very new to file maker but have extensive database/data modelling/reporting experience with other larger platforms. I have a couple things that I am trying to do in File Maker, and not sure if they are possible, or how to do them: 1. I have a new related table that I would like to populate. In general I can do this quickly with a sql statement, but how do I execute this SQL statement against the File Maker database? I see that you can write a SQL to execute against an ODBC/JDBC source, but I just want to execute it in the database that I am working in. A sample of the SQL: Insert into (new table) select column1 from existing table 2. What is the best way to prompt a user for inputs? Example: Pull all the records from table where a date range is between start date and end date. Where the start date and end date are being input by the user. 3. Again...SQL... How can I perform a delete... Delete from TableA where column1 = "Delete" Sorry if these are trivial. I have figured out some things on my own, but some of the things that I have done with other products...seem to not funtion the same way in FileMaker. Thanks in advance for any input.
  20. I think I found a bug in Filemaker 13. The script step "New Window creates an error message that I have attached. This error is occurring in previously developed Filemaker 12 scripts and in new ones. The window does open but this error message always appears.
  21. Hello all: I have a problem that I'm having a hard time getting out of. I have an "OnLayoutEnter" trigger and inside this trigger I have a script that goes to a New Window, does some processing, and returns. The issue I'm having is that when the script hits the New Window command the focus goes back to the "OnLayoutEnter" trigger and starts to run that again. I'm just confused as to why it would jump back to the "OnLayoutEnter" trigger script and is there a way to avoid that from happening. Dom
  22. If I want the auto populate the slashes in a DOB field how would I use the Object Vailidation triggar script to help me convert those dates to an eight figure date?
  23. 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 select one of the options from the second layout. This is the script that navigates to the second layout. Enter Browse Mode Go to Layout [ “0100: Main: Translations” (Translations) ] Show/Hide Status Area [ Hide ] Set Window Title [ Current Window; New Title: "MONDETTA : Translations" ] If [ Get ( PrivilegeSetName ) = "[Full Access]" ] End If If [ Get ( PrivilegeSetName ) = "11 Orient Merchandising: Supervisor" ] Go to Layout [ “0110: List: Translations” (Translations) ] End If If [ Get ( PrivilegeSetName ) = "05 General Clerical: User" ] Go to Layout [ “0110: List: Translations” (Translations) ] End If Perform Script [ “0010 > Set Magnification based on Get (Screen Height)” ] Anyone run into this?? Thanks Michael L.
  24. How would I go about setting up a script to auto delete records with a a blank value?
  25. Hi If i am at a dialog box... how would one make a continuous beeping sound for a operator not at desk or is a sleep at the console? Triggers some external sound? TIA Rod

Important Information

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