FileMaker Pro

FileMaker Pro is a cross-platform relational database application that integrates a database engine with a graphical user interface (GUI) and security features, allowing users to modify the database by dragging new elements into layouts, screens, or forms. FileMaker evolved from a DOS application, but since 1992 has been available for Microsoft Windows and Mac OS, and can be used in a cross-platform environment.

Share tech news, updates, or what's on your mind.

Sign up to Post

I made a very simple database, one table only.
I just need to be able to have 2 functions.

1- Be able to add different classes with different date to a record

2- Be able to get an alert when I set a date, so that  I can notified the student that there need to re-certify again.

How can I do this?

On Demand Webinar - Networking for the Cloud Era
On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

How to make the attached file, be 312x312?
Due to tracking, we know a certain user duplicated one of our central property records 3x in one hour, so it looks like a mistake.  He's no longer with us, so we can't ask him how he did it.  However, he has a customized "User" menu set that does not have the duplicate command' only 3 of us with Admin privileges have it.  Do you know any way that he could have duplicated a record (the duplication is obvious due to the duplicated data in the fields)?
Here's what I'm working with...

$FindInvoiceRecord = $FMInvoices->newFindCommand('Data Entry (XGA)');
$FindInvoiceRecord->addFindCriterion('InvoiceNumber', $InvoiceNumber);
$FindInvoiceRecordResult = $FindInvoiceRecord->execute();
$FoundRecords = $FindInvoiceRecordResult->getRecords();

$FMInvoiceRecordID = $FoundRecords[0]->getField('zRecordID');
$OriginalInvoiceNotes = $FoundRecords[0]->getField('InternalNotes');

Open in new window

This works fine and loads my data as expected from the FileMaker record.  Then i'm trying to update the record...

$InvoiceUpdateData = array('InternalNotes' => $NewInvoiceNotes);
$InvoiceUpdateRecord = $FoundRecords[0]->newEditCommand('Data Entry (XGA)', $FMInvoiceRecordID, $InvoiceUpdateData);
$InvoiceUpdateRecordResult = $InvoiceUpdateRecord->execute();

Open in new window

But this is telling me that newEditCommand() method is not found..??  Any information on what I'm doing wrong here would be greatly appreciated.  Thanks!

I need to make a Filemaker Pro application that will match a value in a table just like the following Excel formula:


I also included the Excel example.


Thanks for all your help :)

Based on schema file like the attached, how can I derive the relevant sample EDI file?
We've been running filmmaker 14 with web direct for about a year with minimal issues, all of a sudden users on the web direct are getting the error message Database not available on all databases which are only three.  Even the sample database gives the same error message.  This happens whether it is an external source (computer outside of the office) or internal computer, the regular FM Pro application works fine but the web direct gives that error.  There are no periods in the filename as I have seen in some issues and can't seem to figure this one out.
Even did it on the server that is hosting it and you can see the error message.fm1.jpgfm2.jpg
Any troubleshooting suggestions?

I created a layout based on a table (People). There are two global date fields in the table that I placed on the layout. When I go into Find Mode I can not enter any thing into those two fields.
Can it be done, if so how?

Would like to contact the person who helped David Aaron's with his freezer issues in April, 2006.

I am not able to view the solution that was provided.

I am having similar issues with my current setup and was hoping this solution would also assist me.

Thx!  J
Hi experts,

I have a FM solution hosted on a Windows Server. All scripts performed on the server are suddenly responding slow. There are currently only 4 scripts called to perform on the server. All independent of each other and responsible for totally different tasks.

Everything was working fine until yesterday when I imported 30K records into 3 tables. I personally don't think the import has anything to do with it as none of the scripts instructed to perform on the server touch the 3 tables or the records imported. If I go to the layouts for those tables on the client side, all 30K records load/display just fine. Even if I set an empty script to be performed on the server and wait til completion, it still has a significant delay....

I restarted the server, just to rule that out but same issue. There is enough space and RAM as well.

Any suggestions?

Thanks in advance.
Free Tool: Subnet Calculator
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Dear experts

I want to open a database from a script and the name of the database is only known at runtime.
What I found on google and what i tried did not work and i don't know why.

According to google, in the the script I

1) set a text variable $filename to contain the name of the database like DatabaseA
2) use the command open file "extDB" to open the database

in external data source management i have defined extDB as a of type FileMaker and the path ist file:$filename

When I run the script the error is 'can not open file "$filename.fmp12" (not found)'. It seems that the variable is not resolved but the name of the variable is used as the name of the file.

This is on a Mac (10.11).

Any help is highly appreciated!

Dear experts

I hope to find help with a problem I haven't seen or heard of before.

I have a user in my Win2012R2 AD - let's call her DOM\Alice - with a Win10 client. Alice's roaming profile folder on the client is "split" into
C:\users\alice\...  and C:\users\alice.DOM\. By "split" I mean most of the profile's subfolders (documents, download, etc., and also NTUSER.DAT) are in C:\users\alice but  the desktop folder is in c:\users\alice.DOM. There is only one user dom\alice in the list of profiles, no local user.

When the roaming profile is synced, only the content from c:\users\alice ist copied to the server into alice.V5  but not the Desktop folder in c:\users\alice.DOM.
My Documents, Videos, Pictures and Music folders are redirected.
It is possible that the problem started when the user upgraded from win7 to win10 (not verified yet.)

Is it best to use the "move folder" option from the context menu of the "Desktop" icon in Windows Explorer to fix things?
Other options?

Thanks a lot.

