<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by The Support Group on Medium]]></title>
        <description><![CDATA[Stories by The Support Group on Medium]]></description>
        <link>https://medium.com/@thesupportgroup?source=rss-86a1bb368a5c------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*j5pZSB9nbOxhd_yriJO0ig.png</url>
            <title>Stories by The Support Group on Medium</title>
            <link>https://medium.com/@thesupportgroup?source=rss-86a1bb368a5c------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Thu, 19 Nov 2026 07:49:32 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@thesupportgroup/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[How to Export from FileMaker to Excel]]></title>
            <link>https://thesupportgroup.medium.com/how-to-export-from-filemaker-to-excel-932f6cfe7205?source=rss-86a1bb368a5c------2</link>
            <guid isPermaLink="false">https://medium.com/p/932f6cfe7205</guid>
            <category><![CDATA[app-development]]></category>
            <category><![CDATA[mobile-application]]></category>
            <category><![CDATA[filemaker]]></category>
            <category><![CDATA[custom-software]]></category>
            <category><![CDATA[software-development]]></category>
            <dc:creator><![CDATA[The Support Group]]></dc:creator>
            <pubDate>Thu, 08 Feb 2024 14:30:18 GMT</pubDate>
            <atom:updated>2024-02-09T15:47:27.246Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="How To Export From FileMaker to Excel" src="https://cdn-images-1.medium.com/max/1024/1*paUIMzr4hQxXXal5e9Kpwg.jpeg" /></figure><p>One common request we often receive as FileMaker developers is to give users the ability to export the data out of the FileMaker app into Excel. While FileMaker provides the ability to do this quite easily with the tools built into the app, users often want more flexibility and customization when it comes to the formatting of the exported Excel sheet.</p><p>There are a variety of options that are available here — plugins exist to make this possible, and we have a <a href="https://blog.supportgroup.com/export-custom-headers-from-filemaker-to-excel?utm_source=BlogPost-2024-02-08&amp;utm_medium=Medium&amp;utm_campaign=traffic">blog post</a> that outlines a routine way to export custom headers from FileMaker using XSLT sheets. But we can also export data from FileMaker to Excel with the power of JavaScript.</p><h3><strong>HOW DOES THIS WORK</strong></h3><p>The general idea behind this is to use a JavaScript library that we’ve embedded into the solution to export an Excel sheet. We take some standard FileMaker data, convert it to a JSON array, and then run it through the JavaScript library to export to Excel. Our <a href="https://blog.supportgroup.com/hubfs/FileMaker_to_Excel/FMtoExcel_v2.fmp12">sample file</a> is completely unlocked, so feel free to look under the hood, as it were, and see how we did it.</p><h3>HOW TO USE FMTOEXCEL</h3><p>Included with this post is a FileMaker sample file called <a href="https://blog.supportgroup.com/hubfs/FileMaker_to_Excel/FMtoExcel_v2.fmp12">FMtoExcel.</a> The purpose of this application is to allow users to:</p><ul><li>Specify custom header labels for all fields on a layout</li><li>Adjust the order of the export at will</li><li>Add a custom header row above the column headers</li><li>Add trailing summaries to each column</li></ul><p>And we want to do this without adjusting any scripts or layout objects. To see how this works, download the <a href="https://blog.supportgroup.com/hubfs/FileMaker_to_Excel/FMtoExcel_v2.fmp12">FMToExcel</a> demo file. It’s pre-populated with an example data set to work with to see how this tool works.</p><p>After downloading the file, open it up. We should be directed to the “DataSet” layout.</p><figure><img alt="FileMaker to Excel 1" src="https://cdn-images-1.medium.com/max/1024/1*GsVUT25dZp9U86cjtmYemA.jpeg" /></figure><p>This is our sample data layout. Notice the layout is in a table view, which is essential for the tool to work. The tool will export any columns visible on this layout to Excel in the order they are displayed. Feel free to re-order the columns, change the found set, or add/remove fields from this table view. Then click on the Export to Excel button.</p><figure><img alt="FileMaker to Excel 2" src="https://cdn-images-1.medium.com/max/1024/1*F8Eh1qm8SHQoK-vRldM1Ng.jpeg" /></figure><p>Clicking the button will take us to a “Spreadsheet Options” <a href="https://blog.supportgroup.com/modular-programming-with-filemaker-card-windows?utm_source=BlogPost-2024-02-08&amp;utm_medium=Medium&amp;utm_campaign=traffic">Card Window</a> with the default set of options, allowing us to specify the spreadsheet name and standard properties. Click the “Use Custom Options” checkbox for more advanced and detailed options.</p><figure><img alt="FileMaker to Excel 3" src="https://cdn-images-1.medium.com/max/1024/1*RkQ-6G4Y4JY0F9f-6ISsuA.png" /></figure><p>The solution will give us various options. The most requested feature here is the ability to change the field names in the headers to a more readable language. For instance, in the screenshot above, we could change “Name_Last” as the column header for Column A to “Last Name,” a much more natural and easier-to-read version of the field name.</p><p>We can also specify additional header lines to go above the column label header row, add trailing summaries to various columns, and store our custom options so that we can restore everything we specify for this table the next time we export.</p><p>Once we have everything set, hit continue at the bottom, and the tool will export our custom file to the downloads folder on our workstation.</p><h3>HOW TO INSTALL FMTOEXCEL</h3><p>All we have to do is:</p><ul><li>Add our table to the FMToExcel file as an external data source</li><li>Create a table view layout with the fields from the table we want to export</li><li>Copy the button “Export to Excel” from the “DataSet” layout to our new layout</li></ul><p>To walk through this, we created a test database using the “Inventory” template that is included with Filemaker. The file reflects one hundred dummy records with random Car Part names and part numbers. Thanks, ChatGPT!</p><figure><img alt="FileMaker to Excel 4" src="https://cdn-images-1.medium.com/max/1024/1*f3DGcPxycDsbRBiNsgvr4Q.jpeg" /></figure><p>In the Relationship graph, we added this file as an external reference to the FMToExcel file. We’ll need to authorize FMToExcel to open our new file when we add it to the relationship graph. Click “Yes” on the dialog box that opens up. It’s similar to this but with your file name.</p><figure><img alt="FileMaker to Excel 5" src="https://cdn-images-1.medium.com/max/258/1*cRri-jF_fKXZ7KsDT8uKLw.jpeg" /></figure><p>Select the table from our solution that we want to be able to access via the tool. We selected the Products table in the sample file. We should now see our table as a table occurrence in the FileMaker relationship graph.</p><figure><img alt="FileMaker to Excel 6" src="https://cdn-images-1.medium.com/max/823/1*j1Xg8f-ANN4Hk9ijMeLsqA.jpeg" /></figure><p>Now let’s create a new layout based on our table occurrence. We enter Layout Mode and select the new table occurrence as the context for that layout. Choose the “Table” view for the data display.</p><figure><img alt="FileMaker to Excel 7" src="https://cdn-images-1.medium.com/max/649/1*a1xTWpX9RgW9G-afowmlpg.jpeg" /></figure><p>Click “Finish,” then add the fields to our table view that we want to be available to export. We’re going to choose the fields in the list view of the Inventory template. Here’s how our table view will look when we’re done.</p><figure><img alt="FileMaker to Excel 8" src="https://cdn-images-1.medium.com/max/1024/1*EZ4f4GsrxJVRYc4_DftSug.jpeg" /></figure><p>We must add the “FM To Excel” button to this layout. Returning to Layout Mode, we’ll edit the Layout Setup options to allow for a header part to be displayed.</p><figure><img alt="FileMaker to Excel 9" src="https://cdn-images-1.medium.com/max/486/1*ySWCRaSQhij1i4xwr3Lc-g.jpeg" /></figure><figure><img alt="FileMaker to Excel 10" src="https://cdn-images-1.medium.com/max/397/1*ImFRLiZMYYRNAXxtHFOLdQ.jpeg" /></figure><p>Staying in Layout Mode, we’ll need to navigate to the DataSet layout to copy the “Export to Excel” button in the header. Then, we’ll navigate back to our new layout and paste the button into the header of our new layout. It should look something like this:</p><figure><img alt="FileMaker to Excel 11" src="https://cdn-images-1.medium.com/max/1024/1*wiime52qTyKc_x7VdYgSjQ.jpeg" /></figure><p>Enter Browse mode, and it should now look like this:</p><figure><img alt="FileMaker to Excel 12" src="https://cdn-images-1.medium.com/max/1009/1*4wnfYRvT_OWPqzSY8xRSoA.jpeg" /></figure><p>When we click the button and select “custom options,” we’ll see the fields on the layout and the arranged order reflected in the tool.</p><figure><img alt="FileMaker to Excel 13" src="https://cdn-images-1.medium.com/max/1024/1*DcgTu8lI0siCM8CCQ7n6pg.jpeg" /></figure><p>And that’s it! Following these steps correctly should open a new window allowing us to export the current layout to Excel. It will also allow us to add new fields to the design — in table view — and those fields will get dynamically added to the export.</p><p><a href="https://blog.supportgroup.com/developer-resources?utm_source=BlogPost-2024-02-08&amp;utm_medium=Medium&amp;utm_campaign=traffic">Check out</a> more FileMaker development tips and tricks, including <a href="https://blog.supportgroup.com/how-to-create-multiple-new-records-in-filemaker?utm_source=BlogPost-2024-02-08&amp;utm_medium=Medium&amp;utm_campaign=traffic">creating multiple new records</a> and <a href="https://blog.supportgroup.com/sorting-columns-in-filemaker?utm_source=BlogPost-2024-02-08&amp;utm_medium=Medium&amp;utm_campaign=traffic">sorting columns in FileMaker</a>.</p><p><em>Originally published at </em><a href="https://blog.supportgroup.com/how-to-export-from-filemaker-to-excel"><em>https://blog.supportgroup.com</em></a><em> on February 8, 2024.</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=932f6cfe7205" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Tips for Improving Software Performance and Scalability]]></title>
            <link>https://thesupportgroup.medium.com/tips-for-improving-software-performance-and-scalability-821d51d24b74?source=rss-86a1bb368a5c------2</link>
            <guid isPermaLink="false">https://medium.com/p/821d51d24b74</guid>
            <category><![CDATA[low-code]]></category>
            <category><![CDATA[filemaker]]></category>
            <category><![CDATA[software-development]]></category>
            <category><![CDATA[custom-software]]></category>
            <category><![CDATA[custom-app-development]]></category>
            <dc:creator><![CDATA[The Support Group]]></dc:creator>
            <pubDate>Wed, 24 Jan 2024 11:48:13 GMT</pubDate>
            <atom:updated>2024-01-25T14:16:53.615Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="Tips for Improving Software Performance and Scalability" src="https://cdn-images-1.medium.com/max/1024/0*XZmKO45BLvcUqWYh" /></figure><p>Is your application in dire need of an update? With operating systems becoming more advanced and offering better app usability, ensuring our software performance and scalability are up to par is more important than ever. So, how exactly can we keep our <a href="https://blog.supportgroup.com/pros-and-cons-of-custom-software?utm_source=BlogPost-2024-01-24&amp;utm_medium=Medium&amp;utm_campaign=lead-gen">custom software</a> relevant? Here are some things to consider when an opportunity to upgrade or enhance our applications presents itself.</p><h3>Use APIs</h3><p>App usability is essential, but so is usability across different interfaces. Imagine how frustrated customers might be if they can only access our software on their smartphones but not on their laptops. A simple answer to this problem is an <a href="https://www.geeksforgeeks.org/what-is-an-api/">application programming interface </a>(API). APIs ensure everything is synced and performance is at the same level across different interfaces. The best APIs should operate seamlessly and provide a quality user experience.</p><p>API capabilities not only extend accessibility across different devices but also allow teams to be agile as new technologies continue to emerge. For example, Generative AI offers many opportunities to enhance our work, whether inspiring new ideas or evaluating code. APIs make it possible for us to incorporate <a href="https://blog.supportgroup.com/integrating-claris-connect-with-chatgpt?utm_source=BlogPost-2024-01-24&amp;utm_medium=Medium&amp;utm_campaign=lead-gen">AI into our workflows</a>. But it’s not just ChatGPT; it’s other third-party applications and cloud services like calendars, email clients, CRMs, geo-coding and routing utilities, etc.</p><h3>Check Performance Regularly</h3><p>Because we’re committed to scalability, we make every effort to avoid technical debt. <a href="https://blog.supportgroup.com/what-to-know-about-technical-debt?utm_source=BlogPost-2024-01-24&amp;utm_medium=Medium&amp;utm_campaign=lead-gen">Technical debt</a> occurs when we use shortcuts or temporary solutions to fix our software rather than making the time to implement a proper and sustainable solution.</p><p>We must also evaluate factors such as the number of users at any given time and processing rates. For example, if our mobile applications aren’t responding promptly based on the current usage and available capacity, the responsiveness will degrade as we increase the workload. We suggest establishing thresholds for adequate processing and reacting accordingly before reaching the limit.</p><h3>Switch to Cloud Hosting</h3><p>Cloud hosting is an excellent solution to free up resources within our internal infrastructure. We can ensure all our applications are built to scale without worrying about running out of capacity. For instance, if we have a <a href="https://blog.supportgroup.com/project-tracking-software-built-with-filemaker?utm_source=BlogPost-2024-01-24&amp;utm_medium=Medium&amp;utm_campaign=lead-gen">project tracking application</a>, we can store the various files and large amounts of data in the cloud so we won’t have to delete or move anything to free up space later.</p><p>Developers can conveniently create custom apps in the cloud with FileMaker Pro and deploy them in virtually a single step via FileMaker Cloud. FileMaker Cloud services provide top-notch security within an easy-to-use interface. It also offers options for creators to manage admin tasks through REST API to streamline and automate their operational and compliance workflows. Furthermore, Claris strategically distributes the applications within their network according to user location to optimize speed and performance.</p><h3>Try Microservices</h3><p>Consider a microservices architecture when the time comes to rebuild the application. The software components are interdependent within a monolithic system, so making changes or updates in one area will affect others. It’s best to break each service into independent manageable parts or microservices that we can easily deploy, modify, or scale as needed.</p><p>Although, there’s no need to reinvent the wheel. APIs can come in handy here. Instead of creating a microservice component, you can connect to an existing service that effectively performs the function. It’s usually faster to integrate a function than it is to build it, so it speeds up development.</p><h3>Evaluate Finances</h3><p>We have to look at our financial stability before scaling up our software. Let’s ensure we have the right amount of money set aside to account for any incremental costs we may encounter.</p><p>The Support Group has been developing all kinds of custom applications for forty years. Our team of experienced and professional certified FileMaker developers would be happy to discuss your needs during a <a href="https://blog.supportgroup.com/the-best-things-in-life-are-free-consultations?utm_source=BlogPost-2024-01-24&amp;utm_medium=Medium&amp;utm_campaign=lead-gen">free initial consultation</a>. From there, we can determine the best course of action: a system audit, development services, or our Sapphire maintenance plan for ad hoc support, etc. We work with you to design a solution to suit your requirements and budget.</p><h3>Optimize Software Performance and Scalability</h3><p>Software performance and scalability are vital when you consider the market competition. With these tips, you can ensure your custom apps are on the same level as your competitors.</p><p>Are you ready to begin your journey into app usability and software scalability for your custom applications? <a href="https://www.supportgroup.com/contact?utm_source=BlogPost-2024-01-24&amp;utm_medium=Medium&amp;utm_campaign=lead-gen#form">Contact us today</a> to schedule a free consultation.</p><p><em>Originally published at </em><a href="https://blog.supportgroup.com/tips-for-improving-software-performance-and-scalability"><em>https://blog.supportgroup.com</em></a><em> on January 24, 2024.</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=821d51d24b74" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[FileMaker 2023: Layout Calculation]]></title>
            <link>https://thesupportgroup.medium.com/filemaker-2023-layout-calculation-38deb365ee2d?source=rss-86a1bb368a5c------2</link>
            <guid isPermaLink="false">https://medium.com/p/38deb365ee2d</guid>
            <category><![CDATA[filemaker]]></category>
            <category><![CDATA[custom-software]]></category>
            <category><![CDATA[citizen-developer]]></category>
            <category><![CDATA[low-code]]></category>
            <category><![CDATA[software-development]]></category>
            <dc:creator><![CDATA[The Support Group]]></dc:creator>
            <pubDate>Tue, 12 Dec 2023 10:41:57 GMT</pubDate>
            <atom:updated>2023-12-12T16:31:20.218Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="FileMaker 2023: Layout Calculation" src="https://cdn-images-1.medium.com/max/1024/1*0tQpnprBDycvcnaVfZcnHQ.jpeg" /></figure><h3>TL;DR</h3><p>Layout Calculations allow for calculations in text objects, but this feature has a few nuances.</p><ul><li>Removes the need for extra fields or scripts or layout objects simply for display</li><li>Need to have version 20.3 or greater of FileMaker client</li><li>Works for labels of regular buttons</li><li>Use fully qualified field names so the calculation refreshes properly</li><li>Can set data format so the formatting of text field works</li></ul><p>The Support Group has been using FileMaker to provide solutions for clients for almost forty years, and for more than half of those years, we’ve been advocating for the layout calculations feature. So, we are very excited about its release.</p><h3>Layout Calculation Function</h3><p>A layout calculation is a text object placed on a layout, with a FileMaker calculation inserted into the text. It’s like a merge field but much more powerful. This new feature removes a great deal of limitations when it comes to creating dynamic layouts, mostly centered around schema and context. Using a merge field means adding to the schema. Using a merge variable means creating a script to set that variable and possibly using a script trigger to create or update that variable reliably. All of that adds to that file’s overhead, complexity, and maintenance.</p><p>Much of that complexity is now unnecessary with the new Layout Calculation feature. How do we do this? First, make sure we’re using version 20.3 of FileMaker. Go into Layout mode and select the Insert menu. At the bottom, we see the new Layout Calculation option.</p><figure><img alt="FileMaker Layout Calculation screenshot 1" src="https://cdn-images-1.medium.com/max/371/1*zm3fazDLQT6CTsKG_RExAA.jpeg" /></figure><p>Selecting that will insert a text object on our layout and then open up the calculation engine dialog. Create the calculation that we want and click ok. For this first example, we’ll use a simple text object that says “Hello” and then display the account name.</p><figure><img alt="FileMaker Layout Calculation screenshot 2" src="https://cdn-images-1.medium.com/max/880/1*K63KOS4Yih5FuPOApEBcvA.jpeg" /></figure><p>After we click OK, the text object will be placed on the layout, but it will have a new notation with a &lt;&lt;ƒ: [Calculation]&gt;&gt;. The calculation above looks like this:</p><figure><img alt="FileMaker Layout Calculation screenshot 3" src="https://cdn-images-1.medium.com/max/294/0*gls2rF9HVLCVzCnt.jpg" /></figure><p>Of course, when we exit layout mode, this then resolves to:</p><figure><img alt="FileMaker Layout Calculation screenshot 4" src="https://cdn-images-1.medium.com/max/167/0*NAkmY_LaEsUDLS8-.jpg" /></figure><p>That’s the basics:</p><ul><li>Enter Layout Mode</li><li>Select Layout Calculation from the Insert Menu</li><li>Specify your Calculation</li><li>Move the text object to where you want it and format it</li><li>Enter Browse Mode</li></ul><p>Note that we can specify the data type at the bottom of the layout calculation. This function is handy because we can pair that with the Data Formatting tools to customize how dates, currency, time, etc. values are displayed.</p><p>The use cases for this new feature — where we can use it in a solution — are many and varied. For example, we can use it to display different text on a button with additional instructions depending on the workflow. Here’s the calc:</p><p>&lt;&lt;ƒ:Case ( $$EDIT_MODE ; &quot;Please make changes to the record and click \ &quot;Done\&quot; when you are finished to save the record&quot;; &quot;Click \&quot; Edit\&quot; to make changes to this record&quot; )&gt;&gt;</p><p>Note the new ƒ: notation at the beginning. For this solution, we’ve scripted a specific “Edit Mode” to allow changes to the record only when users are in Edit Mode. Rather than having a field or two layered buttons with hide conditions or a button bar, we can now use this calculation in the button’s label. Here’s a screenshot of a similar calculation in use on a button:</p><figure><img alt="FileMaker Layout Calculation screenshot 5" src="https://cdn-images-1.medium.com/max/512/1*OoUspG_UfM3xam6BozSB1A.jpeg" /></figure><p>As another example, we usually create a Full Name field when building a contacts module. This calculation concatenates the last name and first name, with a comma in between. It usually looks something like this:</p><p>Last Name &amp; &quot;, &quot; &amp; First Name</p><p>We could certainly accomplish this with merge fields in a text object. But if users leave the last name empty, we would get a result that is a bit ugly — a leading comma and then the First Name. So, we’ll test to see if the fields are empty. The calculation could look something like this:</p><p>Case ( IsEmpty ( Last Name ) and IsEmpty ( First Name );&quot;&quot;; IsEmpty ( Last Name ); First Name; IsEmpty ( First Name ); Last Name; Last Name &amp; &quot;, &quot; &amp; First Name )</p><p>We could not do this with merge fields. We could stack objects and hide them, but that’s a lot of objects and hide conditions. We could create a new field for this, which we often did, but that adds unnecessary schema. Here’s what it looks like as a layout calculation.</p><p>&lt;&lt;ƒ:Case ( IsEmpty ( Contacts::Last Name ) and IsEmpty ( Contacts::First Name); &quot;&quot;; IsEmpty ( Contacts::Last Name); Contacts::First Name; IsEmpty ( Contacts::First Name ); Contacts::Last Name; Contacts::Last Name &amp; &quot;, &quot; &amp; Contacts::First Name ) &gt;&gt;</p><p>When creating Layout Calculations, Claris recommends using fully qualified field names so that the layout calculation will refresh when the field data changes. When we enter “Luke” in the first name field and “Skywalker” in the last name field, the result is:</p><figure><img alt="FileMaker Layout Calculation screenshot 6" src="https://cdn-images-1.medium.com/max/141/0*V7Z7M7xvdO73pRvu.jpg" /></figure><p>But if we enter “Madonna in the first name field, we get this:</p><figure><img alt="FileMaker Layout Calculation screenshot 7" src="https://cdn-images-1.medium.com/max/102/0*Wj8UX18kohwXoYwq.jpg" /></figure><p>We avoid messy leading or trailing commas.</p><p>While this new feature is exciting, we should use it judiciously like everything else. FileMaker will still have to render the calculation when we load the layout and every time the references within the calculation change. We have all seen the effects of too much conditional formatting on a layout, especially in list view. Using related fields and unstored calculations in the calculation will still have performance issues in a layout calculation, just as in conditional formatting and hide calculations.</p><p><a href="https://blog.supportgroup.com/filemaker-2023-perform-script-on-server-with-callback?utm_source=BlogPost-2023-12-11&amp;utm_medium=Medium&amp;utm_campaign=traffic">Check out</a> more FileMaker 2023 development features, like the <a href="https://blog.supportgroup.com/filemaker-2023-send-mail-oauth?utm_source=BlogPost-2023-12-11&amp;utm_medium=Medium&amp;utm_campaign=traffic">Send Mail OAuth</a> and <a href="https://blog.supportgroup.com/filemaker-2023-onwindowtransaction-script-trigger?utm_source=BlogPost-2023-12-11&amp;utm_medium=Medium&amp;utm_campaign=traffic">OnWindow Transaction script trigger</a> to help enhance your custom applications.</p><p><em>Originally published at </em><a href="https://blog.supportgroup.com/filemaker-layout-calculation"><em>https://blog.supportgroup.com</em></a><em> on December 12, 2023.</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=38deb365ee2d" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Integrating Claris Connect with ChatGPT]]></title>
            <link>https://thesupportgroup.medium.com/integrating-claris-connect-with-chatgpt-be31af5c4d76?source=rss-86a1bb368a5c------2</link>
            <guid isPermaLink="false">https://medium.com/p/be31af5c4d76</guid>
            <category><![CDATA[filemaker]]></category>
            <category><![CDATA[custom-software]]></category>
            <category><![CDATA[generative-ai-tools]]></category>
            <category><![CDATA[chatgpt]]></category>
            <category><![CDATA[machine-learning]]></category>
            <dc:creator><![CDATA[The Support Group]]></dc:creator>
            <pubDate>Tue, 28 Nov 2023 15:06:52 GMT</pubDate>
            <atom:updated>2023-11-29T15:26:52.444Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="Integrating Claris Connect with ChatGPT" src="https://cdn-images-1.medium.com/max/1024/1*qL_PuodcmUOYmBW4PNLC9Q.jpeg" /></figure><p>There are many practical applications for ChatGPT with a low-code development tool like FileMaker. We’ve explored a chatbot, image generator, and audio transcription <a href="https://blog.supportgroup.com/filemaker-integration-examples-with-chatgpt?utm_source=BlogPost-2023-11-28&amp;utm_medium=Medium&amp;utm_campaign=traffic">ChatGPT integration with FileMaker</a>. We’ve also shared an example of using ChatGPT to <a href="https://blog.supportgroup.com/how-to-use-chatgpt-and-filemaker?utm_source=BlogPost-2023-11-28&amp;utm_medium=Medium&amp;utm_campaign=traffic">summarize our notes</a>.</p><p>We want to explore how <a href="https://blog.supportgroup.com/chatgpt-and-filemaker?utm_source=BlogPost-2023-11-28&amp;utm_medium=Medium&amp;utm_campaign=traffic">integrating FileMaker and ChatGPT</a> via Claris Connect works. Though not necessarily ideal, we’ll use an annual performance review as the foundation for our example. Of course, performance appraisals are highly individualized, so artificial intelligence isn’t recommended, but most people can relate to this process’s fundamental objectives and structure. We will use it as a simple case to demonstrate the workflow and results.</p><h3>Storytelling with ChatGPT</h3><p>Let’s say an ice cream company called Sweet Bliss Treats has asked us to create a system to help their managers write formal performance reviews. We’ve created a form with questions for them to complete. Managers are responsible for inputting the essential information for their yearly reviews in this form. Then, ChatGPT will take that basic information and write a formal and detailed appraisal. Here’s an example of this form for Colleen B. Vanilla, the Senior Ice Cream Taster at Sweet Bliss Treats.</p><figure><img alt="Integrating Claris Connect with ChatGPT screenshot 1" src="https://cdn-images-1.medium.com/max/600/0*dtPwpgbbKPtjuYqf.jpg" /></figure><p>You’ll notice that the manager doesn’t have to put much effort into articulating their feedback, just hitting the highlights of the performance.</p><p>Hopefully, you’ve registered for a ChatGPT account and connected your account to FileMaker via an API key. It’s relatively quick and painless if you haven’t gone through this process yet. All you need to do is copy the secret key from ChatGPT and paste it into your FileMaker file. For more details and a sample file, review our blog post about <a href="https://blog.supportgroup.com/how-to-use-chatgpt-and-filemaker?utm_source=BlogPost-2023-11-28&amp;utm_medium=Medium&amp;utm_campaign=traffic">how to use ChatGPT and FileMaker</a>.</p><p>Having filled out the information on Colleen, our manager would like ChatGPT to create a detailed narrative to give her. Clicking on the button “Get Review by Connect” will submit a request to ChatGPT via Claris Connect to create that narrative for us.</p><h3>Claris Connect</h3><p>Claris introduced Connect to streamline integrations between FileMaker and other widely used applications, such as Slack, HubSpot, MailChimp, etc. It’s an intuitive, no-code solution for users looking to automate workflows across their technology stack. A drag-and-drop interface guides users through connecting different applications and configuring actions based on certain circumstances.</p><h4>Creating an Account</h4><p>You’ll need to go to <a href="https://connect.claris.com/login">connect.claris.com</a> to create an account. New accounts are free now, so we have access to unlimited active flows and all standard connectors. The only limitation is the number of flow steps we can activate each month — the free tier is limited to 500 per month. This threshold is sufficient if we only have to execute a straightforward flow once a day.</p><h4>Creating a Project</h4><p>The next step is to create a Project. Projects organize our various flows, allowing us to separate them into different buckets. Think of them like folders — an organizational tool, mainly. We may have one project per FileMaker file or one project per department. We’ll get a drop-down menu when we hover over the plus sign icon in the Projects view. Select “Create New.”</p><figure><img alt="Integrating Claris Connect with ChatGPT screenshot 2" src="https://cdn-images-1.medium.com/max/600/0*uhP3tXPSRTjhj0DZ.jpg" /></figure><h4>Creating a Flow</h4><p>On the detail page, click “Create New Flow.”</p><figure><img alt="Integrating Claris Connect with ChatGPT screenshot 3" src="https://cdn-images-1.medium.com/max/600/0*WP_YgkrLUFz4NUY7.jpg" /></figure><p>Configure Flow — Overview</p><p>Our Flow will have three actions:</p><ol><li>A webhook Action (the trigger) <br>In the FileMaker script, we will send two values to Claris Connect via the Trigger Claris Connect Flow script step: the primary key of the review and the prompt we want to submit to ChatGPT.</li><li>A ChatGPT Action <br>The action will take the prompt we submitted to the webhook and generate a narrative based on the prompt.</li><li>A FileMaker Action <br>Using the primary key submitted with the webhook, we will create a new record in the Responses table and set the foreign key to link the responses and review.</li></ol><p>Our Flow will look like this when it’s complete:</p><figure><img alt="Integrating Claris Connect with ChatGPT screenshot 4" src="https://cdn-images-1.medium.com/max/600/0*8_yH733r56s89P5o.jpg" /></figure><p><strong>Step 1: WebHook Action</strong></p><p>The trigger is the kickoff for the entire process. It will start the flow and allow us to transfer data from our FileMaker file to Claris Connect. Once we click “Create New Flow,” we will see a list of the standard connectors. Please note that since this is the very first step of the flow, many of the items will not be available for selection. Only specific connectors can initiate a flow; only those connectors are available to us in the first step. The rest will be available as we progress.</p><p>We’ll select the connector labeled “HTTP” as our first step and then click “Continue” on the bottom right. If there are existing webhooks, we can select one, but Claris Connect will create a new one with whatever name we enter.</p><figure><img alt="Integrating Claris Connect with ChatGPT screenshot 5" src="https://cdn-images-1.medium.com/max/600/0*ZJ_YJhYohAdNECb6.jpg" /></figure><p>Claris Connect will test whether the webhook will work, so we click the blue link that says, “Send an HTTP request to the webhook URL to continue.” A new tab in the browser will open with a default JSON response. Close that and go back to the original tab. Notice that the “Save Trigger” button is an option for us now, so let’s click it.</p><p>After that, we will do something counterintuitive: send the call from FileMaker to Claris Connect now instead of when we’re done. We’re doing that because, in later steps, we will need to know what data points we’re sending with the flow, but Claris Connect won’t know that until FileMaker triggers our new flow and sends the data.</p><p>Since the flow can’t be enabled yet, we’ll manually copy the http request listed in the webhook. Based on our example, it is: <br><a href="https://20zio8.apps.connect.claris.com/api/webhook/v1/chatgpt_webhook/catch">https://20zio8.apps.connect.claris.com/api/webhook/v1/chatgpt_webhook/catch</a></p><p>Next, let’s go into our FileMaker solution and paste this URL into the Trigger Claris Connect Flow script step.</p><figure><img alt="Integrating Claris Connect with ChatGPT screenshot 6" src="https://cdn-images-1.medium.com/max/600/0*qavriWwiNeTiO4Eo.jpg" /></figure><figure><img alt="Integrating Claris Connect with ChatGPT screenshot 7" src="https://cdn-images-1.medium.com/max/600/0*EzFG_gXji7DR4QR_.jpg" /></figure><p>Note: your URL will be slightly different than this one, as it comes from your Claris account, not ours.</p><p>Now, save and run the script. It will likely fail. However, it doesn’t matter because calling the webhook once provides Claris Connect with the list of data points we’ll use in the rest of the flow. And it will use those data points to return a detailed narrative to the record from ChatGPT.</p><p><strong>Step 2: ChatGPT Action</strong></p><p>When we click the plus sign to the right of the first step, we’ll see a pop-up menu with a series of items. Let’s click the “Action” button.</p><figure><img alt="Integrating Claris Connect with ChatGPT screenshot 8" src="https://cdn-images-1.medium.com/max/600/0*W9cdbchAKT4euCvi.jpg" /></figure><p>We must specify a connector for this new action. Find the “OpenAI” connector and select it. Notice that all the connectors are now available to us since we initiated the process.</p><figure><img alt="Integrating Claris Connect with ChatGPT screenshot 9" src="https://cdn-images-1.medium.com/max/600/0*9Tc_b0lzrCzF0qvC.jpg" /></figure><p>We must stipulate what we want to do, so select “Create a chat completion.”</p><figure><img alt="Integrating Claris Connect with ChatGPT screenshot 10" src="https://cdn-images-1.medium.com/max/600/0*5XLW60iWaH_Q-Mdz.jpg" /></figure><p>Next, we sign into the OpenAI account by inputting an API key from ChatGPT. See our previous blog post about how to <a href="https://blog.supportgroup.com/how-to-use-chatgpt-and-filemaker?utm_source=BlogPost-2023-11-28&amp;utm_medium=Medium&amp;utm_campaign=traffic">generate an API key</a>. Enter the API key, click sign in, and continue to the next step.</p><figure><img alt="Integrating Claris Connect with ChatGPT screenshot 11" src="https://cdn-images-1.medium.com/max/600/0*Suii0Wi6SrNGliPg.jpg" /></figure><p>Next, we’ll need to select the model the connector will use. Select gpt-4.</p><figure><img alt="Integrating Claris Connect with ChatGPT screenshot 12" src="https://cdn-images-1.medium.com/max/600/0*v11fmM8tDYTTtHYi.jpg" /></figure><p>After that, click the blue plus button below messages and select “User” in the “Role” text box.</p><p>Click the blue plus button on the “Content” text box and select the webhook.</p><figure><img alt="Integrating Claris Connect with ChatGPT screenshot 13" src="https://cdn-images-1.medium.com/max/600/0*pVCi3kpcEfwFI3sm.jpg" /></figure><p>It will expand to show the JSON array that FileMaker submitted to the webhook. Scroll down and select the “Content” object.</p><figure><img alt="Integrating Claris Connect with ChatGPT screenshot 14" src="https://cdn-images-1.medium.com/max/600/0*0IWj-S0MQ01NUJ7I.jpg" /></figure><p>Everything else can be left blank here. After we get it working, we can play with some of the options to see how they affect the results.</p><p><strong>Step 3: FileMaker Action</strong></p><p>We will ask FileMaker to create a new record in the Responses table and set the foreign key field within the table to the primary key’s value, thereby linking the new record with the respective review form.</p><p>We’ll get started by clicking the blue plus sign in step 2 to create the third step.</p><figure><img alt="Integrating Claris Connect with ChatGPT screenshot 15" src="https://cdn-images-1.medium.com/max/600/0*97Q9rqfeRzO4I4-c.jpg" /></figure><p>Click “Action” and select the “Claris FileMaker Server” option.</p><figure><img alt="Integrating Claris Connect with ChatGPT screenshot 16" src="https://cdn-images-1.medium.com/max/600/0*SQ4ttoxDaJPIkKq8.jpg" /></figure><p>Choose the “Create record” option and hit continue.</p><figure><img alt="Integrating Claris Connect with ChatGPT screenshot 17" src="https://cdn-images-1.medium.com/max/600/0*1kkDdc5KsFv_3CZR.jpg" /></figure><p>Now, we have to sign into the FileMaker server. We will need to provide the following details about the database where we’ll store the new record:</p><ul><li>the domain or name of the server</li><li>username</li><li>password</li><li>the name of the database</li></ul><p>It’s best to gather all this information beforehand to avoid delays because autofill does not apply here. When done, the screen should look like this:</p><figure><img alt="Integrating Claris Connect with ChatGPT screenshot 18" src="https://cdn-images-1.medium.com/max/600/0*HPSvb4PCQipeWgOB.jpg" /></figure><p>After we click continue, we must specify a layout name; in this case, that’s the “Responses” layout. Once we designate the layout, the associated fields dynamically populate. In step one, we want to set the “_fk_review” field to the review’s primary key value submitted via the webhook.</p><p>Click the plus button to the right of that field, select the webhook from the list of options, and then select the “pk” object from the JSON array. It’s directly below the “content” object we set in step two.</p><figure><img alt="Integrating Claris Connect with ChatGPT screenshot 19" src="https://cdn-images-1.medium.com/max/600/0*UgXCI33B2MY47yqX.jpg" /></figure><p>We should also see the “Narrative” field as an option in this connector. Let’s click that and select the OpenAI connector as the source. We’ll scroll until we can choose the “content” object.</p><figure><img alt="Integrating Claris Connect with ChatGPT screenshot 20" src="https://cdn-images-1.medium.com/max/600/0*Fpo9rozQlkTBChzC.jpg" /></figure><p>Click Save at the bottom.</p><p>To test this workflow, we’ll complete the review form using the <a href="https://blog.supportgroup.com/hubfs/Claris-Connect-ChatGPT/TSG%20ChatGPT%20Performance%20Review.fmp12">TSG ChatGPT Performance Review sample file</a> and click “Get Review by Connect.” ChatGPT may take a little while to process the request, and then we’ll receive a detailed rendering based on our responses to the appraisal questions.</p><p>Using our example about the Senior Ice Cream taster, Colleen Vanilla, here’s one response that ChatGPT returned. We’ll receive different results every time we click submit, as would happen within the ChatGPT interface.</p><p><em>Employee Performance Evaluation</em></p><p><em>Employee: Colleen Vanilla</em></p><p><em>Title: Senior Ice Cream Taster</em></p><p><em>Colleen, as a Senior Ice Cream Taster, has consistently exhibited high standards of quality and reliability in her role. Her proficiency in flavor discernment shows marked improvement and she maintains an unwavering commitment to quality assurance in her work. She is excellent at collaborating with her peers and contributes positively to the team environment.</em></p><p><em>In the area of organizational skills, she has been rated as good. She produces consistently high quality work, resulting in delightful and refined ice cream recipes that have garnered positive feedback from customers.</em></p><p><em>In terms of taking initiative and demonstrating enthusiasm for new challenges, Colleen’s performance is satisfactory. Although she has displayed effort in taking on new responsibilities, she fell short of her goals this year in terms of product development, suggesting a need for improvement in this area.</em></p><p><em>With regard to communication, it is observed that Colleen’s proficiency needs significant enhancement. Her active participation in meetings has been found lacking, thereby impacting her professional communication. Similarly, her record keeping could benefit from improvements.</em></p><p><em>Colleen is indeed a great fit for the organizational culture with a positive attitude that resonates well at the workplace. Her friendly demeanor, readiness to acknowledge her peers and willingness to aid others earn her excellent marks in this category.</em></p><p><em>Looking towards the future, the top three goals that Colleen should aim for include: improving her product development performance, enhancing her communication skills, and refining her record-keeping process. By addressing these areas, Colleen can significantly contribute to the growth and development of Sweet Bliss Treats.</em></p><p><em>Overall, Colleen’s performance as a Senior Ice Cream Taster is admirable, with a notable opportunity for growth and enhancement in certain functional areas. With a little effort and focus, she can reach her full potential and bring exceptional value to her role.</em></p><p>Again, the manager will likely have to edit the narrative, but it’s a good starting point. The solution will track multiple responses provided by ChatGPT so we can take the best parts from a few different responses and adjust them to our liking to create our own custom narrative. This example shows how ChatGPT can save us time and effort if used ethically.</p><p>Integrating Claris Connect with ChatGPT opens up exciting possibilities for the future of automation and conversational AI. As both platforms continue to evolve and improve, we can expect to see new features and innovations that further enhance their capabilities.</p><p><a href="https://blog.supportgroup.com/browsemode-subscription?utm_source=BlogPost-2023-11-28&amp;utm_medium=Medium&amp;utm_campaign=traffic">Join</a> our newsletter to keep up with the latest FileMaker features.</p><p><em>Originally published at </em><a href="https://blog.supportgroup.com/integrating-claris-connect-with-chatgpt"><em>https://blog.supportgroup.com</em></a><em> on November 28, 2023.</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=be31af5c4d76" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Data Debt Management]]></title>
            <link>https://thesupportgroup.medium.com/data-debt-management-179bb85c712f?source=rss-86a1bb368a5c------2</link>
            <guid isPermaLink="false">https://medium.com/p/179bb85c712f</guid>
            <category><![CDATA[data-management]]></category>
            <category><![CDATA[digital-transformation]]></category>
            <category><![CDATA[low-code]]></category>
            <category><![CDATA[filemaker]]></category>
            <category><![CDATA[custom-software]]></category>
            <dc:creator><![CDATA[The Support Group]]></dc:creator>
            <pubDate>Thu, 26 Oct 2023 13:30:24 GMT</pubDate>
            <atom:updated>2023-10-27T13:46:43.627Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="Data Debt Management" src="https://cdn-images-1.medium.com/max/1024/0*McxFLt5yUghiccUd" /></figure><p>In the ever-evolving landscape of technology, businesses today face several challenges in managing their digital assets. Among these challenges, one prominent issue often surfaces — data debt. Data debt results from poor data quality, mismanagement, or neglect, hindering business operations and decision-making. But, data debt does not have to be a terminal issue. We can tackle it by applying practical data conventions, implementing regular review and purge tactics, running system audits, etc.</p><h3>Data Debt vs. Technical Debt</h3><p>Before delving into the intricacies of data debt, it is essential to grasp the concept of <a href="https://blog.supportgroup.com/what-to-know-about-technical-debt?utm_source=BlogPost-2023-10-26&amp;utm_medium=Medium&amp;utm_campaign=lead-gen">technical debt</a>. Technical debt arises from shortcuts or suboptimal solutions when developing software systems. These inadequacies lead to inefficiencies, increased maintenance costs, and reduced capacity for future enhancements. Addressing technical debt requires code refinement, architectural improvements, and enhancing the entire software infrastructure to align with evolving business needs.</p><p>On the other hand, data debt pertains to the mismanagement and neglect of data assets within an organization. It arises when data is inaccurately collected, poorly organized, or left unattended, resulting in data quality issues, incomplete or inconsistent datasets, and a significant loss of business value.</p><h3>How Data Debt Affects Custom Software</h3><p>While <a href="https://blog.supportgroup.com/12-signs-you-should-invest-in-a-custom-business-application?utm_source=BlogPost-2023-10-26&amp;utm_medium=Medium&amp;utm_campaign=lead-gen">custom software solutions</a> offer flexibility and a competitive edge, they can also be a significant source of data debt because of their inherent link to an organization’s data ecosystem. Any shortcomings in data management can have a cascading effect on the software’s functionality.</p><p>Consider a scenario where a company’s custom software application relies on customer data. The software’s performance will suffer if this data has errors, duplicates, or outdated information. Inaccurate data can lead to incorrect calculations, failed transactions, and a diminished customer experience. Therefore, addressing data debt is paramount when custom software is in use.</p><h3>Optimizing Custom Software through Data Hygiene</h3><p>We recommend optimizing custom software by applying proper <a href="https://blog.supportgroup.com/organizing-your-data?utm_source=BlogPost-2023-10-26&amp;utm_medium=Medium&amp;utm_campaign=lead-gen">data hygiene</a> practices because of its compelling advantages.</p><p><strong>Enhanced Decision-Making</strong></p><p>Clean and accurate data empowers your organization to make informed decisions. It provides a reliable foundation for analytics and reporting, enabling us to derive valuable insights and identify untapped opportunities.</p><p><strong>Improved Customer Experience</strong></p><p>Custom software can offer a superior user experience when it relies on high-quality data. Accurate customer information ensures personalized interactions and builds trust.</p><p><strong>Efficiency and Cost Reduction</strong></p><p>Proper data management reduces the time and effort spent on data correction and troubleshooting within custom software. In turn, this lowers maintenance costs and frees up resources for innovation.</p><p><strong>Data-Driven Innovation</strong></p><p>Clean data fuels innovation by enabling the development of advanced features and predictive capabilities within custom software.</p><h3>Unlocking the Potential with System Audit Services</h3><p>Data debt can creep into any system, including FileMaker custom applications. Data management is undoubtedly a factor, but complex workflows and an outdated/inefficient system architecture also contribute to the issue. You might recognize a complicated workflow if it takes several clicks to find the information you need.</p><p>We understand the significance of data debt management for custom software optimization. Our <a href="https://www.supportgroup.com/services/?utm_source=BlogPost-2023-10-26&amp;utm_medium=Medium&amp;utm_campaign=lead-gen#audit">system audit services</a> address data debt in mature and legacy systems effectively. We perform comprehensive assessments, identify data quality issues, and recommend strategies to rectify them. By partnering with us, you can breathe new life into your custom software, harnessing its full potential for growth and success.</p><p>While custom software is a powerful asset, its efficiency gets hampered by data debt, making data management imperative. By optimizing your custom software through data hygiene practices and leveraging our system audit services, you can unlock new possibilities and drive your business forward in the data-driven era. <a href="https://www.supportgroup.com/contact?utm_source=BlogPost-2023-10-26&amp;utm_medium=Medium&amp;utm_campaign=lead-gen#form">Contact us</a> to get started with a free consultation.</p><p><em>Originally published at </em><a href="https://blog.supportgroup.com/data-debt-management"><em>https://blog.supportgroup.com</em></a><em> on October 26, 2023.</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=179bb85c712f" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[FileMaker Document Management System for Research and Development]]></title>
            <link>https://thesupportgroup.medium.com/filemaker-document-management-system-for-research-and-development-d9d220ef0ea0?source=rss-86a1bb368a5c------2</link>
            <guid isPermaLink="false">https://medium.com/p/d9d220ef0ea0</guid>
            <category><![CDATA[filemaker]]></category>
            <category><![CDATA[custom-software]]></category>
            <category><![CDATA[citizen-developer]]></category>
            <category><![CDATA[document-management]]></category>
            <category><![CDATA[software-development]]></category>
            <dc:creator><![CDATA[The Support Group]]></dc:creator>
            <pubDate>Wed, 13 Sep 2023 13:15:37 GMT</pubDate>
            <atom:updated>2023-09-14T14:06:01.318Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="FileMaker Document Management System fro Research and Development" src="https://cdn-images-1.medium.com/max/1024/1*aoZnAqSpEMdd9b3u476Hhw.jpeg" /><figcaption>FileMaker Document Management SystemFileMaker Document Management System</figcaption></figure><p>Genentech is a leading biotechnology company headquartered in San Francisco, CA. Since 1976, they have been dedicated to discovering and developing treatments for severe and life-threatening illnesses and diseases. In 2009, Roche Group acquired Genentech and currently operates as an independent subsidiary.</p><p>With more than 13,000 employees, The Support Group has worked with various departments within Genentech since 2011. We’ve built various custom applications to help teams streamline workflows and maximize productivity. We recently developed a records management system for the Quality Systems department.</p><p>The Quality Systems department is responsible for organizing the copious documents produced within the organization. The department stores and prints documents in a precise way. Their document management process is similar to a library system whereby resources must be collected, organized, and stored so that users can retrieve and use them.</p><p>Genentech archives its documents in two locations. Users can conveniently access the records digitally and remotely via a computer. Again, like a library, users check sources in and out in an orderly manner.</p><h3>The Challenge</h3><p>The Quality Systems department relied on an off-the-shelf document management system to file and track their document inventory. That software eventually turned into an antiquated legacy system. The program was unreliable and unstable. A user could spend about twenty minutes trying to log in. And more often than not, the program would crash.</p><p>Once logged in, users had to navigate around the interface to locate and check out the resources they needed. Even though the interface wasn’t user-friendly, the data within the system was accurate and helpful, so fortunately, data quality was not an issue.</p><p>Unfortunately, the software vendor was not easily accessible or responsive to the department’s support requests. And when they did manage to connect with the support team, it was usually an arduous process to resolve issues.</p><p>Eventually, the Quality Systems department decided to customize the software to suit their unique workflows. Again, their documents had to be stored and printed in a particular way, a way that off-the-shelf software did not effectively support. To be fair, most off-the-shelf software is not customizable.</p><h3>The Solution</h3><p>So, after an intense discovery session where we identified the existing pain points and fleshed out a list of functions users expected from the custom software, The Support Group developers went to work on fulfilling the project requirements.</p><p>Since accessibility was a significant source of frustration for users, system performance remained top of mind for the development team. <a href="https://blog.supportgroup.com/what-is-filemaker?utm_source=BlogPost-2023-09-13&amp;utm_medium=Medium&amp;utm_campaign=lead-gen">FileMaker</a> is a lightweight, low-code software programming tool that is easy to use. And, since we’ve implemented other FileMaker solutions throughout the organization, employees were relatively familiar with it. Therefore, FileMaker was a natural technology choice as far as accessibility and usability were concerned.</p><p>So, we designed a custom system they named DocBox. It’s very simple yet powerful software. We created a master record for every document. And there’s a check-in and check-out record for each source.</p><p>DocBox makes it easy and virtually error-free for users to enter records into the system. They use barcodes to process the documents, so manual data entry is minimal.</p><p>Users can also run reports. They can quickly see the total number of documents that are available for use. In addition, they can determine how many resources are checked out at a given time and the number of records by location.</p><figure><img alt="FileMaker Document Management System" src="https://cdn-images-1.medium.com/max/1024/1*hpPVGEjNUulbC2r66i6crA.jpeg" /></figure><figure><img alt="FileMaker Document Management System Menu Options" src="https://cdn-images-1.medium.com/max/1024/1*E5Q2GSIejayfIsvx-IsgGA.jpeg" /></figure><figure><img alt="FileMaker Document Management System Master Record" src="https://cdn-images-1.medium.com/max/1024/1*TKeZYm-kLIdOXfmgdemYhg.jpeg" /></figure><p>In an effort to enhance efficiency, we made it possible for users to confirm availability before borrowing a document. Therefore, users don’t spend time traveling to a particular location only to discover the document they need is unavailable.</p><h3>The Benefits</h3><p>The primary users of DocBox are archive managers and the specialists who scan and store the documents. It didn’t take long for them to appreciate the speed and ease of accessing the FileMaker document management system. They are also grateful for the reliability and stability it provides.</p><p>The TSG developers built a Batch Scan function into the custom document management system so users can scan multiple documents simultaneously to one location. For example, let’s say a user has fifty documents to input. They can add a barcode sticker to each document, then use the barcode reader to scan each document, and then enter the records with one click as long as they are stored at the same location.</p><figure><img alt="FileMaker Document Management System Menu List" src="https://cdn-images-1.medium.com/max/1024/1*Q-PAmJ6JNYfY_cr6UHb7Fw.jpeg" /></figure><p>Users save a remarkable amount of time when they simply open the program. The start-up process went from twenty minutes or not at all to about three seconds. That might sound minor, but for the Quality Systems team, it is a reason to celebrate.</p><p>The system offers a modern user interface, which makes the experience intuitive and productive. We optimized the application’s design to manage the documents efficiently and enhance the production speed.</p><h3>The Future</h3><p>DocBox has more than met the department’s expectations. However, when upgrades or enhancements are needed, we will be there to implement them. We generally design applications to be scalable and flexible so that they grow and pivot with the business.</p><p>We’ve been developing custom apps for more than 30 years. We helped our clients create various solutions, such as a <a href="https://blog.supportgroup.com/covid-19-filemaker-custom-reporting-app?utm_source=BlogPost-2023-09-13&amp;utm_medium=Medium&amp;utm_campaign=lead-gen">reporting application</a> and a comprehensive <a href="https://blog.supportgroup.com/financial-software-built-on-the-filemaker-platform?utm_source=BlogPost-2023-09-13&amp;utm_medium=Medium&amp;utm_campaign=lead-gen">financial management program</a>. Read more of our <a href="https://blog.supportgroup.com/customer-success-stories?utm_source=BlogPost-2023-09-13&amp;utm_medium=Medium&amp;utm_campaign=lead-gen">customer success stories</a> and <a href="https://blog.supportgroup.com/custom-software-case-studies?utm_source=BlogPost-2023-09-13&amp;utm_medium=Medium&amp;utm_campaign=lead-gen">case studies</a> to see how custom software improves operational efficiency.</p><p><a href="https://www.supportgroup.com/contact/?utm_source=BlogPost-2023-09-13&amp;utm_medium=Medium&amp;utm_campaign=lead-gen#form">Contact us</a> to learn more about our custom software development services or schedule a free initial consultation.</p><p><em>Originally published at </em><a href="https://blog.supportgroup.com/filemaker-document-management-system-for-research-and-development"><em>https://blog.supportgroup.com</em></a><em> on September 13, 2023.</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=d9d220ef0ea0" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[FileMaker 2023: Send Mail OAuth]]></title>
            <link>https://thesupportgroup.medium.com/filemaker-2023-send-mail-oauth-c49ac5d41b52?source=rss-86a1bb368a5c------2</link>
            <guid isPermaLink="false">https://medium.com/p/c49ac5d41b52</guid>
            <category><![CDATA[software-development]]></category>
            <category><![CDATA[filemaker]]></category>
            <category><![CDATA[low-code]]></category>
            <category><![CDATA[custom-software]]></category>
            <category><![CDATA[citizen-developer]]></category>
            <dc:creator><![CDATA[The Support Group]]></dc:creator>
            <pubDate>Wed, 16 Aug 2023 11:30:13 GMT</pubDate>
            <atom:updated>2023-08-16T17:32:22.064Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="FileMaker 2023: Send Mail OAuth" src="https://cdn-images-1.medium.com/max/1024/1*SQ6uajz9ypRuwBkXfktMkg.jpeg" /></figure><p>The FileMaker Send Mail script step is a valuable function for developers, but in recent years has become unreliable. Many conventional email service providers have gradually made using Simple Mail Transfer Protocol (SMTP) relays more complicated, primarily due to security concerns. Here at The Support Group, we’ve been transitioning clients to Gmail or Azure Application Programming Interfaces (APIs), depending on their email provider. Another option is SendGrid from Twilio, but that’s a different blog post. Now, FileMaker 2023 offers an enhancement to our Send Mail options, a game changer, in our opinion.</p><p>Open Authorization (OAuth) is a widely used framework that allows different applications to interact with one another. It’s most appreciated for its ability to facilitate those interactions without having to share access credentials. Instead, a private key verifies the user’s identity. It’s relatively easy to implement and maintain.</p><p>While using the API is great, it involves a fair amount of advanced setup to get it to work. That was what was great about using SMTP via the Send Mail script. Like many other things in FileMaker, it is simple, effective, and easy to set up. However, now with FileMaker 2023, we have a new way of using the Send Mail script step.</p><figure><img alt="FileMaker 2023: Send Mail OAuth screenshot 1" src="https://cdn-images-1.medium.com/max/400/0*0ZRPTfyFpHK2Ez19.jpg" /></figure><p>This option hits the sweet spot between SMTP and an API integration as far as usability. With SMTP, we had to ask our IT department for specific settings — settings they had already completed for other users in most instances — and we were good to go. Our IT department will still have to do some work for the OAuth setup on their end. We won’t go through the steps here but refer to these posts from <a href="https://support.claris.com/s/article/Sending-email-with-OAuth-2-0-authentication-Google-and-Microsoft?language=en_US">Claris </a>and <a href="https://www.glenavontechnology.co.uk/content-hub/configuring-filemaker-2023-to-send-smtp-using-oauth-and-google">Glenavon Technology</a>. Please note that we found the Glenavon blog post left out one step; we had to enable the Gmail API explicitly.</p><p>The process takes about ten minutes for someone with Admin Access to the email provider’s account. We need three things from them at the end of the process:</p><ul><li>Service Account Email</li><li>Admin User Email</li><li>Private Key</li></ul><p>As detailed in the articles above, we can easily find all three things to set up OAuth access.</p><figure><img alt="FileMaker 2023: Send Mail OAuth screenshot 2" src="https://cdn-images-1.medium.com/max/400/0*mfa-m3f3PexN_Bcq.jpg" /></figure><p>One thing to remember: be sure to save these settings somewhere because we will have to re-use them. We usually store them in a settings table or designated area of a solution so system administrators can access them quickly and update them if things change. For example, setting up our Google service account gave us the private key and the service account email in a JSON text file. A good practice would be to put that into a container field in our settings area for future reference and create separate fields for Service Account Email, Admin User Email, and Private Key input values.</p><p>Once we input that information, we’re done! It should send an email just like the SMTP email version of the Send Mail script step. At the end of the day, much easier than attempting to set up API access through the Gmail API or some other third-party solution like SendGrid. And the new OAuth option is more secure than the old SMTP protocol settings.</p><p>Where the <a href="https://blog.supportgroup.com/filemaker-2023-perform-script-on-server-with-callback?utm_source=BlogPost-2023-08-16&amp;utm_medium=Medium&amp;utm_campaign=traffic">Perform Script on Server with Callback</a> script step and the <a href="https://blog.supportgroup.com/filemaker-2023-onwindowtransaction-script-trigger?utm_source=BlogPost-2023-08-16&amp;utm_medium=Medium&amp;utm_campaign=traffic">OnWindowTransaction</a> script trigger are significant upgrades in FileMaker 2023, the OAuth component is one of those minor but powerful enhancements. It significantly improves the process of sending email messages from our FileMaker applications in terms of efficiency and security.</p><p><a href="https://blog.supportgroup.com/browsemode-subscription?utm_source=BlogPost-2023-08-16&amp;utm_medium=Medium&amp;utm_campaign=traffic">Join our mailing list</a> to keep up with the latest FileMaker features and tips and tricks to advance your development skills.</p><p><em>Originally published at </em><a href="https://blog.supportgroup.com/filemaker-2023-send-mail-oauth"><em>https://blog.supportgroup.com</em></a><em> on August 16, 2023.</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=c49ac5d41b52" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[FileMaker 2023: OnWindowTransaction Script Trigger]]></title>
            <link>https://thesupportgroup.medium.com/filemaker-2023-onwindowtransaction-script-trigger-75bdbe841301?source=rss-86a1bb368a5c------2</link>
            <guid isPermaLink="false">https://medium.com/p/75bdbe841301</guid>
            <category><![CDATA[low-code]]></category>
            <category><![CDATA[software-development]]></category>
            <category><![CDATA[citizen-developer]]></category>
            <category><![CDATA[filemaker]]></category>
            <category><![CDATA[custom-software]]></category>
            <dc:creator><![CDATA[The Support Group]]></dc:creator>
            <pubDate>Thu, 27 Jul 2023 11:15:43 GMT</pubDate>
            <atom:updated>2023-07-27T17:17:13.495Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*BBpOFm_M-J-0wR4pqdXsMw.jpeg" /></figure><p>FileMaker 2023 includes several useful new features, like <a href="https://blog.supportgroup.com/filemaker-2023-perform-script-on-server-with-callback?utm_source=BlogPost-2023-07-27&amp;utm_medium=Medium&amp;utm_campaign=traffic">Perform Script On Server with Callback</a>. Another noteworthy feature we want to explore is a new script trigger, OnWindowTransaction. We can find this script trigger within the list of script triggers that appear within the File Options selection of the active FileMaker file.</p><figure><img alt="FileMaker 2023: OnWindowTransaction screenshot 1" src="https://cdn-images-1.medium.com/max/417/1*dY-7o4IrIgkVSvscxADOxA.jpeg" /></figure><figure><img alt="FileMaker 2023: OnWindowTransaction screenshot 2" src="https://cdn-images-1.medium.com/max/898/1*QBhqxqaoJAi7CVFxDLFLZw.jpeg" /></figure><p>Where this script trigger appears is the first indication that it is a little different than the others. While other script triggers fire when we modify a field, enter a layout, or change modes, the reach or context of what causes this script trigger to execute is a bit larger. Any time we commit a record in any table, it will fire. Considering how many times we commit a record in FileMaker, it’s clear we must handle this event with some care.</p><p>The other unique feature of this script trigger is that, when called, it will automatically create a JSON block of data, and FileMaker will pass that data to the script it calls as a script parameter. We created a test file with one record to demonstrate this function and wrote a script to set a global variable with that script parameter. Then we created a dialog that displays that global variable. Here’s the script:</p><figure><img alt="FileMaker 2023: OnWindowTransaction screenshot 3" src="https://cdn-images-1.medium.com/max/1024/1*RiM3HSGPQXHgKshGFiOP0A.jpeg" /></figure><p>We associated this script with the OnWindowTransaction script trigger. Next, we specified a field in the Field Name section, in this case, “PrimaryKey.”</p><figure><img alt="FileMaker 2023: OnWindowTransaction screenshot 4" src="https://cdn-images-1.medium.com/max/895/1*dE5Dg971XZ5FdxLhkgojoQ.jpeg" /></figure><p>After setting this, we returned to the database and edited one record. The minute we committed that record, the script fired. Again, it will fire whenever we commit a record in any table in the FileMaker file. So, handle it with care. Here’s what the screen looked like when we committed that record.</p><figure><img alt="FileMaker 2023: OnWindowTransaction screenshot 5" src="https://cdn-images-1.medium.com/max/939/1*W5YdtZ2n9aIRmfl51j3M6Q.jpeg" /></figure><p>Let’s break that down line-by-line:</p><p>1. “ <strong>TestFile </strong>“ is the name of the active FileMaker file.</p><p>2. “ <strong>TestTable </strong>“ is the name of the table where an action has occurred.</p><p>3. The Third section is a JSON array with these elements:</p><ol><li>Action taken</li><li>Record ID of affected record</li><li>The value of the specified field name</li></ol><p>Thus, here it tells me that we</p><ol><li>Modified a record</li><li>The record ID was 1</li><li>PrimaryKey value was 6CE2F8A1–0915–4C7A-8C9F-E041E7E23E2C</li></ol><p>We will see an array of all committed records for this transaction. Let’s think about the “actions” part of the JSON block for a bit. This script trigger will fire whenever a record is created, modified, or deleted. It will do this regardless of whether these actions occur one record at a time or within a batch of records simultaneously.</p><p>Again, this script trigger allows developers to create a transaction log, and as such, we would naturally want to document those three critical types of transactions. If we create a new record, the JSON block looks like this:</p><figure><img alt="FileMaker 2023: OnWindowTransaction screenshot 6" src="https://cdn-images-1.medium.com/max/950/1*n4CVUN6tK0T9YIv_ulWSYQ.jpeg" /></figure><p>If we delete a record, the JSON block looks like this:</p><figure><img alt="FileMaker 2023: OnWindowTransaction screenshot 7" src="https://cdn-images-1.medium.com/max/950/1*3QMyQFXBQ1B15jrpIVdkgw.jpeg" /></figure><p>So that’s the basics of how the script trigger works. It will show us the file we’re working on, the table where the action took place, the action that took place, the record ID of the impacted record, and then whatever information is in the field we specify to pass along.</p><p>Now, to step beyond the basics, we’d like to review two things:</p><p>• The field we specified when setting up the script trigger</p><p>• What to do with the captured data</p><h3>The Specified Field</h3><p>The field we type in is unique in FileMaker land. First, this field should be in every table we want the trigger to work on and the name should be the same in each table. Second, we expect similar results for each table, or at least consistent results, so we’ll have to think about ways to set up this field to work and report back data from the context of all tables in our file. For example, we could capture who the current user is and have the script trigger add that to the data it reports back.</p><p>With some work, we can also use the script to report the current values of all the fields in the current table. A great use case would be to have it document all the data in a record — right before it is deleted. That way, we’ll have a catalog of the data and a way of rolling it back if necessary. The script can include any data we can think of to store in a field in the JSON results.</p><h3>Where to Store the Data</h3><p>Second, let’s discuss what to do with this information once we have it. This trigger fires every time we modify a record. Let’s say we create an internal audit log to store data whenever a record changes. When we do that, we’ll make a new record, which will trigger the OnWindowTransaction event, then try to create a new record, and so on. Suddenly, we’re stuck in a never-ending cascade of events.</p><p>The solution is to move the data outside of our file somehow. We can send it to another FileMaker file, write it to a text file, or push it to an external API. For example, let’s try the first option — create a separate FileMaker file and push the data to that file as part of the script associated with the script trigger.</p><p>Before coding, let’s think about what that would look like. We want a simple table that captures the log data without causing a never-ending cascade. We want to see when a record in our tables has been created, modified, or deleted. To do that, we’ll create a new FileMaker file named “auditLog.” The file has one field named “Log.” We’ll change the script associated with our OnWindowTransaction to run a new script in our auditLog file that will receive the JSON block as a script parameter and save it into the Log field. Here’s how the script in our TestFile looks now:</p><figure><img alt="FileMaker 2023: OnWindowTransaction screenshot 8" src="https://cdn-images-1.medium.com/max/1024/1*6kRxZulu-dibI_eZD5lxrw.jpeg" /></figure><p>And here’s the script in the auditLog file.</p><figure><img alt="FileMaker 2023: OnWindowTransaction screenshot 9" src="https://cdn-images-1.medium.com/max/1024/1*SJ4twJ2kohRMWQq8da42ZA.jpeg" /></figure><p>So then we created a new record, deleted that record, and modified a different record. Here’s what our auditLog file looks like.</p><figure><img alt="FileMaker 2023: OnWindowTransaction screenshot 10" src="https://cdn-images-1.medium.com/max/1024/1*AXMRf8Puc1123bArqp__pg.jpeg" /></figure><p>Now we have three new records, each with the JSON block from the action that triggered the event.</p><h3>A Good Pairing</h3><p>One final word on transactions: this script trigger makes the transactions in our solutions more explicit. By using it, we become more aware of how often they happen. However, it also adds overhead to each action, and we should be mindful of the scripts we attach to it and how they will affect the performance of our system. Like a good wine and cheese pairing, this script trigger pairs well with the new <a href="https://blog.supportgroup.com/new-script-set-filemaker-transactions?utm_source=BlogPost-2023-07-27&amp;utm_medium=Medium&amp;utm_campaign=traffic">Open Transaction and Commit Transaction script steps</a> when thinking about the performance and overhead of this new tool. Using these script steps, we can group actions into one large transaction and thus trigger this new OnWindowTransaction just once, at the “Commit Transaction” step.</p><p><a href="https://blog.supportgroup.com/browsemode-subscription?utm_source=BlogPost-2023-07-27&amp;utm_medium=Medium&amp;utm_campaign=traffic">Join our mailing list</a> to keep up with the latest FileMaker features. And if you need help incorporating any of these features into your custom apps, don’t hesitate to <a href="https://www.supportgroup.com/contact/?utm_source=BlogPost-2023-07-27&amp;utm_medium=Medium&amp;utm_campaign=traffic#form">contact us</a> about our mentoring or consulting services.</p><p><em>Originally published at </em><a href="https://blog.supportgroup.com/filemaker-2023-onwindowtransaction-script-trigger"><em>https://blog.supportgroup.com</em></a><em> on July 27, 2023.</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=75bdbe841301" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[FileMaker 2023: Perform Script On Server with Callback]]></title>
            <link>https://thesupportgroup.medium.com/filemaker-2023-perform-script-on-server-with-callback-7ca409096882?source=rss-86a1bb368a5c------2</link>
            <guid isPermaLink="false">https://medium.com/p/7ca409096882</guid>
            <category><![CDATA[software-development]]></category>
            <category><![CDATA[custom-software]]></category>
            <category><![CDATA[filemaker]]></category>
            <category><![CDATA[low-code]]></category>
            <category><![CDATA[citizen-developer]]></category>
            <dc:creator><![CDATA[The Support Group]]></dc:creator>
            <pubDate>Fri, 07 Jul 2023 13:15:13 GMT</pubDate>
            <atom:updated>2023-07-07T18:42:14.964Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="FileMaker 2023: Perform Script On Server with Callback" src="https://cdn-images-1.medium.com/max/1024/1*D9KNMjviAQfMGBI8o6Z4sQ.jpeg" /></figure><p>Claris has departed from the tradition of sequentially numbering its product releases. They decided to use the year of the release in the name of their latest release — FileMaker 2023. Yet, a word to the wise, while the name of the software is FileMaker 2023, the version number internally to the software is FileMaker 20.x.x.</p><p>Claris FileMaker 2023 includes many new features. The Perform Script On Server with Callback (PSOSWC) function is arguably the most exciting new script function we’ve seen in years.</p><h3>Perform Script On Server with Callback</h3><p>This script step instructs the server to trigger a script back on the client that initiated the event after performing a script on the server, thus, a callback. Nonetheless, there are a few technical details/caveats to be aware of as we explore this feature for our apps.</p><ul><li>This feature will only work if the server and client run FileMaker 2023.</li><li>The callback script will only run when the client is idle and no other scripts are running.</li><li>WebDirect supports PSOSWC.</li></ul><p>Why is this exciting for FileMaker developers? Well, sending a script to PSOS before was a bit of a black box. Unlike using the script debugger in the client, we can’t step through a script and see the errors that it returns. We can refer to the log on the server and see them there, but that can often be tedious to sift through, and sometimes our access to the server is limited. Using a callback, we can script error trapping that can be sent back to the client with the native FileMaker error codes. We can also customize the data we send to test if our script is doing what it should while running on the server. Of course, it was possible to do this using Script Results before, but the callback is more elegant and easier to implement.</p><p>Another use case for this feature, which can benefit developers and end users alike, is when we have a script that requires a long time to run. Rather than tie up the client with this activity, we can send that script to run on the server. Then a callback script can notify the user when it’s complete.</p><p>So how do we set this up? To use this feature, we need three scripts:</p><ol><li>One script to call the PSOS script step</li><li>Another script to run on the server</li><li>A final script to run on the client as a callback.</li></ol><p>As a demo/test, we’ve created a <a href="https://blog.supportgroup.com/hubfs/FileMaker_2023/PSOSWC/FileMaker2023Test.fmp12.zip">sample file</a> with one million records. We’ve written the three scripts above.</p><figure><img alt="FileMaker 2023: Perform Script On Server with Callback screenshot 1" src="https://cdn-images-1.medium.com/max/288/0*uhNkc21r_MlZkTwe.jpg" /></figure><p>The first script — PSOS — Set New ID — will call the new Perform Script On Server with Callback script step:</p><figure><img alt="FileMaker 2023: Perform Script On Server with Callback screenshot 2" src="https://cdn-images-1.medium.com/max/600/0*Rfu-Rd9xURlKaQx9.jpg" /></figure><p>The second one is the meat of the process; this will replace the contents of a field with Get(UUID). Again, doing this via the client on a hosted file would take forever. Doing it via PSOS will take much less time but still consume resources, so it would be nice not to have to wait for the script to finish.</p><figure><img alt="FileMaker 2023: Perform Script On Server with Callback screenshot 3" src="https://cdn-images-1.medium.com/max/600/0*oIr-A4OMZoyom981.jpg" /></figure><p>The third script notifies the user that the script is complete.</p><figure><img alt="FileMaker 2023: Perform Script On Server with Callback screenshot 4" src="https://cdn-images-1.medium.com/max/600/0*E3uuLzUa0lYiYGM9.jpg" /></figure><p>As a test, we started the “replace” script manually, running the replace script step in the client locally. This method was prolonged and would have taken much of the day to complete.</p><p>The next test was to run the PSOSWC script step. Seeing it fire off was a bit disconcerting, with no expectation that we had to wait around for it to complete. But the minute it started, we could see records updating in our client. We left FileMaker running but proceeded to do other things like check e-mail. We could have been using FileMaker as well at the same time. Within about 5 minutes, our last script fired, and a dialogue box popped up to alert us that the script was complete. We are amazed at how productive this technique is. It’s like having another computer at our disposal.</p><figure><img alt="FileMaker 2023: Perform Script On Server with Callback screenshot 5" src="https://cdn-images-1.medium.com/max/600/0*cWg9rJ1Tr-3SQAJb.jpg" /></figure><p>There’s one other interesting feature to review with this: Script Results. With the old PSOS, we could pass our script results back to our original script. What happens with PSOSWC? The script result from the PSOS script gets passed to the callback script. Since the original script runs asynchronously, there’s no place for the results of that script to go except the callback script. So, to demonstrate, we adjusted our main script again:</p><figure><img alt="FileMaker 2023: Perform Script On Server with Callback screenshot 6" src="https://cdn-images-1.medium.com/max/561/0*cgAuaRJjxqF--_kg.jpg" /></figure><p>First, we limited the record count to 100,000 to speed up the processing time for this demonstration. Second, we captured the replace operation’s start and end times to record how long it takes to run this script. This script is an example of local variables and data that will not be stored but are still valuable information that we can distill and transmit. We’ll pass the total elapsed time to the callback script and display that in the pop-up dialog box.</p><figure><img alt="FileMaker 2023: Perform Script On Server with Callback screenshot 7" src="https://cdn-images-1.medium.com/max/600/0*JTzbkEBeLHk_AMsO.jpg" /></figure><p>And this is the final message:</p><figure><img alt="FileMaker 2023: Perform Script On Server with Callback screenshot 8" src="https://cdn-images-1.medium.com/max/600/0*puLhaKntfE_0Byxg.jpg" /></figure><p>What a gift to developers! This minor feature will have major benefits. Anyone using PSOS will likely convert to PSOSWC. We can’t wait to see what the FileMaker developer community does with this and the productive workflows they develop.</p><p><a href="https://blog.supportgroup.com/browsemode-subscription?utm_source=BlogPost-2023-07-07&amp;utm_medium=Medium&amp;utm_campaign=traffic">Join our mailing list</a> to keep up with the latest FileMaker development trends. And if you need help incorporating any of these features into your custom apps, don’t hesitate to <a href="https://www.supportgroup.com/contact/?utm_source=BlogPost-2023-07-07&amp;utm_medium=Medium&amp;utm_campaign=traffic#form">contact us</a> about our mentoring or consulting services.</p><p><em>Originally published at </em><a href="https://blog.supportgroup.com/filemaker-2023-perform-script-on-server-with-callback"><em>https://blog.supportgroup.com</em></a><em> on July 7, 2023.</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=7ca409096882" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[FileMaker Project Management Template]]></title>
            <link>https://thesupportgroup.medium.com/filemaker-project-management-template-dcdc8916623e?source=rss-86a1bb368a5c------2</link>
            <guid isPermaLink="false">https://medium.com/p/dcdc8916623e</guid>
            <category><![CDATA[filemaker]]></category>
            <category><![CDATA[project-management-tool]]></category>
            <category><![CDATA[citizen-developer]]></category>
            <category><![CDATA[software-development]]></category>
            <category><![CDATA[custom-software]]></category>
            <dc:creator><![CDATA[The Support Group]]></dc:creator>
            <pubDate>Tue, 30 May 2023 13:15:06 GMT</pubDate>
            <atom:updated>2023-05-30T19:47:11.230Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="FileMaker Project Management Template" src="https://cdn-images-1.medium.com/max/1024/1*YGlypyjZW5jiHVPkhSa4dg.jpeg" /></figure><p>Welcome back to the third and final part of our FileMaker project management blog series. We reviewed the various types of project management solutions and established a basic set of requirements and the beginnings of an ERD for the system in <a href="https://blog.supportgroup.com/a-filemaker-project-management-solution-example?utm_source=BlogPost-2023-05-30&amp;utm_medium=Medium&amp;utm_campaign=traffic">part one</a>. Then we brainstormed the <a href="https://blog.supportgroup.com/project-tracking-software-built-with-filemaker?utm_source=BlogPost-2023-05-30&amp;utm_medium=Medium&amp;utm_campaign=traffic">workflow for our system</a> and used a few whiteboards to make preliminary sketches of how the solution will work. Finally, we will build the application and flesh out a FileMaker project management template.</p><p>Now, we’ll dive into some actual coding in FileMaker. But first, we should name the solution. The name might sound trivial, but most app designers and software CEOs would agree that what you call the application and how you brand it does impact the product’s success. Also, as FileMaker developers, we have come across many solutions called “The FileMaker,” which is like calling all Excel sheets “the Excel file.” We encourage all of our clients to distinctly identify each program. For this particular project, since our graphic design firm focuses mainly on pet food clients, we will call our system WoofWorkSpace, or WWS for short.</p><p>Of course, we must create the file as well as the primary and foreign keys, and replicate our entity relationship diagram (ERD) in the relationship space. The first pass would look like this:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*L-JWQTMlu3NgN3yD.jpg" /></figure><p>Next, we start building out our list of fields. When working with our clients, we’d reference our initial discovery documents for that. But, for the sake of this example, we’re keeping the details simple and building from there. For instance, there are many fields that we could include in the client database, but we’ll focus on the fundamental parameters. Here are screenshots of the basics so far.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*hyqq4tvSgmyrDLj-.jpg" /></figure><p>Please note that the above screenshots are snapshots in time of our development — a good starting place for us to start working on the next steps of this project. The list of fields will evolve as we continue to work on this. You will find the ultimate list of fields we used for this application within the <a href="https://blog.supportgroup.com/hubfs/FileMaker_Project_Management_Template/WoofWorkSpace.fmp12">FileMaker project management sample file</a>.</p><p>So with that said, our next step is to work on the user interface (UI). Based on our <a href="https://blog.supportgroup.com/project-tracking-software-built-with-filemaker?utm_source=BlogPost-2023-05-30&amp;utm_medium=Medium&amp;utm_campaign=traffic">FileMaker project tracking software article</a>, we already have a good sense of the app’s functionality. So, going into layout mode, the first thing we do is set the grid to 64/8. We’ve found that using this type of grid makes our UI design attractive, not to mention easy and fast to implement.</p><p>Next, we want to start designing the layout but don’t want to start from scratch. We’re going to use the Apex Blue theme to keep things simple. If you read our blog post about designing a <a href="https://blog.supportgroup.com/how-to-design-a-filemaker-crm?utm_source=BlogPost-2023-05-30&amp;utm_medium=Medium&amp;utm_campaign=traffic">CRM in FileMaker</a>, you might recall that we also used the Apex Blue theme for that project. But we modified it a bit to work with the 64/8 grid. We will import that custom theme into this new project to save some time. To do that, go to File → Manage → Themes, and click on the “Import” button at the bottom of the dialog box.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/300/0*DthJh3edrgmbQGEd.jpg" /></figure><p>We will also copy the old detail layout we created for the CRM solution into the new WoofWorkSpace file. Luckily, it has a similar structure in terms of design, so we should be able to adjust it to fit the new solution easily. Here’s what the CRM layout looks like.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/500/0*Cs1782LMCxb3Uleh.jpg" /></figure><p>We decided to use tabs instead of the side navigation element for the project management layout mainly because those are easier to implement natively in FileMaker, and again, we’re aiming for simplicity here. However, if we had time, we would spiff up the side navigation and implement a Material Design look and feel.</p><p>Here’s the first pass of the new Project Detail page. We have four tabs: Tasks, Team, Documents, and Notes.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/500/0*5jcetZ7h7cIKhuXW.jpg" /></figure><p>We can delegate as many tasks as we like and assign each task to a team member. There are drop-down menus for the “Assigned To” field that only allows us to appoint a team member to a job.</p><p>Next to the tasks tab, we have tabs for Team, Documents, and Notes. You can select which users are part of this project’s “Team” within the Team tab. If selected, they will appear in the drop-down to be assigned tasks.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/500/0*Mv9MENqeBQ64k57K.jpg" /></figure><p>Documents is a place to store PDFs of specs, text documents, and images to be used in the web campaign.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*5HE0l2tGWY0zadms.jpg" /></figure><p>And that’s the heart of a Project Management system. From here, we would flesh this out by adding the following:</p><ul><li>A task detail card where users can add comments and feedback, with screenshots, for each task</li><li>A list view for tasks so users to see just their tasks</li><li>A dashboard showing users their assigned tasks, projects, and clients</li><li>A clients module to display the client’s demographic information, and the projects associated with that client</li><li>Color coding and visual alerts to indicate when tasks are due or overdue</li><li>Email alerts to further highlight when tasks are due or overdue</li><li>A settings area with fields to add users quickly, and email address settings for sending email notifications</li></ul><p>Nonetheless, this <a href="https://blog.supportgroup.com/hubfs/FileMaker_Project_Management_Template/WoofWorkSpace.fmp12">FileMaker project management template</a> adequately demonstrates how quickly and easily we can implement a low-code solution to address a task management problem. By being able to change the application’s structure so easily, stakeholders and solution developers can create project management solutions that are tailored specifically to their workflows and business operations.</p><p><a href="https://blog.supportgroup.com/custom-software-case-studies?utm_source=BlogPost-2023-05-30&amp;utm_medium=Medium&amp;utm_campaign=traffic">Discover</a> other ways FileMaker improves productivity and operational efficiency. And find additional <a href="https://blog.supportgroup.com/developer-resources?utm_source=BlogPost-2023-05-30&amp;utm_medium=Medium&amp;utm_campaign=traffic">custom app development resources</a>, including tips and tricks, demos, and best practices.</p><p><em>Originally published at </em><a href="https://blog.supportgroup.com/filemaker-project-management-template"><em>https://blog.supportgroup.com</em></a><em> on May 30, 2023.</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=dcdc8916623e" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>