LinksForIsrael icon indicating copy to clipboard operation
LinksForIsrael copied to clipboard

Align Google form for new initiative with issue form (new_initiative.yml)

Open omer-friedman opened this issue 2 years ago • 3 comments

For example, we are missing the LinkedIn link (but there are more misalignments): image

omer-friedman avatar Nov 06 '23 17:11 omer-friedman

@omer-friedman FYI I changed this to be more generic

ohadschn avatar Nov 11 '23 11:11 ohadschn

@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

ohadschn avatar Nov 16 '23 22:11 ohadschn

As discussed with @4tal, ideally we would move this logic to GitHub Actions:

  1. Pull the spreadsheet from the google/MS form (more precisely spreadsheet) periodically (e.g. once an hour)
  2. Create corresponding new-initiative issues
  3. Mark initiatives as processed in the spreadsheet (or delete them / move to "processed" sheet)

Some notes for form -> issue translation:

  1. Add display name field
  2. Initiative name - strip whitespace to get a proper key (also backfill existing names)
  3. Use category display names rather than key/folder names (when aligned, also add the key/folder e.g. מתנדבים / volunteers)
  4. Improve descriptions (explain what should be in English, what can be Hebrew etc.)
  5. Add regex validations for the above constraints
  6. main URL must be mandatory
  7. Add missing href/url prefixes:
    • tel:1XXXXXXXXXX
    • https://wa.me/1XXXXXXXXXX
    • mailto:
  8. Consider removing tags (leave to ChatGPT + l4i team) - users put X/Twitter hash tags there by mistake

ohadschn avatar Nov 24 '23 11:11 ohadschn