Jump to content


  • Content count

  • Joined

  • Last visited

1 Follower

About DefinitelyNot31337

  • Rank

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. DefinitelyNot31337

    Javascript Condition/show message

    Hello @PeterOConnor, Firstly, I would like to suggest to utilize the DataType of List - String. It would be much easier to do that. However, if you wouldn't want do that due to other dependencies, let's do some custom coding. Assuming this is a Details DataPage / Drilldown, you'd just need to replace '=' to '+=' after each 'innerHTML' In your case: ... document.getElementById("Category").innerHTML += "Retailer"; ... document.getElementById("Category").innerHTML += "Farmer"; ... And so on. You may want to see and inspect this DataPage I have created. Do note that I assumed that this is a Details Drilldown. If this is not the case (if you are referring to the Table, Gallery, or List), then we should not be using `<p id="Category"></p>`, at all, as a placeholder. Please let me know if this works. I hope this helps. D.N.31337
  2. DefinitelyNot31337

    Need to notify users that they would be logged out

    Hello @TroubleShooter, You may try to add this snippet of JavaScript Code in the footer (source) of your DataPage. Just read through the inline comments (//). Works for me in all DataPages where you can insert a Footer. <script> // Edit the values here to your liking var message = 'You will be logged out after [x] minutes. Please save your work to prevent input loss.'; var hour = 0; var min = 0; var sec = 3; // It is not necessary to edit things beyond this point //Do not edit the Hour, Min, Sec here. They are used as a Default Value! setTimeout(function(hour=0, min=0, sec=1) { //Do stuff here //Get Time Reference var timeRef = new Date().toLocaleTimeString('en-US'); //Show the timeRef and the Message alert('[' + timeRef + '] ' + message); //You can also do other stuff below such as (displaying a div, auto-press the save button, etc...) }, (hour*1000*60*60 + min*1000*60 + sec*1000) ); </script> Disclaimer: Use these JavaScript solutions at your own risk! They are provided to assist you in the customization of your programs and while we believe they work properly, by using them you accept all responsibility about them and confirm that they are not a feature of Caspio's platforms and as such are provided "as is" without any warranties, support or guarantees.
  3. DefinitelyNot31337

    SQL and HTML Injection

    Hi Casey, For SQL Injection: Caspio's development team is following secure coding guidelines and best practices. They use parameterized SQL queries and escape all untrusted input data (for dynamic SQL), no matter this data was received from HTTPS request, their database or from somewhere else. Also, they perform periodical security audits, and testing for stored SQL injections is a mandatory part of these audits. If you have any suspicious attack vectors – please report them to the Caspio Support team so they can check it for potential SQL injections. For HTML Injection: Just make sure that unauthorized people are not allowed to edit your source files, and avoid importing from untrusted sources, then you are good. Hope this helps.
  4. DefinitelyNot31337

    Sql Error

    Hi @theconav, Please try adding the target keyword in your calculation. The target keyword means that you refer to the current row in your table. Documentation located here. The result should look like this: SELECT Sum(FieldTwo) From tTable_Name WHERE tTable_Name_Field = target.[@field:FieldOne]
  5. DefinitelyNot31337

    Resizing an Iframe

    Hi @pbullock, If you happen to to have the HTML <body> tag as the parent element of your iFrame, you may want to try this code over here. Works well for me as viewed in Google Chrome. <body style="margin:0px;padding:0px;overflow:hidden"> <iframe src="[your iframe deployment src without brackets]" frameborder="0" style="overflow:hidden;overflow-x:hidden;overflow-y:hidden;height:100%;width:100%;position:absolute;top:0px;left:0px;right:0px;bottom:0px" height="100%" width="100%"></iframe> </body> Hope this helps.