Saturday, August 09, 2008

InfoPath 2007 - odd piece of software

We just installed Office 2007 Enterprise across the 7,000+ workstations at work and that included InfoPath 2007, Microsoft free-format, ultra-flexible, form based front end for entering structured data into a database. I've only just started messing around with the software (creating a daily checklist form) and I'm a bit confused, really. It kind of reminds me of Excel - it can do anything but trying to figure out how to do the one thing you really want is damn near impossible.

I find myself dipping into the help menus constantly for almost everything I'm doing. For example, let's say you create a table, setup a couple fields and radio buttons, and get all of the formatting the way you want it.

Now, you wan to duplicate a couple of the rows and make it 5 or 6 row table instead of three you just copy and paste. Since the fields are bound to a data source, the new rows are all tied to the original fields.

So, after you publish the form, when you type something in to the fourth row, that same information is then displayed in four differently fields. The process to associate these new fields with new data fields is by right-clicking, selected "Change Binding". each process of assigning a new field is about a 9-click process and it has to be repeated for every field. In this simple table, I actually have 5 fields per line - each radio button has to be modified individually. This three-row copy and past is going to be a 135 click process to create new fields that look like the fields I already created. Since there is no "format paint" button, I can't use the insert field tools to simplify the process.

There might be a faster way to do this but I can't find it in the InfoPath documentation. That's why it reminds me of Excel. It feels like a software that requires you take a class or read a big thing text book to understand it.

No comments: