Skip to main content
Member
Apr 5, 2023 12:05 PM UTC
Solved

Dashboard Prompt to appear only for users who access it the first time

Hi,

Is there a way to show a prompt for a dashboard ONLY during the first time the user opens the particular dashboard? User will provide some POV and this should be saved to be used by the dashboard everytime the user opens it.

I am thinking of creating a custom table on the database that gets populated with the username, and the POVs that the user chose. 

It would be best if I can make use of the dashboard parameters prompt, and just create a rule to (1) check if the user has an entry on the custom table, (2) do not show the parameters prompt if the user has entry.

Thanks!

RobbSalzmann
Employee - Advisor
Apr 5, 2023 5:35 PM UTC

A custom DB table [username][povstring] and a dedicated Parameter is the way I would go.  Do the lookup

select COALESCE(povstring, "") as povstring where username={si.UserName}

when launching the dashboard where the POV gets used.  

1 reply

RobbSalzmann
Employee - Advisor
Employee - Advisor
Apr 5, 2023 5:35 PM UTC

A custom DB table [username][povstring] and a dedicated Parameter is the way I would go.  Do the lookup

select COALESCE(povstring, "") as povstring where username={si.UserName}

when launching the dashboard where the POV gets used.