Roll20 uses cookies to improve your experience on our site. Cookies enable you to enjoy certain features, social sharing functionality, and tailor message and display ads to your interests on our site and others. They also help us understand how our site is being used. By continuing to use our site, you consent to our use of cookies. Update your cookie preferences .
×
Create a free account
This post has been closed. You can still view previous posts, but you can't post any new replies.

Easily Nest Roll Queries

1472684134
Scott C.
Forum Champion
Sheet Author
API Scripter
Compendium Curator
Being able to use drop-down menus to access a lot of options for a roll is very handy, but as anyone who has tried their hand at macro-making knows getting all of the html replacements just right can be a time consuming process. This is especially true if you are trying to nest more than a single layer deep as you then need to escape your html escaped text. I decided to off-load this work to google sheets so that I could think about my macros in a closer to human readable format and thought that the community might benefit from this tool. Here is a view only link to the sheet (currently setup to generate my 5e saving throw/ability check/skills drop down macro): <a href="https://docs.google.com/spreadsheets/d/1fEtE4B5BMY" rel="nofollow">https://docs.google.com/spreadsheets/d/1fEtE4B5BMY</a>... You should be able to make a copy for your own use if anyone would like to use it. Happy Rolling, Scott
1472684599
The Aaron
Pro
API Scripter
Wow! &nbsp;That's some work!
Is that for the 5e OGL sheet?
Great tool!!
1472691730

Edited 1472691870
Scott C.
Forum Champion
Sheet Author
API Scripter
Compendium Curator
Ed S. said: Is that for the 5e OGL sheet? Yes, it is, plus a homebrew sanity system that the game I'm playing in is using (only difference is the addition of a Sanity Saving Throw}\). Although I apparently typed something extraneous in somewhere because it's not the correct output anymore.
1472694107
Scott C.
Forum Champion
Sheet Author
API Scripter
Compendium Curator
Well, not sure how I did that, but it is now fixed. Had some improperly formatted values and formulas.