Question

Laserfiche form lookup on dynamic field value

Forms

Updated May 1, 2024

asked on May 1, 2024

Hello.

Building a Laserfiche form to lookup contract status.

Data source = SQL table with column entries updated by a Workflow.

Dynamic entries in db = Signed Contract or Unsigned Contract.

Suggestions on the lookup so it only pulls up either Signed Contract or Unsigned Contract?

My lookup rules:

(1) LF.Database dbo.Contract
When Individual EID matches data source column EID

Fill Contract Status with data source value CONTRACT-STATUS (this entry is dynamic from the WF)

(2) LF.Database dbo.Contract
When Department matches data source column DEPARTMENT
Fill Contract Status with data source value CONTRACT-STATUS

(3) LF.Database dbo.Contract

When Filter Group All matches data source column ALL

Fill Contract Status with data source value CONTRACT-STATUS (I only want those that show Unsigned Contract to populate)

0 0

Replies

replied on May 1, 2024

I'd think just putting a Selectable option on the form that allowed you to Choose "Signed", "Unsigned', or "All" would be easiest as you could just add that to your condition. Otherwise, create a hidden Field on the Form containing the Unsigned Value, and add that to your 3rd Lookup Rule as another condition.

FYI, the new layout designer has built in Search/Filter capabilities that is nice feature as well

3 0

replied on May 1, 2024

Another option is to create a separate view in sql for just unsigned and do your look up from there.

0 0

You are not allowed to follow up in this post.

Question

Question

Laserfiche form lookup on dynamic field value

Replies

Sign in to reply to this post.