" Live as if you were to die tomorrow. Learn as if you were to live forever.. "
- Mahatma Gandhi

How to disable wildcard characters while searching in FileMaker PHP web application using FileMaker API for PHP

Posted on November 23rd, 2015 by Jyotirmaya Dehury

If we pass the search text directly as entered by user to FileMaker API function while searching, then the search will support the wildcard characters like *, @ etc by default. So to disable the wildcard characters always escape the wildcard characters before using them in the search text and for exact match pass the […]

Execute a script using FileMaker API

Posted on November 23rd, 2015 by Shashi Kumar

A script which is stored in FileMaker DataBase, can be executed by using a method newPerformScriptCommand(). This method can be called with the help of filemaker object. It takes three parameter :-       1. Layout Name     2. Script Name     3.  Script Parameter if any (Optional) Code Snippet //CREATE FILEMAKER OBJECT $fm = new FileMaker($database, $hostname, […]

FMPHP API: Pre-validating records in command

Posted on November 23rd, 2015 by Swarup Sahu

We generally validate recordse before saving them to database. Most of the times for some fields, some validations are defined in the Filemaker database itself. As long as data passes the validation defined in the Filemaker database, it will thtrow error while saving the data. So we need to check whether the data passes the validation […]

Retrieve value list from a Filemaker layout using Filemaker API

Posted on November 23rd, 2015 by Swarup Sahu

We know we can get value list from a layout with help of getValueList() method. But it has a drawback, let me explain it here: -This method returns value list in an array from the first field. It does not bother about whether second field is associted with the value list or not. -And also […]

Filemaker API: Create New Record(newAddCommand vs createRecord)

Posted on November 23rd, 2015 by Swarup Sahu

To create a record, we have two functions i.e ‘createRecord()’ and ‘newAddCommand()’. But we should aware of the difference of these two functions though both are doing same task. Both the functions need a layout and data array to create a record. So the first difference is the execution process. The ‘createRecord()’ statement requires ‘commit()’ […]