Review/Audit Custom WINS form

[roslynwythe]

Overview

The website development team needs to perform a functional review/audit of the custom WINS html form and a list of pros/cons for the adoption of the new form, in order to inform the decision about whether to proceed with integration of the form into the website.

Details

• The motivation for exploring the use of the custom HTML form include:
  • Integration with the HfLA website
  • Control over form functionality such as URL validation (see ER ER from TLDL: Feasibility of validating fields on Wins Form #4185)
  • Option of developing code to dynamically generate the list of projects options in the form.
• Concerns related to the adoption of the custom HTML form include
  • Security issues related to storing submission data in the wins-form (Response) Sheet (see Security Audit of WINS form on static site #4588)
  • Most updates to the form will require skill using HTML and possibly JavaScript.
• The form https://github.com/hackforla/website/blob/gh-pages/pages/wins/wins-share-form.html was developed as a result of Create a wins form. #1060 (PR Wins works #1132). The form can be viewed and tested at https://hackforla.org/share-your-wins. The form was developed using the method outlined in articles in the Resources section. JavaScript within the form performs an AJAX request to send submitted data to the Google Sheet WinsFormSheetTest for further processing.

Action Items

• Read the WINS Admin Guide to understand the flow of WINS data.
• Audit user input validation on the form and note (? or fix) any problems.
• Compare the form questions and form field names to the live WINS form and note (? or fix) any discrepancies.
• Test the form and determine why form data is not successfully stored in the Google Sheet.
• Outline a plan for integrating the functionality in WinsFormSheetTest with Wins-form (Response) Sheet which is used to reformat the data submissions, create GitHub review issues and post json data to the Hfla repository.
• If the only secure method of hosting is on a separate Cloud-based server, answer the following questions:
  • What are the challenges for hosting and maintaining a form on a separate Cloud-based server? What skills would be required to make updates and how does the maintenance effort compare to the current Google form ? Would it be possible to develop code to dynamically populate the project list within the WINS form? If so, what is the best strategy for implementing that feature?
• As an alternative to integrating the new custom form, investigate the possibility of embedding the current Google form into the Hfla template. Refer to ER: Feasibility of and how to have all forms within an iframe #4542
• Summarize the pros and cons of adopting a custom html form in place of the current Google form.

Resources/Instructions

• WINS Admin Guide
• This issue is a result of ER: Audit of custom site Wins form and feasibility of using Google Analytics Tags with it #4390 and WINS form analysis #4577
• [WinsFormSheetTest] ??? Is this the correct Sheet? Is it safe to publish the URL?? The owner is Akib and I don't have access rights.
• custom WINS html form
• WINS page live | GitHub
• current WINS form (Google)
• How to Submit an HTML Form to Google Sheets…without Google Forms
• more current - Submit an HTML form to Google Sheets on GitHub
• From SheetMonkey - How to submit a simple HTML form to a Google Sheet using only HTML and JavaScript

[github-actions]

Hi @roslynwythe.

Please don't forget to add the proper labels to this issue. Currently, the labels for the following are missing:
Complexity, Role, Feature

NOTE: Please ignore the adding proper labels comment if you do not have 'write' access to this directory.

To add a label, take a look at Github's documentation here.

Also, don't forget to remove the "missing labels" afterwards.
To remove a label, the process is similar to adding a label, but you select a currently added label to remove it.

After the proper labels are added, the merge team will review the issue and add a "Ready for Prioritization" label once it is ready for prioritization.

Additional Resources:

• Wiki: How to create issues
• Wiki: How to read and interpret labels