Meeting: 6/15/2017 – Remote Presentation on WebViewer Integrations

**Location Note: we will be in room 248 at the foundry, this was the nicer room next door to where we were last month. If you remember your way, feel free to walk up to room 248. **

COFMUG’s June meeting will be at the Columbus Idea Foundry, 421 W State St, Columbus, OH 43215. This month’s meeting is Thursday 6/15/2017. Please review parking and access instructions below. The foundry is BYO for food and drink, so you are welcome to bring what you’d like as long as you clean up after yourself.

As a reminder, our meetings are scheduled on the third Thursday of every month. Future meetings include July 20th and August 17th.

Our function of the day will be a new FileMaker 16 function: Get(AccountGroupName).

This month, we’re featuring a remote presentation by Jeremy Brown of Soliant Consulting:
The Web Viewer object is fascinating. It allows us to integrate the languages of the web (HTML, CSS, and JavaScript). We’ll explore best practices of using a JavaScript library in FileMaker and discuss the pros and cons of working with an integration. Our session will include manipulating an integration from the Web Viewer Integrations Library and how to push it to our own custom app.

About Jeremy Brown:
Jeremy is proud to be a FileMaker 12-15 certified developer. He has worked previously at a charter school network where he built the student information system used for three schools. As with many other developers, he stumbled into the world of FileMaker and has become fascinated with solving business needs in the platform. He is an amateur magician and is currently addicted to the game “Factorio”.

Want to watch past meetings? Check them out on YouTube: https://www.youtube.com/channel/UC9WR_kgfKUR9OwMbdJiAy-g

Date & Time
Date: Thursday June 15th, 2017
Time: 6:00pm – 8:00pm

Location:
Columbus Idea Foundry
421 W State St.
Columbus, OH 43215

AGENDA:
6:00pm – Social Time.
6:30pm – Function of the day, Presentation
7:45pm – Wrap-up, Q&A, Announcements, etc..
8:00pm or later – End of meeting, possible post-meeting get together.

Hope to see you there!
Mike Beargie
MainSpring, Inc.

—————————————————–
DIRECTIONS:
GOOGLE MAP OF LOCATION:
https://goo.gl/maps/Eb6BwMcxxGs

PARKING:
Street parking is available on State St. and other surrounding streets. The Idea Foundry also has a private gravel lot located on the west side of the building at the corner of State & McDowell. The gravel lot entrance is located on Chapel St. on the South side of the Idea Foundry.

ENTRANCE:
Please use the front entrance of the building on State Street. If you remember the way to the conference room upstairs, feel free to head up. Otherwise Mike or Joe will meet you in the lobby to show you the way to room 248.

Meeting: 5/18/2017 – FIleMaker 16 Arrives **Meeting Location Change**

***MEETING LOCATION HAS CHANGED***

COFMUG’s May meeting will be at the Columbus Idea Foundry, 421 W State St, Columbus, OH 43215. This month’s meeting is Thursday 5/18/2017. Please review parking and access instructions below. The foundry is BYO for food and drink, so you are welcome to bring what you’d like as long as you clean up after yourself.

As a reminder, our meetings are scheduled on the third Thursday of every month. Future meetings include June 15th and July 20th.

Our function of the day will be the new FileMaker 16 functions UniqueValues() and SortValues().

This month, there is a TON of new content to review with the release of FileMaker 16. Todd Geist calls 16 “The biggest release since FileMaker 7” and other critics agree. We will be looking at the new features of FileMaker 16 in a rapid-fire format, with some demos of some of the new features gathered from resources around the community.

Want to watch past meetings? Check them out on YouTube: https://www.youtube.com/channel/UC9WR_kgfKUR9OwMbdJiAy-g

Date & Time
Date: Thursday May 18th, 2017
Time: 6:00pm – 8:00pm

Location:
Columbus Idea Foundry
421 W State St.
Columbus, OH 43215

AGENDA:
6:00pm – Social Time.
6:30pm – Function of the day, Presentation
7:45pm – Wrap-up, Q&A, Announcements, etc..
8:00pm or later – End of meeting, possible post-meeting get together.

Hope to see you there!
Mike Beargie
MainSpring, Inc.

