Jump to content

Blogs

 

Claris Connect Overview

Claris Connect Overview Claris Connect, the latest product from Claris International, Inc., is a “no-code” platform that allows organizations to quickly connect multiple cloud services together like QuickBooks Online, Box, Gmail, etc. to build high-value business processes. It is the result of Claris’ acquisition of Stamplay, an Italian startup that notably won a contest to make the best use of Visa’s new APIs. Perhaps the best way to describe Claris Connect comes from Stamplay’s cofounder Giul
 

Claris Connect : la nouvelle plateforme d’intégration/orchestration

Claris a officialisé aujourd’hui la sortie de sa plateforme d’intégration et d’orchestration : Claris Connect. Lors de la DevCon 2020, Brad Freitag (@bradfreitag), CEO de Claris International, annonçait le rachat par Apple/Claris de la startup italienne Stamplay. Quelques mois plus tard, Claris Connect est né ! Cette plateforme permet de créer et d’automatiser des flux […] Cet article Claris Connect : la nouvelle plateforme d’intégration/orchestration est apparu en premier sur 1-more-thing. &

fabriceN

fabriceN

 

GetFieldName Revisited

Long time readers of this blog will be familiar with the following scenario — An ExecuteSQL code example is given, e.g., ExecuteSQL ( " SELECT SUM ( net_amount ) FROM cc_transactions WHERE batch_date = ? AND batch_region = ? AND card_type = ? " ; "" ; "" ; $theDate ; $theRegion ; $theCard )… Continue reading GetFieldName Revisited Afficher la totalité du billet
 

Virtual Portal, part 2

Demo file: virtual-portal-v2.zip (requires FM 18 or later) This is a quick follow up to the Virtual Portal article I posted the other day. As you may recall, the objective was to use virtual list to display disparate entities in a portal… …via an array like this… …which was auto-generated via a Hide Object calculation… Continue reading Virtual Portal, part 2 Afficher la totalité du billet

FileMaker Hacks

FileMaker Hacks

 

Server Side Related Record Duplication

Knowing how to take advantage of Server Side scripting within FileMaker is quite critical when you want the best performance possible. Of course, it makes total sense that you'll get the best speeds when working with the data where it's most accessible. The trick with creating scripts which will also work on the server side is being very specific with the context of things. There's also the very important choices of which method you're going to use. In 2018 I covered a method using a dedicated
 

Virtual Portal

Demo file: virtual-portal.zip This is a follow-up to last month’s article on virtual list, and this time we’re going to explore a way to use virtual list in a portal. Imagine you have built a system where a Company can be a parent of a Mill, Refinery, Estate, or another Company. Each of these entities… Continue reading Virtual Portal Afficher la totalité du billet

FileMaker Hacks

FileMaker Hacks

 

FileMaker Shopify Integration

FileMaker Shopify Integration Shopify is used by more than a million businesses in over 175 countries, including Nestle and Staples, making it one of the leading e-commerce companies in the world. By integrating FileMaker and Shopify, you have the ability to easily create, update, and delete nearly all aspects of your online business straight from your FileMaker system. Running Shopify from your existing FileMaker solution can save you time and money by eliminating the pain of double data entry

DB Services

DB Services

 

Creating more gender-inclusive applications

Photo by Plush Design StudioCreating more gender-inclusive solutions Where we discuss what simple things can be done in an application or database to improve gender inclusivity. As a FileMaker developer, I create databases that are designed to store various kinds of data on a daily basis, for a lot of clients in very different fields of work ; one of the most common modules I usually develop is a “Contacts” module, where my clients can enter the info they have on their own clients, for example

Marina Syhanath

Marina Syhanath

 

Multiple Worksheet Excel Exports

When someone asks a simple question like "How can I make FileMaker export a second worksheet in Excel?" The method you use to achieve this may not be immediately apparent. Especially if you've not worked with other programming languages like Python. Rest assured, however, you can certainly solve most any FileMaker problem as long as you're willing to take a little journey into the land of other tools. And, it's probably not as scary as you think it is. Yes, FileMaker is nice and comfortable, bu
 

Dark Mode Theming in FileMaker

When "dark mode" finally creeps into your operating system, you know it's time you consider the trend and possibly adapt your FileMaker user interface as well. Although, "light mode" is still perfectly acceptable too! In this video, I walk through some of the tips and tricks I use in order to style a FileMaker user interface into a "dark mode" theme. I cover topics such as where and how to find colors, how to deal with grid settings and how to generally convert a light theme into a dark one. I
 

FileMaker Cloud Schedule Manager

FileMaker Cloud Schedule Manager Claris International, Inc. has recently released two new products: FileMaker Cloud and FileMaker Cloud Essentials. Both platforms wrap FileMaker Licensing and Cloud hosting into one simple, annual price. However these products introduce an important update: FileMaker ID (FMID). FileMaker ID is an integrated sign-on system that will allow access to all your files hosted on FileMaker Cloud, and requires all users and developers to create their own unique IDs. In

DB Services

DB Services

 

Automating emails using FileMaker 18’s Send Mail script step

