Forum Discussion

agent09's avatar
agent09
New Contributor II
2 years ago

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!

 

Thanks!

Dashboards
  • RobbSalzmann's avatar
    RobbSalzmann
    Valued Contributor II
    2 years ago

    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.