Jump to content

Search the Community

Showing results for tags 'scripting'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


  • Claris Engage Vendor Discounts

Community Forums

  • The New Claris Platform
  • Community Resources
    • Community Videos, Tips, & Techniques, Articles.
    • FileMaker Marketplace Discussions
  • FileMaker Platform
    • FileMaker Interface Features
    • FileMaker Schema & Logical Functions
    • FileMaker Go for iPad and iPhone
    • FileMaker and the Internet
    • FileMaker Pro 19
    • FileMaker Pro 18 Advanced
  • FileMaker Server Administration
    • FileMaker Server 19
    • FileMaker Server 19 (Linux)
    • FileMaker Cloud
    • FileMaker Custom SSL Certificates
    • oAuth and External Server Authentication
    • Zabbix Server Monitoring
    • Previous Version Server Discussions
  • JavaScript Integration
    • Java Script and the Web Viewer
    • Carafe.FM
    • Widget Studio
  • Brain Food
    • Security Concepts
    • The Left Brain
    • Upgrading & Migration
    • Data Analysis
    • Development Standards
    • The Separation Model
    • Relational Database Theory
    • Damaged / Corrupt File Problems
    • Hardware & Networking
    • Product Ideas
  • 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
  • FileMaker Friday Night Chat's Topics


  • Captain's Blog
  • FileMaker Weetbicks
  • FileMaker Security Blog
  • The FileMaker Rift
  • HOnza's Bits @ FMForums
  • SeedCode
  • 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
  • 1-more-blog
  • Productive Computing
  • Geist Interactive
  • Soliant Consulting


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

Product Groups

  • Workplace Innovation Platform
  • Site Advertising
  • Development & Hosting

Find results in...

Find results that contain...

Date Created

  • Start


Last Updated

  • Start


Filter by number of...


  • Start







Website URL




