Top 5 Reasons to know the Let() function

I can certainly understand why the Let function isn’t the first thing newer FileMaker developers decide to learn. First, it’s a very complex looking function, and it isn’t inherently obvious in terms of the benefits you’ll receive for knowing...

Sort numbers and text

I have a table set up for reports, ReportMatrix, the field names are all data01 data02 data03... data76 etc The reports are built by numerous scripts that dump all values into the fields, with the first row holding the headings. I use placeholder text to display the...

Relationship Based Data Filtering

For some developers who are new to FileMaker, they may not come from a background of having worked with SQL or some other query language. Creating joins on the fly, as data is needed, is a foreign concept. Yet, when you create a relationship within the Relationship...

Relationship setup problem

I have some filtered portals that I need to turn into portals that are filtered by relationship. I can not figure out how to set this up properly. I'm trying make a portal that will show me a list of all of the photos that still need to be Touched-Up. When a photo is...

Filtered portal displays only first value of records

I have a standard invoice database with Invoice, Invoice Data, Products table. I have added a child table named Button to the product table (related by ProductID)that is used to create buttons in portals on the invoice table. The Button table has a product match...