You are viewing limited content. For full access, please sign in.

Question

Question

drop down list - Append Choices to lookup results

asked on May 8, 2017 Show version history

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.

0 0

Replies

replied on May 9, 2017

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());
  }
});

 

0 0
replied on January 8, 2023

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

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.