OS Version

  1. I'd like to add a condition to this to not do it if "id" already exists in the table: Set Field [ Moby_Countries_Values::ID ; JSONGetElement ( $record ; "id" ) ] So that value, 'id' is embedded within the blob that I'm parsing already. In that loop some of the array sets may exist, others many not already. If [ not IsEmpty( $countries ) ] Set Field [ ISBN::JSON_VariableView1 ; $countries ] Set Variable [ $Cover_Group_ID ; Value: ISBN::ISBN_ID ] Set Variable [ $n ; Value: ValueCount ( JSONListKeys ( $authors ; "" ) ) ] Freeze Window Go to Layout [ “ISBN_Meta
  2. Have you ever inherited a system built by someone else, changed a field’s name and everything stopped working? The issue, hardcoded names used in indirection, makes the system fragile. FileMaker provides developers many methods to add flexibility using indirection. However when these instances of indirection are not treated properly they will raise all sorts of problems. In this article you will learn best practices regarding indirection that will help you build a dynamic and robust FileMaker system! Includes free sample file! Building a Dynamic and Robust FileMaker System Davi
  3. One of the most important and wide-reaching updates in FileMaker 16 is the ability to set cURL options in the Insert from URL script step. This allows FileMaker to natively integrate with innumerable services across the web, including Google Calendar, Google Maps, Microsoft SharePoint, and many other services. FileMaker cURL Options David Happersberger dbservices.com
  4. I have started sending emails using the INSERT FROM URL method shown by soliant here: https://www.soliantconsulting.com/blog/html-email-filemaker/ Emails are being sent out but many recipients seem to be getting my emails sent to their spam folders. I'm curious if this has anything to do with this method of sending emails.
  5. I have been running a document creation and management solution for 2 years. My scribe maintenance subscription ran out so I bought a new license. Boom the whole things has collapsed. Scribe is throwing errors when a field in the database does not appear as a merge field in the document the attached being a typical error. This solution is vital to my practice but 360Work have no taken 2 working days with no solution - not responding to my emails when I tell them that their work arounds aren't working. This was suggested "ScribeSetErrorCapture(true)" - but that does not
  6. This is the first example I was showing in my session Marvelous Optimizations at Pause On Error [x] London 2011. I already wrote about this optimization some time ago. It’s the one that led me to unveil the Marvelous Optimization Formula. You can find the original article here: FileMaker Script Execution Time Cut From 5 Hours To 6 Seconds I simply took the example and added FM Bench Detective into it to be able to exactly measure and examine what happens in the slow and the optimized script. Now you can watch the result in this video recorded at Pause On Error. Read more and d
  7. Am a bit lost on what (I think) should be a quite simple script: Field 1 has a value list on layout. Field 2 is a general text field for typed data entry.. My goal is to use Field 1 to trigger/manage a script which does severla things, but then leaves the mouse/selector inserted into Field 2, for ease of use... So... When I select an item in that value list, an OnObjectExit triggered script: sets a variable from that, then clears that field inserts a calculated value (based on the variable created) in another field. Then it SHOULD "go to Fie
  8. Not sure if this is the best neighborhood for the question, but it is tied to network/db security. What method is used to best determine how a user is logged in? Is Get(MultiUserState) the best method for determination of who/how someone is accessing a locally shared (peer-shared) database? For licensing purposes, we run several authorization scripts during login, and it is helpful to know how the access is working.
  9. Hey, I have a Tab-Separated Text File which I want to import to a database that I just created in FileMaker Pro 15. The text file essentially is a log of events, for instance, one line describes an order, another line describes a payment that has been made. The problem is that I somehow need to import all these lines into different tables. I want all lines in the log file that describe a payment in a table called Payments, and all lines that describe an order in a table called Orders for example. I'm just starting out with FileMaker so forgive me if there is an obvious solution that
  10. I have a simple Applescript that works in Script Editor tell application "Keyboard Maestro Engine" do script "Search the Web" end tell I add this same script (with escape chars) to my RESOURCES::A_SCRIPT field inside FM. The RESOURCES table is not connected to the other tables in the graph. "tell application \"Keyboard Maestro Engine\" do script \"Search the Web\" end tell" I've tried this with this field being defined as a Global Storage Field or not. Similar problems with both. I have an FM Script called EXECUTE: Perform Applescript (RESOURCES:
  11. I am having difficulty removing the .JPG extension from the file name of my imported pictures. The Pictures are actually students pictures saved with the student's ID Numbers. Example SLT-098-00034.jpg , SLT-088-11123.jpg I am trying to extract the real ID Numbers from the File names which should be in this format SLT/098/33322 Accomplishment So Far.. Using the Substitute function, Substitute (text; searchstring; replacestring) , I have been able to convert the file name from SLT-098-00034.jpg to SLT/098/00034.jpg Now, I want to remove the .jpg extension, but can
  12. I have a solution that syncs at the end of a "shift". The shift report says what happened during the shift. But I want to add a time card component that syncs when anyone starts work and ends work which doesn't always match the "shift" that one or two guards are covering. So, I want to keep the main Sync with Server script intact for the end of shift report but I want to dupe it, rename it and hardcode it to sync one or maybe 2 tables only. Since there will be only 1 or 2 records it should be fast. That way the timecards are always up to date and the shift reports are sent as a whole.
  13. I am scripting the import of data into some 400 tables already established. I have the corresponding 400 seperate data files (excel cvs). The script step "import" doesn't seem to allow the selection of the "current table specified by the layout" as a target. I goto the different layouts right before the import but the import does not change to the table that is used by that layout. When writing the script I do select the "Current Table "mytable" " as the target, thinking that this would change during execution. Nope it don't. Soo, 1) Can I have a dynamic selection during script execution
  14. When I set a variable this way: Set Variable [$StudentIDs = ""] the actual value of $StudentIDs is 0, not empty or blank. So it fails the IsEmpty test. Is this by design, it is a bug or am I doing something stupid? - Brad
  15. Dear FileMaker Pros, Perform Script on Server (PSoS) Doesn't Run I run FMP 13 (on Windows.) I import records to my Hosting FM Server from my Client. Running the script steps from the Client works well, but its a time consuming task of more than 4 hours, the records are big, almost one million. To save time, I switched the script to Perform Script on Server, (wait for completion, unchecked.) The script does not perform Import records, as it did without PSoS. My script steps on the hosting Server Db: ScriptName:"Import A" > Go to Layout ["Part_A"] > G
  16. 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
  17. I was lucky to have gotten an example file, which was based on designing a Subscription system. I think eos was behind it because of the file name. However, the subscription system was based on just three types 1 month, Six Months and 12 Months... I have tried to modify the scripts so that I can have more types like: 1,2,3,4,5,6... Months ( Basically all the months), I end up messing the whole system up. Please what values can I actually modify with respect to the required month I want? Here is a copy of the file.. LDprototype_subscription_eosMOD.fmp12
  18. Hello, I continue developing the POS and so far I have almost got everything to work as desired. However, there is still a functionality I will like to add. Right now I have a portal on the left which shows all the products pictures in grid, and when I click on the picture the script trigger adds the related item to the line_item table on the invoice. So far the script looks like this: Allow User Abort [ Off ] #--------------Set Variable Product ID Set Variable [ $PRD_ID ; Value PRODUCTS::ID_Product ] #--------------Add new item to portal Go to Field [ LINE_ITEM||id_invoice|::Product ]
  19. Greetings, Your expert advice and solution would be greatly appreciated. Based on the Invoice Starter Solution, is it possible to have a script that will automatically add all products from a specific category into an invoice?Of course not everything in one line item but each product in its own line item? The trigger will be set by checking a check box. The process should also not duplicate the item if it already exists. Many thanks for your support. Kunal
  20. I am not really good with scripting. I want a situation where by contacts with status as inactive are always omitted on entering the contacts layout. My challenge is to script this using the omit record script step. Secondly, another approach I want to implement is to have a check box field called HIDE which when checked, immediately removes (or hides but not deleted) that contact from the list, assuming I am on the contacts list layout... I don't really know if I have explained my question well... Thanks
  21. I have been trying to set up a means of locking down a record so that it can't be modified again.. For example, I want a record in the contacts table to become unmodifiable (locked down) by the user once the person must have entered his date of birth. Please how can I achieve this?
  22. FileMaker 14 SVG Icon Helper - Rev 2 | FileMaker 14 Training http://youtu.be/nk1lWHZ0AhI Download the FileMaker Pro 14 & FileMaker 14 for Mobile Devices Training Videos athttp://www.learningfilemaker.com Please Visit Our Channel: https://www.youtube.com/user/FileMakerVideos Please Subscribe While There. This updated Revision 2 (August 2015) features Claus Lavendt, of DataManix, showing a free FileMaker solution that helps customize SVG icons for use on FileMaker 14 buttons. Download a free copy of the SVG Icon Helper Tool here: http://fmstartingpoint.com/market.html
  23. I use FMSP from Rcconsulting. really love that product and very grateful to Richards and his team. The above script scans bar-codes items (my products) for sales. Now the issue is this, each scan of the same item suppose to add an increment in the quantity of the item and not adding the item on a new row thus having multiple lines of the same item. basically one needs to manually enter the quantity of the products after scanning instead of continuous scanning with the scan gun. Is there a way this can be fixed? I really need help.
  24. I've been inserting small bits of data from Filemaker Pro into other systems we've written for some time using "OpenURL". However, this approach works, but leaves you with a browser window open, and isn't able to see what the other system returns. So moving to the "Insert from URL" script step instead. This seems to work fine when the "Insert from URL" is the only step in a script, but it doesn't complete satisfactorily when "Insert from URL" is one of multiple script steps. What could be happening? My first thought was that perhaps the script step isn't given enough time to complete, but
  25. Is it possible to grab the current users password via script just like Get(accountname). I know this might sound like a strange request but the scenario I want to try and achieve is to re login from a mobile database to server with admin privilege run a script then relogin with the user account and password for the actual user. I would like to do this hidden and seamless. Yes i know i can run a script with full access privilege its just that my sync routine is only working with admin login not other user login and i just cant seem to find the solution as to why, however, this workaround does w
  • Create New...

Important Information

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