Fills multiple rows automatically

Ask for Help
1

image
image1418×774 133 KB

Newbie here, I have table OutletList and TaskList, and the picture is table OutletvsTask. In OutletvsTask, i already have 9 rows (tasks) for every outlet. Can we get the TaskName filled automatically using computed column or anything? I mean, from my 3 weeks learning, i imagine it would be like this:

  • OutletList pulls 9 task names from TaskList for every outlet
  • and then OutletvsTask get task name for every row

I asked Copilot and she says i have to make 9 lookup columns and use custom action to fill the table. Meaning, i have to input manually in app instead input directly inside the OutletList?

PS: I already searched the forum but all of them were asking to use custom action

2
  • Add a RowID column to your TaskList table. This becomes your TaskID.
  • In the table shown above, instead of storing the Task Names, store the TaskIDs
  • Create a relation in the above table that matches the TaskID with the RowID column in your TaskList table.
  • Use a lookup column to fetch the task name via the relation.
3

Meaning, I still have to fill the TaskIDs in that table manually (copy-paste from excel), right?

4

It depends how the rows are added.

5

from Copilot :

Your idea of putting 9 task columns in OutletList → and joining them into OutletvsTask will NOT create rows.
Glide doesn’t support column → row expansion.

Probably only paid plan can do that. I guess I’ll just copy paste them manually. Thanks for the answer, Darren.

6

It shouldn’t work like that. How are you adding rows to the OutletvsTask table? You should be able to add a Task ID if you’re using a form, and then a relation + lookup to get the task name.

7

Sorry for the confusion, what I meant is, if I really had to use form, I want to add them to TaskList, not the OutletvsTask table. Let me explain more:

  • In OutletvsTask table, I have 362 outlets * 9 tasks = 3,258 rows
  • I add new taskname using form, it stored in TaskList
  • It then fills 362 rows (in OutletvsTask table) with 1 new task

But, I don’t think free plan has ability to do it, so I just threw the idea away :smiley:

8

So you have multiple outlets, multiple tasks, and each outlet can have multiple tasks tied to it, which you are representing using the junction table OutletvsTask right?

The problem now is how to automatically assign a new task to all outlets when you add it to the task table?

9

Exactly. But Copilot also says that Glide cannot set to multiple rows, probably only integrations can.