Jump to content


Caspio Rockstar
  • Content Count

  • Joined

  • Last visited

  • Days Won


Everything posted by Mathilda

  1. Hi AzadeEmf, can I take a look at your datapage? Can you send me the URL ?
  2. Hi AzadeEmf, Try deleting the following arrtibute : white-space: nowrap; for the .cbResultSetHeaderCell class To find this class follow these steps: edit style-> source-> all->source then find a class. I attached a screenshot. Hope it helps.
  3. Hi Michitect, I suppose, you need to leave only the first 'if' statement: <a id="visi[@field:Status]"> <script> var isi = document.getElementById("visi[@field:Status]"); if('[@field:Status]' == 'Aangeworven'){ isi.parentNode.parentNode.style.backgroundColor = '#b3e6b3'; } </script>
  4. Hi BigJohn, I think this script might help. Please feel free to ask if something is unclear.
  5. Can I take a look at an URL of the datapage?
  6. Hi, Yes, the current version of Caspio Bridge is 9.3. You may check release notes here
  7. Hi, Try editing style associated with the datapage. You may try changing layout for Label-Cell element. You need to change padding attribute try using 0 px instead of 14 px. Please take a look at the screenshot. You may read more about customizing layout here Also if you need to create a responsive datapage, you can find instructions here
  8. You may try using the following SQL statement in the Aggregation field: SELECT COUNT(DISTINCT Field_name) FROM table_name Please replace Field_name with your name of the field and table_name with name of your table. You may find more information about this query at: http://www.w3schools.com/sql/sql_func_count.asp Also you can read more about aggregation here Hope it helps
  9. Hi Jojodhewa, What type of the datapage do you have?
  10. Hi Danrashba, Do you need to store total value in the table? If yes, you may use the following solution:
  11. Hi RobertJay, I suppose you can't remove this message. It seems that Caspio warns users that they submit personal data to free account. Anybody can create a free account, so there is a security purpose for this warning message. Consider upgrading to paid account.
  12. Hi, yes it's possible. Take a look at the Real Estate Listings ready made application: https://www.caspio.com/real-estate-listings/ Go to the Public view and open a detail page of a records. This application is free, so you may request it for your account and take a look how it was build.
  13. Hi, As far as I understand, you'd like to perform calculation in a webform datapage. Please try using the following Java Script solution: http://forums.caspio.com/index.php?/topic/3149-js-perform-a-calculation-on-values-entered-in-a-webform/ I hope this helps.
  14. Hi, welcome to forum. I suppose you use a submission form. I have modified script from this solution: http://forums.caspio.com/index.php?/topic/3200-js-concatenatecombine-two-fields-into-one-field/ Try using the following script: <SCRIPT LANGUAGE="JavaScript"> function concatenate() { var position1 = document.getElementById("InsertRecordField1").value; var allpositions = position1 + "@XXX.com"; document.getElementById("InsertRecordField2").value = allpositions; } document.getElementById("caspioform").onsubmit=concatenate; </SCRIPT> Replace Field
  15. Hi, You may use a solution from the step#3 in the following article: http://howto.caspio.com/tech-tips-and-articles/common-customizations/tech-tip-5-ways-to-customize-the-look-of-your-datapages/
  16. There are actions that doesn't affect data transfer, like manual uploading or creating datapages. So when you create a datapage or table or any other object in your account it doesn't consume datatransfer, however when you submit data using submission form or when you retrieve data by opening a report datapage it consumes data transfer. You may read more information at: http://blog.caspio.com/caspio-news/update-on-caspios-data-transfer-policy
  17. Hi Richard, Please make sure that you have added code provided here to the head section of the webpage
  18. Hi, Please watch this tutorial. It describes how to build ticketing system. Hope it helps
  19. Hi, When you or your users submit or retrieve data it determines your monthly data transfer, even if you do it inside your account. You may use developer tools like firebug to approximate data transfer for one load of the datapage. It is under Net tab and look for Size. Also I would recommend disabling AJAX feature if you don't need it on your reports. Different deployment methods affect data transfer in a different way. E.g. URL deployment consumes less data transfer comparing to embed method because of styles which loads from server in embed deployment method. Howe
  20. Hi steveruehlen, please add header footer to the datapage, disable html editor and paste the following code in the footer: <SCRIPT LANGUAGE="JavaScript"> function check() { var v_sales = parseFloat(document.getElementById("InsertRecordField_name").value); if(v_sales >75000) { window.alert("Too large.. Please enter value smaller than 75 000"); return false; } else if(v_sales <5000) { window.alert("Too small.. Please enter value bigger than 5 000"); return false; } else { window.alert("Thank you.. Information is registered!"); } } documen
  21. Hi Mylene, Add header/footer to your datapage and in the footer try using the following script: <SCRIPT LANGUAGE="JavaScript"> window.addEventListener("load", myfunction1); document.getElementById("caspioform").addEventListener("submit", myfunction); document.getElementById("caspioform").addEventListener("submit", getDiff); function myfunction1() { Stamp = new Date(); var v_TimeStamp; Hours = Stamp.getHours() Mins = Stamp.getMinutes(); if (Mins < 10) { Mins = "0" + Mins; } v_TimeStamp=('' + (Stamp.getMonth() + 1) +"/"+Stamp.getDate()+ "/"+Stamp.getFullYear() + '
  22. Hi Mylene, I have taken a script from this post and changed a little bit. Paste following script in the footer of the datapage: <SCRIPT LANGUAGE="JavaScript"> function calculate() { var v_field1 = parseFloat(document.getElementById("InsertRecordfield1").value); if (isNaN(v_field1)) v_field1 = 0; var v_field2 = parseFloat(document.getElementById("InsertRecordfield2").value); if (isNaN(v_field2)) v_field2 = 0; var v_field3 = parseFloat(document.getElementById("InsertRecordfield3").value); if (isNaN(v_field3)) v_field3 = 0; var v_total = (v_field1 + v_field2+v_f
  • Create New...