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

Macros, how to put a question inside a question...inside a question.

I hope the title is self explanatory, but here I go anyway. <a href="https://dev.w3.org/html5/html-author/charref" rel="nofollow">https://dev.w3.org/html5/html-author/charref</a> I'm already familiar with the HTML conversion to put a question inside a question, and years back on a hard drive that fried I had saved a macro that had gone I believe like 7 questions deep, but for the life of me I can't remember HOW I got there. For a character I'm using now I've developed a need to have one ?{ need my input for primary designation, another ?{ for the secondary designation &amp; then finally a third ?{. I would include examples, but I'm rarely on the forums &amp; unsure of how to include the &amp;# code so it doesn't automatically convert. gonna make a test example below by just adding occasional spaces. I know the basics of ?{Question|A,?{Question A&amp;# 124;A&amp;# 44;Output 1&amp;# 124; B&amp;# 44; Output 2&amp;# 125;|B,?{Question B&amp;# 124;C&amp;# 44;Output 3&amp;# 124; D&amp;# 44; Output 4&amp;# 125;} Getting to a third layer is eluding me. I apologize if I'm over explaining, but I'd rather give more than needed up front &amp; thereby reduce necessary Q&amp;A
1590416107
keithcurtis
Forum Champion
Marketplace Creator
API Scripter
You might have luck with the&nbsp; Drop Down Nester &nbsp;spreadsheet tool by Scott C.
From what I read that's API script which is locked behind a paywall broke people like me can't break through.
1590416523
GiGs
Pro
Sheet Author
API Scripter
No, that spreadsheet is for everyone, you dont need to be a Pro to use it. It just helps you build macros that use nested queries like the one you're building.
1590418080
keithcurtis
Forum Champion
Marketplace Creator
API Scripter
It's also a Google sheet, so you don't even need to purchase Excel.
1590485213

Edited 1591169795
Ziechael
Forum Champion
Sheet Author
API Scripter
Long story short, for each additional layer of querying you need to escape the &amp;: ?{Question 1| &nbsp; &nbsp; ?{Question 2&amp;#124; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; ?{Question 3&amp;amp;#124; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; ?{Question 4&amp;amp;amp;#124; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; ?{Question 5&amp;amp;amp;amp;#124; and so on... obviously that increased nesting of html applies to each html replacement for that 'layer'
Thank you