Form Tools: generic form processing, storage and access script
What’s Up!April 29, 2008
Filed under: Misc News @ 10:29 pm

Hi folks,

I thought I’d make a quick post to let you know what’s up going on with the Form Tools project. I know I haven’t been terribly active in the forums of late - for which I’m really sorry - I’m just trying to juggle a lot of things, and that was one of the balls I rather let go. I’m a baaad person.

Just so everyone knows: Form Tools 2 is alive and well. I’ve been working on it quite steadily for several months and at this point I’ve solved (and coded) a good 80% of the script. Up until a week ago I was focusing on a couple of the larger modules (Image Manager and the Export Manager), but I’m taking a break to work on a few smaller projects (including a rewrite of the validation script that comes bundled with Form Tools) and generally catch up with other work.

In terms of a timeline, I’m going to shoot for getting a Beta out the door for late Summer / early Fall. I know I’d previously been shooting for early summer, but unless I win the lottery and can spend all my time on it, it doesn’t look very likely. Sadly, I have to make a living too. Due to the new changes in Form Tools 2 I also need to improve this site to allow you guys to upload, download, rate, edit etc. your own modules and themes. Plus the user doc has to be GREATLY expanded. So late Summer / early Fall sounds like a reasonable estimate.

Anyway, I’m moving back to Vancouver on Friday, so I’d better get back to packing boxes. Not to bash Saskatchewan, but boy am I looking forward to getting back. :-)


Form Tools 1.5.1 ReleasedMarch 4, 2008
Filed under: Emails, New Releases @ 12:07 am

Hi folks,

It recently came to my attention that I accidentally introduced a small security hole into version 1.5.0. This new release plugs the leak and fixes a number of more aggravating old bugs, as such it is a recommended upgrade. Thanks to everyone that helped identify the problems and report the bugs!

  • Security fix. Issue on servers with register globals enabled. This bug was introduced in 1.5.0.
  • Problem deleting files from client account [089]
  • Email template bug fix for “omit empty fields”. There was a bug in the previous templates causing some emails to get missed. [085]
  • Closing ?> removed for main code files (including library.php). This is a common cause for the “Step 2 Blank Page bug”

All the best -

Ben


Filed under: Misc News @ 4:05 pm

Howdy folks. I thought I’d post a few screenshots for Form Tools 2. Enjoy! :-)


Italian Translation Complete!February 20, 2008
Filed under: Language Packs @ 11:39 am

Just a quick note to say that the Italian translation has been completed and is available for download, thanks to Diego Meozzi for his hard work!

As always, all completed translations need reviewing. In order to become fully trusted, we need 3 independent translators to review them. So if you’d care to lend a hand, just drop me a line.

Again, many thanks, Diego!


Dutch Translation Complete!January 25, 2008
Filed under: Language Packs @ 10:19 am

A big thanks to Ludo Arts and Rob Prins for their work on the Dutch translation of Form Tools. Ludo just completed the translation today - many thanks!!

As with all the languages packs, we’re always in need of help reviewing the existing translations to ensure there are no mistakes or mis-translations. If you’d like to lend a hand, just click here for more information.

Thanks again, guys. Great work!


Happy Holidays!December 29, 2007
Filed under: Misc News @ 1:31 pm

Hope you all have a very nice Christmas and New Year! :-)

2008 should be a good year for Form Tools… we’re looking at lots of nice new features. :-)

- Ben


Swedish Translation Complete!December 9, 2007
Filed under: Misc News, Language Packs @ 3:52 pm

Many thanks to Peter Häggstrand for his Swedish translation. This is the first complete translation of Form Tools, available for download on the translations page.

You may note that it is set to 0% reliable. This is because all translations have to be reviewed and approved by 2 other translators for it’s reliability rating to increase. So if there’s any other Swedish translators out there that would like to help, just drop me a line!


Form Tools 1.5.0 ReleasedDecember 5, 2007
Filed under: New Releases @ 3:41 pm

Hi folks,

