website design - Building logical criteria (with AND , OR, etc)

I am looking for inspiration on this. We have a Dot.Net web application, where we are building pretty complicated criteria. It works, but I would like to change this, re-shape this, possibly from the ground up.

The idea: Basically there is a background process, we are receiving data. In order for us to parse it, they will set up criteria. We can call it "filter". It probably makes more sense

Example:

1. If the parsed data, has a "created date" field, that is a weekday, then do something


2. If the parsed data, has a "code" field, that contains these letters "ABC", then do something else



3. If the parsed data, has a "amount" field, and that amount is greater than 1000, than do something


4. If the parsed data, has a "color" field, and that is one of these: "red, blue, green", then do something We are going to let the user go even deeper.

Example: If 1 AND 2 AND 3 AND 4 (from above) are all true, then "do something really specific"

You can go even further: If ((1 AND 2) OR (3 AND 4)) , from above, then "do something different"

I hope you see what I mean

So we have basically 2 steps A. let the user introduce 1, 2, 3, 4 somehow B. let the user make it more complicated

This all works. But in a totally non-user-friendly way.

I was wondering if there is something out there, that is well known, easy to use, easy to understand, that is doing the same thing.

I would really like to get some inspiration to rebuild our User Interface, which is currently using too much dropdownlists, checkboxes and such.

Any suggestions?

Answer

Perhaps you will find some inspiration through one of these: