Is there a away to set a variable default value for a drop-down list when using dynamic fields (in the Laserfiche Client), while still maintaining the ability to select other options from the list?
We currently have a dynamic field that we want to be able to set the default value for. The challenge is that the default value can change based on other fields in the template. While we can easily configure dynamic fields such that the selection of one field equals a different value for another field, doing so limits the available options for selection from the drop-down list. That is, only the default value is available for selection.
For example the two following columns are in the SQL table:
- Field 1 - Customer Name
- Field 2 - Customer Type
The possible values for each fields are...
- Customer Names: Customer A, Customer B, Customer C
- Customer Type: Prospect, Current, Former
Thus, our table might look like...
Customer A | Prospect
Customer B | Former
Customer C | Current
The problem we are having is if we want to change Customer A from Prospect to Current, we cannot because Current is not listed next to Customer A in the SQL table. If these fields were independent from each other, this would be simple; however, they are related, and it is critical that when someone chooses Customer A from the drop-down list, that the current Customer Type be defaulted to Prospect or whatever the current default for that customer should be.
Given this, is there a away to set a variable default value for a drop-down list when using dynamic fields, while still maintaining the ability to select other options from the list?
While brain storming this problem we thought about the possibility of generating a larger table with the default value being the first value in the list (for the second column), e.g.
Customer A | Prospect
Customer A | Current
Customer A | Former
Customer B | Former
Customer B | Prospect
Customer B | Current
Customer C | Current
Customer C | Prospect
Customer C | Former
However, we are not sure if the first row in the list will always be displayed first and we felt there had to be a less cumbersome way to do this. Would this work consistently, i.e. the first value would always be the default, and does anyone have a suggestion on a better way to do this? Thank you in advance!