Jump to content

Search the Community

Showing results for tags 'scripts'.

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 55 results

  1. Search in Popover

    Hi gurus, I am sure I’m missing something simple, but for the life of me I can’t figure this out. I have a database with tickets. What I want is when a new ticket is created I want to see a popover (see attached) then I want the user to type in the top box and as they type I want to filter the list below (a portal) and once they client is shown they would select it and a ticker is created for the client. I sound a script and modified to fit my needs but can’t get it to work. Can someone stretch a helping hand? BTW the filtering is working but its not reflecting in the popover its reflecting on the layout.
  2. Hi all, I'm an FM novice who has a functioning database, and I'm trying to add layers of functionality to it. One feature I'm trying to design is a script to search through a Gmail outbox with certain keywords. In URLs, "%" translates to "%25". Filemaker appears to do this automatically - In Gmail syntax, you need to write "in%3Asent" to have the Gmail search bar contain "in:sent" which searches my outbox. Here's my current code for Go to URL: This "%" bit translates to "%25". I've tried "\%", I've tried creating a string, x, then having it open x, but no matter what I cannot get "%" to show up as-is, it always translates to "%25". Is there any way around this? I've tried subtracting text, but I just can't seem to get it to work. Any bright ideas? I can't find an answer to this specific question of disabling URL string substitution.

    Hello everyone.. Guess I have been away for a while. Not fully back though because I am not really engaged with computer tech stuff at the moment. However, I really stumbled across a problem earlier today while going through my email logs. I observed that a server script I had set up has not been attaching the Pdf file report as supposed to. It only delivers the message while leaving out the file attachment. I did test the script when I added it but what I did not test was the result when run by the server. Allow user Abort [Off] Commit Records/Requests [No dialog] Set Variable [$FileName;Value:"Summary"&".pdf"] Set Variable [$PDFPath;Value:Get(TemporaryPath) &".pdf"] Go to Layout ["Summary_Layout] Perform Script ["Print_Page_Setup"] Save Records as PDF [Restore;No dialog;"$PDFPath";Current record] Send Mail [Send via SMTP Server;No dialog] As at the time of my writing the script, I was not observant about server-side scripts. I did go back just recently to observe that the "Save Records as PDF" script step is not server compatible. Please, is there any work around on this? Much help is appreciated.
  4. I have two tables, A & B, with similar fields. I want to write a script that will search table B for records that match the fields that are entered in table A. I am not sure how to do this. Any suggestions?
  5. Hi. I'm using FMPro 12 Advanced. Creating a database for our community centre and I need to add a membership number to contacts - but not all of them. I've created a separate table for Membership numbers (as not all contacts will have one, so serial numbers aren't appropriate). Each membership has a number of details fields. It's probably a REALLY logical and stupid problem I'm batting against - but I need to: Select a contact>go to their details>add a membership number (go to a floating window layout, enter the details to the serial-number-derived membership) and have the details including the number show up in a tab on the contact's details layout. I've created a relationship between my contacts file and my membership file via the Contact_ID>Contact_ID_fk and have played around with other relationships. I've also created a simple script from a button on the Contacts membership tab to go to the Membership Layout window and create a new record. But it keeps creating a new record in the Contacts, not Membership - even though the relationship only has to create new records in the memberships side. I'm now running around in circles - please can anyone help me out here?????
  6. Hello, I have a weird issue that just started happening when I use the 'Print to PDF' script step in a loop. I have a script that passes through and prints out a set of pages. When I use the script Debugger and when I reach the spot I am having issues with, I can see, during the preview, that it is in the correct record; showing the correct page, but once it is done and saved as a PDF, it is showing the first record that was browsed. I have attached a snapshot of the script I am using. If you notice, I have it go to the layout First, Performs a Find based on a Variable - It finds the proper records. Then it goes to the first record, (for this example, lets say record # 36) Starts a loop and saves the record being browsed to a PDF. Then it moves on to the next record in the found set. The Custom Dialog which SHOULD show the next records ID, does not. It still shows record #36. I have no clue as to why. Even though as I go through each script step and I can visually confirm it is moving to the proper record in the FileMaker client, it does NOT save the proper Record. If I switch the option on the 'Save Record as PDF' from Current Record, to records being browsed, it saves the proper records to PDFs, but it duplicates them 3 times and does not set the proper page numbers. Attached is also the end result The Observ ID: should be 36, 37, 38 but all three pages stay at 36 showing the exact same record. Thank you all for your help.
  7. I have a number of scripts that have worked perfectly for years in previous versions of FileMaker, however in FMP 15 they causse FM to crash. They only way I have found to avoid the crash is to use the debugger and to use the "step into" button. That of course is a very cumbersome workaround. You can see one of the culprits below. Anyone have any ideas what's wrong here?
  8. Hi all We have a web based tickets portal which creates new messages in our filemaker database - this is for customers' use. It does this using the PHP API (the website was developed by a third party). We would like the owners of tickets to be notified when the customer has added a message to one of the tickets that they are in charge of. Is there a way for filemaker/filemaker server to trigger a 'send email' script when a new record is created via the web portal? Or would it be simpler for this action to occur on the web side? Many thanks
  9. Hello, I have more than 10k executable files, each EXE export data to a single table, inside of an unique MySQL. I created a FM database to manage all data (ODBC), but I didn’t solve how to trigger a script from an external EXE, without looping for new data each minute. Questions: #01: There is way to trigger a script in an open database, without looping ? #02: Runtime solutions can be used with parameters? My best idea, at this time, is to create a runtime solution and a relationship, and call it from the EXE. I do think is a "stupid idea" and there must be clever solutions out there. Thanks for all INFO: I am using windows 10 | FM Pro 15
  10. Memory issues

    I am running a server script periodically (every hour lets say) which does some database maintenance, uploads some files, etc. I do this on a number of Filemaker Servers (latest server version running on Windows machines) without problems…except for one server. On this server I use scriptmaster to up load some large files into containers as they are generated from scientific instruments. The problem is that the server runs seems to run out of RAM memory after a "few" days. I think this is the only thing that this server does differently than the other 4 servers and feel that this is the problem. My question is…is there a way to "flush" memory used by the plugin or by the FM server. Has anyone else experienced something similar or am I barking up the wrong tree? Thanks.
  11. Attaching .pdf to Mail

    Hi all, I know this should be easy but I am not getting it right. The mail gets sent but no attachment
  12. Hello, It always go to "Default segment button bar", set on the button bar setting, when reenter to layout. I need to go to same segment when user was working on before he left the layout. I know how to get back to last tab panel used, and I wonder if there would be similar for this. Thanks a lot! Luis.
  13. Hello, I have a tab control panel with four tabs, and I would like to achieve that when I change tabs a script is triggered and would set the value of a global field called "zzz_g_collection_type" according to the tab name which is active. I need this field to dynamically filter the products that are shown on 1_row portals that I have put into each tab panel space. I have followed Elishree Dey tip on http://burnignorance.com/filemaker-pro-tips/trigger-a-script-when-user-changes-the-tabs-in-filemaker/ but I cant make it work, it only changes the value of "collection_type" field once and only to show that the first condition is not met. I have attached the picture of my script. My initial idea was to place on each tab space a picture-field of a product as a 1 row portal and then duplicate as much as products I have so when I click on the picture a script is triggered and the product is added to the invoice. Morever, I have set an Object name to each tab Control so it would work, and also the desired value for zzz_g_collection_type comes from another related table with only one record that I use as preferences, this is on Preferences Table I have three fields called "Product_Type_Short_#" and those match on Elishree Day script tutorial. Any ideas what I could be doing wrong?
  14. I have a Layout in Table Mode as (partially) shown in the attachment. (Note: First row will have a Country Code in it - not shown in attachment) I want to "fill-down" the last country code in all rows (in the Country Field) UNTIL the country code changes. Then I want to similarly do it for that one. Until I reach the end of rows. My database will grow from 500 to 10,000 rows of text/number data. I am uploading in batches from Excel. Is this possible? I've tried various calculations and scripting without much success. Thanks! I'm trying to get something like this: COUNTRY IT IT IT IT IT IT IT IT ES ES ES ES ES AU AU AU AU AU IN IN IN IN .......etc
  15. POS question

    Hi all not sure if this is the right area for this post however,any Help appreciated in a design that i am working on for a small point of sale i have an issue (or challenge) the normal price is set as a Retail Price (all good) however I have been asked to now fulfill this next part. A Multi-buy concept. so e.g. a bottle of wine would normally sell for $12.99 however there is a promotion where you can get 2 for $20 ea (or a breakdown of $10 ea) Now I have put a field in inventory table for multi buys i.e. fields 1. a checkbox for whether it is a multi buy item. 2. a field which indicates the qty of item that is applicable as in the above example 2 3. a field which indicates the multi buy price. 4. A field which calculates the individual price as in the example above $10. (multi buy price / qty) and just to throw a little more into it there is the possibility of a situation whereby it could be 2 OR MORE. so I have created a field which is a further checkbox which indicates whether OR MORE is applicable or just the base qty. I guess the question is how does one tie this into the POS where an item would usually under normal circumstances be scanned and price picked up from the inventory table I am just a little lost on this. I thought of a script that checks for multi buy applicable then pops the qty and price into variables which could somehow be used back at the POS screenoveriding the "usual price". Then the issue of OR MORE came into play and that is just for me draining my limited grey matter. or am i looking at this completely wrong and is there a possible better way ie use of a related table etc. Any Ideas would be appreciated. I hope this makes sense.
  16. I am new to FM, coming to it from a SQL Server/Oracle/Access background. I have created a database with layouts and while there is certainly much more for me to learn it generally is working as I desire it. However, I need to perform a task that I do not understand how it would be done in FM. The example below is not my actual problem but does exemplify my core issue and hopefully is easier to understand than if I described my project. I have a table of Users, a table of Entitlements, and a join table of UserEntitlements. I want to execute SQL that, for a given User, will read from the Entitlements table and insert rows into UserEntitlements for this user. The query will read from Entitlements, insert a row for every entitlement for this user and, based on data in Entitlements take, will mark some of the entitlements as 'active'. Ideally, every time I created a new user this SQL would be called (I'd have it as a trigger in a SQL or Oracle database, or I'd have a batch process that ran frequently looking for new users). Basically, as a new user is created I want to create their entitlements profile and activate standard entitlements. I don't need/expect a full answer - was just hoping I could get pointed in the right direction: is 'scripts' the area I need to explore? Is there a SQL capability to FM? I have not found it if there is. Thank you for any assistance you can provide, -Neil
  17. Find from a List

    Hello All, This may have been addressed before and I am very new to scripting in filemaker. Basically what I am trying to create is a script where I can find records from a carriage return separated list. I have created a field and a button to execute the script. For Example: If I have 50 records for every US State, in the field I could put: California Nevada Oregon Thus populating just the 3 records. Any help would be greatly appreciated.
  18. I am running FileMaker 14 on a Win 10 machine. I have a set of records that each have a field with a starting number and a field with an ending number. I have to perform a find that locates the record where the find criteria is greater than or equal to the starting number AND less than or equal to the ending number. I need to write a script that will just let the user enter the find criteria in a edit box and then go to the record. This will theoretically be only one record that would match from the dataset. Can anyone point me in the right direction with this? Thanks RDW
  19. Hiya, 1st of all - I have personally refrained from posting for help on a forum as I wanted to try and read, learn and solve my problems using trial and error! I am learning the FMP platform from scratch and am currently in week 2 of it. My question relates to a file I have attached to this post - the products area. For each product I have a number of 'size options' within it and each with their own unique SKU (stock keeping unit). Each SKU needs its own barcode. My job now is to produce a method to easily assign an 'available' barcode to a specific SKU. Barcodes are purchased from GS1 and are globally unique. I have a table hosting a pool of barcodes that I have available to me. They can only be assigned to one SKU and once assigned, needs to be removed from the available selection of barcodes in this pool. Issues I wanted to set a placeholder text for 'EAN-13' field in the product layout (this is the barcode). This field is a button! When clicked it can perform a script to open a popover or window containing all barcodes that do not have a 'ProductOptionID' assigned to it. How do I structure this script? Click the EAN field button - this sets the 'ProductOptionID' variable globally (is this correct to do) - [$$productOptionID] The script then opens the object 'Barcodes'. This is a popover button with a portal inside filtering all barcodes from the pool that do NOT have a productOptionID value in the foreign key field The script must then pause whilst I manually select a barcode and set a $BarcodeID variable? Or should I script it to pick a barcode at random from the pool of available barcodes (i've already set a script to give available a figure of 1 and unavailable a figure of 0) Then the script must put the BarcodeID variable in the product option record Is the above the right way to go about it? I also need a way to un-assign a barcode from a product and therefore remove the value from the product option id field in the barcode pool I have one more query. I have a relationship between Product Option table and the Barcode Pool. This relationship is O2M the barcodeIDpk with a lookup for the actual EAN (barcode) value on the Product Option table. When I set a barcode ID in the Product Option table - shouldn't the ProductOptionIDfk field update in the Barcode pool with the ID of the product option that the barcode is assigned to?? I am convinced I had it working earlier - but not anymore and cannot see to figure out why? See my relationship graph below and the solution attached. Thanks, Luke CRM Trial barcode.fmp12
  20. Hi All, Does anyone know why my scripts drop down menu might be greyed out? I am unable access these functions. Cheers, Simon
  21. Hi, Im in deep trouble I need help using scripts I am making a homework managing app for a project and i have created a few fields; date due, subject, task, and task type I need help on how to process this information and show computational thinking I need help in creating POP UPS!! I am looking for something, when clicked on, pops up a screen showing the outstanding work when the user clicks on button 1 which has a date which has past . AND I'm also trying to make a button 2 which shows entries that are close to the next few days please help as soon as possible and suggest any features i can add to the homework manager and how to write the script for the buttons
  22. I'm using 14 Advanced, and looking at the Script Workplace. The left pane has my scripts. Some are in folders, some not. How does one move an existing script into an existing folder? I tried dragging but that won't work. Must be a different way? Or perhaps they are moved someplace else in FileMaker Pro?
  23. I have a script that runs on open. It insists on selecting a non-modifiable field even when I end the script with a go to object command. How do you get a file to open in a neutral state - ie with no active field?
  24. Script Running Way Too Long

    Hello FM Pros Would appreciate some tips for the following script problem: I have a situation here where my scripts in FM 13 Pro Adv takes more than 5 hrs to complete a calculation. OS: This is Win 7 Pro. with 16 GB RAM (i5 Processor.) I have Field "A" which is a 7 digit code numbers FIELD, which most often are repeating numbers, from 200 different types. (And I have upto 80 million records, in this field.) Code examples: 1234567, 2345678, 5678012,... Fields "B" to "Y" (are global Fields) provides a reference number for each type of the 7 digit codes from Field "A". For example the code 1234567, as above, the reference is, eg. HH/2015/Jul/132, Code 2345678 the reference is, HH/2015/Sep/314,...etc Field "C" list the reference numbers from Field "B" in the order of the records from Field "A" I use the following scripts in Field "C" If [Field A="1234567"] Perform Script [Replace Field Contents Field C;Field B] Else If [Field A="2345678"] Perform Script [Replace Field Contents Field C:Field B] Else If (...until 200 lines of the references from Field) End If The script runs well. However, it takes more than 5 hrs to complete the entire 80 million records.) Would appreciate your suggestion to speed run the scripts. Many thanks in advance. Lawrencex
  25. One-time use button

    Hi all, Apologies if this in the wrong place, but it seems like the best fit. Just wondering if anyone can help me out with a script I'm struggling with. The background: I have a button I'm using to launch a new window with another layout, then create a new, related record. This action will only happen if the user has completed a specific field in the original layout (__pkCollectionRef), step one of the script. With the new window open, the user will then make a selection from a checkbox set and close the window, which will put their selections into a field in the original layout. This part's all fine. What I want then, however, is for the button to be made inactive once they've completed their selection, so the script won't run if they press it a second time (this is to prevent the creation of redundant records - there is another button that will allow them to edit their previous selections if required). I've attached two screen grabs of the script steps. The first is the script I require help with, the second is the script run if the necessary conditions of the first are met (i.e the creation of a related record in a new window and layout). The _fkPickList field in the original layout will only be populated upon the creation of the new related record, so I had thought that adding the isValid calculation as a means of halting the script would do the trick, however what's happening is that it's preventing the script from running in the first place. As a side note, I've also added conditional formatting to the button so that when the _fkPickList field isValid the text is greyed out. This one discourages pressing the button a second time, however, not prevent it from working. Thanks in advance for the help. All comments appreciated. Franco.

Important Information

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