Community Videos, Tips, & Techniques, Articles.

Nick Hunter continues the conversation on his most advanced and powerful techniques to search records, combine multilevel filters with search, and search records from multiple related table sources at the speed of light. Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Nick Hunter explains in-depth his most advanced and powerful techniques to search records, combine multilevel filters with search, and search records from multiple related table sources at the speed of light. Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Introducing our Video Training Course for the FileMaker 19 Platform! Watch this introduction video that will start your journey into 60 hours of amazing video training. The course has topics for beginner, intermediate, and advanced users! For more information or to purchase this course, visit: FMTraining.TV [email protected] www.fmstartingpoint.com www.rcconsulting.com

"Insert From Device" is a FileMaker Go specific script step, which provides most of the awesome capabilities that people expect from a mobile device. This includes signature capture, barcode capture, image capture, and video capture. Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

You may have read the documentation about the new JavaScript integration in FileMaker 19. Let's take a look on this in detail. For every website you load, FileMaker injects automatically a little JavaScript when the page is finished loading. The JavaScript for the PerformScript script in the FileMaker namespace looks like this: As you see for MacOS (and iOS), they use the MessageHandler protocol offered by WebKit, which is the same we use for our WebView.AddScriptMessageHandler function in MBS FileMaker Plugin. The message handler is quotes the given parameters, builds a JSON text and passes this to the message handler. If you need, you can use MBS FileMaker P…

Have you seen the machine learning functions in FileMaker 19? Apple added CoreML framework in 2017 and presented it at WWDC that year. The framework allows to easily load a model for machine learning and call it with your input data. Examples include visual detection of things in pictures like image classification. Other examples include speech detection and sound analysis, text analysis or pattern matching. For example we saw models to take text and tell you the language or the mood of the writer. Also welcome are models to detect porn or violence to filter those. FileMaker 19 comes built-in with a new script step Configure Machine Learning Model to loa…

Understanding the need for continuously updating data as opposed to historical snapshots. Lookups are good for creating one-time relational links. Learn the differences and how to integrate both into your FileMaker solution. Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

In Part 1, we discussed all of the tools within FileMaker itself. In Part 2, we discuss many of the external tools that are available to all developers to help their efforts. It's a fascinating discussion and we almost guarantee that you'll discover new tools that may well become essential to you and your work. https://firesidefilemaker.podbean.com/e/developer-tools-part-2/ P.S. Today we hit a huge milestone by surpassing 20,000 downloads. We are immensely grateful to all of our listeners.

The just released FileMaker version 19 brings some welcome additions to use JavaScript with web viewer. You can now use a script step Perform JavaScript in Web Viewer to run JavaScript within the web viewer on the current layout. In MBS FileMaker Plugin, we have our own WebView.RunJavaScript function since version 1.3 from July 2007. That function has been upgraded as WebView.Evaluate end of last year for version 10.0 of our plugin to provide results back on MacOS, Windows and iOS. The built-in functionality has an advantage the plugin can't provide, which is is having it work in FileMaker Go or Web Direct. But you first need to upgrade everything to FileMaker v…

During this Q&A with a twist, we look at sample files and cover multiple topics like: Portal filtering, Virtual Lists, Master Detail Layouts and more! Sample file download links can be found in the description of the video. Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

View File The New Add-on Feature: Caveats, Cautions, And Nuances In an effort to raise awareness about this and to offer some recommendations about Best Practices, we are providing this document in bullet-point format for the FileMaker Developer Community. —By— Stephen Dolenski and Steven H. Blackwell Submitter Ocean West Submitted 05/20/2020 Category White Papers FM Version 19

Record Locking - Only 1 user can edit a specific record at a time. Preventing users from running into each other in a shared, hosted solution is an important skill for a FileMaker Developer in order to keep workflow going. Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

In this special LiveStream Q&A clip, Richard takes the time to answer some great questions on PDF generation and saving to a path in FileMaker. Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

