DropDown Nester google sheet how to use?

Hi, I am trying to use the dropdown nester sheet to make a rather long nested macro but I just can not get it to work. I've posted regarding the macro I am trying and failing to build before but I just haven't been able to crack it. Below is what I am trying to build- /em ?{charge|yes, charges into combat with  @{target|character_name } for a ?{charge|10} bonus  with a skill of  @{Furdil Rokinson|WS}  ?{outnumbered|no, in a test of lone fighting with ?{outnum|0} modifier|2:1, joining in the fighting ?{outnum|10} bonus|3:1, piling into the fight ?{outnum|20} bonus} with {grudge|no, with ?{GBF|0} grudge born fury modifier|yes,  with ?{GBF|5} grudge born fury modifier  and other modifiers of ?{mod|0} r/ 1d100<[{ @{Furdil Rokinson|WS}+?{charge}+?{outnum}+?{GBF}+{mod}  |no , strikes at  @{target|character_name } with a skill of  @{Furdil Rokinson|WS}  ?{outnumbered|no, in a test of lone fighting with ?{outnum|0} modifier|2:1, joining in the fighting ?{outnum|10} bonus|3:1, piling into the fight ?{outnum|20} bonus} with {grudge|no, with ?{GBF|0} grudge born fury modifier|yes,  with ?{GBF|5} grudge born fury modifier in a ?{allout attack|no, normal attack with ?{all|0}|yes, all out attack with ?{all|20}  and other modifiers of ?{mod|0} r/ 1d100<[{ @{Furdil Rokinson|WS}+?{all}+?{outnum}+?{GBF}+{mod} } I just can't get it to work. Even changing to HTML it just refuses to work and prints itself. Does anyone have any ideas? Thanks for looking!

Edward C. said: I am trying to use the dropdown nester sheet You you say the exact name of the sheet you're trying to use in your game? Didn't find anything close to "nester" in the dropdown menu. Is that three separate macros you posted that you have issues with? In general with nested macros, you will need to use html replacement for some characters for things to work, you can read more about it on the wiki . I think that's the primary problem with your macro, the second problem might be that you try to split your macros on multiple lines that will break them. It's easier to read if you use the "code" styling in you post for the code segments so we can better separate them, and your linebreaks make that a bit confusing to read. Post your macros exactly as you use them and don't add any linebreaks for readability, breaking up a macro on multiple lines will break the macro and make it harder for us to help you fix it.

I'm guessing the OP is referring to the google sheet that Scott did to help with query nesting .

Damn, that spreadsheet haven't been edited in 4 years, so it's likely that it's out of date in some form. Edward C. might be better of starting from some newer thing that tried to do the same thing. Oh and once you created a macro that contains html replacement, you can't open it again, or Roll20 will convert the replacement symbols.

Andreas J. said: Edward C. said: I am trying to use the dropdown nester sheet Sorry I meant the constructor google sheets sheet, sorry! I was oncall last night and have been up since 4:30am. I'm trying to have 2 different texts for if I charge or if I don't with 2 different sets of rolls.   Not quite sure what you mean by code style, but basically within most of the nested queries there is a ?{modification| 10} with a different value to allow me to do the roll with the correct modifyers. So for example the first question is: have you charged? if so follow this route of nests.  Does that make sense?

Ziechael said: I'm guessing the OP is referring to the google sheet that Scott did to help with query nesting . Thats the one!! Is there a new version or anything of the like?

That sheet shouldnt need updating. Nothing it is used for in roll20 has changed since it was created. It's more likely you need a level of nesting beyond what the sheet is designed for. Can you post a mockup of exactly how you want the output to look in chat? If the previous solution posted didnt satisfy, I have a feeling the way you want the output will be extremely complex and need multiple nested queries, but cant be sure without that information. 

So this is what I have come up with: /em ?{Charge|no ,strikes out at @{target|character_name} with ?{modc| 0 } modifier due to no charge|yes, charges into combat with @{target|character_name} for a bonus of ?{modc| 10 }} with a weapon skill of @{Furdil Rokinson|WS} ?{outnumbers|no ,in a test of lone fighting with ?{modo| 0 } advantage|2:1, joins in the fighting with ?{modo| 10 } advantage|3:1,piles into the fighting for a ?{modo| 20 } advantage} ?{Grudge (orc hob or gob)|no ,without grudge born fury gets ?{modg| 0 } modifier|yes, with grudge born fury due to race gets ?{modg| 5 } bonus} and ?{All out|no, as it’s a normal attack gets ?{moda| 0 } benefit from the 2 nd attack|yes, attacks with all he has for a ?{moda| 20 } bonus} and a modifier of ?{mod|0}   /r 1d100<[[ @{Furdil Rokinson|WS}+?{ modc }+?{modo}+?{modg}+?{moda}+?{mod}]] Now if there's a way of hiding the value of 0's in the macro that would work great as without having a 0 in the queries the roll just askes for a number out of context from the way it works. So at the momement it asks is the modifier valid and if so gives a default number but for no it still asks for 0. Any ideas? Cheers all

As GiGs surmised,the sheet is still perfectly useful. I use it quite often when I'm finding ways to handle complicated attacks and abilities in pathfinder where I might have something like 8 different options that are not mutually exclusive and affect each other. It does have some fiddly syntax to get it to work though, which is described in the sheet (although not as well as it could be). The important thing to remember when using the sheet is that the sheet looks for spaces before curly brackets, "}", in order to determine if it should encode the bracket or not and spaces around bars, "|", to determine if it should encode the bar. What this means in practice is that attribute calls are written out as normal (e.g. @{target|character_name}), while nested rolls get written out with extra spaces in them (e.g. ?{charge|10} in your macro Edward would become ?{charge | 10 } ). If typed up that way, the nester will do the encoding for you. You can also reference the output of another parser cell to chain together parsing of complicated queries. An example of this is B5 referencing E15 in the current version of the sheet.

I think from that I can work it out thanks!! I have one more question. As you can tell it populates the text with the value rolls, then the rolls take the numbers from the values. Is there anyway of hiding those numbers to just leave the text but still contain the values?

This is the reason I asked you to show a mockup of how your roll should look when printed out. I think  I know what you want, but need to see this to confirm. What I think you want is to show the text from each query in one place, and the number from the query in another. Which can be done but needs a massively nested macro. So lets see what the printout should look like.

GiGs said: What I think you want is to show the text from each query in one place, and the number from the query in another. Which can be done but needs a massively nested macro. Yep, which is what the nester sheet is for :)

8So what I want as an example \em charges into combat with a beastman, joining the fight and with grudge born fury.  \r 1d100>[weaponskill+grudge born fury+2:1  Comabt]  I can’t think of a better way to show. Basically I’m wanting to do a story of what I do and the bonus mods and then the roll. 

Scott C. said: GiGs said: What I think you want is to show the text from each query in one place, and the number from the query in another. Which can be done but needs a massively nested macro. Yep, which is what the nester sheet is for :) Yes, my point is that the specific way Edward wants to make his output might influence the way he needs to build the macro before he tries to use the nester. I saw his other thread, and I dont think simple nesting - even at multiple levels - will achieve what he wants. i think he'll need to restructure the macro - but I cant know how that restructuring is needed (or even if I'm wrong) until we see his preferred output.

Edward C. said: 8So what I want as an example \em charges into combat with a beastman, joining the fight and with grudge born fury.  \r 1d100>[weaponskill+grudge born fury+2:1  Comabt]  I can’t think of a better way to show. Basically I’m wanting to do a story of what I do and the bonus mods and then the roll.  Look at the character who makes this roll. Write out what you want to appear in chat after the macro has completed, using that characters attribute values included how you want to show them, and use a roll of 67. For example, I might make a roll that results in this output: Albert attacks with his Sword skill of 30, and charges. roll = 67 vs score 30 +10 [charge] = failure. What would an attack from your macro look like?

Ok so this is the to hit which is on the warhammer below the rolled number system. We are doing a if it’s a success it hits. So ideally: Furdil charges into the beastman with grudge born fury joining in the fight roll 67<70 1 success. 

So here is the final one. Still not perfect but better than nothing: /em ?{Charge|no ,strikes out at @{target|character_name} ?{modc|  } |yes, charges into combat with @{target|character_name} for?{modc| +10 }} with a weapon skill of @{Furdil Rokinson|WS} ?{outnumbers|no ,in a test of lone fighting ?{modo|  } |2:1, joining in the fighting for ?{modo| +10 } advantage|3:1,piling into the fighting for ?{modo| +20 } advantage} ?{Grudge (orc hob or gob)|no ,?{modg|  } |yes, with grudge born fury giving ?{modg| +5 } for race} ?{All out|no, ?{moda|  } |yes, and  attacks with all he has for ?{moda| +20 } bonus}?{Extra mo|no, ?{modx|  } |yes, and a modifier of ?{modx| } }     /r 1d100<[[ @{Furdil Rokinson|WS}?{ modc }?{modo}?{modg}?{moda}?{modx}]]