TFP BOT
?

Run the operation on a Google Sheet

Use an ORBAT-style spreadsheet as the roster, the way it worked before ORBATs existed.

Admin Discord — /setup-slots sheet_url:<link>

How to do it

  1. Share the spreadsheet with the service account in GOOGLE_CREDENTIALS as an Editor.
  2. Lay the first tab out ORBAT-style: a squad name, then slot cells starting 1. or 1-, each with [] <Insert Name> beside it.
  3. Run /setup-slots sheet_url:<link>.
  4. Approving writes the member’s name and unit tag into the cell; clearing restores [] <Insert Name>.

Worth knowing

  • Only the first tab is read, and the operation is named after the spreadsheet unless you pass name:.
  • A sheet with no <Insert Name> markers has no free slots as far as the bot is concerned, whatever its columns are called.
  • Inserting a row moves every cell below it. Run /sync afterwards to repair pending requests that now point at the wrong row.
  • If the sheet write fails on approval the request is rolled back, so the sheet and the board never disagree.

See also

Run the operation on an ORBAT Admin Use a roster held here instead of a spreadsheet — the default choice, and the simpler one. Export an ORBAT to a Google Sheet Admin Write the roster into a spreadsheet, for people who want it there as well.

← All how-tos