FileMaker Pro

3K

Solutions

4

Content

i
The collection of articles, videos, and posts on this topic.

1K

Contributors

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

I have file maker pro 12.  I have a database that uses a portal and I store files from Excel checking "store only as a reference". When I open the file from the portal fnd try to make changes to the excel document , after saving and closing excel I find that when I re open the file the changes have not been saved. Is this inherent in file maker pro or is this a programming issue?
0
4 Comments
OWASP Proactive Controls
LVL 12
OWASP Proactive Controls

Learn the most important control and control categories that every architect and developer should include in their projects.

Start Today!
I'm creating a report in FileMaker Pro 13. The idea is a create a list of employee trainings and list everyone who is not trained to the most current revision of a training. So we have first name, last name, employee number, training number, training revision the employee trained to, and the most recent revision number of the training. I am pretty new to FMP, and have made a number of layouts, but never did any real work on this kind of thing- typically it has just been creating forms to generate records. How do I generate a list that only shows those fields for the highest revision of the training number? I did figure out how to set up conditional formatting to highlight anyone who is behind on a training, but there are cases where there are 30 or 40 revisions... and we are only interested in the highest revision number. So I need to display each employee training sorted by last name and training number, but only the record showing the max of the revision as well as the highest number in the "trained to revision" for each training number. I am guessing I would use some sort of calculation, but I have no idea how.... I'll take any suggestions... Thanks!
0
13 Comments
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
2 Comments
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
14 Comments
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
7 Comments
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
6 Comments
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
4 Comments
I had a field Score in which values read as 63 46 62 and some fields as 63 42 Ret'd.Now i need to display them as 6-3 4-6 6- 2.How can i show like this through custom function by using recursive function
0
2 Comments
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
6 Comments
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
2 Comments
HTML5 and CSS3 Fundamentals
LVL 12
HTML5 and CSS3 Fundamentals

Build a website from the ground up by first learning the fundamentals of HTML5 and CSS3, the two popular programming languages used to present content online. HTML deals with fonts, colors, graphics, and hyperlinks, while CSS describes how HTML elements are to be displayed.

Learn More!
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
3 Comments
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
2 Comments
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
4 Comments
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
4 Comments
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
11 Comments
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
2 Comments
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
14 Comments
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
5 Comments
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
14 Comments
Build an E-Commerce Site with Angular 5
LVL 12
Build an E-Commerce Site with Angular 5

Learn how to build an E-Commerce site with Angular 5, a JavaScript framework used by developers to build web, desktop, and mobile applications.

Enroll Today!
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
5 Comments
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
2 Comments
I need help building the following JSON using native Filemaker 16 commands

{
    "vehicles" : [
       {
         "vehicle_id": "my_vehicle",
         "start_address": {
             "location_id": "berlin",
             "lon": 13.406,
             "lat": 52.537
         }
       }
    ],
    "services" : [
       {
         "id": "hamburg",
         "name": "visit_hamburg",
         "address": {
           "location_id": "hamburg",
           "lon": 9.999,
           "lat": 53.552
         }
       },
       {
         "id": "munich",
         "name": "visit_munich",
         "address": {
           "location_id": "munich",
           "lon": 11.570,
           "lat": 48.145
         }
       },
       {
         "id": "cologne",
         "name": "visit_cologne",
         "address": {
           "location_id": "cologne",
           "lon": 6.957,
           "lat": 50.936
         }
       },
       {
         "id": "frankfurt",
         "name": "visit_frankfurt",
         "address": {
           "location_id": "frankfurt",
           "lon": 8.670,
           "lat": 50.109
         }
       }
    ]
}

Open in new window
0
0 Comments
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
2 Comments
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
4 Comments
I have a layout that is able to display a field that is defined as a calculation in its table. The data displays correctly. I then decided to add three more fields on  my layout using three more fields that were defined as calculations. When navigating through the records, i notice that only one of the four fields on my layout displays the data that is calculated on the table.  It only displays one of the four, not two or three or four, but just any one of the four.
Table A (User Settings) is in relationship with Table B (Device Settings).
The fields in the relationship are two:
ContactID = ContactID
UserLocation = DeviceLocation

All fields are entered in DeviceSettings table.
There is a dropdown on devices that is used to select the employee that is assigned that device.
That device is also entered with a value of either for field DeviceLocation: Local, Remote, etc.
The layout called User Settings is a layout that will house all the devices assigned to a user.
If an employee is at the local site as there work location, the relationship should display all items associated with that employee contact ID and place them in there corresponding field.
I used in the UserSettings table on the four fields the field type as : calculation.
I used the If structure to calculate the field. It works correctly when only one field is on the layout with the calculation field, but the moment i enter other calculated fields on the same layout, it only displays one of the four …
0
17 Comments

FileMaker Pro

3K

Solutions

4

Content

i
The collection of articles, videos, and posts on this topic.

1K

Contributors

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
>
Hall of FameAnnual Expert Awards