Welcome to our community, full of great ideas on developing your FileMaker solutions effectively,
for peer-to-peer support of the FileMaker Platform and related products and services.
The FileMaker Let function is your tool to make a calculation readable, well formatted and easy to debug. Let us discuss how it can be used.
The post Like a Boss: Let us Discuss the FileMaker Let Function appeared first on Geist Interactive.
View the full article
FileMaker Kanban is the latest tool that offers familiar functionality for users and flexibility for the developer. It offers great functionality and organizes your data visually into lanes and cards.
The post FileMaker Kanban: Organize Your Data appeared first on Geist Interactive.
View the full article
[ Edit: 3/16/2016 - With the help of some other people, we have been able to recover, or recreate some of the original images from original thread. ]
Security is always a big topic when it involves data, or people, or possessions. Recently, over on the FileMaker Community, there was a very beneficial discussion regarding security. Unfortunately, that discussion was the victim of a necessary action...and was deleted. It was deleted, because the discussion was tied to a video that, as was det
Forums are a great way to get technical advice for FileMaker but for some reason, many people don't think they have to be nice in the electronic world. I was raised to say "please" and "thank you" and that has translated over to the internet for me. But, other folks think the anonymity of cyberspace is an excuse to be a jerk. Some posters are outright offensive and others will just leave snide responses like, "that wasn't much help". News flash! People on the internet are real and you should be
Free webinar introducing Karbon our free application framework for building ambitious custom business applications. If you are interested in using the FileMaker Workplace Innovation Platform at a high level you'll probably want to see what we have cooked up.
The post Karbon Webinar – Getting Started appeared first on Geist Interactive.
View the full article
I've always wondered how many FileMaker dialogs you can have open at once, or more specifically, how many can you "string" together before hitting the limit, if there is one. So, though a little trial and error, I set out about trying to find the path to the most dialogs, and here is what I came up with…
Read the Full Article Here…
In this article I will demonstrate a very nice way to format a portal using conditional formatting. This method is suitable for portals whose underlying relationship is sorted by a grouping/category field - similar to if it were like a sub-summary report. The easiest way to explain it is to just get stuck in with an example, so here we go....
Read the Full Article Here…
When writing a script to carry out a particular task, ask yourself what conditions need to be true for this script to run properly. Sometimes, a script will do something which can potentially fail, and cause a cascade effect or errors, IF the initial conditions were incorrect. It is always a good idea to check for suitable conditions before doing anything in the script…
Read the Full Article Here…
In part two, I demonstrated how to implement the basics of the join table solution in FileMaker. While the solution works fine as an illustration for join tables, it lacked many of the basic interface features that would make it a usable solution. In part three, I will show how to implement some of these features, namely the following: Better selection of a Student for an Enrollment, Deletion of Enrollments & Prevention of “over-enrolling” a course…
Read the Full Article Here…
The Replace Field Contents command/script step is a very powerful tool for updating field values across records in your found set. This article goes into depth about the use of this command, some of its benefits, and some of the potential pitfalls you need to be aware of…
Read the Full Article Here…
Part two carries on from where Part one left off. This article outlines the construction of a basic join table solution from woe to go…
Read the Full Article Here…
FileMaker provides us with the ability to create related records directly from a portal. This is a great and easy way to generate records without the need to script the process, and for that reason it is a popular technique among both new users and Developers alike. This article extends this concept further and suggests various user interface improvements for making data entry in this method more user friendly…
Read the Full Article Here…
Perhaps one of the most asked questions that I see asked on FileMaker Forums is in regards to join tables. While some users have an understanding of what they are, they may lack the FileMaker skills to implement them. Others are unfamiliar with the concept altogether, but will explain their real word example. Usually it is a prime candidate for a join table. This article provides a real world example that will give you an understanding of why join tables are important, and in what circumstances
Part two in this three-part series deals with constructing conditional value lists that are to be used within a portal. In part one, the conditional value lists built were for use on a single record on a layout. Portals however may contain many rows, each row being a record with it's own field values…
Read the Full Article Here…
In part one, we built a couple of basic conditional value lists to select sport names & equipment items. Part two demonstrated how the conditional value lists could be tweaked for use within a portal. The last part in the series gives some basic techniques to help the selection process from your drop-downs, and ensure that the chosen values remain consistent and correct…
Read the Full Article Here…
Conditional Value lists may be the most asked about piece of functionality on the FileMaker Cafe. To try and provide a thorough and easy to follow explanation of what they are and how they work, I decided to write an article on the subject and build a small example file to help illustrate the technique…
Read the Full Article Here…
With the introduction of script triggers in FileMaker 10, live filtering or portals was made possible. Numerous techniques were introduced to help achieve this. In conjunction with existing filtering techniques, the "Live" aspect was achieved usually by introducing an OnObjectModify script trigger to the filter entry field. As soon as the user enters a value into the field, the triggered script would force a save of the fields contents, thus updating the relationship in question, which in turn u
Here is a nice quick technique that will allow you to place a layout object or objects into more than one tab on any given tab control object, without actually duplicating the object for each tab...
Read the Full Article Here…
In versions of FileMaker prior to 11, working with the Import Records mappings dialog was easy. You could very quickly select and deselect all mappings by selecting all fields and then clicking one of the arrow mapping icons between any two fields in the mapping…
Read the Full Article Here…
Recently on the Forum, someone asked if it was possible on a sub-summary report, to display the percentage of records contained within that sub summary part. Having never needed this functionality before, I decided to investigate how this might be done. What I came up with is a fairly simple and straightforward way to implement this.
Read the Full Article Here…
A sub-summary report, is a special kind of report where records are grouped together by a specified field known as the "break" field (because it acts as a break between groups of similar records). Normally, the break between parts happens above your records, but there is a way in which to have the break "appear" to be beside your records instead…
Read the Full Article Here…
There are four main areas of your database where you can use special separator lines to help keep information organised, these are Scripts, Layouts, Value Lists & Custom Menus. This article will go through each and explain how to use them, and why they are a good idea to use.
Read the Full Article Here…
The count function allows you to produce a count of the number of records through a relationship. However what may be less clear is that in order to achieve this, every record must be downloaded to the client computer, making the process very slow over a wide area connection. There is, however, an alternative to count in this situation which is almost instantaneous, this article explains how...
Read the Full Article Here…
The Let function is one of the most brilliant and underrated functions in FileMaker, and I think it should be used whenever and wherever possible. This article will give an introduction to the function, some possible scenarios when it should be used, and give an example as to it's use.
Read the Full Article Here…
Building layouts in FileMaker can involve adding a number of various elements such as fields, buttons, portals, tab controls, and graphics such as jpg and png images. It is the use of images on layouts that this article is all about.
Read the Full Article Here…
This is a simple technique that I use all the time and find works very reliably. It involves having a script create a new window into which the script executes it's necessary steps, before closing it when done.
Read the Full Article Here…
FMForums members may now create and publish their own blogs.
Click Here To Start
Already have an established blog on another service - you link to the blog service here to get more traffic.
Enjoy
Source: Do you got the gift of Gab?
