Help

Re: Need help with formula

1645 0
cancel
Showing results for 
Search instead for 
Did you mean: 
julie_de_waele
4 - Data Explorer
4 - Data Explorer

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

Capture d’écran 2023-03-30 à 14.40.39.pngCapture d’écran 2023-03-30 à 14.46.48.png

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 

 

1 Reply 1
Kenneth_Raghuna
7 - App Architect
7 - App Architect

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)
)