Populating Single Select


#1

Trying to figure the basics of Airtable. At this point i just want to populate a Single Select field in Table A with information in a field from Table B. Doable?
Thank you for our time ~ Tom


#2

Yes-- if you paste into a Single Select field, it will automatically create new select options based on the pasted values.

Depending on exactly what you’re doing though (depending on the relationship between Table A and Table B), it’s possible that linked records + lookups are what you’re after. Here’s an article explaining how lookups work: https://support.airtable.com/hc/en-us/articles/202576519-Guide-to-formula-lookup-count-and-rollup-fields#lookup


#3

OK the LookUp + Single Select works. An interesting way to get there but all is well.

Tom


#4

It would be very nice to be able to poplulate a Single Select or Multiple Select with a Rollup from a linked table.

I’m using airtable as a PIM (product information managment). When mapping product attributes to various marketplace (Amazon, Overstock, etc…), it’s very important that the attribute value be exact. I maintain an Attributes table and an AttributeValues table. After linking an attribute to a product, it would be extremely helpful to populate a select with the values from AttribributeValues. This would ensure the value is correct.

Airtable really is a wonderful product, this addition would make quite a few things easier for our use.

Thanks!