In the advanced options section I can enter a query, like "SELECT * WHERE B = 3". I am wondering if I can do that programmatically, ie. change the query from a script.
What I am trying to do is show a set of records based on the email address of the current user (which I can get using app script. So something like this:
var userMail = Session.getActiveUser().getEmail();
//now set the query
var query = "SELECT * WHERE A=userMail".
To add to the challenge, I need to be able to embed the resulting awesome table if possible.
Please sign in to leave a comment.