Join us at the 2011 FileMaker Developer Conference in San Diego, which runs from Tuesday, August 2nd through Friday, August 5th. The beautiful Hilton San Diego BayFront is within walking distance from the Gaslamp District and across the street from PETCO Park.
The Support Group Blog
A reader asks:
I created a full name field by calculating First & " " & Last. All are text. It works on the layouts. It works when printing to PDF and preview. I actually see the full name.
I then export the fields to a basic file. All the fields all are what they should be, except for the full name field. It is “0” in every single instance. Why does it not produce text instead of 0?
A reader asks:
Is it possible to create a portal paging system with filtered portals in FileMaker 11? I am interested in showing a portal without the scroll bar. Buttons will take the user to the first, previous, next, and last set of records in the portal. I know this is possible when the filtering occurs on the Relationship Graph but I can’t figure out how to do it when the filtering occurs on the presentation layer in FileMaker 11.
Thanks to all who attended! If you missed the webinar, or want to watch it again, download the recording (which requires the WebEx WRF Player). You can also download the sample FileMaker file used in the presentation.
When it comes to FileMaker Pro, calculations and scripts are your tools to “make stuff happen.” In this webinar, sponsored by FileMaker, Inc. and based on our Advanced Scripting and Calculations class, we explore some techniques for building robust, feature-rich databases with complex calculations, powerful scripted automation, and elegant user interfaces.
When you release new functions or reports to an existing client, you must show them where the new features can be found and how best to go about testing. Changes to a database people use every day—a database they use to get important work done—can trigger a variety of reactions, including alarm and anxiety; effective conversation can help them realize that the scope of the change is manageable. They will be able to do what they always have, but now benefit from new reports or functions. Conditional formatting provides an easy way to spotlight changes in your database. Conditional formatting offers the ability to highlight text or to make text bold or an unusual color. To point out new items, simply use a formula like the following:
This is the first in our series of entries, “How I Got Started with FileMaker.” Jud Wolfskill is Senior Developer of our FileMaker team. He has developed numerous FileMaker systems over the years, for customers such as Dartmouth College, WGBH, MIT, Duke University Press, and Chevron. He is also a regular instructor at Harvard University, teaching FileMaker development for their Center for Workplace Development.
The Support Group has been working with FileMaker for decades, since our founder Rich Coulombre started teaching a FileMaker Pro class at MIT, then at other schools, and then wrote a book on FileMaker Pro 2.
Reader Deborah wites:
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!
This article originally appeared in our old Get ( Answers ) newsletter. I recently heard again from Marcelo, announcing his new consulting company and FileMaker 11 certification (congrats!), and thought I should update this. With some new features introduced in FileMaker 10, this technique is even easier to implement.
Is FileMaker better than other popular environments like MS SQL Server, Oracle Database Standard Edition, Salesforce.com Enterprise Edition, or Force.com Enterprise Edition?
Check out the free white paper from FileMaker, Inc., Supercharging Return on Investment with Rapid Application Development Tools - Total Cost of Ownership. It details just how much better FileMaker Pro is than those other competing platforms in two critical areas: Total Cost of Ownership and Return on Investment.