FileMaker Pro

3K

Solutions

4

Articles & Videos

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

Boss wants to be able to select a choice of nothing in a drop down value list in Filemaker (15).  I just tried adding a return, but it doesn't work.  I searched Help with no solutions.  The only way to remove a "Yes" when that is the only option is to delete it, which is more cumbersome.  And, we don't want "no" as an option nor put a space as this will cause problems with calcs, etc.  Any suggestions?
0
Free Tool: IP Lookup
LVL 9
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

I would like to create daily task database.
I have 20 tasks daily and 4 users using the database.
I would like to create a dashboard to show which task is not done and end of the day,
would like to email to the users, which tasks did not complete.
0
I would like to create a button on filemaker, once push, it changes color and once day change, color goes back to original color
0
We have FileMaker Server v13 and FM Pro 13 clients, we are moving databases to new SQL Server 2008 SP4  running on Server 2012 R2 (from SQL 2008 SP3 running on Server 2008). When in FM Pro External Data Sources trying to add an existing ODBC connection to SQL Server DB, it's not there. Any ideas why? It's a big deal since it's a critical connection to another DB

Thanks!
0
I'm not aware of dynamic reports existing with Filemaker; however, my boss asked this question:  "Why can’t I have one list report with column headings definable from a pop down menu of all the fields in the Propinfo DB and maybe Finance?  Make the fields sizeable from the column headings.  Then whenever I need to look at something in an over view I can do it easily."

The sizeable part can be done if I render the view a table view, but don't know how you can choose column headings.  Any suggestions or do I have to use a third party sw?  I have FM 15.
0
What is count command in fox pro?
0
Hi,

I need to learn how to export a Filemaker Pro database to Excel as a Pivot Table.

Thanks for your help

Cheers,
Rene
0
The only DB experience I have is (unfortunately) with MS Access.  I'm now creating a software application that interfaces with a DB, so I just went with what I know (Access).  But, I don't really like the user interface, especially for dealing with relations.  Also, it has a very limited range of data types (no real numbers, Booleans use a strange convention for storage, etc.).  And most recently, I've run into an intractable problem whereby I cannot programmatically add or update records (covered in a separate post).  So, now I'm seriously considering moving to another platform.  The two I'm considering are Filemaker Pro (Is that different from Filemaker?), and MS SQL Server.  But, I know essentially nothing about either.  So, I'm looking for some advice on the trade-offs / suggestions for which way to go.  Also, of course I'm wondering what is involved with importing / translating my existing DB to one of the other tools.  (If it matters, the DB has 38 tables, and about 200 fields, but very little data so far.)
0
I added plugin to jstree file manager  :
I would like to open file in Iframe in the modal window
Instead  the code below opens file in the another window in another tab.
I am working in MVC5
Can I open file in Modal Window in MVC5. File   could have external address like   " http://somedomain/test.pdf"

thanks
  $.jstree.plugins.addHTML = function (options, parent) {
                this.redraw_node = function (obj, deep,
                                            callback, force_draw) {
                    obj = parent.redraw_node.call(
                        this, obj, deep, callback, force_draw
                    );
                    if (obj) {
                        var node = this.get_node(jQuery(obj).attr('id'));
                        
                       
                        var html =
                        "<a href='http://localhost:29128/test.pdf'  data-rel='modalDialog' data-dialog-title='Fruits and Nuts'>Fruits and Nuts</a>"
                      
                        if (node && node.type == "FILE") {

                            jQuery(obj).append(

                              html
                            );
                        }
                    }
                    return obj;
                };
            };

Open in new window

0
Have a portal resolving slowly because of an unstored field in the link.  The field's calc is below.  Is there a way to get a Max# without using another table occurrence (which forces an unresolved calc), or do I just need to script it so a companion text field is marked with a "Y" in every record that applies when entering this particular file for the first time on startup?  The point of this particular calc is to mark past Tenants as the most recent 3 prior Tenants that will show in a portal in another file.

If ( GetAsNumber ( TENANTS_ALL::TenantNum ) ≥  Max ( TntsAll_RcntTnts::TenantNum ) - 3  and
IsEmpty ( InTnttableFlag ); "Y" ; "" )
0
[Webinar] Learn How Hackers Steal Your Credentials
LVL 9
[Webinar] Learn How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

I have 3 fields

PW, PB and PTotal
PW AND PB have drop down options as to order 1, 2, 3, and so on.

I want to be able to click on PW and order 2 and PB order 1 and each are 199.00 I want to see the total on the PTotal field.

How can I do that?
0
Is it possible to add a SubSummary Part to a Tab Panel on a layout?
Can it be done inside of a portal?

Can a Summary field type be placed somewhere other than in a SubSummary Part ?
0
Hi,
I did adjust size of file to 512x512 px but I still get rejection to the file due to that it should be 512x512 px. What to adjust?
image018-512x512.jpg
0
Hello! I have created database in FileMaker Pro 15 (under Win10), storing information about equipment which we repair (serial numbers models etc.). Wondering if any way to add multiple PDF service reports to each record. It could be 1 to many (sometimes 10-15) PDF reports for each database record. I would like to have scrollable window with list of reports (including number/date) and clicking on each line will open document in PDF reader. As I aware, FileMaker does not allow anymore OLE objects, by some reason. Is any way to solve my problem or I should look for different software (if so, please advise which I may try as alternative to Filemaker Pro 15). Thank you! Leonid
0
Hi,
How to ensure the attached png file is having size of 16x16?
image018.png
0
Currently running a database in Filemaker 6 on Windows 7 PCs.

