Jump to content
  • 0

Display Result of Calculated Virtual Field as HTML Not Text


Becca37
 Share

Question

Good morning :0)

I have an Single Record Update DataPage that pulls in a list of information from another table using  a query in a virtual field calculated value formula. 

This is great as far as it goes, I get the data I'm expecting and with the HTML tags (unordered list) I need.

But I WANT (need ; have ; would really be best) to be able to display that resultant listing as HTML and I can't find a way to do that. 

How do I make Caspio bend to my will? {insertEvilLaughterHere}

2019-04-18_7-57-30.png.bc0980e65281263594db5ae470ddd338.png

2019-04-18_7-58-00.thumb.png.97f06d27ff87886582ae203b0fce17ff.png

 

Link to comment
Share on other sites

2 answers to this question

Recommended Posts

  • 0

Hi - Could you use Details Report DataPage instead of single record update ( to enable editing of the fields select TEXT from FORM ELEMENT). Use "Calculated Field" and paste your formula there. Then add two HTML block, first HTML block is on top of your calculate field and the other is at the bottom.

Paste this  script on your first HTML block
[@calcfield:1!]
<table style="display: none;">

Then this script on your second HTML block:
</table>

image.png.0f589b6cc0486c3acbabc08f90450ea8.png

Actual Result

image.png.4d07be5ff75f0d692b10eb7418a6db75.png

I hope this help.

Link to comment
Share on other sites

  • 0

@SunakoChan ... thanks, that worked beautifully! (Except for having to essentially recreate the entire page / rules / etc. as a "details page" instead of a "single record update form" -- sure wish Caspio had more consistency with how things work across page types, or would (much more simply) allow us to set display type on calcuated and virtual fields anywhere they appear.)

2019-04-19_7-55-29.thumb.png.52bf92586ccd02942651fb32aac3206b.png

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...