Conditional Text On Report

[Master]

I want to show a link to another page if the vale of a field is "Not Completed" in a report page, can you please help?

[MayMusic]

You can add an HTML Block to your report and use this code:

<script>

if ("[@field:FIELDNAME]" == "Not Completed") {
document.write("<a href='http://caspio.com'> Click Here</a>");
}
</script>

Replace the link and also FIELDNAME in the code above

[swipebox]

This worked for me, too! Thank you. I'm a little stuck on what I'm trying to accomplish, however.

 

I need one additional "else" statement (I think). Basically, if the value is "YES" then show text and/or hyperlink, but if value is "NO" show different text and/or hyperlink.

 

Any  help you could provide would be awesome!

[Jan]

Hello swipebox,

I think, you can use the code with "else" statement like this:

<script>
if ("[@field:FIELDNAME]" == "Not Completed") {
document.write("Text and link if yes <a href='http://caspio.com'> Click Here</a>");
}
else {
document.write("Another Text and link <a href='http://caspio.com'> Another link</a>");
}
</script>