Jump to content

GoCubbies

Caspio Ninja
  • Content Count

    82
  • Joined

  • Last visited

  • Days Won

    11

GoCubbies last won the day on November 27 2018

GoCubbies had the most liked content!

2 Followers

About GoCubbies

  • Rank
    Advanced Member

Recent Profile Visitors

892 profile views
  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

    Beginner

    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
×
×
  • Create New...