Alert sent to specific role(s)
I want to create an alert (based on certain criteria) that gets sent to all users in a role. I do not want to specify users because every time I add/remove some from a role i have to manually update ...
Forum Discussion
>Sound like "User Voice' is your only option.
Script is your only option!
I can't provide a live demo of a script solution because you would have to be an administrator of the demo to see it work. So I will just show you a screenshot from a working application and provide sample code.
I have an application where the Administrator is dandiebolt@yahoo.com and there are two users in the Participant role: dandiebolt@gmail.com and dan.diebolt@gmail.com. In fact, the two gmail email addresswes actually are just alternate addressed to one Google email account but QuickBase thinks they are two different users. All three users in the demo are named Dan Diebolt. It can get a little confusing who's who so note the two different email domains (yahoo.com and gmail.com) and the period used to distinguish the two gmail email addresses (dandiebolt@gmail.com and dan.diebolt@gmail.com).
Now when I manually invoke the script in the pasties below I will send a custom email to each user in the participant role (dandiebolt@gmail.com and dan.diebolt@gmail.com) gently reminding them that their TPS Reports are overdue. It is a good practice to personalize your emails as it creates good rapport with your employees.
Here is what the received messages look like in my gmail client:
Pastie Database
https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=644
Script is your only option!
I can't provide a live demo of a script solution because you would have to be an administrator of the demo to see it work. So I will just show you a screenshot from a working application and provide sample code.
I have an application where the Administrator is dandiebolt@yahoo.com and there are two users in the Participant role: dandiebolt@gmail.com and dan.diebolt@gmail.com. In fact, the two gmail email addresswes actually are just alternate addressed to one Google email account but QuickBase thinks they are two different users. All three users in the demo are named Dan Diebolt. It can get a little confusing who's who so note the two different email domains (yahoo.com and gmail.com) and the period used to distinguish the two gmail email addresses (dandiebolt@gmail.com and dan.diebolt@gmail.com).
Now when I manually invoke the script in the pasties below I will send a custom email to each user in the participant role (dandiebolt@gmail.com and dan.diebolt@gmail.com) gently reminding them that their TPS Reports are overdue. It is a good practice to personalize your emails as it creates good rapport with your employees.
Here is what the received messages look like in my gmail client:
Pastie Database
https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=644