Meu app tem 150 usuรกrios diferentes, cada um com seu e-mail google para acessรก-lo. Cada usuรกrio tem sua prรณpria agenda google. Como faรงo para que quando o usuรกrio inclua um evento no Calendรกrio do App Sheet, apareรงa somente no Google Agenda daquele usuรกrio? Os usuรกrios nรฃo podem e nรฃo devem compartilha a mesma agenda.
Solved! Go to Solution.
It's possible to connect Google Calendar as a source for your apps by "+ New Data Source"
But you would have to add 150 Data Sources, which is not practical.
In your case, to manage agenda for multiple users from appsheet. I'll recomend you to make a BOT sending a message/email/notification any action or all of them. As a reminder to each events of each user. (You can configuret when you want this remainder; few hors ago, 1 day before or anytime)
And in Calendar View you can use an Slice in order to the users only can view their events.
You just need be sure that each event include an [owner_column] = useremail() and that will be your slice filter: [owner_column] = useremail()
It's possible to connect Google Calendar as a source for your apps by "+ New Data Source"
But you would have to add 150 Data Sources, which is not practical.
In your case, to manage agenda for multiple users from appsheet. I'll recomend you to make a BOT sending a message/email/notification any action or all of them. As a reminder to each events of each user. (You can configuret when you want this remainder; few hors ago, 1 day before or anytime)
And in Calendar View you can use an Slice in order to the users only can view their events.
You just need be sure that each event include an [owner_column] = useremail() and that will be your slice filter: [owner_column] = useremail()
User | Count |
---|---|
16 | |
7 | |
6 | |
3 | |
3 |