Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.
Jul 23, 2020 03:22 AM
Hi,
Question about linking records between tables. I want to
create a dynamic conditions linking in Airtable. Is this possible? I only see the option for static conditions. Here is a example to explain what I want
Table 1
Firstname - gender - hair color
Joost - men - yellow
Ria - female - brown
Robert - men - brown
Table 2
Groupname - criteria - names(table1field1 where condition of table2field2 = table1field2)
Mengroup - men - Joost, Robert
Femalegroup - female - Ria
Thanks in advance, Robert
Jul 23, 2020 07:51 AM
You can do this in one single table. Use grouping on the column Gender.
When you do want to use two tables. You need to create a link between tabel 1 and table 2 on Gender.
See
.