Cristina, I don't see how you could control access to a Google spreadsheets page via an app. I see two ways to do what you want (if I understand what you're trying to do).
A. This is the hard way which I don't suggest: Create a web app which does a user login function, then displays data from your master spreadsheet and writes any data they enter back into the spreadsheet. B. This is much easier and may not require any app to be written. Create a spreadsheet with 3 sheets Master, Grp_a, Grp_b. Share Grp_a with each user that needs access and grant Edit privileges. Do the same with the Grp_b sheet and users. In the Master sheet, use the cell function example to get cell A1 data ='Grp_a'!A1 into the Master sheet. Duplicate for other cells you need. Then your Master sheet then has all required cells from the Grp_a and Grp_b sheets. If you can use spreadsheet cell functions for all of your processing, put it in the Master sheet. If the users need to see output (results) from the Master sheet, create Grp_a_results and Grp_b_results sheets that import data from Master sheet via cell functions ='Master'!<cell address> BUT grant only View access to users so they can't change cell functions and get other cell data from the Master sheet. If the spreadsheet functions are not powerful enough to do everything you need, then you could create a desktop app that reads and writes data to the Master sheet or all of the sheets. Hope that helps, Bill Hayes On Fri, Oct 2, 2009 at 12:28 AM, Chitinuta <[email protected]> wrote: > > Thanks for your reply. > Yes, it is a single app domain, premier account. "admin" is only one > powerful user, and only this user can see and modify the spreadsheet, > actually he is the owner of the spreadsheet and "user" can be anyone > in the company (by this I also mean same app domain), but these users > can see/modify only parts of the spreadsheet. > It has to be a web application so I'll be careful with the tokens to > properly reuse them. > > Cristina > > On Oct 1, 7:13 pm, "Bill H." <[email protected]> wrote: > > Chitinuta, > > Yes, you could have 2 or more clients. As long as they > > each have a valid login. > > If you're doing ClientLogin from a desktop there's no issue. > > However, if you have a web app that uses AuthSub tokens there can > > only be 10 outstanding tokens between a given server and a > > given google acct, so you should securely store the tokens and > > re-use them. > > This is a Premier App account where the 'admin' and 'user' > > are different accounts in the single App domain? > > > > Regards, > > Bill Hayes > > > > On Oct 1, 12:07 am, Chitinuta <[email protected]> wrote: > > > > > I need to do an application based on logged in user's privileges. I > > > mean I have a spreadsheet which is available only to an admin > > > publisher, I have a group of users that can see and update only a set > > > of columns and another group of users which can see and update another > > > set of columns. > > > My problems is that I need to make first a login for the current user > > > to see who it is and based on this see what privileges he has but also > > > I have to make an internal login as the admin publisher to be able to > > > fetch the spreadsheet columns. > > > What do you suggest to do? which do you think is the best approach? If > > > I use 2 instances of the SpreadsheetService (one for user login and > > > one for admin publisher login) it will be a problem? > > > Thanks > > > > > Cristina > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Google Docs Data APIs" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/Google-Docs-Data-APIs?hl=en -~----------~----~----~----~------~----~------~--~---