We have three handy custom functions for you to log function calls with MBS FileMaker Plugin: CountScriptCall LogFunctionCall LogFunctionResult And they can be used together to log function calls like on the screenshot here: CountScriptCall Now let's take a look on each function. Start of the script may just call the first two functions together in one Set variable script step: The CountScriptCall function is to check which scripts get called and how often. We can call it in each script on the start to log that this script is still in use. We use a global variable $$LogScriptCalls to turn this on/off as needed. In th…

What does it mean for a FileMaker database to be "normalized"? In this special LiveStream Q&A clip, Richard takes the time to answer this great question on database normalization and expand on the concept. Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Is it possible to create so called "global" layout object? You update it on layout1, and it is auto-updates in layout2 and layout3? --- Example: I have three Contract layouts and they share the bottom part, where person sign it. I called this object as Sign. Sometimes, I add new merge fields to this part, and I have to go through all of the Contract layouts and add merge fields.

This is the weirdest thing. I use a script to produce a collection of PDF'd reports that go into a specific folder, which is identified in the script. There are 31 reports that are produced by this script. Of those, only one won't save. The error message below is for another script that is getting the same error message. That one file contains all 31 reports. I have no problems with space. I have tried different names for the file. The only thing that is a mystery to me is the part in the error that says, "unlock it." I have no idea what "it" the message is referring to. I wouldn't know how to lock a disk, and the other files were able to access the same di…

Data doesn't always have to be displayed vertically in a table. Pivot Tables are a great way to reorder data laterally on a layout. Calvin Mosiman takes apart a Pivot Table Sample and discusses it. Learn how you can incorporate this into your solution! Sample File: https://bit.ly/2W4382k Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

In team settings, digital document management can be the difference between a well organized business and workplace confusion. We cover the basics of container fields, storage of the container, performance considerations and much more about Digital Document Management. Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Gents, when I evaluate ExecuteSQL in DataViewer - it is working, but when I attach this calculation to field - it doesn’t! I receive a “?” instead. Where am I wrong?

On the last of three FileMaker API Days, special guest engineer Art Sevilla wraps up the conversation on FileMaker and APIs. Download the work files: https://bit.ly/3aYTxO9 Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

In the second of three FileMaker API Days, special guest engineer Art Sevilla expands on Day 1 as we continue the conversation on FileMaker and APIs. Download the work files: https://bit.ly/3aYTxO9 Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Gents, I have 3 layouts: Contract, Appendix 1, Appendix 2. I need to print all of them into one pdf file. Is it possible?

In the first of three FileMaker API Days, special guest engineer Art Sevilla discusses what an API is and defines terms like REST, JSON, and Postman. Download the work files: https://bit.ly/3aYTxO9 Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

This stream is for beginner to advanced users who want to learn about the proper use of pop-up lists, menu lists, radio buttons and checkboxes. We also mix elements to create multiple control styles and uses for each. Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Anyone could please help me with my script? Validating the following fields: DatePaid,OR# and AmountPaid. i'd like to validate the field with Script Triggers -OnCommitRecords and with the Button(Save). I have attach my script here, problem is it seems the first "if" line is the that works.

In this two part podcast, John Mark & I, are once again joined by Marc Larochelle (CEO of Productive Computing) for a discussion about the tools that are available to FileMaker developers at all levels. This part mostly covers the internal tools and options that are available inside of FileMaker and in Part 2, we'll be discussing some of the external (commercially available) tools that could enhance your development efforts. We hope you find the discussion interesting and enjoyable. Part 2 will be released on May 20, 2020 https://firesidefilemaker.podbean.com/e/developer-tools/

This stream covers different aspects of what it takes to use FileMaker WebDirect as opposed to FileMaker Pro Advanced. Decide if the challenges and benefits weigh in your favor. Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Nick Hunter is back with the newest installment of Lean Design! Now available in reduced fat, this Extra Lean Design live training session covers multiple ways the List Function can help make your solution better. Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

You have a FileMaker Server installed, e.g. on Windows Server, and you need the MBS Plugin installed. Let us guide you though the installation process. We expect you have a current FileMaker Server running. If you have an older/newer one, the buttons may be on a different position. Copy Plugin Files First in Admin Console, please stop the database server, so you can later enable it again. Only when server engine starts, it scan extensions folder and leans which plugins are available. Please use the "Stop Database Server" button: Now the browser changes and shows the server is off: Next go to explorer and locate two folders and copy the MBS.fmx64 …

