Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
In my application there are fields where the end user must be prohibeted to make a discontinuous selection.
If such a field is a dual field or contains numbers it can be done by applying a trigger action on select like:
='>=' & min(FieldName) & '<=' & max(FieldName)
But the difficulty if that my field is of a text type and I don't want to turn it into a dual field. It means that I cannot apply an action like: ='>=' & min(FieldName) & '<=' & max(FieldName)
Is it somehow possible to select from min to max in a text Field based on a FieldIndex? For example: from minimal FieldIndex to maximal Field Index?
Thank you in advance,
Larisa
You need to create the compound search embedding the field values in double quotes when they contain e.g. spaces:
=CONCAT({1} chr(34)&FieldValue('FIELD',ValueLoop(vMinFV,vMaxFV) )&chr(34),'|')
maybe like attached?
Thank you!
Hi Swuel,
As soon as I renamed the field values, it stopped working. Could you please have a look?
Thank you in advance,
Larisa
You need to create the compound search embedding the field values in double quotes when they contain e.g. spaces:
=CONCAT({1} chr(34)&FieldValue('FIELD',ValueLoop(vMinFV,vMaxFV) )&chr(34),'|')
Thanks a lot!