Filter Lookup - substringof

Forms
1

Hi there,

I need to setup a Lookup field to be filtered by a multi-choice field, we have done this in the past using substringof in the OData query when using Cross Site lookup, but I cannot seem to get this to work on the form using Plumsail forms, my code is below some pointers would be good -

fd.field('Company_x0020_Name').filter = substringof('Customer',Company_x0020_Type);

Thanks

2

Dear Tony,

Please try your code with double quotes:

fd.field('Company_x0020_Name').filter = "substringof('Customer',Company_x0020_Type)";

3

Hi Alex,

Works as required now.

Thanks again