Anyone could help me with error-trapping script. I would like to have to set up a script which will show dialog box when i left the "Date Billed" empty records. After the dialog box, that only shows Ok button, then go back to the layout and go to the field (Date Billed), for the user to fill the records. I would like to apply this in all my fields that is required fields. instead of the filemaker error message ,i'd like to do it in a script. i have attached my script which is continues to save even if the show dialog opens with (Revert Records,Yes,No) options, I would like to have a show dialog box with just ok button if the is empty field is True.

I’ve been using remote open for years when working at home. For some reason it’s no longer working. When I click on favorite host I see the the fmnet:/xx.xx.xx.xx but I no longer see the files. When I’m on my work network I don’t have an issue. The port on the router is set to 5003. FMP 13 with Windows 10. Thanks.

With latest pre-release we added the WebView.SetInternetExplorerHiDPI function to switch on the HiDPI aware more for FileMaker application (or runtime). See comparison picture: In your start script you can just call this function once to enable it: MBS( "WebView.SetInternetExplorerHiDPI"; 1 ) When this option is active before web viewer is created, the web control will display the content high-dpi aware and zoom to 100% independent of the DPI of the display. In earlier blog post we recommended to use JavaScript to zoom the website: MBS( "WebView.RunJavaScript"; "web"; "document.body.style.zoom = \"200%\"; ") But this is no longer needed on Windows o…

Wish there was a part 2 to the conversation on Virtual Lists? Well you're in luck! Join us as we continue the talk about how to use them and what makes them valuable! Download the sample file: https://bit.ly/353fbj0 Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Do you want to learn how to create your own Custom Menu in FileMaker? Follow along as we walk through what that looks like. There are endless options; it is called "custom" for a reason. Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Do you want to learn about Virtual Lists? Join us as we talk about how to use them and what makes them valuable! Download the sample file: https://bit.ly/2VO2V1T Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

When most of the world is forced to work from home, many things you took for granted can disappear over night. Speed of the internet is one of them, performance of your business critical apps follows very closely. The good news is that most of the custom FileMaker apps out there do not use the full power of the platform and they can be made much faster. So let me share a few tips on how you can optimize your FileMaker apps for working from home over the slower-than-usually internet connection. Do you know what tools you can use and how you can improve your app's performance to an acceptable level even when connecting from home over VPN? For example, one ne…

ScriptMaster is a free FileMaker plugin brought to you by the folks at 360Works. Join us as we discuss and demo some of the free plugin's capabilities. For more on ScriptMaster, visit: https://360works.com/scriptmaster/ Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

We have made a ton of example code in the last decade showing how to connect to Microsoft SQL Server from MacOS or Linux using FreeTDS and our MBS FileMaker Plugin. And there are two ways to do it: 1. With loading driver directly Set Variable [$result; Value: MBS("SQL.SetClient"; $Connection; "ODBC")] #Tell plugin where freetds library is Set Variable [$result; Value: MBS( "SQL.SetConnectionOption"; $Connection; "ODBC.LIBS"; "/Users/cs/Desktop/libtdsodbc.dylib")] #Connect to database Set Variable [$result; Value: MBS("SQL.Connect"; $Connection; "DRIVER={FREETDS};Server=192.168.2.32;UId=SA;PWD=test;Database=test;TDS_VERSION=7.2;Port=1433")] As you see, we poin…

I have a portal from a child table and i'd like to have a button on each record on a portal for me to edit the data using a card window. I am already using GTRR on a card window, but no luck it does't show the record that I clicked on a portal row. Anybody could help?

Need to test a script to see if it works as you're hoping it will? Script Debugger does just that! Let’s test a script and watch it run step-by-step. Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Everyone here has an interesting FileMaker Origin Story. Sometimes we stumble into the platform, and sometimes we make a deliberate choice. We all know the ending of our stories, but what happened at the beginning? We at Geist Interactive are interested in FileMaker developers' origin stories. We're collecting stories into a series of episodes on The Context Podcacst. Here's the trailer: https://share.transistor.fm/s/d8ad250b Feel free to share your story too. We'd love to hear your story. Reach out at [email protected] or send me a message. We'll set up a time to share your story. Please consider it: no matter your experience level, we want to…

