Help - Airtable Search Record Formula

Questions & Answers
1

Hi everyone,

I have a scenario sending infos from piwaa (linkedin connected inbox) to my airtable

For the module Airtable search records, I have a formula to help finding the record concerned

Capture d’écran 2023-03-30 à 14.40.39
Capture d’écran 2023-03-30 à 14.40.392672×1320 314 KB

Capture d’écran 2023-03-30 à 14.46.48
Capture d’écran 2023-03-30 à 14.46.482672×1320 281 KB

I want it to find the right record to update thanks to the linkedin url, OR if it’s not possible, firstname + lastname + company name

My formula is not working and I can’t figure out why…

Thanks a lot in advance for your help :pray:

2

Not that used to with Airtable formulas, but do let me know if this is what you want; you are searching for either Profile URL Matches OR Name/Company/LastName matches right?

You should structure your formula like this,

OR(
      {linkedin_profile_url} = "[TEST](https://community.make.com/t/help-airtable-search-record-formula/9514/2)", 
     AND(      
       {first_name} = "JOHN"
       {last_name} = "DOE"
       {current_company_name} = "ACME Company"
     )
)

Since This is more related to the formula that you are using, you might find a better solution in the Airtable community.

1 Like
3

Thank you a lot its working now :grin::pray:

4