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

Discussion

Discussion

Laserfiche Forms – Tables and Collections CRUD Operations

posted on October 25, 2024

I recently set up a Laserfiche Forms process with a Workflow that saves the data from a forms table/collection to a SQL table.  It took me a bit to figure out all of the pieces so I decided to document it.

I've attached the document that outlines how to create a table or collection in a form that will update a SQL database table including inserts, updates, and deletes (CRUD - Create, Read, Update, Delete) using Laserfiche Forms Modern Designer and Workflow.

I'm sure there are ways to improve upon the process but I hope this helps someone else get started.

2 0
replied on October 28, 2024

Only one thing I really do differently. I make the insert/update actions part of an "upsert" stored procedure. Instead of conditionally running two different activities from workflow to insert/update a row, you just run the stored procedure. Makes the workflow slightly more simplified and can save you some time if the table has a lot of columns since you don't have to fill in both the insert and update activities.

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

Sign in to reply to this post.