Jump to content


Caspio Ninja
  • Posts

  • Joined

  • Last visited

  • Days Won


Everything posted by GoCubbies

  1. Just to add to what TsiBiRu stated, In a formula field or calculated value you can concatenate without needing JS. The benefit of a formula field is that it will also concatenate values brought in via import or API. Calculated Values have the benefit of displaying on the submission page. Also here is another valid way to concatenate the two fields, using the function Space(n) with n being the number of spaces you want between the fields: [@field:Fname] + Space(1) + [@field:Lname]
  2. Geoffdude, The Scheduled Import is just placing the designated file into the chosen repository. It does not have any functionality to append, update, or otherwise manipulate data in the existing files at that repository. If you are looking for that type of functionality, you will need to build an API integration. It is essentially just a data export to a file storage location.
  3. Here is another possible solution. I have created a custom button in an HTML block that will serve as the submit button and placed this in a section. In another section I placed a message saying that only company email are allowed. Create a rule that when the email field contains 'gmail' or 'hotmail' hide the section with the custom button HTML block. Create a second rule that when email does not contain 'gmail' or 'hotmail' hide the section with the message. You will need to edit the style applied as well to set the existing submit button to display:none; Here is the demo page: https://c0cqk194.caspio.com/dp/d66730007687803bd8c348febbac I attached the DataPage and associated dependencies so you can import and play around with. Just trying to provide a version without using any code as another option. Enjoy! CaspioData_2019-Jan-17_1518.zip
  4. I am running WordPress 5.03 with the latest Caspio plugin. Here is my test page for reference: http://caspiotraining.x10host.com/sample-page/ I would recommend backing up everything before you update and you may want to reach out to the Caspio support team as well to see if they have any additional information.
  5. This site has some useful templates as well for Bootstrap sites: https://startbootstrap.com/
  6. If you are looking for resources as well on converting Excel to Caspio, this is a good video series to look at as well:
  7. You may want to explore Caspio's integration with Zapier. Take a look at this page for some integrations of Caspio and Google Sheets: https://zapier.com/apps/caspio-cloud-database/integrations/google-sheets. Here is more information on Caspio's integration as well: https://howto.caspio.com/integration/zapier/
  8. Here is an updated version of this code to work with the ajax feature on DataPages: <script type="text/javascript"> document.addEventListener('DataPageReady', function (event) { 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 EditRecord for an update form //Current_Long and Current_Lat should change to reference correct field names document.getElementById("InsertRecordLong").value = position.coords.longitude; document.getElementById("InsertRecordLat").value = position.coords.latitude; } initGeolocation(); }); </script>
  9. Hello, I would recommend taking a look at this forum post, as it may help you achieve this conditional behavior:
  10. 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.
  11. 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
  12. 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.
  13. 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:
  14. 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.
  15. 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
  16. 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/
  17. 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
  18. 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/
  19. You can also check the server statuses for Caspio at https://status.caspio.com/.
  20. 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/
  21. 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/
  22. 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.
  23. 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
  24. 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.
  25. Hello, I added the tag direct in the label under General Options.
  • Create New...