How to Code a Dynamic RPG Character Sheet OVERHAUL - Saving and Loading with PapaParse & Apps Script

Finally continuing my series on coding a dynamic RPG character sheet online using HTML and Javascript for Dungeons & Dragons games (and more). In this video I make a MASSIVE OVERHAUL to the character sheet and add SAVING and LOADING using the power of PapaParse.js and Google Apps Script to save and load our characters to a Google Spreadsheet.

Timestamps:
0:00 Intro
1:00 Demo
4:55 Why Google Sheets
7:06 HTML
8:00 Linking Bootstrap and PapaParse
8:51 Open form tag
10:15 Text fields with dropdowns (datalists)
13:26 Number field attributes (min, max, placeholder value)
15:09 Ability scores/modifiers
16:32 Save/Load buttons
17:47 Armor/Shields
19:38 Armor Class
20:11 Hit Points
21:00 Damage/Heal buttons
22:55 Hit Dice
24:35 Short Rest/Long Rest buttons
26:06 Proficiency Bonus
27:08 Skills
29:34 Javascript
29:52 characterData global variable
30:51 LoadSheet() (PapaParse Setup)
35:28 PopulateData()
41:49 LoadCharacter()
43:13 SetLevel()
45:37 SetProficiencyBonus()
47:33 UpdateAbilityScores()
49:59 UpdateModifiers()
51:59 UpdateSkillProficiency() (adding checkboxes to Google Sheets, IsTrue(string))
56:44 SetSkills()
1:00:21 UpdateHP()
1:01:45 UpdateHitDice()
1:03:02 LoadGear()
1:06:13 UpdateAC()
1:07:59 Shield Modifier
1:08:44 TakeDamage()
1:09:08 HealHP()
1:10:22 LongRest()
1:10:49 ShortRest()
1:11:07 SaveData()
1:12:24 Google Sheet Setup
1:12:33 Validation Setup
1:14:44 Apps Script
1:15:39 Initial Permissions Setup
1:17:28 doPost(e)
1:26:38 Setup Trigger behavior
1:27:44 New Deployment
1:29:08 Conclusion

Link to Character Sheet v7 on Codepen: https://codepen.io/midnighthatter/pen/KKyyrvB?editors=1010
Apps Script tutorial on GitHub: https://github.com/levinunnink/html-form-to-google-sheet
My Apps Script: https://drive.google.com/file/d/119vNOZstE7k66vLSb-dGkUDSgATp6Flw/view?usp=sharing
PapaParse docs: https://www.papaparse.com/

Discord: https://discord.gg/4MfSegD
Gundam RPG Rulebook and Resources: http://www.gundam5e.com
YouTube: https://www.youtube.com/c/midnighthatter
Odysee: https://odysee.com/@MidnightHatter:e
Twitch: https://www.twitch.tv/midnighthatter

Patreon: https://www.patreon.com/midnighthatter
Locals: https://midnighthatter.locals.com/
DMsGuild: https://www.dmsguild.com/browse.php?author=Stephan+Bayless
TeeSpring: https://teespring.com/stores/midnight-hatter