Operation grid view in spreadsheet

[tidoust]

Documenting a set of tasks worth looking into to complete the exploration started to synchronize the content of the repo/project with a Google spreadsheet and create a grid view within the spreadsheet automatically:

• GitHub to spreadsheet
  • Explore/Switch to workload identity federation
  • Drop Meeting column for breakouts
  • Drop Day/Slot column for group meetings
  • Make the labels a constrained multi-select from breakouts
  • Consider incremental updates to allow more columns in the spreadsheet and shuffled rows
  • Add data validation constraints to the Meetings sheet
  • Also synchronize from the spreadsheet to the repo / project
  • Consider retrieving zoom info from spreadsheet
  • Run synchronization as part of GitHub workflow
  • Write documentation
• App Script
  • Make script a standalone script (not bound to a spreadsheet)
  • See whether script can be added automatically to a new spreadsheet
  • Save script in w3c/tpac-breakouts
  • Explore script publishing workflow
  • Synchronize grid whenever an edit is made to data in other sheets
  • Consider incremental grid updates (to avoid clearing it entirely)
  • Synchronize List and Meeting view when an edit is made
  • Constrain edits in all non grid views - number, issue title, issue body
  • Constrain edits in the grid view, initially with protected ranges or data validation
  • Synchronize edits to room names in the grid view with the Rooms sheet
  • Synchronize edits to meetings in the grid view with the Meetings sheet
  • Report conflicts within the grid view
  • Import validation logic so that an editor may try updates
  • Write documentation

[ianbjacobs]

In spreadsheet, could progress on #134 by creating a new sheet with references to rooms with columns for unavailable dates and multi-select of slots

[ianbjacobs]

Some data currently in the generated HTML pages will not be that useful in the spreadsheet view (e.g., group view)