Community Videos, Tips, & Techniques, Articles.

Hi all, you can zip and unzip any FileMaker field without a plugin. This article will describe the Mac side of things and I’m still looking for a way to do the same on Windows. Will post it here when I figure it out. (Don’t know yet how to send PowersShell commands in the background and get screen output back into FM. 1) Zipping Pretty straightforward: 1.1) You export a container field to the TemporaryPath directory, 1.2) zip it and 1.3) insert the zipped file back into a container field. From then on you could store it in any type of field, just be sure to use the Bas64 functions, otherwise the contents will be changed when saving to a different field type…

It's another Dead Bird Friday - more Q&A and more free sample files! This time, Richard discusses FileMaker Server backups and how to deal with crashed files! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Jesse Barnum from 360Works joins the stream to spotlight their Safety Net product and give us a demo of how it works with your FileMaker Files! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

When using MBS FileMaker Plugin, you may need to combine a lot of functions together to get some work done. That makes our toolbox of functions so flexible to use for your needs. Let us show you four examples: Regularly import files from hot folder First you start with Schedule functions to run a script regularly every few minutes in FileMaker Pro. Independent of SetTimer script step, so you can have multiple of them. You look into a file path with Files.List to get a list of file names in the folder. By using our List functions you compare the current file list to the one from last run. For example List.And would find similar files in both files, …

Performing searches on the web, on the operating system or in your FileMaker file can be slow! But it doesn't have to be that way. Join Nick Hunter as he discusses the Search function on an advanced level. Future live streams:https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Performing searches on the web, on the operating system or in your FileMaker file can be slow! But it doesn't have to be that way. Join Nick Hunter as he discusses Searches and Relationships in FileMaker! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

FileMaker novices learn to make HIGH PERFORMANCE relational database with the assistance of this manual! https://amzn.to/3w8PqLk

Performing searches on the web, on the operating system or in your FileMaker file can be slow! But it doesn't have to be that way. Join Nick Hunter as he breaks down the Search function! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Explore our new add-on manager, pre filled with some useful FileMaker add-ons from Kristian Olsen! Day 3 discusses the six elements of making an add-on and an in-depth look at slide tabs! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Explore our new add-on manager, pre filled with some useful FileMaker add-ons from Kristian Olsen! Day 2 discusses Developer Mode and sharing add-ons to Wolfpack! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Let us show you a few things to use in MBS FileMaker Plugin and add to your solutions quickly today. Give your users a few new possibilities. From easy to complex, you may be able to copy a few scripts and adjust them to your field and layout names and get instantly new functionality for your solution. Let us show you a few things related to container fields in your solution: Continuity Camera If you have containers fields on a layout for images or PDF containers, how about adding a little button next to the field to let the user take a picture with their iOS device and insert it to the container? The button may be hidden, if it's not FileMaker Pro on a Mac. But …

The recording of the MBS Plugin presentation from FMDiSC meeting from 12th March 2021: FileMaker Developers in Southern California (English) 55:08 minutes Watch on Youtube Content 00:00 Introduction to developer goodies and syntax coloring. 30:30 fmSyntaxColorizer database 35:50 FileMaker Snippet Storage database 36:40 Script WorkSpace Context Menu Commands database 39:20 JSON functions like JSON.Colorize 41:00 XML functions like XML.Colorize 42:40 WIA functions, DynaPDF functions and GraphicsMagick functions together. 44:40 OCR functions and DynaPDF functions together 45:30 R…

When you use our MBS FileMaker Plugin, you will make a lot of calls to the plugin. Most will succeed, but some will fail. Do you notice when something fails? IsError function We see a lot of clients coding without checking for error state. But not all function calls succeed and our MBS FileMaker Plugin keeps a last error state for you. Even on server with multiple scripts running in parallel, we keep an error state per script. You can query it with MBS("IsError") to see if the last function call returned an error. You may do an error check each time you call a function with an If script step and handle the script. You may even write a log entry in a text fi…

Explore a new add-on product that is a package of useful FileMaker add-ons with Kristian Olsen! Day 1 will discuss how to use WolfPack and unveil its capabilities! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