—————————————————–
DIRECTIONS:
GOOGLE MAP OF LOCATION:
https://goo.gl/maps/Eb6BwMcxxGs

PARKING:
Street parking is available on State St. and other surrounding streets. The Idea Foundry also has a private gravel lot located on the west side of the building at the corner of State & McDowell. The gravel lot entrance is located on Chapel St. on the South side of the Idea Foundry.

ENTRANCE:
Please use the front entrance of the building on State Street. You will be met by either Mike or Joe as accompaniment is required for non-members to our second floor meeting space. Please wait in the lobby until Mike or Joe can escort you to the meeting room.

Meeting: 4/20/2017 – Using Python to run statistical analysis on FileMaker data.

COFMUG’s April meeting will be at the Smokehouse Brewing Company, 1130 Dublin Road, Columbus OH. 43215. This month’s meeting is Thursday 4/20/2017. Please note that you are encouraged to purchase food and drink to support our meeting location’s business. There will be no additional second location for post-meeting social time.

As a reminder, our meetings are scheduled on the third Thursday of every month. Future meetings include May 18th and June 15th.

Our function of the day will be the three clipboard functions from BaseElements. Note that we are going to start using Custom Functions and Plugin Functions for FOTD as well now!

This month, Travis Risner will present a method for connecting to FileMaker data using Python, and running statistical analysis on that data using a Python library called Pandas. The data source has been shared and will be explained by Paul Conaway.

At the end of the meeting, we will discuss our meeting relocation to the Columbus Idea Foundry starting with our May meeting.

Want to watch past meetings? Check them out on YouTube: https://www.youtube.com/channel/UC9WR_kgfKUR9OwMbdJiAy-g

Date & Time
Date: Thursday April 20th, 2017
Time: 6:00pm – 8:00pm

Location:
Smokehouse Brewing Company
1130 Dublin Road
Columbus, OH 43215

AGENDA:
6:00pm – Social Time, ordering food.
6:30pm – Function of the day, Presentation
7:45pm – Wrap-up, Q&A, Announcements, etc..
8:00pm or later – End of meeting.

Hope to see you there!
Mike Beargie
MainSpring, Inc.

—————————————————–
DIRECTIONS:
GOOGLE MAP OF LOCATION:
https://goo.gl/maps/ExEBwNbb1Sx

PARKING:
There is ample free parking on the east side of the smokehouse brewing company.

ENTRANCE:
Please use the regular restaurant entrance, tell the hostess you are here for the developers group in the private room.

Meeting: 3/16/2017 – Building a perpetual slide control

COFMUG’s March meeting will be at the Smokehouse Brewing Company, 1130 Dublin Road, Columbus OH. 43215. This month’s meeting is Thursday 3/16/2017. Please note that you are encouraged to purchase food and drink to support our meeting location’s business. There will be no additional second location for post-meeting social time.

As a reminder, our meetings are scheduled on the third Thursday of every month. Future meetings include April 20th and May 18th.

Our function of the day is CustomList. Note that we are going to start using Custom Functions for FOTD as well now!

This month, We will discuss a technique to take a slide control object with only three slides, and make it behave like it has an infinite amount of slides. In our example, we will build a week view calendar that can scroll back and forth between weeks perpetually.

We will end the meeting with a discussion on whether or not people want to move back or alternate meetings at the Columbus Idea Foundry, since the renovation to their building is complete.

Want to watch past meetings? Check them out on YouTube: https://www.youtube.com/channel/UC9WR_kgfKUR9OwMbdJiAy-g

Date & Time
Date: Thursday March 16th, 2017
Time: 6:00pm – 8:00pm

Location:
Smokehouse Brewing Company
1130 Dublin Road
Columbus, OH 43215

AGENDA:
6:00pm – Social Time, ordering food.
6:30pm – Function of the day, Presentation
7:45pm – Wrap-up, Q&A, Announcements, etc..
8:00pm or later – End of meeting.

Hope to see you there!
Mike Beargie
MainSpring, Inc.

—————————————————–
DIRECTIONS:
GOOGLE MAP OF LOCATION:
https://goo.gl/maps/ExEBwNbb1Sx

PARKING:
There is ample free parking on the east side of the smokehouse brewing company.

