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

Hello Everyone,

Finally back for Irma, 72 hour's on duty then home to do clean.
Everyone safe and house untouched, Thank God!

So here is my question.

I created a script that allowed me to send and email that was the layout in which that email button lives.
I was able to send the info on the layout as a PDF.
So I got that working correct and then I uploaded it to a VM Server Win2012 R2 which I install FM Server one and now when I run the same script while I do get the email I no longer get the attached PDF that I was getting before.

What I'm I doing wrong? I just uploaded the file to FMS
Is it a Server issue?
Do I need to save the file in a different location then when I had it running on just a PC desktop?

Thank you for all of your help.

Respectfully
J.Pineiro
0
On Demand Webinar: Networking for the Cloud Era
LVL 10
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.

The db is for tracking students that take classes, there are diff classes.

CPR/AED
CPR/AED & First Aid
BLS
APLS
PALS

I want to be able to display 2 numbers.

I want to do a cal for the total number of students in each class...
so if there has been 50 CPR/AED classes in 1 year ( 12 months) I would like to get the total of that, one total for each class.

Then I would also want to get a total for each student in each classes, but for each company...
so if I teach the guys from the Coral Gables Fire Dept BLS/ACLS & PALS I want to see how many guys took the BLS and how many took the PALS ect...


so I want something like this...

Total students in one year  = 500
Company CGFD = 300
Company MDFD= 200

CGFD BLS = 250
CGFD ACLS = 125
CGFD PALS = 125
____________________
NDFD BLS =100
MDFD PALS = 100

I need a break down like the above for reports and some of will be on the layout for a quick look to see how many per company so far have taken which class.

If someone can show me how it's done as I have no clue how to string cal (put them together)

Thank you

Respectfully
J.Pineiro
0
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 need a custom function for filmmaker that will create an EAN 13 string of 13 digits, with the 13 digit being the checksum from a 12 digit input.
0
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
Important Lessons on Recovering from Petya
LVL 10
Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

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
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
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
Free Tool: IP Lookup
LVL 10
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.

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

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
>