'Transfer of Found Set' is an essential tool to have in your arsenal! In day 2, Nick discusses searching in related records and how important the transfer of a Found Set is with PSoS! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

'Transfer of Found Set' is an essential tool to have in your arsenal. In this first day, Nick defines found sets and discusses different found set techniques! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

In this article I want to introduce you the new functions from the MBS FileMaker Plugin in version 11.1. Archive With the new Archive.CompressContainer function you can compress the content of a container into an archive. In the parameters you can specify in which format your archive should be. The following formats are available for this purpose: 7zip, ar, arbsd, argnu, arsvr4, bsdtar, cd9660, cpio, gnutar, iso, iso9660, mtree, mtree-classic, newc, odc, oldtar, pax, paxr, posix, raw, rpax, shar, shardump, ustar, v7tar, v7, warc, xar and zip. Then you can additionally specify a filter at e.g. for zip format it can be store or deflate. We also need to specify the desti…

Let us show you a few of the new features in the version 11.1 of our MBS FileMaker Plugin: MBS FileMaker Plugins 11.1 (English) 17:23 minutes Watch on Youtube Some links for the video: 00:15 Installation 00:50 Preferences dialog 01:30 RegEx.DataDetector 02:30 QuickLook functions with new Markup 06:00 EPC Barcode project and Barcode functions 07:20 Enhancements for Calculation Dialog 09:00 Enhancements for Custom Functions Editor 12:15 Enhancements for Debugger Please do not hesitate to contact us if you have questions.

Richard and junior engineer Andy discuss vertical charts! Andy shows off his demo he’s worked on to explore the various charts usable in FileMaker! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

A brief explanation of primary keys. This video is for newbies/intermediates to FileMaker™ and is the 2nd in a series explaining key concepts in an entertaining and easy-to-understand way.

It's Day 3 of discussing PSoS with Nick Hunter! This video discusses fine-tuning your PSoS scripts and how to export records on the server! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Time for Day 2 of covering PSoS with Nick Hunter! For the second day, we talk about actually building a PSoS script, how to debug it, and when you should use it! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

In this 3-day Livestream, Nick Hunter discusses the ins and outs of PSoS! In this session, he covers PSoS from a beginner's perspective! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

It's an open Q&A with Nick and Richard! This time they discuss pie charts, donut diagrams, and more neumorphism questions! FREE sample file included! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Richard and Nick discuss FileMaker's latency by showing a demo file from the community as well as a bonus demo, Magnifier Glass. FREE sample files included! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Unfortunately we can't give you that new book smell through the LiveStream but you still won't want to miss this book review party! Join us as we walk through the 2021 edition of the “FileMaker Manual for Novices”. Learn more at: https://fmtraining.tv/#BOOK [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Jonathan Ray explains how to do custom FileMaker portal sorting with just a web viewer, a touch of JavaScript, and a teaspoon of magic. FREE sample file: https://bit.ly/37rgL0I. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

We may not be able to take the FileMaker Certification Test for you but we can make sure you're properly prepared to pass it! Richard wraps up the study tips in the final day of this 2-day event. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

If you are at all interested in hearing where Brad Freitag is taking Claris and how the Developer Community fits in to those plans, then you are not going to want to miss this podcast. It may well be the best use of 75 minutes in your professional life. https://firesidefilemaker.podbean.com/e/a-conversation-with-brad-freitag-1614645756/

For a few years we have worked on integrating the LibXL library and making functionality available for FileMaker. Beside all the standard built-in features from LibXL to read/write Excel files, we have some extra functionality developed ourselves: Copy Cells LibXL comes with a copy cell command, see XL.Sheet.CopyCell. Beside that we added XL.CopyRow to copy content of a row. Similarly XL.CopyColumn copies a column. As you can pass different book reference numbers, you may even copy from one document to another one or copy from one sheet to another sheet within the same document. The XL.CopySheet function can copy the content of a sheet to another document, great…

Just when you thought tests were a thing of the past, the FileMaker Certification test comes along. Not to worry though, we're here to make sure you're properly prepared to pass it in this two-day event! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Calvin joins us to give alternate techniques for filtering value lists and sorting a dynamic value list in a custom order. But wait there's more! Check out the description for a couple of FREE sample files! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

