ClayG

Thanks! That sounds very workable.

Has anyone successfully done a live feed or a scheduled data sync from Caspio to Google Data Studio? I have a consultant who has created some data visualizations for us in Google Data Studio using an exported copy of data from Caspio, but now we want to try and either do a scheduled data sync or a live feed, and we're not sure where to go next.

Thanks! That article about separating the search page vs results page would probably also work for me since google analytics would likely capture those URL strings and that would be adequate for reviewing how people are searching.

We're getting ready to launch a solution we built in Caspio. Users will be able to search people records using a variety of search fields. My boss is asking if there's anyway we can see a log of the search criteria that users try. We don't have the Grow plan currently, so we don't have the user activity log feature, but I'm doubtful it would show that level of detail. Does anyone know and/or have you tried to record the search criteria that users submit in their record searches?

For anyone who reads this thread later.... I did find working code for Weebly websites for changing the home page href link of the logo (or site title) to point to the user's landing page, rather than the usual "/" home page URL. <!-- redirecting the logo to someplace else --> <script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.7/jquery.min.js"></script> <script> $(document).ready(function() { $(".wsite-logo a").attr("href", "/admin-page.html"); }); </script>

Thanks, the part of this setup that I'm still pondering is how to handle a home page. Traditionally, a website's logo will be something that users can click to return to the home page. But when you're creating different landing pages for your roles, are you using some Javascript to change a home page link or logo to point to the user's landing page?

kpcollier, For your datapages that are truly universal in their purpose (e.g., Change Password, or maybe an Update Profile), did you create unique versions for each user role?

Awesome, I really appreciate your write-up!!! I will pursue the same approach and let you know how it goes!

Thank you both! I had planned to use the user-specific redirect after login, and I have it partially set up. The thing I'm wrestling with now is wanting to use a website platform like Weebly to host the site. Since I want to have different menu options for an Admin vs a Regular user, I'm trying to figure out whether to create my menu options for the site in Weebly, but then use CSS to hide menus that a regular user should not see (which doesn't sound like a very security conscious way to go). Or, should I create my menu choices in Caspio using the App Parameters feature? That seems like a more security-minded approach and I have played with that a bit. This is my first significant app for me in Caspio. I've watched the videos from Ned who shows how he has hand-coded HTML pages for different users, and while that approach looks straight forward, I would really prefer to host the website with a nice CMS, like Weebly or Wordpress.

As I've been building a prototype application, I originally created 3 different tables for the 3 kinds of users (people) in my app, but now I'm thinking that was a bad idea and it would make more sense to just have a single table of all people but have a column for their "Role" which I would leverage for what level of access they will have to datapages, etc. To give a little more context, I currently have 3 tables: School leaders (with profile fields that are pertinent to them) Consultants (with profile fields that are specific to them) Staff (internal staff who will need to login to add/edit info) All 3 user groups above will need to login but they'll be given different menu options. I realized after attempting to create an Authentication that there can only be a single data source for the usernames and passwords, so it probably makes more sense to put all my different users into one table and then create views that specifically filter on my 3 types of users for my datapage needs?

This did mostly work. It was important that when exporting the DataPage, I do a 'Custom Export' and use "DataPage Only" as the export option so that the future import doesn't wipe out my table structure, etc.

I just had a thought for my own question... In case others run into this, my thought is to export my app (without any data) before doing a data import; then switch my column datatypes as needed; do my data import; switch the column datatypes back; then import the app back into Caspio so that my datapage is back to normal.

I'm building a robust search interface via Caspio for data that I need to routinely import from Excel into Caspio. The app features a single table, and we won't be updating this data within Caspio. I need to routinely re-import the data (weekly), so the problem involves having to convert the TEXT(255) columns into "List - String" datatype columns. I know that when I want to import a fresh set of data into Caspio, I can switch the List-String columns back to TEXT(255); do my import; then convert those columns back to List-String so that I have the functionality I need. Unfortunately, I'm finding that my datapage gets messed up in that I lose all of the fields that are getting converted back and forth, so I have to re-edit my datapage extensively to re-add those columns and reconfigure those columns within the datapage. Has anyone found a workaround for these issues?

I found this thread while exploring potential web platforms for a Caspio project. Webflow definitely looks like a cool CMS, but I'm disappointed that the free trial account doesn't let you have access to the "embed code" feature, thus you can't test the deployment of any Caspio datapages. :-/