Here, the Rollnumber lookup value can be utilized in the page that it is redirecting to but it should remain hidden in the URL. The main purpose here is to allow the user to add a comment to the rows in a table that has around 10 columns. Since Quicksight natively doesn’t have that facility, whenever the user clicks on the rows in the table they will be redirected to a different page where they are allowed to add comment. Therefore, the redirected page might require all these lookup values, however, one of the column’s lookup values should be hidden in the URL for some security concerns. Appreciate your answers
Apologies for the late response. Are you saying if my dashboard was using SDK and embedding on a web page, it would allow me to hide the parameter value? Pls clarify my doubt. Thank you.
I could imagine this way, let’s say my dashboard is on the web page now and i am setting an URL action for a table visual in the dashboard. https://example.org?#p.<<$roll_number>>
Now every time i click on one of the rows of the table visual, it redirects me to the following page https://example.org?#p.All
Now i want the roll number value of the respective row that i clicked on the embedded web page to be displayed on the redirected page. How would we go about this from here? Because if the value displays on the link, it is easier to fetch it on the redirected page. Pls clarify this a bit more in an understandable way. Thank you for the response.
Hello @pauldiv, do you still need assistance with this topic?
My thought is, you will need a way to set the rollNumber param without the user seeing the actual value. Is that correct? You want that to remain hidden?
If so, you have a few options. You could include the rollNumber value in the table, but select it to be hidden from the user. Then you could create 2 different actions on the table. One would actually set the parameter value. That would be a navigation action that could set the rollNumber parameter based on the table value. Then the second action would be the follow-up url action that could take the user to the url with the appended parameter value.
Since you are using this directly within the QuickSight console, that might be the best route. Now, if the rollNumber is user specific rather than row value specific, you can utilize RLS or Dynamic Defaults to set that value on load based on the UserName or GroupName the user is linked to.