Can someone show me how to create a field that will should a found set of a search?

not sure how to go about it.

Respectufully
JPineiro

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

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

Hi,
Is there a way to open attached PDB file, other than using Visual studio?
B.PDB

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

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

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

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

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

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

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');

Select all 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();

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

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