ENTRANCE:
Please use the regular restaurant entrance, tell the hostess you are here for the developers group in the private room.

Meeting: 2/16/2017 – FMPerception

COFMUG’s February meeting will be at the Smokehouse Brewing Company, 1130 Dublin Road, Columbus OH. 43215. This month’s meeting is Thursday 2/16/2017. Please note that you are encouraged to purchase food and drink to support our meeting location’s business. There will be no additional second location for post-meeting social time.

As a reminder, our meetings are scheduled on the third Thursday of every month. Future meetings include March 16th and April 20th.

Our function of the day is TBD.

This month, Dave Ramsey will be presenting FMPerception from Geist Interactive, and demonstrating how it can help you become a better, faster, and more confident FileMaker Pro developer.  You’ll also get a sneak peek at what’s coming in the next release.
FMPerception™ is the fastest, most-accurate database utility for searching, analyzing and maintaining FileMaker custom apps. It helps you develop the highest-quality FileMaker custom apps – faster and easier than ever before.

Want to watch past meetings? Check them out on YouTube: https://www.youtube.com/channel/UC9WR_kgfKUR9OwMbdJiAy-g

Date & Time
Date: Thursday February 16th, 2017
Time: 6:00pm – 8:00pm

Location:
Smokehouse Brewing Company
1130 Dublin Road
Columbus, OH 43215

AGENDA:
6:00pm – Social Time, ordering food.
6:30pm – Function of the day, Presentation
7:45pm – Wrap-up, Q&A, Announcements, etc..
8:00pm or later – End of meeting.

Hope to see you there!
Mike Beargie
MainSpring, Inc.

—————————————————–
DIRECTIONS:
GOOGLE MAP OF LOCATION:
https://goo.gl/maps/ExEBwNbb1Sx

PARKING:
There is ample free parking on the east side of the smokehouse brewing company.

ENTRANCE:
Please use the regular restaurant entrance, tell the hostess you are here for the developers group in the private room.

Meeting: 1/19/2017 – Make a Javascript Widget

Ring in the new year and learn a new FileMaker skill at the Smokehouse Brewing Company, 1130 Dublin Road, Columbus OH. 43215. This month’s meeting is Thursday 1/19/2017. Please note that you are encouraged to purchase food and drink to support our meeting location’s business. There will be no additional second location for post-meeting social time.

As a reminder, our meetings are scheduled on the third Thursday of every month. Future meetings include February 16th and March 16th.

Our function of the day is GetLayoutObjectAttribute().

For our main discussion, Mike will give an introduction to using javascript to create a webviewer “widget” in FileMaker. This handy technique has unlimited potential for integrating highly interfaced data in your filemaker solution. We will cover the basics of:

  • Why use javascript webviewers, example uses.
  • How to load custom HTML, CSS and JS files into a webviewer.
  • Sending FileMaker data into usable javascript or HTML arrays.
  • Using fmp URLs to link back into your FileMaker app.
  • Cross-platform compatibility considerations.

Want to watch last month’s meeting? Check it out here: https://youtu.be/Uxr5TsPBf_I

Date & Time
Date: Thursday January 19th, 2017
Time: 6:00pm – 8:00pm

Location:
Smokehouse Brewing Company
1130 Dublin Road
Columbus, OH 43215

AGENDA:
6:00pm – Social Time, ordering food.
6:30pm – Function of the day, Presentation
7:45pm – Wrap-up, Q&A, Announcements, etc..
8:00pm or later – End of meeting.

Hope to see you there!
Mike Beargie
MainSpring, Inc.

—————————————————–
DIRECTIONS:
GOOGLE MAP OF LOCATION:
https://goo.gl/maps/ExEBwNbb1Sx

PARKING:
There is ample free parking on the east side of the smokehouse brewing company.

ENTRANCE:
Please use the regular restaurant entrance, tell the hostess you are here for the developers group in the private room.

Meeting: 12/15/2016 – FileMaker Roadmap Roundtable

Our December meeting is Thursday December 15th at the Smokehouse Brewing Company, 1130 Dublin Road, Columbus OH. 43215. Please note that you are encouraged to purchase food and drink to support our meeting location’s business. There will be no additional second location for post-meeting social time.

