lucioof / tourneyscripts Goto Github PK

We want different sheets for people that have missed declarations, people that pout the wrong OrderN and people that have multiple orders under same name.

At the moment this is just coded as "TODO" but will need to implement dealing with the food choices of players.

As provided in the internal Tourney Admin Flow file. I am missing this table

Create constants for these so theyre easily editable and also better to read.

We only want to clear from row 6 and down, and only want to clear the content (So not the formatting, colours etc)

Would also be good to add "Food order complete" |   |   |  
| What data would this have? |  
| A count of those who ordered food and have selected what they want |  

Some errors are only being logged and not thrown which means we don't see amazing information in the progress sheet when an error happens.. For example, when we can't find a sheet., spreadsheet, folder, etc

Idea is we have a process everything button, which we do. but also a separate button for the separate things. (Such as something like "Create Lions Feed"). This will likely ease testing and showcasing

Matt seems to want a sheet with details on clubs, mostly the count of players

At the moment we just log "status done" once we're done with the task, meaning we only log it after its finished, so we never know the current task. Its not horrible but if its taking a bit long you just dont know what is actually running

Currently we show a list with club names and how many people are signed up for in this club, also show the clubs who haven't got people yet.

One for example would be LionsFeedData in lionsFeed.js

We have different methods to fetch different data and we are calling all in "fetch all data" but when running a single task we might not need to fetch all. So we are making extra calls and storing extra values in memory that are not needed at all

Will mean we dont need to have extra sheets with raw that that we don't need in our master spreadsheet.

We have a couple procedures that are dependant on others so we cant do all async but definitely more than it is at the moment.

Some people have two orders with the same name, whilst this migjht be ok, we might need to manually check so would be nice

I have seen in a random scenario that the sheet wasnt cleared before re-filling it. Although this might not happen every time.

We should add the player count to the 4th column so we dont have to scroll to see the count. May be worth creating a formula here in case this file is then manually manipulated. Unsure on this though

Once we fix the form, the code handling will change.