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

[Michael_Leidens]

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

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

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

Best

Michael 

[TheTimeSavingCo]

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