Visibility condition for calendar event based on user

[devick]

Hi, I’d like to allow users to see events in calendar view only if they are assigned to this event. How to do that ?

[Robert_Petitto]

Depends how you’re verifying that they’re assigned to the event. Ultimately, you’ll want to record or relate an event to the current user’s email or userID. Then, filter the list of events where the email is signed in user or userID is user> rowID

[devick]

Re : My problem (re-explained) was :

• Allow a user to see an event in calendar view only if they are assigned to the event or if they are an admin (who must see all events).

To achieve this I did this :

1- I Created a new boolean column in user table called “Is admin ? (1)”
2- I Check the box for all admins
3- In the event form, I added the component “Is admin ? (1)” from “Values from user profil” that fills the coresponding newly created boolean column in Event table (“Is admin ? (2)”)
4- To assign a user to the event you just have to create a list of “assignable users”, then allow one to add them in the event form
5- Finally, in the calendar view I added the filter data option :
“Is admin ? (2)” is “User profile > Is admin ? (1)”
or
“Assigned user” includes “User profile > Name”