Slicing google calendar into appsheet to seperate users

[johnni88]

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

[Aurelien]

Hi @johnni88 

You may benefit from using a Slice, and set your calendar view data source on this slice.

How to:

Option 1

1) go to Data/Slice

2) set a row filter condition, such as : 

[Section]=LOOKUP(USEREMAIL(), "USER", "email", "section")

Note: this assumes you have a table USER, with columns Email and Section.

And this assumes you want to separate viewings according to each section 

More information here:

Slices: The Essentials

LOOKUP 

Option2: use security filter

basically the same function, but only relevant data will be loaded on user's device

How to: 

1) Go under panel Security/Security Filter

2) pick your schedule table 

3) same expression than above

More information here:

Security filters: The Essentials 

[johnni88]

Thank you very much. I'll check it out and see if i can make sense of it. I'm still learning expressions but i should be able to manage. 

Thanks again 🙂

[johnni88]

What does "section" mean? what are you referring to?

[Aurelien]

By 'section', I was referring to a company service. 

Let's say: HR services should not see manufacturing informations. That's just an example, I probably picked a wrong word, English is not my native language 🙂

[johnni88]

its ok 🙂 I appreciate your help.

because the data is coming directly from google calendar, there is no table on google sheets to reference.

Therefore, do I need to create a new USER table in google sheets? somehow I need to distinguish users via google calendar directly.

I might need to ask for some direct advice

[Aurelien]

Hi  @johnni88 

I'm afraid  I don't have experience when it comes to dealing with Google Calendar and multiple users.

Maybe  @Joseph_Seddik , @Steve @Marc_Dillon 

[John_Pearson]

Hey Aurelien, FYI

Use the expression IN( USEREMAIL() , [Attendees] ) in a security filter, not a slice

Thanks for your help!

[Marc_Dillon · 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.

[John_Pearson]

Thanks marc you're spot on! but I found I had to add it in as a security filter, not a slice.

Massive help anyway! really appreciated!

[Joseph_Seddik]

Haven't encountered that need, but I'd definitely go with Marc's proposal.