Thread: MPMB's Character Record Sheet (PDF form) + MPMB's Spell Sheets (Excel / PDF form)

Originally Posted by Pauln6

Sounds like you might have sussed the issue. I'm using Acrobat XI on Windows XP with version 11.1 but all the macros worked on on the 10 series. The hang seems to be on the class macros, although I have not had a chance to check them all. Fey Warlock, illusionist wizard, and champion fighter produce the error. Race and background macros seem ok.

Having Dhood6708 post the software version and the error codes made it possible for me to identify the problem, that is why it is so important that people give specifics when they see an error. To be fair, the sheet does say it is not compatible with Adobe Acrobat XI and only works in DC. However, I think I found a way to make the sheet backwards compatible with Acrobat XI (and possibly X, but that is untested). You can try for yourself with version 11.2

Originally Posted by Astromath

According to page 91 the ranger gets a quiver with 20 arrows. When auto-adding the ammunition to the equipment list, the quiver does not show up. Request that when adding arrows, a quiver is also added as a container for arrows with the arrows listed as being contained in the quiver.

Quiver
- Arrows

Bolts can be done the same way. Just replace quiver with box (it seems to be assumed that a "quiver" of bolts is the same as "box" of bolts), or you can just leave it as quiver.

Box
- Bolts

Originally Posted by Pauln6

I always thought the traditional titles were a Quiver of Arrows and a Quarrel of Crossbow Bolts but the term quarrel is just another term for the bolt itself. A quiver can be used to hold arrows, bolts, or darts. I don't think we need separate terminology.

I think that some things are better not to automate. If I have the sheet automatically add a container to the arrows, what happens if the player doesn't want it? Why then aren't containers added for other items? I feel that people can take responsibility in thinking of what they want on and how they want to sort their equipment list without me imposing to many things on them with the code auto-adding stuff.

As for the Ranger's starting gear and what happens when you have the sheet add things from the ammunition section, I hope you understand that those two are very separate things. The starting equipment of any class is already part of the tooltip (mouse over text) of the "Add Equipment" button.


After some thorough looking through the code, I think I finally have a version that is compatible with Adobe Acrobat XI (again). However, I would highly recommend everybody to upgrade their Adobe Acrobat installation to version DC, especially if it is a Reader installation, because it is a safer version that protects better against malicious code (i.e. viruses)!

MPMB's Character Record Sheet v11.2 (7-5-2016) with the following changelog:

• Changed the way the equipment section interacts with containers, i.e. backpacks (as suggested by Astromath, sort of)
• Changed the way the equipment section interacts with adding ammunition (as suggested by Astromath)
• Added the “Maximum Spell Level able to cast” to the spell selection dialog (as suggested by Subpar77)
• Fixed a bug that stopped the adding of a class features if the class was first entered at a level that required the addition of a subclass
• Fixed a bug with Acrobat DC crashing at opening the sheet while the welcome message is showing
• Fixes a bug with the addition of items of quantities other than 1 (ammunition was affected most)
• Replaced all JSON functions from the code that are incompatible with Acrobat XI with functions that are compatible to ensure the sheet stays compatible with Acrobat XI

Whoops! Sorry. I'm not that technically minded when it comes to coding. I download the sheets and they work. Or not! But this one now works so thank you so much for the extra effort!

Edit: Just tweaking my warlock. I'm a pact of the tome warlock so I need to use the extra spells section for my cantrips, rituals, and at-will pact boons and I will run out of space. Would it be logistically horrific to generate separate dialogue boxes for your at-will pact boons and book of ancient secrets?

It looks like the limit on the extra spells is imposed by caster level i.e. I can't have more extra spells than the maximum number of spells my character can know at level 9. Maybe the simplest fix would be to just remove that restriction on the warlock spell page if the sheet recognises the pact of the tome class feature?

Edit 2: Ah but i can add a manual page so can add my rituals to that myself. Sweet.

Originally Posted by Pauln6

Whoops! Sorry. I'm not that technically minded when it comes to coding. I download the sheets and they work. Or not! But this one now works so thank you so much for the extra effort!

Edit: Just tweaking my warlock. I'm a pact of the tome warlock so I need to use the extra spells section for my cantrips, rituals, and at-will pact boons and I will run out of space. Would it be logistically horrific to generate separate dialogue boxes for your at-will pact boons and book of ancient secrets?

It looks like the limit on the extra spells is imposed by caster level i.e. I can't have more extra spells than the maximum number of spells my character can know at level 9. Maybe the simplest fix would be to just remove that restriction on the warlock spell page if the sheet recognises the pact of the tome class feature?

Edit 2: Ah but i can add a manual page so can add my rituals to that myself. Sweet.

No problem, the error got fixed and you helped by reporting that there was something wrong and that got me looking in the first place

I did the math of how big the "Extra Spells" section should be based on the Warlock. First of all, you mention the rituals you get from Pact of the Tome. I think you are referring to the "Book of Ancient Secrets" invocation that grants you the option to add rituals to your Tome. As you will see when you select this Invocation on the sheet, this class feature actually adds another "class" to the pop-up dialogs that you get. When you have that feature, you then get one pop-up for your Warlock spells (which includes all the other invocations) and a second pop-up dialog for your Book of Ancient Secrets, which allows you to add any amount of rituals.

I am also assuming that with "at-will pact boons" you mean Invocations that grant you access to spells (which can be at-will or once per long rest).

So, we have now concluded that the Rituals are not a problem, but this still leaves us with the other stuff that has to fit in the 15 slots of the "Extra Spells" section:

Slots 1-3 three cantrips from Pact of the Tome
Slots 4-7 four spells from Mystic Arcanum
Slots 8-15 Invocations, of which you can have maximal 8

Thus, it fits perfectly, even if you pick 8 Invocations that grant you spells.

Do note that in order for this to work, you will have to select the Invocations via the "Choose Feature" button on the second page.

JavaScripted-up the Haunted One background from Curse of Strahd:

https://gist.github.com/Ry7n/6f5f88e...606353a3c43361

Also:

* Devil's Tongue Tiefling is incorrectly showing a Dex bonus
* My spell sheet was being generated BETWEEN my Adventurer's League Log Sheet pages
* My spell sheet for Devil's Tongue Tome Lock was generated blank.

EDIT: unsure why that custom JS isn't working, but I'll update it if I figure it out.