Question

Pre-build forms based on DB lookup

Laserfiche Version 9 Forms

Updated January 15, 2016

asked on June 30, 2014

Today's challenge:

Given «Order ID» entered in Forms' header, have a process (workflow?) that builds up the form body through a database lookup as follows:

Item no Description Qty Ordered Qty Shipped

For instance if «Order ID» has 6 items, the process will create 6 lines in the form body. The first 3 fields are readonly so users have to enter «Qty Shipped» only. There is no need to insert additional lines. I understand users will have to wait the form to build up after entering «Order ID», possibly (?) refresh screen content to see the lines in the form body.

note: database lookup consists in an ODBC data source

0 0

Replies

replied on January 15, 2016

Hi there,

Laserfiche Workflow 10 now supports Set Business Process Variables activity which can update the variables of a Forms business process in a Workflow Service Task.

1 0

replied on June 30, 2014

My understanding is that you cannot currently use a database lookup to fill in a table in the current version of Forms out of the box. I'm not sure whether or not this is possible using jQuery though.

0 0

replied on July 1, 2014

You can use jQuery to do it. Here's an example of editing row labels with the values from a database lookup. You could adjust the code slightly to fill in a column instead.

0 0

replied on October 27, 2015

Hi there,

Let's say if you populate the item number based on certain criteria (a field or dropdown option)

First time, table populate with 5 items; then criteria changed, table populate with 4 items.

User already input value in the Qty shipped on the row5, do you want this row5 to be automatically removed since there're only 4 items now.

0 0

You are not allowed to follow up in this post.

Question

Question

Pre-build forms based on DB lookup

Replies

Sign in to reply to this post.