A FMT Preferred FileMaker Consultant - Developer
Log in
Hot & Trending on FMT
12ti Studios

12ti Studios

12ti Studios was founded to bring exceptional software design and experience together with a venture capital-like approach to helping small businesses, and businesses-to-be, create innovative software products.

It all started when people came to founder Chad Novotny with ideas. During his career as Vice President of Technology for a custom software development company, he had been approached by many people, each with an idea for a product or service. In return for equity, they would ask, could he build their ideas for no charge? Unfortunately, he had to say no; that wasn’t the business his firm was in. But Chad always wondered what could have happened had he been able to say yes.

When Chad left his previous position and joined The Venture Capital Fund of New England as Entrepreneur-in-Residence, (after having personally been involved in several VC investment opportunities and “gotten the bug”), he decided to also launch 12ti Studios. The mission is to provide not just software development, but to partner with and assist in the development of businesses that traditionally would be unable to take advantage of venture capital.

12ti continues the tradition of Chad’s contributing to the FileMaker community — experienced developers and beginners alike — by sharing techniques, tips, and thoughts through its blog. We welcome your feedback and ideas.

To find many more in depth articles from Chad and some must have tools and services from 12ti Studios visit their site at the link below:

Website URL: http://12ti.com

Searching Across Relationships for Empty Fields

Have you ever wanted to find records where a certain field is empty? Suppose you are updating your contact database and trying to capture email addresses for as many people as possible.  You need to find every person for whom you do not have an email address.

Running Totals in a Portal

I want to get running totals or summaries in my portal rows for number fields. Also, I want my portal rows to show a row number in a “self” relationship portal (I tried the Get(PortalRowNumber) function and could not get it to work). Hope that you can help. Thanks!

Aggregating Filtered Portals

If you’ve played with FileMaker Pro 11’s filtered portals at all, you may have discovered its biggest stumbling block:  aggregate functions and related data.  All of your calculations summarizing related records no longer reflect what appears in the filtered portal.  Various solutions have been proposed using script triggers and merge variables, but they can require some foresight and maintenance.  Fortunately, there’s an even easier solution for the majority of cases where you need to total up related records.

Highlight the active field with conditional formatting

A not-uncommon request we’ve received over the years is to highlight the current field with something more than slightly darker field borders.  Conditional formatting seems the perfect answer: there must be a way to change a field’s background fill from its default to another color on entering the field, right?

Subscribe to this RSS feed