I’m trying to create a workflow for myself which is ultimately a To Do list. I have 3 different tables which uses zapier to bring in new/updated tasks from Asana and google calendar.
I need to create a master table in this base which filters all the tasks in the 3 sheets of things to do in the next 7 days and then populate them in the main master sheet for me to see an overview of the next 7 days.
How can I do this? as when I do a simple ‘link to another record’ it doesn’t automatically populate the data which is what I need