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

Hi, All - I am a budding FileMaker developer, and I have a new client who wants a POS system The first challenge I need to solve is how do I get the cash drawer to open.

My research has shown I can get Troi Serial but I am hoping to open the drawer natively, or at least perhaps using 360 Scriptmaster plugins send a windows shell command.

The printers are Epson TM-T20, The operating system of the POS tills are Windows 10.

Any guidance is very appreciated.

Thanks!
0
Technology Partners: We Want Your Opinion!
Technology Partners: 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!

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

I need to make a Filemaker Pro application that will match a value in a table just like the following Excel formula:

=INDEX($B$3:$F$7,MATCH($A$11,$A$3:$A$7,1),MATCH($B$11,$B$2:$F$2,1))

I also included the Excel example.

Tariff_v1.0_2.xlsx

Thanks for all your help :)

Cheers,
Rene
0
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
Hi,
Based on schema file like the attached, how can I derive the relevant sample EDI file?
0
We've been running filmmaker 14 with web direct for about a year with minimal issues, all of a sudden users on the web direct are getting the error message Database not available on all databases which are only three.  Even the sample database gives the same error message.  This happens whether it is an external source (computer outside of the office) or internal computer, the regular FM Pro application works fine but the web direct gives that error.  There are no periods in the filename as I have seen in some issues and can't seem to figure this one out.
Even did it on the server that is hosting it and you can see the error message.fm1.jpgfm2.jpg
Any troubleshooting suggestions?

Thanks
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
Free Tool: ZipGrep
LVL 8
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

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
I created a layout based on a table (People). There are two global date fields in the table that I placed on the layout. When I go into Find Mode I can not enter any thing into those two fields.
Can it be done, if so how?
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
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
On Demand Webinar - Networking for the Cloud Era
LVL 8
On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

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

Would like to contact the person who helped David Aaron's with his freezer issues in April, 2006.

I am not able to view the solution that was provided.

I am having similar issues with my current setup and was hoping this solution would also assist me.

Thx!  J
0
Hi experts,

I have a FM solution hosted on a Windows Server. All scripts performed on the server are suddenly responding slow. There are currently only 4 scripts called to perform on the server. All independent of each other and responsible for totally different tasks.

Everything was working fine until yesterday when I imported 30K records into 3 tables. I personally don't think the import has anything to do with it as none of the scripts instructed to perform on the server touch the 3 tables or the records imported. If I go to the layouts for those tables on the client side, all 30K records load/display just fine. Even if I set an empty script to be performed on the server and wait til completion, it still has a significant delay....

I restarted the server, just to rule that out but same issue. There is enough space and RAM as well.

Any suggestions?

Thanks in advance.
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

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
>