Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interactive GRID - download -> CSV -> email - populate email-receiver, sender, cc, subj. from page i

Bernhard FWSep 13 2018 — edited Sep 25 2018

APEX 18.1 - we have a cool function to send csv as part of an email from the interactive GRID.

Any tipp how to populate the values: FROM, TO, CC, BCC, SUBJECT, BODY-TEXT  from e.g. an PAGE_ITEM or key in an permanent default ?

Business case: the user like to send this sort of email every day/week and like to avoid keying in the above every time.

Thanks

Update: meanwhile I have analysed "interactiveGrid.min.js" and found these elements:

var h,i,j=b._getElement("DL_SEND_AS_EMAIL"),k=b._getElement("DL_EMAIL_TO"),l=b._getElement("DL_EMAIL_CC"),o=b._getElement("DL_EMAIL_BCC"),p=b._getElement("DL_EMAIL_SUBJECT"),q=b._getElement("DL_EMAIL_BODY")

these "DL_..." elements have to be set_value with values from a PAGE_ITEM...

Update 16.09.2018
A solution (workaround) provided by Marko Goricki is provided - thanks Marko! - is as follows:
DA with (when) jQuery Selector

input[id$="SEND_AS_EMAIL"]

- event scope : dynamic and a True Action  exececuting JS Code: like

$('[id$="DL_EMAIL_TO"]').val('tomail@mail.com');  

$('[id$="DL_EMAIL_CC"]').val('toccmail@mail.com');  

$('[id$="DL_EMAIL_SUBJECT"]').val('e-mail subject');

$('[id$="DL_EMAIL_BODY"]').val('this is the body text'); 

But this is not running stable... - once the values are set, the mail sending initiated, the mail is not send...

Update 20.09,2018

Another question came up: How can I influence the "standard text" added to an email sent from the Download --> send email dialog ?
I: per default the
1) link to the sending application like apex.orscl.com/pls/apex/f?p=12345 is added
and:
2) this message was send by user MYNAME (&APP_USER.) was added too.

I like to wave both these entries.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 23 2018
Added on Sep 13 2018
4 comments
523 views