Editing records via TorqueDataConnect

Created by: Nolski

Overview

We would like to be able to edit the contents of submissions & store those edits separately from the original submissions. The main constraints are:

• Be able to edit in place, so basically when looking at the wiki page, be able to click around the data you want to change to change it
• Edits should survive re-runs of the ETL pipeline, and when the underlying data changes, users should be alerted to the fact that the edit may now be invalid

Then on top of that things that might be feature requests would be:

• ChangeLog of edits (that can be deleted, or modified)
• Ability to approve edits by admins

Further Context

Best guess for entry point it is replacing calls to "cull_invalid_columns" to something that culls and then puts in overlays int he torquedata python server. In that response, return not only the column value, but also some kind of html that javascript acts on.

Then, I would add a call to the python server of "get column X of proposal Y in sheet Z" for the popup, and another call of saving the edit.