With the recent release of LibXL 3.9, we got new functions for working with styled text. For our MBS FileMaker Plugin, we added new functions for styled text: XL.Sheet.CellIsStyledText XL.Sheet.CellReadStyledText XL.Sheet.CellWriteStyledText Now you can pass directly styled text from a field in FileMaker to a cell in an Excel document. Or you build a styled text from scratch with text formatting functions in FileMaker like in the example below: # create sheet Set Variable [ $sheet ; Value: MBS( "XL.Book.AddSheet"; $book; "Styled Text Test") ] # Set Variable [ $row ; Value: 1 ] Set Variable [ $col ; Value: 0 ] Set Variable [ $text ; Va…

A look at Tony White's collection of FileMaker tips and tricks. For more of Tony's collection, visit : http://twdesigns.com/ Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Nothing to do with FileMaker but I decided to write a letter to the Coronavirus and tell it what I thought of it. I'm hoping to get a reply

The While Function was introduced in FileMaker 18. Nick Hunter takes the opportunity to break down how and when to use this new function. Download the sample file here: https://bit.ly/2Kr7euo [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

For some time now we can sign PDFs with DynaPDF functions automatically in a script in FileMaker. For next pre-release we add a new feature to add a custom signature appearance. You define in your script how the PDF draws the signature on the page and includes the validation icon. That validation icon is a special feature of the PDF reader where they draw a checkmark to let you know the signature is valid. Like this screenshot: We draw in the box there to show it's signed, write the name there and then tell the PDF viewer to place the icon left to the text. If the PDF viewer doesn't know or doesn't check, this should display a question mark. See picture on the righ…

This episode is a continuation of our examination of the 179 script steps in FileMaker 18. We talk about the ones you should know intimately, the ones that you need to be aware of and use occasionally and finally the ones that you should never, under any circumstances use. As always, we'd love to hear your comments so please email us at [email protected] https://firesidefilemaker.podbean.com/e/the-good-the-bad-and-the-ugly-part-2-1587545578/

Keyboard Shortcuts in FileMaker can save you a lot of time. Let's talk about how these shortcuts can be useful to FileMaker Developers. Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Recently a client asked whether we could integrate the libPhoneNumber library into the plugins. Well, it's a big C++ library with a lot of dependencies and it looks like building a static version for our plugin or a DLL version to load at runtime is a bit tricky. But we found the JavaScript port of the library on the same website. This one has a couple of dependencies, but it can be compiled into a single file version with all required libraries embedded in one JavaScript file. As you may know we introduced a JavaScript engine into our plugins last December for both FileMaker. This JavaScript engine is capable to load the standalone version of libPhoneNumber and exec…

This new $79 tool generates “Web Reporting” quickly and easily from your existing FileMaker Server. Web Reports require NO additional server licenses and provide remote user web browser access to view and edit data... all from a browser. To learn more about this amazing tool, visit: https://webportalwizard.com/ [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

On HOnza Day, we were excited to review and discuss some of 24U Software's awesome products. We followed that up with a conversation about how you can improve your database performance! Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

currently working on water billing system. Parent Table-Customer Infor(Consumers Table) Child Table-Transactions(Meter Reading Information) I have a Ledger Layout which I want to show the data from the related table, and print all the data with more than one pages. The Ledger Layout in set to Transactions Table. I tried using the Go To Related Records but it is not the results that i want cause it shows all the data in the Transactions Table.

i am currently building an application for Water Billing System. I have 2 tables: wb-which is the Customers Information. Transactions-for the Water Meter Readings Record. i am working on my reports layouts for filtering using 2 global fields. that i set before opening my report layouts. Global Fields-g_Address & g_Month. this my script that i am using. Set Variable[$Address; Value:g_Address] Set Variable[$Month;Value:g_Month] Enter Find Mode[] Set Field [wb::Address;$Address] New Record/Request Set Field [Transactions::Month;$Month] Perform Find[] i have set this on Script Triggers-OnRecordLoad …

