Question

Select Forms - database table values

Forms Workflow

Updated February 22, 2018

asked on February 15, 2018

Good morning,

We will be constructing a query to populate fields into repository that were not captured, as the repository field was recently added. The value of the field was captured by Forms though. I'm thinking that we will be doing this with some type of a workflow.

Does anyone know which table contains the fields in a form? We have a form that has a unique reference id per entry so we were thinking of doing something like UPDATE this table, SET this field to this value where this number is this number. We just need to know which table holds the field values I guess.

Any guidance, suggestions or ideas?

Thank you,

Raul Gonzalez

1 0

Answer

SELECTED ANSWER

replied on February 22, 2018

Hi Raul,

If you meant the submitted field values, the data are saved in table [cf_bp_data]. You can find a certain submitted value by the submission_id and attribute_id. attribute_id can be found in table [cf_bp_dataset] related with a certain process.

2 0

Replies

replied on February 22, 2018

Thanks Rui,

We decided to rely on Laserfiche support for this as it seems that it's more involved than previously expected.

Thanks for sharing.

Raul Gonzalez

0 0

You are not allowed to follow up in this post.

Question

Question

Select Forms - database table values

Answer

Replies

Sign in to reply to this post.