-
Content Count
23 -
Joined
-
Last visited
-
Days Won
1
princezuko last won the day on November 7 2019
princezuko had the most liked content!
About princezuko
-
Rank
Member
Recent Profile Visitors
The recent visitors block is disabled and is not being shown to other users.
-
Maximum Number of Calculated Fields in a DataPage
princezuko replied to princezuko's question in Calculations and aggregations
That's helpful! Are there other learning materials that I can use as references? -
Maximum Number of Calculated Fields in a DataPage
princezuko replied to princezuko's question in Calculations and aggregations
How about for submission forms, what is the maximum number of calculated values that I can add on the DataPage? -
Maximum Number of Calculated Fields in a DataPage
princezuko posted a question in Calculations and aggregations
I'm trying to create an application that deals with many calculations. Before I start building my app, I would like to know how many calculated fields can I add to a Reports DataPage? -
I'm looking for a workaround to remove a value on my dropdown field if it was already selected by one of my users and submitted using a submission form. Is that possible?
-
I have a submission form that has a text area wherein the rich text editor is enabled. Whenever I submit records,there are some unnecessary special characters that are found on my table for this particular field which I don't remember entering. For example, if I enter the word "don't", it appears on the table as "don't". Is there any way to avoid this?
-
Formula to get the percentage contribution of each record
princezuko replied to astroboy's question in Calculations and aggregations
If you want to calculate the contribution for a specific filter, you may try adding a Where criteria that utilizes 'target'. You may refer to this formula: (([@field:NumberField]/(SELECT SUM (NumberField) From Table))*100 WHERE Company_ID=target.[@field:Company_ID])) -
Formula to get the percentage contribution of each record
princezuko replied to astroboy's question in Calculations and aggregations
You may try this formula, however, this only works on the DataPage level: ([@field:NumberField]/(SELECT SUM (NumberField) From Table))*100 Please make sure to replace the field names according to your table design. -
Hi Astroboy, I have a piece of Javascript code with me that might do the trick for you. You may paste this code on the footer inside your DataPage, but make sure to disable the HTML editor on the advanced tab. Here's the code: <script type="text/javascript"> document.addEventListener('DataPageReady', chartUpdateHandler) function chartUpdateHandler(event) { var cleaner = function(interv) { clearInterval(interv); } let interv = setInterval(() => { if (!!Highcharts.charts[0]) { console.log(Highcharts.charts[0]); Highcharts.charts[0].update({ title: { t
-
Hi Astroboy, There's actually a way to add logos/images in your DataPages that are directly uploaded to Caspio. Here are the steps to do this: 1. Add a new App Parameter inside your application. This can be found on your App Overview > App Parameters > Manage 2. Under App Parameters, click on new then set a parameter name and change the data type from 'Text' to 'File'. Upload an image by clicking the add file button under 'Value' and click on save. 3. Go to your DataPage configuration and add a Header & Footer or HTML Block. Make sure to disable the HTML editor under th
-
Caspio actually released a new feature which automatically allows your application to be responsive without adding a piece of code. You may check more of that here:
-
Making Caspio Forms Responsive / Mobile Design
princezuko replied to pisaacs's question in DataPages
Caspio actually released a new feature which automatically allows your application to be responsive without adding a piece of code. You may check more of that here:- 12 replies
-
Duplicate Table Without Sharing Tables
princezuko replied to astroboy's question in Tables, Views and Relationships
Since you want to copy the table to another app without sharing tables, you may do so by following these steps: Duplicate the table to make another copy → Share the table to your other application → Detach the table to remove it from the application -
If your schedule doesn't match the schedule of the training, you might want to check these videos instead on your best time: Basic Training with Caspio - Introduction to Application Building - https://www.youtube.com/watch?v=TEB-8O0cJZ0 Intermediate Training with Caspio - Application Architecture and Authentication - https://www.youtube.com/watch?v=X8HZC3mBSPg Advanced Training with Caspio - Database Relationships and Passing Parameters - https://www.youtube.com/watch?v=CYcBQSb7dWs However, it would be best to attend the training so your questions can be addressed right away.
-
For this instance, it is recommended to split up your files to avoid reaching the maximum limit for exporting using task. However, this will still depend on your workflow, files and file types.