How do I update certain columns in a GSheets table from a Javascript Query

💬 Queries and Resources
3

Hi @justin!

Great. Thanks!
Sounds like I need to use this answer here to do the thing: Send data from one JavaScript Query to another

Here is my understanding of the steps:

  1. Form1 auto-populates with selected table row data
  2. User adds/modifies form data and hits submit
  3. JavaScript Query runs, manipulates some data, triggers other queries, completes (successfully)
  4. On successful completion JavaScript Query triggers a Google Sheets Update query, passing in the data needed to identify the row, columns, and updated values for those columns
  5. Google Sheets Update query runs, updating the Google Sheet with passed values
  6. Google Sheets read query reruns to get newly updated data
  7. Table refreshes, showing updated data

Is that about right?