Where is the Remote ?!? Part 1, Referencing a Remote Container

Very Cool Remote Control

Remote containers are a great new feature in FileMaker.  It lets you keep the size of your databases smaller.  I have one database that went from over 6GB to just 500MB when I moved the containers from internal to remote.  It made the backups faster and saved a lot of space on their backups!  In this first installment of a short series about containers, we will review how to reference a remote container. Continue reading ‘Where is the Remote ?!? Part 1, Referencing a Remote Container’

 

Please join us: Guided User Interaction (D. Todd Weller, Presenter)

Please join us:

Thursday, April 24, 2014

6:00 PM

IT Solutions Consulting, Inc.
414 Commerce Drive
Suite 150
Fort Washington PA 19034

Note: Pizza as always will be provided after the presentation, around 7:15 PM

Guided User Interaction

Presenter: D. Todd Weller

In any database solution, the preservation of data integrity is the primary goal of every developer.  With the FileMaker platform, there are many “out of the box” features that provide the required data validation and verification.  This presentation takes the next step as we will examine a number of techniques that allow developers to guide the user through the solution in the layout layer and help preserve data integrity by showing the user only the needed fields for the task at hand.  There are a number of layout objects and simple scripts that give developers a way to present choices to ensure that the correct business processes are followed for the given solution.  With the December 2013 release of FileMaker 13, the presentation with spotlight a few of the new features of FileMaker 13 that can be used when guiding the user through a solution.

Todd Weller is the Senior Data Systems Architect with Cross IT Services and Solutions, LLC.  He has been using and developing FileMaker databases for over 12 years for both in-house and outside client solutions, starting with FileMaker 6, and is a FileMaker 12 Certified Developer.  He holds an electrical engineering degree from Grove City College.  Prior to his FileMaker experience, he worked in industry for an electrical engineering firm that specialized in systems integration as a PLC and Drive System programmer and troubleshooter.”

About the Philadelphia FileMaker User Group

The Philadelphia FileMaker User Group was founded in 2004 as an initiative by FileMaker Business Alliance Platinum member IT Solutions Consulting.  The group’s goal is to provide an open forum for FileMaker developers and those interested in FileMaker to meet, brainstorm and network.

We hold meetings the 4th Thursday of every month at 6PM, in the office of IT Solutions Consulting, Inc., at 414 Commerce Drive, Suite 150, Fort Washington PA.

Meetings are open to all, regardless of background and there’s no charge to attend.

Mailing List

Blog

Twitter

FMPug Chapter

The Philadelphia FileMaker User Group is sponsored by:

 

IT Solutions Consulting, Inc.

Employee ownership – fueling our innovation, strengthening your business.

http://www.itsolutions-inc.com/

 

Please join us March 27th: Client Feedback Modules, and Gianine Campbell, FileMaker BAM

Please join us March 27th at the Apple Store King of Prussia at 6 PM!

RSVP HERE

FileMaker: Client Feedback Modules  
and
FileMaker BAM Gianine Campbell

Client Feedback Modules

Jerry Salem

This month we will walk through the process of creating a Client Feedback Module for your FileMaker databases.

Accidents happen.

People sometimes use your solution in ways you haven’t imagined.  When something goes wrong, it’s important to document the event right away, before the user forgets the details of the event.

In this presentation Jerry will discuss the benefits of client feedback modules and demonstrate techniques for capturing user feedback “in the moment of insight”.

FileMaker BAM Gianine Campbell

Please join us in welcoming Gianine Campbell, the new FileMaker Business Account Manager for the greater NYC Metro region, including the Philadelphia territory.  Gianine will introduce herself and spend about 10 minutes talking through her role and the benefits of the FileMaker platform.

About Jerry Salem

Dr. Jerry Salem began his career in technology as a computer science major, eventually moving to the biological sciences where he earned his Ph.D in Biochemistry. During that time he published papers on malaria, tuberculosis, and AIDS. He holds a U.S. patent and has spoken internationally on numerous topics.

As a researcher, Jerry learned computer networking, web design, and FileMaker. He has worked in various technology fields developing a number of solutions, including electronic medical records software and complex systems for many businesses and organizations.  Along the way he has mastered standard SQL tools and a variety of other technologies.

Since 2007, Jerry has worked at IT Solutions, a Platinum level member of the FileMaker Business Alliance. Among his accomplishments since joining ITS are certification in FileMaker versions 8 through 12, leadership as an educator in the FileMaker Training Series program, and frequent contributions to the Philly FileMaker User Group.

About Gianine Campbell

Gianine comes to FileMaker with 5+ years of successful Sales experience at Xerox Corporation and most recently at ADP Corporation. Gianine brings to FileMaker a strong and rounded sales background selling into and managing growth accounts. She is a graduate of Providence College and is a classically trained Soprano, and has performed with Peter Nero and the Philly Pops just this past Fall.

About the Philadelphia FileMaker User Group

The Philadelphia FileMaker User Group was founded in 2004 as an initiative by FileMaker Business Alliance Platinum member IT Solutions Consulting.  The group’s goal is to provide an open forum for FileMaker developers and those interested in FileMaker to meet, brainstorm and network.

