Conditional field populating

Hello everyone. Sorry if this isn’t in the proper category or if the question seems newbie.

I’m kind of new to Airtable and was wondering if there’s a way to automatically populate a field across a whole table based on a condition within a field in that table and/or in another table entirely.

To simplify, I have a table with the following columns: Website Name, URL, and Categories.

What I want to achieve is create a 4th column based on values within the Categories field. For example, if Categories field has “Laptops”, the 4th column would automatically populate with a text like “Source1, Source2”, etc. Is there a way to do this across the whole table and at the same time be able to edit the “Source” text to add more websites?

Photo for clarification:

Is it possible to make it so that Sample Website 2 through 4 also have Source1, Source2 in their Sources column?

Sorry if this is confusing.

Thank you so much!

Unfortunately, that is not possible in Airtable. Be sure to email support@airtable.com to request this feature.

You could potentially write your own script to mimic this functionality in a scripting block.

There is also an elaborate workaround to this issue here — but this also comes with its own drawbacks:

Thank you! I sure will do.

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.