Group multiple columns

1

Hi there,

I have a table “DB Tasks” with a column “Task” and a column “Task Done?” (which is a checkbox). On another table which is called “DB Sub-Tasks” I have a column “Sub-Task” and a column “Sub-Task Done?” (also checkbox).

I created another table which serves as my overall view of all tasks and sub-tasks. I created a look-up to the all columns of the above mentioned tables with the tasks and sub-tasks. It looks like this:

image
image920×1209 46 KB

After that I grouped the column “Task”:

image
image1581×537 40 KB

Now I have a question: can I group the “Task Done?” column together with the “Task” column, so that there is only one checkbox per Task? More general, is it possible to group multiple columns together?

If it’s not possible, how would you solve this problem instead?

2

Hey, thanks for reaching out to the community!
We don’t have a way of combining groups like how you described, but for your particular use-case I wonder if we can achieve this with some rethinking of your doc structure. It sounds like right now you have separate tables for tasks and sub-tasks, and then use a lookup on another table to make a “master table” of tasks and sub-tasks. What if you flipped that logic, so you have one big master table, that contains all tasks and sub-tasks, then create views of that?
I think that’d get your end result looking more like how you want. If you need any help with that, let me know and we can dig in further :grin:

2 Likes
3

Thanks, this came also in my mind as I realized that tasks, sub-tasks and checkboxes are all related and it doesn’t really makes sense to split them up. I’m new to Coda and learned from some experienced users and from the Coda help, that splitting up larger tables in multiple small databases is a common practice. But in my case I think it’s counterproductive. I will try it with one big tasks table.

4

Hi Yannik,

Here’s a hack. Coda grouping is by textvalue. Anyone feel free to correct me if I’m wrong

Say you have 2 rows (these are to be considered 2 unique objects with different UID) and they are both named “Task A”. When you group them, they become the same grouping “Group A”. Multiple rows to one grouping yes.

You can take advantage of this by creating a formula for naming your groups
I would do

Task + " | " + If(Done?, "Complete", "In Progress")

You will end up with 2 groups called “Task 1 | Complete” and “Task 1 | In Progress”

2 Likes
5

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