The FileMaker Data Viewer gives you under-the-hood access to your data. It is a great tool for analyzing scripts and testing variables, both on a record and file level. Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Our lead developer Milan made his dream come true and built a pond controlled by FileMaker and Raspberry Pi. The pond contains about 35 cubic meters of water (about 9246 gallons) and it’s 2 meters (6.5 feet) deep in its deepest point. It is equipped with both mechanical and pressurized filter, UV light, pumps for filtration and waterfall, and an air pump. There are water plants, fish, and other water animals living in the pond. To keep the pond in good conditions, Milan has automated control of its environment with the help of Claris FileMaker and Raspberry Pi… Click here to read how he made it all work and even watch it in action

Using some Categories and Sorts, you can create a neat Folder toggle within your FileMaker portals. In this tip, we show you how this can be done and include a free demo file to help you get started. For more helpful tips, check out: FMCoachesCorner.com Download Sample File: https://bit.ly/2K99QgA [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

What are Dynamic Windows and how can you use them in your FileMaker solution? Join us as we compare Card Style windows, Popover windows, Custom Dialogs, Sliding Shelves, Sliding Panels and tabs. Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Relationships are a key foundation in FileMaker. Without them your data does not connect or “talk” to each other. Let’s break down this thought process to better grasp this important basis of development. Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Claris has recently released Claris Connect. It’s an integration platform provided as a cloud-based service, letting you easily connect many different apps and make the data smoothly flow between them. To show you how it works, I have prepared a short demo using Claris Connect to integrate a FileMaker based CRM with Maichimp. Read how Claris Connect fits in the toda's world and how it compares to other integration methods

We hear the term "deprecated feature" thrown around from time to time but what exactly does that mean? Is it a feature that is on its way to being completely removed or is it completely removed already? Join us as we dive into deprecated features in FileMaker you may not know about! Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

You may have heard the term “Customer Relationship Management” system or CRM. Maybe you have one already? Maybe you need one? Let’s look at a fully unlocked and FREE CRM that you can run from within FileMaker. Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Explore the various options under the TOOLS menu that is part of FileMaker Pro Advanced. This includes a discussion of Runtime, Kiosk Mode, Removal of Admin Privileges, EAR Encryption and other capabilities. Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

