Stacking Character Sheet Macros(Abilities)

So I'm trying to create a Spell List by stacking a Character Sheet's same Macros one would ordinary macros, like in this video:
https://www.youtube.com/watch?v=8RxRODcMRRo

But it seems to be unable to recall, any Macros from said Character Sheet. I checked the wiki (https://wiki.roll20.net/Macros#Ability_Command_Buttons) but some reason the code just keeps giving an error.

Here's a screenshot of the code in question and the error report being given:

Edit: Changing it to remove the "Character_Name" portion (as the wiki said I could omit this) changes the error to:

TypeError: Cannot read properties of undefined (reading 'substring')

Edit 2: Found the solution, and posting it here incase someone else hits this wall in the future and Google leads them back to here.

Just use this in the Macro instead:

[Macro](!
%{Character|Ability})

So in the example of my code above I have it typed out as such:

&{template:default} {{name=@{Selected|Character_Name}'s Spell List}} {{Cantrips=[Spell Name](!
%{Default|SpellTemplate}) }}

I'm not going to watch that video through to see exactly what he is doing, but realize that the video you are pulling this from has some age.

I would recommend looking at the posts on the Roll20 Tricks thread having to do with Chat Menus (what he calls stacking macros) and Macro Character sheets.

Chat Menus:

https://app.roll20.net/forum/permalink/5927072/

Macro Character Sheets:

https://app.roll20.net/forum/permalink/5924364/

https://app.roll20.net/forum/permalink/7605679/

https://app.roll20.net/forum/permalink/6138238/

Wiki articles (probably mostly drawn from those posts):

https://wiki.roll20.net/Chat_Menu

https://wiki.roll20.net/Macro_Character_Sheet

What you have going above looks to me like (for your final error message) it is looking for a character sheet named "Character Name" to run the ability macro named "SpellTemplate".  Do you have a sheet with that name with the correctly named ability macro on the Attributes & Abilities tab?

I don't understand why people want to spam the chat output with whisper macros of buttons that already exist on your character sheet.  You can minimize your character sheet and pull it up when you need it OR use the mobile app to run your sheet.  Chat output is already spammy as all hell and adding even more nested chat macros is just going to gum it up even more.  Then theres the issue where if any player begins typing in chat you can miss the buttons you are trying to press.  Then if you need to scroll up to see what you rolled for stealth 3 minutes ago you scroll for days due to all the whispers.  I get what you wanna do but have you considered its practical execution?  Its kinda the whole point of the sheet to begin with.  

On the GM side, I prefer to not have sheets open at all.  I have very little reason to ever scroll back, so having menus in chat don't bother me.  It is also a way to set up spell casting (and other mechanics) for unsupported games without having to set up each individual macro on each sheet that may need it.  All you need is a chat menu that triggers the macros on a macro sheet.  I generally only have character sheets open when/if I need to know exactly what they were carrying for some reason.

Even as a player, I have taken to setting up chat menus as token actions for my characters (Pathfinder 1).  Then I don't need to have my character sheet open at all unless I need to change buffs. In a game with 4 other players, I don't have an issue hitting options on the menu even with initiative.  It is also usually faster for me to respond to the GM asking for a roll because I don't need to bring my sheet back up from being minimized and then find the button on the sheet which may be on a different tab than I was on previously.

I'm not arguing that this is a superior way to run things.  It is just a different way to run things... Though I might argue it is more convenient on the GM side of the screen, if you are set up to run all npc actions that way.

DM Eddie said:

I don't understand why people want to spam the chat output with whisper macros of buttons that already exist on your character sheet. 

Chat spam matters when you are running text based games, but it's hard to care about how spammy it is when you are primarily using voice. Then the chat just becomes a place of utility.

You make your rolls when you need them, then they are visible while you need them. You whisper buttons so they only see pollute your own chat window, and then you make your roll, and your roll appears after the chat menu.

As Kraynic said, some of us just dont like having the character sheets visible - most of the time they aren't needed. And most designs (even mine) just aren't very good for computer use - they are based on paper character sheets and take up way too much space. The chat window by contrast is off to the side, and doesnt obscure the screen much, so it's a handy place to drop utilities.

DM Eddie said:

I don't understand why people want to spam the chat output with whisper macros of buttons that already exist on your character sheet.  You can minimize your character sheet and pull it up when you need it OR use the mobile app to run your sheet.  Chat output is already spammy as all hell and adding even more nested chat macros is just going to gum it up even more.  Then theres the issue where if any player begins typing in chat you can miss the buttons you are trying to press.  Then if you need to scroll up to see what you rolled for stealth 3 minutes ago you scroll for days due to all the whispers.  I get what you wanna do but have you considered its practical execution?  Its kinda the whole point of the sheet to begin with.  

1. The customized ruleset being used doesn't work with the built-in sheets

2. The others cited good reasons for using stacked macros as well
3. Not your game to be judging