Community Videos, Tips, & Techniques, Articles.

In this livestream, we discuss our Wolfpack update! New add-ons, which include how to create a virtual list that updates in real time, how to stage data before it's committed to your database, and more. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

In this livestream, Kyle Williams covered how to best create and format your ExecuteSQL queries in a way that they will be easy to understand and work with! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Day 3 of Nick Hunter's guide to solving difficult scenarios in FileMaker with creative problem solving. This livestream, breaks down the finer details of his scheduling solution. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

In this Livestream, we continue our talk about FileMaker not having a 'function' for every scenario. Nick shows us how to solve these problems, including speeding up solutions, transforming records and more! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

We discuss the Execute DAPI script step in FileMaker. This livestream also showcases a demo file that breaks down the script step by step! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

FileMaker can solve many problems, but sometimes it doesn't have a direct solution! In this livestream, Nick Hunter shows unique ways to get around problems in FileMaker with a scheduling app. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Christian Schmitz returns to discuss Monkeybread and the 19.4 update, as well as showing off an awesome new auto-complete feature for variables in calculations! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Build a Save, Edit, and Cancel records feature the super easy way! In this livestream, one of our senior engineers shows how to implement these features using lean design! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

For a couple of years we do various things in FileMaker Script Workspace like syntax coloring. We got a copy command once we started to read all lines in a script. Later we added checks to find usage of undeclared variables, so you easier spot typos in your variable names. Now we go one step further: We scan for variables and present you a list of names we know. When you have a script open in the Script Workspace and you open a calculation dialog, you can now auto complete. Just go into a calculation dialog for a Set Variable or Set Field or any of the other script steps taking a calculation. Then type something. We have a switch there, so only when you type a $ symbol…

If you like to see the IDs for your value lists and later reference them in your scripts, check out the new option in the upcoming MBS FileMaker Plugin in version 11.6pr2 or newer: If enabled in preferences dialog or via SyntaxColoring.SetShowValueListIDs function, the MBS FileMaker Plugin will query FileMaker's ValueListNames and ValueListIDs functions to assemble the lists and show right in the table the ID. You can use FM.ValueListIDForValueListName and FM.ValueListNameForValueListID later in scripts to pick the name of a value list by ID or otherwise. Or just do the same via custom functions if you prefer that. We'll provide 11.6pr2 next week, so keep checkin…

FileMaker 19.4 has come out and it has WAY more changes than we anticipated. In this livestream, we talk about it! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Our last stream on ransomware and how to protect your FileMaker databases. Heidi returns to discuss unique and clever ways you can hide your FileMaker Server from possible attacks. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

In this livestream, we continue to discuss how to protect yourself from Ransomware. Our presenters show off how ransomware works with a simulation software called Racketeer, and how to use it to improve your own security. https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

In this article we want to introduce you the new functions from the MBS FileMaker Plugin in version 11.5. Text Let's start with the two functions that are new in the Text functions. With the function Text.Concat we create a text that writes all texts specified in the parameters one after the other. No space is set between the individual texts. Let's have a look at the sample. We have entered the words banana, orange and pineapple in the parameters of this function. Set Variable [ $Concat ; Value: MBS("Text.Concat"; "Banana"; "Orange"; "Pineapple") ] In the dialog box we see the text we get back. The second new function is Text.List. It too w…

Ransomware is malware that employs encryption to hold a victim's information at ransom. We discuss ransomware and how you can improve protection on your FileMaker databases. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Claris had a presentation on the future of the FileMaker Platform. Richard and two of RCC's senior engineers recap and discuss. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Wouldn't it be cool if you could always see your portal totals immediately below the last used portal row, instead of having them at the bottom of the portal? www.nautilusfm.com/portaltotals

I goofed - please delete I have posted elsewhere Hey All -- I have a search script that is working - yipee - it finds invoices within a date range and displays them I want to add an additional parameter that only displays the records found that also match what the user selects from a Picklist ie. Web Orders, Catalog Orders, Phone Orders Basically, FIND all invoices in a Date Range that were Phone Orders I can't seem for the life of me to make the additional parameter work. Does anyone have a direction they can point me in? I've attached what is working, I've removed all of the code that I can't make work - any help is greatly welcome

In this livestream, Richard and Jacob discuss Azure and setting up OAuth and easy password management for your FileMaker users. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

More FileMaker server questions with Jacob. We cover preferences and file options in FileMaker, best PSOS practices, explaining database folders and folder paths, and more! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Did you know that you can extract and analyze images from a PDF file with DynaPDF? For this you can use the function DynaPDF.GetImage. In the parameters you can specify which information you want to get for an image. You can choose between the following values: BufSize The size of the image buffer in bytes. BufSize The size of the image buffer in bytes. Buffer The image data as JPEG or FILE. Picture The image as a picture container. Either JPEG or TIFF. Filter The format of image: Required decode filter if the image…

