Jump to content
  • 0
AdamS

Pass column total values to html page and/or virtual field

Question

I am trying to pass the value from specific column totals for use in html page(s) and/or virtual fields. Any help is appreciated.

e.g. table with 3 columns and n rows

I want to retrieve and pass the total value of column 1, column 2 and column 3 for use on a different webpage or for a custom html field

Thanks in advance

screenshot_caspio.png

Share this post


Link to post
Share on other sites

1 answer to this question

Recommended Posts

  • 0

Hi AdamS,

I am afraid that you cannot pass Total & Aggregation field value.

I would recommend using calculated field with SQL expression in order to display table sum value in Datapage which has a different datasource table.

Here is an example of SQL expression:

SELECT SUM(Sales) FROM Sales_By_Region_TBL WHERE SaleRep_ID = target.[@field:SaleRep_ID] 

Hope this helps.

Regards,

vitalikssssss

Share this post


Link to post
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...

×
×
  • Create New...