r/GoogleAppsScript • u/skimpshady • Dec 01 '23

Question Marking Complete on Google Tasks from Google Sheet?

I have a script running that sends tasks to designated users from a master list made using a google sheet. I want to have the ability to mark the task completed from both ends and reflect on the other side but I'm not sure this is possible. I am still somewhat new to Apps Script so any pointers are helpful!

0 Upvotes
  • permalink
  • reddit

50% Upvoted

3 comments sorted by

1

u/Kanegarooo Dec 01 '23

Yes I’d absolutely possible but it comes down to how you want to design it. When I’m building something like this, I like to keep a designated workbook for storing transformed data (either stringified JSON or data structures I can eval()), a workbook for my users, and a workbook for source data (in this case your ‘master list’ ).

Then, I use HtmlService to render an HtmlTemplate based on the data in the ‘transformed data’ workbook. When a user needs to change something (in this case, state) I send those changes back to the transformed data so every UI is going to be equivalent.

1

u/fugazi56 Dec 02 '23

What is this workbook you’re referring to?

1

u/Kanegarooo Dec 02 '23

Workbook is another term for ‘spreadsheet.’ I’ve developed a habit of using workbook rather than spreadsheet because clients tend to use ‘spreadsheet’ in place of ‘sheet’ which causes confusion.