View File OAuth Extensibility Addendum4 Authentication With ADFS Wim Decorte and I are pleased to announce the release of another Addendum in our series of White Papers on extending the oAuth Authentication capabilities of the FileMaker Platform. This one deals with the use of Active Directory Federation Services (ADFS). FileMaker Server has been able to authenticate against Active Directory since 2004 (FileMaker® Pro 7. In order to authenticate users against Active Directory, your FileMaker Server has to be a member server in that Active Directory domain so that FileMaker Server, through the Operating System configuration, w…

Whether you are a FileMaker developer, a RCC customer or just an advocate for the community - adopt these habits in order to grow your business. Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

When you need FileMaker records as JSON, you can just query them via MBS Plugin functions. Use FM.SQL.Execute first to run SQL and get reference number to result in memory. Then call FM.SQL.JSONRecords to get the records as a JSON array. This has high performance and may be faster than looping in a script to build the JSON in pure FileMaker functions. Once you have the JSON, you may just pass it to FileMaker's data API to move records to another server or pass them as payload for a web service. Within the SQL you can make adjustments to the data. For example you insert fixed values with putting them in the SQL (text in single quotes), you can use CONCAT to concat text…

FileMaker Cloud 2 has been released and is available for use. Join us as we talk about the new features and what it can do for you. Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

View File OAuth Extensibility Addendum3 Wim Decorte and I are pleased to release another paper in our series on oAuth 2 OIDC and the FileMaker Platform. This one deals with a new IDaaS provider as well as secure password-less authentication. Submitter Steven H. Blackwell Submitted 04/06/2020 Category White Papers FM Version

Charts can be a powerful way to quickly see how your data stacks up. There can be simple charts made directly within FileMaker to complex ones that are created by outside vendors. To catch future live streams, check out the schedule at: https://fmtraining.tv/#LIVE Download the demo file here : bit.ly/chart_demo [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Recently I got a client complaining about a crash in FileMaker Server with a script using plugin functions. A look on the trace output from our plugin via MBS("Trace"; $path) function call to write a log file showed the problem. The loops where running endless. And an endless loop eventually causes trouble when some resource is limited, e.g. available memory. Looking on the script we basically found this a couple of times: Go to Layout [ “MyTable” (MyTABLE) ; Animation: None ] Perform Find [ Restore ] Go to Record/Request/Page [ First ] Loop # process record # # next Go to Record/Request/Page [ Next ; Exit after…

FileMaker Go is the application that runs on an iOS device and let’s you interact with your database. It also has some unique features and capabilities that we are going to demonstrate. To watch these streams live, check out the streaming schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

If you or any of your friends or family are suffering from anxiety about the coronavirus, this video offers some commonsense advice that may help. I hope it does. https://youtu.be/rKwzAGKI-J4

FileMaker Cops Ep.2: License Pirates. Whatcha gonna do when the FM Cops come for you? FMTraining.TV, here to protect the world from bad code and development practices. Happy April Fools! [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

FileMaker Cops Ep.1: Chasing Loops. Whatcha gonna do when the FM Cops come for you? FMTraining.TV, here to protect the world from bad code and development practices. Happy April Fools! [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Is your database secure from outside threats? There are some simple things you can due to greatly increase your FileMaker security. For more helpful tips and to ask your own questions live, find the streaming schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Excerpts from my “FileMaker 17 Performance Lab” session are available, covering some of the topics not covered anywhere else, as well as from my presentation of upgraded demo integrating 11 hardware technologies. Take a look at highlights of the FileMaker Konferenz 2018 and learn how field dependencies can slow down your Set Field, how to minimize the impact of slow network connection, why to avoid overusing conditional formatting, how to benchmark and optimize layout rendering, or how to integrate RFID, NFC, mobile printer, motors, digital scale, and other hardware with FileMaker app running on iOS. Click here for the whole article and videos

Not everyone likes to mess with Custom Menus but sometimes they are necessary. Senior engineer Calvin Mosiman is back to show you what the process of setting up your own Custom Menus would look like. To catch future live streams, check out the streaming schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Senior engineer Calvin Mosiman demos a brand new audit trail sample, answers questions about the best features and shares tips on things to look out for. To catch future live streams, check out the streaming schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

View File Addendum2 oAuth Extensibility Working With OneLogin Wim Decorte and I are pleased to announce release of Addendum2 in our oAuth series for the Claris FileMaker Platform. This one focuses on the use of the OneLogin IDaaS service. Submitter Steven H. Blackwell Submitted 03/25/2020 Category White Papers FM Version

A lot of businesses currently have their employees working from home. A location change should not make your performance suffer. In this live stream recording, we go over performance tuning your file for remote FileMaker Users. If you want to catch more of the live streams and ask your own questions, find the schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Do you want to save a ton of cash getting your small business’ CRM up and running as soon as possible? Check out this recording of our live stream to find out how. If you want to catch future live streams, you can find the schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Open Q&A with FileMaker experts. Questions about installation, upgrading... or how to make FileMaker work for you. To find out when the next live stream is and ask questions yourself, check out the live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

We made a new video to show you a few newer examples for MBS FileMaker Plugin this spring. Later download the plugin to try the examples yourself. Watch on our website or on Youtube. 0:15 Signature Field 2:40 Barcode functions on MacOS 8:10 WebView.Evaluate on MacOS 11:20 Font in Script Workspace 13:50 WebView.Evaluate on Windows 14:40 Barcode functions on Windows 15:20 WebView.PostURL 17:35 Windows Media Player (WMPF functions) Please don't hesitate to contact us with your questions.

In this article I want to introduce you to the new functions from the MBS FileMaker Plugin in version 10.1. JavaScript In the last plugin version we introduce the new JavaScript component. With those functions it is possible to use JavaScript without the help of a web viewer. In this version we have added some features, that simplify the work with JavaScript functions. Times and dates in JavaScript are passed as floating pointer numbers. The function “JS.Now” returns us the number of milliseconds since the 1st January 1970. So we can determine the current time in combination with the “JS.TimeToDateComponents” function. This function returns us a JSON object with t…

Barcode scanning can work smoothly with FileMaker, either natively on an iOS device or with a handheld scan gun. Your warehouse Production checkin just got a whole lot easier! For more live training, check out the schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Topic: NY FileMaker Pro Developers' Group Time: Mar 19, 2020 05:30 PM Eastern Time (US and Canada) Join Zoom Meeting: https://meetmsk.zoom.us/j/515666745

In October 2017 I presented two sessions at the German-speaking FileMaker Konferenz. My first session was focused on results of almost forty thousand performance tests our team had performed and evaluated to compare different versions of FileMaker Pro and FileMaker Server and the second one was focused on our recent great discovery of the impact of database structure on its performance. Now we have made the best parts of those sessions publicly available, so don’t hesitate and dive into the deep waters of FileMaker performance and I hope you'll find the videos useful.

I'm trying to insert the html code of a product page on a website for later Web Scraping Data. I am aware of the standard practice of using "Insert from URL" to get the source code, but I would only retrieve the content of the unmodified (pre-javascript altered) page, not the page after javascript has modified the DOM. Options I tried so far: 1) Make a webviewer from the url and use the GetLayoutObjectAttribute ( "webviewer" ; "Content" ) it shows the content of the unmodified (pre-javascript altered) page, not the page after javascript has modified the DOM on Filemaker Pro on mac. 2) As pointed from Tod on https://stackoverflow.com/questions/25561850/…

I have a portal,which i could add data, and i have a button in every data that the user can edit the data entered,but i want to set up a security before editing,it will show the account log in form before they can continue editing each data.

Learn to make highly efficient FileMaker custom apps that perform well on FileMaker Server or FileMaker Cloud by utilizing "lean design". In part ten of this course, Nick wraps up with some helpful design tips and real-life examples. To watch the rest of the Lean Design Course and download the free sample files that go with it, visit: https://fmtraining.tv/marketplace/lean-design.html [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

We hope you’ll join us in Nashville this August for Claris Engage (formerly DevCon). Unfortunately, the emphasis is on “hope.” We’re watching the news like you are. We’re concerned for those affected by Covid-19, and with the awareness that our event could put any of you at risk, determined to proceed intelligently. Meanwhile we’re seeing many events like ours cancelled, rescheduled, or virtualized. Still we choose to be hopeful because Claris Engage is a vital part of our year and yours. It’s our annual gathering to communicate, learn, and connect. The Claris community is easily one of the greatest partner and developer communities in the world. And now with Connect f…

WOuld you ever consider not using a list view and detail view in custom apps? Alexis Allen talks with us today about that very idea. Instead of a design that highlights the data structure, build a system and design it so that it emphasizes the workflows. Check out the episode here https://share.transistor.fm/s/0e15cab6

All Claris Connect flows start with an event that triggers the rest of flow, your FM app can act as a trigger by running a script. This is a walkthrough on how to set that up: https://www.soliantconsulting.com/blog/claris-connect-flow-filemaker/

This is part one of two and outlines the 'why' and then goes into the how to authenticate from inside FM. A big part of the 'why' is that providers like Microsoft and Google are making a big push towards us using their APIs instead of older and less secure SMTP / POP / IMAP protocol implementations that depend on just a username and pw. https://www.soliantconsulting.com/blog/microsoft-graph-api-filemaker-one/ oh, and it has a fully functioning demo file...

Learn more about FileMaker Server 18 (either Mac or Windows) Stability. [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Walk-through on how to set up, configure and use the Claris Connect on-premise agent to connect to a FileMaker Server that is not exposed to the internet https://www.soliantconsulting.com/blog/claris-connect-on-premise-agent/

I wanted a quick way of modifying a script to analyze its load time. While the raw results can be used however needed, in this example I converted the data into a simple 'chart' for a quick visual summary. RIVET Script Load Time v1b.zip

We received an email today from Russell Watson and we like to share it with you: If you have stories to share, please let us know. PS: Syntax coloring is a free feature of MBS Plugins for FileMaker on MacOS.