Link to another record not populating


#1

Hi, I have the basic ‘project tracker’ base set up to track all my clients, design projects, and tasks. It works great, I love it (mostly).

The projects tab has a nifty ‘tasks’ column that grabs shows linked records from the ‘tasks’ tab. When I add a new task in the tasks column, they show up in the tasks tab as well. Or, vice versa, if I add a new task in the tasks tab, they will show up in the appropriate project on the project tab. My tasks tab is grouped by project, which is helpful for obvious reasons.

What I don’t understand, is why I can’t add a linked record in the ‘tasks’ tab, that pulls the client for a particular task based on its project. I’d like this, so then I can group the view by client (as well as project). So the view would show client as the main grouping, then projects (with their tasks) as sub-groupings within client. Each project has a defined client, and on the clients tab it has no trouble telling me what projects apply to which clients.

But when I’m in the tasks tab, and I add a ‘link to another record’ column, and select ‘clients’, it doesn’t work. It gives me the column, but then I have to manually add the client to each task. I’d like the client to be pulled from the information in the projects tab, where I’ve already defined which projects apply to which clients.

I did figure out how to use the ‘lookup’ column type in order to achieve what I want, but I wanted to reach out to the community for two reasons:

  • I don’t have a firm grasp as to why the linked record approach isn’t working, and I feel like in order for me to use Airtable effectively, I should understand that reason

  • When I group my tasks tab by client and then project, it won’t let me add new records, because “You cannot create a new grouped record when grouping by a computed field”. Being able to add new records without ungrouping and then grouping again is important to me. And I don’t really feel this is a ‘computed’ field.

Anyway, if I could get some of your wisdom, I’d really appreciate it. Thanks in advance for your time!

As a side note, the linked records ‘tasks’ in the clients tab never worked for me either, I ended up having to go with a ‘lookup’ column type there as well.