- Add a simple checkbox on adult profiles that reads “Available for Boards of Review?”
- Add a corresponding report to populate all adults with this checkbox selected on their profile OR just add this “Available for BoR” parameter to be an option on the Adult Leadership report.
Purpose: when trying to schedule a Board of Review, there is a lot of confusion about which adults–unit leaders, volunteers or parents–who are available to be contacted to help sit on the Board of Review needed for a scout’s advancement.
Having a parameter where a user with unit-level permissions can select AND a corresponding report would allow leaders to know the pool they can draw from, making scheduling these Boards of Reviews much easier. This also prevents the same few people being asked every time, preventing burnout.
I had to pull the entire membership report, remove more than half the columns, and then go through each user to determine on my own if they were available, eligible or interested in helping with the Boards. Much more time-consuming than it should have been.
All it would require is adding another column in the user table in the database and then having it editable through the Profile page for each user (set to TRUE/FALSE), and then reference it as a report parameter for the CSV export.