This video explores ways to get around FileMaker web viewer limitations! Learn about Headless Chrome - an awesome service that allows your web viewer to work with older versions of Internet Explorer! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

It's another Dead Bird Q&A with Richard Carlton! If you want some free sample files, or you're curious to see if someone has the same questions as you do, give it a watch! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Richard discusses the latest and greatest happenings of the FileMaker platform! He also fields questions about installation, upgrading, and purchasing! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

You may have seen the earlier blog post about Custom Function Tools for FileMaker Pro. Once we showed this to people, we got a few ideas and one request was to include those buttons for the calculation dialogs in FileMaker in various places: As you see we added a white box for the result and put a place holder text inside. And we had to do code to dynamically look for what controls FileMaker places there and measure their size to place our box between controls on the left and controls on the right. Let us know if we got it wrong in your FileMaker version or language. Check 11.1pr4 to try this feature. Looks like the features work even in lots of older FileMaker …

Today we're covering the PerformScriptWithOptions JavaScript function with Calvin Mosiman. Learn about this new option for calling a FileMaker script from a web viewer! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Did you know that iOS 11 introduced a feature to markup images and PDF documents right into the iOS system software? A client asked for adding annotations to a PDF right on the iPhone or iPad with their custom FileMaker iOS SDK based application. We through first to use our PDFKit or DynaPDF functions. Those can do things like merge or render PDF documents. And DynaPDF has quite a few functions to create annotations via script. Great if you automatically want to do things, like adding clickable links via script. (see older blog posts). But this is all via script and the user wants to annotate manually with his finger (or a pencil). Recreating all the markup tools with …

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…

It's our final day of UI/UX design with Nick Hunter! This extra long session covers Card Style Windows, limiting the role of your layouts, and how to think outside the box with FileMaker! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

When using other development tools, we frequently have a feature to inspect values for variables or fields. Just move the mouse over the variable or field and see what's inside. This is very convenient for debugging a script to quickly see values, especially if all the local variables and object properties don't fit a single variable viewer window. We got an idea for FileMaker. The macOS NSView class allows an application developer to register a function to provide a tooltip on demand. Instead of filling tooltips earlier, you can later decide on the value and generate it on the fly. To implement tooltips, we register for providing tooltips. When you move mouse …

You may have seen Safari, Mail, Notes or other applications highlighting information in some text and they may offer to do something with the data, e.g. take a date and make a new event in your calendar or take an address and add it to your contacts. Have you wondered how this works? Apple provides data detectors in their frameworks to identify those data bits. We just added a new function RegEx.DataDetector to use those in FileMaker. While you can do a lot with regular expressions yourself, these pre-built detectors are convenient to use as they are. Here is our new function: MBS( "RegEx.DataDetector"; CheckingType; Text ) You tell what to look for, either…

We're back with another day of Nick Hunter's UI/UX livestreams! In day 9, Nick discusses the Find functionality in FileMaker, dedicated Find layouts, dealing with Finds in related tables, and much more! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Starship Captain Nick Hunter is back to tell you how to get your UI design federation approved! Learn how to deal with navigating through layouts; the advantages of the hamburger menu; and how to get your design to the next gen...I mean, level! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

It's another day of Nick Hunter's UI/UX tips and tricks! Learn about planning your UI, adding mandatory fields, and simplifying your interface! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

We're back with Day 6 of this FileMaker UI/UX event with Nick Hunter! We hope that with each LiveStream, you get one day closer to achieving your dream interface! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

We were honored to be joined by the most influential person in the FileMaker community, Brad Freitag, Claris' CEO. It was a very open and interesting discussion and Brad shared his vision for FileMaker moving forward as well as part that the developer community have to play in this new, but familiar, sandbox we call home. You won't want to miss listening to this one.

https://firesidefilemaker.podbean.com/e/can-you-hear-me-running-faster/ Our guest today is Nick Lightbody from the UK, who you may not be familiar with but, behind the scenes, Nick has had and continues to have enormous influence on the work we do, because he is intently focused on getting FileMaker to perform better and faster. In Nick's words "Performance is the most underdiscussed subject and yet it is the object of most complaints." In this fascinating discussion, Nick talks about the work he does and its implications, and it will give anybody who listens some really powerful strategies for having your solutions work better and insights on things that w…

