Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

When user submits a new organization, add content to Google Sheet #836

Closed
2 tasks
DrIffathsultana opened this issue Aug 27, 2021 · 9 comments
Closed
2 tasks

When user submits a new organization, add content to Google Sheet #836

DrIffathsultana opened this issue Aug 27, 2021 · 9 comments
Labels
p-feature: Organizations Everything relating to Organizations page research role: back end role: front end size: 2pt Can be done in about 12 hours
Milestone
4 - Design MVP

Comments

@DrIffathsultana
Copy link
Contributor

DrIffathsultana commented Aug 27, 2021 •
edited by mariastudnicka
Loading

Overview

When a user submits an organization at Add Organization link in Tag Generator, add submitted content to Google sheet.

Action Items

  • Connect the Org form to a google sheet.
    We want the new Org form to output its values to a google sheet so that site managers can review and approve them
  • Follow the tutorial below to create a google sheet that gets inputs from the new google sheet

Resources/Instructions

Figma File

Medium tutorial
https://medium.com/@dmccoy/how-to-submit-an-html-form-to-google-sheets-without-google-forms-b833952cc175
Reference - Hack for LA wins page.
hackforla/website#1069
hackforla/website#1060
hackforla/website#1061
@DrIffathsultana DrIffathsultana added the p-feature: Organizations Everything relating to Organizations page label Aug 27, 2021
@DrIffathsultana DrIffathsultana changed the title Create a new github action that will eventually replace the organizations page github action When user submits an organization, create a new Github action to alert the PM. Aug 29, 2021
@DrIffathsultana DrIffathsultana added the size: 2pt Can be done in about 12 hours label Aug 31, 2021
@DrIffathsultana
Copy link
Contributor Author

Please update the following
• Progress: How much progress have you made on the issue?
• Blocks: Are you facing any blockers?
• Availability: How much time do you have to work on it this week?
• ETA: When do you think it will be completed?

@bruceplai
Copy link
Member

bruceplai commented Sep 8, 2021 •
edited
Loading

@cnk mentioned several pieces that make up the functionality in this issue

  • we need to know what the API call is to create a new issue
  • we need to know what tokens / secrets are needed to make those API calls
  • we need to figure out how to get those secrets into the django container during our build process
  • make an API call in a post_save signal

Worked with @cnk to determine how to submit a new github issue every time a user submits a new org (first 2 items in the list). As for the rest of the back end functionality, the level of effort is still TBD

@DrIffathsultana DrIffathsultana mentioned this issue Sep 12, 2021
Closed
@ladissi
Copy link

ladissi commented Sep 14, 2021

Hi @bruceplai thank you for the update above. Could you please update the following
• Progress: How much progress have you made on the issue?
• Blocks: Are you facing any blockers?
• Availability: How much time do you have to work on it this week?
• ETA: When do you think it will be completed?

@DrIffathsultana DrIffathsultana mentioned this issue Sep 14, 2021
Open
@bruceplai
Copy link
Member

@ladissi This feature is largely backend implementation so I'm not deeply familiar with the code to make a level of effort estimate. I discussed with @cnk and we're still trying to determine how to set up GitHub apps or Oauth apps. Not sure when that will be done.

@mariastudnicka
Copy link

mariastudnicka commented Sep 23, 2021 •
edited
Loading

This issue has been downsized and created into two issues. The next sequential issue is here #877

@mariastudnicka mariastudnicka mentioned this issue Sep 23, 2021
Closed
5 tasks
@mariastudnicka mariastudnicka changed the title When user submits an organization, create a new Github action to alert the PM. When user submits an organization, add content to Google Sheet Sep 23, 2021
@mariastudnicka mariastudnicka changed the title When user submits an organization, add content to Google Sheet When user submits a new organization, add content to Google Sheet Sep 23, 2021
@mariastudnicka
Copy link

@bruceplai to connect with @cnk re: verify/validate workflow vs other earlier option

@ladissi
Copy link

ladissi commented Sep 28, 2021

related to issue #877

@cnk
Copy link
Contributor

cnk commented Sep 29, 2021

I updated #877. I am not doing anything with Google sheets but do have code to create GH issues when a new organization is created from the React FrontEnd

@kevindphan
Copy link
Member

Solved by #877

@github-project-automation github-project-automation bot moved this to New Issue Approval (All new issues should be added to this column) in CTI: Project Board Aug 21, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
p-feature: Organizations Everything relating to Organizations page research role: back end role: front end size: 2pt Can be done in about 12 hours
Projects
CTI: Project Board
Status: New Issue Approval (All new issues should be added to this column)
Milestone
4 - Design MVP
Development

No branches or pull requests
7 participants
@cnk @emecas @bruceplai @ladissi @mariastudnicka @DrIffathsultana @kevindphan