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

Hello Filemaker experts,

I have uploaded my DB to https://goo.gl/Ko5b5F. This is what I need help with:

a) Is there any way to import the data from table "Non Operational Expenses" into "Total Expenses" in an automated way, i.e. I am aware that I can export the data and then re-import into the table I want but what I am looking for is some kind of a trigger that would update Total Expenses every time that a Non operational Expense is added

b) Field "Total How Flown" on layout "Summary" is not working properly. How can it be fixed?

c) On layout "Detail" I need to hide each record detail under Fixed Expenses.

Thank you for any assistance you can provide.
0
Independent Software Vendors: We Want Your Opinion
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Client is looking to have 3 separate locations connect to FileMaker databases.  Sometimes 2 users will want to access the same file.

Can they set up FileMaker Pro on a Virtual Private Server and use that copy to serve files?   What is the limit of open files for non-server FileMaker at the moment?
IF they purchased FileMaker Server, would that work?

Could they remotely run FileMaker on a VPS?

Is there a way to do this?

Thanks.
0
Here's what I'm working with...

$FindInvoiceRecord = $FMInvoices->newFindCommand('Data Entry (XGA)');
$FindInvoiceRecord->addFindCriterion('InvoiceNumber', $InvoiceNumber);
$FindInvoiceRecord->setScript('wa_CommitRecord');
$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!
0
hi experts,

 i'm wondering if there are any filemakerpro experts in here. I'm trying to open the admin console and i'm getting error message : Java (TM) Web Start 11.13.2.11-fcs   Cannot Determine a valid Java Home
0
User has Filemaker Pro 6 Files that they opened with FileMaker Pro 8 and converted to latest format.  The problem is that these new files now ask for a user name and password, whereas before they only asked for a password for access.

What is the 'trick' for opening these upgraded files?

Thanks
0
Hi, All - I am a budding FileMaker developer, and I have a new client who wants a POS system The first challenge I need to solve is how do I get the cash drawer to open.

My research has shown I can get Troi Serial but I am hoping to open the drawer natively, or at least perhaps using 360 Scriptmaster plugins send a windows shell command.

The printers are Epson TM-T20, The operating system of the POS tills are Windows 10.

Any guidance is very appreciated.

Thanks!
0
Boss wants to be able to select a choice of nothing in a drop down value list in Filemaker (15).  I just tried adding a return, but it doesn't work.  I searched Help with no solutions.  The only way to remove a "Yes" when that is the only option is to delete it, which is more cumbersome.  And, we don't want "no" as an option nor put a space as this will cause problems with calcs, etc.  Any suggestions?
0
Hi,

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

=INDEX($B$3:$F$7,MATCH($A$11,$A$3:$A$7,1),MATCH($B$11,$B$2:$F$2,1))

I also included the Excel example.

Tariff_v1.0_2.xlsx

Thanks for all your help :)

Cheers,
Rene
0
I would like to create daily task database.
I have 20 tasks daily and 4 users using the database.
I would like to create a dashboard to show which task is not done and end of the day,
would like to email to the users, which tasks did not complete.
0
I would like to create a button on filemaker, once push, it changes color and once day change, color goes back to original color
0
Enroll in July's Course of the Month
LVL 9
Enroll in July's Course of the Month

July's Course of the Month is now available! Enroll to learn HTML5 and prepare for certification. It's free for Premium Members, Team Accounts, and Qualified Experts.

Hi,
Based on schema file like the attached, how can I derive the relevant sample EDI file?
0
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?

Thanks
0
We have FileMaker Server v13 and FM Pro 13 clients, we are moving databases to new SQL Server 2008 SP4  running on Server 2012 R2 (from SQL 2008 SP3 running on Server 2008). When in FM Pro External Data Sources trying to add an existing ODBC connection to SQL Server DB, it's not there. Any ideas why? It's a big deal since it's a critical connection to another DB

Thanks!
0
I'm not aware of dynamic reports existing with Filemaker; however, my boss asked this question:  "Why can’t I have one list report with column headings definable from a pop down menu of all the fields in the Propinfo DB and maybe Finance?  Make the fields sizeable from the column headings.  Then whenever I need to look at something in an over view I can do it easily."

