Question

dynamic fields

Version 9 Laserfiche Capture

Updated April 23, 2021

asked on February 20, 2014

I have a customer that wouldd like to make GL Codes as a drop down list based on description. These are already in a SQL table. My question is this, If I make these fields as dynamic fields, is there any way to allow for multi values? Example If the select "Energy" the GL Code may be 0002 or 0003. On the same invoice they may need to select "Energy" and "Water" At that point I am unable to slect "004" GL Code for water as a Dynamic Field. By the way there are way too many GL Codes to make this a list field in Admin Console.

0 0

Replies

replied on February 20, 2014

They need to select both and both need to be multi value so they select water in the multi value description field and all the choices they can select for the gl code will show up in the gl field then they select their next choice energy and then in the multivalue field for gl code will show the choices for energy

0 0

replied on February 20, 2014

I think I am a bit confused.

When you set the field with the ledger code type to multiple, then you can select both values and then select the GL codes for all of the selected values in the first field?

It sounds like you already have it figured out unless what I am saying above is not what is happening.

0 1

replied on February 20, 2014

Both GL Description and GL Code are Multi-value and are connected to a table. I can select a description for the first value in description field and then select a code for the first vallue in the GL Code field. Whe I select a second value in the description field all I get as a choice in the second value of the GL code is the choice that I seleted for the first value.

0 0

replied on February 20, 2014

Yes, this is the current behavior. We've been looking into ways to extend this, but currently only the first value of a field is used to determine the values available for the second field.

2 0

replied on March 9, 2015

Hi Justin,

Any update on this feature request or field behavior issue.

Is this now fixed or resolved?

0 0

replied on March 10, 2015

Not as this time. Alternate methods for displaying collections of dynamic field sets has been discussed and we've got some approaches we're looking into, but it's not something that we've had a chance to look into.

0 0

replied on October 23, 2015

I have this exact same problem. I was looking for an answer, but it appears there is none, so this was at least helpful in that I can stop searching for the solution.

Just to illustrate what I'm seeing and what I believe Derek was describing:

In my template I have line of business and then I choose a specific program.

Line of business can be Worker's Compensation, Liability, Property, etc. When Liability is selected, I have the option of Primary General Liability, GL1, GL2 or SLIP. When Property is selected (usually, by itself or first) I'd only have the option of the 1 property program.

When I choose Liability as my first line of business, I get the choices of Primary General Liability, GL1, GL2 or SLIP for the first program.

For the second program I need to choose property, but I can't because I get the choices for Primary General Liability, GL1, GL2 or SLIP.

0 0

replied on April 23, 2021

Anyone ever come up with a work around for this? I am trying to do the exact same thing as Derek with GL Codes and running into the same problem 6 years later. I can select multiple departments but the GL codes only populate off of the first department selected. Thoughts?

0 0

replied on February 20, 2014

I am trying to understand, Are you saying you cannot just make the field with "Water" and "Energy" be multi-value and then both available options appear in the dynamic field?

0 1

replied on February 20, 2014

Are you able to show an image or video of this?

So when you have two values set for the first field, the second field has no options, but retains the first selected value from when only 1 Desc was selected?

Have you tried setting both GL Description values before trying to see the options for GL Code? If nothing appears in the GL Code, then you are dealing with a compounded query. Basically, the dynamic field is looking for the locations where both those values are set and since that is none, nothing shows.

You can likely check on the server's event viewer to see if a SQL Query error is generated when you are doing this.

0 2

You are not allowed to follow up in this post.

Question

Question

dynamic fields

Replies

Sign in to reply to this post.