hackforla / hackforla/tables

Removing people from Google Drives: short-term solution

Open
#68 1 comment 0 reactions 0 assignees View on GitHub
draft missing: complexity missing: milestone missing: size p-feature: Google Drive role: developer
Dominant language
JavaScript
Stars
2
Forks
0
PR merge metrics
No merged PRs in 30d

Description

### Overview
Google Drive imposes a limit of 600 people per Drive folder. We need to implement a way to remove volunteers automatically from team Google Drives using a combination of Tables bots, Tables forms, and Google app scripts.

### Action Items
- [ ] Research the limitations of using Tables forms to collect information on volunteers who should be removed
- [ ] Decide whether we should be using one Tables form for all teams or if each team should have their own form
- [ ] Decide where we should be storing volunteer information -- just in the Volunteers table or in a separate Table for each team -- and where volunteers should be marked inactive
- [ ] Implement Tables bot that takes form input to mark volunteer(s) as inactive in the appropriate Table(s)
- [ ] Implement Google app script that uses Tables field update to "inactive" as trigger to remove volunteer(s) from the right Drive
- [ ] Implement a mechanism to notify team representatives that a volunteer has been removed from the team Drive

### Resources/Instructions
REPLACE THIS TEXT -If there is a website which has documentation that helps with this issue provide the link(s) here.

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.