Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a Multi Box Object as
Options->A
B
C
D
I am creating a button which on selecting should change the values in the Multi Box to A, B and C.
The usual way is
-Create an Action
-Select In Field
-Give the field name in Field
-Enter Search String in the Search String.
I am able to write ='A' in the Search String. How do I write multiple values in the Search String.
(A|B|C)
Try
("A"|"B"|"C")
[without a leading equal sign]
Thanks guys. Let me try it and get back to you.
Can we use not to select one particular value and select the rest?
In this case, how can we select A,B,C but not D?
The reason am asking about excluding a value is because, if my options are too many, it's easier to exclude a single value rather than including too many values.
For example, if I have to select A to Y but not Z, easier would be excluding 'Z' rather than defining all 25 values.
swuehl,
Should this work in the requirement I gave here? I tried but I don't see the button selecting A to Y but not Z in my case.
I am creating a button and adding "Select in Field'' action. How do I define Search String here if I have to select alphabets A to Y but not Z in my Multi Box, when I click the button?
Seems to work for me
Hi Swuehl,
You are generating the Data using
LOAD Chr(ORD('A')+REcno()-1) as Char
Autogenerate 26;
This itself is selecting A to Y and excluding Z, right?
I need to create an Action in a button using 'Select in Field' so that when i click the button, A to Y values are selected, leaving 'Z'. This should happen after I select the button, not by default. I need to mention some logic in the 'Search String' field of Buttons->Actions->Select in Field->Search String