Any way to get all records except one into a single cell?

Hi @Tae_Hyun_Kim,

Welcome to Airtable Community! :slightly_smiling_face:

Yes you can do that since the records are linked, create a new field in table B that is a Lookup and choose the field you wanna bring from table A.

BR,
Mo

Thank you @Mohamed_Swellam.

But what I like to do is to have a list of records except for one specific record, all into one single cell. In the scenario I mentioned, I have Amazon and Google (two linked records) into a single cell if the record that contains that cell has a field with the Facebook value. And I’m looking for a way to do this automatically.

Basically, I’d like to have an automatic routine (or formula) that first go to the linked table and get all records except for the one specified in the previous table’s record.

Help!

Ah ok! Now I think I get it

You have 3 companies (Facebook, Amazon, Google) and if Current Company is Facebook you want Other Companies to be pasted automatically.

I assume they are not only 3 companies or it would have been easy to do, right?

In case they are only 3 companies, you can then make a small table called Co. & Others where you have each company in the Primary Field excluded from the Others field then use a Lookup field to check them.

In case they are more than 3 companies, you can use a Script (which would be fairly simple) to do so.