Hi, I have a Table "Main" that is Linked to table "Agenda". Being in Main, on a record, lets say “33” I want a button to view agenda filtered by ID (Both table have the ID field, in this case “33”). Any idea to turn aroud this? Im new to Airtable. Thank you ----------------------------------------------- Example: Table Main: ------------------- ID Name 33 Marta 34 Martin 35 John
Table Agenda:
------------------------- ID Done 33 Mailed
45 Called 46 Mailed 33 Zoom
87 Visited
Result Expected
------------------------------ 33 Mailed
33 Zoom
Page 1 / 1
That is not possible in the data layer, but you can get a similar experience to what you’re looking for on an interface page.
First, at the data layer, make sure that you have already created a linked record field in your main table. (This is the field where you will link record #33 to all of its related records in the agenda table.)
Then, at the interface layer, create an interface page based on your main table. I would recommend using the “Record Review” interface page for this.
Then, on your interface page, you can add the linked record field to that page.
However, in the right margin underneath “Appearance”, you would choose to display the linked record field as a “view” instead of a “field”.
This will enable you to automatically see all of a record’s linked records whenever you choose the main table’s record in the left margin.
So, for example, whenever you choose Record #33 in the left margin, you will automatically see all of its linked records on the page.
First, make sure your "Main" table is properly linked to the "Agenda" table using the ID field. You can do this by adding a linked record field in the "Agenda" table that links to "Main".
Once the link is set up, go back to your "Main" table. For each record, you will now see the related Agenda entries linked to it. You can also add a lookup field to pull the "Done" field from the linked Agenda records.
This way, when you're in the "Main" table, you can easily see all related Agenda records for each ID.
Hmm, I think you’d have to use an Interface for this I’m afraid. I’m not sure what your workflow is, but I worked on a similar thing and basically summarized the data and then pulled it over via a rollup so it looked like the following. For that workflow I just needed a birds eye view of everything though, so not sure whether it works for you
If that doesn’t work, then I reckon you could try an Interface and it might look like this:
