Tasklist and Note meetings Lookup

1

Hello.

I’m new to Coda but it’s already helping me a lot. I’ve created documents to help me plan my shopping visits by aggregating recipes ingredients by supermarket aisles, I’m also tracking my freelancer hours and generating invoices! It’s an amazing new world.

I always struggled with Excel, formulas and lookups. Since I’m a visual guy (UI/UX Designer) I think visually and sometimes I struggle even with basic things. That’s why I’m asking for help.

I’ve created a document where I input my Meetings Notes on a table. It has Date, Client and Notes and other not so relevant fields.

Then, I created another table which is a To Do list with my tasks organized by clients, priorities, due date, etc.

I want to be able to create tasks right inside meeting notes so they will go the the To Do list table. Ideally, the task Client field would be automatically filled based on the Client I selected for that Meeting Note table entry.
How can I connect both?

image
image765×628 16.1 KB

I want the selected cell to retrieve the value from Client field on Meeting Notes table so I don’t have to fill it manually.

2

@Geiras_ES

Here’s a basic reliable structure you can use as a starting point. Study the formulas and how it’s put together, and then you can customize it in many different directions.

1 Like
3

Awesome! I took a look at it and I’m starting to understand what I need to do. I guess I’ll understand formulas the more I use them but sometimes it’s really frustrating when I’m trying to do something and I just can’t.

Thanks a lot, Ander!

Eric Anderson via The Coda Community <coda1@discoursemail.com> escreveu no dia quinta, 21/05/2020 à(s) 14:07:

1 Like