May We?

The academic year is just about over for the rest of the country, but not us. Learning is a life-long thing for us devotees of The FileMaker Method!

This session, building on our past lessons, we tackle the hard stuff: Introduction to Calc Sci (Oooh!), and Survey of Great American Self-Join Relationships.

Tim Krebs—who, by the way, was but a mere elementary student himself not that long ago—will walk us through some of the cool things you can do with relationships between two table occurrences of the SAME base table. Come, show your support for student teacher Mr. Krebs and learn about some very handy things to do with the relationship graph that you may not have even thought possible!

Also, Jonathan Fletcher, continuing on with his how-to theme will show you how to write a calculation. Yup, calculations are something that will be with you your entire FileMaker life. It’d be nice to have a few techniques to fall back on when the calcs get tough, don’t you think?

Also, this month we’re premiering a new recurring lesson: How I Solved It. Someone from the ranks of your fellow students will report on a problem each class and walk through the process they used to come up with a solution. Jonathan will will go first with a method to make your basic value list serve double-duty. [No, we don't know what that means either. Guess we'll all find out at the same time next Tuesday.]

Master Songer’s pedagogical prowess is demanded elsewhere for a couple of months, but fear not, he’s agreed to return to his duties for the July class. (Please don’t skip that one—we never know when he’ll spring a pop quiz. Just sayin’.)

And remember the rules, be on your best behavior, Bring Your Own Brown Bag, be in your seat when the noon bell rings, and, please, keep your hands to yourself. Oh, and no shooting spit balls at the back of the teacher’s head. (We’ll be watching next time!)
–The Faculty: Alan, Bill, Brian, Byron, and Jonathan

At our usual scheduled time and place:
Tuesday, May 27nd, 2014 (Remember, FOURTH Tuesday of the month!)
12:00 – 1:00pm – BYOBB*
1:00 – 3:00pm – Class lessons, followed immediately by lab time
1234 S. Third Street, Louisville, KY 40203

Registration for this event is at http://www.kyfmp.com/reg/
Join in the discussion on our listserv at http://fmpug.com/mailman/listinfo/louisville_fmpug.com

*BYOBB = “Bring Your Own Brown Bag.” (Soft drinks are provided.)

Spring Break is over. Back to school.

It’s time, boys and girls, to return to Kentuckiana FileMaker Magnet School, where the geeks are the coolest kids around, and everyone learns new ways to master our favorite tool for business productivity.

Master Byron, the Pedagogue, will be back with the next lesson in his FileMaker 101 series. This month, he’s gonna crank it all the way to 102(!) and go all RELATIONAL on us!

Byron will create a check register on the overhead projector and demonstrate the science behind using the ever-handy Portal object. Take careful notes; there WILL be a test. (And the syllabus says that Byron never grades on a curve! You’ve been warned!)

Adjunct Jonathan, who’s gotten paid for writing a few scripts in his time, will show you how you, too, can find fame and fortune with your trusty keyboard and just minutes a day with his little booklet entitled: How to Write a Script. (Hmm, wonder what that’s about…)

Annnnnnd…as usual, you can bring any question you would like to have discussed. (Be sure to raise your hand and wait until the teacher calls on you. And please don’t laugh at other people’s questions—you don’t want them to laugh at yours, do you?)

So, be on your best behavior, Bring Your Own Brown Bag, be in your seat when the noon bell rings, and, please, keep your hands to yourself.

–The Faculty: Alan, Bill, Brian, Byron, and Jonathan

At our usual scheduled time and place:
Tuesday, April 22nd, 2014
12:00 – 1:00pm – BYOBB*
1:00 – 3:00pm – Class presentations and small-group discussion
1234 S. Third Street, Louisville, KY 40203
Registration for this event is at http://www.kyfmp.com/reg/
Join in the discussion on our listserv at http://fmpug.com/mailman/listinfo/louisville_fmpug.com

*BYOBB = “Bring Your Own Brown Bag.” (Soft drinks are provided.)

Please listen to the following Public Service Announcement
***************************************************************************

Are you an “in-house” developer and your boss needs a little persuading to let you take the afternoon off? Well, practice these in front if your mirror every morning until you’re ready, and then walk right into her office and lay one of these down:

  • We can call it professional development time! Yeah, that’s it!
  • It’s just an afternoon—that’ll cost less than sending me to a class, out of town, for a whole week!
  • I’m kinda lonely being the only FileMaker person here. I need to go hang out with some kindred souls, so I’ll know I’m not the only Filemaker Fanatic in the world.
  • I’ll wash that coat of winter road salt off your car for you!

Whatever it takes, come join us each fourth Tuesday for your Further Fix of Fun FileMaker Fundamentals.

***************************************************************************

Isn’t Triskaidekaphilia Fun?

Bill Heizer (FileMaker Senior Systems Engineer) was with us last month to show off some of the best features of the new FileMaker 13. And provide free pizza. What a deal: feeding mind and body simultaneously! Thanks, Bill!

