Discussions

Expand all | Collapse all

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

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

    Posted 03-01-2018 20:14
    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!


  • 2.  RE: I need a way for ""Email everyone in this column"" to have a custom subject, is this possible?

    Posted 03-01-2018 21:21


  • 3.  RE: I need a way for ""Email everyone in this column"" to have a custom subject, is this possible?

    Posted 03-01-2018 21:29
    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.


  • 4.  RE: I need a way for ""Email everyone in this column"" to have a custom subject, is this possible?

    Posted 03-05-2018 13:59
    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.


  • 5.  RE: I need a way for ""Email everyone in this column"" to have a custom subject, is this possible?

    Top
    Contributor
    Posted 03-05-2018 14:03
    >I can not help with the "blue envelope on the bottom of the column" because I never saw it.

    Ditto - Where art thou blue envelope? In any event I am 100% confident you can do this with script whatever it is you are trying to do.


  • 6.  RE: I need a way for ""Email everyone in this column"" to have a custom subject, is this possible?

    Posted 03-05-2018 14:05
    when you have a table report which has a group by in the sort and includes a field of type email, there will be a blue envelope at the bottom of the column for the subtotals and grand total. 

    Clicking on that invokes the client email and populates the TO box with that's column's email addresses.


  • 7.  RE: I need a way for ""Email everyone in this column"" to have a custom subject, is this possible?

    Top
    Contributor
    Posted 03-05-2018 14:13
    I don't see it. Must be some native black magic.



  • 8.  RE: I need a way for ""Email everyone in this column"" to have a custom subject, is this possible?

    Posted 03-05-2018 14:29
    Perhaps some context would be helpful.  I created a report that lists users that require an email when a package arrives.  Currently, I have a button that emails on a per row basis with custom subject.  However,  most of the time all the users in a particular group will require the notification and I want to streamline the current solution by having one button that emails those users in the column group with the custom subject.

    Thanks


  • 9.  RE: I need a way for ""Email everyone in this column"" to have a custom subject, is this possible?

    Top
    Contributor
    Posted 03-05-2018 14:37
    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/">https://getsatisfaction.com/people/dandiebolt/">https://getsatisfaction.com/people/dandiebolt/


  • 10.  RE: I need a way for ""Email everyone in this column"" to have a custom subject, is this possible?

    Posted 03-05-2018 14:47
    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.


  • 11.  RE: I need a way for ""Email everyone in this column"" to have a custom subject, is this possible?

    Top
    Contributor
    Posted 03-05-2018 15:02
    I know it is labeled "user" but it is a email field:

    ">https://d2r1vs3d9006ap.cloudfront.net/s3_images/1711474/RackMultipart20180305-11049-1nr37fi-screenshot_inline.jpg?1520261803">

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

    But I  see that option you are talking about now:

    ">https://d2r1vs3d9006ap.cloudfront.net/s3_images/1711475/RackMultipart20180305-128270-9vqaym-screenshot3_inline.jpg?1520262067">

    I don't normally look at these options but I have reprogrammed my robot scrapper to summarize these options for me.


  • 12.  RE: I need a way for ""Email everyone in this column"" to have a custom subject, is this possible?

    Top
    Contributor
    Posted 03-05-2018 15:06
    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!



  • 13.  RE: I need a way for ""Email everyone in this column"" to have a custom subject, is this possible?

    Posted 03-14-2018 01:20
    Could you tell me the script I need to create and where to place it?

    Thanks