Featured: Adventures in Chaos| Nearly Wed| No-Obligation Book Club
Categories: Food & Recipes| Home & Organizing| Beauty & Fashion| Holidays & Entertaining| Health| Work & Life| Technology


Software
Organize with a Personalized Database
Posted on May 9, 2008 8:30:00 AM  |  By Erin—Manic Mommies

Since leaving my former workplace and starting my own business, I've identified only a few things I really miss about the old office.



1) The IT person, Mary.
2) Free food at 10am or 3pm in honor of someone's birthday. Bonus if I didn't know the person.
3) 401K match.



This post relates to #1 on the list, Mary. Mary knew her way around FileMaker databases and she could do mail merges like nobody's business. If I had a question about creating a new database of contacts for media pitches, I'd consult with Mary. Whether I needed help with invitations to press events, preview DVD mailings, or tracking event RSVPs—Mary made it happen.



Mary managed data using FileMaker, and that was about all I knew about the process. So when I went out on my own, I purchased FileMaker for my laptop. I had visions of creating a massive, awesome database of media contacts and bloggers that my clients would be so happy to have access to they'd keep me on retainer just for My List. I tried, on several occasions, to actually set up my dream database. I envisioned one with custom fields and the capability to sort by name, outlet, market, type of publication, etc.



I also dreamed of using FileMaker to run project reports for my clients and generate billings every month.



Screenshot_4It's been over three years since I launched my own small business and FileMaker remains on my hard drive, virtually untouched. So you might imagine why I became almost giddy when contacted about giving Bento, FileMaker's new, easy-to-use and stylish personal database software a test drive. Truthfully, it's almost as if someone used me as the case study when designing this software. Bento is designed specifically for Mac users (check), for personal or small business use (check), and it's affordable at $49 (double check!).



Bento looks, feels and works like other Mac applications. Organizing your information into collections in Bento is much like organizing songs in iTunes. Bento is beautiful in design and you really don't need to understand database concepts or have any experience with databases to use it. Sure, it does take some time to get familiar with all the features, and to design your forms, but as long as you don't spend all day trying out the 20 different preset color and font themes, you can start entering your data in a matter of minutes.



Bento comes with several library templates designed for home, education or work. The work category is especially great for small business owners as it includes templates for time billing (yes!), event planning, contacts, expenses and more. I actually feel like the time billing template is the answer to my prayers because you can export the data into a CSV format (i.e. Excel) and easily generate invoices. Bento's personal category templates include an exercise log, vehicle maintenance forms, to do items, and more.



I could go on, but then I'd really seem like some kind of database geek. I know databases can simplify life and work, but until now, I've never been able to design them myself. It usually took someone like Mary, a FileMaker pro, to help me out. With Bento, I'm actually getting organized in a simple and stylish way.



Sorry PC users. Just another reason to consider a Mac.



Digg This! | Stumble It! | Add to KiRTSY | Save to del.icio.us | Email this post



Post Your Comment:
Terms of Service

If you have a TypeKey or TypePad account, please Sign In
















In fact, my dad recently purchased Bento (family licence), and was disappointed with the time-keeping aspect. I haven't played much with that part of Bento, but I was able to find OfficeTime, which does the job very well and integrates with iCal.
Now, if Bento did that, there would be no question about which app he'd use.

As much as I like Bento, I still feel there should be the possibility to create new templates (and download user-made ones). Modifying existing templates isn't yet as good as it could be.

Posted by: Peter Craddock| May 16, 2008 at 01:44 PM




Sounds great — I just can't imagine learning a whole new suite of apps!

Posted by: Dan&Kim| May 16, 2008 at 01:50 PM




Coincidentally, I downloaded the free trial of Bento yesterday. So far, I love it! I'm hoping it helps me get a little more organized at work and outside of work.

Posted by: Melissa M.| May 16, 2008 at 02:06 PM




Bento is good DayLite 3 is great. Try the free download at Marketcircle.com. Greatest CRM for Mac I have found. Great for single user or growing office.

Wes

Posted by: Wes| May 16, 2008 at 02:15 PM




I'm with you on that Market Circle's Daylite three is amazing!

Posted by: Kate| May 16, 2008 at 02:22 PM




