Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

I have a spreadsheet in Google Docs. Users can change everything and anything in the spreadsheet.

Now, I want them to be able to change empty fields or their own fields only.

Is this possible? If yes, how?

share|improve this question

migrated from stackoverflow.com May 31 '12 at 23:35

This question came from our site for professional and enthusiast programmers.

add comment

2 Answers 2

up vote 3 down vote accepted

It's not possible using just Google Docs. If you've written some sort of program that just uses Google Docs as a storage mechanism, then you can do anything you want. For example, you could add a column that records the name of the person who created each row. When someone tries to edit a row, verify that they are the person listed as the row creator before accepting the edit.

share|improve this answer
    
Oh, good call. I didn't think of using the Google Docs API. That's probably the best solution here. –  Daniel.J.Shapiro May 31 '12 at 14:04
    
thanks, any example for this? if it's too complicated it's not worth the effort and I have experience with the google docs api –  Ruben May 31 '12 at 15:02
    
I'm sure there are examples of programs that use Google Docs as a storage mechanism, but I don't have one for you. –  Caleb May 31 '12 at 15:21
add comment

Google spreadsheets can't do this. I don't think they've said that they'll implement it, either. I'm not sure what your exact situation is, but if you have a small, known number of users, you might try:

1. Create a spreadsheet for each user. Set those to private.
2. Let users enter their information in their own spreadsheets.
3. Create a public spreadsheet that gathers data from the private
   spreadsheets.

If your number of users is large or might grow faster than you care to manually add private spreadsheets, this obviously won't work. If that's the case, you might have to look elsewhere for a solution. I'm pretty sure the Office Web Apps would solve your problem, but those aren't free.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.