Display Aggregate in HTML as Text

[gregbovenkerk]

I'm looking to display totals or counts as text in HTML. Specifically, I'm running a sweepstakes and want to display the total number of entries. For instance:

TOTAL NUMBER OF ENTRIES: 2,387

 

I know there's got to be an easy solution. Thanks in advance for your help.

[Vitalikssssss]

Hi @gregbovenkerk,

What Datapage type do you use? 

It is possible to add Total & Aggregation field  on Tabular report in order to get count of records.

You can check this article:

https://howto.caspio.com/datapages/reports/advanced-reporting/totals-and-aggregations/

Hope this helps.

Regards,

Vitalikssssss

[gregbovenkerk]

Thanks @Vitalikssssss. I was hoping to not use a table at all and instead, have a line of text. Is there another option? Thanks -

[Vitalikssssss]

@gregbovenkerk, you should consider Calculated value with SQL expression if you would like to show the result on a form (Submission/Details).

This features explained in this articles:

https://howto.caspio.com/datapages/datapage-components/calculated-values/

https://howto.caspio.com/datapages/reports/advanced-reporting/calculations-in-forms-and-reports/

Regards,

vitalikssssss