Need help with formula

julie_de_waele · ‎Mar 30, 2023

Hi everyone,

I have a scenario one Make, 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

I want it to find the right record to update thanks to my formula, -> 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

Kenneth_Raghuna · ‎Mar 30, 2023

Is the formula shown the full formula you have in that box?

If so it is not a valid Airtable formula. You probably want something closer to this:

IF({linkedin_profile_url}='5.url', 1, 
   IF(
      AND({first_name}='5.firstName',
          {last_name}='5.lastName',
          {current_company_name}='5.company'), 1, 
   0)
)