Community Videos, Tips, & Techniques, Articles.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

The SQL Distinct command can be pretty powerful. There is a way to get this same powerful result natively within FileMaker! [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

We got a new example database for MBS FileMaker Plugin to show how to merge PDFs. One of the feature beside adding page numbers is to build a table of contents for the document with clickable entries: Set Variable [ $pdf ; Value: MBS("DynaPDF.New") ] # # create dummy page for table Set Variable [ $r ; Value: MBS("DynaPDF.AppendPage"; $pdf) ] Set Variable [ $r ; Value: MBS("DynaPDF.EndPage"; $pdf) ] # # create table for index Set Variable [ $r ; Value: MBS("DynaPDF.SetPageCoords"; $pdf; "TopDown") ] Set Variable [ $table ; Value: MBS("DynaPDF.Table.Create"; $pdf; 10; 2; 500; 20) ] # Set Variable [ $r ; Value: MB…

Learn to make highly efficient FileMaker custom apps that perform well on FileMaker Server or FileMaker Cloud by utilizing "lean design". In part nine of this course, we explore how fast the List function is and how much it can speed things along. To watch the rest of the Lean Design Course and download the free sample files that go with it, visit: https://fmtraining.tv/marketplace/lean-design.html [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Please help with this one, I want to copy or set field from another summary field.how to do this for each individual record.

Hi All! I have a script importing currency into Filemaker. Today I do as follow: 1. Startet the script which open an URL to my bank currency webpage. 2. I have manually open Excel file: C:\EXCEL kalkyler\0 Valuta 1.xlsx 3. I go to the open webpage and CTRL+A and CTRL+C 4. I go to the open Excel and past CTRL+V 5. Then the script continue import the Excel page into Filemaker. 6. Ready to use the new currency in my Filemaker apps. Question: Is it any possibility to let Filemaker open Excel automaticly or by a plugin or? Thankss in advance -Per

There are many ways to delete records in FileMaker. Some methods may be faster than others. Let's find the best process for your workflow. [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Inexperienced developers often program FileMaker in a particular way because they saw someone else on a video, blog or other resource perform the same series of steps. It even happens because the developer simply follows the client’s request. There isn’t one set of programming for generalized solutions. It’s up to you as a developer to think about the best way to solve a programming problem with all the tools at your disposal. In this podcast, we examine the pros and cons of Quickbooks integration, calendars, web enabling, the data separation model, live development, main menus, dashboards, reporting, progress bars, building solutions from scratch as opposed to using a st…

Today a client asked how to automate login to the admin console when it is open in a web viewer within a FileMaker solution. You probably saw the video Automate web viewer already? The login here is a bit more difficult as you need a couple of JavaScript calls to login, but here is a script that works for us: As you see we define an utility function in JavaScript to trigger an event programmatically. This is required as the login form has event listeners in JavaScript which validate the fields and we need those to enable the Sign In button for us. we do the following steps for each field. We query the field by its ID, set the focus, enter the text and trigger i…

Are you tired of working for somebody else? Do you want to make a 6-figure income rather than a 5? More importantly, do you want to control your own destiny; working the hours you want to? This short video describes the skills you need to master in order to become successful as an independent developer, no matter what your field or profession but is it for you? It's definitely not for everyone but if you're willing to take the risks in order to get all the rewards, you've come to the right place. https://youtu.be/V2rVUr6rn34 The video is a free introduction to an online course. For more information go to https://nautilusfm.com/course There are …

People who are new to the database world and/or those who come from platforms, i.e., spreadsheets, that don't support normalized data, often get themselves confused as to what normalization is and why it is needed. In this short video we answer those questions and take you through a step-by-step process to normalize your data. https://youtu.be/4Ae6lqqfuHY (While this video covers a subject that all experienced FileMaker developers will know inside-out and is thus intended for beginners and some intermediates, it may be useful to show customers who wonder exactly how much work is involved).

here is a popover tweaked a bit to have a tray effect popover-tray.zip

RCC’s engineers have put together another amazing kit for you to utilize - the Video Library Publication Kit. This kit allows you to use a FileMaker database to control a video library web page. Totally Free... requires FileMaker Server (17 or 18) or Cloud 17 or 18. Download and find more information at: https://fmstartingpoint.com/marketplace/video-library/index.html [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

code Let ( o = "portalA" ; "objectType:" & GetLayoutObjectAttribute(o; "objectType") &" | ¶" & "hasFocus:" & GetLayoutObjectAttribute(o; "hasFocus") &" | ¶" & "containsFocus:" & GetLayoutObjectAttribute(o; "containsFocus") &" | ¶" & "isFrontPanel:" & GetLayoutObjectAttribute(o; "isFrontPanel") &" | ¶" & "isActive:" & GetLayoutObjectAttribute(o; "isActive") &" | ¶" & "isObjectHidden:" & GetLayoutObjectAttribute(o; "isObjectHidden") &" | ¶" & "bounds:" & GetLayoutObjectAttribute(o; "bounds") &" | ¶" & "left:" & GetLayoutObjectAttribute(o; "left") &" | ¶" & "right:…

In the newest version of the MBS FileMaker Plugin 10.0 we offer functions for the use of JavaScript without the use of a web viewer. See WebView.RunJavaScript and WebView.Evaluate to run or evaluate JavaScript in a web viewer. The new JavaScript functions increase your functionality in FileMaker enormously. You can write your own Javascript, use a JavaScript snipped that fix a problem or fast up a process of your solution. In this article I want to show you how to use JavaScript code in FileMaker: Setting values in the JavaScript with functions in FileMaker, add functions and run them. If you have a problem that you want to solve, you don't have to reinvent the whee…

Supercharge your FileMaker searches with this incredibly powerful but simple technique.

RCC now offers FileMaker coaching and development in Spanish! Send an email to [email protected] to get started today. RCC ahora ofrece coaching y desarrollo de FileMaker en español! Email [email protected] para empezar hoy. www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

I have a large DB of over 400k records. I have a found set of records I want to delete - only 500 records. When I click 'delete' the db churns away for about 20 minutes and eventually deletes 40k records - that's to say all other records which match one field in the found set - this is a big problem. Is it a bug - what's going on?

Modularization, generally, refers to scripting where you take a section, or sections, of one script and create a sub-script from that which is subsequently called (or invoked) from the original script. There are lots of reasons, and some significant benefits, as to why you might want to do this but there are also a number of gotchas and reasons why you might not want to. In this podcast we discuss the pros and cons of modularization so that you can make your own decisions as to whether it is right for you or for the solution you are working on. https://firesidefilemaker.podbean.com/e/should-you-modularize/

In the last weeks a few people asked about automating web viewer in FileMaker, so here a video to show a couple of features in MBS FileMaker Plugin: To automate a website, you may first want to inspect it. For that you can use our Form Utility application to show which form fields are available. The application suggests which commands to use to query or set fields. Then you can use WebView.SetFormButtonValue, WebView.SetFormInputChecked, WebView.SetFormInputValue, WebView.SetFormSelectValue, WebView.SetFormTextAreaValue and WebView.SetFormValue to change form fields. For MacOS and iOS in FileMaker 16 or newer you can use WebView.SetPreferences function to set pr…

Recently a client asked how to leverage JavaScript in FileMaker to do a specific calculation. For this blog post we replace the client's function with a CRC function to show you how to do it. Up until a few weeks ago we would have pointed to loading JavaScript in a web viewer and using WebView.RunJavaScript to run the JavaScript. But now we would point to WebView.Evaluate and just run it. See the example script in our documentation for this CRC function. With MBS FileMaker Plugin in version 10.0 we got our own JavaScript functions using the DukTape engine. We have an example in the documentation to run the CRC function right in a Let command and the JS.Evaluate …

One version with shadows and one without. In the off state, note the background of the switch is black with an opacity of 8%, so it adapts to the layout color. iOS toggle.zip

As you may know the FileMaker Server Data API does not load plugins. If you need to run a script using plugins, you need to use a little trick. You query the application version of the script engine running the script. If you get back "FileMaker Data API Engine 18.0.1", you know the script is run via Data API. Now you can branch to the same script on the server scripting engine. That is a different process on the FileMaker Server which does load plugins. Then you return the result back to the calling script. Let us show you an example script: If [ Position ( Get(ApplicationVersion) ; "Data API" ; 1 ; 1 ) > 1 ] # forward call to Server Scripting Engine Perf…

We recently got a query how to create the scripts to handle barcode creation everywhere with MBS Plugin. This includes passing the request to a FileMaker Server if no local plugin is installed: in FileMaker Pro with MBS Plugin to create barcode locally. in FileMaker Pro or Go without MBS Plugin and using the plugin installed on server in a scheduled script on FileMaker Server with MBS Plugin installed in WebDirect on FileMaker Server in FileMaker Data API on FileMaker Server, where we need to trigger script in server side scripting engine. in FileMaker iOS SDK with either local plugin or server side plugin The following script r…