Community Videos, Tips, & Techniques, Articles.

A number of people say that Join Tables are too complex and totally unnecessary but they don't have to be! We’ll try to help educate you on some relational database techniques and hopefully make join tables a little less complex. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

We heard the cries for an inspector for Windows and looked around for help. Recently we found Firebug, but that only works if you install it on the same domain. Our search continued and we found DebugBar, an extension for Internet Explorer and it still works in Windows 10, so we worked on an integration into FileMaker as DebugBar doesn't do that as is. For MBS FileMaker Plugin 10.3 we add the new WebView.ShowDebugBar function. Our plugin will look for the web view in the FileMaker window, then create a new window and host there the DebugBar component. Looks like this: We have four tabs there. The first one allows you to inspect the DOM and you can use the green …

Did you know you can use XML functions in MBS FileMaker Plugin to split your Database Design Report XML files into smaller XML files and put them in a GIT repository? First you can use FM.RunDatabaseDesignReport function in our plugin to trigger FileMaker to create a DDR by script. Or you use AppleScript for GUI scripting as you can see in this older blog post: Automate creation of Database Design Reports in FileMaker. For FM.RunDatabaseDesignReport, here is an example line: MBS( "FM.RunDatabaseDesignReport"; 1 /* XML */; "/Users/cs/Desktop"; 0; "Anlagen.fmp12" ) First parameter is 1 to enable XML. Second parameter is folder path, but that is ignored on Windows o…

In this article I want to introduce you the new functions from the MBS FileMaker Plugin in version 10.3. LibXL Let's start with a few innovations with LibXL, that allows you to edit Excel files. You now have functions with which you can identify the area of the table where data is filled in. You can determine the first row or column in an existing Excel document and which one is the last row or column that is filled. This simplifies your work. For example, you want to enter data in an existing table. You first determine the last filled row and then you enter the new values in the next row There is the new XL.Sheet.CellWriteTextAsNumber functio…

Now that you have one foot into deploying your first app to WebDirect, we can move on to Day Two where we finish the conversation on some of the "gotchas" that can snag beginners. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Building your first app with FileMaker Pro can be exciting. Deploying that to WebDirect can be a different experience. We’ll discuss some of the "gotchas" that can snag beginners. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

One step closer to your first FileMaker Go App! Join us as we continue the conversation on how you can do a little advanced planning to avoid some "gotchas" that usually trip beginner developers. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

How exciting, you've decided you want to access your FileMaker app on an iOS device. If this is your first FileMaker Go custom app, there may be some "gotchas" that can catch beginners off guard. We'll cover these to save you some time and headaches! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

If your FileMaker Server crashed, would you know how to handle it? In this LiveStream we go over emergency restoration considerations. Free sample file: https://bit.ly/2YIbWff. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Help! My file is getting huge because of all the records I use for charting. How can I reduce the file size and produce the same chart? Jonathan Ray explains how to build native FileMaker charts and Google charts using JSON text instead of records. Sample file: https://bit.ly/31kaQbr. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Another day, another Server configuring conversation. Join us in Day Two as we continue the basics of installing FileMaker Server with an emphasis on backups and SSL Certificates. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

