Jump to content


Caspio Ninja
  • Content count

  • Joined

  • Last visited

  • Days Won


GoCubbies last won the day on May 10

GoCubbies had the most liked content!


About GoCubbies

  • Rank
    Advanced Member

Recent Profile Visitors

750 profile views
  1. Vipul, I agree with MayMusic on this. You don't want to use CSS to hide content that should be restricted by role as you can easily use the developer tool in most browsers to then see this content.
  2. GoCubbies

    Missing the Automn Style

    Here is a copy of the Autumn style. Go to Tools -> Import and select this file. I would recommend placing in All Assets. Autumn_2018-Jun-26_1550.zip
  3. Vipul, Just a recommendation from a security standpoint, but if there is content that only should be viewed by certain roles, I would strongly recommend building separate DataPages for each user. Hiding content using CSS is 'Security through Obscurity' and is not a recommended practice. A user could easily use the developer tool in the browser and expose the hidden content. Now, if you are just trying to guide users, and the content is not a security concern, you may want to look a using rules on a DataPage to hide sections. You could receive the role value into a virtual field, and use this field to control what action is taken. For example, build 3 sections on the DataPage, each section containing the appropriate information (Section 1 = Customer, Section 2 = Employee, Section 3=Admin). The virtual field would receive the authentication value on load. You could have 3 rules. Rule 1: When virtual1 is NOT EQUAL to Customer, hide Section 1 Rule 2: When virtual1 is NOT EQUAL to Employee, hide Section 2 Rule 3: When virtual1 is NOT EQUAL to Admin, hide Section 3 Here is an article that has more information on rules as well: https://howto.caspio.com/datapages/forms/conditional-forms/
  4. GoCubbies

    Using Query Strings With Qr Code Generator

    Andrii,It seems that the encoding of the URL may be part of issue, as well as combine the advice from MayMusic. Is this the link you are trying to create: https://chart.googleapis.com/chart?chs=150x150&cht=qr&chl=http://website.com?name=fred&email=fred@aol.com
  5. GoCubbies

    API login Authentication

    Baharul, Have you created your web services profile to get the REST client ID and client secret? These are not the same as your account login. See this article for more information: https://howto.caspio.com/web-services-api/creating-a-web-services-api-profile/
  6. GoCubbies

    Caspio Unexpectedly Down

    You can also check the server statuses for Caspio at https://status.caspio.com/.
  7. GoCubbies

    SELECT COUNT() possible?

    You can use the SELECT COUNT in a calculated field in reports or details pages, but sub-queries are not allowed in formula fields (table based calculations). What is the overall workflow you are looking to achieve and maybe I can help guide you to some other solutions? Take a look at these links for some additional information as well: https://howto.caspio.com/function-reference/ https://howto.caspio.com/datapages/reports/advanced-reporting/calculations-in-forms-and-reports/
  8. GoCubbies

    Change history of a field

    Hello, You may want to take a look at using Triggered Actions for this. There is a video on the How-To page that shows how to create a change log. This concept seems fairly close to what you are looking to do. https://howto.caspio.com/tables-and-views/triggered-actions/
  9. GoCubbies

    Caspio User logs

    Not all account types will include user access logs, as these are only included in Performance accounts and above. To access the logs, go to Tools in the top menu, and select User Logs. You can then select how you wish to display the logs (I recommend the Detailed Report). To the right of this selection is the option to download the logs.
  10. GoCubbies

    Caspio User logs

    Lynn, The User Logs do not appear as a data source under 'All Assets', so you would need to download the logs, then import them in order to reference by a DataPage
  11. GoCubbies

    Triggered actions on import

    Hello all, For clarification, current Triggered Actions will only execute on data being inserted, updated, or deleted via: DataPage At Datasheet level (direct in table) API As Franchiser said, DataHub (Scheduled Tasks) and manual import will not fire triggers. Also if cascade update and/or delete is enabled through referential integrity in table relationships, these events as well will not execute Triggered Actions.
  12. GoCubbies

    Label Color, Field Color

    Hello, I added the tag direct in the label under General Options.
  13. GoCubbies

    Label Color, Field Color

    Hello, You can also add some HTML direct to the label itself. See this page: https://c0cqk194.caspio.com/dp/d667300046b81b2a2b534766a4eb. If you cycle through the records, you will see that Address 2 has text label in red when a value exists or hidden otherwise. This was achieved by setting the element under the advanced tab to 'Hide when blank' and then setting the label itself for that field to the following: <span style="color:#FF0000;">Address 2</span>
  14. GoCubbies

    Generate Geolocation

    Hello Corey, Could you possibly provide the URL of the page with the submission form so that I can take a look at it? I'm wondering if any errors are appearing in the console. Also, if you are using the Google Map API integration for the first time, you may need to adjust the code placed in page above the deploy code. You may need to try the code with the API key included. For example: <script type="text/javascript" src="http://lib.caspio.com/pub/jquery/jquery.js"></script> <script src="//maps.googleapis.com/maps/api/js?v=3.exp&sensor=false&key=<API KEY HERE>" async="" defer="defer" type="text/javascript"></script> You can get a Google API key by going to this page: https://developers.google.com/maps/documentation/javascript/get-api-key#get-an-api-key
  15. 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