Does anyone know of a solution for fixing the Reader DC print dialog box locking up when printing a PDF from a web window using FileMaker Pro 14/ Runtime and Windows 10? It worked fine until upgrading to Windows 10. When the print dialog comes up nothing can be clicked on unless you minimize the FileMaker app first
WHen I into my admin console and try to close a database with no one connect to that database it seems to be doing nothing.

What is causing this and what would be the command line to save for example close rabbit.fmp12 ?
I added fully qualified ssl certificates to my remove fms14 server and rebooted the server.
When the server came back up no one is able to connect to their fmp12 files.

What do I need to do to fix this ?
We have a commission report I am trying to put together. The problem I run into is that we calculate commission on the job as a whole versus separate calculations for the base job, then another calculation for the first change order etc.  I have been able to create a report that has each base job and change order listed.(each one is a separate record with the Job# as the common denominator. ) I can list and sort by salesperson and job# but my total is where the problem is.  Since some individual records wishin the jobs are calculated at different rates 16% vs 14%, the totals are way off.   Is there a way to add up just the GetSummary fields by Salesperson?
The problem is opening a pdf file for view with filemaker go when the pdf is in a container that is an external open type container.  

Set variable [$output; Value:Get(TemporaryPath) & "sample.pdf"]
Export Field Contents [Chart Records::document; "$output"; Automatically open]

This just brings up "loading web..." and eventually fails.
A solution would be most welcome.
My filemaker application which has the ui separated from the data.  I would like to be able to locate all graphics in the application.

How can i do this ?
I am seeing same error on FM 13 pro - on find operation - on the layout which don't have any conditional formatting.What  could be the other reason to see such error ?
Free Tool: IP Lookup
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Trying to create a value list that displays only active products being used by a patient.
We have our patients table, medications table, products table.
The medications table house all current and previous medications that patient was using, such as product ID, contact ID, active or inactive status, and other miscellaneous information.
The products table houses all the information for a specific product, such as product ID, description, brand name, dosage strength, etc.
The patients table houses data such as, patient ID, contact ID, active status, etc.
On the patients layout, when products are added to a patient either it be an Rx or Ancillary product it would be placed in in a portal called Patients_Medications_Rx or Patients_medications_Ancillary, etc.
That would display the history of products that patient has used and is using. The same time there is a field that the user selects as if it is active or an inactive product.
When our user goes to make a delivery form from patients layout, the user would select from the Rx or Ancillary portion of the delivery form the products that patient is using. The problem is that it displays all the products including the "inactive" products.
I was trying to creat a value list that would only display the "Active" products per specific category of products such as "Ancillary, OTC, Rx, etc.

Assistance in this would be greatly appreciated.
We have some users who change data on records and then do not recall what the previous data was and at times leave it blank or enter inaccurate data. What we would like is to have the capability to track and keep history of users and times when certain fields were modified.  We would like these to go to a separate table. This table would document the previous data and the newly created data for comparison in the future. It will also document the name of the layout, table, and field.
Is there a function or script already established for such a request?
If not, is it possible to get some insight on what would be the best practice in building one?
Filemaker Pro 12 question

I am a high school teacher and I’m looking into the possibility of a correlation existing between calendar age and academic perfomance at our semestered school.

I set up a FMP db with one table and all the fields in that one table.

I have four fields:

1) Month_of_Birth (radio buttons: 01 -12)
2) Student_Mark (#)
3) Level (radio buttons: D, P, IB, L)
4) Semester (radio buttons: 02, 06, 07)

I would like to calculate averages based on this data. I assume I need to use a calculation field, but I am at a loss as how to proceed.

For example, I'd like to calculate the average mark for those born from Jan to Jul (inclusive), who are Levels "D" and "IB", in semesters "02" and "06".

Obviously, I'd like also to calculate the average mark for those born from Aug to Dec (inclusive), who are a Level "P", in semester "02" as well as other combinations and permutations.

I figure I'd be able to modify the code if I could get something for the first one.

Any ideas on how to write a calculation for this? Or do I need something else?

Thank you for your time.

Alex Crane
I have having difficulties trying to get my drop-down lists to display the accurate data instead of all the data.
I am trying to use pop-up menu for drop down list.
I have a "products" table, inside that table I have "brand name", "Product type", "item type", and " variety type", those are just some of the fields.
We have issues with employees entering multiple records in products and we need to curtail this.
Also, when we do finds, there are always inaccurate data.
What we are trying to accomplish is that when a user enters a new product, that some of the information be conditional drop-down menus.
For instance, I have a drop-down menu called "Item Type", such entries include: syringes, bandAids, gauze, catheters, etc.
This portion works correctly, it is joined to the "products" table by unique field "__kp_ItemType_ID" from "ItemType" table to "_kf_ItemType_ID" in the "Products" table.
Then from the "ItemType" table, there is a table joined to it called "ItemTypeVariety", it is joined in relationship by unique field "__kp_ItemType_ID" from "ItemType" table to "_kf_ItemType_ID" in the "ItemTypeVariety" table.
I tried to create a pop-up menu to display only the "itemTypeVarieties". associated with the "itemType"
For example, bandAids ("Item Type") can have "itemTypeVarieties" of : children, medicated, sports, etc.
The way it is suppose to work is when a new bandAid is entered into the system, they would select "Band-Aid" and then select from the variety of children,…

FileMaker Pro

FileMaker Pro is a cross-platform relational database application that integrates a database engine with a graphical user interface (GUI) and security features, allowing users to modify the database by dragging new elements into layouts, screens, or forms. FileMaker evolved from a DOS application, but since 1992 has been available for Microsoft Windows and Mac OS, and can be used in a cross-platform environment.

Top Experts In
FileMaker Pro