Can I open Google Sheet's side bar and filter the tasks as I select a cell?

Question

I understand that we can write and read tasks using Google Apps Script. I was wondering if I could have the side bar open, as I click on a certain cell, containing a data. Then, the side bar would appear, showing the tasks due on that date.

This is what I'm talking about:

Answer 1

Unfortunately there is no way to open the Task sidebar from the UI class. As @Tanaike references, there is also no way to activate the UI from a Simple Trigger.

They cannot access services that require authorization.

onSelectionChange(e) Simple Trigger pointing to "https://www.googleapis.com/auth/script.container.ui" scope in this case

You could make a Feature Request, asking for that functionality to be integrated in Apps Script.

As a workaround you can activate a sidebar by creating an Installable Trigger, and using Task API to filling it, but in that case you would only have the edit and change events available. The trigger would only change when a value or the spreadsheet structure changed.

Code.gs

const test = (e) => {
  // Getting all the task from a certain TaskList
  // this should be tweaked for obtain the TaskList from a
  // certain day 
  var tasks = Tasks.Tasks.list(TASKLIST_ID)
  if (!tasks.items) return
  Logger.log(tasks)
  let htmlContent = tasks
    .items
    .map(task => `<li>${task.title}-${task.note}</li>`).join(' ')
  SpreadsheetApp.getUi()
    .showSidebar(HtmlService
      .createHtmlOutput(htmlContent)
      .setTitle('Custom Notes'))
}

Documentation

• Simple Trigger Restrictrions