Jump to content


Caspio Ninja
  • Content Count

  • Joined

  • Last visited

  • Days Won


GoCubbies last won the day on November 27

GoCubbies had the most liked content!


About GoCubbies

  • Rank
    Advanced Member

Recent Profile Visitors

798 profile views
  1. GoCubbies

    How to Disable Links?

    Hello, I would recommend taking a look at this forum post, as it may help you achieve this conditional behavior:
  2. GoCubbies

    Setting up default value for date field

    Shuchi, Instead of choosing Default Value for the Date/Time field 'On Load', choose System Parameters and Time Stamp. This will stamp the current Date/Time, but still allow the user to change the value.
  3. GoCubbies

    Navigation Bar

    Another idea is to use App Parameters to create the menu bar. Create a 'Long Text' App Parameter and place in the code for your menu bar. You can then call this in the Header of any DataPage in that application. There are many CSS menu bar templates available that you can copy, paste and modify to fit your desired need. Take a look at the link below for an example: https://c0cqk194.caspio.com/dp/D6673000bbd638fefcc444eab2dc
  4. GoCubbies

    Logout link

    Hello, You will use the logout link that is created by Caspio from an Authentication. If you edit an authentication, under the Advanced Options, you can change the logout destination to the desired location.
  5. GoCubbies


    Here are a few quick tips in getting started that I use for new apps: Key areas to scope prior to beginning and as you progress: What entities (tables) are needed, and general purpose of each. Define what data you need for each, and what type of data this is What users and roles will be needed to access this application? Who is using the app. Group them into roles and permissions for each role/sub-role For each user/role, what permissions should they have on each entity. What should each user role be able to do with each set of data. Keep this simple: Insert, Edit/Delete, View only. Should this be for the whole data-set, or just a sub-set. How is sub-set determined? I use a table like the screenshot below to help build this out:
  6. 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.
  7. 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
  8. 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/
  9. 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
  10. 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/
  11. GoCubbies

    Caspio Unexpectedly Down

    You can also check the server statuses for Caspio at https://status.caspio.com/.
  12. 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/
  13. 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/
  14. 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.
  15. 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