Provide automatic fill suggestions autocomplete for a form based on previously added entries

Really i just want a simple CSV spreadsheet program that can run on the web easily, no formulas or anything just a very basic

Given the web-based approach, the simplicity, the autocompletion, i’m probably looking for a JavaScript app, but i can’t find one and am not really looking to write one right now.

javascript csv editor

https://www.drupal.org/project/webform_dynamic_autocomplete

Google, which has effectively infinite resources to get this right, doesn’t even try to make a good mobile-version of their spreadsheet, instead having a nearly impossible to read message pop up:

“The current window is too small to properly display this sheet. Consider resizing your browser window or adjusting frozen rows and columns.”

automatically generate autocomplete form from google sheets google form autosuggest

Whole thread to conclude that google forms is not very good: https://community.spiceworks.com/topic/2276304-google-forms-autocomplete-typed-answer-with-dropdown-options

But anyway, although google forms can export to a spreadsheet, they don’t seem to try to round trip the data at all, no automatically creating a form with the fields based on the column in the spreadsheet, nor allowing automatic suggestions based on data already entered in a given field.

And don’t suggest my browser autocompletion of fields the whole point is this work collaboratively, that other people get the same benefit. There’s whole articles on using the Web Storage API to do autocompletion even more thoroughly than the browser will do for you but again that’s per-user, per-person, we want to draw from the data submitted.

web form autocomplete based on data submitted

javascript web app form autocomplete based on data submitted

If i do end up having to build it myself someday:

https://stephenafamo.com/blog/posts/how-to-create-an-autocomplete-input-with-plain-javascript

https://www.papaparse.com/

drupal csv editor