Hi Shelly. What specifically is preventing you from using STR(Today()) in the subject and filename?
Thank you for your prompt response.
This is the error I get:
Found non-allowed character(s): (( in filename ABC + STR(today( for content reference VIZ_PDF(/ABC/Report|filename=LA ABC + STR(today(), only allowed characters are alphanumeric, space, hyphen, underscore, period, and plus sign
This is how I am putting in my spread sheet:
Subject: Name + STR(TODAY())
Filename: VIZ_PDF(/Sales/Report|filename=LA ABC + STR(today()))
The content references shouldn't start with "/". So
Try that and see if it helps.
It does not work, I get the same error
Found non-allowed character(s): (( in filename ABC + STR(Today( for content reference VIZ_PDF(Report/MonthtoDate|filename=Sales + STR(Today(), only allowed characters are alphanumeric, space, hyphen, underscore, period, and plus sign
Bummer. My next guess is that the "+" symbol is actually included in the literal string rather than being considered the concatenate operator between what you really want as your strings:
'VIZ_PDF(Report/MonthtoDate|filename=Sales + STR(Today()))'
'VIZ_PDF(Report/MonthtoDate|filename=Sales' + STR(Today()) + ')'
The first would be likely to result in the failure you are experiencing. The second will work.
unfortunately this didn't help either.
Okay, please attach a sanitized version of the workbook your trigger view is located in, as a .twbx. That should clear this up fairly quickly.
@Shelly - Showing us the formula you are using for generating the content reference string is great, what would be even better is showing us the resulting *value* of the content reference string(s) in your trigger view. For example, here's what the Email Body * field shows in the VizAlertsDemo/AdvancedAlertsDemo worksheet:
The tooltip is displaying the VIZ_IMAGE() content reference and by seeing that we can usually get a sense of whether the syntax is accurate or not.
When Matt is asking for the trigger view .twbx he's mostly asking for that level of detail.
@Matt - We should probably put this in the documentation in the troubleshooting section.
Here you go:
I have attached the trigger view source spreadsheet and the workbook.
I have changed the format so many times...but I think the one you see in the files is the one with which I started.
Also, I want to add the date in the subject, I was not able to accomplish that by adding STR(Today()) in the spread sheet, so I have made a calculated field, but I would like to not do that, and instead have the custom subject coming from the spread sheet.
Thank you for your prompt replies.
Hey Shelly. Thanks for attaching the files. The issue is that the STR(TODAY()) stuff isn't actually a calculation, it's just text in your view. VizAlerts doesn't evaluate that stuff, it just treats it as plain old text. You need to either have Excel calculate the current date by building out a formula there for it and connecting to it live, or wrapping the report values in a Tableau calculation that uses the formula I previously provided.
You will know that you're doing it right when you see the actual current date being showing in the table view itself in Tableau.
Right (or closer to it, at least):
Another question, not related to the custom subject/attachment.
In the trigger view if one alert has an error (due to say wrong view name), none of the alerts go successfully.
They all fail.
Is there a way to change this ?Meaning, send the ones which don't have a problem?
Nope, not at present.