hi, wondering if anyone could let me know of a solution to generate
and email PDFs to provide project participants with comments from all
jury members relevant to the piece they submitted to the project.
relationships are as follows:
JURIES (comments) -- AUDIO (composition) -- CONTACTS (composer / email)
everything works up to seeing the pages as i want them: project
information in the header, CONTACTS::composer and AUDIO::composition
info in a sub-summary layout part (sorted by CONTACTS::composer) and
all juror comments in the body. the layout.
i know how to name individual PDFs using the fileName variable, but
can't figure out how to make it work in this context, because of the
sub-summaries.
other email scripts i use work because they are done from within
CONTACTS, where each record is one person/email. i thought of doing
it from a new layout in JURIES defined to "Show records from
CONTACTS", but then i need a portal to show the comments, and the
portal doesn't seem to recognize the sliding/printing options to
remove empty space. (i have to define the text area large enough to
accommodate the longest juror comments).
any solutions would be appreciated. hoping to avoid printing /
naming /emailing the comments pages manually.
cheers,
jef
