Resource InviteTracker (31 Viewers)

[krafticus]

One way around it is to use the Siri Shortcut on an iPhone because that takes the processing of the messages out of the Google Script and on to the iPhone.

The other way is to try and optimize the code t be more efficient about how it runs so t that more emails can be sent within the 6 minute window. I've already done some work in that area in v4.0 but I don't know what that will translate to in terms of how many emails you can push through in the 6 minute window. Google Script is just very slow anytime you ask it to access a range in a sheet. I've already tried to consolidate those lookups to as few as possible.

Out of curiosity, how many emails are you looking to send?

I send 88 emails per month, and I find that I can get 29-31 emails out in that 6 min window. With only an A/B/C list, I can only add 2 more players before I have to start sending 1-off emails

 

[Kid_Eastwood]

I need to take the time to give this a try. I'm so frustrated with my current method of scheduling. I tried setting up a FB private group, but some aren't on FB, and half my people that are won't respond until I text them personally. Are those of you who use this finding that it really improves getting a response from your players?

I'm in the same scenario as you with not everybody having Messenger.

Big issue is that most persons receive these email in their spam folder.

So it's difficult to have everyone in a clean state when once it's done, this tool is very intuitive to use.

 

[Al Azouri]

Il use list A, list B, list C for smaller subsets. Ans sending in several batches. Avoiding this error

Man, that's gotta be so annoying. How many total emails are you trying the squeeze through that 6 minute window?

 

[Al Azouri]

I send 88 emails per month, and I find that I can get 29-31 emails out in that 6 min window. With only an A/B/C list, I can only add 2 more players before I have to start sending 1-off emails

I could very easily add a D/E/F list for you. But that would just be a band aid.

 

[krafticus]

I could very easily add a D/E/F list for you. But that would just be a band aid.

That would be very helpful actually

 

[Al Azouri]

I'm in the same scenario as you with not everybody having Messenger.

Big issue is that most persons receive these email in their spam folder.

So it's difficult to have everyone in a clean state when once it's done, this tool is very intuitive to use.

If anyone out there knows how to develop code for Android I'd be happy to work with them to port my Sire Shortcut over to Android.

 

[Al Azouri]

That would be very helpful actually

I'll add it to v4.0 and you can also do it yourself by clicking on the edit button at the bottom of the Dropdown in those fields (In the Guests tab and the MsgSend tabs)

 

[AutoDonk5000]

Humm…
maybe have the option to add a logo somewhere
In the dashboard and/or email template ?

That would be cool!

 

[Phoe9x]

When’s the estimated release? And is it possible to port over metrics from my existing sheet?

Thanks so much for your project, it’s been so helpful!

 

[AutoDonk5000]

Where on the page would you like to see that text?

Right here would be great. You see how I've used dashes to kind of get the details in as it's currently set up. I can't get a line break to work here. To have multiple lines at maybe a smaller font size for details would be cool!

 

[divinerites]

Man, that's gotta be so annoying. How many total emails are you trying the squeeze through that 6 minute window?

no that is fine. From memory around 20 in each list

 

[krafticus]

I'll add it to v4.0 and you can also do it yourself by clicking on the edit button at the bottom of the Dropdown in those fields (In the Guests tab and the MsgSend tabs)

View attachment 1463197

Cool. I didn’t know I could do that. Done

 

[Al Azouri]

Cool. I didn’t know I could do that. Done

Me either until you asked

 

[Al Azouri]

Right here would be great. You see how I've used dashes to kind of get the details in as it's currently set up. I can't get a line break to work here. To have multiple lines at maybe a smaller font size for details would be cool!

I like this idea. Let me see what I can do to squeeze it into this version.
I'm thinking of a field in the Manage Tab where you could add your message and it would show in that section of the Dashboard.

 

[Al Azouri]

Al Azouri updated InviteTracker with a new update entry:

Version 4.0 BETA Released

Hi All,
I just posted a BETA of version 4.0.

New in this version:

1. Added More options to Siri Shortcut
2. Fixed Last Comment logic
3. Improved support for Siri Shortcut
4. Added color options for Dashboard Statuses
5. Converted most tabs to Sheets Tables
6. Cleaned up Guest tab and Status tabs to eliminate most hidden columns
7. Adding rows to Guests and Statuses can now be done natively in the sheet
8. Added capability of adding an event description to the Dashboard
9. Added...

Read the rest of this update entry...

 

[Al Azouri]

FYI: Working on adding the capability of adding a logo to the web based dashboard.

 

[Al Azouri]

Just posted v4.0a which now gives the ability to add a logo on the web page.

 

[djfayze]

New update looks great! Seriously, this thing has been such a help over the past couple of years.

One thing I’ve never gotten to work with my iOS shortcut (with any version) is sending email - if I set the form to send “both” text and email I always get the following error:

If I set the option on the form to text messages only the shortcut works fine. Otherwise this is working excellent!

 

[Al Azouri]

Al Azouri updated InviteTracker with a new update entry:

Version 4.0b BETA Released

Just some fixes to issues identified in Beta testing

Read the rest of this update entry...

 

[Al Azouri]

New update looks great! Seriously, this thing has been such a help over the past couple of years.

One thing I’ve never gotten to work with my iOS shortcut (with any version) is sending email - if I set the form to send “both” text and email I always get the following error:

View attachment 1464681

If I set the option on the form to text messages only the shortcut works fine. Otherwise this is working excellent!

What about if you set it to email only?
I may have inadvertently fixed it in the 4.0b BETA as I addressed an issue with blank emails that caused the whole thing to fail.

If it's still broken, PM me your web app URL and create a test account for me (or give me the name of a guest I can use for testing) and I'll troubleshoot.