I need a way for "Email everyone in this column" to have a custom subject, is this possible?

  • 0
  • 1
  • Question
  • Updated 8 months ago
  • In Progress
Or is there a better way to email people in a group with a custom subject, body, etc.  Currently I have an email button that does this, but it is on a per record basis and wont fill in mailto lines with multiple emails.

Any help is appreciated!
Photo of Patrick Tucker

Patrick Tucker

  • 90 Points 75 badge 2x thumb

Posted 9 months ago

  • 0
  • 1
Photo of Esther

Esther

  • 702 Points 500 badge 2x thumb
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,256 Points 50k badge 2x thumb
Patrick is asking about the blue envelope on the bottom of a column of email addresses when there is a group by on the sort of a table report.
Photo of Esther

Esther

  • 702 Points 500 badge 2x thumb
I followed the link I pasted before in one of my apps , they request update from the customers about their projects situation every new month .  I like the outcome. I paste the shot screen I hope it could be useful .

I can not help with the "blue envelope on the bottom of the column" because I never saw it.
(Edited)
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 26,372 Points 20k badge 2x thumb
Two issues: 

(1) I don't see the blue button anywhere.

(2)  Irrespective of (1) above, this can be done with script. It is similar in nature to this inquiry that wanted to send email to everyone in a particular role:

Alert sent to specific role(s)
https://community.quickbase.com/quickbase/topics/alert-sent-to-specific-role-s

Note the emails sent in my answer to the above question had customized subject lines.

The script in my answer above can be adopted for your purposes. I don't have time to do this as a demo but if you need a solution feel free to contact me off-world using the information in my profile:

https://getsatisfaction.com/people/dandiebolt/
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,256 Points 50k badge 2x thumb
Dan,
I think in your example you are grouping on a user field.  it needs to be an email field type.

The envelope used to be blue, but now after the purple UI change it is is black and white.

Also there is a field property in the email field that needs to be enabled, but I think it defaults to checked,

Display an icon in the totals row to email everyone in reports

Dan, once you get that working, maybe the leap to customize the Subject will be easier.
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 26,372 Points 20k badge 2x thumb
I know it is labeled "user" but it is a email field:



I was playing around with various things and just left it in that state.

But I  see that option you are talking about now:



I don't normally look at these options but I have reprogrammed my robot scrapper to summarize these options for me.
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 26,372 Points 20k badge 2x thumb
That options shows the envelopes but it synthesizes mailto: protocol links which would have a common subject line when filled in. So we are back to using a script solution - what a happy place!

Photo of Patrick Tucker

Patrick Tucker

  • 90 Points 75 badge 2x thumb
Could you tell me the script I need to create and where to place it?

Thanks