Mathilda

Caspio Rockstar
  • Content count

    444
  • Joined

  • Last visited

  • Days Won

    44

Mathilda last won the day on November 15

Mathilda had the most liked content!

4 Followers

About Mathilda

  • Rank
    Advanced Member

Recent Profile Visitors

1,729 profile views
  1. Chart Category Sort Order

    As far as I know, only fields which are being used for Value and Category can be selected for the chart sort order. You could also try using chart and report type of the datapage and count needed values in calculated field, then use that field for Value and default sort order.
  2. Hi, I tried this code, it works for me. I would recommend checking that: - you specified correct fieldname in the code; - code is inserted into the footer of the datapage and your datapage is a submission form; - there is no errors in browser's console (hit F12 and select Console tab)
  3. Multiple Search Buttons

    You're welcome!
  4. split streetname and number in download

    I would use calculated or formula field for this case. Is there a separator (e.g. comma) between street name and number?
  5. Multiple Search Buttons

    You may hide a standard button using the following code in the header of the search page: <style> #searchID { display:none; } </style>
  6. Since this is cascading field, try to get a field value by name, please find an example here
  7. Multiple Search Buttons

    try placing the following code in an html block above all the fields: <input type="submit" name="searchID" id="searchID1" value="Search" class="cbSearchButton">
  8. Hi, I modified script from this article. Code for the header: <div id="cbwrapper"> Code for the footer: </div><script type='text/javascript'> var lat_id = 'EditRecordlat'; var lng_id = 'EditRecordlng'; var address_id = 'EditRecordAddress'; var city_id = 'EditRecordCity'; var state_id = 'EditRecordState'; var zip_id = 'EditRecordZip'; var wrapper_id = 'cbwrapper'; var msg1 = 'Please input a valid address'; if(typeof jQuery != 'undefined'){ var cb_geocoder = cb_geocoder = new google.maps.Geocoder(); $('#'+wrapper_id+' input[id=Mod0EditRecord]').click(function(e){ e.preventDefault(); var add = $('#'+address_id).val(); var city = $('#'+city_id).val(); var state = $('#'+state_id).val(); var zip = $('#'+zip_id).val(); if(!add || !city || !state || !zip){ alert(msg1); }else{ var full = add +','+city+','+state+' '+zip; cb_geocoder.geocode({address: full}, cbCallBack); } }); }else{ document.write('This Datapage require Standard Caspio Deployment for full functionality.'); } function cbCallBack(locResult){ if(locResult != "" && locResult.length>0){ var lat1 = locResult[0].geometry.location.lat(); var lng1 = locResult[0].geometry.location.lng(); lat1 = Number(lat1); lng1 = Number(lng1); $('#'+lat_id).val(lat1); $('#'+lng_id).val(lng1); $('#'+wrapper_id+' form').submit(); }else{ alert(msg1); } } </script> Code for the html file where the datapage is deployed: <script type="text/javascript" src="https://lib.caspio.com/pub/jquery/jquery.js"></script> <script src="//maps.googleapis.com/maps/api/js?v=3.exp&sensor=false&key=YOUR_KEY" async="" defer="defer" type="text/javascript"></script> You should place those two lines above the deploy code of the datapage. Paste your google apikey instead of: YOUR_KEY Cheers!
  9. Hi, since we cannot create a button or link in grouping, you need to place the link in each record If you don't want to display value of calculated field, you could hide the calculated field using css, like in this post
  10. PLugin error with Caspio deploy

    Hi Try adding <?php session_start(); ?> at the beginning of the "class-datapage-loader.php" file. Also, please remove any trailing spaces at the beginning of that file. You may find more details here
  11. How do I hide a submit button based on a dropdown value?

    You may insert my script in the footer of the submission form <script> function hide() { var v_value = document.getElementsByName("InsertRecordFieldName")[0].value; if (v_value.length<1){ document.getElementById("Submit").style.display="none"; } else{ document.getElementById("Submit").style.display = "inline-block"; } } window.onload = hide; document.getElementsByName("InsertRecordFieldName")[0].onblur=hide; </script> Use your field name instead of: FieldName
  12. Mail Merge

    As far as I remember MS plugin is not available for MS Word, it gets data only for Excel and Access. You may have a look at 3rd party apps in zapier, perhaps mail chimp provides needed pattern
  13. Replace field given certain input

    autonumber field will be populated for every records, therefore you would need to use integer field instead. If triggers available for your plan, you can do that using triggered actions, if no - you could use java script. In case of creating java script function I would add a virtual field (drop-down, displaying values, gotten from the table in descending order - this will give you the most recent value) and incrementing a value if value in rego field = unreg You may find an example here
  14. You could get total value using sql query in a calculated field, then you may create a link (find an example here) and pass calculated value parameter in query string Hope that helps
  15. resize an iframe

    I have a solution for your case. You may find code below: <script>https://ajax.googleapis.com/ajax/libs/jquery/1.11.3/jquery.min.js"></script> <script> function resizeIframe(obj) { obj.style.height = obj.contentWindow.document.body.scrollHeight + 'px'; } </script> <iframe src="URL_of the datapage" frameBorder="0" scrolling="no" width=100% onload="resizeIframe(this)">Sorry, but your browser does not support frames.</iframe> Don't forget to insert your URL instead of: URL_of the datapage