Apr 03, 2019 09:01 AM
Hey guys,
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 :slightly_smiling_face:
Thanks!
Apr 03, 2019 09:32 AM
If you want a master calendar table, the date field in all three tables should be a Link to Another Record pointing to the [Master Calendar]
table.
If each of your three non-master calendar tables has three fields (i.e. {Start Date}
, {Description}
, {Task Owner}
), the [Master Calendar]
table will need a Date Field field for the primary key, and 6 Lookup Fields pulling the three sets of two other fields from the other tables.
Then you’ll want another two Formula fields that consolidate the three sets of data like so: IF({Table 1 Description},{Table 1 Description},IF({Table 2 Description},{Table 2 Description},{Table 3 Description}))
Apr 03, 2019 10:11 AM
Actually, @W_Vann_Hall (as always) has made a demo base that I think addresses your problems: