princezuko

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?

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]))

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

Hello Astroboy, You may use this formula to concatenate these two fields without changing the format of the date and time field. Please refer to this formula and modify it according to your field names: '[@field:Text_Field]' + CONVERT(VARCHAR, [@field:Date_&_Time_Field], 22)

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:

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:

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.

Well if you would like to know more about Caspio it would be great if you will start by having a great foundation about the standard features that they have. They actually offer this service called webinar that is pretty much like a live online tutorial conducted by a trainer. By the way, this one is for free so if you want to check it, here's the link: https://www.caspio.com/training/

'Count Non Blank' is an aggregate function which means that this would work better if used in aggregation. However, I have here a different syntax that is similar to count non blank that you might want to try: SELECT COUNT ([@field name]) FROM Table name WHERE [@field name] != ' ' Just make sure to change the field name and table name according to your table name and design.

If you want to create a task that runs every 15 minutes, you may duplicate the task and set the time 15 minutes apart from one another and set the recurrence every 1 hour. Although this will do the work, it is not highly recommended to run tasks too close from one another because this might cause overlapping. Therefore, 30 minutes gap would be a better option for this.