Jump to content


Caspio Rockstar
  • Content Count

  • Joined

  • Last visited

  • Days Won


Everything posted by Mathilda

  1. try placing the following code in an html block above all the fields: <input type="submit" name="searchID" id="searchID1" value="Search" class="cbSearchButton">
  2. 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(funct
  3. 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
  4. 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
  5. 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
  6. 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
  7. 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
  8. 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
  9. 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
  10. I modified a solution from this post for submission form. You may try using my script in the footer: <script> function validateEmail(email) { var email = document.getElementById("InsertRecordEmail_field").value; var splitted = email.match("^(.+)@thisdomainonly\.com$"); if (splitted == null) return false; if (splitted[1] != null) { var regexp_user = /^\"?[\w-_\.]*\"?$/; if (splitted[1].match(regexp_user) == null) return false; return true; } return false; } document.getElementById("caspioform").onsubmit=validateEmail; </scri
  11. You may find an example in this post. Hope that helps
  12. If "type of music" field is included in your datasource, you may use the following syntax: select count(user_id) from table_name where type_of_music=target.[@field:type_of_music] target.[@field:type_of_music] - this part refers to the field value on report Hope that helps
  13. Hi, welcome to forum! I don't think that this can resolved in caspio account, you may have a look at this article. Hope that helps
  14. Hi, what is the purpose of updating that field? Can you describe a workflow? I suppose that you may need to have a separate datapage for this purpose
  15. I suppose that you may try using sql count function in a calculated field. E.g.: select count(user_id) from table_name where type_of_music='Rock'
  16. You can use formula field with dateadd function: DATEADD(dd, 1, [@field:end_date]) If you prefer JavaScript, have a look at this post, you just need to add 1 day instead of 1 month.
  17. I would hardcode deploy code in js file and load datapage in a specific node on a condition (when page is scrolled to a specific place)
  18. I would hide datapage is parameter is not equal to X. You may find an example below: <script type="text/javascript"> window.onload= function my_funct(){ var check='[@param]'; if (check != 'X'){ document.getElementById("caspioform").style.display = 'none'; } } </script>
  19. Only regular drop-down form element can receive a parameter on a submission form. What is the purpose of assigning a parameter to a cascading element? First, you may need to submit a parameter to your lookup table. Have a look at this post.
  20. I think that you may try using cascading elements, this will let you fill out fields with data depending on value, selected value in a parent field.
  21. In this case, you may use java script only for displaying the value to a user. Depending on your requirements, you may execute function window.onload or 'onchange' of a specific field.
  22. In this case you may use java script. I created a simple example for you, you should paste script in the footer of the datapage: <script> window.onload = function myFunction() { var d = new Date(); var weekday = new Array(7); weekday[0] = "Sunday"; weekday[1] = "Monday"; weekday[2] = "Tuesday"; weekday[3] = "Wednesday"; weekday[4] = "Thursday"; weekday[5] = "Friday"; weekday[6] = "Saturday"; var n = weekday[d.getDay()]; document.getElementById("InsertRecordField_name").value = n; } </script> Enter name of your field instead of: Fi
  23. As far as I remember app parameter doesn't have this flexibility. Depending on the type of the datapage you will be able to get current day of the week in calculated field: DATENAME ( dw , '[@cbTimestamp]')
  • Create New...