I read a few posts about people wanting a better way to keep the registry updated. I'm a web developer.
I created a demo website that displays data submitted via Google Forms. The demo has a list of books, but this code could be used for anything. Feel free to add records using the form and go to the site to see the data. Website. Google Form.
- As long Google Forms does not ask for user's email and does not allow file uploads, then people do not need a Google Account to submit the form.
- The data from Google Forms is saved to Google Sheets. This means the data can be exported into other formats.
- The website shows all the records in the Google Sheets. The site uses javascript to fetch data from the Google Sheets and render the HTML, which means the site will be updated a few seconds after form submission.
- The data is stored for free in Google Sheet. The webpage is hosted for free on Github pages. This means the entire setup can be hosted for free.
- I added "Verified" column to Google Sheet that only people who have editor permission can update.
- I created a very basic site that just displays a table of data. The code can be updated to add features like sort by columns, search, etc.
- The code to create the site is open source.
- One or more people can be given permission to edit Google Forms, Google Sheets, and website code. Having multiple people update the registry can speed up the verification processing.
- If the data of the current registry is stored in a spreadsheet or csv, then the data can easily be imported into Google Sheets.
This is just a demo. There is still other stuff to discuss if y'all are interested in creating something like this for the registry.
Edited by wykbbb, 15 December 2024 - 12:15 PM.