Creating User Permissions in your App

This article explains how you can use filtered Views of your user table to create user groups for your app.  Using these filtered Views you can limit access to authenticated DataPage folders based on user profile permission data.  For user groups within your Caspio Bridge account, see Internal Users and Groups.

In this example we will be creating an Admin folder and a Staff folder.  There will only be one “user permission” variable.  Admin users may access DataPages in both folders, but other users only access DataPages in the Staff folder.

Steps to creating user permissions:

Modify your user table

In the Caspio Bridge Explorer window proceed to the Tables section.  Select your authentication table.  Click the Design button to open the table in design view.  We are going to add a field with a Yes/No data type to indicate if this user is an Admin user.

Create a filtered view

Now we are going to create a filtered view of the authentication table.  This view will display only the users with a Yes value in the Admin field.  Go to the Views view of Caspio Bridge.  Click the New button to create a new View.   Name the view and select your users table as the source.  Click Next.

Select the Yes/No field that was added in the previous step.  Click the checkbox labeled Filter data by this field.  Click the Value checkbox to indicate that only records with this field checked should be included in this View.  Press Finish to save your View.  If you have data in your users table, you can open the view in datasheet view to verify that the records are being filtered correctly.

Create and password protect a second folder for Admin specific DataPages

Back in the DataPages view you can now add a second folder for Admin DataPages.  Click the New folder button.  Select the folder and enable authentication based on the view created in the previous step.  On the first screen of the Authentication Wizard, choose the Custom radio button and enable advanced options.  Click Next.

Include any fields you would like to use for authentication and click Next.  Format the fields as needed and click Next again.  You can now format the login failure message.  Click Next.

On the last screen of the Authentication Wizard we will want to check the checkbox labeled Enable auto-login across apps.  This way when a user logs into the admin folder they will automatically be logged into any other folders that are also password protected using the same base table.  Click Finish to save your authentication settings.

Now you can move DataPages into this folder and only users with admin privileges will be able to access them.

Creating the basic staff folder

For DataPages that should be accessible for all users enable Password Protection using the original user table instead of the filtered view.