Hyperlink in Launch Pad

[Former Member]

Hi Frnds,

i have status as column in my report. In status i have running, succeeded, warning and Failed as status values.

How can i hyperlink only for warning and Failed status. i dont want hyper-linking on succeeded and running.

Thanks,

Kumar

[Former Member · Accepted solution]

Hi Kumar,

Can you please share screenshot So that we can help you better.

Regards,

Anuj

[Former Member · Accepted solution]

Hi Anuj,

Thanks for your reply..I got it..actually we have to mention that column as Read as hyperlink option then everything worked fine.

Thanks,

Kumar

[Former Member]

Hi Balaji,

You can write code like this-

If [Status]="Warning" Then <Past link of Hyperlink> Elseif [Status]="Failed" Then <Past link of Hyperlink> Else [Status].

regards,

Anuj

[Former Member]

Hi Anuj,

It is working for success but i am getting URL for failed and warning instead i should get hyperlink on failed and warning.

Thanks,

Kumar

[Former Member]

Hi,

why not working with an if statement?

Then you can read the cell as hyperlink and the hyperlynk will only appear for the cases where you wish (e.g. Warning and Failed).

Best regards,

Victor

[Former Member]

Hi Victor,

Thanks for your reply.

what i have done is i have created a Hyperlink variable on status column using hyperlink URL.

One more variable i have created saying

=IF([Hyperlink]="WARNING" AND [Hyperlink]="FAILED";Hyperlink)

i think whatever i have done is wrong.

Regards,
Kumar

[Former Member]

Hi

If you add hyperlink to that column ,whether or not all the LOV in column will effect the hyperlink , but in other way we can achieve  is by making filter  succeeded status in one table and use relative position with other table in that filter only warning and failed and use hyperlink on the second table ,hide header of 2nd table

Hope it will helps u

Regards

Sunil

[Former Member]

Hi Sunil,

You are not getting my point.

I have a report with

Package Name | Start Date | End Date | Status

xyz                       -                    -         Warning

abc                                                      Succeded

qwe                                                      Failed

Regards,

Kumar