Including fuzzy search on selection

[#1]

Hi,

I would like to filter data based on selected string value.

ex: I have fields email  and zemail.

On selected email =CCmark I can see two fields related in zemail like CCmark,NPCargo.

So I want a text box selected on selection of data having zemail= CCmark when I click email =CCmark .I tried wildmatch but it didn't work.

Can anyone suggest  me a better approach.

[sunny_talwar]

Not sure I understand what you are doing, would you be able to elaborate? and provide a sample may be?

[Anonymous]

may be try this in text box expression?

=GetFieldSelections(zemail ,'; ')

[#4]

What I am trying to do is , I am making a conditional display of a text box object.

In layout I have mentioned

=if(GetFieldSelections(Email)= z_Email and sum(Actuals)>0,1,0)

The prob what am facing here is zemail is giving two values but I want the wont that matches with email alone.

Hope this helps!

Thanks,

Prajna

[sunny_talwar]

Email include two values of z-Email? I am still not sure I understand, would you be able to provide a sample?

[tresesco · Accepted solution]

May be like:

=if(max(if (Email= z_Email,1,0))=1 and sum(Actuals)>0,1,0)

[#7]

Thanks, that helped!

Regards,

Prajna