(Updated to include prepend empty option to top of the list)
There is a way that you can get around this by using workflows and Javascript.
In workflows:
We use a custom query activity to query our database for the information that we need. For example, members on an account. Our query returns multiple owners of the account in one string separated by a pipe. Ex. Member1|Member2|Member3
Then we use the "Set Business Variable" activity to push that string to Laserfiche Forms into an empty drop-down field.
In Laserfiche Forms we assign a specific css class to that field. For example: List_of_Owners
Then we use the following JavaScript to separate the string from Workflows out into drop-down field choices. (Replace "List_of_Owners" with whatever you named your css class)
$(document).ready(function () {
//Compile correct list of Owners in "Person Making Request Field"
//Loop through all options in the drop-down list.
var options = $('.List_of_Owners option:first-child').text().split('|');
var index;
for (index=0; index<options.length; index++) {
$('.List_of_Owners select.form-item-field').append("<option>"+options[index]+"</option>");
}
$('.List_of_Owners option:first-child').remove();
$("<option>", { value: '', selected: true }).prependTo(".List_of_Owners select.form-item-field");
//Prepend a blank option to the field
$("<option>", { value: '', selected: true }).prependTo(".List_of_Owners select.form-item-field");
});
That should convert the string into drop down choices like you want.
Hope this helps. :)