Ever since we built our first calendar in FileMaker 5, we’ve been publishing that data to iCal (and then to Google Calendar) one way or another. We’ve always wanted something simpler, and now we have it.
SeedCode Subscribe is the simplest way we’ve found to get your FileMaker data into iCal, Google Calendar, and the calendars on your iPhone and iPad.
Please check it out here, where you’ll find a short video showing how easy it is to get started (you can test your first calendars without even i
We’ve just released the newest version of GoZync and it makes a lot of things easier for developers using sync as part of their workflow.
You’ll find it easier to sync calc fields, add business logic inside the sync, and get GoZync added to your files more quickly. And though we’re still coding for transparency and dependability vs speed, the sync itself is also faster: often 4x faster.
If you’ve looked at GoZync before, or are using version 3, this video gives you a quick overview of the new
Jason has just completed a major new version of SQLexplorer that makes it easier for beginners and pros alike to write better queries.
If you haven’t used SQLexplorer before, it writes FileMaker SQL queries for you as you fill out a simple form using FileMaker terms your familiar with (sorts, relationships, etc). You can then test your query right in SQLexplorer before copying and pasting it into your solution. Queries are clearly commented and abstracted to survive field renaming.
I can tell
Brad Cranston of Cranston IT sent us this gorgeous screen shot of his integration of ProMaps into SeedCode Complete. (Love the filters)
He got the (free) icons from http://mapicons.nicolasmollet.com and explains the legend like this:
When showing projects and events at the same time, it can be a little bit confusing because they do overlap to some extent, so you can filter either way. Also, there are three tables involved here because the phone icon is based off the incoming calls table.
I’d have difficulty imagining a conference that could have gone much better. Egbert Friedrich was a super host, very kind, gracious and made sure we were all welcome in Berlin. Talks were exactly what you’d have hoped to see. Almost all were a bit chaotic and loads of audience participation. Everyone wants to do this again.
Hotel was in a super location right on the bank of the River Spree, in the former East Berlin. There are several sections of the wall right by the patio area along the river
Great FileMaker User Group meeting last night punctuated by Xandon Frogget’s self-guided-wheelchair demo. Amazing work / evil-genius parenting (see the collision-avoidance stroller demo).
http://daddiorobotics.com/
Toddler-Assisted Steering
<a href="http://seedcodenext.wordpress.com/2013/06/12/robotics-seattle/" rel='nofollow external'>Source</a>
We’ve simplified GoMaps to work on desktop versions of FileMaker Pro solutions and named it ProMaps. The relationship graph got dead simple so you can paste the map right on to your existing layouts. (And the map is scriptable, so once you click on a pin, you can run your own scripts from the property detail within the map.)
ProMaps is completely unlocked for you to modify and extend.
And if you need both GoMaps and ProMaps, you can save $100 with our Maps Bundle.
Download the demo and chec
Once you distribute offline files to your users, how do you keep making changes, fix bugs, and re-distribute the files without breaking things or ending up with duplicate files on someone’s iPad?
GoZync makes this easy, and this short video shows how. It also demonstrates that GoZync can let you recover from schema errors you might introduce when you’re defining fields. You’ll see how we capture errors (like “the field we’re trying to sync is no longer there”) and let you re-play a sync after y
Jason’s swapping out the results portal in our free SQL Explorer with a webviewer so he can take advantage of column resizing and other UI goodies you just don’t see in FileMaker. The second part of the video shows how he lets users easily swap out the styles used in the “portal” as their layouts change.
HTML5 in FileMaker apps. Yummy.
<a href="http://seedcodenext.wordpress.com/2013/05/01/webvier-portals-preview-of-sql-explorer-next/">Source</a>
Todd and I have been working on some changes to GoZync, and the latest build offers a substantially faster sync down from hosted files.
In one test, pulling 5,000 new contacts went from 12:52 to 2:00 minutes flat. (Times will be longer on mobile and over shaky connections.) This is a big improvement.
Add this to Your Deployment
Needless to say, we recommend this for all users: only 4 scripts were changed so updating existing deployments is easy, though you will need to distribute new copies o
Heard very good things about this program for onboarding new developers. New cohort starting in June: http://thorsenconsulting.com/filemaker-virtual-training-program-jump-start-your-career-as-a-developer/
FileMaker’s answer to: https://www.codefellows.org/#bootcamps
Molly: Thorsen Consulting
<a href="http://seedcodenext.wordpress.com/2013/04/25/filemaker-training/">Source</a>
Background: ID Lists
I have one thing (at least) to follow up with on my ExecuteSQL using the Found Set post from a little bit back. This was to see if I could get the RecordID parsing optimized (or at least faster) using some of the techniques in Todd’s Hyperlist demo. Although this is not the slow part of the process–feeding the large set of values into the SQL IN clause is the slow part–it still did seem worth pursuing for two reasons: Firs,t to get my head around Hyperlist and the underl
Weave is cool little app that begins by reading the event kit data from your iPhone and showing your calendar events in a rough todo list.
You can’t do much with these existing events, but you can make new to-do items. And when you go to mark one as “done”, you see the screen at the right.
And you can see how Weave can get you to log your time and track your expenses. Pretty cool. Screenshots of weave on the app store show project income and expenses and the tasks completed by others.
Now you
I spent some time this weekend doing some old fashioned FileMaker hacking that I’ve always enjoyed (viva La WorkAround Pro). Definitely inspired by Todd Geist’s very cool hyper-list stuff, but he had also reminded me of the problem of ExecuteSQL on the found set, and I’ve heard this as a common feature request. My big take away from Todd’s comments was that the found set is a uniquely powerful thing, so if it could somehow be incorporated into FMSQL, then that would certainly be a potentially
So, is this crazy or cool?
Let ( [ uid = Get ( UUID ) ] ; Substitute ( $sc_List & uid ; [ ¶ & uid ; "" ] ; [ uid ; "" ] ) )
If UUID is good enough for your primary key, is it good enough for this?
<a href="http://seedcodenext.wordpress.com/2013/04/04/trailing-carriage-return-removal-method-3412/">Source</a>
Well, that’s what happens when you post things to the wrong blog! =)
Internally we try to publish the most effusive comments form the last week’s support cases every Friday–”fan mail friday”–just to let everyone know what their teammates have been up to.
We *usually* post this privately: sorry for the interruption. “Happy Friday” everyone.
- John
<a href="http://seedcodenext.wordpress.com/2013/03/29/fan-mail-friday/">Source</a>
The developers at IT Solutions just completed a great FileMaker Go project for the Center for Disabilities Studies at the University of Delaware.
The solution facilitates in-person evaluations of 100 public schools across the state and replaces a paper system that delayed feedback and analysis of this important information.
I can’t express how much FileMaker Go and the app developed by IT Solutions has positively impacted our project. We’re now able to complete evaluations in less time, an
Beautiful screen shot sent to us by Don Blaylock of Noble Casings…
…Don says:
I appreciate all your help. The syncing is working awesome! GoZync was central to the success of this and future products!!!
Glad to hear it Don; and thanks for the sexy screen shot: love the dimmed “1″ and “2″.
<a href="http://seedcodenext.wordpress.com/2013/03/25/gozync-customer-solution-rigman/">Source</a>
Cool and provocative video by Todd Geist showing how he incorporates unit testing into a new project: Unit Testing in FileMaker. Nice stuff.
<a href="http://seedcodenext.wordpress.com/2013/03/23/unit-testing-for-filemaker/">Source</a>
Overview.
We’ve been syncing FileMaker Go solutions since June of 2011 and it now seems like a good time to reflect on what we’ve learned helping folks make mobile apps as well getting the apps they already have debugged, sped up, and syncing.
This article will talk about some of the things we think are most important–and maybe counter intuitive–when planning a distributed app.
Because that’s the big shift for most of us: we’ve been making networked apps, and now that we’re mobile we’re makin
Just got this wild screen shot from Guglielmo Imbimbo. Definitely went to town on the calendar layout: well done!
<a href="http://seedcodenext.wordpress.com/2013/03/14/calendar-skin-job/">Source</a>
I’ve had some small pre-FileMaker experience with SQL and had it in my head that subqueries work in the FROM clause. They do in MySQL etc, so I was frustrated when I couldn’t get that to work in FileMaker’s SQL as it’s really needed in some cases.
In a current project we have a case where there is a relationship from Contacts to Loans and we wanted to see the Total Loan Amount from the Contact Context. However, they can be associated with that Loan as multiple roles, so we only want to have
Had a chance to catch up with Angelo Luchi at Pause On Error and was very impressed with what he has planned for Foxtail Labs. “Labs” is a suite of hosted APIs that let FileMaker developers employ techniques that previously required plugins. The first lab involves using URLs to generate bar codes: vey useful for apps on FileMaker Go where plugins won’t run, but also makes sense on Pro for folks who don’t want to install or update plugins.
This was part of a big theme at Pause: leveraging File
If you’re using SQL in your FM12 work, you’re in luck. Jason has released a new version of SQLexplorer that writes queries which survive field renaming.
It will also apply this abstraction to queries you simply type in there (vs ones you build with the wizard). Big step forward.
Still free and unlocked, the new version is here.
<a href="http://seedcodenext.wordpress.com/2013/03/03/sqlexplorer-enhanced/">Source</a>
Psyched that GoMaps is featured front and center on the FileMaker home page and in FileMaker’s iOS Showcase:
<a href="http://seedcodenext.wordpress.com/2013/02/26/gomaps-featured-on-filemaker-com/">Source</a>
