Add record to new table based on field selection

[candaceA]

Hello! I'm an artist using Airtable to keep track of each artwork that I create. I currently post some artworks on sites that allow me to promote them with affiliate links. 

Here's what I want to do - if I indicate in my multi-select status field that an artwork has been posted to an affiliate site, I'd like that artwork record added to a new "Affiliate Table" that includes a field for affiliate link. 

This way I can track individual artworks and larger page section affiliate links on the Affiliate Table. 

So... how can I do this?

[Alexey_Gusev]

Hi,
Create automation with trigger 'when record matches condition'. For multiselect it's .'.has any of'
Action - create record. you can put both file and link into a single action.
Just try, it's quite easy. If something goes wrong, find video.