Congrats! You made it half way through this FileMaker UI/UX event! On Day 5, Nick teaches how to deal with lists and how to properly give feedback to your users. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

We hope you're all taking notes because Nick is just getting started. Join us on Day 4 of this FileMaker UI/UX event as Nick shows us the power of buttons and how they can help clean up your layouts! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Recently we noticed a new idea on the FileMaker Community, a wish to extend the custom functions dialog with some useful capabilities to execute a custom function or check the syntax. And that's what wish was my puzzle for the weekend to solve. I remembered we had something like this in FileMaker as database: Formatting and error checking expressions in FileMaker, where you can enter a formula, format syntax and check for errors. Let's put that from a script to C++ and do it within the plugin: As you see we got two new buttons for the custom script editor dialog in FileMaker Pro. When you click Check Syntax, we take your expression and build a test expression aroun…

On Day 3 of this FileMaker UI/UX event, Nick continues with the transformation of FMSP. However, this time Nick highlights bad design techniques so that you can avoid these same pitfalls in your solutions. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

One of our clients asked for how to create payment QR-Codes in FileMaker and we just made him a new example for this. You may prepare the data, but then you can use MBS Plugin to create the barcode and put it as picture in a container and print it on your invoice. Or you use DynaPDF to draw it as vector graphics to keep it sharp. Here is the main script with the full calculation to assemble the text for the barcode: # EPC-QR-Code generation # Go to Layout [ “Tabelle” ; Animation: None ] # Sample data for QR-Code. May need adjustment to final standard Set Variable [ $text ; Value: // Service Tag "BCD" & ¶ & // …

Welcome to Day 2 of 10 of Nick's FileMaker UI/UX Event! Nick starts working his magic on FMSP and creates a newer sleeker look. Along the way he'll be demonstrating super valuable tips and techniques. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Introducing a 10 day FileMaker UI/UX event with Nick Hunter. That's right... not one, not two but TEN content packed days that will change how you look at the design of your solutions. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Happy Friday! In this weekly Dead Bird Friday, we have some FREE sample files from one of our viewers! Find the download links in the description. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Calvin joins us to demonstrate how to use JotForm and a REST API to pull data from a public web form and populate records in FileMaker where we can track results! FREE sample file: https://bit.ly/38HYZaj. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Loop has always been an obscure and difficult technique to master and could lead into an unwanted "infinite loop". Nick provides techniques to help you master Loop. FREE sample file: https://bit.ly/3nFEoI3. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

You can never have too many functions up your sleeve! Nick introduces the Choose Function, a super powerful function that could be your savior hundreds of times. FREE sample file: https://bit.ly/3bILSb7. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Although some features in FileMaker aren't great out-of-the-box, they make sure to include all of the tools you need to make your own! Including portal sorting features. Free sample file: https://bit.ly/35w2vmu. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

https://firesidefilemaker.podbean.com/e/walking-in-carltons-shoes/ In this episode, we are visited by the one and only Richard Carlton from RC consulting Inc. Richard Carlton is a long time veteran of the FileMaker Community. With his 28 years of experience, he has built a team of 32 FileMaker developers and supporting staff throughout North America. Richard is best known for his video courses on the FileMaker Platform, developing “FM Starting Point” Business Software (free to everyone). RCC is involved with every facet of the FileMaker platform including: training, development of custom apps, and large scale deployments with organizations. So, needless to say, Rich…

Last Friday of the month so let's make it a good one! Join us in our weekly Dead Bird Friday stream where we give everyone FREE FileMaker Sample Files! Find the download links in the description. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

What do you get when you cross Calvin, Audit Logs and Lean Design? A super informative LiveStream on audit logs that track users without any delay to the user! Sample File links in the description. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Need an extra boost to power through the rest of the week? How about 3 days of Calvin using lean design to create audit logs that track users without any delay to the user! Sample File links in the description. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

