Premium Only Content
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
-
2:05:48
2 MIKES LIVE
3 hours agoTHE MIKE SCHWARTZ SHOW with DR. MICHAEL J SCHWARTZ 12-24-2024
8.76K1 -
1:14:17
MTNTOUGH Fitness Lab
1 day agoNavy SEAL Dom Raso: The Cold, Hard Truth About Modern Brotherhood | MTNPOD #96
6.57K1 -
43:42
Dad Dojo Podcast
19 hours agoEP14: Every Girl Dad's Biggest Fear and How To Prevent It
4.26K -
55:06
Bek Lover Podcast
12 hours agoWill Trump Pull Off A Miracle? Other Strange News Podcast...
3.69K4 -
55:53
PMG
1 day ago $0.01 earned"Hannah Faulkner and Courtney Reed | BEHIND THE LENS OF A TRUMP PHOTOGRAPHER"
3.13K -
8:09:50
Dr Disrespect
1 day ago🔴LIVE - DR DISRESPECT - MARVEL RIVALS - GOLD VANGUARD
223K37 -
1:15:00
Awaken With JP
1 day agoMerry Christmas NOT Happy Holidays! Special - LIES Ep 71
307K252 -
1:42:21
The Quartering
1 day agoTrump To INVADE Mexico, Take Back Panama Canal Too! NYC Human Torch & Matt Gaetz Report Drops!
219K140 -
2:23:15
Nerdrotic
1 day ago $17.49 earnedA Very Merry Christmas | FNT Square Up - Nerdrotic Nooner 453
160K16 -
1:14:05
Tucker Carlson
1 day ago“I’ll Win With or Without You,” Teamsters Union President Reveals Kamala Harris’s Famous Last Words
273K425