Jump to content


  • Content Count

  • Joined

  • Last visited

  • Days Won


Everything posted by princezuko

  1. 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.
  2. 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)
  3. 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*]">
  4. 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:
  5. 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:
  6. 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
  7. 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.
  8. 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.
  9. 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/
  10. '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.
  11. 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.
  12. Hello, If you're using a Number, Currency or Integer Data Type for your search fields in your DataPage, you may apply the range as a comparison type as long as you're using a Radio button, Drop down or List box Form Elements. Range is also available when using special elements such as Cascading Radio button, Drop down or List box. Please refer to the screenshot attached for reference:
  13. Yes, that's possible. You may try this formula: CASE WHEN len([@field:Minutes]) = 1 then '0'+Str([@field:Minutes]) ELSE str([@field:Minutes]) end
  14. Just want to give an example on this. If you have a Home page with a centralized login and you want all users to login from Home page, when they tried to open another page (e.g. Dashboard page), they will be redirected to your Home page. Below is a use case. You have 3 web pages: 1. Dashboard page (dashboard.html). This has 5 DataPages deployed in it. There will be 5 login forms displayed on it. 2. Profile page (myprofile.html). This has 2 DataPages deployed in it. 3. Welcome page (home.html). This has only one DataPage deployed in it. You want all users regardless on from where they come from to see only one centralized login form (not 5 or 2), and you want all users to be redirected to your Dashboard page after login. You set up a “designated entry page” to be home.html, and “login redirection on success” to be dashboard.html. Then, when non-authenticated user opens dashboard.html, they will be redirected to home.html with one login form, and after successful login they will got redirected to dashboard.html. If non-authenticated user tries to open myprofile.html, they will be redirected to home.html, where they will need to enter login information, and then they will be redirected to dashboard.html (as all users after successful login go to Dashboard page). If authenticated user opens any page, they will not be redirected and will stay on the page they opened.
  15. I've tried this and it worked for me. I'm glad there's an existing forum answer regarding this question.
  • Create New...