Slicing google calendar into appsheet to seperate users

Hey everyone

Does anyone know the formula and how to make a slice to seperate users on the calendar function.

I have field workers and I want to use the calendar to schedule where they need to be BUT i dont want them seeing where everyone else is scheduled to be. Otherwise, the calendar will be full of junk not relevant to them. I just want them to see what is relevant to them

Can anyone help me please?

Thanks

John

Solved Solved
0 10 323
1 ACCEPTED SOLUTION

A GCal table should come with an [Attendees] column. Use a Slice with the expression IN( USEREMAIL() , [Attendees] ) should work, I'd think.

View solution in original post

10 REPLIES 10
Top Labels in this Space