Jump to content
  • 0

How do I Count Data in Fields?



11 answers to this question

Recommended Posts

  • 0

Below are some documentations that can help you with this:

  1. Calculations in Reports - https://howto.caspio.com/datapages/reports/advanced-reporting/calculations-in-forms-and-reports/ 
    • Here you can find an example for using Subqueries in Calculated Fields. Calculated fields also support the SELECT statement to get values from the same or other tables.
  2. Calculated Valueshttps://howto.caspio.com/datapages/datapage-components/calculated-values/


On 11/29/2018 at 9:09 PM, techguy said:

any way I can do a Select count statement within an html datapage?

Link to comment
Share on other sites

  • 0

As an extension of this question. 

I want to create 'user friendly' IDs using names to create unique IDs. eg. John Smith would SMIJ01, and the second John Smith would be SMIJ02

Can anyone point me in the right direction as to how to do this with triggered actions?



Link to comment
Share on other sites

  • 0

Hi @Felix, this is what I use on my app to create a user friendly unique IDs. I utilize their Submission Form DataPage's Calculated Value which allows me create a formula that will combine the input field for Code (For example: JS derived from John Smith) and an ID (For example: 1).



Here is an example before submit: 



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.

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.

  • Create New...