Is there any “conditional” programmatic methods available in Quick Sight to enable/disable a URL Action (menu select style) based on the data value within the field being used? Example:
URL Action has “https://my.web.site/folder/structure” as the URL portion that I want to transfer to, and I tack on the <> placeholder to enable the action to open the URL to the correct “fieldname” page of the site …
The data, however, occasionally has NULL as the value in that field, and either causes errors at the website or opens an errant webpage that just happens to match up to “null” …
The closest thing I found to a similar question is about 2 years old and was noted to be added as a feature request - when the field value of the row on the table is NULL, I would LOVE to not have the action meu even offer the ability to send the user off to an “error” situation.
Is this possible? Is there any traction on a feature request after 2 years?
An alternative situation, similar n nature, could be to change the hardcoded URL piece of the final address to send a user based on the value of the intended field, but same concept of “conditional action” settings.
Any help will be greatly appreciated.
Hello @jnkline, in regards to a conditional URL action, there really isn’t a way at the moment to create that type of functionality. What visual type are you using to create this action? Maybe there is something we could do with a table visual to display proper URLs. Alternatively, there may be a work around option we could create to provide some kind of visual display for the user to show whether or not the URL is available.
1 Like
Thanks, @WLS-DM - guess I pretty much expected this response. The current visual that I added the action(s) to is a Table visual. When you say display proper URLs in this case, are we then meaning, perhaps, to create a calculated field on that table that is programmatically created based on the conditions of the other fields? Then show that field on the table as a hyperlink rather than an action?
1 Like
Hello @jnkline, that is exactly what I was thinking! You could try to display the link rather than using the URL action to dynamically manage whether the link is shown in the table or not. Do you think that could resolve the issue you are facing?
1 Like
I will attempt that and see if the record volume and logic causes any delays (perceptiple to our report users) and if the links then give us the correct “action” … I’ll come back to this post with an update and a “solution” check if this in fact works for us. Thanks, again, @WLS-DM
1 Like
Hello @jnkline, that sounds good to me. Please let me know how the performance is on the update, and we can try to make improvements depending on the results.
1 Like
I created the “calculated field” on the dataset so it appears that it won’t kill us in any way on performance - just a few moments longer at refresh time to prepare the data, but it gives me full conditional logic to set or clear a URL based on the two other data fields of interest. I added the two new fields at the end of the table visual and set the formatting of those to show as URLs and open a new window/tab if/when clicked on - both took me to the correct external URL address. THANKS @WLS-DM
1 Like
Thanks for the update @jnkline, I am glad it worked for you!
1 Like