Free Online Storage

  • Subscribe to our RSS feed.
  • Twitter
  • StumbleUpon
  • Reddit
  • Facebook
  • Digg

Friday, 13 February 2009

Add, edit, sort, and filter: Improved mobile access to spreadsheets

Posted on 06:30 by Unknown
Over a year ago, we enabled view-only access to docs from mobile devices. This has come in handy for me because I use Google Docs spreadsheets to keep track of a lot of nerdy and not-so-nerdy things in my life. I've often found myself wanting to access my spreadsheet data on the go, when I'm not near a computer.

Today, I'm happy to announce that we've made mobile access even better by adding new capabilities with List View for spreadsheets. You can quickly view, edit, sort, and filter your spreadsheets on a variety of mobile devices including Android-powered devices like the T-Mobile G1, the iPhone and iPod touch, and the Nokia S60.

With Valentine's Day coming soon, I'd like to share two ways that List View is helping me to play cupid.

Last week I was trying to find some Broadway tickets to surprise my boyfriend for Valentine's Day. A friend of mine at a ticket agency publishes an online spreadsheet with a list of last-minute available tickets. From my iPhone, I was able to quickly access his spreadsheet to see upcoming shows:
 
Mobile List View showing all shows (sorted by "Show" column).  Shown in portrait mode on the iPhone.

From here, in just a few taps, I was able to filter down to tickets available on Valentine's Day:

Choosing a filter for the "Date" column.

I could see only the rows that matched my filter, and I eventually found a show that I knew that my boyfriend would like: "Billy Elliot The Musical" at 7pm with orchestra seats.

All rows matching the "2/14/2009" filter.

