Payment reminder email going to wrong person

[Haliboot]

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.

[random-parts]

My first thought is the extra "(keeper)" for Sean may be the issue. Add a "-" between the last name and (keeper). Seems like that should not be an issue - However, the script uses the space between the first and last name to split them into an array for iterating over. It may be adding an extra array element throwing off index & count for the retrieving the proper email cell location.

[random-parts]

After re-reading the above thought/comment, that makes no logical sense at all why that would break it - I still think that is causing the problem - only because I vaguely remember being uncomfortable with how I was implementing a process - and convinced myself that no one would add 3 names to that cell.

+1 lessons in getting it done over getting it right

[Haliboot]

I removed the "(keeper)" from the name, but the same thing happens. Next, I'll try re-ordering the rows and see what happens

[random-parts]

The NamedRanges appear to be off - were there rows that were deleted on that sheet? It would cause inconsistencies in cell references. Will have to add a way to prevent those changes - cell reference errors seem to be the most common cause of problems

[Haliboot]

I didn't know deleting rows could cause a problem, so it is likely I did that. What is the best way to fix the sheet?

On Wed, Feb 14, 2018 at 9:51 AM, random-parts notifications@github.com wrote:

The NamedRanges appear to be off - were there rows that were deleted on that sheet? It would cause inconsistencies in cell references. Will have to add a way to prevent those changes - cell reference errors seem to be the most common cause of problems

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/random-parts/Team-Sports-RSVP/issues/37#issuecomment-365650052, or mute the thread https://github.com/notifications/unsubscribe-auth/Ad18T7tOJqAuI-0O1V2cwO8j1ipH5W5kks5tUwEEgaJpZM4R_CLd .

[random-parts]

Not sure; I would probably make a new sheet and copy over replies

[random-parts]

Deleting rows throw the ranges off

Google sheets had some bugs with handling ranges consistently. possible work around:

• adding a row deletion confirmation msg
• shore up ranges throughout the script