How to clear select lookup box variable value?

Lisa Goldman · ‎03-05-2024

Hello,

I have the following two variables, reference and lookup select box. The variables are getting data from the same table: u_part_number

On the "lookup select box", I am using Auto-Populate to fill in the Part Id variable.

How to you clear Part Id variable on Part number changes.

Here is the onChange script I have tired, but it did not work. Please help. Thank you

Harsh Vardhan · ‎03-06-2024

@Lisa Goldman Strange , but anyways you can give another try.

Set 'Include none' as true on your Lookup select box variable and now use below script.

eg:

function onChange(control, oldValue, newValue, isLoading) {
    if (newValue == '') {       
	 g_form.removeOption('part_id','');
        g_form.addOption('part_id', '', '');
    }
}

Thanks,

Harsh

View solution in original post

James Chun · ‎03-05-2024

Hey @Lisa Goldman,

Is the 'u_part_number.part_id' a reference type or a string?

Cheers

Lisa Goldman · ‎03-05-2024

@James Chun ,

It was on lookup select box type. I changed to reference type to make it works.

James Chun · ‎03-05-2024

No, I meant the Part id field on the part number [u_part_number] table. The one you are referencing to fetch the data.

Lisa Goldman · ‎03-05-2024

@James Chun

Sorry James!

Here is the table attributes:

James Chun · ‎03-05-2024

Thanks, since the field is a 'String' type, you should also use a string type variable. Once you change the variable type, you can deactivate the Client Script.

Just a tip, make sure these data types are aligned, otherwise you will see unexpected behaviors.

Cheers