Using Google Apps Script, is it possible to allow users only access few spreadsheet records?

Question

What I want to do is onOpen, find out who the user is and store their email address in a variable. That part is no problem. The issue comes next.

Is it possible to then say, Display only the records that contain that user's email address?

Short answer is no. Think about a UI as a standalone webapp that shows selected data depending on the logged in user. — Serge insas
– Serge insas, Commented Mar 24, 2014 at 17:24

Zig Mandel · Accepted Answer · 2014-03-24 20:05:41Z

1

Not possible. Build an app (uiapp or htmlseevice)

answered Mar 24, 2014 at 20:05

19.9k5 gold badges32 silver badges39 bronze badges

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

1 Answer 1