M
M
Maksim19882020-08-21 08:50:59
Google Sheets
Maksim1988, 2020-08-21 08:50:59

Is there a free analogue of Google Spreadsheets with access control?

Hello!
At work, they gave me an excel tablet and asked me to make it available to several people (~ 10 people). All these people are in different places and they must enter their data into this plate. At the same time, there is a requirement that they see only their parts of the table, for example, each has its own sheet in the table. Also in the table there are simple formulas (summation), the calculation results of which are on a separate sheet, which everyone should not see either.
In Google Sheets, it seems like you can do all this, but then each participant must have their own account. This is the main bug and turned out to be. Since there are certain requirements at work to control everything and everything, we need access to all these accounts. One phone number does not have so many accounts. The fastest and easiest way would probably be to ask these people to create accounts themselves and pass information on them to us. Only with this, too, there is some kind of plugging, since these people have a great desire to evade work (they “forget” to do it, then they “lose” the password from the account, then they delay the completion of work, or something else). Nevertheless, I am inclined to somehow force them to register themselves in Google mail and give me logins and passwords. Let me remind you again
As a result, such a question - what is the best thing to do in this situation? Or maybe there are some other options for implementing such a project? I am not very well versed in IT, it only occurred to me to create a site on a free hosting and somehow already make an analogue of such a table there, but I have never done this and it will take some time to master it, but you need to do it, according to the request it was yesterday morning.

Answer the question

In order to leave comments, you need to log in

3 answer(s)
D
Dimonchik, 2020-08-21
@Maxim1988

At the same time, there is a requirement that they see only their parts of the table, for example, each has its own sheet in the table

you can’t
do this 10 tables, share access to yourself and one to each,
then use a script to combine the data into one file for the authorities

N
necrodeflorator, 2020-08-21
@necrodeflorator

What to advise? Get out of this job.

A
Alexey Andreev, 2020-08-27
@LostAlly

In general, this can be done, but for this you need to write your own authentication and authorization, as well as handlers for all your Wishlist.
The only question is, does it all make sense?

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question