Hi Vee Gees
Do you want to look at the complete hyperlink?
On the Dashboard, go to Actions, Click on the Action Name, Edit;
You can see the complete "URL" path.
I am not sure what you mean by the <projname> as the calculated field. This usually displays the dashboard title.
Yes, I am aware of that.
I want the url action to open any of 3 possible file types: .docx, .doc, or .pptx
Not sure if it is possible to use a wildcard character instead of hardcoding one file extension at the end, i.e. just .docx
I think what Vee means is that the file name is known via the <project name> field, but the extension is not known. I think he is asking if there is a way to interrogate the source and open the right type of file. I do not think it is possible to do what is being asked via a URL action, not because it is a URL action limitation, but in general how would I do it (programmatically or otherwise) even if it were a browser? If we can answer the latter part of the question, then we could build the URL appropriately.
The way I would pose the challenge is this - do we know of any way to open a file without knowing the extension in general (via a browser/hyperlink) ?
Hi Vee Gee,
Oh! I get it. Misread the question. I am not sure about hard coding ".doc or .docx" or any other file extension except "CSV".
You can export directly from the dashboard as a "CSV" file through a small hack (Posted on Andy Kriebel blog).
Yes, exactly. I do not want 3 different hyperlinks/actions for each of the 3 possible file types.
What you are asking for is not likely possible from within Tableau, you are essentially asking to interrogate a file store within sharepoint and make a determination.
It has been a while since I worked with Sharepoint, but is it possible to script a page in sharepoint to which you can pass the project name as a URL parameter, and then have that script test the existence of various file types within Sharepoint?