As a reminder, our meetings are scheduled on the third Thursday of every month. Future meetings include January 19th and February 16th.

Our function of the day is TBD.

For our main discussion, we will discuss as a group the recent FileMaker Roadmap presentation. If you missed the presentation from FileMaker, PLEASE watch or read it before the meeting:
Video recording: https://community.filemaker.com/videos/2447
Documentation: https://community.filemaker.com/community/product-roadmap

This is the first time that FileMaker has openly presented a roadmap to the general public, and there’s a number of key features in the roadmap that you can identify to help drive your development focus over the next few years. We will be testing our new conference style microphone to record the discussion and release it on the website. Want to watch last month’s meeting? Check it out here: https://youtu.be/Uxr5TsPBf_I

Date & Time
Date: Thursday December 15th, 2016
Time: 6:00pm – 8:00pm

Location:
Smokehouse Brewing Company
1130 Dublin Road
Columbus, OH 43215

AGENDA:
6:00pm – Social Time, ordering food.
6:30pm – Function of the day, Presentation
7:45pm – Wrap-up, Q&A, Announcements, etc..
8:00pm or later – End of meeting.
Hope to see you there!
Mike Beargie
MainSpring, Inc.

—————————————————–
DIRECTIONS:
GOOGLE MAP OF LOCATION:
https://goo.gl/maps/ExEBwNbb1Sx
PARKING:
There is ample free parking on the east side of the smokehouse brewing company.
ENTRANCE:
Please use the regular restaurant entrance, tell the hostess you are here for the developers group in the private room.

Meeting: 11/17/2016 – FileMaker Cloud

Our November meeting is Thursday November 17th at the Smokehouse Brewing Company, 1130 Dublin Road, Columbus OH. 43215. Please note that you are encouraged to purchase food and drink to support our meeting location’s business. There will be no additional second location for post-meeting social time.

As a reminder, our meetings are scheduled on the third Thursday of every month. Future meetings include December 15th and January 19th.

Our function of the day is the Get(HostApplicationVersion) Function.

For our main discussion, Mike will be giving a tour and talk regarding the new FileMaker Cloud Server product. This is a huge update to FileMaker Server and gives a lot of insight as to the direction the Server product line is headed towards.

Date & Time
Date:  Thursday November 17th, 2016
Time:  6:00pm – 8:00pm

Location:
Smokehouse Brewing Company
1130 Dublin Road
Columbus, OH 43215

AGENDA:
6:00pm – Social Time, ordering food.
6:30pm – Function of the day, Presentation
7:45pm – Wrap-up, Q&A, Announcements, etc..
8:00pm or later – End of meeting.

Hope to see you there!
Mike Beargie
MainSpring, Inc.

—————————————————–

DIRECTIONS:
GOOGLE MAP OF LOCATION:
https://goo.gl/maps/ExEBwNbb1Sx

PARKING:
There is ample free parking on the east side of the smokehouse brewing company.

ENTRANCE:
Please use the regular restaurant entrance, tell the hostess you are here for the developers group in the private room.

Meeting: 10/20/2016 – Introduction to Regular Expressions

Our October meeting is Thursday October 20th at the Smokehouse Brewing Company, 1130 Dublin Road, Columbus OH. 43215. Please note that you are encouraged to purchase food and drink to support our meeting location’s business. There will be no additional second location for post-meeting social time.

As a reminder, our meetings are scheduled on the third Thursday of every month. Future meetings include November 17th and December 15th.

Our function of the day is the SerialIncrement Function.

For our main discussion, Travis Risner will be giving us an introduction to Regular Expressions. Regexp for short, they are powerful pattern matching calculations that can identify patterns inside of field content for data scrubbing, validation, reporting and more.

Two links you should check out before the meeting:
RegExr – a playground for regexp.
2empowerFM Text Toolkit – a plugin for FileMaker used to run regexp. 

Date & Time
Date:  Thursday October 20th, 2016
Time:  6:00pm – 8:00pm

Location:
Smokehouse Brewing Company
1130 Dublin Road
Columbus, OH 43215

AGENDA:
6:00pm – Social Time, ordering food.
6:30pm – Function of the day, Presentation
7:45pm – Wrap-up, Q&A, Announcements, etc..
8:00pm or later – End of meeting.

