Add record to new table based on field selection

Topic Labels: Base design
509 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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?

1 Reply 1

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.