Pathfinder 1e Community Sheet: Popup coding for "Overcome SR"

I need to be able to add a value to my "Overcome SR" roll in any spell macro I click. I wrote a macro to prompt me when I click a spell macro: ?{Dweomer Nethys ginger Piercing:|0} I put this in the " Spells Notes " field just under the "Concentration Check" button on the "Spells" tab so that it creates a popup when I click any spell. This much works as expected. I copy-pasted that same macro into the " Spell Pen Bonus " field in the "Roll Adjustments" box to the right above it, but the value I enter in that popup never appears in the "Overcome SR" roll in any spell macro I click. If I add a macro like this in multiple places in an attack macro, it creates one popup, replacing the value I enter at all instances of the macro.  Here, it prompts me, but never adds the value to the "Overcome SR" roll in the spell macro . Leaving the macro in the   " Spell Pen Bonus " field and removing it from the  " Spells Notes " field means when I click a spell macro, it does not generate a popup anymore. Does anyone know a way I can make the sheet prompt me for a value that will be added to the  "Overcome SR" roll in any spell macro I click?

Hi Jason, the "Spell Pen Bonus" field only allows a flat value entry or one that can be derived directly from the sheet attributes. It does not allow "roll-time" values like queries or rolls because the sheet's calculations need to calc the value before the roll is made.  Adding a query in the field will not be recognized and probably defaults to "0". Not ideal, but you could modify the macro-text "per-spell" to override the default roll (that is included within @{spell_options}) by adding  {{spellPen_chk=[[ 1d20 + @{casterlevel} + @{SP-mod} + ?{Dweomer Nethys ginger Piercing:|0} ]]}} to the end of the spell's macro.

Thanks, Vince.  I can spend some time doing it spell by spell I guess, but I wanted to see if there was something I was doing wrong or some trick I could pull.

Another idea, add your own Overcome SR roll to the Spell Notes }}{{spellPen_chk= [[ 1d20 + @{casterlevel} + @{spellclass-0-SP-mod} + ?{Dweomer Nethys ginger Piercing:|0} ]] This should override the default Overcome SR roll and would be included with any spell that displays Spell Notes. No need to edit individual spell macro-text. Adjust "@{spellclass-0-SP-mod}" as needed to match the appropriate spellclass (ie multi-casters)