We hold meetings the 4th Thursday of every month at 6PM, in the office of IT Solutions Consulting, Inc., at 414 Commerce Drive, Suite 150, Fort Washington PA.

Meetings are open to all, regardless of background and there’s no charge to attend.

Mailing List

Blog

Twitter

FMPug Chapter

The Philadelphia FileMaker User Group is sponsored by:

600_322485152

 

 

IT Solutions Consulting, Inc.

Employee ownership – fueling our innovation, strengthening your business.

http://www.itsolutions-inc.com/

 

Please Join Us February 27th: Data to GO: Practical uses for Mobile Solutions in the FileMaker 13 Platform

Please join us February 27th for a special meeting at the Van Pelt Library Building on the U Penn Campus in West Philly!

February 27th 2014
6-8 PM

Van Pelt Library, Room 302
3420 Walnut Street, Philadelphia PA

Data to Go: Practical uses for Mobile Solutions in the FileMaker 13 Platform

From real-time customer updates and quotes, to order processing, project management, and time tracking — user-friendly mobile solutions are assisting small companies and educational institutions to get ahead and stay ahead. Jerry Salem, FileMaker Consultant and Colin Keefe, Project Manager at IT Solutions Consulting, Inc., will provide expert insights into custom programming that helps clients develop mobile apps that make back-office information accessible in real-time across a variety of platforms and devices. From laptops to smartphones to tablets, learn how the device choice is no longer a limitation now that the software can be tailored to fit them all.

Jerry Salem will start out with a discussion of new iOS features in FileMaker 13 with coding examples. Colin Keefe will walk through some real world use cases. WebDirect and Go will both be discussed in detail.

The group will meet in the Fireside Lounge in the newly renovated ARCH Building. Pizza will be provided.

About the Philadelphia FileMaker User Group

The Philadelphia FileMaker User Group was founded in 2004 as an initiative by FileMaker Business Alliance Platinum member IT Solutions Consulting. The group’s goal is to provide an open forum for FileMaker developers and those interested in FileMaker to meet, brainstorm and network.

We hold meetings the 4th Thursday of every month at 6PM, in the office of IT Solutions Consulting, Inc., at 414 Commerce Drive, Suite 150, Fort Washington PA.

Meetings are open to all, regardless of background and there’s no charge to attend.

Meetup

Mailing List

Blog

Twitter

FMPug Chapter

The Philadelphia FileMaker User Group is sponsored by:

 

 600_322485152

IT Solutions Consulting, Inc.

Employee ownership – fueling our innovation, strengthening your business.

http://www.itsolutions-inc.com/

 

Please Join Us January 23: To Sync or Not to Sync, That Is the Question (Eric Morrison, Presenter)

January 23, 6-8 PM at the ITS office
414 Commerce Drive, Suite 150
Fort Washington PA 19034

Note: Pizza is provided at the end of the presentation, around 7:15 PM.

syncdek_full_trans-300x300

To Sync or Not to Sync, That is the Question 

Presenter: Eric Morrison 

Distributing your data across multiple servers and clients is a really bad idea unless it’s a really good idea. In this session we will explore why you might want to distribute and sync your data, the downside, the upside and what you can expect if you choose this path using the SyncDeK product from Linear Blue. While there are risks and challenges, in the right business this solution can be magical.

About the Presenter 

Eric Morrison is the Director of IT and the primary in-house FileMaker Developer for Insigniam, a Management Consulting firm with offices in Philadelphia, Los Angeles, Paris and Hong Kong. Eric began developing in Excel and moved to Nashoba’s FileMaker 4 shortly thereafter. After a long hiatus from serious FileMaker Development, in 2010 Eric once again became a full-time FileMaker Developer as Insigniam decided to develop a system to run its business based on the FileMaker Platform. The system is fully operational and in daily use throughout the world with data being replicated across the entire network using SyncDeK.

About the Philadelphia FileMaker User Group

The Philadelphia FileMaker User Group was founded in 2004 as an initiative by FileMaker Business Alliance Platinum member IT Solutions Consulting.  The group’s goal is to provide an open forum for FileMaker developers and those interested in FileMaker to meet, brainstorm and network.

We hold meetings the 4th Thursday of every month at 6PM, in the office of IT Solutions Consulting, Inc., at 414 Commerce Drive, Suite 150, Fort Washington PA.

Meetings are open to all, regardless of background and there’s no charge to attend.

Mailing List

Blog

Twitter

FMPug Chapter

The Philadelphia FileMaker User Group is sponsored by:

 

IT Solutions Consulting, Inc.

Employee ownership – fueling our innovation, strengthening your business.

http://www.itsolutions-inc.com/

 

Show and Hide Objects in FileMaker 13

By Jerry Salem

FileMaker 13 is finally here. It was worth the wait. Arguably one of the most exciting features in this release is the ability to hide objects based on a calculation. In the past we have been able to hide objects using a number of tricks. For example, using a broken portal to hide a button or using conditional formatting to insert hidden text. Now, just like a magician you can wave your wand and make an object disappear! In this post we will look at when and when not to use this new ‘hidden’ attribute.

