Better Form Submission Data Display

Passing this suggestion along from another LiveWhale editor.

Some background:
When you make changes to form fields, the data in the "view submissions"page can get weird.

  • If you remove a field, that data will no longer display, even for rows that were submitted when the field existed (even though the data still exists in the database).
  • If you add a field in the middle of a form, data on rows from before the field was added is shifted under the wrong column headings.

It would be nice if there was a way to avoid these issues. I recognize that this is a complicated situation, and there may not be a good solution, but I wanted to throw it out there anyway.

Maybe the view submissions page should loop through all form submissions and generate columns for every possible field, past and present, and display the data for each row under the corresponding header. Granted, this could also get weird, and may not be very performant.