Jump to content

Search the Community

Showing results for tags 'calculated field'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


  • Caspio Bridge
    • General Questions
    • Caspio JavaScript Solutions
    • Tables, Views and Relationships
    • Import/Export and DataHub
    • DataPages
    • Deployment
    • Security, Authentications, Roles, SAML
    • Styles and Localizations
    • Parameters
    • API and Integration
    • Calculations and aggregations
    • User JavaScript and CSS Discussions

Find results in...

Find results that contain...

Date Created

  • Start


Last Updated

  • Start


Filter by number of...


  • Start




Website URL






  1. I'm trying to use a calculated field for a Sum in another calculated field on a tabular datapage (the aggregation won't work for this particular sum, as the sums are for group headers). This is a complicated series of totals so hopefully the process can be followed through. a) I have 2 calculated fields (that are SELECT) to determine some totals and then a 3rd calculated field that 'decides' which one to use for it's own value: Calculated Field:3 CASE WHEN myfield=1 THEN [@calcfield:1] ELSE [@calcfield:2] END I need to now do a Sum
  2. I have a tabular report with search page . In the search page, I send a parameter with a start date on which I seek ( [ @beginyear ] ) to the resulting page . In the Calculated Field in the resultpage i like to have: search date ( [ @ beginning year ] = 1-1-2016 Record: Start date item item [ @field : begin_date_item ] = 5-5-2016 result: Calculated Field = 5-5-2016 [@field: begin_date_item ] Or Record: Start date item item [@field: begin_date_item ] = 12-4-2015 result: Calculted Field = 1-1-2016 ( [ @ beginning year ] Unfortunately, this do
  3. Hi all, Is it possible to process HTML in an Calculated Field. In the code below, I would like to change the text in an image. CASE WHEN [@field:PAARD_KOPPELINGEN_soort_koppeling]= 1 THEN 'Ruiter/Verzorger koppeling: [@field:GEBRUIKERS_volledige_naam]' ELSE 'Stal medewerker koppeling: [@field:STAL_GEGEVENS_stalnaam]' END Regards Peter
  4. Hi, as the Title suggests, I want to aggregate calculated fields. This is not allowed via a standard Aggregation. Is there a workaround for this? Thanks
  5. Hi all, I want to hide the submit button in a details page based on the value of five calculated fields. I saw this post from before: http://forums.caspio.com/index.php/topic/5131-hide-button-based-on-calculated-field/ Based on the advice there, I came up with the following: <script language="javascript"> var stat='[@calcfield:2]'; if (stat.length='Not Equal, please revise figures') { coauthor = stat; document.write(stat); document.getElementById("Mod0EditRecord").style.display = "none"; } </script> But I have been unable to get that script to work for me properly.
  6. Hello; I am working with a report and aggregate functions. I am trying to get a percentage toward a goal. ((COUNT_NON_BLANK [@tblActionLog_ActionCompletionDT]) / (MIN [@pUser_QFGoalWeek])) Should result in a percentage for completed QuotesFinished to QuotesFinishedPerWeekGoal, but it results in zero. For diagnostic purposes I've checked the following formulas... COUNT_NON_BLANK [@tblActionLog_ActionCompletionDT] = 2 (correct) (MIN [@pUser_QFGoalWeek])) = 10 (correct) ((MIN [@pUser_QFGoalWeek]) / (COUNT_NON_BLANK [@tblActionLog_ActionCompletionDT])) = 500.00% (correct)
  7. I inserted a "Calculated Field" as a "Datapage Element." I used the calculated value but do not want the calculated value to show up on the "Details Page." How do I hide a Calculated Field from showing up on the "Details Page?" I need to keep it as a Datapage Element; however, I do not need the value displayed in the Details Page. Thanks, Thor
  8. I'm using the below select statement in a calculated field, the resultset works great in the html grid when I fire the datapage, but when I export the datapage the columns are blank. I am able to get results if I change the values from 'true' and 'false' to 1 and 0. Has anyone run into this? We would like the text value of either 'true/false' or 'yes/no' Thanks, -John select case when sum(b.CCO_Place_Points) > [@field:State_Points_Required_Required_Points] then 'True' else 'False' end from JRRESULTSTABLENEW a join Lookup_Places_2 b on b.CCO_Place_ID = a.CCO_PlaceID where a.Me
  • Create New...