Specific entry allow

Hi,

I want to create an entry form for which I need a valid expression. I want to allow entry based on its start value and end value. I have made it in one sheet which has all the start value and end value. The name of our sheet is "Flyer list". 

Below mentioned expression not working properly could you please help me. 

Screenshot_20240215-232745.png

โ€ƒ

and(
isnotblank([AWB NO]),
isnotblank(
filter(
"FLYER LIST",
Or(
endswith([AWB NO], [END FLYER NO]),
startswith([AWB NO], [START FLYER NO])
)
)
)
)

0 0 25
0 REPLIES 0
Top Labels in this Space