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?

Respectfull
J.Pineiro
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.

Hi,
How to make the attached file, be 312x312?
p5.png
0
I have a Filemaker Pro Server 9.0 and I need to move 2 databases from the default location on the C: drive as they have run out of space.  I created an additional default database location on the H: drive, a separate physical disk on the same machine.  How do I move the databases so that the FM clients still have access?  All I can find is info on uploading a db from local hard drive on the client machine.

Thank you.

Am hoping in the near future to move to FMCloud but I assume the files will need converting.  Still researching that one.
0
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)?
0
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
On Demand Webinar - Networking for the Cloud Era
LVL 9
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

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

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

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
>