1.5.0 is now the standard build. As most of you probably know, this release has been in Beta for several months, due to the extensive backend change to accomodate the language packs. Again, a big thankyou to the translators who’ve been helping translate up to this point. If you’re interested in helping finish off some of the existing translations, just drop me a line!

Other than for bug fixes, the next release will be the big 2.0. Development is coming along pretty well - the Smarty templates are extremely cool, and the overall look and feel is a HUGE improvement over the current release. I won’t guess at a release date just yet, except that it will be well into the New Year.

I’ll add some screenshots of 2.0 sometime further down the line.

All the best!

Ben
Form Tools Site Administrator


Form Tools 2.0November 22, 2007
Filed under: Misc News @ 4:12 pm

Hi folks,

1.5.0 is now looking pretty solid and soon to be released as the standard build, so I thought now would be a good time to make some remarks about the next release. After much humming and hawing, I’ve settled on the features discussed below. As you can probably guess, this is going to be a major upgrade - hence the 2.0 label.

So here’s what’s coming in version 2.0:

1. Views

Views are ways to, well, “view” your data. (That clears THAT up!)

To explain: currently, you have one and only one way of viewing your form submissions: ALL submission information. When you or your clients browse the submissions you have no choice but to see all fields and all submissions (with the notable exception of the under-used “submission filters” feature). But what if you’re interested in seeing a subset of that information - both in terms of the submissions that get listed, and the fields that appear for each submission? For example, what if your form was a registration form and you just wanted to see the emergency contact information for submissions entered in the last week? Or maybe you want to limit the fields that client accounts can see? Or perhaps let a client see certain fields but not be able to edit them?

Views let you do all this. You can create your own custom ways to view the data, and assign particular clients to particular Views. This is an exceedingly powerful feature, as it effectively converts Form Tools into a fully-fledged report builder. You can define your own Views to slice and dice your form information in whatever way you wish (including setting up default sort orders, submissions per page and field order) and then use the existing Print Preview and Excel download options to export that particular “View” of the data.

[N.B. I have this feature already working, and BOY is it cool. Incidentally, I cribbed the term “View” from a Drupal module since I think it’s the best term for what it does.]

2. Tabbed Editing

This feature has been put off and off and off in favour of more pressing features. But now I’m adding Views, I figured it was a great time to work on it.

Imagine you have a large form with a lot of fields (say over 100). Viewing and editing that form through the Form Tools UI can be pretty painful: the page itself can take a long time to load and finding the field you want may involved scrolling and scrolling and scrolling…

Tabbed editing provides you with an elegant solution to this. You can defined up to 6 tabs for each View and assign every field that appears in the View to a particular tab. Now, when you or a client goes to edit or view that particular submission, they’ll see the information presented in your neat little tabs, each with whatever title you’ve assigned to it.

3. WYSIWYG editor for field editing

A month or two ago I did a job for a client that involved adding FCKEditor to allow administrators & clients to edit their submissions in rich-text format (with things like bold, italics, colours, links etc). It’s a nice, practical feature so I’m going to incorporate it into this next release. But I still haven’t made up my mind between tinyMCE or FCKEditor. I’ll provide controls so that the administrator can specify which options appear in the editor.

4. Themes

I’ve never mentioned this, but I never really liked how Form Tools looks! I think the UI is generally pretty clear, but the overall styles are very plain, very boring. What can I say? I’m not a designer!

When I first wrote Form Tools I knew that people would want to change how the program looked. So, thinking that the majority of users would be web developers like myself, I added the option to allow administrators to customize the client’s CSS. Well… perhaps that wasn’t sure a great idea. I have yet to see an installation of Form Tools that looks genuinely unique. Most people tinker with the styles but not radically re-write them - probably partly because they don’t have time but also because they’re just not that familiar with CSS.

Solution? Themes.

Themes apply to all user accounts: administrator and clients. Instead of the current, klutzy solution where administrator pages are rendered via one route (the admin_styles.css file), and the clients via another (the CSS in the database), the new themes will apply to all accounts, helping to simplify the code.

