continuous selection

[Anonymous]

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

[swuehl]

maybe like attached?

[Anonymous]

Thank you!

[Anonymous]

Hi Swuel,

As soon as I renamed the field values, it stopped working. Could you please have a look?

Thank you in advance,

Larisa

[swuehl · Accepted solution]

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),'|')

[Anonymous]

Thanks a lot!