We’re all learning to love the number 13, and why 13 is our lucky number when it comes to FileMaker. With many features that long-time FileMaker practitioners have been pining for for the better part of 3 decades, 13 brings a new excitement to what we can do with our favorite development platform. We’re gathering together presentations from the membership far and wide for this month and hope that you’ll come join us as we share the love for 13!

–The Committee: Alan, Bill, Brian, Byron and Jonathan

Back to our usual scheduled time and place:
Tuesday, January 28, 2014
12:00 – 1:00pm – BYOBB*
1:00 – 3:00pm – Feature Presentations
1234 S. Third Street, Louisville, KY 40203

Registration for this event is at http://www.kyfmp.com/reg/
Join in the discussion on our listserv at http://fmpug.com/mailman/listinfo/louisville_fmpug.com

*BYOBB = “Bring Your Own Brown Bag.” (Soft drinks are provided.)

FileMaker is Coming to Town!

You better not shout, you better not cry,
You better not pout, I’m telling’ you why,
‘Cause FileMaker is coming to town!
————————————————————
Those of you of significant linguistic ability (or mad Google skills) will already know from the references to “Triskaidekaphilia” in our various notices that we are lovin’ us some 13! Yes, FileMaker 13 is out and you are going to be able to do things with FileMaker better, faster, stronger… than ever before.

To make it official, representatives from the mother-ship themselves, the great and powerful FileMaker, Inc., will be visiting The ‘Ville to show you just what all the excitement is about. Regional Business Account Manager Mark Ringo and North American Senior Systems Engineer Bill Heizer (whom you’ve likely ooh’d-and-ahh’d at before if you’ve attended one of our co-branded new-product-intro-geek-fests before) will be on hand to demo the ground-breaking new features of the latest iteration of FileMaker’s already industry-leading application development platform.

Change of day and location, this month only:
WEDNESDAY, December 18, 2013
Kentucky Farm Bureau building
Cafe Meeting Room (front door and follow the signs)
9201 Bunsen Parkway Louisville, KY 40299

TIME: 12:00pm – 3:00pm

GENERAL AGENDA:
12:00 – 1:00pm – Lunch being provided by FileMaker, Inc.
1:00 – 3:00pm – FileMaker 13 Intro Presentation

Coming Up: Back to our regular fourth Tuesday of the month on January 28th (And you’ll never guess what we’ll be talking about! Well, okay, maybe you might.)

–The Committee: Alan, Bill, Brian, Byron and Jonathan

Sign up: (Food is being provided, so please let us know you are coming)
Registration for this event is at http://www.kyfmp.com/reg/
Join in the discussion on our listserv at http://fmpug.com/mailman/listinfo/louisville_fmpug.com

Date & Time:
Wednesday, December 18th, 2013 (Yes, it’s a Wednesday.)
12:00 PM – 3:00 PM (-ish)
BYOS* Soft drinks and lunch provided. (Don’t forget to thank Mr. Ringo!)

Location:
Kentucky Farm Bureau

*BYOS = “Bring Your Own Self” (And a friend or two.)

Last month:
If you didn’t join us last month, you missed Alan Bird’s great review of what was hot at the most recent FileMaker Developer’s convention.

This month:
Jonathan Fletcher will show off some techniques for value lists that have surfaced in the FM developer community lately. One technique in particular is a “game-changer” allowing us to do something with value lists that you never could before! If you do many popups, drop downs or any of the other uses of value lists, you will want to see this!

Jason Scharf will demonstrate how you can have your FileMaker solutions access your company’s “directory server” for a very convenient “single sign-on” capability. No more setting credentials in multiple files every time even one user needs to be added to or deleted from accessing FileMaker. If you have a lot of files and/or a lot of people this one can be a real time-saver!

Then as usual, you may bring whatever issue, questions, trick to share, or just plain curiosity that you may have and we’ll talk it to death for you (“all part of the service, ma’am”). It’s kind of like our own little version of the Car Talk guys’ “Stump The Chumps!” Only with chumps that are real tech nerds as well. (An awesome combination if we do say so ourselves!)

See you this coming Tuesday.

Coming Soon:
We have a big surprise coming for you sometime in the next few months, so stay tuned. No details yet, but you will love it!

–The Committee

Sign up:
Registration for this event is now available at
http://www.kyfmp.com/reg/
Join in the discussion on our listserv at
http://fmpug.com/mailman/listinfo/louisville_fmpug.com

Date & Time:
Tuesday, September 24th, 2013 (Our usual Fourth Tuesday schedule.)
12:00 PM – 3:30 PM (-ish)
BYOBB*. Soft drinks provided.

Location:
1234 South Third Street Louisville, KY 40203
http://goo.gl/maps/Ggo0V

*BYOBB = “Bring Your Own Brown Bag”

An August Body

This month:

“A thousand FileMaker developers walk into a hotel…”

“And…?” You ask.

Well, what do you think? They talked about FileMaker, of course!

For days. And nights.

And you didn’t go.

But don’t fret. Straight from their exciting visit to ever-balmy San Diego and the 2013 FileMaker Developers Conference, a crack team of your fellow developers group members will bring you the highlights of their best remembrances of sessions, keynotes, and impromptu conversations around the table, in the hallways, and sipping lemonade (yeah, right!) out by the pool.

