I have a “Role” column in my Users table, defined as the role in User Profile settings. There are only two roles: Customer and Coach. Coaches can register new users through a form, which includes a hidden text field that sets the default role as “Customer.” The issue is that Glide keeps deleting the role value from the table. I tried workflows to re-insert “Customer” if the field is empty, but Glide still wipes it. Is this a bug? With row owners enabled, it clears the entire column, breaking the app since roles aren’t defined. If I disable the role column in user settings, it works—but then I lose proper row-owner logic, which creates a big security flaw because customers can access other users’ data trough chrome’s backend with network flow. I also can’t use the Glide API as a workaround, since that requires a Business plan, which makes no sense for me with just one app, my explorer plan doesnt allow that
i dont want coaches to mess with backend of glide so manually editing the data table is not an option for me, glide api is also not an option since i dont need business plan. What is the server side workflow solution, could u tell me a bit about it?
Are there any other ways of securing data of my users without needing row owners? Not just visually but also from backend.
thank you a lot in advance!
Any workflow type except the App Interaction workflow will allow you to change the Role because they run on the server and are more secure. The App Interaction workflow runs directly on the client device whereas all other workflow types run on the Glide servers. You need a paid plan to access the other workflow types.
Row Owners is the only way to properly secure data. An alternative is to have multiple row owner columns in the table with a different email in each column, or you can try the Multiple Texts column type (need to enable it as a preview feature from your team settings). The only way to populate the Multiple Texts column is to have an array of emails (for example a lookup column or a split text column) and use a Set Column action to copy the array into the Multiple Texts column.
thank you for your support once again!