Bento would be much better if you could print out the data in your database tables. To not have this function is incredible.

Posted by: Christopher Skelton| May 16, 2008 at 02:40 PM




If you want to spend four times as much, Daylite sounds great. The difference in price puts them in completely different product categories, IMO.

Posted by: David Rourke| May 16, 2008 at 02:45 PM




If you want to print your data in a Bento database, export it as a CSV and import it into any spreadsheet for a simple printout, or use it as the data source for a mail-merge in any word processor so you can format it to your heart's content.

It costs $50. What do you expect? If you want it beefed up so you can buy it for $100, please leave me the $50 version.

I love Bento. I've used it since its first beta. I pull together stuff from iCal, my address book and lists I've made up on my own.

I use it to organize stuff, keep track of stuff, remember what I've done with whom or to what and generally find information I need when I need it. I don't use it for reports or other paper-consuming activites. I filter or search or sort to find things on the computer and go from there.

Hmmm. I just checked. You actually CAN print. Just sort or filter or whatever so that the table view is showing the entries you want and choose File:Print and select "All displayed records" from the available options.

You can even save paper by creating a .PDF file instead of printing it... or just use it on the screen, like it's designed to be used and give up on killing trees for a report you'll use for less than a week before you print a new one.

Posted by: Will Martin| May 16, 2008 at 03:13 PM




Will it export into numbers? or only excel?

Posted by: Ruth Martin| May 16, 2008 at 04:11 PM




Can I sync Bento between my 2 Macs? I have not been able to find an answer to that.

Posted by: Rick| May 16, 2008 at 04:34 PM




Syncing question is relative to us with us using a multiplicity of computers. Additionally, how does Bento organize .pdf's .doc's .ai, .jpg's? I still don't have this in my mind yet.

Posted by: Tom Franklin| May 16, 2008 at 05:29 PM




I love, love, love my Bento! Very beautiful, easy to use and inexpensive. Meshes perfectly with my address book. Love it! Oh I said that already.

Posted by: bravefacari| May 16, 2008 at 05:34 PM




I don't have Bento (I'm a FileMaker consultant, still on Tiger) but if Bento can export a .csv ("comma separated values") file, then Numbers can open that as well as Excel.

Posted by: Glenn| May 16, 2008 at 06:27 PM




I purchased Bento, fooled around with it for a little while, and gave up. It's the exact same reaction I had with FileMaker.

Maybe I'm just a dunce, but I don't find either package intuitive, or useful, out of the box.

I need some tutorials, or instruction videos, or something.

Frankly, Entourage does a decent enough job of managing more than 2,300 work and personal contacts. I thought database software would be better and easier, but it's neither.

Posted by: Ken Carpenter| May 16, 2008 at 10:35 PM




Bento is not for everyone. It integrates with iCal and Addressbook, exports to Excel/Numbers as .csv and is a single-user application only. I use it for my small business. I have created linked fields to related files (quotations) for each record, meaning when I am at a particular customer's card I can quickly open the last offer I have sent that customer. I also have created a visit record for each customer, which is linked to another collection of all visits. This way I can see all my visits/contacts for a particular customer or I can pull out all my visits in a given week, say. Wonderful and easy to set up once you play around just a little.

Printing and formatting could be more flexible, but this may just be an old habit refusing to go green.... get a laptop and you don't really need to print as you have all your information at all times!

Posted by: Manolis Kroussaniotakis| May 17, 2008 at 12:45 AM




