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.
Dec 15, 2022 12:22 PM - edited Dec 15, 2022 12:23 PM
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
Dec 16, 2022 09:12 AM
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