I have a form where I am using a db look-up to retrieve a list item for a drop down menu. However, when I do this, I lose all the other options that I have loaded into Forms for that drop down. I'm still having issues with this...when I select "Append Choices to lookup results" the lookup rule no longer populates the field - it comes through blank. When I unselect "Append choices to lookup results" it fills correctly as expected but my drop down is no long my whole list, rather just my prefilled choice.
Question
Question
drop down list - Append Choices to lookup results
Replies
Hi Amanda,
Your screenshot works just as expected if I understand if correctly: the "II" is lookup result, the ""JR/SR/..." are existing choices, so when "Append choice" is selected, all options are listed, while when "Append choice" is not selected, only lookup returned value is listed.
As for the default selected value, it's not guaranteed that lookup value will be selected: it's selected when it's the only one choice, which is not true if "Append choice" is used.
If you would like the first lookup result to be selected, you could use custom script like this (need to update ruleId and field id):
$(document).on("lookupcomplete", function (event) { console.log(event.ruleId); if (event.ruleId == 1494) { $("#Field1").val($("#Field1 option:not(:empty):first").val()); } });
This has been fixed with Forms 11 Update 3.
When the dropdown field has "Append choices to lookup results" selected and there is only one result from lookup rule, the lookup result will be auto selected.
You can see other changes of Forms 11 Update 3 from https://support.laserfiche.com/kb/1014413/list-of-changes-for-laserfiche-forms-11-update-3 and get Forms 11 Update 3 from Laserfiche 11 package https://support.laserfiche.com/kb/1014263/software-versions-and-fixes-included-in-the-laserfiche-11-download-package.