calculated field to create a url with parameters

[Jodie]

Ok - so this has me completely stumped. In a report table I've been able to create a calculated field that I can then read into html that provides a link with all the right parameters to pass based on the record details.  

This is what I used to create the link:

CASE WHEN ([@calcfield:6]) =0  THEN "No action"
ELSE '<a href="https://picklework.com/manager-skills/skills-endorsement/?AsID=' +CAST([@calcfield:7] AS varchar) +  '">Evaluate</a>'
END

But I just can't get a similar formula to work in a details page of a report. I've played with so many different formats and just can't see what I'm doing wrong. This is my latest attempt:

CASE WHEN [@calcfield:1] >= [@field:count1]  THEN "Complete"
WHEN  [@calcfield:11] >= [@field:count1] THEN "Waiting approval"
ELSE "<a href='https://www.picklework.com/employee/program-progress/?ProgID=" + CAST([@field:progid#] AS varchar) + "&item=" + CAST([@field:mod1#] AS varchar) + "&num=1&erid=" + CAST([@field:enrolid#] AS varchar) +"'>Add item</a>"
END

This is what is returned:

<a href='https://www.picklework.com/employee/program-progress/?ProgID=+ISNULL(CONVERT(nvarchar(max),&item=+ISNULL(CONVERT(nvarchar(max),&num=1&erid=+ISNULL(CONVERT(nvarchar(max),'>Add item</a>

Any ideas on what I'm doing wrong here??? Any help would be much appreciated. Thanks

[Ilyrian]

Hi @Jodie

I have tried this on my account and I got the formula verified:
 

<a href="www.google.com?ProgID=CAST([@field:Customer] AS varchar)&item=CAST([@field:DateFrom] AS varchar)&num=1&erid=CAST([@field:Customer] AS varchar)">Add item</a>'

You can try the following:

 

CASE 
WHEN [@calcfield:1] >= [@field:count1]  THEN 'Complete'
WHEN [@calcfield:11] >= [@field:count1] THEN 'Waiting approval'
ELSE '<a href="https://www.picklework.com/employee/program-progress/?ProgID=CAST([@field:progid#] AS varchar)&item=CAST([@field:mod1#] AS varchar)&num=1&erid=CAST([@field:enrolid#] AS varchar)">Add item</a>'
END

After you are done with the formula you can follow the steps from the article below on how to render HTML inside the Calculated field: 
One way to do this is to add an HTML Block, inside the HTML Block add your calculated field and set it as HTML. You could then use some CSS to hide the calculated field. In the forum post below all the steps are explained. 

 

[Jodie]

Thanks for responding Ilyrian, whilst  the formula showed as verified in my account too it still didn't return the field values.  Caspio Support suggested blocking the " mark and that finally worked.