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

Question

Question

Use Workflow to Tie Forms and Repository?

asked on February 20, 2018

Good afternoon,

We are brainstorming on the best way to query our repository and based on the results, query the Forms database.

For demonstration purposes...

Workflow get entry from repository

The resulting repository entry queries Forms, WHERE repository-entry-something=database-column-something.

Does anyone have any suggestions on the best way to do this match?

 

Thank you,

Raul Gonzalez

 

0 0

Replies

replied on February 20, 2018

What sort of information do you expect to get back from the Forms database?

0 0
replied on February 20, 2018

Thanks Miruna,

 

Let's say that we have a form (in Forms) that has a field labeled "Name" and the form has a Save to Repository Task.

10 Forms have already been submitted, and then I decided to implement a repository template to keep the "Name" value as metadata.

From then on I'll be capturing the metadata value into repository, but I have 10 forms that are empty.

I'm looking into the best way to populate those 10 empty fields.

In a real scenario there are hundreds of forms already submitted.

0 0
replied on February 20, 2018

Do you have any field data saved on the documents currently? Forms doesn't keep the entry ID, but if you saved the instance and submission IDs with the documents, then Workflow can look up the form data.

Without the instance and submission IDs, it's not possible to find the Forms instances that generated these documents. You could use something like Quick Fields and Zone OCR to extract the data from the image, though.

0 0
replied on February 20, 2018

Thanks Miruna,

Unfortunately the last image that is saved in repository does not contain the value of the desired field either. This is a multiple form process, so at the beginning of the submission the form has the desired field value, but as the process continue, at the end the image saved does not have that value.

Also, the submission ID would have changed throughout the process right?

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

Sign in to reply to this post.