In this article I want to introduce you the new functions from the MBS FileMaker Plugin in version 11.0. Drag & Drop Let's start with the functions that are new in the DragDrop component. You can now create a drag drop area over the whole working window. The DragDrop.AttachToWindow function disables FileMaker's drop handler and installs the plugin one to the window. You can also drag things out of a drop zone. To do this, you can use DragDrop.SetFilePathsToDrag to specify a list of paths to where the files should be taken. With DragDrop.SetDragImage you can set an image that should be displayed when this object is dragged. If we do not set an image, we have a…

Get (ScriptParameter) and Script Parameters go hand in hand. A good understanding of these 2 fundamental components is the key to your stargate, to a new world. FREE sample file: https://bit.ly/38nESy3 Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Did you know you can configure the capabilities of the WebViewer in FileMaker using MBS FileMaker Plugin functions? If you take a close look on the WebView.SetPreferences function for MacOS and iOS, you find a couple of options to set. Let's take a look on the most important options and what each option sets: minimumFontSize You may load some HTML into the web viewer, like the content of an email. Since you don't know the font sizes, you can define a minimum font size for the content. For example use 12 point for fonts as minimum: Set Variable [$r; Value: MBS("WebView.SetPreferences"; "web"; "minimumFontSize"; 12) ] javaScriptEnabled If you show an e…

Repeating Fields are relics from the prehistoric era of FileMaker, but they may still have a place in modern solutions. Nick shows us how to use them to save time. FREE sample file: https://bit.ly/2Xf07Mg Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Hi All, I've forgotten my user name and password for my FMP12. Is there any way I can retrieve that info? If not, can I copy all info from my database to another database and start new password? Thanks!

What's better than Friday? How about Dead Bird Friday! Join us in our weekly stream where we give everyone FREE FileMaker Sample Files! Find the download links in the description. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

We've reached the final day of this event on Value Lists but that doesn't mean you have to stop unlocking levels in FileMaker. Keep finding those power-ups! FREE sample file: https://bit.ly/3ri98Su Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Get ready for level 2 as Nick shows you how to use Value Lists in a more comfortable way with Global Fields driving relationships! FREE sample file: https://bit.ly/3ri98Su Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

For MBS FileMaker Plugin we recently added a new DynaPDF.SetPageBreakExpression function. Have you seen it? It allows you to define a page break expression. This calculation is evaluated when a text rectangle is filled with text and we need a new page or a new rectangle on the same page. Look on this sample database with three columns filled over many pages with one big text block: Here is a sample call for DynaPDF.SetPageBreakExpression: As you see this calculation gets called when the text rectangle is filled. It uses a Let statement to compound multiple statements and first increases the CurrentColumn variable. If we have room left, we define a ne…

Player One - ready to unlock a new level of Value Lists?! In this three day event, Nick will show you how to use Value Lists in a more comfortable way with Global Fields driving relationships. FREE sample file: https://bit.ly/3ri98Su Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

The "Self" function is another powerful tool worth adding to your set of skills. After Nick is finished explaining, you'll wonder how you made it so far without it! FREE sample file: https://bit.ly/3gZ3u2S Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

You made it to Day 5! We hope you've picked up a ton of valuable information on the latest iOS design techniques to enhance the UI/UX of your FileMaker Go app. FREE sample file: https://bit.ly/3abgcKB Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

As you may know we have a great Optimize command for DynaPDF. You can use it on PDF documents in both FileMaker and Xojo plugins. Over time the command got more and more powerful and we like to write here about some of the features. In general the function rebuilds the content stream of all pages, templates, patterns, annotations, and form fields. This may remove errors in the content stream and produce a consistent document. When you specify the flags, the default flag value (0) just rebuilds the content stream and fixes errors. You may specify "InMemory" to have changes made in a way, that the PDF is in memory and not flushed to the current output. Normally y…

What could possibly be better than 3 days of a FileMaker Go UI/UX event? How about 4 days of Nick covering the latest iOS design techniques! FREE sample file: https://bit.ly/3abgcKB Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

The show must go on! On Day 3 Nick continues to cover the latest iOS design techniques to enhance the UI/UX of your FileMaker Go application. FREE sample file: https://bit.ly/3abgcKB Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

