Can you create a lookup that populates a field if a partial entry is made?

Can you create a lookup that populates a field if a partial entry is made and still be able to do a manual entry?

Is it possible to have functionality where when the user partially types, it filters to those options e.g. blue/green/white and populates with that option. And for the user to also manually be able to enter what they want? Not sure if this functionality already exists

Best Answer

  • vaprogvaprog Member Posts: 1,007
    Answer ✓
    Yes, but you need to call your code from the trigger on the page, not from the trigger on the database field. There you get in Text, whatever is in the field when the trigger is called. Also, you should return the value selected in the VAR parameter Text, and indicate succsess or abortion of the lookup with the trigger's boolean return value.

Answers

  • vaprogvaprog Member Posts: 1,007
    Answer ✓
    Yes, but you need to call your code from the trigger on the page, not from the trigger on the database field. There you get in Text, whatever is in the field when the trigger is called. Also, you should return the value selected in the VAR parameter Text, and indicate succsess or abortion of the lookup with the trigger's boolean return value.
Sign In or Register to comment.