Jump to content


Caspio Evangelist
  • Content Count

  • Joined

  • Last visited

  • Days Won


Jan last won the day on March 22 2019

Jan had the most liked content!

About Jan

  • Rank
    Advanced Member

Recent Profile Visitors

1,331 profile views
  1. Sudesh

    Hi Jan Please help. 

    I am new to caspio,  JS. I have a attendee checkin screen. I need to validate attendee by entering least on to the validation values to make sure the right person is checkedin. I have 3 validation values, code sent at the time of registration, mobile number and email. I have setup an update for with 3 virtual fields and modified a JS function I found on this forum to check if atleast on of the field is entered and then to check the enter field is same as on record. For some reason the fucntion never get call when I click the update button. below is the code. Really appreciate if someone can point what I am missing/doing wrong. Thanks in advance for your help.

    <script language="Javascript">

     function myFunction()
         var field_code = document.getElementById("cbParamVirtual1").value;
         var field_email = document.getElementById("cbParamVirtual2").value;
         var field_phone = document.getElementById("cbParamVirtual3").value;

     if (field_code == "" && field_phone == "" && field_email == ""){
         alert("Please enter at least one verification value. Please try again.");
         return false;    } 
      else if ( field_code !== "") {
             If  (field_code !== [@field:ER_CODE]{
         alert("Attendee Code did not match. Please try again.");
         return false;                     }

      else if (field_phone !== "") {
          If  (field_phone !== [@field:Phone#]{
         alert("Attendee Phone number did not match. Please try again.");
         return false;                     } 
       else if (field_email !== "") {

       if (field_email !== [@field:Email]) {
         alert("Attendee Email did not match. Please try again.");
         return false;  }
    document.getElementById("caspioform"). Mod0EditRecord = myFunction; 


    Hi Jan,

    Could use your help


    Im trying to change the text of a label.

    script below doesnt work.

    I can get the id , but unable to replace the text.


    What am I doing wrong?


    Ive also loaded it onLoad , so that the html loads before the script,

    but it doesnt work

    Thanks !!



    var label=document.getElementsByTagName('input')[0].id;
    alert("label value=" +label);
    document.getElementById('label').innerText = 'Change The Label Text';

    1. TWIRED



      I have managed to change

      -the label of a virtual field

      -label of an  input field

      -value of an input field


      All I need now is help updating the value of a virtual field text box.


      Thanks !

  3. Hi Jan,


    Can you please help me.


    Need help with a code in a HTML blok for storing a date with extra days.

    Whats the promblem: I want to store a (date + 84 days) extra


    I use in my submissionform the parameter  [@Initiele_meting], this parameter [@Initiele_meting] receives on load a[@cbTimestamp*] 

    In my table the field Initiele_meting is a Date/Time field

    I want to store [@Initiele_meting] + 84 days in the table as A_Keuring is a Date/Time field.

    Why do I want it: see it like this. You are making today [@cbTimestamp*] a appointment, the deal is that you always take a action between the [@cbTimestamp*] and A_Keuring (this is the [@cbTimestamp*] + 84 days)


    I now have this in the footer, but dont work:

    function grandTotal(){

    var_a =parseFloat(document.getElementById("InsertRecordEndDate").value);


    Thank you!!

    And greetz from the Netherlands.

  4. Hello xtrasize, Welcome to Caspio forum! If I understand correctly, you can click the Account in the Up menu, then click "My Profile" and edit. You can find the instructions in the article. I hope, it helps.
  5. Hi, I am almost did it Maybe, someone can help me with the last step. Steps: Create three DataPages: Tabular DataPage that uses the table A as the DataSource; Submission DataPage that uses the table B as the DataSource; Details DataPage, that uses the table A as the DataSource. On Tabular DataPage, add the HTML Block, disable HTML Editor and enter the code: <a href="URL_where_Submission_DP_is_deployed?id=[@field:id]&name=[@field:name]&surname=[@field:surname]&comment=[@field:comment]">Delete</a> You can enter the correct URL and use as many fields as you wan
  6. Hello naidah14, Maybe, conditions in Calculated fields can help. Does it work for you?
  7. Hello crazedwombat, What page do you want to use? Result page or Details page? If I understand correctly, you want to click a link or button, then the record is "moved" to another table. Is it correct?
  8. Hello nhunsaker, Welcome to Caspio Forum! As far as I know, you can send Views and Tables with Scheduled Export Tasks. Does it work for you?
  9. Hi Aurora, You are right, it was not completely good code. You can use the update code (please, enter the name of you field instead of FIELDNAME and the correct number instead of "15": <SCRIPT LANGUAGE="JavaScript"> function check_date() { var field_name = "FIELDNAME"; var allowed_years = 15; field_name = "InsertRecord" + field_name; var entered_value = document.getElementById(field_name).value; var entered_date = new Date(entered_value); var entered_year = entered_date.getFullYear(); var today = new Date(); var current_year = today.getFullYear(); var denied = false; if(current_
  10. Hi Aurora and piyali, I have used this generator. Please note, that the link does not work in the Preview mode. Please also note, that you should use the code as it is and click the "Source" button in your HTML Block or Header&Footer element: <a href="//pdfcrowd.com/url_to_pdf/">Save to PDF</a> You should do not change anything in the code. Could you please tell what does not work? Do you see any error message?
  11. Maybe, it is possible to merge both scripts (and three steps, that allow do not click the last record more than once): <script type="text/javascript"> if(document.getElementById("caspioform")) { if(document.getElementById("cbParamVirtual1").value==document.getElementById("cbParamVirtual2").value) { document.getElementById("caspioform").style.visibility = 'hidden'; document.write('<font face="arial" color=red size="5">Email Notifications have been Sent!'); } else { if("[@field:text]" == "105") { setTimeout('document.forms["caspioform"].submit()',1000)
  12. Hi aam82, I am afraid, my solution (all steps, not only the script) replaces Aurora's.
  13. Hello larsonchst, I am not sure that I understand you clearly. There is an article with a JavaScript Solution: Concatenate/Combine two fields into one field. Does it work for you?
  14. Hello everyone, I have found a solution, but it requires additional steps. Select the field with id or with any unique value, on the Advanced tab, select the Pass field value as parameter checkbox and copy the name of the parameter (for example, "[@id]"). Add a Virtual field, select the Hidden Form element, select the External Parameters "On load, receive", paste the name of the parameter from step 1 (for example, "[@id]"). Add the second Virtual field, select the Hidden Form element, select the Data Source Field "On load, receive", select the field with id or with any unique value, th
  15. Hi ychaudhry, Welcome to Caspio forum! The code looks like good. Could you please provide the URL to your DataPage to see the problem?
  • Create New...