Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here
Jan 24, 2023 10:58 PM
Dear Community,
I am faced with the following problem:
I want to pull data from a different table when the status in each table is the same.
I am creating a text.
Say the status in Table 1 is "First Text" then it should check in Table 2 for the row named "First Text" and pull the information from a specific cell in that roll.
In sheets it looks like this: =IF(A4=Table2!A2;Table2!B2;IF(A4=Table2!A3;Table2!B3);0)
How can I replicate that in Airtable?
Thank you
Jan 25, 2023 09:00 AM
You will want to use field types and linking in Airtable instead of formulas:
1. Create a field in Table 1 using the "Link to another record" field type and choose Table 2. That will create the link.
2. To pull over specific data from Table 2, create a 2nd field in Table 1 using the Lookup field type and choose the linked field from Table 1 that you just created and also the field from Table 2 you want to pull over.
If you would like to schedule some time with me to review this or anything else, here is my Calendly link: https://calendly.com/bruce_consulting/30min
Jody