There will be 3 themes by default: the “classic” grey theme (as it is right now) a “Deep Blue” theme - a fixed width theme that will fit on all 1024 minimum monitors - and another theme which… well, I haven’t come up with yet.

I’ll also be encouraging real designers to create their own themes and upload them here to the site for others to view and download. Naturally, each theme can include author information and links to their sites.

What may seem odd is that I’ll be removing the existing option to upload your own program image or choose a preset one. Now it’ll be entirely theme based: if you want a client account to look a certain way, you’ll need to create it’s own custom theme. Despite the reduction of the functionality, I think that this is a much better solution all-round.

From a back-end point of view, themes will be the most substantial change from 1.x. I’ll be employing the Smarty PHP templating engine to allow non-programmers to modify every last aspect of the pages without requiring any knowledge of PHP. The existing mix of PHP and HTML is a mess - I’ve known this for some time, but balked at adding some sort of template system, due to the sheer volume of work involved.
5. Modules

With every new version of Form Tools I’m walking an ever finer line between usability and functionality. The more features I add, the more complicated it gets - and for anyone that’s used software like Drupal knows, usability is paramount. Sure, you can do virtually anything with Drupal, but actually figuring out how to get it to DO it can be downright agonizing - often involved at least 3 shots of expresso and a punching bag. Form Tools is nowhere near as huge a script as Drupal, but the usability problems are similar: how to accomodate feature requests without sacrificing usability.

For a long time I’ve known that adding some sort of Module support is the only real solution. If you need Feature A, you can just download it in a separate module.

I have a tentative solution to this problem, which I’m still investigating. But whatever I come up with, the following two modules will be included:

  1. Duplicate Form Module (lets you make an exact copy of a form)
  2. Submission-to-User account module. (letting you convert a submission to a user account, allowing that user to log in and update that single submission)

Naturally I’ll also write some documentation to add to the Developers Doc section on how to write your own modules.

My hope is that eventually I can move away from developing features for the main script and focus on separate modules. But time will tell.

6. Other stuff

- All passwords will now be encrypted in the database (loooong overdue! Holy smokes!).
- Options for client accounts to define their own logout URL and system timezone offset.
- A solution for the age-old uploading-images-with-multi-page-forms problem.
- new “date” field type that will let you edit any field that contains date information (consistently) in a specific format with a JS calendar.
- And a few more goodies… :)

Oh, and there’s one more thing I need to bring up: this will be the first disruptive upgrade. If you choose to upgrade to this version, the following information will be lost:

  • any client filters (the last of the Edit Client tabs) you have defined will be deleted,
  • client styles will all be reset.

The reason for this is that filters will now be associated with Views, not directly with clients. Technically I could write some complicated code to allow a smooth upgrade, but frankly it’s just not worth my time: the feature has been rarely used since it’s inception, and it won’t be too much work to your part to create a view, add the filter and assign it to the client(s).

Client styles will be deprecated in favour of themes. I regret that the old styles will be lost, but if I continue to support features that hold back the overall development of the script, the program will be much the worse for it!

That’s all for now! I’ll be sure to post more information as I progress.

Ben


More Translators needed!November 18, 2007
Filed under: Misc News, Language Packs @ 2:39 pm

Hi folks,

A big thanks to the translators who’ve already volunteered their time and skills - we’re coming along very well. But we’re always on the lookout for more help! In the 2 1/2 months since releasing the language pack version of Form Tools, we’ve had volunteers in no less than 18 languages sign up to translate Form Tools into their language, including:

  •  Chinese (Simplified and Traditional), Dutch, French, German, Indonesian, Italian, Persian, Polish, Portuguese, Romanian, Russian, Slovak, Swedish and Turkish.

Not bad!

Open Translate (the software handling the translations) employs a review-based mechanism to ensure the best quality translations. This means that at least three different translators in each language need to review each translation and agree that it is correct in order for it to get a decent “reliable” rating.

So if you’re interested in helping review the existing translations, or finish off an incomplete translation, just let me know! Send me an email through the Contact Us page and I’ll gladly set you up a translator account.

Many thanks!

Ben


Next Page »
Powered by WordPress