Hi everyone, I’m new to Glide (just tried the apps a few days ago) so please bear with my question if they have been asked before. I created a task management apps where everyone can create and assign task to their team members. My issue is that once I send the published apps to my team and they create their new tasks, I can’t see their created tasks on my “Data” Menu. I was expecting as an ‘app owner’ that I’ll be able to see every entry to my database.
I asked the AI agent and was told that it’s because of how row ownership works in Glide and as such, I have added an Admin column to my Task List table that will be filled in with my email address everytime a user submit a new task. I asked my team to retry and they have submitted more tasks, which I still can’t see. How can I, as the app owner, enable the capabilities to see all of the submitted entries to my Task List table?
If I was to make a guess, I’d say it’s probably because you are mis-using User Specific columns.
If you provide a screen shot of your data table, I can confirm if that is the case.
hey @Darren_Murphy , sorry for the late reply and thanks for assisting me.
So, my issues is this table only shows task that I created. if someone else created the task, I will not see them in my table. How can I see all submitted tasks from other people as well?
I asked the AI agent before and was recommended to add ‘Admin’ column and make it Row Owner, then adding my email address as the row owner so that I can see all submitted tasks. I have done it but still see no tasks apart from my own.
That action that you show there, is that an onSubmit action with a Form?
If so, you should not try to use a Set Columns action to update a new row in that way. It is unreliable and should never be necessary. Any and all values that need to be set should be passed with the Form, either as User Profile values or other special values.
Should others be able to see their own tasks? If yes, you need a second Row Owner column that contains the email address of the User that adds the task.
Can you show me a screen shot of your Form layout in the builder, with the component list on the left hand side visible please?
Why is it unreliable? Should the onSubmit action assigned to add Row? I tried that before and for some reason it resulted in the rows being added 2x.
So my requirement is as follows:
Admin and Role Manager should be able to view all tasks
Role Staff should be able to view only tasks that are assigned to them
Also, if the action row shouldn’t be used on onSubmit Form, how can I pass through my email address as the Admin from User Profile, or other special values?
It’s unreliable because sometimes there can be a race condition where the onSubmit action fires before the new row has been created, and so the Set Column Values fails. And no, you should never use an Add Row onSubmit action unless you actually want two rows being added.