Spell duration tracker macro?

so long story short one of my groups has far to many casters. the DM is having trouble keeping track of duration for each spell, the players are really bad at it and forget then just guess. Im kind of the guy everyone turns to for macros and things in the group. So the DM has asked me if there is was to keep track of spell durations via some sort of macro. Well i didnt have much luck looking around but i did find a way to do it in the initiative tracker where you add a +1 or -1 and just create a "turn" for it in the tracker and let it count up or down till the spell is gone. well we tried that and ended up between our large group and many spells cast an initiative tracker that that was almost 30 spells/players/monsters long and just became a hassle to click through for the DM So is there a way to make a separate window that that we can add spells and their duration to that will count down every turn? Im pretty good with macro but my API knowledge and access to is extremely limited.

The initiative tracker method you've found is the only way to do this unless the game's creator has a Pro saubscription. Macros can only read information from character sheets, they cant modify values in any wya. What you could do is create a separate character for this purpose, and track it's 'initiative' .

For sanity / playability ... why not just ignore spell durations for combat? Unless the combat is super long, they are unlikely to be that relevant. This is assuming DnD of course. Another thing you might consider is using the coloured token markers. Each marker can have a number from 1-9 on it (you just press the number) so that would let each token track quite a few spells of their own and declutter the turn tracker. You would of course only be able to track upto 9 rounds worth and you'd have to have players remember / write down what each colour represents in turns of spells:

If your group ends up wanting to go the API Route (Pro Subscription for the Game Creator is required), then it's very possible to use a macro to run an API command that adds an custom turn to the Turn Tracker, and it could look like this: !act ?{Countdown Number|-1} ?{Number of Turns|10} --?{Caster|@{selected|token_name}}: "?{Effect Name|BlessSleepEtc}" ?{Concentration?||Yes,«🇨» |No, |} /w GM [?{Caster}: "?{Effect Name}" ?{Concentration?} added to turn tracker for ?{Number of Turns} turns](#" style="background: none; background-color: transparent; border: none; padding: 0px 7px; text-decoration: none; display: inline-block; outline: 2px dashed purple;) I also have a script that prompts me to add a status marker to the character whenever I add the «🇨» for concentration to the Turn Tracker, and this will automatically count down by 1 each round.