Populate multiple select lookup based on matching fields between two tables

[Courtenay_Ricke]

I have two tables with matching fields. (week ending dates) I want new records created in Table A populate in the multiple select lookup field in table B if the weekending dates match. How do I do - I fear the AI has sent me on a whild script chase.

[Courtenay_Ricke]

Sorry, I'm not using excel, I'm using airtable. am I missing something?

[TheTimeSavingCo]

Hmm, could you provide some screenshots of Table A and Table B with the relevant fields, with some example data and example output?  Would love to help but don't have enough information!

[Courtenay_Ricke]

here you go!

https://www.loom.com/share/c45438baef264aee9bc408fef0df70c6?sid=cdb48c1b-f513-41c1-96e2-7959d9f8fb86

[TheTimeSavingCo]

Thanks!  Yeah we can do this with an automation without any scripting.  Try setting it up like this:

And you can view the actual setup via the link below:

Link to base