Help

Populate multiple select lookup based on matching fields between two tables

Topic Labels: Automations
297 4
cancel
Showing results for 
Search instead for 
Did you mean: 
Courtenay_Ricke
6 - Interface Innovator
6 - Interface Innovator

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.

4 Replies 4

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

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!

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

Screenshot 2024-10-16 at 5.57.43 PM.png

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

Link to base

Screen Recording 2024-10-16 at 5.57.31 PM.gif