LinksForIsrael
LinksForIsrael copied to clipboard
Align Google form for new initiative with issue form (new_initiative.yml)
For example, we are missing the LinkedIn link (but there are more misalignments):
@omer-friedman FYI I changed this to be more generic
@DanielShterenberg we can use this to track our idea about the GitHub Action that modifies the form on each new_initiative.yml change: https://developers.google.com/forms/api/guides/update-form-quiz
It looks like we can actually update the script itself as well: https://developers.google.com/apps-script/guides/import-export
As discussed with @4tal, ideally we would move this logic to GitHub Actions:
- Pull the spreadsheet from the google/MS form (more precisely spreadsheet) periodically (e.g. once an hour)
- Create corresponding new-initiative issues
- Mark initiatives as processed in the spreadsheet (or delete them / move to "processed" sheet)
Some notes for form -> issue translation:
- Add display name field
- Initiative name - strip whitespace to get a proper key (also backfill existing names)
- Use category display names rather than key/folder names (when aligned, also add the key/folder e.g.
מתנדבים / volunteers) - Improve descriptions (explain what should be in English, what can be Hebrew etc.)
- Add regex validations for the above constraints
- main URL must be mandatory
- Add missing href/url prefixes:
tel:1XXXXXXXXXXhttps://wa.me/1XXXXXXXXXXmailto:
- Consider removing tags (leave to ChatGPT + l4i team) - users put X/Twitter hash tags there by mistake