The journey of this specific version often stems from a community-driven desire to streamline tabletop gaming sessions. Unlike standard PDF sheets, GSheet v2.1 acts as a living database for a player's character.
Sharing a script with hardcoded SpreadsheetApp.openById('abc123') breaks if the sheet is copied.
Common parameters:
| Parameter | Values | Use |
|-----------|--------|-----|
| majorDimension | ROWS, COLUMNS | Orientation of returned data |
| valueRenderOption | FORMATTED_VALUE, UNFORMATTED_VALUE, FORMULA | Control cell output |
| dateTimeRenderOption | SERIAL_NUMBER, FORMATTED_STRING | How dates are returned | gsheet v2.1
Respect Warnings: You will see a warning when trying to edit "protected" ranges. These contain the math required for the sheet to function and should typically be left alone.
Looking for DND Beyond Alternatives for Character Sheet Creation 22 Nov 2024 — The journey of this specific version often stems
Tips to get the most from v2.1
Automatic Calculations: It automatically computes Ability Scores, Saving Throws, Skill proficiencies, and Armor Class (AC). No offline dynamic arrays: Spilled ranges recalculate only
Weapon attacks, spell save DCs, and damage modifiers are pre-calculated based on the character’s current level and equipment. Inventory & Encumbrance: