0

I've inserted a script to hide row when user click on a button in a googlesheet document. This document is opened simultanously with multiple users. My problem, when a user click on the button, rows are hiden for all users.

Is there a possibility to limit the action on the user who click the button?

here is the code to hide row:

activeSheet.hideRows(rowStart,rowCount)

thanks a lot for your help

Cyrille

Improve this question

2 Answers 2

Reset to default
1

Every simultaneous user sees the spreadsheet at the same state. The only exception is with filter views that can show the sheet with some rows hidden, and in a different sort order.

Unfortunately, I do not think that filter views can be configured programatically. They are managed by client code in the user's browser, while Apps Script runs on Google's servers and consequently has no access to filter views.

One workaround, a bit clumsy though, is to insert links in the frozen section of the sheet to easily switch between filter views. See the Filter views example spreadsheet for an illustration. This works well but the filter views need to be defined in advance, and that cannot be done programatically.

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

0

Use Fiter Views to allow each user getting different partial view at the same time. https://support.google.com/a/users/answer/9308952?hl=en

Improve this answer

2 Comments

thanks. do you know if possible to do that with apps script. I've found no solution
What I have already done is to select a filter view among different ones, but not to build them.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.