Can anyone help please?

[#1]

Hello all,

I have a query which I hope will be simple!!

I have a field named GROUPNAME and I'd like to conditionally hide a text box if a value within the GROUPNAME equals 'AEUSERS'.

I've been trying the match function but I can't get it to work, I feel like I'm so close!

Any help is greatly appreciated.

[israrkhan]

try below: in conditional show

=If(GROUPNAME ='AEUSERS',1,0)

[#3]

That does hide the text box but only if the value 'AEUSERS' is selected.

That isn't what I want, I want to hide the box if 'AEUSERS' exists in the field, without selecting anything.

[#4]

It must be easy to identify if there is a value in a field. For instance get 1 or 0 if AEUSERS exists in your column or get the number it shows up.

Then you will set a variable to get this value. In your box you will set a conditional variable=....

[bruno_m_santos · Accepted solution]

Try

If(FieldIndex('GROUPNAME','AEUSERS') >0 ,1,0)

Thanks

Bruno

[israrkhan]

THEN LOAD IN THE SCRIPT LIKE BELOW:

LOAD ABC,

EDC,

IF(GROUPNAME ='AEUSERS', 1,0) as Flag

FROM ....

THEN IN THE TEXT BOX USE EXPRESSION LIKE BELOW:

IF(Flag =1,1,0)

WILL; WORK....

[#7]

You can make your object show/hide by a conditional variable=1

Then you set your variable value as

=If(FieldIndex('GROUPNAME','AEUSERS') >0 ,1,0)

If it exists in the field you will get 1 and the object will appear.