rivantmedia / google-workspace-automation

MIT License
0 stars 0 forks source link

Add more verbose errors & multiple error emails #16

Closed paraswtf closed 1 month ago

paraswtf commented 1 month ago

1. The error email should contain the cell that might have caused the error.

For example: Employee Email Error Cell
roshan@rivant.in taskData[j][assignedOnIndex].toLocaleDateString is not a function H2
tanisha@rivant.in taskData[j][assignedOnIndex].toLocaleDateString is not a function H3
altamash@rivant.in taskData[j][assignedOnIndex].toLocaleDateString is not a function H5
deepanshu@rivant.in taskData[j][assignedOnIndex].toLocaleDateString is not a function H7

The cell column is a clickable link. Instead of

Screenshot 2024-08-06 at 10 25 51 AM

2. Multiple error notification emails

For, e.g. Project Manager & IT are notified about tasks not being sent. The project manager can try to fix the format; IT can fix any bugs.

3. The table in the mail isn't properly formatted. It is difficult to read.

This can be fixed by adding borders and left alignment along with some background colour for the heading. Refer to below format.

Screenshot 2024-08-06 at 10 43 11 AM

References

For clickable links to cell

paraswtf commented 1 month ago

resolved in #17