With tickets purchased, and a restaurant booked, I'm nearly set. Here's another example of how this enhanced mobile access will come in handy tomorrow night. A few of my friends and I like to think of ourselves as wine aficionados. We rate wines that we like (and don't like) in a wine diary and it's kept in a shared spreadsheet. On the T-Mobile G1 or the iPhone home screens, we all have shortcuts which link directly to the spreadsheet.

Mobile List View showing all wines. Landscape mode on the G1.   

While at a restaurant or wine bar, we can see each others' recommendations and note our likes and dislikes.  Here I can view and add a new entry:  

Mobile List View "Add row" widget on the G1.

Tomorrow night, mobile access to this spreadsheet will come in handy when presented with a big wine list, with my significant other looking at me across the table waiting for me to pick a wine (already).

Try this out by pointing your mobile device's browser to m.google.com/docs. And if you use Google Apps, go to docs.google.com/a/your-domain. This feature is available in all 38 languages that are supported in Google Docs spreadsheets.

Posted by: Eric Bogs, User Interface Software Engineer
Email ThisBlogThis!Share to XShare to Facebook
Posted in Google Apps Blog, mobile, spreadsheets | No comments
Newer Post Older Post Home

0 comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Popular Posts

  • More Google Experiments That Hide Results URLs
    There are at least two other versions of the Google experiment that removes search results URLs . The first alternate version places site na...
  • Merge cells vertically in Google spreadsheets
    There are many times when you want to format your spreadsheets in a certain way to make your data easier to read and understand. Starting to...
  • Add a Keyboard Shortcut for Chrome's App Launcher
    I'm not sure why Chrome's app launcher doesn't have a keyboard shortcut, but it's pretty easy to add one. For Windows XP, r...
  • What's The Right Answer?
    Sometimes the same question can have multiple answers, even when you're looking for a simple fact. I've searched for [ny population]...
  • Google Quick View
    Google Search for mobile has a new feature called " Quick View ". Right now, it only shows up for Wikipedia results and it allows ...
  • Online Office Hours with Google Docs
    Cross-posted on the Google Student Blog Guest Post: Alex is a senior at Harvard University, and interned this summer on Google's marketi...
  • Give us your feedback with Product Ideas for Google Docs
    With Google Docs, we've learned that some of our most valuable insights come from our users, and we are always excited by what you have ...
  • More In-Depth Articles in Google Search
    For general queries like [ global warming ], [ love ], [ Mandela ], [ China ], Google shows some in-depth news articles at the bottom of th...
  • A completely new look for Drive on iOS
    One of the features you’ve told us you want on Drive for iOS is the ability to effortlessly browse and preview files, just like you can on A...
  • Google Tests New Desktop Sign-in Page
    Back in August, Google changed the sign-in page for mobile devices. A few readers report that they see the updated sign-in page in the desk...

Categories

  • Acquisitions
  • Ads
  • Android
  • Annoyances
  • April Fools Day
  • attachments
  • back to school
  • Blogger
  • charts
  • chat
  • Chrome
  • Chrome extensions
  • chrome web apps
  • Cloud Connect
  • collaboration
  • comments
  • community
  • discussions
  • DMCA
  • docs
  • document list
  • documents
  • documents list
  • drawings
  • drivebacktoschool
  • Easter Egg
  • education
  • Faces of Docs
  • forms
  • gmail
  • gone google
  • Google Alerts
  • Google Analytics
  • Google Apps Blog
  • Google Apps Script
  • Google Calendar
  • Google Cast
  • Google Checkout
  • Google Chrome
  • Google Chrome OS
  • Google Cloud Connect
  • Google Contacts
  • Google Dictionary
  • Google Docs
  • Google Docs Viewer
  • google documents
  • google drive
  • Google Earth
  • Google Goggles
  • Google Hangouts
  • Google Instant
  • Google Keep
  • Google Latitude
  • Google Local
  • Google Maps
  • Google Music
  • Google News
  • Google Notebook
  • Google Now
  • Google Pack
  • Google Photos
  • Google Play
  • Google Plus
  • Google Reader
  • Google Sites
  • Google Suggest
  • Google Takeout
  • Google Talk
  • Google Toolbar
  • Google Translate
  • Google Trends
  • Google Voice
  • Google Wallet
  • Google+
  • googlenew
  • Greasemonkey
  • Guest Post
  • holiday
  • iGoogle
  • Image Search
  • images
  • InOut
  • iOS
  • Keep
  • Knowledge
  • mobile
  • OCR
  • offline
  • OneBox
  • paperless
  • pdfs
  • photo
  • photos
  • Picasa Web Albums
  • presentations
  • product ideas
  • profiles
  • quickoffice
  • Reddit
  • research
  • save to drive
  • scripts
  • Security
  • sharing
  • sheets
  • shortcut
  • slides
  • spell check
  • spreadsheets
  • stock photos
  • storage
  • students
  • tables
  • teachers
  • templates
  • Tips
  • User interface
  • videos
  • Viewer
  • Visualization
  • Voice Search
  • Web Search
  • Yahoo
  • YouTube

Blog Archive

  • ►  2013 (519)
    • ►  December (33)
    • ►  November (44)
    • ►  October (64)
    • ►  September (50)
    • ►  August (63)
    • ►  July (60)
    • ►  June (57)
    • ►  May (62)
    • ►  April (49)
    • ►  March (33)
    • ►  February (1)
    • ►  January (3)
  • ►  2012 (34)
    • ►  December (4)
    • ►  November (4)
    • ►  October (5)
    • ►  September (4)
    • ►  August (2)
    • ►  July (1)
    • ►  June (3)
    • ►  May (2)
    • ►  April (2)
    • ►  March (2)
    • ►  February (5)
  • ►  2011 (80)
    • ►  December (4)
    • ►  November (1)
    • ►  October (7)
    • ►  September (10)
    • ►  August (11)
    • ►  July (8)
    • ►  June (9)
    • ►  May (1)
    • ►  April (8)
    • ►  March (8)
    • ►  February (8)
    • ►  January (5)
  • ►  2010 (118)
    • ►  December (11)
    • ►  November (16)
    • ►  October (6)
    • ►  September (13)
    • ►  August (13)
    • ►  July (7)
    • ►  June (15)
    • ►  May (11)
    • ►  April (7)
    • ►  March (7)
    • ►  February (6)
    • ►  January (6)
  • ▼  2009 (82)
    • ►  December (14)
    • ►  November (4)
    • ►  October (10)
    • ►  September (10)
    • ►  August (4)
    • ►  July (6)
    • ►  June (6)
    • ►  May (5)
    • ►  April (4)
    • ►  March (8)
    • ▼  February (7)
      • A faster way to get to Docs and other Google Apps ...
      • Data Validation gives you more control over your s...
      • Add, edit, sort, and filter: Improved mobile acces...
      • Students tell their stories
      • Preview before you print (and even more offline la...
      • Meeting your New Year's resolutions? We'd like to ...
      • Offline access available in 29 additional languages
    • ►  January (4)
  • ►  2008 (97)
    • ►  December (6)
    • ►  November (4)
    • ►  October (6)
    • ►  September (8)
    • ►  August (5)
    • ►  July (7)
    • ►  June (11)
    • ►  May (20)
    • ►  April (13)
    • ►  March (6)
    • ►  February (6)
    • ►  January (5)
  • ►  2007 (25)
    • ►  December (1)
    • ►  November (1)
    • ►  October (2)
    • ►  September (3)
    • ►  August (3)
    • ►  July (4)
    • ►  June (3)
    • ►  May (2)
    • ►  April (2)
    • ►  March (1)
    • ►  February (2)
    • ►  January (1)
  • ►  2006 (10)
    • ►  December (2)
    • ►  November (4)
    • ►  October (4)
Powered by Blogger.

About Me

Unknown
View my complete profile