Changing value in a column of tabular report

[DDNex]

I have a tabular report with a few calculated fiekls.  I want to add an html filed in the report that will conditionally display a link based upon a value in one of the columns.

 

Thanks in advance

[Kurumi]

Hello @DDNex,

Are you referring to conditional show of link based on the a certain value?  If yes, you can create a Calculated Field to get this value then use the Calculated field in the HTML Block.

Calculated Field Formula:

CASE WHEN [@field:Requested_Action]='Update Sales'
THEN 'https:<yourlink>?Request_ID=[@field:Request_ID]'
ELSE
'https:<yourlink>?Request_ID=[@field:Request_ID]'
END

Then add  this in HTML Block:
 

<a href="[@calcfield:1]">View Request</a>

In the Report, you will see the Calculated field, if you would like to hide this, you can refer to this post:

I hope it helps.

[DDNex]

Do I have to have the calculated field? Can I do the Case statement in an HTML block?

 

Thanks

[sandy159]

Hello @DDNex,

HTML blocks can be added to the DataPage for adding descriptive text, links or graphics to your DataPages. They can also be used to add snippets of JavaScript, HTML or CSS.

For the Conditional Cases, you need to use Calculated Fields. You may check this article: https://howto.caspio.com/datapages/reports/advanced-reporting/calculations-in-forms-and-reports/

So the answer is yes, you need to have the calculated field.

Regards