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 set a field and set it to a calculation field and return value is"?" when I am using PC.
Server FM9
Client FM18
I'm trying to use a Send Event to create a file from Filemaker.  I was able to do it successfully if I quote the text; however, when trying to add a variable so that it would recognize our Property Code and Work Order#, it doesn't work.  It seems the $FilePath needs to be quoted, but I don't know how to do that in the calc without rendering the variable useless.  Any ideas?  See attached.  capture.JPG
I would like to set a text aloud function on FileMaker. is it possible?
I need an advice for filemaker file opening script.
I would like to set a launching script when opening a filemaker file and decide a layout, depends on the device type, like laptop vs smartphone.
How did you set up PDF Manipulator?  I was able to successfully have it interact once I recreated our PDF document and named the fields.  However, did you copy all the PDF Manipulator tables and fields (see screen print) over into one of your Filemaker files?  I'm looking for a best practice more than one right answer.

ScreenPrint of Tables and Fields
Have downloaded PDF Manipulator and went through demo videos, but it doesn't show case of data being inserted from EXISTING Filemaker fields into the pdf.  Or, do I create new fields with the name of the PDF fields and then enter the data?  Trying to avoid double entry.  Tried to get into FM Forums, but having a problem.
I would like to compare the text in a field before a checkbox set field is changed (OnObjectEnter) and after it is changed (OnObjectSave) to return what is different.  Is there a function for that?  Can't find it.
Boss want Filemaker to be able to export to a pre-existing Fillable form (Bloomberg).  Is that possible or what workaround would you suggest?
Have SuperContainer which allows me to drag and drop files on a container field, which creates a file path and stores the file in it.  However, we have some large files that tend to cause a drag on Filemaker, so I want to create a button where I can store "additional files."  Currently, I have about 30 large files I'd like to just dump in a folder on the server and have a button in FM that accesses them.  I'd like this button to EITHER open the folder path or create it if it is not there (opening is easy; the creating is the problem).  

Is there a way in Filemaker or SuperContainer or some other (hopefully free) method to do what I describe?  

Thank you.
Hello, I have a FM Pro 15 Advanced Script, which has trouble setting the specified field values, I've a feeling there is a 'Filemaker' way to do it and I've missed out a step or two but unable to so far to glean from forums what that might be. Any pointers much appreciate:

Context: table

Valid Relationship: table = table 7 on Field1, Field2, Field3

Script step that doesn’t work:  Set Field by Name [table 7::field4]; table 7::field4 + 1

Field 4 is number.  I am trying to get the current last record reference number for a document and insert the next number to specified field which is also a number. The calculation will return correct number to dialog assigned  as a variable. But not set to field. No obvious errors popup.
In Filemaker Pro 10 , can it be done or does it require a later version?
I want to have a default value in a field that requires a value from a value list.
Field is "Language" default would be English.
In Options for field
I selected Auto-enter and entered English in data box.
for Validation I choose Always validate and
                                          Allow change during data entry
Under Requires: Member of Value list

Most records will be English, so I don't want everyone to have to worry about filing in the field, only those that are other than English.
I have a script that enters an employees initials and date into a comments field and forces previous comments to the next row with a hard return.  However, is there a script step where I can have the cursor go back to the beginning or arrow up to the prior row with the initials and date because it is leaving me on the previous line.  I'm experimenting with this method instead of a sub table of comments shown in a portal since I'm in table format.  Thanks.
I had this question after viewing Filemaker repeating field problem.

The issue is with Filemaker Repetition fields.  In a Contacts file, I wish to place the entered value of the field "DP"  in the repetition corresponding to the day of the week in the field, "DP Day",  based on the value present in any repetition of the field"Day".    
Three fields:  Field 1. is "DP" ~ a single entered value;  
Field 2 "Day" ~ is a Text [7] repetition field ~ each repetition can contain blank or numbers (1 2 3 4 5 6 7 ) corresponding to the day of the week.
Field 3 "DP Day" ~ is a Text [7] repetition filed ~ contains the value of "DP" in the repetition corresponding to the day of the week.

e.g. If Field 1 -  "DP" ='s 100;  and Field 2 -"Day" contains (blank, 3, 7, blank, blank, blank, 4) in the repetitions; The resulting values in Field 3 - "DP Day" should result in the values (blank, 100, 100, blank, blank, blank, 100)

