Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
May be like:
=if(max(if (Email= z_Email,1,0))=1 and sum(Actuals)>0,1,0)
Not sure I understand what you are doing, would you be able to elaborate? and provide a sample may be?
may be try this in text box expression?
=GetFieldSelections(zemail ,'; ')
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
Email include two values of z-Email? I am still not sure I understand, would you be able to provide a sample?
May be like:
=if(max(if (Email= z_Email,1,0))=1 and sum(Actuals)>0,1,0)
Thanks, that helped!
Regards,
Prajna