Pathfinder Skill drop down query

Some time ago someone posted a really long query that provided a drop down list for all the pathfinder skills to roll from. Does anyone have such a query they are able to share since I am not so good with the long queries?

That's close I think. But it was limited to just doing a skill drop down menu. Either that one is broken or it just isn't made for drop down.

Did you remove the spaces between the &'s and the #'s before trying the macro?

I found it, and since I hate when people say they fixed their problem and don't say how for future people with the same problem.

Chris b. created I think, this is a link to it that he posted somewhere.
https://gist.github.com/plutosdad/529753fd46fae334c8f5671aa9951d94

Ok, new problem. When I paste this into a macro box and test it, it works fine. But after saving it it breaks and the drop down won't go past disable device.

Hey Jake,
If you are saving this as a global macro (under the settings tab) html entities entered into the global macros are replaced with their symbols (e.g. pipes, commas, or end brackets) when you open the macro back up. This does not happen if you enter html entities into abilities (character specific macros). I would guess that this is your problem.
EDIT: As for why it happens, Silvyre or someone else with more roll20 knowledge will need to answer that.

EDIT2:I know it's not a dropdown query, but as a pro subscriber, take a look at the skill book creator API in the one-click install.

I've never heard a reason as to why, it just is, but it's the reason that I have a character named Macros.

For compare/contrast purposes, you can also check out the grouped version found near the bottom of The Macros - Pathfinder Examples wiki article.  It does the same thing (rolling and displaying 0 for any untrained skills that need ranks to use), but groups them by category so you have a much shorter drop-down list.

As others have pointed out, you need to create these as ABILITIES on character journals.  The Macro button system doesn't retain HTML entity replacements.  You can set it as a Macro but you can never edit it again without breaking it.

So the macro from the link works fine. But the test macro button doesn't work. But once I close the macro and run it from a token action button it works perfectly.

If you mean the Wiki example; you should be able to copy/paste it exactly as-is, straight into a given character's Journal as an Ability, under the Attributes and Abilities tab.  You can then use the checkboxes under that entry to show it on your Macro Bar, As a Token Action anytime you click the token, or Both.

it stops at disable device in the test because the link escapes the }} at the end of disable device, but once you paste it in it gets un-escaped.  Once it's un-escaped the }} terminates the query .
So it only runs correctly from the macro bar, not from the test button.

The difference between that macro and the one in the wiki is the one in my gist forces the roll to 0 if the user has no ranks. (but it is old and it does not take into account the "requires ranks" column in the PF sheet since that was added later). We plan to add a all-skills macro to the sheet hopefully someday.

My example in the wiki does provide for the roll 0 if untrained, actually.  There's two versions listed; you might just be looking at the first one. The "Skill Checks(Alternate)" is the one to look at.  It doesn't check for the required checkbox, but just considers what skills in then Pathfinder system can only be used trained.  Tomato / Tomahto, really.  If it does what it needs to do, then it's a good macro :)

The macro Silvyre linked to should work. I made it for the sole purpose of it using drop-downs. If you have any issues with it, feel free to let me know what's not working about it and I'll try my best to fix the issue.

Edit: The way I wrote the macro is for it to change the macro text of a sheet. So if you want to use the macro, you'd have the change the macro text of what you're wanting it to use inside the character sheet. I'm thinking I might update it so that it functions on it's own and doesn't affect the character sheet. But as of now, I don't quite have the time (due to getting into a new job and having to focus on getting into the groove of it) to be able to do that. I'll get back to it when I can.

If you could provide a fully working macro that doesn't need editing on my part, I would be most appreciated. I'm having trouble getting your "Query Macro" to work due to my inability to follow all the replacements needed. I removed all the spaces between & and # but it still won't work. Like a pastebin link would be amazing.

Copy/Paste exactly as-is.
This is the grouped skills drop-down query that shows "0" for untrained rank skills.
"Skill Checks(Alternate)" - https://wiki.roll20.net/Macros_-_Pathfinder_Exampl...  "


