CODEWITHSUNDEEP
google-apps-scriptgoogle-apigoogle-sheets
Ulk
Ulk

Reputation: 187

how to check if a user has opened another spreadsheet

Hy, my question is simple: how to check if a user has opened another spreadsheet? So I have a master spreadsheet and a slave spreadsheet. I have some routines that are in the code of the master that run on the slave spreadsheet. I want to know if there are users that are working on the slave spreadsheet when my routines run from master spreadsheet.

thanks

Upvotes: 0

Views: 187

Answers (1)

Zig Mandel
Zig Mandel

Reputation: 19835

Theres no api to tell if there are users with the spreadsheet open. However, you can look at the slave's last modified date to tell if someone changed them recently. You can also have onopen/onedit apps script installed triggers on the slaves and store the date last opened/modified from a browser

Upvotes: 4

Related Questions