I am looking for a way to manage the input of some data in Google Spreadsheets. Before I roll up my sleeves and write a new UI using the Google API I thought I would see if there was anything out there that does what I need.
The data is sorted by the name column, and the other columns are information about the person that needs to be updated from time to time (because it needs to be updated periodically I don't think a Google Form will work). I want a way to enter in a name and then be prompted to update the other fields in the row, as well as check to make sure the inputted data is of the right form.
Is there anything out there I might want to look into?