I have a table called PROFILE which is set up as a DECK VIEW in the menu bar.
Once the user creates a PROFILE, I’d like for the DECK VIEW to disappear and go directly to the DETAIL VIEW once the user clicks PROFILE from the menu.
The DECK VIEW serves no purposes anymore once the profile is created. It’s just another view in which the user has to click on their box which then takes them to the DETAIL view. A two step process. I wonder if it’s possible to cut it down to one?
Is there a way to set up the SHOW IF condition in the PROFILE DECK VIEW which says basically that IF profile is created, then show the PROFILE DETAIL VIEW, else, show the DECK VIEW.
I have the formulation below to determine if the profile is created:
ISBLANK(SELECT(PROFILE[EMAIL], [EMAIL]=USEREMAIL() ) )