So I’ve made some changes…
-
Script added to remove all clients marked “Done”, “Done “, “done”, “done ” or where the status is unmarked (blank).
All you need to do is click the red “click me” button image on the sheet, sorry this wasn’t added before Elements.
-
Added a new columns “Product Purchased” and “Date Supported”
This was mainly added because as you can see if you go to the sheet now there are a ton of “progress” clients. With these new columns, we can see when they were supported and what product they bought. So at the end of every month when Elements or whoever is in charge of keep track of this info hits that button, we can send a message to the clients like: “Hello [insert name here], according to our records your [insert product here] has not been fully activated yet. Please send an active admin your Mod ID to complete the activation. (just as an example) date format can be mm/dd (01/23) or mmm dd (Jan 23).
Any thoughts to these changes??