Has anyone tested the Select2 jQuery with Forms 10.4.5 when multiple conditions are required for the lookup to run? We had been using Chosen jQuery, but it no longer works with Forms 10.4.5.

We have been using Select2, as described above, for all of our user lookups on Forms for several months now.

We've noticed, however, that there is no blank space at the top of the list for clearing out selections. In a normal drop-down, there is always a blank at the top, so if you decide the value entered wasn't correct, you have a way to clear it.

Is it possible to modify the Select2 javascript to include this blank?

I know we could include a checkbox for "clear selection" but our forms are already getting a bit bogged down with all of the code behind them, so I'd like to avoid adding much more if possible.

(if asking in this comment section of an old post doesn't get much visibility, I may make a new post for this question)

Select2 javascript:

/* Select2 Drop-Down User Selection */

    $('head').append('<link rel="stylesheet" href="https://forms.siumed.edu/Forms/js/select2.min.css" type="text/css" />');
    $(document).ready(function () {
        $('.table.cf-table-block').on('click', 'a.cf-table-add-row', ApplySelect2);
        ApplySelect2();
    });

    function ApplySelect2() {
      $.getScript('https://forms.siumed.edu/Forms/js/select2.min.js', function () {
            $('.employee select').select2({
                placeholder: "Select an employee",
                width: "450px"
            });
        });
    }

It doesn't appear that someone had figured out how to make the single line work, so I ended up finding a solution. Here's how I did it - 

1. Create a stored procedure to verify validation that the value exists in the database. This procedure will trigger as soon as the single line is filled in. 
2. Create a hidden "output" field on the form that will show True or False based on whether the value exists in the lookup table. 
3. Add a custom HTML field + JavaScript to show an error + hide the submit button when the validtion output = false. 

Here's some screenshots of each component. 

vendchknum is the field we are pulling on the single line lookup. I assigned that same field the @Vendor variable in the stored procedure. Then I'm filling the output of the procedure with the vndlookup column. 

Here's the form itself with the 3 fields. I used field rules to hide vendor_validation always but I save the data. Then I used field rules to show the custom HTML so the error is only visible when vendor_validtion = True

Finally, this little piece of JavaScript will show/hide the submit button depending whether the validation is true or false

Here's the actual code for your copying & pasting convenience

Stored Procedure

USE [LFFormsData]
GO

/****** Object:  StoredProcedure [dbo].[CheckProcVendorValidation]    Script Date: 1/30/2023 9:17:51 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO




CREATE PROCEDURE [dbo].[CheckProcVendorValidation]
@Vendor nvarchar(max)
AS

BEGIN 
	IF EXISTS 
		(SELECT vndchknm AS vndlookup FROM [GP].[UAIC].[dbo].[LaserficheActiveVendorLookup] 
		WHERE vndchknm = @Vendor) 
			BEGIN 
				SELECT 'True' AS vndlookup
			END 
		ELSE
			BEGIN 
				SELECT 'False' AS vndlookup
			END 
END
GO

JavaScript to hide Submit (replace q66 with the ID of your output field) 

  //Hide submit button if the vendor is not in the database
    $("#q66").on("change", "input", function(){
        if($(this).val() === "False"){
            $(".Submit").hide();
        }else{
            $(".Submit").show();
        }
    });