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...
