Jump to content

DB Services

Membres
  • Content Count

    145
  • Joined

  • Last visited

    Never
  • Days Won

    1

DB Services last won the day on February 16

DB Services had the most liked content!

1 Follower

About DB Services

  • Rank
    100

Profile Information

  • Gender
    Homme
  • Location
    US

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. DB Services Named FileMaker Partner of the Year 2020 On August 5th, 2020, DB Services was named the Claris Excellence Award FileMaker Growth Partner of the Year for the Americas for 2020. This is DB Services 4th consecutive year bringing home the award from Claris International, Inc. The award is presented annually to each region’s Claris partner that achieves the highest revenue and brand growth for Claris. DB Services CEO, Kevin Hammond, reflects on this award: “It is an unprecedented honor to be given the FileMaker Growth Partner of the Year award for 4 years running. Our incredible team and drive for innovation and growth continues to put us at the forefront of the FileMaker space.” DB Services’ mission is to make organizations more efficient and effective through the use of custom applications. With 15 plus years of experience in FileMaker development, DB Services is dedicated to advocating and growing the FileMaker community. Since 2003, DB Services has provided custom applications and workflow solutions to Fortune 500 companies, small businesses, K-12, Universities, and non-profit-organizations. DB Services is also Claris Business Alliance Platinum Member, and provides FileMaker Development, FileMaker Support, FileMaker Training, FileMaker Cloud Hosting and FileMaker Licensing. With 20+ Certified FileMaker Developers and 4 time FileMaker Growth Partner of the Year for the Americas award winner (2017-2020), DB Services is considered one of the top Claris Partners in the country. For a Complimentary consultation contact DB Services at 888-488-0191, or fill out a Contact Form on DB Services’ website. Did you know we are an authorized reseller for Claris Connect Licensing? Contact us to get a competitive quote on a Claris Connect License. Afficher la totalité du billet
  2. Surveys for Success: UNITY Performing Arts Foundation In these difficult times, it is more important than ever to give back whenever possible. DB Services continues to support organizations with our Surveys for Success program, and this quarter, our charity partner is UNITY Performing Arts Foundation! The UNITY Performing Arts Foundation and their CEO and founder, Marshall White, have been leaders in transforming the lives of children and young adults in so many ways. UNITY provides after-school performing arts programs for youth in Fort Wayne, IN. UNITY’s goal is “empowering and developing young people in the areas of artistry, character, and leadership.” This is achieved through their dance classes, empowerment camp, creative writing classes, and much more. Their outstanding Voices of Unity Youth Choir was named one of the top 50 after-school arts and humanities-based programs in the country in 2009. DB Services is proud to highlight UNITY and their accomplishments for our Surveys for Success program. We are donating $25 for every survey that our clients complete to UNITY Performing Arts Foundation. Our goal for Q3 is to donate $1,000 from surveys from those we work with. Each survey we receive is an additional donation towards UNITY. Your feedback for DB Services will not only help our team, but provide UNITY with donations in the process! Simply fill out our surveys with your feedback, and together we can make a positive impact. Afficher la totalité du billet
  3. DB Services Ranked on IBJ Fast 25 DB Services has been ranked on the Indianapolis Business Journal’s Fast 25 list. This yearly list ranks the 25 fastest growing companies in Indianapolis area based on year over year growth of revenue. DB Services ranked 20th out of 25, with 78% revenue growth from FY 2017 to 2019. DB Services CEO, Kevin Hammond, shared his thoughts on the ranking: “DB Services is proud to be a growing member of the Indianapolis tech community. Since our start in 2003, our goal has been to help bring Indianapolis to the forefront of tech, and to be a fast-growing and innovative company. Making the IBJ Fast 25 list is confirmation that we’re on the right path to both of those goals.” In the article, Hammond also shares the secret to DB Services’ growth: customer relationships and a team that “goes beyond the technical skills set.” DB Services is proud to be a growing member of the Indianapolis community, and thanks the IBJ for their recognition of our team. We look forward to continued growth and innovation for years to come for our customers and employees! Afficher la totalité du billet
  4. Claris Connect and FileMaker Approvals Email has totally transformed the way people work and communicate. The average employee receives over 120 work emails a day, so the easier it is to take action on an email, the better. Claris Connect offers a powerful tool for efficiency in its Approvals Utility, a service that uses email to automate approvals for your team. You can set up approval workflows, automate immediate next steps based on an approval’s response, and view the results of previous approval requests all within Claris Connect itself. Another stand out feature of Claris Connect is how easily it integrates with FileMaker, so in the video example, we’ll send an approval request from a form built in FileMaker. You won’t need to set up fmp urls, webhooks, or anything fancier than Insert from URL and a few JSON functions. Claris Connect handles the call and response functions, while users interact solely through their email client. If you’re not yet comfortable using FileMaker’s JSON functions, check out our article on FileMaker JSON functions. To see another Approvals Utility example that integrates with Formstack, check out our Claris Connect Overview article. Approval Basics The New approval action is the first option in the Utilities menu. As with all new flows in Claris Connect, you’ll need to configure a trigger before you have access to the action steps. To set up a new approval, you’ll need: Title: this appears in the subject line of your email Description: this is the main body part of the email, where you make the case for your request Approver email: recipient Requester name: sender Due date: if the request has not been approved or rejected by this date, it will be marked as expired Adding an Attachment You can also send an approval with an attachment, as long as the attachment can be specified as a url. This can be an attachment address that is open to the public, such as a document hosted on your website. This could also be a url obtained from a previous trigger or action in your Claris Connect flow. For example, you can use the Get Attachment by id flow step from Microsoft Office to get a url for an existing email attachment. Responding to Approvals The approver will receive an email that looks something like this: Most recipients can simply input their comments and press approve or reject, right from their email browser. As shown in the image above, Microsoft Outlook users will need to click the link in the email to approve the request from the Claris Connect project itself. In order to access the project, they will need to be a user on your Claris Connect team, or an external user who has been invited to the project with the Approval. To invite users, click “Sharing” on the left side of your project, then enter their email. Note that these users will need to create a FileMaker ID, they will full have access to modify any flow in your project, and they will be able to see your Claris Connect subscription usage. Only Microsoft Outlook users need access to the project in order to respond to approvals. Handling Results Once the recipient has approved or rejected a request, use additional flow actions to take next steps, such as updating a record in FileMaker, sending a message using Slack, or creating a purchase order in Quickbooks. Additionally, Claris Connect provides a centralized management center for your entire Approvals history. You can search for approvals by status, requester name, or approver, and update pending approvals from this page. Takeaway Claris Connect opens up a world of options for automation and connecting your business services. The Approvals Utility takes this even further, giving you the tools to initiate and manage approval requests right “out of the box,” so to speak. And as you can see, it’s very simple! When you link this tool to other services, including FileMaker, you have a powerful way to document decisions and keeping things moving within your organization, while minimizing errors and keeping track of stale requests. Contact us for help integrating Claris Connect into your business. Did you know we are an authorized reseller for Claris Connect Licensing? Contact us to get a competitive quote on a Claris Connect License. Download Claris Connect and FileMaker Approvals Please complete the form below to download your FREE FileMaker database file. Download File Name* First Last Company Phone* Email* FileMaker Experience*New to FileMaker Platform Existing User of FileMaker Existing Developer of FileMaker Terms of Use I agree OPT-IN: I agree that I am downloading a completely free FileMaker application file with no strings attached. This database is unlocked, and I may use it for my business or organization as I see fit. Because I am downloading a free database, I agree that I should receive occasional marketing. I understand that I can OPT-OUT of these emails at anytime. Constant1 Afficher la totalité du billet
  5. FileMaker BackBlaze Integration BackBlaze is a large scale cloud storage platform that currently boasts an impressive 1 billion gigabytes of file data hosted on the cloud and counting. With its competitive pricing, BackBlaze makes a strong case for a place where you can store and retrieve large amounts of data at an affordable rate. Integrating your FileMaker application with BackBlaze’s B2 Cloud Storage API can assist moving external files to the cloud, minimizing file size growth and keeping your FileMaker application lightweight.  What You Need In addition to owning a BackBlaze account, you will need to create a Bucket on your account page. A Bucket is a location where files can be stored, and you can upload files to the Bucket of your choosing. Following this, you will need to generate an application key with access to this Bucket to perform API calls. Please note that the information will only display once so please make sure to document it. Authentication You will need your application key and associated info you received on the BackBlaze account page to authenticate with the BackBlaze B2 Cloud Storage API. Authenticating successfully gives you an Authentication Token, an API Url, and a Download Url. These credentials are only valid for 24 hours, and after that they must be refreshed. Here is an example of a result: { "absoluteMinimumPartSize": 5000000, "accountId": "d7afd9e250f5", "allowed": { "bucketId": "7db75acf7d99eeb275100f15", "bucketName": "FileMakerArticle", "capabilities": [ "listBuckets", "readBuckets", "listFiles", "readFiles", "shareFiles", "writeFiles", "deleteFiles" ], "namePrefix": null }, "apiUrl": "https://api002.backblazeb2.com", "authorizationToken": "4_002d7afd9e250f50000000001_01941816_6fa62b_acct_PQ6MJFWUoCp6159-dKFNBzBNM7g=", "downloadUrl": "https://f002.backblazeb2.com", "recommendedPartSize": 100000000 } Uploading Files Using the API Url from the authentication process and its associated credentials, you now need to generate an Upload Url. This Url is used to upload files onto your BackBlaze account. Much like the authentication process, this Url is only valid for 24 hours. With the Upload Url in hand, you can now push container files from FileMaker into BackBlaze’s cloud storage. Your curl request should look something like this: "-X POST " & ¶ & "-H \"Authorization: " & $uploadAuthToken & "\"" & ¶ & "-H \"X-Bz-File-Name: " & $fileNameEncoded & "\"" & ¶ & "-H \"Content-Type: b2/x-auto" & "\"" & ¶ & "-H \"X-Bz-Content-Sha1: " & $sha1 & "\"" & ¶ & "-H \"X-Bz-Info-Author: unknown" & "\"" & ¶ & "--data-binary @$container" A SHA1 Checksum is recommended when uploading your files to BackBlaze. This ensures that the file is not corrupted while in transit between FileMaker and the cloud. You can apply the following FileMaker function to generate a SHA1 checksum on a container. HexEncode ( CryptDigest ( <<YourContainer>>; "SHA1" ) ) If your file was successfully uploaded, you should receive a response with a status of 200, indicating that your file was successfully uploaded to your bucket on BackBlaze. Additionally, a fileID will be passed alongside the response, which is that file’s unique identifier on your BackBlaze account. You will need this fileID to download that file from BackBlaze. Additionally, successful uploads should display on your BackBlaze account. Downloading Files Using the Download Url from authentication in tandem with the fileID from your upload request, you can perform an API call to request a download of a specific file. In the headers from the response you have access to BackBlaze’s SHA1 checksum as well, so you can compare it against what you have to see if there is any corruption. Displaying Files In FileMaker One thing you’ll want to keep in mind when working with the API is that you’ll need to store a representation of all the files as records in your FileMaker solution. In the sample file, we have a file table to store the document names, BackBlaze fileID, size, etc. Conclusion BackBlaze’s B2 Cloud Storage API allows you offload large amounts of file data from your FileMaker application to the cloud. With all your files stored on the cloud, you can keep your data size low, while also being able to easily access your files on the web. Contact us if you would like help integrating your BackBlaze account with your FileMaker application! Did you know we are an authorized reseller for FileMaker Licensing? Contact us to discuss upgrading your FileMaker software. Download the FileMaker BackBlaze Integration Sample File Please complete the form below to download your FREE FileMaker database file. Name* First Last Company Phone* Email* FileMaker Experience*New to FileMaker Platform Existing User of FileMaker Existing Developer of FileMaker Terms of Use I agree OPT-IN: I agree that I am downloading a completely free FileMaker application file with no strings attached. This database is unlocked, and I may use it for my business or organization as I see fit. Because I am downloading a free database, I agree that I should receive occasional marketing. I understand that I can OPT-OUT of these emails at anytime. Constant1 Afficher la totalité du billet
  6. Claris Connect QuickBooks Online Integration Intuit’s QuickBooks Online is a powerful tool with over 4 million subscribers that allows for easy management of invoices, payments, and other accounting tasks. Many companies find themselves with both QuickBooks and FileMaker and end up having to do double data entry from one system to the next. Claris Connect is a “no-code” platform from Claris International, Inc. that allows organizations to rapidly connect multiple cloud services together, including FileMaker and QuickBooks Online. See our articles overviewing Claris Connect and integrating FileMaker with Quickbooks Online on our website. Here we will show you how quick and easy it can be to integrate your FileMaker solution with QuickBooks Online using the new Claris Connect toolset. Delivering Data from FileMaker to Claris Connect In this example will we be initiating our sync from FileMaker and transmitting new or updated Customer and Invoice data to our QuickBooks Online account. Claris Connect also offers the ability to begin a sync process based on actions taken in QuickBooks Online and we invite you to explore those further on your own. For this walkthrough, the first thing you want to do is create a new flow in your Claris Connect project and select the trigger as FileMaker. You can use either Cloud on On-Prem servers as an option and the configuration is very similar; here, we will be connecting with an on-prem server. Simply enter your server URL, user credentials, and filename (do not include the “.fmp12” extension) and click continue. Note: The user you provide must have the “fmrest” extended privilege enabled in FileMaker or you will get an error here. You will then be presented with a callback url specific for your flow and instructions on how to connect your FileMaker Pro file. Follow these instructions to connect your database to your new flow and click Save Trigger, and you are now ready to begin. Any time you initiate a sync from FileMaker you want to be sure you are delivering all the data that you might need throughout the entire flow up front. Create a sync script in FileMaker which contains a JSON payload being delivered to Claris Connect and contains all customer data such as name, address, email, phone, and existing QuickBooks ID as well as invoice information such as amount, line item description, and line item service/product category. Once you have your file connected and your “initiate sync” script created, enable your flow and run the script for an example invoice so that your trigger step will now contain all the potential data points you may need to set through your flow. Note: In order to test syncing to QuickBooks Online you will need an active QBO company account to connect to. At this time Claris Connect does not allow you to authenticate with Intuit Developer Sandbox companies, however you can create a 30 day free trial account with QBO and connect to that for testing purposes. Workflow for Syncing Customers Any time we sync an invoice to QuickBooks Online we must provide the Customer’s internal QuickBooks ID number (QBID) to tie them together, which means we must verify the customer exists already in our QuickBooks account. Here you will want to go through some steps in your flow to confirm the existing customer, find a matching customer, or create a new one if necessary to acquire the customer QBID we need. First, use a “Set Variable” flow step (one of the standard utility actions) to create a new variable called customerQBID and set it to the value of the customer’s QBID you delivered in your trigger payload from FileMaker. It is entirely possible that this will be blank if it’s a customer you have never synced with Quickbooks before. Next use an “If / Then” flow step to check if your variable is empty, and if it is then you want to perform a “Get customer by query” flow step to check for a matching customer in QuickBooks using the name sent from FileMaker similar to this: Next use another “If/ Then” flow step to see if your query returned a CustomerID. If it did, then that means we have a name match already existing in QuickBooks so you can set your customerID variable to that value and we are ready to move on. If not, use the “Create Customer” flow step to generate a new customer in QuickBooks first and then capture the customerID returned from that step into your variable. Lastly, run a “Get customer by ID” flow step using your customerID variable and confirm that it returns a result, which verifies for us that the ID we are using matches an existing customer in QuickBooks and you are good to go. If you want, you can also run an “Update Customer” flow step here to make sure that all the customer data in QuickBooks is synced and matches the information you delivered from FileMaker. It is highly recommended that you use On Error flow steps to capture any failures that may have occurred when executing QuickBooks functions, and then delivering those errors back to FileMaker using “Execute Script” and “Stop Flow” steps to prevent unwanted changes and return issue details back to your database. You can also use the History tab in your flow to view all the request and response messages for every single step, which can be extremely beneficial when troubleshooting errors. Note: In the screenshot above I only show a single On Error trap as an example to save space, but you will want to ensure you error trap all QuickBooks flow steps to capture any issues. Creating a New Invoice Creating invoices via Claris Connect is still somewhat limited in the amount of custom data you can deliver to QuickBooks, but if the goal is reducing double entry you can definitely automate this process. Continue your previous flow from the customer steps above by adding a new step for “Create Invoice”. You will notice that the only options here are to enter the Customer ID, which is your customerQBID variable from before, and information for invoice line items. QuickBooks will automatically populate customer data on the invoice based on the Customer provided, but the line items can be a bit trickier particularly if you might have a dynamic number of potential lines all using various product/service categories. You can perform a simple sync by previously combining the amounts of all your line items into one total and providing a generic description from FileMaker such as “Products and Services”. Doing so allows you to add those values passed in from your trigger to the Line Item options here and create a simple invoice with the proper amount. Note: QuickBooks requires the QBID of an Item (product/service category) for any invoice lines, but unfortunately Claris Connect does not yet provide the option to query for accounts/items by name. In order to provide this information, you may need to use Intuit’s API Explorer or another method to retrieve the QBID’s of items you wish to use and store those in FileMaker so you can deliver them in your trigger. Currently Claris Connect does not support a dynamic number of invoice line items, so if you have more than one you will need to hardcode them in your flow step. You can still make this work by pre-populating variables for a set number of line items in your JSON package and then using “If/Then” flow steps to create invoices with various numbers of line items based on a count of the total. This can get somewhat messy though, so if possible you are better off combining invoice details into a single line item at this time. Be sure to end your flow by calling a script in your FileMaker database to return pertinent information such as the customerQBID and invoiceQBID. You will want to be sure and store these values on their related records in FileMaker for use on any subsequent syncs so as not to create duplicate data in QuickBooks. Conclusion It can be extremely rewarding to integrate your FileMaker solution with QuickBooks Online using the Claris Connect platform due to the speed and minimal coding requirements necessary. Although the flexibility may not be as complete as a native integration, for setting up a quick sync to automate tasks, eliminate double date entry, and reduce user error you could hardly ask for a more simple solution. Feel free to contact us if for any additional assistance or to discuss getting your QuickBooks system integrated with FileMaker using Claris Connect. Did you know we are an authorized reseller for Claris Connect? Contact us to get a competitive quote on a Claris Connect License. Download File Name* First Last Company Phone* Email* FileMaker Experience*New to FileMaker Platform Existing User of FileMaker Existing Developer of FileMaker Terms of Use I agree OPT-IN: I agree that I am downloading a completely free FileMaker application file with no strings attached. This database is unlocked, and I may use it for my business or organization as I see fit. Because I am downloading a free database, I agree that I should receive occasional marketing. I understand that I can OPT-OUT of these emails at anytime. Constant1 Afficher la totalité du billet
  7. Claris FileMaker 19 Overview A new and exciting version of FileMaker is here! 2020 marks over 35 years for the Claris FileMaker platform. A lot of innovation has occurred at Claris since the last FileMaker release. FileMaker Cloud, FileMaker Marketplace, and Claris Connect have launched, and Claris Nextgen is in the roadmap. In this article we will focus on the Claris FileMaker flagship product, specifically FileMaker Pro 19, FileMaker Server 19, FileMaker Go 19, and FileMaker Cloud. We discuss some of our favorite new features with articles, videos, and free downloads. With this release, it is clear that Claris FileMaker continues to be the leader in Workplace Innovation Platforms. What’s New? FileMaker Pro (no longer called Advanced) now includes Javascript Web Viewer Integration, Add-On Interface, Creating Your Own FileMaker Add-Ons, Claris Marketplace, Configure Machine Learning Models, Printing Page Counts, Dark Mode Support, and Layout Switching Shortcuts. FileMaker Go now includes Configure Machine Learning Models, NFC Scanning, Siri Shortcuts, HEIF image support. FileMaker Server includes FileMaker Card Window support in WebDirect, support for Windows Server 2019, Startup Restoration OFF by default, and improved reliability and performance. FileMaker Developer License (FDS) will be revamped to include Claris Connect. FileMaker Solution Upgrade Tool as Preview software. This is not intended to replace the FileMaker Data Migration Tool. Claris Connect launched in March 2020. FileMaker Marketplace launched in November 2019. FileMaker Cloud launched in October 2019. The EU rollout will come later this year. Claris FileMaker Pro 19 FileMaker Pro is no longer called FileMaker Pro Advanced and this marks the last annual release of Claris FileMaker Pro. Claris will adopt an Agile Development methodology that includes more rapid release schedules. Eventually, we expect Claris will name the product based on the year, i.e. Claris FileMaker 2021 next year. Perform JavaScript in Web Viewer You can now perform Javascript in a Web Viewer and have FileMaker scripts communicate directly. Each can call the other and pass in parameters. This means you can use your own or third party JavaScript libraries to add advanced user interface elements into your apps. See the new FileMaker JavaScript Web Viewer Integration in action as Devin Drake presents to you this powerful technology. Note: On Windows, the Web Viewer uses Internet Explorer 11 which has limitations and may require additional complexity to in order to support IE 11. Claris plans to move to Edge down the road. FileMaker Add-Ons FileMaker Add-Ons have been in the product since version 17 when inserting a Portal. Now, they are much more visible in Layout Mode on the left Objects Pane. The Add-Ons present are the same 11, (Action Items, Addresses, Attachments, Companies, Email Addresses, General Info, Inventory Transactions, Notes, People, Phone Numbers, and Topics), but now, you can create your own Add-On with the script step “Save a Copy as Add-on Package”. You can create your own Add-Ons and utilize the new Javascript Web Viewers to really take your Workplace Innovation Platform to the next level. Learn about Creating Your Own FileMaker Add-Ons as Isaac Harris provides a video walk-through and sample Add-On file for download. Claris plans to release Add-Ons down the road in the product and in the Marketplace. Claris Marketplace The new Claris Marketplace launched in November 2019, replacing Made for FileMaker (MFF). FileMaker 19 now displays a link to the Marketplace in the Create screen. You can expect to find in the future Add-Ons in the Marketplace to add to your applications later this year. We are expecting to see Kanban Boards, Calendars, Charting, Rich Text Editors, and more. All are features that are difficult to achieve in the native FileMaker client which leverage existing Javascript libraries via Web Viewers. There are great solutions for all needs in the Claris Community and Marketplace. The number of free and paid products is increasing each day in the Claris Marketplace, and we are excited to see what solutions these products can offer to FileMaker users of all experience levels. Configure Machine Learning You can now load a Core ML (Machine Learning) model and prepare it for use using the new Configure Machine Learning Model script step. You can create your own model you have trained yourself, or find one for free online. You can also purchase a Core ML model. Just drop it into a container, give a model name, pass parameters, and return the result. We expect a lot of innovation in customer applications in image recognition and more. See in action FileMaker Machine Learning Using CoreML as Aaron Kaiser demos how to set up a model. Check out Core ML models on GitHub too. Print Page Numbers If you would like to show the total page count on reports, this is now easier than ever. You can print Page X of XX by using the new PageCount symbol to print page numbers with total page count. Claris FileMaker Pro 19 Technical Specifications FileMaker Pro 19 is supported on Windows 10 Pro and Enterprise (64-bit only), macOS Catalina 10.15, and macOS Mojave 10.15. Note: there is no longer support for Windows 7. FileMaker Developer Subscription If you want early access to FileMaker versions, purchase a FileMaker Developer Subscription for $99/per year. The subscription gives you access to the pre-release version, the FileMaker Data Migration Tool, the FileMaker iOS SDK, and more. Once purchased, you can download the tools from your Claris Community account. NOTE: The FileMaker Developer Subscription is planned to be updated to a new program that includes Claris Connect, and current subscribers will automatically convert to the new plan. FileMaker Solution Upgrade Tool You can now patch a FileMaker application using the FileMaker Solution Upgrade Tool. The new tool is Preview software for the community that expands on the Save As XML feature released in FileMaker 18. See how the FileMaker Solution Upgrade Tool works as Sarah walks you through how to use. This is strictly a command line tool that leverages XML files for critical fixes to your solution. In most situations, you will still want to use the FileMaker Data Migration Tool when upgrading. FileMaker Go 19 FileMaker Go for the iPad and iPhone has all the features provided in FileMaker Pro, plus specific iOS features. You will need FileMaker Pro on the desktop to customize your application in FileMaker Go. The new version of FileMaker Go 19 is available in the App Store as a free download. NFC Readings You can now scan or stop scanning Near Field Communication (NFC) tags using FileMaker Go. Learn how NFC Tag Reading works in FileMaker Go as Devon Mason walks you through this exciting new feature. Siri Shortcuts In FileMaker Go 19, you can now create FileMaker scripts in the Shortcuts app allowing you to run Shortcuts or Siri voice commands. See how to set up FileMaker Siri Shortcuts with Andy Bowerman. High Efficiency Image File Format Inserting HEIF images on layouts and in container fields that can be viewed in macOS and iOS is now available. At times, iOS users have HEIF images turned on their iPad and iPhone when inserting images. This is now compatible. FileMaker Go 19 Technical Specifications FileMaker Go 19 is supported on iPads and iPhones running iOS 13.2. FileMaker Server 19 FileMaker Server is known for its ease-of-use and ability to run smoothly. The newest version focuses on WebDirect Window Card support, along with performance improvements and security updates. WebDirect FileMaker Card Windows With this release, you now have one of the most powerful and popular user experience tools available in FileMaker WebDirect. See how FileMaker Card Windows work by looking back at FileMaker version 16. Startup Restoration The new Startup Restoration feature is now turned off by default and enhancements are planned for the future. FileMaker Server 19 Technical Specifications FileMaker Server 19 is compatible with Windows Server 2019 Standard Edition, Windows Server 2016 Standard Edition, macOS Catalina 10.15, and macOS Mojave 10.14. If you’re on Windows Server 2012, it’s a good time to consider moving to FileMaker Cloud. WebDirect desktop browser support includes Safari, Microsoft Edge, Edge Chromium, Chrome, and mobile browser support includes Safari on iOS and Chrome on Android. Note: Supported clients include FileMaker Pro 18, FileMaker Pro 19, FileMaker Go 18, and FileMaker Go 19. FileMaker Cloud The new product called FileMaker Cloud was launched in September 2019 and can be purchased from your favorite FileMaker Reseller or direct from Claris. In addition, FileMaker Cloud Essentials was released in January 2020 for 5-10 users. FileMaker Cloud and Cloud Essentials are considered a new license type, to which our DB Services Licensing Specialists can help you transition. This is a great option versus deploying On-Premise for many customers–especially if you are new to the platform, need to replace your current server hardware, or are expanding to a more mobile or remote workforce! FileMaker Cloud plans to expand to the EU later this year. At this time, FileMaker Cloud doesn’t offer a native Schedule Manager like what is available for On-Premise. You can download our free FileMaker Cloud Schedule Manager to add this capability. Contact us if you would like help with setup, or for us to manage FileMaker Cloud Hosting for you. Note: FileMaker Cloud does require a separate user license for any consultant or developer you may work with. FileMaker Cloud for AWS was released in September 2016 and is now End of Life. Version 1.18 is the last supported version and can only be purchased till the end of 2020. Product support ends in January 2022. Summary The Claris FileMaker platform continues to be the leader in creating innovative, powerful custom applications for organizations all around the world and works seamlessly across Windows, Mac, iOS, and the Web. The release of the FileMaker 19 platform further solidifies FileMaker as the Workplace Innovation Platform leader with more frequent releases ahead. FileMaker Go gives the platform a competitive edge and this version continues to build off its strong foundation. Organizations can create innovative and rapid custom applications for iOS with great return on investment (ROI), and creating prototype applications on the iPad and iPhone is a matter of hours not months. FileMaker 19 is a great release and has features everyone can benefit from. We look forward to helping you build innovative custom applications using these new tools for desktop, mobile, and web. Contact DB Services at any time with any questions or needs with Claris FileMaker! Did you know we are an authorized reseller for FileMaker Licensing? Contact us to discuss upgrading your FileMaker software. Afficher la totalité du billet
  8. FileMaker JavaScript Web Viewer Integration The new FileMaker JavaScript Web Viewer Integration creates seamless communication between FileMaker and web viewers. This integration will allow for more efficient development of web viewers which will extend the functionality of FileMaker systems with features not native to FileMaker. The integration comes with a new script step called “Perform JavaScript In Web Viewer,” and JavaScript function, FileMaker.PerformScript(), both of which we will explore in this article. Performing FileMaker Script from JavaScript The ability to perform FileMaker scripts from JavaScript is fairly simple but does have some caveats. The function itself is FileMaker.PerformScript( "Script Name", "Optional Script Parameters"); There are some considerations when using this function: The JavaScript will not wait for the FileMaker script to complete. The function will not be available until the web page has finished loading. Web viewers now have a setting that needs to be enabled. That setting being “Allow JavaScript to perform FileMaker scripts” found in the Web Viewer Setup dialog. This function follows the Same Domain Policy, meaning this function will only work if the database and web app are hosted under the same domain. If they are not the browser will block the code. Performing JavaScript from FileMaker To perform JavaScript from FileMaker, call the new Perform JavaScript in Web Viewer script step. The parameters of the script step are: Object Name: The defined name we give the web viewer. Function Name: The name of the JavaScript function we want to run. Parameter: Any parameters we want to pass into our Javascript function. Some considerations: The JavaScript function’s return value is ignored. The script step will wait for the JavaScript function to return, if the JavaScript function enters an infinite loop the whole FileMaker solution will come to a halt. When executing the script step, there will be no way for a user to cancel the operation or perform any other operations. If the web viewer object is not visible the script step will not be executed. Once the script step is called and the JavaScript function runs, error handling will be done through the web browser. Any errors that occur in the FileMaker solution will be handled in the same way we do error handling now. Conclusion Web viewers are an incredible tool in FileMaker’s arsenal giving solutions ways of gathering and displaying information not native to FileMaker itself. The JavaScript integration now allows implementation of web viewers to be even easier by updating how to develop communication between the web app and FileMaker. Contact us if you need assistance with web viewers in your custom FileMaker application! Download File Name* First Last Company Phone* Email* FileMaker Experience*New to FileMaker Platform Existing User of FileMaker Existing Developer of FileMaker Terms of Use I agree OPT-IN: I agree that I am downloading a completely free FileMaker application file with no strings attached. This database is unlocked, and I may use it for my business or organization as I see fit. Because I am downloading a free database, I agree that I should receive occasional marketing. I understand that I can OPT-OUT of these emails at anytime. Constant1 Did you know we are an authorized reseller for FileMaker Licensing? Contact us to get a competitive quote on a FileMaker License. Download JavaScript Web Viewer Integration Please complete the form below to download your FREE FileMaker database file. Afficher la totalité du billet
  9. FileMaker Machine Learning Using CoreML Machine learning and artificial intelligence are rushing in the next era of computing by enabling machines to make decisions, rather than humans telling machines which decisions to make. Whether you need to classify objects in an image, parse speech into text, or get recommendations on what products to market next quarter, machine learning can be adopted to assist. Leveraging FileMaker’s machine learning capabilities on MacOS makes integrating artificial intelligence into your business easier than ever. Models 0x101 A predictive machine learning algorithm relies on a model—a set of black box functions that generate an expected output set based on an unknown input set. The model is created using a collection of training data with known inputs and outputs. For example, to create a model that identifies different types of dog breeds, you would train the model using a collection of photos for each dog breed. Once created, giving the model an image of any type of dog breed that was included in the training data would produce an output identifying the image’s breed. The first step in using machine learning in your FileMaker system is to either create or use an existing model. Apple provides a handful of CoreML models for image and text recognition. CoreML is Apple’s library that optimizes performance of on-device machine learning processes. Executing machine learning tasks on-device, as opposed to integrating with an online API, improves responsiveness and privacy. Models, No Assembly Required Apple also provides Create ML—an Xcode tool that makes creating a CoreML model effortless, with no code required. Once a model has been created using Create ML, getting it up and running with your FileMaker database takes only minutes. The Create ML tool can be started by opening Xcode and then selecting Xcode>Open Developer Tool>Create ML from the menu bar. Select New Document from the dialogue and then you’ll be asked to choose a template. For this demo, we’re choosing to work with an image classifier, but Create ML provides options for sound, motion, text, and data analysis as well. After selecting Image Classifier, give a name to your new project and click Next. Choose a location to save your project and once the project window is open, you’re ready to begin training your model. If You Give A Model an Image Next up, you’ll need to supply the model with a set of images for the training and testing processes. This demo will be creating a model to identify objects in the Caltech 101 dataset. You can download the image dataset yourself by visiting the Caltech 101 website. Included with the sample file is a model created using Create ML and this collection of images. With Create ML open, we select the 101_ObjectCategories folder for the Training Data section. This folder contains subfolders that each have a set of images to train the model. To begin the training, click the Begin Training button at the top of the screen. Once the training is complete, Create ML will produce a .mlmodel file that can be used in FileMaker. Loading the Model in FileMaker In usual FileMaker fashion, incorporating the model into your system is effortless—just drop it into a container field. Since this demo is using an image classification model, there’s also a container to hold the image to classify. Putting the model to use requires only a couple of script steps. The first script step sets the stage for loading the model into memory. Configure Machine Learning Model [ Operation: <operation> ; Name: <modelName> ; From: <modelContainerField> ] The first parameter specifies the operation, which can be either vision, general, or unload. Vision is used for image inputs and general is used for scalar input values. Unload frees the named model from memory. The second parameter specifies a name, which is used to reference the model in subsequent script steps. The last parameter specifies a container field from which to load the model. Compute the Model After the model is loaded, the next step is to use the ComputeModel function. This returns a result from processing the given input. There is a slight variation in this function based on which type of model is being used. Vision: ComputeModel ( <modelName> ; "image" ; <value1> {;"confidenceLowerLimit" ; <value2> ; "returnAtLeastOne" ; <value3>} ) General: ComputeModel ( <modelName> ; <name1> ; <value1> {;<name2>; <value2>;...<nameN>; <valueN>} ) For vision models, value1 is the input image container. To limit the results returned, confidenceLowerLimit can optionally be specified between 0.0 and 1.0. The results will be limited to classifications that have a confidence level above the specified value. The returnAtLeastOne parameter is used in conjunction with the optional confidenceLowerLimit parameter. If no results are returned with a higher confidence level than the specified limit and returnAtLeastOne is true, the first result will be returned. This technique can be used to always return only the first classification in the list by specifying a limit of 1.0. General models are similar but require the parameter name of the model as defined by the creator. They do not include the confidenceLowerLimit or returnAtLeastOne parameters. Multiple parameter-value pairs can be specified as needed. Unload the Model After using the model, it’s important to free the memory resources required to compute the output. The Configure Machine Learning Model script step supplied with the name of the model to unload is used. Configure Machine Learning Model [ Name: <modelName> ; Operation: Unload ] After the model is unloaded, you can continue with your script as needed. Conclusion Leveraging FileMaker’s machine learning capabilities will speed up time consuming tasks such as classifying images and transcribing speech; moreover, it can help with data analysis by providing predictive insights based on your existing data. Contact us today for assisting in adding machine learning to your FileMaker system! Did you know we are an authorized reseller for FileMaker Licensing? Contact us to discuss upgrading your FileMaker software. Download the FileMaker Machine Learning Using CoreML Database Please complete the form below to download your FREE FileMaker database file. Download File Name* First Last Company Phone* Email* FileMaker Experience*New to FileMaker Platform Existing User of FileMaker Existing Developer of FileMaker Terms of Use I agree OPT-IN: I agree that I am downloading a completely free FileMaker application file with no strings attached. This database is unlocked, and I may use it for my business or organization as I see fit. Because I am downloading a free database, I agree that I should receive occasional marketing. I understand that I can OPT-OUT of these emails at anytime. Constant1 Afficher la totalité du billet
  10. Siri Shortcuts in FileMaker Go As more and more businesses bring apps into their daily workflows, it is important to have fast and easy options for completing tasks while mobile. With FileMaker Go 19, you can execute your favorite FileMaker Go features with a voice command or single tap using Siri Shortcuts! Released with iOS12, Shortcuts introduced the ability to build intuitive and customizable Siri workflows using your favorite apps- with intuitive being the key word: nearly a third of smartphone users now use voice commands once a week (99firms)! Siri Shortcuts take you directly to the FileMaker features you need before you’ve even opened the app, eliminating waste from your workflow and letting you focus on the task at hand. Below we will demonstrate how to create Siri Shortcuts in FileMaker Go 19. Donate Scripts To make a FileMaker script available as a Shortcut, you’ll donate it from your Script Manager by right clicking on the script and selecting Enable Shortcuts Donation. Once a script has been enabled for donation, a microphone icon appears to the right of the script’s name, signifying its new availability as a Siri Shortcut. You’ll also need to enable the “Allow URLs to perform FileMaker scripts” in Manage–>Security–>Extended Privileges to allow this execution from outside FileMaker. Now, each time you load your FileMaker Go solution, these Shortcut-enabled scripts can be run with a tap or voice command! Simplify with Shortcuts With your FileMaker scripts donated, launch the Shortcuts app to construct a new tap or voice shortcut. Here, FileMaker’s powerful scripting engine is augmented by external commands and can be integrated into the workflows of any other Shortcut-enabled iOS app. Add your favorite FileMaker functionality to a Siri Shortcut. Command and Control From Shortcuts, search for ‘FileMaker’ in the top left, then add your FileMaker solution and pick from any of the scripts you’ve enabled for donation. Your new Shortcut is now accessible as a voice command or an icon that can be added to your Home screen! Use voice commands to launch FileMaker scripts from Siri Shortcuts! Conclusion Siri Shortcuts expand FileMaker Go’s functionality by bringing scripts out of your app and into your life, letting you reimagine FileMaker Go development and workflows. Bring iOS advances to FileMaker and your business with Siri Shortcuts in FileMaker 19 Go! If you’d like assistance setting up Siri Shortcuts for your FileMaker Go app, please don’t hesitate to contact us! Did you know we are an authorized reseller for FileMaker Licensing? Contact us to get a competitive quote on a FileMaker License. Download File Name* First Last Company Phone* Email* FileMaker Experience*New to FileMaker Platform Existing User of FileMaker Existing Developer of FileMaker Terms of Use I agree OPT-IN: I agree that I am downloading a completely free FileMaker application file with no strings attached. This database is unlocked, and I may use it for my business or organization as I see fit. Because I am downloading a free database, I agree that I should receive occasional marketing. I understand that I can OPT-OUT of these emails at anytime. Constant1 Afficher la totalité du billet
  11. NFC Tag Reading in FileMaker Go Near Field Communication is a technology developed in the early 2000s that allows for contactless communication between devices using radio waves to transfer data. NFC can share information between two active devices, such as two smartphones sharing contact details, or between an active device and a passive device, such as a smartphone reading a NFC tag embedded in a poster. NFC tags are tiny, inexpensive chips that contain a small amount of memory, a radio chip, and an antenna. They can be visible or hidden in almost any object, thus allowing common household items to turn into “smart objects” easily. Although technology already exists that lets us share data using radio waves, NFC is specifically designed to share information securely and faster than earlier methods (Bluetooth, RFID, QR codes, etc). As cited by the NFC Forum, there are over 2 billion NFC-enabled devices worldwide. From making mobile payments at the grocery store to scanning boarding passes at the airport, NFC has rapidly become a mainstream technology in our everyday lives. The video below demonstrates how FileMaker Go makes it easy to incorporate NFC by introducing a new script step to read these tags. NFC in Action To set up a test case for NFC, I acquired a pack of NFC tags that worked at a frequency of 13.56MHz. I programmed mine using a free app called NFC Tools which I downloaded from the App Store. It took less than a minute to associate a serial number with my specific NFC tag, and I was able to easily reconfigure the tag to associate other test data. My iPhone XR acted as an active device and through the use of FileMaker Go 19, my serial number was scanned, passed as a parameter, and set in a field when my iPhone was placed no more than 4 inches away from the tag. Currently, only iPhones XS, XS Max, and XR equipped with the latest iOS software can read and encode NFC tags without an additional application. iPhones 7 and 8 are limited to reading NFC Tags with the help of an additional scanning app. Note that this capability will not work on iPads. Introducing “Configure NFC Reading” Script Step Be sure to download the file at the end of this article to follow along with the demonstration. FileMaker Go 19 added the script step “Configure NFC Reading” to read NFC tags. Configure NFC Reading [ Action: Read; Script: <script name>; Parameter: <param calc>; Timeout: <secs calc>; Multiple: <calc> ] In the Configure NFC Reading step, users choose between “Read” or “Cancel” to bring up the pre-made Apple UI that instructs users to hold devices as close as possible to the NFC tag. The Script is automatically invoked once the reading has either succeeded or cancelled and comes with an optional parameter to pass. The Timeout exits the reading after the specified number of seconds and relieves the user of manually finishing the scan. Lastly, the Multiple parameter should be used if more than one NFC tag needs to be read in one session. The cog wheel will bring up specifying the script, timeout, and continuous reading features. All three will be unchecked initially. Supported Formats Because NFC tags can be programmed in several ways, FileMaker Go will support four of the most common formats: Plain Text URL XV Card “Smart Posters” which are like QR Codes– a combination of text and URL. Example Script To start my script, I checked to see if the user was in the correct platform, as this script step is only compatible with iOS systems. If [( Get(SystemPlatform) <>3 ] Show Custom Dialog [ "User needs to perform function on an iOS System."] End If Next, I used the Configure NFC Reading script. This activated the tag scan, and once the tag had been read, it called upon the “Save Scanned Data” script which pulled the serial number of the tag into a field on my layout. Configure NFC Reading [ Action: Read; Script: "Save Scanned Data"] I attached this script to a button on my layout made specifically for an iPhone. The end result passes the serial number associated with the tag as a parameter to a field on the layout. Once the data is saved as a parameter, it can be used in whatever capacity to perform the specialized functionality your app requires. Whether that is keeping track of Euchre scores or counting attendees at a mandatory event, NFC’s versatility is one of its biggest assets. This was all done without the need for wifi, manually pairing devices, and if there is a mistake, the NFC tag is easily reprogrammable to show the correct data. Conclusion NFC allows businesses to talk to customers in innovative ways. Every endpoint acts like a personalized channel to engage potential customers and create relationships. It essentially allows any manufactured product, from potato chip bags to NFL jerseys, to become smart products that can share information with customers by simply hovering smartphones near a product. FileMaker Go is simplifying the process of using NFC technology by enabling your business to create personalized channels and ultimately grow your customer base. Contact us today to find out how NFC can expand your business! Did you know we are an authorized reseller for FileMaker Licensing? Contact us to get a competitive quote on a FileMaker License. Download NFC Tag Reading in FileMaker Go Please complete the form below to download your FREE FileMaker database file. Download File Name* First Last Company Phone* Email* FileMaker Experience*New to FileMaker Platform Existing User of FileMaker Existing Developer of FileMaker Terms of Use I agree OPT-IN: I agree that I am downloading a completely free FileMaker application file with no strings attached. This database is unlocked, and I may use it for my business or organization as I see fit. Because I am downloading a free database, I agree that I should receive occasional marketing. I understand that I can OPT-OUT of these emails at anytime. Constant1 Afficher la totalité du billet
  12. Creating FileMaker Add-Ons With the release of FileMaker 19, Claris International, Inc. has introduced the ability to create add-ons, allowing developers to package a set of features that can be distributed to other FileMaker solutions. While installing custom add-ons currently must be started outside of FileMaker, add-ons can currently be created in FileMaker Pro using the preview script step Save a Copy as Add-on Package. As with all preview software, this feature is subject to change. Let’s take a look at how to create your own add-on. A Few Things to Note Before Diving In Before we begin making our add-on, please note The file we use to create the add-on needs to have a unique file ID. Creating a new file generates a unique file ID, so we recommend creating a new file for each new add-on. The name of the file will be the name of the add-on. You can change the name afterwards, but it’s simpler to have the file be the correct add-on name. Add-ons will ignore security features but will retain any sample data in the file. Once the add-on is installed in the application it will be available to everyone using the app. Creating an Add-On File As stated above, we recommend creating a new FileMaker file to ensure you have a unique file ID and to property name the add-on. Once you have created and named your file create a layout based on a table occurrence that you want to import into the new file. Name the layout __FMAddonTemplateDirectives_en (“en” can be replaced with any ISO 639.1 language code). The layout will act as place to create the add-on content, but the layout itself will not be part of the add-on. Adding Drag and Drop Content Almost everything in the FileMaker file will be included in the add-on when the package is created, including all scripts, layouts, tables, table occurrences, etc. in the file, meaning that you don’t need to put everything on the __FMAddonTemplateDirectives_en layout. But there are special steps to tell FileMaker what layout objects you want added to the layout that a developer drag and drops your add-on onto. On the __FMAddonTemplateDirectives_en layout, add all layout objects that you want created when the add-on is drag and dropped. Once you have all of the layout objects positioned, anchored, and styled properly group them all in one single group. This should be the only group you make on this layout. Do not name the group. The add-on will include any objects in this group when the add-on is dragged onto the layout. Anything outside of the group will NOT be included in the add-on. (Creating add-ons that automatically create a relationship to the target file’s current table require more advanced setup.) Packaging The Add-On Now that the add-on is ready to be packaged for deployment, we need to run the “Save a Copy as Add-on Package” script step with the following settings and parameters. Pass in the window name of the add-on window. Replace UUIDs: On. The UUID is what FileMaker uses to show unique add-ons in the Add-on Install tab. If two add-ons have the same UUID, only one will be shown. If you want to have different versions of this same add-on, set this step to On Running this script will create the add-on. It will include all valid parts of this file into the package and save it in the AddonModules folder, which will open up. Distribution To make this add-on available for FileMaker for your development, simply quit FileMaker. Then start it back up. This add-on will be available in the Add-on Tab of layout mode. To make this add-on available for another developer, simply go to the AddonModules folder, zip your custom add-on folder, send the zip to them, and ask them to place the unzipped folder in the AddonModules folder on their computer. The AddonModules folder is at: Mac: /Users/username/Library/Application Support/FileMaker/Extensions/AddonModules PC: Users\username\AppData\Local\FileMaker\Extensions\AddonModules Installing Add-Ons To install an add-on in your FileMaker solution ensure you have the folder of your custom add-on in your AddonModules folder and that you’ve restarted FileMaker Pro after adding the folder. Next, navigate to the layout in your FileMaker solution in which you want the add-on to appear. Enter layout mode and expand the left menu layout object panel. Click on the “add-ons” tab. Click +, select an add-on, and click Choose. The add-on will appear in the add-ons list and is available to place on any layout. Simply drag the add-on from the list onto the layout. Conclusion Using add-ons makes installing features in your custom FileMaker solution faster and easier than ever before. You can install pre-made add-ons, or create your own, saving time and effort. Check out our popular Google Calendar Integration demo file that we packaged as an add-on for this article’s sample file, and contact us if you would like help creating your own add-on. Did you know we are an authorized reseller for FileMaker Licensing? Contact us to discuss upgrading your FileMaker software. Download the Creating Add-Ons Sample File Please complete the form below to download your FREE FileMaker database file. Download File Name* First Last Company Phone* Email* FileMaker Experience*New to FileMaker Platform Existing User of FileMaker Existing Developer of FileMaker Terms of Use I agree OPT-IN: I agree that I am downloading a completely free FileMaker application file with no strings attached. This database is unlocked, and I may use it for my business or organization as I see fit. Because I am downloading a free database, I agree that I should receive occasional marketing. I understand that I can OPT-OUT of these emails at anytime. Constant1 Afficher la totalité du billet
  13. FileMaker Solution Upgrade Tool Upgrading your custom FileMaker application used to require migrating data or manually following a complex set of instructions which would take quite a bit of time to complete. Now FileMaker has released a command line tool that will upgrade your custom application in a matter of minutes. At the moment, the FileMaker Solution Upgrade Tool is considered to be a preview software and is subject to change. In the video below I will walk you through the process of upgrading your FileMaker custom app to the newest version using the new FileMaker Solution Upgrade Command Line Tool. New Privilege A new extended privilege has been created for this process. In order to run the patch file the user must have a full access account or at least have the fmupgrade privilege. If the patch file is an encrypted xml file, then you will open up the source file first and the provided account’s suffix of the fmupgrade privilege extension will be used as a decryption key for the patch file. An example of this would be creating an upgrade passkey (such as MyPass123) and appending it to the end of the privilege extension – fmupgradeMyPass123. What the Tool Transfers Over It’s important to know that this tool transfers over everything except for your FileMaker data. You will still need to use the data migration tool if you’re planning on doing that. You can find the article including the download for our FileMaker Data Migration Companion here. Creating the Command Once you’ve downloaded the command line tool, you’re ready to start creating the command. The first step you want to take in creating your command is generating the GUIDs for versions 01 and 02 of your applications, which will look something like this: The generateGUIDs command is important because it ensures that all objects have a unique ID. Once you’ve generated the GUIDs, you will then save the newly generated copies of the files as XML. It is important that you use a diff tool when creating your patch file. In my video I show you which tool I use online for comparing my XML files. For reference, the skeleton of the patch file should look like this: You want to wrap each change in <AddAction></AddAction>. In the above example, I have wrapped a value list between the “<AddAction>” tag. Another tag that you can utilize is the <DeleteAction> tag, and as the name implies, this tag allows you to remove objects from your solution. After you’ve created the patch file, you will run a set of commands that look similar to this: If you’ve successfully upgraded your file you will see the output, “Patch File Applied”. Best practice is to test the patch file on a copy of your original FileMaker solution to ensure that the upgrade will work. Once you’re confident in your patch file, you as the developer can run the command to upgrade the first version of the customer’s app or you can wrap the tool and the patch file into a batch script and distribute this to the customer. Conclusion The release of the FileMaker Solution Upgrade Tool is a welcome addition for both developers and clients. Now, upgrade your FileMaker app takes minutes and applying any code changes is an automated process. Contact us if you need assistance with upgrading your custom FileMaker application! Did you know we are an authorized reseller for FileMaker Licensing? Contact us to get a competitive quote on a FileMaker License. Download File Name* First Last Company Phone* Email* FileMaker Experience*New to FileMaker Platform Existing User of FileMaker Existing Developer of FileMaker Terms of Use I agree OPT-IN: I agree that I am downloading a completely free FileMaker application file with no strings attached. This database is unlocked, and I may use it for my business or organization as I see fit. Because I am downloading a free database, I agree that I should receive occasional marketing. I understand that I can OPT-OUT of these emails at anytime. Constant1 Afficher la totalité du billet
  14. Surveys for Success: The Glioblastoma Foundation DB Services has been proudly giving back to the community for years. Now we are partnering each quarter with a charity to donate for each survey we receive! Our new Surveys for Success program is our way of saying thank you to our clients for filling out our surveys and to also let you know how we are paying it forward. We are donating $10 for every survey that our clients fill out. Our goal for Q2 is to get at least 100 surveys back so that we can donate $1,000 to The Glioblastoma Foundation. Glioblastoma is one of the most aggressive and deadly forms of brain cancer, and The Glioblastoma Foundation seeks to transform care and treatment for the disease. The DB Services family is impacted by this disease personally and therefore we chose The Glioblastoma Foundation as this quarter’s charity. Our donations would not be possible without the help of our amazing partnerships and for that, we thank you! Each survey we receive is an additional donation towards The Glioblastoma Foundation. Your feedback now can positively impact others. You can help by simply filling out our surveys and together we can help others! Afficher la totalité du billet
  15. Claris Connect Utilities Claris Connect is a great tool to help organizations automate workflows, integrate their digital services, and reduce user errors. Ultimately, this saves a lot of time! A 2017 Global study estimated that workers lost 69 days per year to administrative tasks. Organizations of all kinds are prioritizing automation to stay competitive, improve productivity, and increase employee satisfaction. If you haven’t already, be sure to check out our overview of Claris Connect. In this article, we’re looking at Claris Connect Utilities. Think of utilities as powerful connector elements for your flows. You can use them to re-format the data you get from apps, add business rules, or just make your flow easier to manage as you build complexity. In this article, we’ll tour the utilities offerings and demonstrate two flows: one to call an API for current exchange rates and post an alert when rates are favorable, and another to read the text of a PDF email attachment and determine if the document should be forwarded to another party. A Closer Look at Utilities Currently, Claris Connect offers 13 utilities, shown below. Within each utility is a selection of actions, and in some cases, triggers. We’ll go through each one to highlight how to they can be used in a flow. I’ll go a little out of order here, starting with Variables, then highlight some special Utilities at the end: Variables Calculations Cryptography Dates Documents Images Text Lists FTP & SFTP Approvals Schedules Webhooks Variables Variables may be the most familiar tool to developers. There are some significant differences between how variables are handled in Claris Connect compared to FileMaker. For starters, you don’t have to store results of previous action steps in a variable. When selecting inputs for a new Action, If-Then, or Repeat step, you can expand any previous step to view and select its results, and even use the search feature to find what you are looking for: However, you may still find it useful to store certain results in a variable. Previously defined variables are always at the top of your selection options— not in chronological order with the flow steps— making them even easier to find. And you can redefine the value of a variable as you progress through the flow, just as you would in a FileMaker script. Variables have an important additional trait: this is the only utility that lets you concatenate text. Always be sure to test your flow steps as you go, even the very simple ones. Without test result data, you won’t have access to that step’s output as you craft your flow. Calculations This is your calculator and then some. The actions Add numbers and Subtract numbers can be performed on two numbers only, whereas Multiply and Average are performed on a comma-separated list. With Return random number, the result is a whole number between (and including) the two values you specify. This differs dramatically from FileMaker’s Random function, which returns a decimal value between 0 and 1. For most of your calculations, you’ll want to use Calculate expression. This lets you construct a mathematical expression using parentheses, operators like +, *, and ^, and other functions like floor, sqrt, abs, and PI. The syntax is based on Java Math, but always test your results. Not all methods are available in Claris Connect. Cryptography This utility has 3 actions. Hash generates a hash for a text string, which is useful for checking whether stings are identical, and, as the utility name implies, encrypting! HMAC creates a hash-based message authentication code using a key. Both functions require a hash algorithm (MD5, SHA1, or SHA256) and an encoding parameter (Base64 or Hex). Finally, the UUID action generates a universally unique identifier. Dates This is actually more like a “Dates and Times” utility, because many of the options work with timestamp data, instead of simple dates. Get current date returns the current timestamp in YYYY-MM-DD HH:MM:SS format. You can use Add date or Subtract date to offset a timestamp in increments of years, months, days, weeks, hours, minutes, and/or seconds. Note that Days between dates returns a whole number of days, so choosing parameters that are different times on the same day will return 0 days: Format date currently offers 16 date formatting options, including ISO and human-friendly text strings, to easily send date and time information to any app you’ve connected to Claris Connect using that app’s date formatting requirements. Documents Documents has two main kinds of actions: Extract text actions and Convert actions. Extract text actions pull text from .pdf, .doc, .docx, .png, .jpeg, or .rtf files, while Convert actions transform JSON to XML to CSV in each direction. Images This utility pulls metadata from an image, which you specify as a url. Get image location returns GPS data if available. Get image size returns the megapixels, height and width, and file size. Get image file information returns the file name, type, and extension, as well as the MIMEType and compression. Finally, if the information is available, Get camera settings returns a wealth of information about the camera settings, including the make and model of the camera, shutter speed, flash, and more. Text This offers some expected formatting choices like Lowercase and Title case, but a lot more, too. Use the Text Utility to: generate random passwords based a set of requirements (length, necessary capital letters, special characters, etc) generate a random hexidecimal by specifying the byte length encode/decode Base64 isolate the domain in a url or email use a Regular Expression to parse text Replace pattern, just like the FileMaker Substitute function and more Remember that you don’t use the Text Utility to combine existing text, but rather to manipulate text you already have from previous flow actions, or generate random strings. Lists Most actions in the List Utility can be performed on a comma-separated list or on an array. Use the List Utility to: merge or reverse lists return the maximum or minimum value in a list that contains only numerical items get element by a zero-based index remove duplicates convert a list to text (and vice versa) by specifying a separator get the number of elements in a list add, remove, or replace a value in a list, specifying position as a zero-based index FTP and SFTP These utilities have the similar action options, such as uploading or downloading a file, getting directory contents, and deleting a file or folder. You connect your account much in the same way you do when you first connect an app to Claris Connect. Once you set it up, your credentials are saved for future use across flows within the same project: Approvals Claris Connect is especially unique in its Approvals offering, which is built right into the platform. The overview of Claris Connect highlights this feature in the demo video. Without configuring any email settings or other account information, you can create an approval workflow simply from the New approval action. Once your approval requests are out in the world, you can manage them from the Approvals area of Claris Connect, separate from the flows that created them: Schedules The Schedules Utility can be used as a flow trigger, not just an action. You can think of this like a FileMaker server scheduled script. A scheduled flow can run every hour, day, week, or month. You can also create a custom schedule using a cron expression. Schedules also has two action options: Wait for a period of time, and Wait until a specified time. You can use these actions to pause your flow for up to one week. Webhooks Webhooks let you extend Claris Connect even more. Like the Schedules Utility, you can use a Webhook as a trigger to start a flow. You can also use this utility inside a flow to reply to the initial trigger with JSON data, and to make HTTP Get, Post, Put, and Patch requests. In the video, we show a scheduled flow that queries an exchange rate API, uses the Calculation Utility to calculate the new price of a foreign product, and alerts a Slack channel if prices are favorable. In Conclusion Claris Connect comes with a broad toolkit of both Apps and Utilities. Together, these features allow you to extend the services you already use, in real time, to automate your workflows and make your organization more efficient and effective. Contact us to see if Claris Connect is a good fit for you, and how you can make the most of what it has to offer. Did you know we are an authorized reseller for Claris Connect Licensing? Contact us to get a competitive quote on a Claris Connect License. Afficher la totalité du billet
×
×
  • Create New...