As FileMaker developers, it’s common practice to need to contact the client records stored in the database, often scheduled daily, or weekly, or by a specific event. Without FileMaker’s ability to automate emails, this could become very time consuming. This blog post will cover the essential scripting techniques required to save time by automating emails and optimize communication with clients by attaching files. The Send Mail script step Right off the bat, the most important thing t

MainSpring

MainSpring

 

FileMaker Cloud Essentials

Introducing: FileMaker Cloud Essentials On January 22nd, 2020, Claris International, Inc. announced the release of FileMaker Cloud Essentials. This product is the latest innovation by Claris, and is another step forward towards the vision of becoming a “Cloud-First” Workplace Innovation Platform. The bundling of FileMaker licensing and hosting together for an annual price allows for organizations to quickly and easily create a custom application without the hassle of server setup and maintenanc

DB Services

DB Services

 

Pre vs. Post Script Triggers

Occasionally, you hit certain issues within FileMaker development where you're just stumped as to why you can't do something. Let's take a super simple example like being able to show and hide a button based on having selected a given portal row. How do you know when the user is within the portal? How do you know when they've left? Think it's easy? Try to solve this issue without watching this video first. You'll quickly find out, that because of how FileMaker's "event model" works, known as sc
 

Virtual List Simplified

Demo file: virtual-list-simplified.zip Note 1: The example in today’s article and demo file is intentionally very basic. Note 2: The demo is self-populating to keep the data current, so the values you see in the screen shots will not exactly match those you encounter in the demo. Recently I had the pleasure of discussing virtual… Continue reading Virtual List Simplified Afficher la totalité du billet

FileMaker Hacks

FileMaker Hacks

 

Dynamic Data Display

When you need to display data which is dynamic by nature, it tends to boil down to who's viewing the data and how do they need it presented. There's typically more than one way to solve the same problem and knowing what your options are helps you make a good decision when it comes to displaying that data. In this video, I showcase what I would consider are the top three methods of displaying dynamic data. Starting with the easiest method first, we talk about how to make things easier by using a
 

FileMaker Squarespace Integration

FileMaker Squarespace Integration Squarespace is one of the largest all-in-one website building and hosting providers with $300 million in total revenue in 2017, and is currently hosting over 350 thousand websites. This makes Squarespace a useful tool to expand your business by starting a professional looking website. And when you add FileMaker to the mix, you can streamline the process of dynamically showing data from your FileMaker app on your Squarespace website. Custom Code with Squaresp

DB Services

DB Services

 

I Once Was Lost, But Now Am Found: InspectorPro 7 Global Search

When I am working in the Bay Area, I often carpool to Beezwax’s Cupertino and Oakland offices with Vince Menanno, the creator and lead architect of InspectorPro. Over two years of commuting, I have been bugging him to add global search to InspectorPro, so FileMaker developers can search elements across the entire DDR for any […] Afficher la totalité du billet

vincenzo

vincenzo

 

UI Searching

As with all software projects, one of the biggest prices you'll ever pay is the accumulated technical debt. It's a cost which starts as soon as you make the choice to simply write a new script with every new feature you add into your FileMaker solution. Thus, the trick with creating something which is easier to manage is to simply decide to limit the number of things you create. So, what does one do when you've made that decision? Well, you focus on using the available toolset, using great orga
 

List View Grouping Indicators

There are all kinds of methods for using indicators within FileMaker. We have multi-segment button bars, using the Hide calculation on any number of layout objects and, of course, there's simply using text alone to indicate something. In one of my more recent projects, I needed to group duplicates together. While normally you'd want to rid your system of duplicates, this particular use case actually wanted them retained as an indication of importance or urgency. So, what was really needed was a

FileMaker Magazine

FileMaker Magazine

 

Table Of Contents for FileMaker Hacks

As 2019 draws to a close, I am mildly astonished to note that FileMaker Hacks is now nine years old. As promised in my recent conversation with Jeremy Brown, and in response to a number of  reader requests, here, for the first time, is a comprehensive table of contents (as of December 2019). While some… Continue reading Table Of Contents for FileMaker Hacks Afficher la totalité du billet

FileMaker Hacks

FileMaker Hacks

 

Des sauvegardes périodiques sans FileMaker Server (5)

Pour clore notre série d’article concernant la mise en place de sauvegardes périodiques sans FileMaker Server commencée par une réflexion sur les besoins auxquels on veut répondre, je vous invite à regarder la construction des chemins de sauvegardes. Notre objectif va être de rendre nos différents scripts plus lisibles mais aussi plus facilement modifiable si […] Afficher la totalité du billet

MagalieJ

MagalieJ

 

Automating FileMaker Imports

Importing data may be a very common task for some of your FileMaker workflows. Of course, not all data is going to come from the wonderful world of an online API. Some software just doesn't make its data available through the Internet. So, what you often need to do is get hold of the import file and then create the script. But, what happens if your data for import is in some obscure location and may be hard for the user to find? Well, in that situation we want to work with as many known values

FileMaker Magazine

FileMaker Magazine

×
×
  • Create New...