My wife organises amateur and semi-pro orchestras. She has a ‘database’ of about 600 musicians which she currently keeps in an OpenOffice spreadsheet on the Mac, with each player’s name, instrument(s), contact details, some notes, and a record of which concerts they have played in. She’d now like to have this accessible on her iPhone (4S). It would be nice to be able to edit it on the iPhone, but not essential; it needs to be easy to keep the two copies in sync; it would be great if it was easy to call/SMS someone’s number from the iPhone database, but she doesn’t really want to merge the database with her iPhone address book.
I can think of a few different ways of solving this, for example:
- view the spreadsheet on the iPhone using Quickoffice or Documents to Go
- move the spreadsheet to Numbers on the Mac and iPhone, syncing via iCloud
- use some sort of business contacts manager app, maybe adding contacts to groups to define both instrument played and concerts played in
- create some sort of custom solution using Bento on the Mac and iPhone
I don’t have any of the above apps at the moment. Any advice on the ideas above, or any alternative suggestions please?