Search the Community
Showing results for tags 'calculated fields'.
-
Hi all, Is it easy to calculate the total number of records in a table to display on a data page? I was thinking of creating a landing page with summary data on it including some record totals. Thanks! JC
-
Hello, I often use the following SQL code to create a calculated field which concatenates elements of a list with a character separating them (here is it a vertical bar "|"). For instance, here I am creating a list of all the common names for a given plantID (CPCNumber) in the table tblPlantCommonNames. Is there a way to create this code but remove the character from the end of the list? SELECT CAST( CommonName AS nvarchar) + N' | ' FROM tblPlantCommonName WHERE CPCNum = [@field:CPCNumer] for xml path(N'')
-
Hello - I need help for custom JS to compute and display the Calibration_Due in a submission form when the user inputs the Last_Calibration date and the Calibration_Frequency · Calibration_Due = Last_Calibration + Calibration_Frequency Where field types are Calibration_Due – date Last_Calibration – date Calibration_Frequency – number of months
- 4 replies
-
- date
- calculated fields
-
(and 1 more)
Tagged with:
-
Working With Calculated Age From Date Of Birth
clicknip posted a question in Calculations and aggregations
I have a table that includes the person's date of birth (DOB). I am able to create a virtual field in my Report DataPage that calculates the age from the DOB and display it. I also need to be able to search on age. How can I do searches such as: 1. Age is equal to x 2. Age is greater than x (minimum age is x) 3. Age is greater than minimum x and less than maximum y Thank you for any help on this. The application has to do with booking models, where age is an important factor. -
Is it possible to hide entire rows of data in a tabular results page based on a Calculated field Value using JS? Essentially, I have a search and report to return records based on predefined criteria. However, one criteria that I would like to filter by is not stored directly in the table (Table A). It is stored in another table (table B ). So I have a calculated field holding a SQL Query to return a number based on the records from the other table (table B ). I would like to then see if there is a way to hide all records returned that are returned with a Value of 0 from the Table A Tabula
- 1 reply
-
- SQL
- JavaScript
-
(and 5 more)
Tagged with:
-
Calculate A % Of Records Where Columnvalue=X Using Sql
codell posted a question in Calculations and aggregations
Hello, I am looking for help on a solution I am hoping to implement. I will do my best to be clear and include all necessary information but please let me know if you have any questions. I believe this can be accomplished with SQL but am not familiar enough with SQL to begin this on my own. I have a search and report datapage (tabular) that pulls information from Table A. Table A has columns including Client, Project, Asset, Task, and Status where a client can have multiple projects, a project can have multiple assets, assets can have multiple tasks and each task has a status (See Tabl- 2 replies
-
- SQLSearch and Report
- Calculated Fields
-
(and 1 more)
Tagged with:
-
Brand new to Caspio and have been using a trial to evaluate. Very close to signing up and using it as our vehicle of choice to build a new CRM system (we currently use Zoho) One question: I understand how to use calculated fields within reports, but it is not clear (if possible) how to make a field content dependent on another at the time of data entry. eg Business is introduced to us for which we pay a commission. Certain parties (through reputation or volume) are entitled/demand alternative terms. What I would like to know is - through a drop down list - is:- Q: Commission tarif