https://firesidefilemaker.podbean.com/e/punishing-performance/ In this PodCast, we highlight yet another hero in the FileMaker market, Wim Decorte of Soliant Consulting. As long as there has been FileMaker, it seems like Wim has been there helping people on the message boards, writing white papers and presenting at Claris DevCon/Engage. He even created an open source FileMaker product, called the Punisher, aimed at testing a FileMaker solution over the network. We’ll discuss the Punisher and where you can get it, as well as optimizing performance on FileMaker Server, FileMaker Pro and FileMaker Go. Specific subjects include FileMaker Server logs, Linux, AWS, backups,…

This FileMaker Go UI/UX event was so good, it needed 5 days! On Day 2 Nick will continue to cover guidelines and principles from the latest iOS design techniques. FREE sample file: https://bit.ly/3abgcKB Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

What better way to start a new year than with a 5 day FileMaker Go UI/UX event! Nick will go over guidelines and principles from the latest iOS design techniques. FREE sample file: https://bit.ly/3abgcKB Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

360Works' Sam Barnum joins us to talk about fmPromise, a product that provides a richer JavaScript Web Viewer Integration! Find this FileMaker Product and more at 360Works.com. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

GetContainerAttribute is a great way to learn more about the data inside your containers. Nick shares a FREE sample file (https://bit.ly/34AOTpB) to help guide us through this powerful function. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

New to the FileMaker Platform but overwhelmed by some of the more advanced topics? This Open Q&A LiveStream for new FileMaker Developers may help point you in the right direction! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

If your New Year's resolution is to learn a new script step, we have the perfect LiveStream for you! Nick Hunter is here to discuss Set Field by Name. FREE sample file: https://bit.ly/2JCapmr. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Don't let those pesky errors get away from you! Learn how to manage Error Capture in scripts and what to watch out for with Nick Hunter. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Hi, I want to create a preferably automatically-updated table (Monthly Sales Report) that tallies the daily sales qtys for multiple items - see PDF attached. PM = Past Month totals; Tot = total of the individual columns ie Single, King Single, Long Single, Double, Queen, King. If not an automatic solution, could I create a looped routine to generate data for each item one by one and then populate a page in another layout (copy & paste routine)? I also considered creating sub-summaries and sorting by date, but I couldn't see how to create an elegant summary such as the attached PDF with zero days included. FM data is drawn from MYOB and stored in multipl…

Do you need to separate a block of text into individual fields? You cold use the Position function and a combination of left, middle and right functions or you could use the KISS method. https://youtu.be/n32QR6VqXjc Check out www.filemakercommunitycollege.com for more tutorials.

A long term project came to delivery just before Christmas 2020: DynaPDF got a new feature to convert texts to outlines. And it's just a new flag for the Optimize function: ConvTextToOutlines. The benefit of this conversion is that you can send the PDF to a printer shop and be sure that it will look exactly as you need. No font trouble, no missing fonts and no font rendering issues. Please note that the process is not reversible. Once the text is converted, the text is gone. Just the look of the text stays, so you need OCR to convert it back to text. Copy & Paste is not possible for outlines, but for some uses this may be desired. To show you what…

Getting your Found Set to contain what you need is a super useful skill to have. Nick Hunter is here to demonstrate the power of the Constrain and Extend script steps as well as some of their limitations. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

RCC's Junior Developers are back and this time they're sharing their experiences on building a Mechanic Inspection Form! They're also sharing the Inspection Form File FREE and UNLOCKED: https://bit.ly/3fUxYm6 Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Hi All, I'd like to use fmp 14 databases on my off-line computer only using local host and a browser. Is this possible without using FMP 14 server? Thanks!

Stay safe these holidays in these most difficult of times. We'll be back in the New Year with a fascinating conversation that we're sure you will enjoy.

Still have a lot of Holiday shopping to do? How about some FREE sample files from our weekly Dead Bird Friday event! Find the download links in the description. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

RCC's Junior Developers built their own Vehicle Manifest and are here to share what they learned along the way! They're also sharing their Vehicle Manifest File FREE and UNLOCKED: https://bit.ly/39bU8io Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

As a developer, it can be difficult to deal with text issued from JSON, Javascript or external APIs. Knowing how to use LeftValues, RightValues, and MiddleValues will save you hours of work and a lot of headaches. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Working on a complex Layout with a large amount of layout objects may require a large amount of skill. Not to worry, Nick Hunter is here to share the skills to manipulate those objects without any troubles. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com