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

Question

Question

How to send forms data to workflow to be stored in Database

asked on April 25, 2016

Hi dears, i have a requirement of creating a number of forms for capturing patient details for a hospital and storing them into SQL Database.  i need to know a complete procedure that after the user fills in all the information in the LF Forms, how can this data be saved in SQL database on submit so we can use this data for generating reports with different criteria also based on this raw data captured from the LF Forms fields.

 

Just to summarize, i need to know how to send the captured data from the LF Forms fields to SQL Database.

0 0

Replies

replied on April 25, 2016

In order to get the data into a SQL database, you don't even need to store the submitted form in Laserfiche. In the Process Diagram add a Workflow Service Task.

Then create a workflow in Workflow that has its first activity using the "Retrieve Laserfiche Forms Content". Set it up to retrieve the field data you need from the correct Forms process. Depending on how your data is setup on the form (tables, collections, etc.) you may need to use other activities to parse through the different rows etc. being retrieved from Forms. Once you have that figured out, you can add a Custom Query activity or just a simple Insert Data activity to insert the data into a SQL database. Below is a screenshot of a Workflow diagram that does this:

Make sure after you save your workflow that you go back into the Forms process diagram and edit the Workflow Service Task so it has the correct workflow name.

2 0
replied on April 25, 2016

The process is pretty straight forward. 

1. Store the form in Laserfiche

2. use workflow to update the SQL database using a custom query tool and an Insert Data or Update Data statement, depending on what you need to do.

 

It is hard to give a "complete procedure" without knowing specifically what you are needing to get into the SQL database.  

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

Sign in to reply to this post.