I’m not even sure this is possible, but I thought I’d ask before I pull any more hair out.
I’ve created a game that uses an mqtt database as a server and after a game it would be snazzy to be able to process the various data into a summary email showing which team was fastest at each challenge/etc.
The structure of the game is all hung under a dynamically created gameID and each player is populating assorted topics. For example:
In this case the gameID is “DC-Z” and under that is a topic hierachy of players with “name, status, time, x and y” topics underneath.
From what I can figure out with streamsheets, It would be super easy to work with team 1/2/3… if there was only one game. But since the entire heirarchy is hanging under a topic that will have the day’s date as well as a personal code to the players, is there any way at all to process that? Like, ideally every game would be a new streamsheet?.. (or it would process the game, export some outcome to an email/csv, then move on to next game?)
Any thoughts/ideas about how this might be done are appreciated.