Use Expression in Search box

[bhavikumehta]

Hello,

I have an expression to be used in Search box. For example:

=if(field1='ABC', field2, field3)

All 3 fields are in different tables.

Requirement is to have a Search box to search based on field2 or field3 based on value of field1.

Please suggest a solution. Thank you.

[ahaahaaha]

Hi,

Mae be like as at attached file?

Regards,

Andrey