You are viewing limited content. For full access, please sign in.

Question

Question

Trying to correct my mistake

asked on December 2, 2020

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?

0 0

Replies

replied on December 6, 2020

Hi Jamie,

You can find submission action by instance id in Forms database table cf_submissions. And you can find corresponding variable data in table cf_bp_data.

Hope it helps!

 

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.