-1

I created a Google Sheet for a group of people to use. However, some of these people do not know how to use filtered view (for example) in Sheets. Therefore I created some buttons to automatically filter the content and to hide/display certain information using macros/scripts.

My problem is that these buttons only work for me. I read that I can try to work with installable triggers, however, I cannot find the elements of the path that they describe. I tried to create a new trigger (in the AppScript menu) and it worked, however, I was only able to make it work for a couple standard triggers, such as when someone edits the sheet, and don't know how to link this to someone clicking the buttons.

All users have been granted editor access so that should not be the cause of my issue.

Mark Rotteveel
  • 100,966
  • 191
  • 140
  • 197
Milan L
  • 1
  • 1
  • 2
    Are some using Excel? – Solar Mike Aug 30 '23 at 11:55
  • Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. – Community Aug 30 '23 at 21:02
  • `However, some of these people do not know how to use filtered view (for example) in Sheets.` The words **for example** jumped out at me. I sense that you could go to some trouble to devise a solution for "filtered views" only to deal with a different issue next week. With the greatest respect, may I suggest that the answer here is staff training (by video). – Tedinoz Aug 31 '23 at 02:52
  • @SolarMike No, everyone is on Google Sheets and also logged in with their accounts. – Milan L Aug 31 '23 at 12:08
  • @Tedinoz Yes, I agree that that is the best 'last resort'. However, it would make their life a lot easier if I could get these buttons to work and that is my job. – Milan L Aug 31 '23 at 12:08
  • Then why tag Excel? If it has nothing to do with Excel then don't tag it... – Solar Mike Aug 31 '23 at 12:11
  • No worries, Milan L; we've all been there :) `My problem is that these buttons only work for me.` In order to assist you, we need your spreadsheet, complete with scripts and buttons. Don't post any private data, just use dummy data. – Tedinoz Aug 31 '23 at 22:53
  • @Tedinoz I also contacted others for help and it has been resolved for now. I was told that the users did not get an 'authorisation pop-up' when they tried to use one of the buttons, but that turned out to be false. It was therefore a matter of explaining how they had to 'trust' the project for the buttons to work. Thank you anyway! – Milan L Sep 02 '23 at 14:49

0 Answers0