Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x

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 hide for the tool bar.
I create a script to go into find mode and be able to do a find.

Now I would like to be able to create

as is showed when the tool bar is allowed to be viewed.
Screen-Shot-2017-09-25-at-9.28.04-AM.png
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE
LVL 4
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

How can I remove the tool bar for a user?

also are there any book that explain how to string commands
0
Hi,
Is there a way to open attached PDB file, other than using Visual studio?
B.PDB
0
I have a note field, and I want to be able to generate a date and time when I enter a not.
When I close it and reopen it I want to be able to add another note with a new  date and time stamp.

This way I can track when the note are made
'

Respectfully
J.Pieniro
0
Hi,
Is there any tool to be able to open attached pdb file?
B.PDB
0
So in the state filed I setup the cal value to be upper (self) so the if I enter Fl it will auto switch to FL.
I also want it to be able to remove any format that a user may want to do to the txt, color font style ect..
The cal is  TextFormatRemove ( Self )
Tried diff ways but cant get both to work in same cal value

How do I create the cal in the value to make both work.

Respectfully
J.Pineiro
1
I confused.

I get the 1 to many and many to many and the join table to allow to communication between tables and why.

My issue is when you click on the sq in the middle of the relationship the one with the lines, when it open at the bottom is say

Allow creation of records in this table via the relationship.

ok I get that, and I get that from contacts to invoice if I want to use a portal or just put the fields in the contacts layout I can do that by way of Allow creation of records in this table via the relationship and a portal to view more records at the sametime from the invoice layout.

But I have seen layout that have relationship and not all use it.

So my confusion is when  and when not to use it,  what direction do I use it to get what effect, do I want to allow deletion or not and why not?

Is there something I can read to understand this better??

Have been looking on line for a few days and still can't get a straight simple answer .

Respectfully
J.Pineiro
0
OK,
So new to FMP

Reading a white paper by David Kachet

A bit confused, hopefully someone can clear this up for me.
As I understand it there is not one set way to create a Primary and Foreign Key Field.

So the question is which one in my sample is the better one to use and why?

I understand having the pk & fk in front to tell which is primary and which is foreign key, what is a bit confusing is if I don't use it and just connect ie. (contacts_id in contacts tables to contacts_id on the invoice table) but this is the example in these white paper and I have also seen it in some youtube videos.

Thank you.

Respectfully
J.Pineiro



Tables
0
Hi experts, does anyone know how to get this set up? I've downloaded FileMaker.php assets and used the following code:

include 'assets/inc/FileMaker.php';
$fm = new FileMaker("<database name>", "http://<FM server ip address>", "<username>", "<password>");
if ( $fm ) {
  echo "Connected to database"."<br/><br/>";
} else {
  echo "Problem"."<br/><br/>";
}
$findCommand = $fm->newFindAnyCommand("customers");
$result = $findCommand->execute();
if (FileMaker::isError($dbs)) { /*can't connect to server*/
  echo $dbs->getMessage();
  exit;
}

Open in new window


We're on FileMaker 14. Here's the output I get:

Connected to database

Communication Error: (22) The requested URL returned error: 404 Not Found - This can be due to an invalid username or password, or if the FMPHP privilege is not enabled for that user.

Username and password are correct?

Thanks, Jon
0
Hi all, I'm trying to connect to FileMaker (version 14, Pro) database from a website using PHP. I've tried including the FileMaker API for PHP files but I keep getting the error 'cURL is required to use the FileMaker API' even though I know that cURL is installed on the web server (verified this by running the command man curl using terminal to display the manual). Does anyone know of an alternative way of connecting or any reason why I'm getting that message? Thanks
0
Hire Technology Freelancers with Gigs
LVL 10
Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

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
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
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
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
Concerto Cloud for Software Providers & ISVs
LVL 4
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

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

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
>