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

Has anyone found any major problems with Filemaker 17?  We currently have FM 16 and are completely dissatisfied it.  Instead of the usual 3-4 seconds, it takes anywhere from 8-15 seconds to open AND sometimes it doesn't open at all.  Worked with FM tech support for a year and tried all the solutions in EE, but couldn't figure it out.  Seems that FM 16 doesn't always close out all the way because a reboot seems to solve the problem of not opening up, though not the delay problem.  Appreciate any advice on FM 17.  Thank you.
0
Learn SQL Server Core 2016
LVL 12
Learn SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

Hi

I have one table with fields for COSTCENTRE and ANNUALBUDGET.
The table has 7 records

I have another table with fields for COSTCENTRE, ACTUAL and TOTALACTUAL (which is a summary of the ACTUAL)
There are many records in this table

I want a report that shows the COSTCENTRE, its BUDGET and the total of all the transactions for that cost centre on the same line.
I would also like to see the variance between the BUDGET and the TOTALACTUAL
How do I do this?

The tables are related through the COSTCENTRE fieldKHub-for-EE.fmp12

Many thanks

Michael
0
Filemaker Pro 13 - need to know how to copy a field with a script. I have a layout that contains a button. Due to internal controls, this layout has to be populated, then the person who filled it out has to click a button and copy two of the fields to another table in a separate database. This seems like a simple script, but I am not proficient in composing FMP scripts, and all of the results from Google are data imports and exports. I have hundreds of users with Filemaker Pro, and a single license of FileMaker Pro Advanced on the server that shares the databases. The users do not have access to the Advanced edition, so I am trying to do this complete in the "non-Advanced" version that they will be using. How do I do this?
0
When printing from Filemaker, there is a text field being used for notes but it keeps getting cut off after two pages. Is there a size limit on what can be printed out from one text field within Filemaker Pro?
0
filemaker pro 14 "save as pdf "
I created a layout with some labels and fields and tried to save it as PDF.I didnt used any scripts.But when i saved it as PDF,the field widths are getting reduced by few points.It is showing difference in widths in A4 size paper after i print the pdf.
Can anyone help me out of this problem.Thanks in advance.
0
Can You Create Dynamic Columns for Portals?  My boss wants to choose which columns he wants to show because we're running out of screen room etc.  Only way I can think of doing it is to create a pop up layout in table view where he has the column picker.  Any suggestions?
0
Is there an easy way to put a portal scroll on the left side instead of the right?  Don't see an option for it in portal settings.
0
One of my employees/customers gets a strange font in Filemaker if they close it out and then reopen it.  The only way they can clear up this problem is to reboot their whole PC.  We've scanned their PC for viruses and malware with no luck.  Any ideas?
0
Trying to separate out addresses and cities that have been placed in the same field with only a space to separate them.  I've captured many street abbreviations, but how would I capture the address for something like 100 Hwy 16 Los Angeles?  I attempted to put a Find wildcard of ** like you see below to capture a two-digit number, but it didn't work.  Are there any wildcards that can be used in a calculation field?

PatternCount ( SuperMarketsList::Address; "Hwy ") = 1;
Left ( SuperMarketsList::Address ; Position ( SuperMarketsList::Address ; "Hwy ** "; "" ; 1 ) + 2 ) ;
0
ON the server, the Admin Console No Longer Appears in the Browser.  Could it be because of a Java or Windows upgrade?  Using FM server 16.0.3
0
Amazon Web Services
LVL 12
Amazon Web Services

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

I had a problem with import records function.In script i given arrange by option as"custom import order".But after running script for 1 time,when i'm trying to run for 2nd time,the option is reverted to "last order".Can't we fix this problem??.I searched everywhere,but i didn't found the solution.
Can anyone help me in this situation.
0
I have a field set to send auto data ( D&R)

when I create a new record and go to the Kitchen tab the auto data dose not appear.
When I click on the check box next to it, the auto data appears.
If I take of the auto data, and I click on the check box next to it, it just places the check mark.

Not sure what I'm doing wrong...
I checked to make sure that each field has the correct values form is correct and are even spelled diff.

I have done the same in a diff tab and it works correctly, so i'm not sure why its not working on the kitchen tab.


1
2
0
I created a simple 5 table db on FMP

Scopesheets
Ceiling
Walls
Flooring
Cabinets

right now I only have scopesheets with a relationship to ceiling.
this is the relastionship

  Relationship  

I can start to input info without any problems.
I can input notes, with the time and date stamps without any problem.

But if I delete all of the notes it clears all the check boxes...



Very crazy, cant understand why it's doing this...

Can someone please help me to how to fix this and why it is happening so that I don't make this mistake again.

Respectfuly
J.Pineiro
data-inout.png
Screen-Shot-2018-01-15-at-4.05.23-PM.png
0
I've checked the version of FM and downloaded the exactly version corresponding updated from http://www.filemaker.com/support/downloads/ running the downloaded exe file as administrator on Windows 10.

I consistently get an installer message saying..

The upgrade patch cannot be installed by the Windows Installer service because the program to be  upgraded may be missing
 or the upgrade patch may update a different version of the program. Verify that the program to be upgraded exists on your computer and that you have the correct upgrade patch.

FM Pro Adv works fine. I updated it to 15.0.4.400 today before running the updater, which I want to get the 32 bit ODBC driver.

It seems to be a Windows installer originated issue - 10 home Version 1703 OS Build 15063.726.  Maybe it can't find the FM install path.

At a dead end, anyone else had this or any ideas how to troubleshoot / workaround ?

Many thanks
0
Hello. I built a database using FileMaker. In my table, each record has an automatically generated ID number (specific field): 1,2,3,4 5, etc....
When I delete a record, this field is not automatically renumbered. For example, if I delete record #3, my table will contain 1,2,4,5.
Is there a way I can automatically renumber to 1,2,3,4 and ensure that the last record ID corresponds to the total number of records?
0
The solution that Will gave me to auto start our Leads database so that employees won't have to do a File:OpenRemote, takes a long time after we upgraded from FM15 to 16.  I even recreated the database and created the table, fields, layout, and script from scratch and didn't save time.  The problem is that it takes so long to open (15 seconds?) that people click again and that hangs up FM.  It then never opens.
Start-FMNew.JPG
Start_Script.JPG
0
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
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
CompTIA Network+
LVL 12
CompTIA Network+

Prepare for the CompTIA Network+ exam by learning how to troubleshoot, configure, and manage both wired and wireless networks.

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

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
>