fix google form

[superbunker]

Overview

Google form submissions currently aren't being added as futureautomations issues. This was recently working, so something must have changed.

Action Items

• research and document how form was built
• rebuild connection to the form
  • duplicate form as 100automations
  • rename (unpublish?) old superbunker-owned form and sheet
  • connect responses of new form to a new sheet
  • get personal token for 100a account (requires 2FA)
    • test with superbunker token
    • test with old token (akib's)
  • add app script to google sheet
    • publish, deploy, versioning, trigger, uhhgggg
  • change all links to the form
    • ideator's guide
    • futureautomations board
    • fa issue template - config.yml
    • self-evaluating a New Automation Idea (linked to fa board)
  • various formatting and fussiness
  • test and revise
• review: ensure submissions go into the icebox with proper labels, etc
• Bonus Round: send an issue to the website project board too, alerting of new submission

Resources/Instructions

Address of the new form:
https://docs.google.com/forms/d/e/1FAIpQLSemmRJ1tBDVrGtPpwpxLVCQbw2O-tVVRpcbRW3SzRdNbZ9olg/viewform

New form, shortened:
https://forms.gle/daURL7woEeCNans89

• Broken Automation Proposal Form, shortened
• GitHub Issues API

apps script dashboard:
https://script.google.com/home/projects/1qT70DBmD4KgJMUPh_mTtsSQb1IBKhDkT3gjMIzsniOjGKMl0y_c9ACcK

Related Issues:

• create google form to take in new ideas #223
• Change the Github user who creates the issue to the FutureAutomations board. #241
• A proposal for streamlining the process of adding a new guide page OR project page/card. #189

[superbunker]

Linked google form seems to be owned by superbunker@gmail. Perhaps there's another form out there.

Ah, yes. Google made it impossible to change ownership The form will have to be copied/recreated by the 100automations account. After we figure out how it's supposed to be working.

[superbunker]

Form is referenced in this yml :
https://github.com/100Automations/futureautomations/blob/master/.github/ISSUE_TEMPLATE/config.yml

Can't find any other relevant code in GitHub

[superbunker]

Research

There are zaps set up in the 100automations@hackforla Zapier account for GitHub and Google Sheets.

GitHub issue to google sheet is still working. Wait.... this is sending all our issues to a google sheet?
Is this even for the project submission form?

Zapier has an active connection to our GitHub. There's a zap still actively updating a google sheet with each idea submission! My test submission is there. That zap last edited jun 17, 2021

There's also a zap for "Create GitHub issues from new Google Forms responses" which is turned off and has never run. Setup isn't complete—no GitHub account selected.
So... what was creating the GitHub issue?

Looks like prior comment ("akibrhast to set up the Google Form with an script and the GitHub API") is how it was done. But aside from that one YML reference, can't find any code for this in our repos.

AH! Gotcha. It's a script in the google sheet that form responses go in.
Instructions for setting it up. (actually this seems to be a slightly different script)
Another set of instructions for doing this with app script
But wait... this script has the assignee as Olivia, and we changed that. Is there another script? Another form?

HERE we go: "The app is requesting access to sensitive info in your Google Account. Until the developer ([email protected]) verifies this app with Google, you shouldn't use it."
So I gotta copy the form as 100a so it has correct permissions, set up the script again, and change every link to the form.
Yaaaaaay..
oh hang on, It's letting me jump through "unsafe" hoops to give the script permissions to run....

[superbunker]

Notes

For users to get a copy of their responses, the form needs to "collect email" — the question asking for email is duplicated, and should be removed.
On second thought, i'd have to re-do the sheet and probably re-deploy the app to get the fields right. Better to just turn off the send copy function
on third thought, the form was created with duplicate email fields, lol

Have to deploy (web app?) and add the trigger. Ohhh wait. the function is named onFormSubmit? That seems odd.

versions. wtf

WORKING. ugh only took two days. If the script is changed, i think it needs to be saved (floppy icon) and redeployed to a version - "Publish" allows a version to be updated. Let's see. Yes! working with old token.

But it looks like "project" isn't in the API, so not added to the board.

This looks handy:
https://github.com/marketplace/actions/assign-to-one-project
Oh ho! what's this! Secret is already there? srggrs/assign-one-project-github-action#61
Creating a new issue for deploying this workflow to FA

Plot twist: there was also a script in the form itself. That might be better than form-to-sheet-to-issue? Contrariwise, the sheet is a backup

[henlatourrette]

The Google form is now working. A related issue was opened to work on having the new issue created through the google form go to the Project Board >> #491