@hippysurfer
Loving this project, perfect timing as I'm trying to combine a Google App Sheet mobile deployment with automated data collection from OSM to create a new way of managing district WLs.

My plan is to adapt your approach to pull member details from waiting list sections only.
Baring in mind I don't need to preserve the functionality to the other functions (subs etc), I've been able to modify the [OSM.gs and member.gs code to include "waiting" in the list of sections presented in the dialogue and adjusted the spreadsheet output to include the fields I want.

But I'm stuck. I can't figure out how to return ONLY waiting list section types to the dialogue - and not all the other, beavers, cubs etc.

Even better - if I could do away with the dialogue all together and trigger the fetch of data, for any 'waiting' section, programmatically (and later, to a schedule) - thereby allowing automation of the report.

Suggestions to approach this welcome.

Hey, I'm looking at how to adapt your project to pull Section Size information into a sheet. It's not part of OSM many folks will see/use.

Would you take a look at the output below and suggest which of your existing .gs components would be closest to what I'd need to do to pull the "sections" elements per group? I am happy to work on it myself and share back, but I struggle to interpret the function calls necessary to navigate across the array. It's probably pretty simple - but I can't get my head round it.

Thanks in advance.

The POST is: /ext/discounts/?action=getSizes&code=221&sectionid=68972
The returned BODY (sample) is:

{
    "Portsmouth": {
        "idealsize": 1451,
        "numscouts": 1084,
        "waiting": 272,
        "byGroup": {
            "104th Portsmouth": {
                "sections": [
                    {
                        "numscouts": 15,
                        "sectionid": "30931",
                        "type": "beavers",
                        "idealsize": 50,
                        "idealleaders": "5",
                        "numleaders": "5",
                        "name": "Beavers",
                        "waiting": 3
                    },
                    { ... etc ... }
                ],
                "idealsize": 88,
                "numscouts": 45,
                "waiting": 7
            },
            "1st Portsmouth Sea Scouts": {
                "sections": [
                    {
                        "numscouts": 15,
                        "sectionid": "50569",
                        "type": "beavers",
                        "idealsize": 18,
                        "idealleaders": "4",
                        "numleaders": "2",
                        "name": "Beavers",
                        "waiting": 0
                    },
                    { ... etc ... }
                ],
                "idealsize": 63,
                "numscouts": 70,
                "waiting": 0
            },
            ... etc ...
            }
        }
    },
    "categories": [
        "Portsmouth"
    ]
}