I have been using basic features of Filemaker for ten years and welcomed Bento as it would integrate more efficiently with Address Book. Must say am very disappointed by Apple's showing on this. To start, the templates are butt ugly, they mostly look like bad wallpaper or carpet. The colors are very drab and dull. Not at all what you would expect from Apple. Plus, the fields are too rigid. If you create your own template, you soon realize that you can't have multiple email addresses without creating multiple fields - this is ridiculous if you have 10+ contacts at one company, there is no room left for any other data on the page. Plus there is no way to delete the name of the field (ie. where it says "Email" next to the email field") so you have lots of extra space used up on each page. Very basic and very disappointing. This product is only useful for colorblind people who are database novices and happy to use the templates provided. Current Filemaker customers are better off waiting for improvements before buying.

Posted by: Sara Finlayson| May 17, 2008 at 01:42 AM




I do not see the reason to use Bento (and all bento-like apps). This kind of app is rather good (and topmost needed) on ugly and hard to use windows platforms from Microsoft corporation.
On Mac - simply - you have included in your OS tools like: smart folders, spotlight etc. So why have you to use 3rd party apps (in fact - they uses the mechanisms of OS X - smart folders etc.)...

Posted by: Umbrela, ela, ela| May 17, 2008 at 04:34 PM




Bento needs work to be functional.

Needs mailing label printing.
Needs easier export to Filemaker.
Needs to import v-cards and export v-cards.

I like it because it integrates with address book and I-Cal.
I am old hand at Filemaker and started with PFS more than 20 years ago. Data bases don't bother me, but none of my 11 employees will touch Filemaker, even after expensive training. I will try Bento on them, even though it needs much work to be functional.

Posted by: Jerome Ryden| May 17, 2008 at 06:35 PM




I've had Bento since January and do like it. However, Filemaker decided to rely on the OS X address book for dealing with contact info. For those of us who manage databases of non-profits and want the contact info outside of our personal address books, Bento has the gaping missing feature of being able to print to labels. I recently needed to do a large mailing and Appleworks had to come to the rescue to do the labels. And it isn't like this is Filemaker's first database (sarcasm intended). Not supporting label printing is a rookie mistake.

Posted by: David Firth| May 17, 2008 at 06:48 PM




Multiple email addresses are handled with either an email address list field or a related record field from the address book.

Posted by: Alan| May 17, 2008 at 07:22 PM




Bento is great and it's exciting what you can do and the way it links with Address book and Ical.

But please be careful. We spent about 300 hours importing data, putting everything in the correct fields, setting up calculations that work and making it so useful.

The day before we were ready to swing it into action Address book developed a problem and could not bereliably searched anymore. Applecare helped us fix that by reloading address book.

Great Address book was back ontrack. Only problem was that every single field we created for Bento was empty. What heartbreaker. Lucky I did daily back-ups. Imagine how I felt when all the fields in those back-ups were also empty no matter how far back I went.

Unfortunately I had not set up time machine so I couldn't go back.

Filemaker said "Mmmm interesting problem. Seems unusual. Bad luck."

Any tips on recovery of the information?

Posted by: David McIlwaine| May 17, 2008 at 10:05 PM




I took the risky move of starting my own freelance business right about the time Bento came out and have been wondering if I need it ever since. I fall into the "I don't know what I don't know" category. With a small handful of mostly magazine clients -- billing per project vs. hours - keeping me very busy, I don't know if I need Bento. But I think it's time to download that trial demo. Thanks for this little article.

Posted by: Bpb6stringer| May 18, 2008 at 08:10 AM




Missing SYNC via .Mac or directly is the major problem at this moment in Bento for people that travel...

Posted by: Andreas Blass| May 18, 2008 at 09:31 AM




"I do not see the reason to use Bento (and all bento-like apps). This kind of app is rather good (and topmost needed) on ugly and hard to use windows platforms from Microsoft corporation.
On Mac - simply - you have included in your OS tools like: smart folders, spotlight etc. So why have you to use 3rd party apps (in fact - they uses the mechanisms of OS X - smart folders etc.)..."
Posted by: Umbrela, ela, ela

Bento is not a 3rd party app. It's all Apple. For every business person screaming about what it lacks. It's a PERSONAL DATABASE".

Posted by: Jim Smith| May 19, 2008 at 09:45 AM




It isn't really a database that works as there is no option to mailmerge - the primary use of a database. It looks great. But for managing mailing to supporters/clients it's completely useless.

Exporting stuff through CSV shouldn't be necessary. I have staff who wouldn't be able to do that hundreds of times a week.

Bento is not a real database and until it gets a mail merge facility (for more than names and addresses) it is useless for most database purposes.

Posted by: Don Egan| May 24, 2008 at 05:05 AM






Subscribe

Enter your email address to get updates:

Get the RSS feed
Subscribe by Category


Previously on Simply Stated


Advertisement




Search Simply Stated




Contributors

Archives

Advertisement

Sites We Like


Featured in Alltop



Past Contributors