Jump to content


  • Posts

  • Joined

  • Last visited

  • Days Won


VAP1 last won the day on October 18 2015

VAP1 had the most liked content!

VAP1's Achievements


Newbie (1/14)



  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. Hello all, I have setup caspio's map mashup and now I would like to combine it with various layers using google maps api v3. I have the code setup so each one works on its own, however I am not sure how to integrate the code for the two so they work together. Below is the code I got from the caspio mashup wizard, and as is it works fine and shows the results page records on the map: <script type="text/javascript" src="//d23b32zmhbr2ct.cloudfront.net/mashup/script/caspio_mashups_v7.js"></script> <script type="text/javascript"> var mapSettings = { 'mapType': 'G', 'mapView': 'R', 'mapWidth': '800', 'mapHeight': '600', 'mapCssStyle': '', 'useAutoZoom': 'N', 'zoomLevelResult': '6', 'zoomLevelDetails': '11', 'zoomLevelMapIt': '11', 'bubbleOpenType': '1', 'disableScrollWheel': 'N', 'showTrafficLayer': 'N', 'plotMarkers': 'Y', 'homePosition': 'amman, Jordan', 'apiKey': '' }; var dpSettings_********************* = new mapDataPageSettings('*********************'); dpSettings_*********************.DefaultIcon = '//d23b32zmhbr2ct.cloudfront.net/mashup/icons/flat/icon2.png'; dpSettings_*********************.DefaultIconWidth = '20'; dpSettings_*********************.DefaultIconHeight = '34'; dpSettings_*********************.MapItEnabled = 'Y'; dpSettings_*********************.MapItLabel = 'View on map'; dpSettings_*********************.FilterNeed = 'N'; dpSettings_*********************.FilterRowSize = '5'; mapEnvironment.AddDataPageMapSettings(dpSettings_*********************); </script> The following code is what i have for displaying the fusion table in google maps API <!DOCTYPE html> <html> <head> <style> #map-canvas { width:500px; height:400px; } .layer-wizard-search-label { font-family: sans-serif }; </style> <script type="text/javascript" src="http://maps.google.com/maps/api/js?sensor=false"> </script> <script type="text/javascript"> var map; var layer_0; function initialize() { map = new google.maps.Map(document.getElementById('map-canvas'), { center: new google.maps.LatLng(32.06811272653243, 35.41485433094706), zoom: 9 }); var style = [ { featureType: 'poi', elementType: 'all', stylers: [ { visibility: 'off' } ] }, { featureType: 'transit', elementType: 'all', stylers: [ { visibility: 'off' } ] } ]; var styledMapType = new google.maps.StyledMapType(style, { map: map, name: 'Styled Map' }); map.mapTypes.set('map-style', styledMapType); map.setMapTypeId('map-style'); layer_0 = new google.maps.FusionTablesLayer({ query: { select: "col18", from: "1QewvePdgZ_iYjkE0mFvx9lzVXPqqkKm-xy-xbzFq" }, map: map, styleId: 4, templateId: 5 }); } google.maps.event.addDomListener(window, 'load', initialize); </script> </head> <body> <div id="map-canvas"></div> </body> </html> Is it possible to combine the two into one map, and if so, how would I go about doing so? Any help or guidance would be much appreciated!
  4. 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.
  5. 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...