user specific calendar view

AppSheet AppSheet Q&A
1

HI all,

I’m trying to create a calendar funtionality that

  1. Allows each user to create and see only THEIR added events

  2. allows them to share events with selected other users

For the first task, I think I need to create a slice of Calendar data and then write in the “Row filter condition” some kind logic that limits the view to the current user. I have a User slice called “currentUser”. I also have a “user_id” that is a UNIQUEID() and a “user_email” in the Users table.

I’ve written this in the Row filter condition, but it seems wrong:

IF((currentUser[user_id])=Users[user_id],TRUE,FALSE)

2 
INDEX(CurrentUser[user_email], 1)=USEREMAIL()

Now, it may not be the best way to do it.

I would just make a CalendarTable with an Email column with initial value of UserEmail() and then a security filter to just see the rows where [Email]=UserEmail()

1 Like
3

You may use this simple expression LOOKUP(USEREMAIL(), “Table_name”, “Column_name”, “user_id”). Before you do that add a table with user email ids their user ids. change the table name to the newly created table name, column name to the email id column and user_id with User ID column name.