¦ Bento 4 works well with Bento for iPad and Bento for iPhone, enabling users to sync data with Bento for Mac and vice versa. This versatile application scores high marks for getting administrators, teachers, and students in Mac-based schools working with databases. Looking for a personal database recommendation for iOS and OS X – basically a replacement for Bento. It needs to be able to have cloud sync, so I can do work on multiple devices. Two options seem to be: Tap Forms; Ninox; There is also a cross-platform and open source Symphytum, but it does not work for iOS.
Beer Tracking Trilogy Episode 4
Bento
I started this project in Bento. A couple of years ago, I created a Bento database for cataloging beers I drank. The purpose was to know what to buy again, and what to avoid at all costs. Bento worked moderately well but had some frustrating rough edges.
Bento on the Mac has two different views into the data. There is a simple list view that can be searched, sorted and filtered. Then there is the form view which provides extensive customization. With careful design I built a form that looked like a custom app built for the single purpose of cataloging beer.
Spoilers
This is a long post (>2500 words) with lots of images and details that may be tedious to some. If you just came here to find out if you should be a Bento user here’s the conclusion: It worked great on the Mac but did not translate well to the iPhone app. The iPhone was just too small and the application did not have well thought out controls. It was fine for looking up information, but frustrating for adding anything new from iOS. There was also the issue of data portability. I’ve had too many instances of applications going away and taking my well curated data with them. That’s why I forced myself to leave Evernote in favor of alternative note-taking systems. There were several features that I really liked, so I kept with Bento for about a year. In the end, I decided my requirements had changed and no longer fit into the Bento model.
Bento on the Mac; $49
Initially Bento was only available on the Mac. It’s a more laid-back, more attractive and more accessible version of FileMaker Pro. There’s no scripting
I purchased Bento when it was first released. I was once a heavy FileMaker Pro user and developer but I had graduated to new and more severe forms of self-flagellation with Oracle databases. I had not touched FileMaker Pro in many years but Bento looked to scratch an itch for some lightweight database solutions at home.
Bento on the Mac is a lovely experience. It has a simple and clean interface that can be customized within seconds to provide an excellent experience. There is no scripting in Bento. That might be a relief to anyone that is familiar with FileMaker. That also means you’re stuck with exactly what Bento offers out of the box.
What is offers out of the box is very good. At it’s core, Bento is a flat database with a lot of chrome and pre-made widgets. To create a useable form, I just need to define fields and drag UI elements to where I want them. There’s a list view that behaves much like a dumb spreadsheet. It can be sorted and numerical columns can be summed. There is no text formatting or field coloring.
Bento really embraces the idea of “ignorance is bliss.” The less you know about how to build forms, the more you can just enjoy using them.
Here’s the form I built for my beer inventory.
That form took under 15 minutes to make. That included defining the fields, arranging the UI elements and tweaking the field lengths. That’s really the only options you have.
On the left hand side of the image you can see that Bento uses a single source for all libraries. There are not separate library files. This is both good and bad. It’s very similar to iOS where I don’t think about where my files are stored. iOS apps generally store the files and manage them for me. Bento does the same. The down side is that I can not just move or send my library file manually. I can’t just copy my library file to Dropbox to share. In fact, Bento doesn’t play nice with Dropbox at all.
I think this library model works for Bento. It’s a simple application for basic workflows.
There are more views available automatically. No formatting or tweaking needed. Here’s the grid view of the library. This view mocks me for missing images, much like the Cover Flow view in iTunes.
Grid View
Here’s the list view available for the inventory. This view exposes the guts of the library. It really is mostly a flat table with a bunch of entries.
Vst nexus for mac os. List View
Version 3 of Bento introduced a split view as well. List view on top and the form view on the bottom. This is my preferred view for working in my library.
Filemaker Bento Replacement
Split View
Smart Lists
In addition to a Library group in Bento, each Library can also have Lists. Lists are groupings of records. One of the most useful for me is to have Smart Lists that are based on some search criteria. As with every feature in Bento, smart lists are limited, but dead-simple to make. There’s no way to create nested criteria like in iTunes, but that’s not how Bento was designed and I’m willing to bet most iTunes users don’t make smart lists with nested criteria.
The Smart Lists that I use often (I have more but cleaned them out for this image) are as follows: Favorites: Anything with more than 3 stars Shopping List: Anything with more than 3 stars with no stock (quantity is empty)
I would like to see something a bit closer to iTunes. For example adding a criteria that is dependent upon being in another smart list. That shouldn’t add too much complexity to the interface, but provide a powerful way to build complex Smart Lists.
Manual Lists
Just as the name implies, Manual Lists are created by adding individual records. One way I use this, is to prepare for a tasting session. I can quickly add all of the beers I want to run through and make sure that I have enough in stock.
Manual List Creation
Saving
There is no saving. I make a change or add an entry and can then quit the application. One advantage of Bento’s lack of library portability is that there’s no need to ever save changes. There are plenty of backups created, but even before Lion, Bento never needed a manual Save step.
Data Portability
I have been pleasantly surprised at how easily I can get data in and out of Bento. For an application with few bells and whistles, it has plenty of options for data portability.
Bento supports a couple import and export options that include iWork Numbers, Excel, PDF and CSV. I only ever work with CSV since it is a tried and true method for moving tabular (pun intended) data around.
When importing CSV data, Bento will auto-match fields that already exist in the current library. I can also quickly create any necessary fields without leaving the import window. For example, importing a bunch of records into my Beer Inventory library was dead-simple.
Import Form
Bento on iPhone; $4.99
Each iOS companion app is going to set you back a bit. I think that’s somewhat fair. I would prefer a universal app rather than a separate iPhone and iPad app, but it’s reasonable not to just give them away. You don’t need Bento on the Mac to use it on iOS. It’s a perfectly capable form and database manager with the Mac counterpart.
If you do have the Mac, it’s going to be a much better experience.
iPhone Browsing
Syncing
iOS Bento can only sync with Bento on the Mac. That’s not a problem for me since I’ve invested in the entire suite. However, if I wanted to just keep Bento in sync from iPad to iPhone, I would be out of luck.
Syncing to the Mac is simple, as I have come to expect with Bento. There is nothing more than pairing Bento on iOS with Bento on the Mac. Bento must be running on the Mac to initiate a Sync from iOS. Syncing can only be done over a WiFi network and must be manually initiated on the iOS device.
There are few options for syncing. I can choose to never sync a specific library, but I can not selectively sync one set of libraries to one device and another set to another device.
Syncing
Lists
Only the Mac version of Bento can create Smart Lists. However, the iPhone version can create manual lists. Their not as useful for me as Smart Lists but at least it’s possible. You can use smart lists that are were created on the Mac and they work great. I can whip out my iPhone while I’m at some beer shop and quickly see what I need to buy. No need to tap in a new search. I just select the Smart List I have for shopping.
Smart Lists are dynamically updated on iOS. If I happen to purchase something I needed and change the quantity to something greater than zero, then the item is removed from the smart list immediately.
Search
Search is very slow on iOS, which is unfortunate since it’s necessary for a large library. It is also limited to global text searches. I say limited, because that’s the worst possible search for a large organized library. It would be more efficient and helpful to provide a search by record properties. I almost never search my library on iOS. I use the Smart Lists and the sorting functions.
Searching on iPhone
Sorting and Viewing
iOS Bento offers good options for sorting and displaying the record list. I can set primary and secondary display fields, as well as sort by any field. In a small way, this makes up for the lack luster search. As long as my list is sorted in a logic way, I can find what I’m looking for.
Sorting
Editing
Editing on iPhone is much more difficult, but that’s usually true of any multi-platform application. The screen space is so much smaller that it’s difficult to display and edit everything at once. Bento has tried hard to make the process simple, if not easy. The process is much like any iPhone app from 2008. It uses the standard view controllers and elements that require multiple taps to enter and back out of. It was fine a couple of years ago, but the bar for design on iOS is much higher now and Bento fails in the data input area.
Editing
One area the iOS does excel, is adding multi-media to a library record. There is full support for the camera and photo library as well as video and audio capture. I like to include photos of the bottle when I inventory. It makes it easier to identify again when I’m at the store, or trying to find it at the back of my beer cabinet.
I haven’t tried to use any other media in my libraries, but I could imagine using the audio recording function to capture quick voice memos and notes, especially on my iPhone.
Bento on iPad; $4.99
The iPad version of Bento is easy to use and provides an elegant interface. However, if you put a lot of effort into designing your Mac Bento library, that is all stripped away when using the iPad. There are eight standard templates that are quite nice looking, but no custom design is possible. The customization consists of adding or removing fields from the display and positioning them vertically on the form.
Where the app really shines is data entry on the iPad. Bento provides a quick entry form to get data into the app. Combined with the skeuomorphic presentation of the data as a book or clipboard the iPad version of Bento feels comfortable in my hands.
Sorting and Viewing
Viewing records on the iPad is very similar to the iPhone, except it’s actually comfortable to view a large library. My beer library works nicely in list view. I can easily find a specific beer and check its rating in just a couple of taps.
iPad List
In addition to a more useful list view, iPad Bento provides custom input keyboards based on the data type. This is very similar to Numbers for iPad.
iPad Input
While there is plenty to love about iPad Bento, there is still room for improvement. I’d love to have the Mac versions split view available. Search also needs to be improved. Seriously improved. I’d also like just a small amount of formatting control. For example, some fields do not need to span the entire page and could easily be placed side-by-side if only the app allowed it.
Data Portability
I’ve already mentioned how easily I can get data out of Bento on my Mac but sometimes I just want to notify a friend of a great beer while I’m away from desk. It happens. Unfortunately the iOS versions of Bento completely fail for data export and sharing. The only way to share a record is to perform a screen capture and mail the image.
It’s hard to comprehend how the 4th version of the iOS app still has no mechanism for sharing data. It’s baffling and frustrating. It’s also why this story does not end here. Bento great on my iPad until I wanted to share my library.
I had an old friend coming to visit for a few days and I wanted to arrange a beer tasting from my private reserves. I had just assumed I could grab my iPad and quickly send a “print out” of my Beer Inventory. Not so fast! I was required to switch to my Mac and export the library to a CSV file. I was then able to import the data in iWork Numbers and paste the list into an email. So while the data is portable on the Mac, it is not easily shared.
Pros and Cons
This review is based on my single use-case: a beer inventory system. Some of the cons may not matter for other use cases but this is my perspective on the Bento experience.
Pros
- List and Form views
- Add photos to an entry from the iOS camera
- Sync with desktop application
- Well implemented search on Mac
- Available for Mac, iPad and iPhone
Cons
- Unusable search
- Tiny controls on iPhone
- No options to share an entry on iOS
- Limited data portability (requires Mac version)
- Only two devices can sync with Mac at a time
- Manual sync required from each iOS device
- Sync over WiFi only
- Manual multi-step sync
- No auto-suggest text from previous entries
Overview and Distinctions
Just what is Bento?
Named after the compartmentalized Japanese meal box, Bento is a databasesuited to personal usage, organizing the compartments of our lives.Bento inherently ties in with your Address Book (contacts), iCal(calendar/schedule), and your iPhoto library.Whereas FileMaker Pro is for both Mac and Windows, Bento is not versioned forWindows.Bento started out on the Mac; then came a reduced version for the iPhone (andiPod touch); then came a somewhat boosted version for the iPad.
Why would I want that instead of FileMaker Pro?
The single word summary for the reason would be: cost.FileMaker Pro costs $299, and $179 to upgrade.Bento costs $49 on the Mac, with a proportionally smaller upgrade cost.(The upgrade is offered for a reasonable period of time following a new release,whereafter one must pay the purchase price.)Bento is a lot more affordable.
The second compelling reason to choose Bento is that it is also available onApple's handheld devices: iPhone, iPod touch, and iPad.Not only that but, get this, the price there is just $5!And you can sync a copy of your Mac Bento database table from the Mac to thehandheld device.The version on the handheld device is a true, manipulable database environment,just not as fully featured as the Mac version: the differences aresummarized in FileMaker's Answer ID 7620 documentWhat are the differences between Bento for Mac, Bento for iPad, and Bento for iPhone/iPod touch.Why would you want a database on your mobile device?A good example is when you are out video disc shopping and see a good price on acertain title — but you're not sure whether you already own that title.If you've seen people toting a large, printed list of videos they already own,you'll immediately appreciate the expediency of having the list on your Applemobile device.
FileMaker Pro is an 'industrial' database package, providing a wealth ofcapabilities which are well in excess of the needs that most people have for adatabase they will use for their personal needs.
How different is the Bento experience?
While FileMaker is an Apple company, and follows Apple interface guidelines,they are not obligated to adhere to the Apple infrastructure; and with thatfreedom, they take independent approaches to things.(The separation of the two companies is pronounced in Apple keynotepresentation, where FileMaker company products are rarely mentioned.)
Bento's orientation is more modern than that of FileMaker, as the company hadthe opportunity of a fresh start with the invention of the product.One of the first things you'll notice is that whereas FileMaker was fileoriented, Bento is not: you would have a FileMaker database in your file systemwhich you would double-click to launch; but Bento takes the more modern approachof being app-centric, where you simply launch Bento, and your data is there withit. In that way, Bento is in tune with the iPhone, iPod touch, and iPad in theview that slogging through a file system is just so old-school and unnecessary.
Bento does not burden the person with database/table terminologies.Instead, Mac Bento stores related information in what it calls Libraries.
In syncing a dependent device to your Mac, 'sync' is synonymous with the usageof iTunes as the syncing vehicle.Bento does not adhere to that convention, which is likely partly due to Applenot wanting a subsidiary database product having a dependency which could hinderthe evolution of the company's primary infrastructure.Instead, Bento itself performs the synching, over a wireless connection,directly between the Bento instances running in the two devices.
And, to further confuse things..
On July 20, 2010, the FileMaker company released FileMaker Go, being a mobileversion of the FileMaker product, for the iPhone and iPad.Database systems must be developed on the desktop; thereafter they can beremotely accessed via FileMaker Go conducting a session with the FileMakerserver, or by transferring a copy of the database to the mobile device foron-the-go reference.Hopefully, the development effort on FMGo will not detract from Bentodevelopment: it might even help further both products.
So, is FMGo worth getting into?If you're committed to FileMaker Pro, Go is probably worth it to you, to have aportable version of the database you're familiar wity.Again, you have to be willing to pay the price: the iPad version costs almost asmuch as the full Bento for the Mac.
Usage and Tips
Syncing with your mobile Apple device
Bento syncing has been slowly evolving..Mac Bento 3.0 will sync with one iPhone or iPod touch.As of Mac Bento 3.0.4, it will now sync with one iPhone or iPod touch, and one iPad.This syncing is very fast.As of Bento 4 for iPad, the iPad becomes a peer rather than subservient device,where you can sync from the iPad to your Mac.As of mid 2012, there is still no iCloud synching in Bento, unfortunately.Here's how to sync with an iPad:
Turn on the Mac and iPad, and have both active on the same wireless network.Launch Bento on both.On the iPad, go into Tools (the gear symbol, upper right) and chooseSync With a New Computer.This will result in a 4-digit passcode being displayed on the iPad.In the Mac Bento, go into File > Set Up Sync with Device.The iPad will show up in the Mac Bento boxed list ofChoose your mobile device.Enter the 4-digit passcode on the Mac.Bingo: Immediate pairing and syncing.In Mac Bento's left pane, the DEVICES entry will show both your iPhone/touch andthe iPad.On the iPad, its Tools area will show when the last sync occurred along with aSync Now button.
Restriction: Syncing is restricted to a common set of Libraries for the set ofmobile devices.This is to say that you can't have your videos list on just your iPhone and householdinventory on just your iPad.
Bento for iPad
The iPad version of Bento started out as a lesser product compared to the Macversion, but has greatly evolved such that the iPad incarnation is relatively comparable.As such, the iPad version numbering jumped from 1.1 to 4.0 to be in step withMacintosh Bento. (As of mid 2012, the iPhone version remains at a 1.2.1 numbering.)Usage of Bento for iPad is summarized in FileMaker site Answer ID 7620 documentBento for iPad help.So, what's it like to upgrade from version 1 to 4 on the iPad?The new version downloads and installs separately: it does not replace theearlier version.When you first launch the new version, it detects that the prior version was inuse and presents a dialog box to allow the new version to adopt the databasethat was in use with the prior version.To accomplish that, the database must be exported using the earlier Bento, whichis dynamically invoked in the background, whereupon the database is nowavailable in the new version.Many customers use the Mac Bento as their primary database repository, being thedefinitive data source, and sync to their mobile devices from that, such thatthe database migration within the iPad is somewhat superfluous, but still a goodthing to do.
Bento Database Mac
Back to the Things Apple page