Looking for the equation that will result in the above solution.

Thanks for any thoughts on this.

Bill Rock
Is there still no interactive way to sort a portal?  Last technique I used was to use tabs, duplicate the portal, and sort the portal based on the tab headings, which I have made one per column.
Client is using LogMeIn remoting service to access remote computers that are running a clinic app with Filemakerpro as a key component.  Through that arrangement, they are printing locally; in this case, prescriptions.

The LogMeIn system nicely sets up printers that are local to the user and remote to the application (note I've flipped "local" and "remote" here!).
Like this:
User remotes into application computer and runs the application.
User, via the app and remoting software, prints "remotely" (from the app computer) back to the client's computer environment.

The printer in question is networked and working fine.
It shows up on the remote app as a LogMeIn remoted printer.

Here is the problem:
Occasionally, prescriptions won't print at all .. I've been able to deal with that.
However, the next thing is that the prescriptions print off to the right edge off the paper and what is printed is mirrored.

I've fixed this before but it's been so long that I can't even find the solution any longer.
I have enabled Force Bitmap Printing to get the printing to work at all.
Now, my notes say: "will only print prescriptions using Java in order to avoid "mirroring".  I can't find any reference to that.  It's NOT about programming anything with Java I can tell you that!  I'm sure it's a selection but where?

This time I'll write it down... promise.
Is there a way to set a separate tab order for Browse vs. Find mode?  Doesn't seem to be in the Set Tab Order dialogue box.  Would be very helpful.
In one of my layouts, I have the property code set #1 in the tab order, but unlike other layouts, when I do a find, it selects another field.  Any ideas?  And, yes, the Find Mode is selected in the Inspector.  In Browse mode, it is in Table View if that makes a difference.
Has anyone found any major problems with Filemaker 17?  We currently have FM 16 and are completely dissatisfied it.  Instead of the usual 3-4 seconds, it takes anywhere from 8-15 seconds to open AND sometimes it doesn't open at all.  Worked with FM tech support for a year and tried all the solutions in EE, but couldn't figure it out.  Seems that FM 16 doesn't always close out all the way because a reboot seems to solve the problem of not opening up, though not the delay problem.  Appreciate any advice on FM 17.  Thank you.

I have one table with fields for COSTCENTRE and ANNUALBUDGET.
The table has 7 records

I have another table with fields for COSTCENTRE, ACTUAL and TOTALACTUAL (which is a summary of the ACTUAL)
There are many records in this table

I want a report that shows the COSTCENTRE, its BUDGET and the total of all the transactions for that cost centre on the same line.
I would also like to see the variance between the BUDGET and the TOTALACTUAL
How do I do this?

The tables are related through the COSTCENTRE fieldKHub-for-EE.fmp12

Many thanks

Filemaker Pro 13 - need to know how to copy a field with a script. I have a layout that contains a button. Due to internal controls, this layout has to be populated, then the person who filled it out has to click a button and copy two of the fields to another table in a separate database. This seems like a simple script, but I am not proficient in composing FMP scripts, and all of the results from Google are data imports and exports. I have hundreds of users with Filemaker Pro, and a single license of FileMaker Pro Advanced on the server that shares the databases. The users do not have access to the Advanced edition, so I am trying to do this complete in the "non-Advanced" version that they will be using. How do I do this?
When printing from Filemaker, there is a text field being used for notes but it keeps getting cut off after two pages. Is there a size limit on what can be printed out from one text field within Filemaker Pro?
filemaker pro 14 "save as pdf "
I created a layout with some labels and fields and tried to save it as PDF.I didnt used any scripts.But when i saved it as PDF,the field widths are getting reduced by few points.It is showing difference in widths in A4 size paper after i print the pdf.
Can anyone help me out of this problem.Thanks in advance.
Can You Create Dynamic Columns for Portals?  My boss wants to choose which columns he wants to show because we're running out of screen room etc.  Only way I can think of doing it is to create a pop up layout in table view where he has the column picker.  Any suggestions?
Is there an easy way to put a portal scroll on the left side instead of the right?  Don't see an option for it in portal settings.
One of my employees/customers gets a strange font in Filemaker if they close it out and then reopen it.  The only way they can clear up this problem is to reboot their whole PC.  We've scanned their PC for viruses and malware with no luck.  Any ideas?

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