You will hear about new techniques, new ideas, and of course, new products, all in service of the FileMaker world we live in.

Then, as is our custom, we will spend our remaining time talking about whatever tickles our fancy in the world of FileMaker, solving problems, and sharing our latest issues and success stories.

Come join us for one of the geekiest travelogues you will ever hear. Next Tuesday, the 27th.
–The Committee

Sign up:

Registration for this event is now available at http://www.kyfmp.com/reg/
Join in the discussion on our listserv at http://fmpug.com/mailman/listinfo/louisville_fmpug.com

Date & Time:

Tuesday, August 27th, 2013 (Our usual Fourth Tuesday schedule.)

12:00 PM – 3:30 PM (-ish)
BYOBB*. Soft drinks provided.

Location:

1234 South Third Street Louisville, KY 40203
http://goo.gl/maps/Ggo0V

*BYOBB = “Bring Your Own Brown Bag”

Midsummer Afternoon’s Dream

Your client (or your boss) calls you up and says, “Hey, FileMaker Gal [or Guy], our accountant tells us we have to use Quickbooks. Can you connect that whiz-bang workflow app that you wrote for us to QuickBooks so we can post invoices and share client data with it and stuff?” Your immediate response is “Sure! No problem!” And then you think to yourself, “Wait a minute. What did I just get myself into?” Well, if you’d already been to this month’s FileMaker Developers Group meeting you would know that it’s really nothing all that difficult and there is a pretty nice tool that makes short work of all kinds of FileMaker-to-QuickBooks interaction.

Come July 23rd, we will be having a presentation by Productive Computing, the makers of fine enhancements to the FileMaker platform. In addition to the aforementioned Quickbooks integration tool, they make other utilities, including ones for connecting to Outlook, Address Book, and iCal, for processing credit cards, reading biometric scanners, and a really handy printer switcher for Windows.

If one or more of those sounds like something you would like more information on, please let us know and we will make sure that gets included in the presentation.

Then, as is our custom, we will spend our remaining time talking about whatever tickles our fancy in the world of FileMaker, solving problems, and sharing our latest issues and success stories.

Come join the fun next Tuesday, the 23rd.

Send your requests to

–The Committee
Alan, Bill, Brian, Byron & Jonathan

Upcoming:
Next month, we will hear from those of our members fresh off their trip to the FileMaker Developers Conference in San Diego. Come be regaled with accounts of the best of the best that the FileMaker developer world has to offer!

Sign up:
Registration for this event is now available at http://www.kyfmp.com/reg/
Join in the discussion on our listserv at http://fmpug.com/mailman/listinfo/louisville_fmpug.com

Date & Time:
Tuesday, July 23rd, 2013 (Our usual Fourth Tuesday schedule.)
12:00 PM – 3:30 PM (-ish)
BYOBB*. Soft drinks provided.

Location:
1234 South Third Street Louisville, KY 40203

*BYOBB = “Bring Your Own Brown Bag”

Monkey Bread Software

Taylor Sharpe spoke to the FMPUG-Dallas Chapter on July 5, 2013, about the Monkey Bread Software (MBS) plugin for FileMaker.   MBS is a Swiss-Army knife of plugins supporting many different utility functions such as encryption, image modification, file manipulation, etc.  The plugin has over 1100 functions and we only had time to go over a examples from each of the different sections.  But we also had a good open discussion about plugins and their advantages and disadvantages.  We had a pretty good crowd in light of it being right in the middle of a long 4th of July weekend for most people.  Thanks for all who came.

XML/REST-y Database Manipulation

Brad Stanford came and made quite a presentation on May 3, 2013, about FileMaker and evaluating ways to look at schema and interface in different ways and how to by pass FileMaker’s standard way of handling schema through putting whole records (or databases) in single fields and using repeating fields to store all the fields on a layout so that the layout is only one field with a bunch of repetitions of the same field.  While this was good for stretching the mind and looking at how FileMaker does things, it also brought up a few interesting aspects.  One thing Brad discovered was that FileMaker is much faster at importing a record with one field and 1000 repetitions than it is than it is in importing one record with 1000 fields.  The speed increase is dramatic and has some possible uses in moving data around.  It truly was a presentation to stretch the mind in thinking about how schema, data and the user interface all work together and how we might work around some of those paradigms FileMaker has given us.

ExecuteSQL – Stephen Sykora

Stephen Sykora and Robert from Harmonic Data came to speak to us about ExecuteSQL on April 5th, 2013.  This is a new feature in FileMaker 12 and now that this version has been out a year, many of us are learning to dive deeper into the new features.  Robert created a sample database that Stephen demonstrated to us to show us how to not only use ExecuteSQL, but how to use it in a reporting table made up of calculations from variables out of a ExecuteSQL function.  It was quite impressive and Robert said he would make it available to anyone wanting a copy.  Just send him an email at Robert@Harmonic-Data.com.

Thank you for everyone who showed up.  We had quite a crowd of 27 people and it was good seeing everyone.  Hope to see you next month!