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.
Populate multiple select lookup based on matching fields between two tables
+5
+31Hmm, 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!
+5Hmm, 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!
here you go!
https://www.loom.com/share/c45438baef264aee9bc408fef0df70c6?sid=cdb48c1b-f513-41c1-96e2-7959d9f8fb86
+31here you go!
https://www.loom.com/share/c45438baef264aee9bc408fef0df70c6?sid=cdb48c1b-f513-41c1-96e2-7959d9f8fb86
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:
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.