Hope to see you there!
Mike Beargie
MainSpring, Inc.

—————————————————–

DIRECTIONS:

FROM THE NORTH:
Take 315 or 71 South
Exit for 670 West
Exit for Grandview Ave, Turn Right onto Grandview Ave.
Turn Left onto Dublin Rd.
Smokehouse is just a few buildings on your right

FROM THE NORTHWEST:
Take 33 East to 270 South
Take 70 East
Take 670 East at Split
Exit for Grandview Ave, Turn Right onto Grandview Ave.
Turn Left onto Dublin Rd.
Smokehouse is just a few buildings on your right

FROM THE WEST:
Take 70 East
Take 670 East at Split
Exit for Grandview Ave, Turn Right onto Grandview Ave.
Turn Left onto Dublin Rd.
Smokehouse is just a few buildings on your right

FROM THE EAST:
Take 70 West to 315N exit.
Exit for 33 West, Turn Left onto Dublin Rd
Follow Dublin Road to Smokehouse (on your right)

FROM THE SOUTH:
Take 71 N and keep left to merge onto 315N
Exit for 33 West, Turn Left onto Dublin Rd
Follow Dublin Road to Smokehouse (on your right)

GOOGLE MAP OF LOCATION:
https://goo.gl/maps/ExEBwNbb1Sx

PARKING:
There is ample free parking on the east side of the smokehouse brewing company.

ENTRANCE:
Please use the regular restaurant entrance, tell the hostess you are here for the developers group in the private room.

Meeting: 9/15/2016 – File Help Panel

*REMINDER* – our meeting location is now at the Smokehouse Brewing Company!

Our September meeting is Thursday September 15th at the Smokehouse Brewing Company, 1130 Dublin Road, Columbus OH. 43215. Please note that you are encouraged to purchase food and drink to support our meeting location’s business. There will be no additional second location for post-meeting social time.

As a reminder, our meetings are scheduled on the third Thursday of every month. Future meetings include October 20th and November 17th.

Our function of the day is the EvaluationError() Function.

For our main discussion, we will work together to suggest improvements to a file provided by COFMUG member Karen Bocko. Karen will give us a brief overview on her contract tracking app, and the club will provide feedback about structure, design and functionality to help her improve it!

Date & Time
Date:  Thursday September 15th, 2016
Time:  6:00pm – 8:00pm

Location:
Smokehouse Brewing Company
1130 Dublin Road
Columbus, OH 43215

AGENDA:
6:00pm – Social Time, ordering food.
6:30pm – Function of the day, Presentation
7:45pm – Wrap-up, Q&A, Announcements, etc..
8:00pm or later – End of meeting.

Hope to see you there!
Mike Beargie
MainSpring, Inc.

—————————————————–

DIRECTIONS:

FROM THE NORTH:
Take 315 or 71 South
Exit for 670 West
Exit for Grandview Ave, Turn Right onto Grandview Ave.
Turn Left onto Dublin Rd.
Smokehouse is just a few buildings on your right

FROM THE NORTHWEST:
Take 33 East to 270 South
Take 70 East
Take 670 East at Split
Exit for Grandview Ave, Turn Right onto Grandview Ave.
Turn Left onto Dublin Rd.
Smokehouse is just a few buildings on your right

FROM THE WEST:
Take 70 East
Take 670 East at Split
Exit for Grandview Ave, Turn Right onto Grandview Ave.
Turn Left onto Dublin Rd.
Smokehouse is just a few buildings on your right

FROM THE EAST:
Take 70 West to 315N exit.
Exit for 33 West, Turn Left onto Dublin Rd
Follow Dublin Road to Smokehouse (on your right)

FROM THE SOUTH:
Take 71 N and keep left to merge onto 315N
Exit for 33 West, Turn Left onto Dublin Rd
Follow Dublin Road to Smokehouse (on your right)

GOOGLE MAP OF LOCATION:
https://goo.gl/maps/ExEBwNbb1Sx

PARKING:
There is ample free parking on the east side of the smokehouse brewing company.

ENTRANCE:
Please use the regular restaurant entrance, tell the hostess you are here for the developers group in the private room.