Users often need to select an item from a large list. In such case it may be convenient to make the selection process hierarchical - for example, select a category first, then a subcategory in the selected category and finally an item in the selected subcategory. A popular solution is the use of conditional value lists. However, this requires adding relationships and table occurrences to the relationships graph in order to "filter" the value lists. Plus fields to hold the intermediate selections - fields that are otherwise not required, since only the final selection matters. Plus the value lists themselves. Here is an alternative method using a card window to …

XML External Entity Vulnerability in Claris FileMaker 49 minute read A couple of months ago I looked more deeply into the “Import Records” functionality in FileMaker, especially the XML parsing, and was wondering if any XXE vulnerability may exist and how one could exploit this in technically interesting ways. The vulnerability is/was indeed there and can lead to local file disclosure and server side request forgery in various components of the FileMaker platform. The following is a description of the vulnerability including potential exploitation paths. If you’re running FileMaker Server, make sure to install patch 19.4.1 to mitigate thi…

Not sure how to catch every last mistake you make when building your layouts? MrWatson shows us how to use fmCheckMate + the fmCheckMate-XSLT library to analyze layouts instantly and thoroughly. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Richard discusses the FileMaker certification test. The focus is on possible OAuth and ODBC questions and we skim over Claris' online study guide. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

In this livestream we show off two fantastic games made with Javascript in FileMaker, and then the same techniques are used to increase script execution speed! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

It is another Monkeybread Q&A! Christian Schmitz takes on questions about his plugin and shows off a fantastic new feature! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

MrWatson returns to discuss how to use fmCheckMate-XSLT. Some topics covered include how to analyse your code, get a list of fields, get a list of script calls, and list all fields referenced in a layout! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

For Day 3 of the UI/UX in depth livestreams, Nick Hunter returns to discuss value lists and their UI in detail. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

In this livestream, Claus Lavendt revists explaining SSL and the process of installing a custom SSL certificate on FMS, the basics and not least best practice. He also showed off a new hidden feature. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

https://youtu.be/imA92obcVwc Bill returns for Day 3 of his credit cards and FileMaker series. In this Livestream we discuss FileMaker Go and Webdirect. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Day 2 of MrWatson showing us his toolbox. We converted FileMaker code to/from fmxml, changed code with search and replace, and deployed patched code to another machine. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

MrWatson introduces us to his free toolbox for FileMaker developers. On Day 1 we took a close look at fmSyntaxColorizer to see how it - with the help of the MBS-Plugin - can help find bugs in your variables, highlight code smells and generally brighten up your code. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Nowadays we live in a connected world, so web services run on different computers and sometimes need to notify each other. They usually do that with sending a HTTP request to a given URL and pass on some data as part of the URL or e.g. a JSON block as payload. FileMaker has no built-in web hook feature and with FileMaker Server you can do some things with DATA API or a custom php script on the web server part. Our MBS FileMaker Plugin in version 11.5 comes with a new WebHook functionality. You can open a receiver to listen on a port for an incoming request and trigger a script to process the query. Our plugin provides maximum flexibility as you can create listeners as…

For MBS FileMaker Plugin version 11.5 we got a few new improvements for the syntax coloring. First, SyntaxColoring.AddTag can now do formula tags with wild cards. Just define a tag with stars on beginning and end to get that color rule applied on the end over all other rules: MBS( "SyntaxColoring.AddTag"; "formula"; "*deprecated*"; "red" ) This rule would mark everything with deprecated in a formula text with red color. Great if you have fields you want to get rid off. Rename the field to have deprecated in the name and then walk your way through calculations to easily spot the field name. We got a new way to color comments in calculations. When we detect a co…

Let's discuss what the main requirements of PCI compliance are as they pertain to small businesses. Let's also chat about what must be done to ensure PCI compliance within FileMaker, as well as other technologies and platforms. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

What is the actual cost of FileMaker solutions? In this livestream we discuss licensing costs, time investment, hiring developers, and the actual price of 'FREE'. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

This livestream is the beginning of a new UI/UX deep dive with Nick Hunter. In this one we discuss the ins and outs of building an item picker. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Calvin and Richard discuss their experiences at the Pause on Error conference. They briefly discuss lambda, third-party addon sites like PentagonFM, and more! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

A client got a bit xml file from Swiss government with a list of all registered/permitted medications. A huge XML file with thousands of entries. In order to import those easily, we use our XML.Import function in MBS FileMaker Plugin. We copied the XML Import example database included with our plugin to desktop. We copied the xml file to desktop and renamed it test.xml. Then we open the database and run the script. Since we didn't change it, it will simply look for a file named test.xml and import it. Since the XML file is 50 MB, this takes a while, but the XML.Import function creates 18 new tables with a lot of fields: The example has "Import2" as prefix for r…

