Hi Kefsid,

You can add links at the main menu Settings->Links->Add web link. Then in the dialogue use drop down list "Insert field values" to insert your key field to the link address.
Then you can add several web views and using "Link" button choose corresponding link.

If this is not the case, can you attach an example IOK file and explain in more details what you are trying to achieve.

As you can see from attached document each of our website has different system and unique "ids".. if i m able to write a simple formula, i d do something like this if(website=httl.com,x.com/processid=ids,if/website=hrro.com/processid=ids,ttl.com/processid=ids)

Hi Kefsid - You can use the IF function in Omniscope, in a similar way to Excel.
You can add a formula field in the Table view or add it through DataManager in a Field Organiser block. Each cascading IF statement is effectively 'false' statement for the previous one.

IF([Website]="hottl.com", "HttpsA",
IF([Website]="hrro.com", "httpsaB",
IF([Website]="ttl.com", "httpsC")))

You also need to tell Omniscope that this field contains web links.
In field type Options (right click on the field) > show link in cell>add web link

There's a voting process going on our Forum, and people are voting for development ideas to be included in next version. One of the ideas is for Omniscope to automatically recognise a web link. You can vote on
http://forums.visokio.com/discussion/1407

Omniscope supports simpler IF statements. The above Excel syntax will work, but all you need in Omniscope is:

IF(
[Website]="hottl.com", "HttpsA",
[Website]="hrro.com", "httpsaB",
[Website]="ttl.com", "httpsC"
)

Thanx a lot, i didnt know that i could use a formula to add a weblink.. actually didnt even try..

how about (if expr1 and expr2) is there a syntax for this one in omniscope?

Same as Excel. IF(condition, resultIfTrue, resultIfFalse) accepts a boolean condition which can be AND(expr1, expr2, ...), OR(expr1, expr2, ...), AND(OR(...), OR(...)), etc.:

IF(
AND(expr1, expr2, expr3, ...),
resultIfTrue,
resultIfFalse
)

NB. we also support multi-choice syntax:

IF(
conditionA,
resultA,
conditionB,
resultB,
conditionC,
resultC,
...
resultOther
)