Resource InviteTracker (29 Viewers)

[Irish]

It took a little bit to get it setup and working, but I love using it. It costs me about $30/year, but I have 75+ invites that go out each month.

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?

 

[krafticus]

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.

 

[Irish]

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.

 

[Al Azouri]

I've been putting off implementing this for far too long, going to give it a try this month. I think I've got it mostly setup correctly, but I have what's likely a very basic question:

• I have some folks that are fine with getting the message via email & text
• I have some folks who would prefer to get the message ONLY via email
• I have some folks who would prefer to get the message ONLY via text

I tried setting up the guest tab accordingly (ie, input some guests with only the email, others with just the cell phone #) and this doesn't appear to work, when I use the Send Type of "Both" when sending out the message via the MsgSend tab, I get a failure indicating invalid email: @ for the "blank" entries:

View attachment 1443790

Am I missing something here or is this functioning as expected? Any workarounds? I was thinking I could potentially use the A/B lists to organize guests by email/text and send out two sets of messages, one just emails and another just texts.

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.

 

[Irish]

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

 

[Al Azouri]

Hmm that’s a new one. Let me think on it. Are you on android or iPhone?

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

 

[Al Azouri]

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

Disregard that. Our messages crossed. I’ll give it another look tomorrow.

 

[Al Azouri]

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

Except now that you brought it up I feel the need to fix it. Lol