Skip to main content

I’m building a database for products that sell on multiple marketplaces (Etsy, Creative Market, and my own website). I have one table for the products and another for the marketplaces. I have URL fields for inputting direct links to product listings (separate fields for each marketplace), and fields for linking the products to the marketplaces they’re listed on.

Currently, I have to manually add both the URL and link to the related marketplace, but I’d love to create an automation that updates the marketplace link to include all marketplaces for which the URL field isn’t empty. For example, if a product has only an Etsy URL, it should only link to the Etsy marketplace record. If it has both an Etsy URL and a Creative Market URL, it should link to the marketplace records for both. 

I was able to successfully create an automation that linked to a single marketplace based on a single URL, but when I tried to update it so that it would also link to a second or third marketplace when additional URL fields were updated, it just overwrites the existing link. Is there a way to get things to update without overwriting existing data? 

Full disclosure: I’m pretty comfortable with most of Airtable’s features, but I’m fairly new to using automations. Feel free to explain things like I’m five years old, because I definitely feel a teensy bit out of my depth with this. I believe it’s possible, but I just can’t figure out how...

Does this look right?  If so, I’ve set it up here for you to check out 


The idea is to create a whole bunch of conditionals to handle it and I’ve put a screenshot below.  You can duplicate the base linked above to your own workspace to play with it too

 

We can do this with a script as well and it’d be more elegant, but I figured a non-scripting solution would be better so that you could maintain it yourself

 


Yes, that looks right and makes perfect sense. Thank you so much for taking the time to do all that! It really helps a lot!


Reply