Continue reading ‘Show and Hide Objects in FileMaker 13′

 

Please Join Us: FileMaker 13 Showcase at the Apple Store in Philadelphia – Year End Bonanza and 100th Meeting!

Our next meeting is December 12th from 6-8 PM at the Apple Store on Walnut Street in downtown Philadelphia!

Ronnie Rios from FileMaker Inc. will be presenting on the new features in FileMaker 13!

FileMaker 13 was released today – it is a very big release with significant platform changes and a serious focus on mobile and web delivery.

We’ll have Ronnie Rios with us again to give us an overview on FileMaker WebDirect, iOS keyboard enhancements, Popovers and Slide Controls, Custom Themes, Object Control Visibility, 256 bit EAS encryption, and more!

Catered food will be provided for this presentation, so please RSVP so we can get an accurate headcount.

This is also our 100th Philadelphia FileMaker User Group meeting! And our Year End Bonanza!

You DON’T want to miss this.  RSVP HERE.

 

Please Join Us December 12: 9th Annual Year End Bonanza AND our 100th meeting!

This is more of a placeholder for you over-planners:

Our next meeting is December 12th from 6-8 PM.   It may or may not be at our office, we’re still sussing that out.

The meeting will be held at the Apple Store on Walnut Street in downtown Philadelphia.

We’ll have more details about presentations as we approach December.  FileMake

This will be our 9th annual party, where we perform feats of strength, air our grievances, and eat non-pizza-like food.

It will ALSO be our 100th meeting!  That’s a heck of a lot of meetings.

And here they all are – what we know about them, anyway:

 

5/27/2004 1st Meeting: FileMaker 7 Review
6/24/2004 FileMaker 7 Basics, Script Parameters
7/22/2004 FileMaker 7 review/tips/tricks Continue reading ‘Please Join Us December 12: 9th Annual Year End Bonanza AND our 100th meeting!’

 

Respect the Inspector – What to try if a Pop-Up Menu appears blank

Recently I was tasked with converting an existing FileMaker 11 solution to FileMaker 12.  As is often the case, the conversion was quick and painless and the solution just plain worked as expected in FileMaker 12.  However, I noticed something strange about the pop-up menus on some of the layouts.  Many (not all) of the menus appeared to be blank although they actually had values selected.  If I clicked on the menu, I could see the list of values to choose from, and the existing data was checked.  But if I released the menu, all I could see was the blank box.

“Hmmm.  Ok.  That’s weird,” I thought.  So I went into layout mode and placed a new field on the layout, formatted it as a pop-up menu, and selected the same value list to see if that resolved the issue.  When I went back into browse mode I was surprised to see that the new fresh field still didn’t show me that there was something selected in the field.  I returned to layout mode and added a plain field, without the menu.  Back in browse mode I could see the number that was in the field.  The data was definitely there.

Next I checked the Value List to see how it was set up.  Everything looked good.  It was a list that had the key as the first field and a description as the second field, with only the second field showing to the user.  I looked at other Value Lists as well and they were all set up the same way.  Some were displaying correctly on the layouts and others were not.

Okay, back to layout mode.  “I’m going to figure this out!”  I went to a layout that had one menu that worked, and one that didn’t.  Let me just say now that the Inspector palette rocks!  I clicked back and forth selecting the menu field that worked and the menu field that didn’t, and I noticed a screen jump – or more precisely a palette jump.  Whenever I clicked on the one that didn’t work, the Data Format area showed that the field was formatted as Decimal.  When I clicked on the menu that worked, the field was formatted as General.  Ah ha!  I changed the one that didn’t work to the General format, entered Browse mode, and now it displayed correctly.

FM_Inspect_Compare

So there you have it.  When something isn’t displaying as expected, always remember to check the way that it is formatted.  Numbers and Text can be formatted differently, and if you copy/paste your fields you will be inheriting the format that you copied.  I hope this reminder saves you some hair pulling.

Happy FileMakering!

 

 

Auto-highlight a new portal row using conditional formatting and an onTimer script

When you’re building a robust FileMaker solution, you might find yourself in a situation where you want to control additions to a portal row via a scripted process rather than by using the “Allow creation of records in this table via this relationship” option on your TOG. The problem with this is that when you return to the original layout, your user might not be able to immediately tell which record was added.

So let’s take a page from some of the slicker web interfaces and highlight a new row when it’s created.

Here’s a Job screen with a simple Task list via portal row.

job_screen_1

As you can see, there’s already an “empty” field behind the data fields being used to highlight rows–if the task is completed, then the row is gray. If the task is started, the row is light blue. Otherwise, there aren’t any field shenanigans going on here, the interface is based on a simple three-table structure. Job, Tasks, and a join table (JobTask). The portal will always be sorted by the “Rank” field which is looked up (but editable). Continue reading ‘Auto-highlight a new portal row using conditional formatting and an onTimer script’