Jump to content


  • Content Count

  • Joined

  • Last visited

  • Days Won

  1. Hi Aurora, thanks for your help! Each calculated field listed in the script below compares 2 or more calculated fields not listed and basically checks to make sure the user filled out the form correctly. What I want is that they do not allow the submit button if the the calculated fields do not read "OK" Based on what you provided I was able to put together the following, which worked on its own but not when deployed with other datapages on the same page: <SCRIPT LANGUAGE="JavaScript"> var stat='[@calcfield:2]'; var stat4='[@calcfield:4]'; var stat6='[@calcfield:6]'; var stat8='[@calcfield:8]'; var stat10='[@calcfield:10]'; if (stat!='OK' || stat4!='OK' || stat6!='OK' || stat8!='OK' || stat10!='OK') { document.getElementById("Mod0EditRecord").style.visibility = 'hidden'; } </script> Do you have any advice on why it works deployed by itself and not with other data pages?? thanks again!
  2. Hi all, I want to hide the submit button in a details page based on the value of five calculated fields. I saw this post from before: http://forums.caspio.com/index.php/topic/5131-hide-button-based-on-calculated-field/ Based on the advice there, I came up with the following: <script language="javascript"> var stat='[@calcfield:2]'; if (stat.length='Not Equal, please revise figures') { coauthor = stat; document.write(stat); document.getElementById("Mod0EditRecord").style.display = "none"; } </script> But I have been unable to get that script to work for me properly. As is, it does not hide the submit button but rather shows the button and the text "Not Equal, please revise figures" below the submit button.(see attached) Also, the script is for only one calculated field and I would like the javascript to include five. Any help would be much appreciated.
  3. Hi Shannon, I think the issue is that you are using DMS (degrees, minutes, seconds) when you should be using decimal degrees (latitude and longitude). The Caspio Google Maps mashup uses Latitude and longitude: http://howto.caspio.com/extensions/map-mashup/map-mashup-guide/ You can play around with the following website to get an idea of this: http://www.gps-coordinates.net/ If you plug in 29.61 as Latitude and 95.02 as Longitude it will take you to china. If you plug the same numbers in as DMS, it will take you to Houston. If you only have a few locations you need to convert to latitude and longitude you can do it manually on the above website or in google maps. If not you can use an opensource GIS program like QGIS to convert a large table of locations. hope that helps.
  4. Hello, I have a system that runs in two languages and in some cases I have dropdown menus to select a city in Arabic. The same city is then automatically selected in English in an associated cascading dropdown. This english cascading dropdown is hidden in the form using html blocks as per: http://howto.caspio.com/tech-tips-and-articles/common-customizations/how-to-hide-fields-in-datapages/ This information is then displayed in a tabular report that can be inline edited. In this case, if a user changes the city in arabic, the change automatically occurs in english as well. The problem is, i would like to have the english cascading dropdown column hidden in the table, but still function properly. I have attached a picture which makes things clearer I hope. any help on how to hide these table columns would be much appreciated.
  • Create New...