Launches a view according to some condition

[BrendaGarciaC]

HI!

What formula can I apply for the following situation: In a user view, when selecting a user, it shows me another view where I can see their name, email, and other data. Additionally, there is an action with which I want to be able to view the activities that this user has recorded during the day.

NOTE: There is a view with a table called timesheet and that is where the user's activities are recorded.

the views: 

timesheet:

users:

 

the button of activity is where i want to show me the view of the activities of that same user, in this case of hannah 

the table timesheet is connected with the table of users through the column id_user

THANKS FOR THE HELP

[WillowMobileSys]

---

@BrendaGarciaC wrote:

What formula can I apply for the following situation: In a user view, when selecting a user, it shows me another view where I can see their name, email, and other data.

---

It is not clear what view you are starting with.  You say "user view"  which I would assume means a table view of users.  If so, then by default you would be shown a Users_Detal view which you can modify to look that shown for Hannah.  If its some OTHER view then I am not certain what you mean by "when selecting a user".  We need clarity before we can advise on this part of your question.

As for the view of Activities for a User...in that Activities table (whatever it might be) if you have the User column defined as REF type to the Users table, you will automatically get a column named [Related Activities].  If you simply include this column in the User Detail View, it will show as an Inline table showing the list of users Activities right there in that Detail View. See image.

I hope this helps!!

[BrendaGarciaC]

Yes, that's what i mean. 

In the Users_Detal view i want that the action called activity as it can sees in the image:

show me the activities of just hannah or whatever the user you choose to see details. so for that, i don't know what formula use in the action, i tried with this one: 

IF(
IN([ID_USER], [Related TIMESHEETs][ID_USER]),
LINKTOVIEW("TIMESHEET"),
"No hay coincidencias"
) 

but it shows me the view timesheet with the activities of all users, instead of just for the one user that i'm seeing his details

this is the action called activity:

And the option that you give me, it's fine thanks, but inside of the view with the activities i want to add other options, so that's why i want to do it with an action