Jan 31, 2023 01:11 PM - edited Jan 31, 2023 01:12 PM
Is there any way within airtable to return multiple row headers based on a column match? I have an example below. Basically my master base is company-focused but I have two fields "Investors" and "Investments" which would both be matching items in the "Name" field. Ideally I want to be able to tag "Investor(s)" in a column but have the "Investment(s)" column auto-populate pulling in "Name" based on a match of "Investor(s)" to "Name" in that particular row.
|Startup A||Investor A, Investor B|
|Startup B||Investor A|
|Startup C||Investor B|
|Startup D||Investor A, Investor D|
|Investor A||Startup A, Startup B, Investor D|
|Investor B||Startup A, Startup C|
|Investor D||Startup D|
Jan 31, 2023 02:13 PM
I can't clearly understand your goal, but it seems like on your place I would create 2 tables: 1st for Startups, linked to the second table of Investors.
Jan 31, 2023 02:14 PM
Is this one table in your Airtable base? If so, it should be 2 tables. First table named Investments where Name is "Startup A", Startup B", etc. Second table named Investors where name is "Investor A", "Investor B", etc. Your Investor(s) field in the Investments table should be linked to the Investors table.
Feel free to book some time with me to discuss additional ways I may help. My Calendly link is: https://calendly.com/d/zvr-vqp-j95/30-minute-meeting
Jan 31, 2023 10:51 PM
So, with reference to the row "Investor A", you'd want the results:
1. Investor A - Startup A
2. Investor A - Startup B
3. Inverstor A - Investor D
Is that right? If so, you could accomplish this with a formula field with`SUBSTITUTE()` replacing commas with the "Name" value