Jump to content


Caspio Ninja
  • Content count

  • Joined

  • Last visited

  • Days Won


GoCubbies last won the day on January 9

GoCubbies had the most liked content!

About GoCubbies

  • Rank
    Advanced Member

Recent Profile Visitors

524 profile views
  1. Hello James, Would it be possible for you to share a screenshot of the Triggered Action? My initial thought would be to use the value from the #inserted table for the new record creation, and not a value from the existing table to avoid the multiple insert. By seeing a screenshot, I may be able to better understand the overall trigger flow. Thanks, Jason
  2. I would recommend for the user registration form to create a Connection using Google ID services. You can then capture the Social Login field value. Simply include the field you wish to use to store this value on the registration page, set it to hidden, and have it receive the Unique Social Login value from the Connection fields. Here is a screenshot to help illustrate this:
  3. Another option is to use a formula field, and the formula below: Substring([@field:First_Name],1,1) + [@field:Last_Name] This will then work even if you import data, and avoids any JS needed for the form.
  4. Obtain GPS Coordinates for Desktop Computer

    You may want to review this post: Be aware, the geolocation is using your browser, so on a desktop it will be much less accurate than other devices.
  5. Geo Coordinates From Phone

    New note on this script: You may see an error if the DataPage is deployed on a page using http. Please see this message: getCurrentPosition() and watchPosition() no longer work on insecure origins. To use this feature, you should consider switching your application to a secure origin, such as HTTPS. See https://goo.gl/rStTGz for more details.
  6. Simple Integration With Wix.com

    2 things to be aware of when using Wix and Caspio: 1) Wix automatically places the deploy code into an iframe. So if you deploy 2 DataPages on a single Wix page and are attempting to pass parameters via the DataPages, it will have issues. 2) Wix does not support use of query string parameters -https://www.wix.com/support/html5/ticket/eb436024-2ad8-4e7e-b151-9f46df085b85 Just be aware of these Wix limitations as you are building to prevent frustration!
  7. Barcode to populate field

    Hello, I haven't implemented any via API, but have been using mobile application barcode scanner called Scan Pet that saves the result to a XLS file that can be uploaded to DropBox or Google Drive. I've then setup a DataHub scheduled task nightly to update/append the records to my Caspio table. It seems to be available for iOS and Android. It even supports stamping of GPS location and timestamps. https://play.google.com/store/apps/details?id=com.maiko.scanpet&hl=en https://itunes.apple.com/us/app/scan-to-spreadsheet/id478631675?mt=8 May be worth taking a look at.
  8. Just want to add this additional information. Note that HTML Tags styling is ignored for embedded DataPages. If you edit your style, and choose HTML tags, you will see that message at the bottom of the page. For URL or iframe deployment this will not be a problem though.
  9. Hello Jonathan, Try something like this: var x = document.getElementsByName("cbParamVirtual1")[0].value; You may want to take a look at the post on Caspio Form Elements for more references as well.
  10. Checkbox on Submit if statement

    You may want to review the information in this previous post, as you can likely modify to work with your comparable element types: http://forums.caspio.com/index.php?/topic/5177-update-checkbox-when-virtual-radio-button-is-checked/#comment-16253
  11. User Own Activity Report

    Muzi, Is this report to be using a Caspio Authentication? If so, you could use Record Level Security to filter the results so only see records belonging to the logged in user.
  12. Wanted To Share This Third Party Pdf Generator

    It looks like this pdfcrowd is blocking the URL from Caspio, so the solution for creating a print button in the page http://forums.caspio.com/index.php/topic/4223-print-button/?hl=print may be the better solution.
  13. Hello, I would recommend disabling AJAX on the Results Page Options of the DataPage Wizard.
  14. Geo Coordinates From Phone

    You would need 2 fields to capture the latitude and longitude, in the example above the fields Current_Long and Current_Lat were used. These fields need to be included on the submission form, but can be hidden fields. For a submission form as well, any spots in the script using EditRecord need to change to InsertRecord.
  15. Geo Coordinates From Phone

    You could try something along the lines of the following, your browser may prompt you to allow current location. <script type="text/javascript"> function initGeolocation() { if(navigator.geolocation) { // Call getCurrentPosition with success navigator.geolocation.getCurrentPosition(success); } else { alert("Sorry, your browser does not support geolocation services."); } } function success(position) { //Change to InsertRecord for a submission form //Current_Long and Current_Lat should change to reference correct field names document.getElementById("EditRecordCurrent_Long").value = position.coords.longitude; document.getElementById("EditRecordCurrent_Lat").value = position.coords.latitude; } //Modify behavior for method trigger as desired window.onload = initGeolocation(); </script>