Quick update on my availability and a Google Docs project.

Quick update on my availability and a Google Docs project.

Availability
I have been having some health issues and not been keeping well. Hence, I am taking a break from DeputyDeputy Community Deputies are a team of people all over the world who review WordCamp and Meetup applications, interview lead organizers, and generally keep things moving at WordCamp Central. Find more about deputies in our Community Deputy Handbook. work at Central for a few weeks. I guess around 10th of September I should be back.

I had undertaken a project with WordCampWordCamp WordCamps are casual, locally-organized conferences covering everything related to WordPress. They're one of the places where the WordPress community comes together to teach one another what they’ve learned throughout the year and share the joy. Learn more. Status Doc and its privacy options during our last meeting at #outreach

Archive: https://wordpress.slack.com/archives/outreach/p1438888721001600

Following is an update.

So we had a Google Docs for WordCamp Status shared with all the DeputiesDeputy Community Deputies are a team of people all over the world who review WordCamp and Meetup applications, interview lead organizers, and generally keep things moving at WordCamp Central. Find more about deputies in our Community Deputy Handbook.. The issue was sharing it publicly as it had some private contact information in other sheets / tabs of the doc.

First test done was to see if one single sheet/tab of the spreadsheet doc could be made public and rest made private. It is done by hiding all the sheets except the one we want visible.

That seems to be a bad idea as the moment someone with edit rights – like a deputy opens the doc and clicks show tabs, all the tabs become visible even publicly.

The other option seems to be to have two spreadsheets – one with the public info and other with contact info on organisers and deputies safely private.

One issues with this approach was how to maintain two separate sheets and sync them with the same data.

Solution is to use =IMPORTRANGE(spreadsheet_key, range_string) function

Ref documentation: https://support.google.com/docs/answer/3093340?hl=en – function.

I tested a public sheet and moved ownership to @andreamiddleton of the doc, so further changes or formatting can be done while I am not available.

Link to Public Sheet: https://docs.google.com/spreadsheets/d/1EApFBKsuqXBtI8yGjrMh40iaxc6SJjn81TX_ZrKkihQ/edit?usp=sharing

#community-management