A
A
Alex23432019-09-28 13:12:43
Google Sheets
Alex2343, 2019-09-28 13:12:43

How to link to Google Sheets with edit-protected checkboxes?

The situation is this, there is a Google table with checkboxes (checkboxes), you need to do so that

  1. Those to whom I will throw off the link to the table could check the box once (cannot be changed)
  2. You can't uncheck it either.

So far, I've just tried to protect the range, but then the checkboxes cannot be set to a third-party user.
Who has any ideas?

Answer the question

In order to leave comments, you need to log in

2 answer(s)
A
Alexander Ivanov, 2019-09-28
@oshliaer

There is no such functionality. Let your users check boxes in Forms.

G
Grigory Boev, 2019-09-28
@ProgrammerForever

You can pervert and add an onEdit () handler, where you can put protection on the checkboxes and remember users separately. But it will be difficult and unreliable. Google Forms will indeed be the best solution.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question