I see it’s possible to get all values from an Airtable table, but it looks like it’s not possible to then take those values and identify a single record. Please let me know if that’s wrong!
Is there another way to get a single Airtable record?
- Currently have an Airtable with two tables:
- We have a Bardeen scraper that is just 2 steps: 1) scrapes a list of all the companies one investor invested in → 2) creates a new Airtable record for each in
Companyhas at least 1
Investorrecord linked to it (who invested in said company). But…
Today, we have to manually link the
Investor to each
Company after running the scraper.
Instead, we’d like to have Bardeen do this linking.
Ideally this would be a third step (between steps 1 and 2), so the flow would be:
- Scrape list of companies
- (NEW) Get Airtable
Investorrecord (match by name search — the name is available on the page in step 1 so it can be programattically fed into Bardeen, nothing manual required)
- Add companies to Airtable + (NEW) link the
Investorrecord from step 2 to each company as it loops through