We invited Darren Terry on our show to talk about the calculation dependency tree (what triggers calculations to fire). What we got was so much more than we expected. Darren’s close ties with Claris engineers and dedication to the platform has given him insight into how FileMaker works under the hood. To put it simply, both of us were flabbergasted at how much he taught us about FileMaker. Come join us in this in this "can’t miss" PodCast about the calculation engine and whatever else comes across Darren’s big brain. (Our regular guest, Marc Larochelle had this to say "You can plant an entire garden while learning about dependency trees." https://firesidefilemaker.po…

Learn the basics of installing FileMaker Server with an emphasis on backups and SSL Certificates. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Jonathan Ray shows off a Lean Design Technique - How to create “summary” fields that give you the numbers you want without the dialogs you hate. Free Sample File: https://bit.ly/3dsfYwD. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

How fast can Auto-Enter Calculations run? VERY FAST. Join Nick Hunter as he covers the benefits of auto-enter calcs. Check out the video description for a couple free sample files. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

You've already taken one of your first steps towards becoming a FileMaker expert and learned how to build reports. So what's next? Subsummary Reports! Join us as we dive into the basics of subsummary fields. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Is the FileMaker Developer Subscription (FDS) right for you? Join us as we talk about what comes with the subscription and what you can't do with it. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

View File Sign In With Apple Addendum 5 Wim Decorte and I are pleased to release another in our series of White Papers related to extending oAuth2 and OIDC to the FileMaker Platform. Addendum5 deals with the use of Apple ID and Sign In With Apple to authenticate FileMaker users. Submitter Steven H. Blackwell Submitted 07/16/2020 Category White Papers FM Version 17  

Dialing your iPhone from FileMaker Pro or Go is a niche topic, but can be a major time saver for some businesses. Calvin Mosiman explores this capability using Open URL! Free sample file: https://bit.ly/37ICEYf. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Learn how to properly summarize and total up List Views and related records in a report. We will look at the very basics, including subsummaries, and how to tune for performance. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

On the third day of the new Video Player App overview, FMTraining.TV gave to me: a technical DAPI tear down with Jacob Taylor. Follow along with the free sample file: https://bit.ly/37ICEYf. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

One day wasn't enough to cover how awesome this new Video Player is. Nick Hunter takes over Day 2 and explores complex relationships, sorcery and Lean Design. Free sample file: https://bit.ly/37ICEYf. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

FMTraining.tv’s new Video Player is pretty awesome. By popular demand, and with the help of Myles Debski, we start Day 1 of our in-depth overview of the Video Player. Follow along with the free sample file: https://bit.ly/37ICEYf. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

With users being on various FileMaker clients, you need to make sure your UI is consistent between platforms. Nick Hunter to the rescue! We’re going to unpack the conversation of making UI work between all 5 or 6 FileMaker Clients. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Hello Everyone, We’re happy to release a new accordion table solution for FileMaker. Accordion tables allow you to have expanding rows in a FileMaker layout, fulfilling a similar role as a list view or portal. These are incredibly flexible and allow you to do things like: Nest Multiple Levels of Expanding Tables Combine Data from Different Tables into a Single List Trigger FileMaker Scripts from Clicking Table Elements Fully Customizable Style to Match Your Theme Download the demo and check out the documentation to see how you can integrate accordion tables into your solution.

With next MBS FileMaker Plugin (already in 10.3pr7 to try), you are able to trigger the sharing services in macOS from FileMaker. You can pass images, URLs, styled text and native file paths to various services. Not just one value, but several, e.g. Send text and image to Messages Send files, text, images, URLs, subject and recipients to Apple Mail Send pictures to Photos application Send text and URLs to reminders or notes applications Send files via AirDrop to other users Send URLs to reader list in Safari Send PDF to Books application Send picture to make it the desktop background More services are available, for …

Learn how to radically speed up your record filtering by offloading the script to the server for processing. Super Nick will be there to guide us through our learning experience. Follow along with the free sample file: https://bit.ly/nickmay2020 Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Learn how to leverage the Let function, and the massive performance improvements it can bring to your FileMaker custom app. Free sample file: https://bit.ly/nickmay2020. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Now loading: How to Build a Progress Bar in FileMaker. Join us as we discuss how you can enhance your solution with a progress bar. Follow along with the free sample file: https://bit.ly/nickprojectsstartersolutionfixed. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Make sure the core of your FileMaker App is well organized with proper naming conventions. It could keep you out of trouble! Check the description of the video for three FREE awesome sample files. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

After watching Nick Hunter present on how to “Empower Your Searches”, we figured that we should have a basic course on the benefits of Auto-Enter Calcs. Free Sample File: https://bit.ly/nickprojectsstartersolutionfixed. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

What is Workflow Security and how is it any different than "Bad Guy" Security? Learn about what it takes to protect your FileMaker data from both internal and external threats. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Ever wonder how FileMaker compares to Excel? Or how FileMaker competes with Access or other Database Management Systems? Join us as we explore these different programs and talk about how FileMaker can be useful for your team. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Is there a such thing as too many FREE sample files? In this special FileMaker Q&A, we cover an overview of Andre's sample file. Follow along, download the sample file: https://bit.ly/3gymyV3. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

When it comes to mutli-record selection techniques, this demo will explore both basic examples and advanced examples. Follow along with this free sample file: https://bit.ly/2XyXjJC. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Can't get enough of FileMaker 19's newest Add-on feature? We have you covered! We'll take a look at the components of a custom add-on as well as other caveats about building your own FileMaker custom add-on. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

The first step in building a script is learning about the tools you have. In this video for beginners, we dive into the "If" script step and the slightly more advanced, "Case" script step. Follow along and download the free sample file: https://bit.ly/2zsf05p. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

With the last DynaPDF update we got new support for ZUGFeRD 2.0 and Factur-X, two standards to deliver invoices as PDF files with embedded XML data. We supported ZUGFeRD 1.0 before and now upgraded code to support version 2, too. So here is a little FileMaker script to convert an existing PDF into a ZUGFeRD 2.0 document. Before you start, please assemble the XML for the invoice and know whether it's Minimum, Basic, Comfort or Extended level. So the script here initializes DynaPDF library if needed and then creates a new PDF environment. We set import flags to import all content and prepare for PDF/A. If needed, you could skip some content like annotations dire…

Learn the basics of capturing errors in your FileMaker Scripts, and presenting that information to the user. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

ExecuteSQL in FileMaker is back with Day 2 and this time with a sample file! Calvin continues the conversation as we explore ExecuteSQL in FMSP's Calendar. Download the sample file: https://bit.ly/3bO6JWA Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

ExecuteSQL in FileMaker is very powerful. It provides some additional ways of rapidly generating reports and finding unique sets of data without creating additional relationships. Calvin Mosiman dives into ExecuteSQL for beginners, so they can learn to use this valuable Function. Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Makeovers can take some time and effort. UI makeovers are no different! Nick Hunter lays down design rules and guidelines and shares some important tips on slide controls and button bars. Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Watch as a viewer's solution undergoes a complete transformation into a more modern UI design... in real time! Along the way, Nick Hunter will lay down design rules and guidelines, giving precious insight, reasoning and advantages behind those rules. Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

On the third and final day of Nick Hunter Speeding the Search in FileMaker, we have a sample file to share with you. Download the file: https://bit.ly/nickmay2020 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 Deploying FileMaker 19 Video Training Course! Enjoy this intro video that will lead you into the rest of the amazing 9 hours of video training on deployment. This 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

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.