Setting data in column Y based on column X

Hey @WilliamPorter - You are correct, the update only updates records in one column, it doesn’t append / updated records in another column based on the first.
I presume this is a builder update that you need to do whilst building out your application.
I’d do this with Integromat.
Check out some of the “green” Integromat videos to help you get started. It’s actually pretty simple, just a bit of a learning curve. DM me if you want to get into it.