Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Search a record in Table 1, IF found, then copy record in Table 2 Please Help‌🙏‌

Topic Labels: if search
113 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Michael_Leidens
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi everyone,

I need urgent help for something I can't solve. It's like search function in excell.

Job to be done:

- If EAN of Record 'x' in table 2 =  EAN found in a record in table 1 THEN "Handle record" in table 2 = Handle record in table 1.

Here is a screenshot of Handle2 that needs to be filled in with the correspondant "handle" in another page.To search for it, i am looking for same Variant Barcode

Capture d’écran 2022-12-15 à 21.01.41.png

On the page ONBOARDING, we have the variant barcode, and the right handle we want to copy in the first page with same ean. 

Capture d’écran 2022-12-15 à 21.18.31.png

 

Thank you for your help. It's very important for us.

Best

Michael 

1 Reply 1

Hi Michael, you can use an automation for this.  Its actions will be to:
1. Find record based on conditions, specifically where the "Variant Barcode" matches
2. Update record, specifically updating the triggering record's "Handle2" field with the found record's "Handle" value