I have to read up on that part, I honestly have no idea what it is lol. Do you have the same situation where you have email for some folks and text for others, or do you send both email and text to everyone?
Resource InviteTracker (19 Viewers)
- Thread starter Al Azouri
- Start date
I have a few (< 5) that are text only. Google Script has a bug that only loops for 6 minutes, so I have to break my list into 30's (I've found that 30 is the max emails it will send before it fails). I have many players that I send both email and text to, and most are email only. Using Twilio, I don't need to know the cell provider, and it will just skip them if they are blank when using the "both" option.
Sounds like I need to look further into Twilio, that's the functionality I'm looking for, thanks boss.
OP
OP
Al Azouri
3 of a Kind
ok I made a code change that now more gracefully handles blank email addresses. You’ll need to get a fresh copy of the sheet and set it up again.
This unfortunately didn't fix it (still got the error), and it also looks to have broken something else, as the MsgSend only sends the first message in the guest list and then stops.
FYI I was able to use the List A/B solution on the previous sheet as a workaround, so really not a big deal. Considering this has been in use for years and no else has asked about it, it doesn't sound important - revert back to the previous sheet
OP
OP
Al Azouri
3 of a Kind
Ok. So I updated the code in the demo version I have posted. It now handles blank entries. Give it a try-you’ll have to go through the setup steps again. Sorry
OP
OP
Al Azouri
3 of a Kind
Disregard that. Our messages crossed. I’ll give it another look tomorrow.
OP
OP
Al Azouri
3 of a Kind
Except now that you brought it up I feel the need to fix it. LolThis unfortunately didn't fix it (still got the error), and it also looks to have broken something else, as the MsgSend only sends the first message in the guest list and then stops.
FYI I was able to use the List A/B solution on the previous sheet as a workaround, so really not a big deal. Considering this has been in use for years and no else has asked about it, it doesn't sound important - revert back to the previous sheet
I really wish I liked coding and scripting. This could be such a fun project.
I also wish I had free time to learn
I also wish I had free time to learn
Lol, sorry, I was really hesitant to post because I didn't want to trigger that, I was hoping I was just doing something wrong. Seriously, not a big deal at all, I'm using it right now for a game next weekend and used the A/B/C lists to send out groups to email via text, and that appears to be working. This is already an improvement over evite
Ditto. I used to do a bunch of VBA for excel in my younger days, I love juicing up spreadsheets. Zero time for that these days, adulting and such.
OP
OP
Al Azouri
3 of a Kind
No worries. I think I fixed it now in case you get tired of using the work around.Lol, sorry, I was really hesitant to post because I didn't want to trigger that, I was hoping I was just doing something wrong. Seriously, not a big deal at all, I'm using it right now for a game next weekend and used the A/B/C lists to send out groups to email via text, and that appears to be working. This is already an improvement over evite
Ditto. I used to do a bunch of VBA for excel in my younger days, I love juicing up spreadsheets. Zero time for that these days, adulting and such.
A couple of curiosities...
1. I've deleted guest rows in the past which seemed to result in emails being sent to an "empty" address.
E.g. sending to ( ). I'm not bumping up against any guest limitations, so I've just been marking them as inactive
2. I occassionaly get time out messages (see below) from doTimedSend events even though I have doTimedSend events disabled. I just ignore them,
but thought you might be interested to know. It appears doTimedSend is being triggered every hour, on the hour
Overall the app fits my needs very well. Thanks for creating it.
1. I've deleted guest rows in the past which seemed to result in emails being sent to an "empty" address.
E.g. sending to ( ). I'm not bumping up against any guest limitations, so I've just been marking them as inactive
2. I occassionaly get time out messages (see below) from doTimedSend events even though I have doTimedSend events disabled. I just ignore them,
but thought you might be interested to know. It appears doTimedSend is being triggered every hour, on the hour
Overall the app fits my needs very well. Thanks for creating it.
Last edited:
This is a google docs error, as scripts have a 6 minute execution time. I've read that instead of loading each row individually and processing them (sending the emails), you can load them all into an array, and the processing time will be cut down to seconds instead of minutes. I've found that if sending invites to a larger group, 30-32 emails is about all it can get through in the 6-minute time frame. I've broken my list into the A/B/C group to get through that 6-minute timing; however, I've almost outgrown the app, as all 3 lists are getting to be about 30 people each.
I'm not having an issue with the 6-minute time limit as I have also broken my guests into groups.
Rather, it seems that the app gets confused about how many guests are in the list when I delete a row and it tries to send to an "empty" email.
doTimedSend is mystery, but not a real issue (at least so far)
Rather, it seems that the app gets confused about how many guests are in the list when I delete a row and it tries to send to an "empty" email.
doTimedSend is mystery, but not a real issue (at least so far)
Create an account or login to comment
You must be a member in order to leave a comment
Create account
Create an account and join our community. It's easy!
Log in
Already have an account? Log in here.
Similar threads
