
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 16, 2024 12:17 AM
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.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 16, 2024 01:10 AM
Sorry, I'm not using excel, I'm using airtable. am I missing something?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 16, 2024 02:36 AM
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!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 16, 2024 02:40 AM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 16, 2024 02:59 AM
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:
