Jump to content

Search the Community

Showing results for tags 'Authentication'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


  • Caspio Bridge
    • Caspio Apps for Ukraine
    • General Questions
    • Caspio JavaScript Solutions
    • Tables, Views and Relationships
    • Import/Export and DataHub
    • DataPages
    • Deployment
    • Security, Authentications, Roles, SAML
    • Styles and Localizations
    • Parameters
    • API and Integration
    • Calculations and aggregations
    • User JavaScript and CSS Discussions

Find results in...

Find results that contain...

Date Created

  • Start


Last Updated

  • Start


Filter by number of...


  • Start




Website URL






  1. Hello Caspians, I just wanted to share my case: I have a Submission Form with Authentication (users can have access levels 1,2 and 3). In it, I have a Dropdown where user can choose to which department (role) to assign the issue, but I want that each logged in user can choose department which is only on his or any lower level. So, user which is on level 2 can see only options that have stamped on them level 2 and 1. User with level 3 can see any option with levels 1, 2 or 3. We will need 'users' table with levels, and 'Roles' table with their mapped maximum level access:: In Submission Form, we will need to set up the Dropdown field as follows, as well as additional Virtual Field with Dropdown Form Element (Virtual Field will be hidden with JavaScript, but in order to hide Label, select 'No Label' from Advanced Options): Once this is done, add another HTML block, and add the following JavaScript code in it: <script> document.addEventListener('DataPageReady', function(event) { const userLevel = '[@authfield:Level#]' // Select you own Authentication Parameter for User Level const dropdown = document.querySelector('select[name="InsertRecordAssigned_Departmant"]'); // Select your own Dropdown Field const helper = document.querySelector('select[name="cbParamVirtual1"]'); // Select Virtual Field helper.style.display = 'none'; let optionsMap = []; const arrayHelper = Array.from(helper.querySelectorAll('option')); for (let el of arrayHelper) { optionsMap.push({ 'level': el.value, 'type': el.textContent }) } let getOut = []; for (let i = 0; i < dropdown.length; i++) { const find = optionsMap.find(({ type }) => type === dropdown.options[i].value) console.log(`find level: ${find.level}, type: ${find.type}, user_level: ${userLevel}, option: ${dropdown.options[i].value}`) if (Number(find.level) > Number(userLevel)) { getOut.push(i); } } getOut = getOut.reverse(); for (let i of getOut) { dropdown.remove(i); } }); </script> Adjust declaring of variables at top, to select your Authentication Parameter for User Level, Dropdown Field (Just this need to be changed: const dropdown = document.querySelector('select[name="InsertRecordAssigned_Departmant"]'); ), and for Virtual field.
  2. Hi everybody, I'm trying to create a log in DataPage that, depending on the user level (Admin, Developer or Customer), will grant or deny access to another DataPage. The user type (level) is a field of Users Table. So the process would be: 1) register as a user with email and username (already done that) - 3 different Forms for each user type/level; 2) After a user has registered they can log in; 3) Depending on which type of user logs in, they will be granted access to a different DataPage or even to the same DataPage but with different permissions. How do I do that? I couldn't find anything on the Help pages. Thank you.
  3. Is there a way to set a specific style for the login/authentication screen? Andrew
  4. How can I check if the Cookies are enabled on the Authentication page?
  5. Hi Caspio newbie here! I'm trying to do email verification, most of it works fine but the only way to change the verification status to yes is to manually run the datapage I created called email_verification. the email sends okay and the link copies the GUID but it doesn't change the field status. I tried copying the script on the help page to get automatic updating but it doesn't appear to work....my code is as follows <script> document.getElementById('caspioform').onsubmit = function (){ document.getElementById('[@field:Email_Verified^]').checked="y"; } </script> any advice much appreciated Ian
  6. I am trying to conditionally show/hide HTML elements based what type of user is logged in. I’m not too familiar with how Caspio sessions are handled and how they relate to my HTML pages. I also have very little Javascript experience. There should be three levels of access, Admin, Manager, and User. I currently have an authentication table that has three users and three yes/no fields (admin/manager/user), each user is a different type. My first idea was to use cookie data. On successfully logging into my authentication form it would make a cookie for user type which would have a value of admin, manager, or user. Then I could use that cookie to add the display:none style to certain elements that I don’t want lower access users viewing. My problem is that I’m not sure how to do that with Javascript, or if that is the best practice. I currently have an HTML Datapage linked to my Authentication. On that page is this code: var type_admin = '[@authfield:admin]'; var type_manager = '[@authfield:manager'; var type_user = '[@authfield:user]'; if (type_admin == "Yes") { document.cookie="type=admin"; } else if (type_manager == “Yesâ€) { document.cookie="type=manager"; } else if (type_user == “Yesâ€) { document.cookie="type=user"; } Then I assume I would just reference the cookie on my HTML pages somewhat like this: <div class="adminContent"> Show this content if the user is Admin </div> <div class=â€managerContentâ€> Show this content if the user id Manager </div> <div class=â€userContentâ€> Otherwise show this content </div> Here are the HTML/PHP files I’m working with: http://domco.us/vita/test/ And here is the login page that’s just an embedded Datapage: http://domco.us/vita/page_login.php In the end I would like to be able to filter things like navigation buttons or div blocks. It would be great to have an Admin Tools link in the navigation that only Admins/Managers could see. I’m not sure the specifics of getting something like this to work. Also I don’t know how to keep that @authfield data throughout different HTML pages (not linked to Caspio) and I’m just assuming Cookies are the best option. Any help would be greatly appreciated.
  7. Greetings all Curious if anyone has successfully deployed logic that will allow multiple Authenticated users to VIEW any Data Page, but only one user my edit it. Thank you for sharing any guidance you may have. Leon
  8. I have embedded my app with CASPIO authentication into a Wordpress site and app's users do not need to authenticate themselves on Wordprees. Now I would like to know if a user is logged in to the app in order to show/hide some wordpress menu items. Can I check In a caspio datapage some fiedl before login? i.e. if System Parameter User Agent is Null user is not yet logged... Anyone has been faced with this?
  9. my one authentication is built from a view based on a user_ table. when i build a report from that view, all fields present their expected values, that is, they show the values that are in the user_ table. however, when i build an HTML page and select authentication fields for embed (using the 'insert parameter' feature), not all fields present their expected values. for instance: [@authfield: user__first_name] prints out the user's first name on the HTML page and [@authfield: user__last_name] prints out the user's last name on the HTML page and even [@authfield: user__display_name] (which is a function that concatenates the first and last name) prints out the user's first name on the HTML page HOWEVER [@authfield: user__original_user_id] displays nothing even though it has a text field value of IAQM6XBX in the user table (upon which the authentication view is built, and, again, which prints out just fine in a tabular report built from that view) AND [@authfield: user__has_a_pool] displays nothing even though the text field has a value of 'Y' in the user table, and even though it prints out just fine in the tabular report built from the view. the only theory i have for why this might be is that the fields that are displaying nothing did not exist when the table was first created; they were later added. that is, i suspect that some caspio features don't update after initial creation (such as authentication view fields). i have created new views based on the updated table, but that hasn't helped. the only thing i haven't tested is creating a whole new table, which i am loathe to do. a perhaps related issue is that i have noted that when i change / add fields in tables - and ensure that those changes are duly reflected in the views that they participate in - datapage lookups for those views still do not reflect the changes in the table fields. in other words, if i were to change 'field ABC' to 'field XYZ' in a table, i can confirm that the change is reflected in view. however, when i select that view as a lookup table for a datapage's dropdown field, i will still see 'field ABC' and not see 'field XYZ'. that is, it is as if the original blueprint of the table/view is preserved. so, any thoughts? thanks for reading this far.
  10. If someone creates a new user for my application, (email and password), the new created user has to login (fill out his email and password) before he can start using my application. Isn't it possible to auto login a new user? I've searched and tried many things but can't find a solution. Thanks so much Dominique app.reduceincidents.com
  11. I am creating a new Application and found one issue. I need to check a number of registered and unregistered users visiting my DataPages. Question: How can I track the user logins to the DataPages?
  12. In each of my application tables, I have added four fields for created timestamp, created by user ID, updated timestamp, updated by user ID. I am having trouble figuring out how to capture the "updated by user ID" field when I am editing a record from within a tabular datapage (both inline and details view editing). Any help at all would be appreciated!
  13. I created a login page on my website in order to authenticate to Caspio for data inserts and updates. The login page is a data page with required authentication with username and password fields. When bringing up the page in Firefox, the " Create a Free Online Database /Disclaimer: This is a Caspio free app. Do not submit passwords or other sensitive data. Report Abuse" tagline appears but the username and password fields do not. When bringing up the same page in Chrome, the fields do appear. In comparing code in developer tools for both browsers, Firefox seems to be replacing all of the <tbody> data that defines the fields that I see in Chrome with <noscript></noscript> tags. I'm at a loss as to how to further troubleshoot. Any assistance would be greatly appreciated. I would go to support but, alas, as a newbie trying out Caspio, I'm still in the Free Plan.
  14. I've looked through the forum for help on this issue and although I found a posting or two, it doesn't seem to provide any additional info. I created a "user" datapage with auto-generated ID, username and password. I created an authentication using the same datatable and the Caspio data source setting. Last, I created a login page datapage with authentication required to the authentication I created. I deployed this page and chose the embed method to embed the login page to my WordPress site. I have added a test login to the users table. Each time I login with the test credentials, I get the message "Authentication failed. The information you have provided cannot be authenticated. " Going through the forums I found a troubleshooting page that simply says make sure you're using the correct ID and password, caps lock is off and cookies are allowed on the page. I have done all of this but am still getting the error. I am new to Caspio and am using a "Free" account. Is there a step I'm missing or something else I should be looking at? TIA
  15. Is the "Designated entry page" in authentication's advanced setting used to redirect timed out users?
  16. I just started using Caspio this week. I have a simple database project that I would like to share only with specific google users. I have successfully created a Tabular DataPage Report that is configured on the Access and Security section to Restrict Access by Requiring a Connection. The connection is successfully configured to use only Google ID Services. When I do this, any authenticated google/gmail account can be logged into my DataPage. That part works. Ultimately, I would like to restrict the access to only specific google accounts. I can't seem to find any documentation on how to get that to work. I have tried to instead create a new Authentication. One that is configured with a Setup option of "Custom" and a User Validation Method of "ID Services Only". Then I enabled only Google ID Services, and selected by Authentication Data Source (table) to use the "social login field" of Username (as well as entering the same Client ID & Client Secret that worked in the Connection I created). But I cannot log in to the database with any of the accounts I added to the Authentication Data Source. and I've edited the DataPage's Access and Security to use this new Authentication (rather than the Connection). But when I try to authenticate, the Google login screen appears, and it accepts my passwords, but just returns me to the Caspio login page with the message "Unknown user. Contact the app administrator for assistance." at the top. So my suspicion is that something's wrong with the record data in the authentication table I'm using as the data source. It has only four fields: Username Text(255) Password Password Email Text (255) Name Text (255) For example, say I have an account with the email of bill.smith@gmail.com I am using the Username field as the Authentications "Social login field" and I've tried populating that field with all the variations I can think of: "bill.smith", "billsmith", "billsmith.gmail.com", "billsmith@gmail.com" but no matter what that contents, I still continue to get the "Unknown user. Contact the app administrator for assistance." message, after logging in successfully to that account. The Google ID Services seems to be working, but the the Caspio Authentication part doesn't. So I'm stuck. Any ideas how to make this work?
  17. I have searched for a solution, but have only found situations that don't resolve my problem. My need: at login, a user with a password that has not been changed in XX-days will be directed to change their password (should this be a submission page or a password change form) . The system, knowing what their current password is, will not allow them to use the same one. Once the password is changed, the user will continue to the page they were trying to sign into. My level of experience with Caspio can be described at best as self taught. I was tasked with the implementation of my project with no prior knowledge of Caspio or coding. Please forgive me if I have followup questions or need additional direction. Thank you!!
  18. I want to make a website that people post their writings and publish it. So, I need that each person has a username and password that he/she uses in order to post anything and other people will be able to view them and know who wrote it. Is that possible? How? Please note that putting the correct password is necessary in order to use the username. Thanks a lot in advance
  19. Hi All, I have tried calling authentication API to get token Key but I am always gettinf it as bad request. Can anyone please help me on this , if I am missing something here. Please refer below screen on what all data is passed during calling.I have used postman tool of google. Thanks Baharul Islam
  20. I am in need of using a list - string in authentication. I would like to have a list field with "roles", and when a datapage loads, I access the values through the authentication fields. It could equate to a comma separated string, then I would just compare to see if the role is contained in the string. The List - String datatypes currently do not show up, but is there a way around this? Maybe by using a formula field to create our own string from the List datatype? Currently, I have each role as a Yes/No column, but it is getting pretty hectic with many roles. I would like to limit it to a few columns if possible. Has anyone encountered this yet? Thanks, Josh
  21. Hello, I am building a Login/Registration/Password-reset database and authentication system with Caspio and am trying to integrate it into an existing PHP based web page. My web page is highly customized ecommerce site that has specialiazed B2B purchase order type system without any login. I want to expand into offering online credit card payments and paypal but I require a customer account system to authenticate and save customer data and provide my FoxyCart with shipping and bulk pricing for individual customers. 1. Is this possible with Caspio? After building a login system I can't see where or how I can pass Authentitcation data through to my order system. 2. How can I update my current php database with newly (caspio) registered users? 3. Is there a webhook or API to assist in this?
  22. I have user authentication by Role setup. When the user signs in they are taken to a page depending on role. I also have a Sign Out option in the Nav. Two questions: Is there a way to have the Sign Out Button auto switch to Sign in after someone signs out or times out? Also, not sure the timeout of 15 minutes is working. Did a test and came back later (when I should have been timed out) and could still navigate to pages based on my role.
  23. Hi I am designing an app with a login data page. When designing the web page where I am deploying the login HTML Data Page the HTML box is showing either the redirected web page or the login in page superimposed over where I am expecting to see the login boxes. (See attached scree shot which will explain it better) The issue I have is that the container for this HTML box is wider that the app I am designing so its changing the layout of my web page. How can I restrain the size of this box to only the size of the login fields and not the referenced web page. I am using Adobe Muse to design the web page and deployed the data pages. Regards Steve
  24. My site has public and private pages. The public pages contains long lists of items. When a user selects an item they are taken to a private details page for that item; however they must be logged in. Currently, if the user is not logged in then they are taken to the login page and upon login they are redirected to the index page. However, I would like the user to be redirected to the private details page that initiated the login. I.e. I don’t want the user to have to find the item again once they are logged … they should just be taken to that details page upon successful login. Description is a little confusing but hopefully someone understands! Thx
  25. I'm working on a wordpress site and writing some custom PHP functions that access Caspio via the REST interface. I'm trying to figure out how to determine if the current user is logged in and get that user's info. I tried creating an HTML DataPage with the same authorization setup that simply echoed back the user info, hoping that if I logged into the website the REST request would be authenticated as well, but this didn't work. I also tried setting the PHPSESSID cookie in the request. Unfortunately, the REST request for the HTML datapage is always getting the login screen, regardless of if the user is logged in in the website. How does Caspio track user authentication? Is there a known solution to this? Thanks, Andrew
  • Create New...