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. 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.
  18. 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.
  19. As far as I know, it's not possible. Caspio mailers send email on behalf of your email address, therefore you cannot use encryption in this case.
  20. Hi, Thank you for sharing
  21. I suppose that you use update form. You should use a little bit different syntax, have a look at this post
  22. Calculated field can return only one value. Perhaps, you may create a view, join tables and then use that view as a data source for report with grouping. Hope that helps.
  23. Are there any errors in browser's console? You may send me an URL and I will check
  • Create New...