Day 2 of Nick's UI-UX in-depth livestream. Nick continues to show you how to vastly improve FileMaker's out of the box UI for item pickers. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

This livestream is the beginning of a new UI/UX deep dive with Nick Hunter. In this one we discuss the ins and outs of building an item picker. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Hi everyone, I want to use a webviewer to play mp3 and mp4 files but I can't manage to construct the right path to the external drive where those files are stored. I have hundreds of records each with its own mp3 or mp4, so I guess the way to access the right mp3 or mp4 from the right record would be to use the ConvertFromFileMakerPath function in the webviewer calculation. Amongst other things, I've tried this calculation: ConvertFromFileMakerPath ( "filewin:/G:/VIDEOS/"; URLPath ), but it's obviously the right approach. And frankly I'm lost as to how to construct the right path. Could anyone help? Thanks.

Day 10, CEO Kevin Miller and LiveCode's product manager, Ali, answer a variety of questions on licensing, syncing, and a host of other topics! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Day 9 of our LiveCode for FM training series. In this Livestream, we had two customers give testimonials/use cases, and Kevin Miller discussed the future of LiveCode, including a Windows and Web runtime. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Day 8 of LiveCode for FM, we discuss runtimes, specifically how LCFM allows you to create runtime applications for your Mac! We also discuss the Mac App Store and differences between desktop and mobile runtimes. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Day 7 of our LCFM livestreams. In this one, we discuss the advantages of LiveCode for FM vs FileMaker Go and the FileMaker iOS App SDK. We also chat about deployment profiles and the Apple App Store. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Day 6 of our LiveCode Livestreams, we share the public link to our submitted/posted App and discuss app maintenance, how to roll out updates and talk about data retention. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

On Day 5 of our LiveCode livestreams, we discuss the Google Marketplace, how to sign up, what software you might need to install, Google submission rules and possible problems as well as any other hangups! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Day 4 of our LiveCode series. In this livestream, we focus on the ins and outs of syncing and discuss other sync options, as well as testing vs deploying. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

On day 3, we begin compiling our LiveCode and begin testing to make sure it all went smoothly! We will also discuss how to prep your development machine to use LiveCode. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Day 2 of our LiveCode livestreams. Myles builds the app in FileMaker, we install LCFM native and discuss sync support from a bird's eye level, as well as feature support. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

In this livestream, Kyle reviews a submitted demo covering how to close card windows by clicking outside of the window, and also shows his own demo, which discusses utilizing the webviewer for Layout Navigation. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Kyle returns with an improved demo file to discuss some of the more intricate ins and outs of checkboxes and radio buttons in FileMaker. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

In this livestream we discuss optimizing your calculations, specifically tab objects, for scalability and performance. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Supercharging your searches. • Tutorial video • Example files • Step-by-step guide https://www.nautilusfm.com/hilite

Day two of our in-depth dive into Value Lists. In this stream, Nick discusses the limitations of value lists and its related objects in FileMaker. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

We begin our 4-day series of livestreams on Value Lists. Nick covers the very basics of value lists for beginners, as well as showing off some tricks that even advanced developers forget about. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Let's discuss the fundamental basics of Value Lists and how they relate to checkboxes and radio buttons. We will also focus on the auto-enter of value lists and binary searches. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

In this livestream we discuss how FileMaker can send a command for a cash drawer to pop open. We also have a more in-depth discussion around API integration. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

View File OAuth OIDC Authentication For The FileMaker Platform The FileMaker Platform works with a number of OAuth OIDC Identity Providers and Brokers. This chart reflects that. Also the White Papers in this section discuss the details of this. These papers were co-authored with Wim Decorte. Submitter Steven H. Blackwell Submitted 09/23/2021 Category White Papers FM Version 16  

Day 3 of our Audit Series. We cover digital document management - internal vs. external and basic storage vs. interactive. We also talk about API stability and liability. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Day 2 of our audit series. This time we look at structural issues like relational diagrams, organization, TO's, scripts and layouts. We also review UI for usability. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

This is the beginning of our five-day set of livestreams covering auditing. In Day 1, we look at politics of your audit and documentation of customer concerns. We also review basic file structure, health, and indicators. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Claris, continuing the Claris Engage Beyond webinars, hosted an Executive Q&A with Brad Freitag and Peter Nelson. In this livestream Richard, Nick, and Jacob discuss their thoughts on the questions and answers. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

In this livestream, we discuss Primary and Foreign keys for beginners. We cover common mistakes, UUIDs vs Serial IDs, creating relationships with those keys and Cartesian joins. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

In this livestream we finally finish our discussion about dynamically programable data fields! Nick wraps up with the last of his tips and tricks and does a recap of everything we've learned so far. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

