I’m building an audit app in Glide and I’m stuck on clearing data in user-specific columns.
Setup:
I have a Questions table
Columns like answer, photos, notes are user-specific
Each user can have only one audit in progress at a time, but multiple users can audit at the same time
What I need:
After generating a document (end of audit), I need to clear the values of a user-specific column for all rows in the Questions table for the current user only.
I have a workflow with a loop through the table and set column value - clear value but it doesn’t clear the user specific column. if i set it up to clear a not user specific column it does it.
Workflows that allow looping run server side, so they do not run as a specific user and thus cannot access user specific columns. Only the App Interaction workflow can access user specific columns because it runs client side as the user that is signed in. Unfortunately the App Interaction workflow does not allow looping through multiple rows. A bit of oversight on Glide’s part and a very frustrating limitation.
My best suggestion is a method that I use, which is a bit of smoke and mirrors, but very effective.