Laserfiche Cloud 12: Can form table rows be inserted into Lookup Table rows on submission?

asked one day ago

I am working in Laserfiche Cloud 12 (Forms + Workflow) and need clarity on platform capabilities around Forms tables and Lookup Tables.

Use case:
A form contains a Forms Table with multiple items (each row represents one item).
I would like each row in the Forms Table to be inserted as its own row in a Lookup Table when the form is submitted.

What I have observed so far:

There is no Insert Row / Update Row activity in Cloud Workflow.
The For Each Row activity appears to be designed to iterate over Lookup Tables or Business Process tables, not Forms tables.
Forms table rows do not seem to be exposed as a row collection that Workflow can loop through.
Lookup Tables appear to allow writing one row per task, mapped from single-value fields, but not bulk inserts.

My questions:

Is it supported in Laserfiche Cloud 12 to insert multiple rows into a Lookup Table from a Forms Table on submission?
Can For Each Row iterate over Forms Table rows, or is it limited to Lookup Tables / Process tables?
If this is not supported, is the only Cloud-supported approach:
- one submission = one Lookup Table row (using single-line fields), or
- redesigning the solution to avoid Lookup Tables for transactional data?

I want to confirm whether this is a platform limitation by design, so I can redesign the solution correctly rather than chasing unsupported patterns.

Thank you.

0 0

replied one day ago

This isn't immediately intuitive - I needed some extra time with this!

If I understand what you're trying to do it does work. I'll work backwards from the lookup table.

Create your lookup table. Create an Insert rule.

Create your workflow. Add a 'for each value' with a 'run rule' inside the iteration. I had two value in each of my rows so I added them in the 'Values'. It's really important to get this part correct; there are a few parts to this. Here's the workflow:

But first...the workflow needs input parameters. Parameters need to be multivalued.

Here's the workflow:

In the "Values" of the "For Each Value" activity be sure to apply an index with "All values separated by a comma".

In the lookup table query "Run Rule", which is actually an Insert, set up your parameters like this:

Each of the Input Values needs an index:

On your Business Process you need a Workflow Service Task

Here's what the form looks like:

Maybe I missed a step. Let me know! But this should get you going.

1 0

replied one day ago

This is the solution. Well written. Form tables/collections are just multi-valued fields when sent to cloud workflow. You recreate the rows using the index function as shown here.

0 0

replied 12 hours ago

Thank you for taking the time to respond and share this solution. I appreciate the detailed explanation — I haven’t tested it yet, but it’s very helpful and gives me a clear direction to work with.

As soon as i test, i will give you feedback

0 0

Question

Question

Laserfiche Cloud 12: Can form table rows be inserted into Lookup Table rows on submission?

Replies

Sign in to reply to this post.