Hello! I have spent far too long looking through all of the report options on Scoutbook and have come begging for help.
I currently export the Recognition Report for our troop scout tracker, but it is missing information for scouts that have transferred into the troop or badges earned before the scout was fully integrated in with our troop’s Scoutbook.
I found that I can run a custom report via the Report Builder to capture all of the missing data. Plus, I like that it has the additional information like DOB in the export. However, I would really like it if we could adjust the formatting of the display. Think Tabular Pivot table with the Scout name and badge in the rows and the values of the badge earned in the measures.
Basically, I REALLY want the Report Builder data in the format of the Recognition Report.
I can use PowerQuery to transform the data in Excel, but the troop uses Google Sheets which doesn’t have PowerQuery.
Like I said, Ive spent too much time trying to make a round peg fit in a square hole. So, im hoping someone can help. Thanks!!
