random-parts / team-sports-rsvp Goto Github PK
View Code? Open in Web Editor NEWGoogle Sheets add-on for ezleagues.ezfacility.com team schedules
License: Apache License 2.0
Google Sheets add-on for ezleagues.ezfacility.com team schedules
License: Apache License 2.0
Happens after the year change with previous games scheduled for the previous year (ie games in December when it is now January)
Walking Dead had a 11:45 game added this Friday. We already had an 9:30pm game with responses filled in. Although it was on the web, no amount of run-schedule-update, relink-schedule, reinstall-team-form, or reinstall-triggers would make the sheet pick up the 11:45 game (or change at all). So, I created a new season and copied the responses for the 9:30 game. This had the 11:45 game, but the email it sent for that game was for 12:00am and clicking the reply didn't update the sheet.
When creating a new season sheet, in the middle of a season that spans a New Year - while currently in the New Year - the previous games will have the incorrect year. This will cause incorrect emails and game highlighting as the script moves sequentially through the column index on current or future dates.
Example:
games in December will have the same year as games in January
Current solution:
Manually change the year or Wait for a new season to start
TypeError: Cannot call method "toString" of undefined.
On New season Roster copy, only the values should be moved. Currently copying over formats, causing the new season sheets conditional formatting to be confused.
Games listed for the new year use the year(date) from the day the game was listed.
Example:
schedule_set_today = 01-dec-2017
game 1 | game 2 |
---|---|
26-dec-2017 | 03-jan-2017 |
Games set for Jan 1st or later will not receive automated emails until the actual date(today) is in the new year and the schedule is updated.
Cancelled game header format is being overwritten by the field/venue format
Empty roster rows mixed in with filled rows cause email error.
Shows a "busy-sending-email" indicator for quite a while, but then gives
Exception: Invalid email: Email
The intermediate bees paid column looks like this:
5 James Grey Balance -69, 4-21
6 Vimal Fernandez Credit 4-21
7 Brandon Treece google wallet 1-28-18
8 James Delaney
9 Sean Collier (keeper) paypal 1-25-16
10 Francesca Ramadori zelle 11-4-17
11 Ann Rich Credit 4-21
12 Eileen Bucayan check 0069643686
13 Jessica Tupa paypal 1-26-18
14 Mae Adams
James and Mae have not paid. However, Sean gets a reminder instead of James and Mae doesn't get one at all.
The feature I need most is one that harasses people until their payment field is not empty. :)
Will it send email for all relevant games, or will the soonest game "hide" the other games? I haven't tested this, but it seemed like a case that could easily be overlooked, so I thought I'd ask.
Create a link to add games to Google calendars from the reminder emails
Probably depends on whether you are the away or home team. Example:
"James, will you attend the Dyslexia game? Monday, September 11 9:30 PM vs. Dislexia Untied"
(I thought I had already made an issue for this, but I don't see it. Sorry if it is a dupe)
The schedule here had a game added for the 21st. But when I update the schedule or even reset the web link, the schedule still starts on the 28th
https://soccerzone-lakeline.ezleagues.ezfacility.com/teams/2129720/Intermediate-Bees-.aspx
Intermediate Bees has a makeup game this Saturday at 10pm, but it isn't on the schedule yet.
Because of the other problems with this sheet, I created a new season. I then manually inserted the game:
Makeup Game Raising Cane's Field
"Saturday
Feb 24"
10:00 PM
Third Bounce
Unfortunately, when I sent the emails, the emails said that the game was at 12:00am.
(this seems a little familiar, sorry if it is a dup)
I tried to install it on Chrome. I searched add-ons for RSVP, but got no results.
Send payment due emails out weekly to team members
single season win %
accumulative win %
season and accumulative Win/Lose/Tie record & win % vs individual teams
[ create the above stats for individual team members - base on rsvp reply to game (?) ]
chart/graph it
Here is another feature idea: if a schedule change is detected, either:
a) Easy: send a message to everybody that the schedule has changed and they need to double check their responses.
b) Medium : Same as (a), except include in the email which un-played games have changed. It would say something like "The schedule has changed for the game that was previously scheduled for 8/18/17 at 11:45pm. Please update your status now"
c) Medium: Same as (b) except email prompt to reconfirm games instead of a single message. If the next game changed, prompt everyone to reconfirm their response. For later games, only prompt people who had already marked responses.
d) Harder: Same as (c), but also try to match up old and new games so the prompt messages can state the changes. This might be easy if you only match games that changed times but are still on the same day. Maybe you are doing this already, because it didn't seem to lose the responses for the old game time? Perhaps it could append "(previous game time)" to any current responses for changed games, so it is visible whether someone has responded to the latest time.
Walking Dead had a game at 8:45, to which all the replies were filled in. Soccerzone called and said we had a bonus game at 7:15. I copied and pasted the 8:45 game column to the left and changed the time and opponent to reflect the new game and cleared the replies. I then had it send the reminders, hoping people would get the email about the 7:15 game, but instead it sent two new emails both referencing the 8:45 game time. I asked Doug to respond to them and they filled in the 7:15 column, so it seemed that the emails linked to the right game time in the sheet but has the wrong game time displayed to the recipient.
I cleared the responses, changed the game time, and then ran the send email task.
It seemed to noticed that I cleared the responses, because I personally got the email, but the email had the old game time that was no longer in the sheet.
Last Friday's walking dead game was cancelled. The remaining games moved one space to left in the column headings, but the responses were not changed, so that responses to deleted game are now under the heading for the next game, ... and every column after that is similarly off by one
At some point, maybe when there are four weeks or less before the last game?, it would be extremely useful if the system started to send periodic emails to people who haven't yet specified it, prompting for a Yes or No as to whether the player is returning next season, the reply to which would be placed in column C.
TypeError: Cannot read property "0" from undefined
at updateSchedule(ScheduleService:149)
at onDailyTrigger(Code:117)
e0d5cf2 Does not allow the menu option to send emails unless it is a scheduled email day. Manually running the email task should bypass this and send emails for the next gameday
I'm about to move my ninth team on to RSVP. The regular pile of emails telling me that "No Emails have been sent" is starting to get overwhelming.
Until there are configuration options to provide preferences, I would suggest that no summary email be sent to the team captain when no emails are sent out. If I need that info, I can infer it by the absence of the summary.
Store TeamName in the document properties by the spelling based on the web schedule - to prevent script breakage on accidental changes to TeamName cell
or add TeamName value change alert()
I had a couple of teams that only had a couple of games on the schedule. When soccerzone added two more games to each schedule, they appeared, but the dates of the old two games were updated to also be the same as the dates of the new two games. Since the old games were first, it thought the first old game was the next game, and since it already had the old responses, did not send any reminders.
I tried pasting the correct game header information into both sheets. In one it seems to be working now. In the other, it screwed it up so bad I had to delete it and recreate it from scratch because no matter what I did, it generated errors.
FYI: On one of my teams, I had put "lewis (keeper)" on row 19 under the column for Game 5. When it sent the email for game 6, it asked "will you be attending the lewis (keeper) game?". Rows 17 and 18 were blank.
I noticed that for some reason, unlike other sheets, I had a blank row 5. I deleted it now, so I'll see if anything else funny happens or not.
fix:
I just created Gunners season 25. It copied the values in the Next and Paid columns from season 24 even though they don't apply to season 25.
near the end of a season, send emails to team members that have not marked on the sheet if they are returning for a new season
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.