The sizeable part can be done if I render the view a table view, but don't know how you can choose column headings.  Any suggestions or do I have to use a third party sw?  I have FM 15.
0
What is count command in fox pro?
0
Hi,

I need to learn how to export a Filemaker Pro database to Excel as a Pivot Table.

Thanks for your help

Cheers,
Rene
0
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?
0
The only DB experience I have is (unfortunately) with MS Access.  I'm now creating a software application that interfaces with a DB, so I just went with what I know (Access).  But, I don't really like the user interface, especially for dealing with relations.  Also, it has a very limited range of data types (no real numbers, Booleans use a strange convention for storage, etc.).  And most recently, I've run into an intractable problem whereby I cannot programmatically add or update records (covered in a separate post).  So, now I'm seriously considering moving to another platform.  The two I'm considering are Filemaker Pro (Is that different from Filemaker?), and MS SQL Server.  But, I know essentially nothing about either.  So, I'm looking for some advice on the trade-offs / suggestions for which way to go.  Also, of course I'm wondering what is involved with importing / translating my existing DB to one of the other tools.  (If it matters, the DB has 38 tables, and about 200 fields, but very little data so far.)
0
I added plugin to jstree file manager  :
I would like to open file in Iframe in the modal window
Instead  the code below opens file in the another window in another tab.
I am working in MVC5
Can I open file in Modal Window in MVC5. File   could have external address like   " http://somedomain/test.pdf"

thanks
  $.jstree.plugins.addHTML = function (options, parent) {
                this.redraw_node = function (obj, deep,
                                            callback, force_draw) {
                    obj = parent.redraw_node.call(
                        this, obj, deep, callback, force_draw
                    );
                    if (obj) {
                        var node = this.get_node(jQuery(obj).attr('id'));
                        
                       
                        var html =
                        "<a href='http://localhost:29128/test.pdf'  data-rel='modalDialog' data-dialog-title='Fruits and Nuts'>Fruits and Nuts</a>"
                      
                        if (node && node.type == "FILE") {

                            jQuery(obj).append(

                              html
                            );
                        }
                    }
                    return obj;
                };
            };

Open in new window

0
On Demand Webinar: Networking for the Cloud Era
LVL 9
On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Have a portal resolving slowly because of an unstored field in the link.  The field's calc is below.  Is there a way to get a Max# without using another table occurrence (which forces an unresolved calc), or do I just need to script it so a companion text field is marked with a "Y" in every record that applies when entering this particular file for the first time on startup?  The point of this particular calc is to mark past Tenants as the most recent 3 prior Tenants that will show in a portal in another file.

If ( GetAsNumber ( TENANTS_ALL::TenantNum ) ≥  Max ( TntsAll_RcntTnts::TenantNum ) - 3  and
IsEmpty ( InTnttableFlag ); "Y" ; "" )
0
I have 3 fields

PW, PB and PTotal
PW AND PB have drop down options as to order 1, 2, 3, and so on.

I want to be able to click on PW and order 2 and PB order 1 and each are 199.00 I want to see the total on the PTotal field.

How can I do that?
0
Is it possible to add a SubSummary Part to a Tab Panel on a layout?
Can it be done inside of a portal?

Can a Summary field type be placed somewhere other than in a SubSummary Part ?
0
Hi,
I did adjust size of file to 512x512 px but I still get rejection to the file due to that it should be 512x512 px. What to adjust?
image018-512x512.jpg
0
Hello! I have created database in FileMaker Pro 15 (under Win10), storing information about equipment which we repair (serial numbers models etc.). Wondering if any way to add multiple PDF service reports to each record. It could be 1 to many (sometimes 10-15) PDF reports for each database record. I would like to have scrollable window with list of reports (including number/date) and clicking on each line will open document in PDF reader. As I aware, FileMaker does not allow anymore OLE objects, by some reason. Is any way to solve my problem or I should look for different software (if so, please advise which I may try as alternative to Filemaker Pro 15). Thank you! Leonid
0
Hi,
How to ensure the attached png file is having size of 16x16?
image018.png
0

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
<
Monthly
>