Row owners in linked table?

Ask for Help
1

Hi, I’m scratching my head on how to solve this. Let’s say I have a “Projects” table where I’ve set a row owners column. So whenever a user logs in, only their projects are downloaded to their device.

Inside each project are 100 tasks, which are in a separate “Tasks” table. Whenever I create a new task, it is automatically linked to that project.

If I have 10 projects with 100 tasks in each, I’d ideally want the user to download only their project and only their tasks. Without a row owners column in the Tasks table, am I making my users download all 1,000 tasks into their device? If so, how do I set up row owners in this tasks table? If I use lookup column, then I can’t make it row owners. If I copy/paste the row owners when making a new task, it works for the time being, but the row owner for the project gets updated from time to time, and I want that to be reflected in the task as well.

My Projects table is synced from an external source where I added an email column and made it the row owners.

2

You should find a flow to update the child tasks’ owner whenever the row owner of the parent project gets updated.

3

Thanks for clarifying. This is what I was fearing though, since the row owners are synced in the projects table from an external source. If it were inside Glide, I’d set up an action button to make that flow. Let me think on how to do this.

4

@ThinhDinh , just for my understanding, when a user goes from the app’s home screen to the “Projects” tab (which shows only their project) and then clicks on a project to show its tasks, which of these two will happen?

  1. will all tasks inside and outside that project be downloaded to the user’s device (since there’s no row owners column in the tasks column)?

OR

  1. only that project’s tasks will be downloaded to the user’s device?
5

Generally I always make the assumption that rows not under row ownership will always be downloaded. Think of it this way… The relation is only going to function on the user’s device along with most computed columns. Very little is actually computed server side. That’s why Glide apps are so responsive. For it to compute on the device, all the data needs to be there to determine what is a match or not.

3 Likes
6

Alright, so I’m going to assume that all tasks inside and outside that project will be downloaded to the user’s device since there’s no row owners column in the tasks column. Thanks for clarifying.

2 Likes
7

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.