Display Image in Calculated field

[MyMelody]

Hi ,

 

I have a calculated field on my Reports DataPage. If the age of the user is greater than or equal 18, then it will display the details of the contact person assigned. It is working properly. However, I would also like a picture to appear. How do I add a picture to the formula in the calculated field?

 

Thanks.

[cheonsa]

Hi @MyMelody,

 

This can't be done using a calculated field alone. You will also be needing HTML Blocks.

First, the photo must be saved inside your Caspo Bridge under All Assets > File. http://prntscr.com/mizlbp

You need to create an app parameter to be called on your calculated field.
http://prntscr.com/mizlzi
https://howto.caspio.com/apps/app-parameters/

Then on your DataPage, insert two calculated fields. One is for the image (http://prntscr.com/mktprf) and the other one is for the text (http://prntscr.com/mktpfj).

Insert an HTML Block to display the result of the calculated field as an image. 
http://prntscr.com/mizoyq
Click the source button and insert this code: 
<img src="[@calcfield:1/]" >

Lastly, you need to hide this calculated field using two HTML Blocks. You can use this link for reference:
https://howto.caspio.com/tech-tips-and-articles/common-customizations/how-to-hide-fields-in-datapages/

Hope this helps.

 

- kristina

[JolliBeng]

Hi MyMelody,

For the image to be displayed, FileStor must be enabled first.

However, this feature is not available on all Caspio plans. 

 

-JolliBeng

[Chuchu]

Hi  

 I'm having a problem trying to display the image,  everything looks good except fot the image.  Any thougths? 

[MayMusic]

For the picture to appear you need to have a javascript code as HTML cannot be combined with SQL syntax