I just wondered if you might be interested - A platform independant, basic approach to barcodes not involving plugins or fonts. Great for printing product id labels. However, barcode length is limited to 64 characters because of FileMaker's ability to display only 1000 repeats.

https://www.meetup.com/filemaker-mastermind-group/events/280630795/

This video walks you through every single step to normalize one field in a set of data and was presented during a recent workshop given by the FileMaker Mastermind Group, for beginner to intermediate FileMaker developers. Join us and see what we've got coming up! https://www.meetup.com/filemaker-mastermind-group/

We continue our conversation about dynamically programmable data fields. This time Nick discusses how to avoid creating too many fields through his technique of 'virtual fields'. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

We're back in this Livestream to discuss Window PDFs previews in FileMaker. Calvin gives a thorough overview with a FREE sample file. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

This Livestream is another Open Q&A with Jacob, Nick, and Richard. They answer questions about portals, dynamic values, FileMaker Server and the limitations of FileMaker's engine, DRACO. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

This Livestream is an Open Q&A with Christian, CEO of MonkeyBread Software. He covers extracting text from PDFs/Images, how to use regular expressions, taking screenshots inside of FileMaker, hidden features, and more! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

We're back to discuss dynamically programmable data fields with Nick Hunter and dive deeper into the free sample file that Nick is using to show his techniques. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

In this Livestream, Nick returns to discuss dynamically programmable data fields in FileMaker. We cover a variety of topics, including using records as fields, attaching value lists to pop up menus, and more! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Kyle takes us through his C3 Charting file, showing how you can adjust and customize the data, as well as how to install it into your own database. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Sometimes you need to print a document quickly that's NOT A4 or 8.5 x 11 inches. In this livestream we discuss how you can get FileMaker to do that for you, and what sort of hardware you need. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Claris Engage Beyond 2021 kicked off their first webinar and covered the future of the FileMaker platform. In this Livestream, Richard and a few RCC senior engineers discuss their thoughts and impressions of the webinar. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Nick discusses some of his tips and tricks to making your life as a FileMaker developer easier. His focus in this stream is mostly on how to best utilize "Groups" with your layout items! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

I have a process where I am storing aggregated data in to a table. Which consists of the following data points: date | staff | data | value This process will create two records per day for each staff person for the two types of data. The value is Get(FoundCount) after a find request in a Quotes table for the day / staff and a few other criteria including an omit. I store this in a $quotes variable. Then I perform a constrain on this founds set to get another Get(FoundCount) which is $approved quotes. The process then creates a record in the data warehouse. date | staff | data | value 8/28 | Jim | quote | 32 8/28 | Jim | approved | 3 …

Deleting records in FileMaker can make you anxious, especially when using Perform Find and Delete Record/Request script steps together. In this Livestream, Nick shows off his tricks to make the process less stressful. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

One of our engineers, Jon, shares and demos a sample file in which he integrates Dropbox with FileMaker. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

In this Livestream we show you how you can display the first page thumbnail of a PDF stored in a FileMaker container field on Windows. No more interactive containers needed! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Let's discuss the new Script execution options that were released in FileMaker 19. These allow you to control when a script is fired - ie: by interrupting or by waiting for current scripts to finish, or something else. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

In this Livestream we continue our Beginner to Intermediate overview of FileMaker Security. This discussion has a special emphasis on extended privileges and how they're helpful. https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

This livestream is a Beginner to Intermediate Overview of FileMaker security. In Day 1 we look at what a FileMaker Account actually is and discover some good practices for passwords and security. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

In this livestream, Kyle discusses how to export your FileMaker solutions as code. We also discuss updating code for different tables in minutes, saving you weeks of time. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Kristian Olsen, with the help of the Monkeybread Plug-in, has crafted some efficient hacks to speed up some processes in FileMaker. In this livestream he'll break down the 'Wolf's Toolbox' and show us how he made them. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Join Jacob Taylor as he discusses PowerShell on Windows. It allows for pretty unlimited control and programming of a Windows Server, allowing you to redirect to alternate locations, upload to Amazon S3, and more. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Ever wanted Emojis in FileMaker? With this wonderful add-on from Calvin, now you can! Join us as Calvin breaks down how to use it and how he made it! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

It’s another FileMaker open Q&A! This time, Jacob’s here, answering questions about server backups, updates, and the certification test. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Our FileMaker add-on pack, Wolfpack, has just been updated to version 6. In this Livestream the engineers that created the add-ons cover what improvements have been made and what new add-ons have been integrated into the collection. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

https://youtu.be/vyG6_IVYJSE In this Livestream one of our engineers shows off a FREE demo file that covers how to integrate Paypal with your .fmp12 file! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

We discuss the latest updates we've made to our calendar kit. We also discuss tips for integrating calendar functions into your solutions. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com