I have updated a form which is used quite a bit. In making the new form better, I inadvertantly left one field off of the form. The field is hidden and is only used only for reporting. But it stores the approvers decision, whether the request was approved or denied. Now that dozens and dozens of the forms have been completed, the report which includes that result is incomplete without the actual result.
I have since added the hidden field and written the javascript click function that populates it with the appropriate value when a button is clicked. That is good...going forward. But I need to correct my mistake with the existing instances. I know that the data is stored with the instance of the form in the sql tables and that I can add it, via sql, to the instance. I just don't know where that data lives. Would anyone care to share the tables and columns I need to touch to make this happen?