Jump to content


Caspio Ninja
  • Posts

  • Joined

  • Last visited

  • Days Won


Everything posted by princezuko

  1. Hello, You may also utilize parameters to achieve this workflow and tweak the code in this article a little to make it work: https://howto.caspio.com/tech-tips-and-articles/common-customizations/create-user-specific-redirect-after-login/
  2. I would like to add an 'IF ELSE' condition inside my Trigger, but instead of the receiving field, I would like it to be the selecting value. I'm not sure if that's doable so I'm wondering if there is a way to achieve that.
  3. I have a DataPage with a dropdown field. I'm using a look-up table as values for this but I would like a dropdown value to be deleted when it's submitted on the form and added to the table. How can I do that?
  4. Hi I would like to stamp the username of the person logged in to my authenticated DataPage when a specific field is modified. How do I do that?
  5. Hi, I had the same issue before and what I did to resolve it is to configure the file format from the 'Configure Table File Formats' wizard. On this page, you will see a dropdown where you can select two options, 'First row contains field names' and 'Does not contain field names'. You may select the first one to display the actual name from your CSV file. Here's a screenshot for reference:
  6. That seems helpful but if I want the timestamp to be updated only when a specific field is modified, is that also possible?
  7. I would like to update the timestamp whenever a record is updated or modified. How can I do that using Triggered Actions?
  8. That's helpful! Are there other learning materials that I can use as references?
  9. How about for submission forms, what is the maximum number of calculated values that I can add on the DataPage?
  10. 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?
  11. 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?
  12. 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?
  13. 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]))
  14. 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.
  15. 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: { text: 'Insert Text Here', align: 'left', x: 70 } }); cleaner(interv); } }, 200); } </script> Note: You have to insert the title that you want to use directly on this code. To do that, simply replace the text *Insert Text Here* with the title that you want to set for your chart.
  16. 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)
  17. 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 the Advanced tab. 4. Lastly, add this HTML code and insert the app parameter between the two double quotation marks using the picker. <img src="[*Add your app parameter here*]">
  18. 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:
  19. 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:
  20. 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
  21. 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.
  22. 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.
  23. 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/
  24. '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.
  25. 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.
  • Create New...