Filter For Status

[subbareddykm]

Hi All,

I m trying to achieve creating filter or list box or Calculated dim  in my app to filter data like following Cse:

PR  without PO

PR without PO  and with IO

PR  with PO

PR  with PO and IO

Invoices  without PR

Invoices  without PR- with IO For reference check attached app

[sunny_talwar]

It might not be a great idea to do this on the front end. Can you rather join the tables and do it in the script?

[subbareddykm]

If i i got chance in back end , then i have some idea .

No problem Sunny give solution for front end . I can manage.

Because i have join so many table now , if we try it in back end now

[subbareddykm]

Please guide ,How to create in front end Sunny.

[sunny_talwar · Accepted solution]

Did it for 2... you can extend the logic

=If(Len(Trim(PR)) > 0 and Len(Trim(IO)) > 0 and Len(Trim(PO)) = 0, 'PR Without PO and With IO',

  If(Len(Trim(PR)) > 0 and Len(Trim(PO)) = 0, 'PR Without PO',

  ))