APAC SD Team
Category
Broadcast & Report Export
Product Version
9.0
Using a Filter Value in Broadcast Email Subject and File Name
Completed
I want the ability to use a filter value in the Email Subject and potentially the file attached (PDF, Excel, etc). This would be particularly useful when using the Advanced Broadcast option, as I have 100's of email addresses which receive a specific filter value all setup within a single broadcast job. Attached example of how we could utilise string replacement tags to solve this.
As an Administrator, I have myself setup to receive these same broadcasts however without opening every email and checking the attachment, I have no way to know which email is for which client. A client may contact me to ask a question about the broadcast and it's very difficult to find which email they received.
Files:
Broadcast.png
I like this idea 
Hi Emma,
Could you explain the output a little more for me? Do you mean you have a report with existing filters configured and you want to use a tag system to pull the filter results through and also help with naming the attached file?
I suppose a workaround for now could be to use multiple broadcast jobs, but if I'm understanding your request properly, then I can see how integrated tags could be useful. If that's the case then I'll go ahead and create an enhancement request.
Kind regards,
Chris
Hi Emma,
Could you explain the output a little more for me? Do you mean you have a report with existing filters configured and you want to use a tag system to pull the filter results through and also help with naming the attached file?
I suppose a workaround for now could be to use multiple broadcast jobs, but if I'm understanding your request properly, then I can see how integrated tags could be useful. If that's the case then I'll go ahead and create an enhancement request.
Kind regards,
Chris
Hi Chris,
Yes so a simple example could be a report with a Invoice Date filter. I setup a weekly broadcast with the filter Invoice Date = Maximum (so it's dynamic and always selects the latest date). Using a string replacement tag [Filter:InvoiceDate] to customise the Email Subject to dynamically include the Max Invoice Date (eg. Sales Report as at 19 Nov 2020) at the time of sending broadcast.
It would also be great if the file name had the same flexibility, not just for dates but any filter.
We are working around it at the moment, but it's a lot of admin and maintenance for the client. Please raise as an enhancement request for future releases.
Thanks,
Emma
Hi Chris,
Yes so a simple example could be a report with a Invoice Date filter. I setup a weekly broadcast with the filter Invoice Date = Maximum (so it's dynamic and always selects the latest date). Using a string replacement tag [Filter:InvoiceDate] to customise the Email Subject to dynamically include the Max Invoice Date (eg. Sales Report as at 19 Nov 2020) at the time of sending broadcast.
It would also be great if the file name had the same flexibility, not just for dates but any filter.
We are working around it at the moment, but it's a lot of admin and maintenance for the client. Please raise as an enhancement request for future releases.
Thanks,
Emma
Hi Emma,
Thanks, that's been added as a Jira task for a future enhancement!
This ticket will be updated with any further developments.
Kind regards,Chris
Hi Emma,
Thanks, that's been added as a Jira task for a future enhancement!
This ticket will be updated with any further developments.
Kind regards,Chris
Hi Emma,
This was added in 9.6 and 8.0.10! I'll mark this idea as complete.
Kind regards,
Chris
Hi Emma,
This was added in 9.6 and 8.0.10! I'll mark this idea as complete.
Kind regards,
Chris
Hi Chris, just following up on this functionality.
I am using the filter values in the broadcast email subject and this is great, but did similar functionality to customise the attachment file name ever get added or exist as enhancement request?
Regards, Nick
Hi Chris, just following up on this functionality.
I am using the filter values in the broadcast email subject and this is great, but did similar functionality to customise the attachment file name ever get added or exist as enhancement request?
Regards, Nick
Hi Nick,
In the original request, the functionality to add tags for file names was also mentioned, but it doesn't appear to have been implemented. I couldn't find a reason why, but it might have been evaluated to be too much work... I can bring this up with the dev team when I have a meeting with them in a couple weeks to see if I can find out why.
Kind regards,
Chris
Hi Nick,
In the original request, the functionality to add tags for file names was also mentioned, but it doesn't appear to have been implemented. I couldn't find a reason why, but it might have been evaluated to be too much work... I can bring this up with the dev team when I have a meeting with them in a couple weeks to see if I can find out why.
Kind regards,
Chris
Hi Chris, yes that would be good.
One of our customers asked if file names could reflect the filter entity used for advanced broadcast.
Currently they have to rely on the email content or opening email to confirm entity.
Regards, Nick
Hi Chris, yes that would be good.
One of our customers asked if file names could reflect the filter entity used for advanced broadcast.
Currently they have to rely on the email content or opening email to confirm entity.
Regards, Nick
No worries. I'll discuss it with the dev team and let you know.
Kind regards,
Chris
No worries. I'll discuss it with the dev team and let you know.
Kind regards,
Chris
Hi Nick,
I raised a separate enhancement for this, which you can find here: https://community.yellowfinbi.com/topic/27246-add-tag-filters-to-broadcast-file-names
I'll go ahead and close this one off.
Kind regards,
Chris
Hi Nick,
I raised a separate enhancement for this, which you can find here: https://community.yellowfinbi.com/topic/27246-add-tag-filters-to-broadcast-file-names
I'll go ahead and close this one off.
Kind regards,
Chris
Replies have been locked on this page!