Filemaker Windows Shrinking Issue

Isn’t  the main window shrinking from full-screen to a smaller size while opening a modal window screen in Filemaker irritating ? Indeed it is irritating…and the experience looks very unprofessional.

The main window shrinking is indeed a known bug in Filemaker and it happens when you open a modal dialog window from the interface with the main window size “Maximized”.

Let me explain with an example ; Suppose, you have a FM application interface which is maximized to fit all corners of the screen (Either with script step – “Adjust Window(Maximize) or with script step “Move/Resize Window” in start-up script or any other ways). Now, there is a button in your application which opens up a new modal window; On this button click, if you have noticed, the new modal window opens and the main Window shrinks in the background. This is not a big functional issue but create a lot of annoyance and irritation for some customers/clients.

As this is a known and reported bug in Filemaker, any way to fix it ? Ofcourse there is a way. The way is to not use the “Maximize” option in the “Adjust Window” for full screen display. In place of it, use “Move/Resize window” script step and set the “Height” and “Width” option the script step 5-10 pixels from your desktop or monitor size and it WORKS!!! The window does not shrink anymore after this.

Example :

Move/Resize Window :
Height [Get ( WindowDesktopHeight ) - 10]
Width [Get ( WindowDesktopHeight ) - 10]

Something like this…..

Written By: Shibasis Nayak, Software Engineer, Mindfire Solutions

Themes – Is it Really that Important?

Well, what would you say to a client who comes up with a new color of button, new font, new background icon, new format of almost each and every object every 2 weeks and you have a very large application to work with? It is overwhelming if the application is not using FM13.

FileMaker 13’s new Custom Themes and Styles feature is a total rescue to this situation. All that is needed,is to create and attach styles to all objects, save those under a theme and wait for the client to ask for a change once again 😉 Read the full post »

Identical Values Custom Function

There was a requirement from a client to filter data according to the client’s name .There were 6-8 Fields in a table on which the client’s name could be present in 1 or more fields.
I needed to filter the  records so that there would  be unique client’s name present in all/some fields if data were present in those fields.
Read the full post »

FileMaker Security practices

A lot of user actions/practices can make a FileMaker solution more secure.

FileMaker has a security level that is usually file specific.

There are some small things that can be considered while making an application more secure and unadultered from external threats :- Read the full post »

Perform Script on Server

Say STOP to waiting for a long process to complete in FileMaker13 applications. As we all know,server scheduling or running of a script from the FileMaker server is much faster to execute than from a FileMaker Pro client,so it’s time to accelerate the process by using the most beautiful feature provided by FileMaker13 i.e. Perform Script on Server (PSoS).

With everyday progresses, I am getting more and more opportunities to explore the new Perform Script on Server feature in FileMaker13 and each time it’s making me more curious than the previous one. There’s a new way of running scripts in FileMaker Server 13 by sending request from Pro client to FileMaker server. In my view, its one of the predominant features that has been introduced in the latest version of FileMaker.
Lets me get into more details about PSoS. Read the full post »

Optimization of FileMaker Applications

Query Optimization in FileMaker:
Everybody always thinking of use/design a good application which gives them a faster processing and better output but what is the way to get that? It’s “Optimization” which is nothing but the process of making your query request BETTER and FASTER. An efficient application is that which give faster output to your query. As a database application FileMaker solutions must goes under query optimization to make the solution an efficient application. So here there are some descriptions how we can make our FileMaker application queries optimize.

What is query optimization?
Optimization comes from Latin meaning “making it better”. So Query Optimization is nothing but making a script better and faster.

What is Query Optimization in FileMaker?
As FileMaker is a relational database and the query script used in FM is purely depend on relationships and layouts on which the query execute. So optimization of query in FileMaker is nothing but optimizing our database definitions, relationships, layouts as well as script statements/steps.

To target the optimization we need to follow below 4 steps:

  •  Well-defined Database Definition
  •  Perfect Relationships
  •  Best Layouts
  •  Optimized Scripts

Read the full post »

Display Custom Error Message when WebViewer is unable to load an Image

For instance, I am having a webviewer on a layout which loads an image from a specified path. But if there is no image found then it shows “?” icon or “object not found” etc. In that case I want to display custom error message; here is a script which we can run on the layout where it is having the webviewer and check if there is any issue in image loading. The webviewer should have a name.

-> If there is no image tag present in the URL content show Custom Error Message

-> If an error template has been loaded show Custom Error Message

-> If object not found 404 error show Custom Error Message

Read the full post »

Manage timezone differences with Filemaker

Few days back, I was surfing across some forums and found a thread which asks about – How to manage with various time-zone differences with Filemaker having users fanned out across globe with different time-zones? Well, I had never came across such an issue before until today, when a Filemaker community member  asked me for some help to handle the issue of timezone differences for his users using a terminal server(Like 2X, Aqua-connect, Citrix) to render Filemaker files for user interfacing. The problem was, the files were hosted on a cloud server with “PST” time-zone and the terminal interface was a Mac OS X which had also “PST” time-zone. Obviously, any date, time, time-stamp will take the “PST” time-zone values in the interface. However, everything was fine until my friend( the community member is a friend by now 🙂  )  had some new customers in Asia, South America and Africa and they have their respective time-zones.

Read the full post »

Say HELLO to Filemaker 13 !!

With the release of Filemaker 13 couple of weeks back, we were really excited to lay our hands on it and have a run through it. We are amazed to find some brilliant and cool features with the new release of FM 13. Allow me to share some important enhancements/features of the same;

Formatting Excel Report In FileMaker While Export – PART 4

Exporting Dynamic Columns In Excel Sheet While Exporting:

Before going into the detail of it, we need to understand dynamic column export concept by looking into a case study. Suppose in your FileMaker application there is an interface where users need to select which are the fields to be exported. For that you have shown a checkbox to users with showing a list of the fields name to be exported from a table. Lets say we are showing 6 field names of a table in that checkbox to users. Since we are giving the option to user to select any field to export dynamically, they may select any possible combination of fields while exporting.

Read the full post »

Extreme FileMaker

League of Filemaker Gurus