&{template:pf_attack} {{name=?{Skill Grouping
| Athletics, @{selected|token_name} Athletics Check}} {{[[1d20 + @{ACROBATICS} ]] Jump=Acro [[1d20 + @{ACROBATICS} ]] }} {{[[1d20 + @{CLIMB} ]] Climb=Swim [[1d20 + @{SWIM} ]]}} {{[[ 1d20 + @{RIDE} ]] Ride=Fly [[1d20 + @{FLY}]]
| Conversation/Interaction, @{selected|token_name} Conversations}} {{[[1d20cs0cf0 + @{INTIMIDATE} ]] Intim=Diplo [[1d20cs0cf0 + @{DIPLOMACY} ]]}} {{[[1d20cs0cf0 + @{SENSE-MOTIVE} ]] Sense=Bluff [[1d20cs0cf0 + @{BLUFF} ]]}} {{ [[ (1d20cs0cf0+@{handle-animal}) * ceil(@{handle-animal-ranks}/100)]] Handle Animal = Performance[[1d20cs0cf0 + @{perform}]]
| Knowledge, @{selected|token_name} Knowledges}} {{[[(1d20 + @{Knowledge-Arcana}) * ceil(@{Knowledge-Arcana-ranks}/100) ]]Arcana=Nature[[(1d20 + @{Knowledge-Nature}) * ceil(@{Knowledge-Nature-ranks}/100) ]] }} {{[[(1d20 + @{Knowledge-Planes}) * ceil(@{Knowledge-Planes-ranks}/100) ]]Planes=Religion[[(1d20 + @{Knowledge-Religion}) * ceil(@{Knowledge-Religion-ranks}/100) ]]}} {{[[(1d20 + @{Knowledge-dungeoneering}) * ceil(@{Knowledge-dungeoneering-ranks}/100) ]]Dungeon=Geography[[(1d20 + @{Knowledge-Geography}) * ceil(@{Knowledge-Geography-ranks}/100) ]]}} {{[[1d20 + @{Appraise}]]Appraise=Engineer[[(1d20 + @{Knowledge-Engineering}) * ceil(@{Knowledge-engineering-ranks}/100) ]]}} {{[[(1d20 + @{Knowledge-History}) * ceil(@{Knowledge-History-ranks}/100) ]]History=Linguistics[[(1d20 + @{Linguistics}) * ceil(@{Linguistics-ranks}/100) ]]}} {{[[(1d20 + @{Knowledge-Local}) * ceil(@{Knowledge-local-ranks}/100) ]]Local=Nobility[[(1d20 + @{Knowledge-Nobility}) * ceil(@{Knowledge-Nobility-ranks}/100) ]]}} {{[[1d20cs0cf0+@{Heal}]] Heal = Craft[[1d20cf0cs0+@{craft}]]
| Senses, @{selected|token_name} Senses}} {{ [[1d20cs0cf0 + @{PERCEPTION} ]]Perception = Survival[[1d20cs0cf0+@{Survival}]] }} {{ [[ (1d20cs0cf0+@{spellcraft}) * ceil(@{spellcraft-ranks}/100) ]]SpellCraft =
| Skullduggery, @{selected|token_name} Skullduggery}} {{[[1d20cs0cf0 + @{Stealth} ]] Stealth= Disguise [[1d20cs0cf0 + @{Disguise} ]]}} {{ [[1d20cs0cf0 + @{Escape-Artist}]] Escape = Disable [[(1d20cs0cf0 + @{disable-device}) * ceil(@{disable-device-ranks}/100) ]]}} {{[[ (1d20cs0cf0 + @{sleight-of-hand}) * ceil(@{sleight-of-hand-ranks}/100) ]]Sleight=
| UMD, @{selected|token_name} UMD Check: [[ (1d20 + @{Use-Magic-Device}) * ceil(@{Use-Magic-Device-Ranks}/100) ]] }} {{25 =Activate Blindly}}{{25 + Sp Lvl=Decipher Scroll}}{{20 + caster level=Use Scroll}}{{20=Use wand / Emulate class}}{{25=Emulate Race}}{{30=Emulate Align
} }}

This one only works on the character sheet right?

Correct.