In the process of upgrading to Filemaker 14.  

The database migration has been successfully configured and works fine, however, there is an issue with Filemaker 14:
 
The fonts in FileMaker 14 are “blurry” and not as clear or sharp as the fonts in  FileMaker 6 on the PCs.

We have not tried this on a Mac since we do not have them.

Any ideas?
0
Hello
In FileMaker, I created an "Information" table which contains data on people: First Name, Lat Name, Country and Age.
I have populated this table with a few examples
I have then created a second table  called "Search Table" with 2 fields that user can choose: Country and Age
Then I added a button to run a search using a script : display only the records from "Information" table that fit with the data from the Search Table
I don't understand why my script does not work...
Please see attached file
Thanks
-Search-Script.fmp12
0
I've been tasked with importing from Excel sales reports from our tenants.  I started designing per the spreadsheet, but thought I'd ask for best practice.  The spreadsheet is setup with column headings for the months, which translates into separate fields in FM.  However, I think it would give me more flexibility if I had one field for the amount and a field for the month (already planned to have a field for the year).  The drawback is I would have to import one month at a time (so 12 imports) so I could auto enter the month.  See attached screen print (without identifying info).
Capture.JPG
0
I am new to Filemaker and databases---trying to wrap my head around concept and ideas to get a better understanding.  

Many times we write one purchase order for many computers with the same manufacturer and model.  When the computers arrive,  we have to enter each computer's unique information like MAC addresses and SNs.  I was wondering how/if I could create a layout for people to enter Purchase Order information after they complete the PO, but before the computers arrive.  It would work somewhat like this....

1. User would enter the PO information (PO #, funding numbers, acquisition date, etc.)
2.  Enter the quantity of computers, say 25, which will trigger....
3.  25 records with the PO information (and auto generated Asset ID) to be created in the database and
4.  Fields for manufacturer, model, cost per unit, etc would appear for the user to enter information once to propagate to the fields of the 25 newly created records.

After the items arrive, records would already be created to enter the unique information for each item.

Is this possible?  How would I go about making this work?
0
Announcing the Most Valuable Experts of 2016
LVL 6
Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Does the Surface Pro 2 (8GB RAM 256GB storage) have a maximum speed broadband that it can get? I'm paying my ISP for 400Mb but the fastest I can get is 284Mb average over a number of tests via a USB 3 to Gigabit adapter. Before this it was worse. I fought with my ISP until they diagnosed probable faulty cable from nearest junction box to my property. They replaced that cable. The Speed-tests-before-and-after-work-on.pdfSpeed-tests-before-and-after-work-on.pdftechnician's laptop showed close to 400Mb but my Surface Pro 2 only got 237Mb average. Upload gets 40Mb which is what I'm paying for. They blamed my "Plugable USB 3.0 Docking Station" so I bought a USB 3 to Gigabit adapter. Running speed tests on my ISP's own speed test site and leaving the docking station out got me to 284Mb average. So the question is does the Surface Pro 2 have a limit or was the technicians laptop wrong? Testing with other laptops gets worse results.
0
I have a layout that is based on the Cataloging table.
One field from Cataloging is "required value" and you can't continue till it is filled in.
Another field (BldgCode) is from the related table Buildings. It is a "required value" in the Buildings table. But on the layout it can be left blank.
There is a field in the Cataloging table (BldgCode). If I make that field a "required value", wont all layouts based on the Cataloging table have to have the field properly filled in. Even if the field is not on the layout. I think I ran into something like this a couple of years ago.
Is there some way to require a field on a layout to be filled in regardless of its table's field's validation status?
0
I have a "PayPal for FileMaker" solution I put together that uses the Scodigo PHP SmartPill plugin.

Scodigo's plugin has a license I have to buy and then I can distribute it with my solution, however, I need to find a way to hide this license key from people that I distribute my solution to, while still making it available to the solution itself so that it can run properly.

Within the solution file is a script like this:

PHPRegister('123456789', 'Product Name');

So the value 123456789 needs to be hidden from users so they can never see it, but still needs to be available to this function within the solution file that I am distributing.

Is there a way I can store the value in a container field that cannot be accessed by anything but the script, or any other way I can handle this situation?

Any information on this would be greatly appreciated.  Thanks!
0
I am using FileMaker 14. I need to remove the embossed border of the FileMaker webviewer in Windows and display a bcgen.com barcode from data within the database.

Within the webviewer, I can get the barcode to show up but there is the border:
"http://www.bcgen.com/demo/linear-dbgs.aspx?D=" & Table1::ProductGTIN

When I use HTML to remove the border, I cannot get the barcode to be dynamic.
"data:text/html,<body style='border=0;margin=0;overflow:hidden'><html><head><title>IDAutomation_Barcode</title></head><body>
<img src='http://www.bcgen.com/demo/linear-dbgs.aspx?D='Table1::ProductGTIN > </body></html>"

I know there is a simple solution. Please try the attached database and let me know what the correct code is please. Thanks so much!
barcode_database---Copy.fmp12
0
Hi I have created an application in Filemaker Pro 15 and would like to allow users to access my beta version of application for 30 days.
Does anyone have a solution that is easy to use and intergrate and is preferably free or reasonably priced?
0
Is there a way to have portals in Filemaker 14 auto-resize by the number of rows/records?  Ideally, there would also be a max setting, so the # of rows does not grow below the tab page.  The settings I see seem to indicate a static # of rows.  Does Filemaker 15 or 16 have auto-sizing portals?
Capture.JPG
0

FileMaker Pro

3K

Solutions

4

Articles & Videos

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
>