Go Premium for a chance to win a PS4. Enter to Win

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

We have FM 16 in a Windows environment integrated with an Exchange Server.  Boss asked if I can format font in an email.  There is a function (see below) in the email script for the text body, but it didn't work.  The text came through like all the other text in the body - Times New Roman.  Can you format font in an Email in FM 16, including text fonts, bolding and different colors?

TextFont ( "Loretta," ; "Arial Black" )
0
Hire Technology Freelancers with Gigs
LVL 11
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.

SQL 2012 is not supposed to be compatible with Filemaker 11 Server but I made it work. I have a live connection and wish to utilize it. Does anyone know of any risks in using it to import data from sql into filemaker? The company only supports up to SQL 2008, but our databases are all SQL 2012, and FileMaker 11.
0
I need to create a cal that will allow a reminder...

So if a student take a CRP class today 10/26/17 the certification is good for 2 year so until 10/26/19.
I want to setup a reminder that will with conditional format turn red 3 month before, 2 months before & 1 month before the expiration of the students certification.

I have a date set up in courses so when the student take the class I simply input the date. I also have a reminder_on file.
Not sure how to processed from there.

attached is what i have so far in layout and design.



Respectfully
J.Pineiro
ERSCRM-Copy.fmp12
0
So I have 4 tables

Students
Courses
Instrcutors
Compnay

from how I see it it's like this...
one student can take manny courses so thats one to many.
one course can have many students  so thats also one to many
that makes them a many to many relationship.
to connect them I would use a join table (STUDENTS_courses)
The same would be true for the company and Instructors.

So my question is this....
Can I use the same (STUDENTS_courses) also as a join table? if so it would look like this.


Join table

Can this be done?
I'm not sure if I can only use one join table.

Any suggestions?

If it's wrong, what would be the correct way to do it?

Respectfully
J.Pineiro
0
Hello, I'm new to FM and already hitting a brick wall.

I have a layout "AssignUsersToCourse" and I can pick a course from a drop down per student with dual credit classes they are allowed to take based on their program, but I cannot figure out how to get the actual credit hours earned by the dual credit program. It always shows one value.

Database is attached.

Hope someone can help with this...

Thanks!
Marek
dual_credit_db_v2.fmp12
0
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
0
I created a container to be able to take a pic from FM GO, which I can as long as I am logged in as someone with full permissions.
I created a pri-set for user....

can anyone tell me what I need to do to allow for a user to be able to take a pic using a container without having full permissions?

FM Permissiosn
0
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
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
How can I remove the tool bar for a user?

also are there any book that explain how to string commands
0
New feature and membership benefit!
LVL 11
New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

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
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
Industry Leaders: We Want Your Opinion!
Industry Leaders: 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!

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

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
>