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

I would like to create a button on filemaker, once push, it changes color and once day change, color goes back to original color

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.
Any troubleshooting suggestions?

Thanks

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.

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?

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

Select all Open in new window

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?

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

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?

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.

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