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

Is there still no interactive way to sort a portal?  Last technique I used was to use tabs, duplicate the portal, and sort the portal based on the tab headings, which I have made one per column.
0
OWASP: Threats Fundamentals
LVL 13
OWASP: Threats Fundamentals

Learn the top ten threats that are present in modern web-application development and how to protect your business from them.

Client is using LogMeIn remoting service to access remote computers that are running a clinic app with Filemakerpro as a key component.  Through that arrangement, they are printing locally; in this case, prescriptions.

The LogMeIn system nicely sets up printers that are local to the user and remote to the application (note I've flipped "local" and "remote" here!).
Like this:
User remotes into application computer and runs the application.
User, via the app and remoting software, prints "remotely" (from the app computer) back to the client's computer environment.

The printer in question is networked and working fine.
It shows up on the remote app as a LogMeIn remoted printer.

Here is the problem:
Occasionally, prescriptions won't print at all .. I've been able to deal with that.
However, the next thing is that the prescriptions print off to the right edge off the paper and what is printed is mirrored.

I've fixed this before but it's been so long that I can't even find the solution any longer.
I have enabled Force Bitmap Printing to get the printing to work at all.
Now, my notes say: "will only print prescriptions using Java in order to avoid "mirroring".  I can't find any reference to that.  It's NOT about programming anything with Java I can tell you that!  I'm sure it's a selection but where?

This time I'll write it down... promise.
0
Is there a way to set a separate tab order for Browse vs. Find mode?  Doesn't seem to be in the Set Tab Order dialogue box.  Would be very helpful.
0
In one of my layouts, I have the property code set #1 in the tab order, but unlike other layouts, when I do a find, it selects another field.  Any ideas?  And, yes, the Find Mode is selected in the Inspector.  In Browse mode, it is in Table View if that makes a difference.
0
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
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
Become a Certified Penetration Testing Engineer
LVL 13
Become a Certified Penetration Testing Engineer

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

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
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
Expert Spotlight: Joe Anderson (DatabaseMX)
LVL 13
Expert Spotlight: Joe Anderson (DatabaseMX)

We’ve posted a new Expert Spotlight!  Joe Anderson (DatabaseMX) has been on Experts Exchange since 2006. Learn more about this database architect, guitar aficionado, and Microsoft MVP.

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

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
>