
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 31, 2017 04:38 PM
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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 31, 2017 04:48 PM
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-fi...

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 31, 2017 05:20 PM
OK the LookUp + Single Select works. An interesting way to get there but all is well.
Tom
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 25, 2017 08:18 AM
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!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 12, 2019 07:26 PM
I think this is a related or identical question, I can’t quite tell.
In Table 1, I have a list of names. In Table 2, I’d like a single select drop down list that comes from the list of names in Table. This way I can add more names to the column in Table 1 and have them show up as options on the list in Table 2. Can anyone tell me if this is possible? I have played around with linked records and can’t figure it out.
Thanks,
Jim

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 13, 2019 02:39 AM
Hi @Thomas_Carey, @Emmett_Nicholas,
Did you manage to populate the Single Select (dropdown) with data from another table using a Lookup? I can’t get my head around it. If you could point me in the right direction it would be much appreciated.
I’m trying to add a Single Select (categories), that pulls the options from a “Categories” table.
Thanks!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 28, 2019 06:58 AM
Did you find the solution to this? I’m new to Airtable and am trying to accomplish the same goal.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 28, 2019 07:16 AM
@Burner no I haven’t. But still curious whether it’s possible.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Feb 24, 2020 11:38 AM
Yes, you can, You only need to add typecast = true to the Records JSON,
Example:
{
“records”:
[
{
“fields”: {
“Field 1”: “Test”,
“Field 2”: “Single Select field” }
}
], “typecast”: true
}
I used this example to add-update multiple records (10 records per request)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Aug 24, 2020 07:18 AM
I don’t think @Carlos_Torres response does what we want, since we’re not trying to “add-update” records. We just want a single select dropdown populated by a linked record field. How could this feature not exist?
