Help

Populate each row in new table with single select values from another table

Solved
Jump to Solution
1134 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Pieter_Kruithof
4 - Data Explorer
4 - Data Explorer

First ever question for the community! I have a table with a single select column that contains the names of different documents and articles used while conducting secondary research.

I would like to create a new table that adds each unique document to a single row.

Suggestions?

1 Solution

Accepted Solutions
Nathaniel_Grano
8 - Airtable Astronomer
8 - Airtable Astronomer

Does that column need to be a single-select, or could it be a “Link to another Record” field? That type of field works exactly as you describe:

  • Users can select from the list of records in the other table, or
  • They can create a new row of the other table and link that instead

See Solution in Thread

1 Reply 1
Nathaniel_Grano
8 - Airtable Astronomer
8 - Airtable Astronomer

Does that column need to be a single-select, or could it be a “Link to another Record” field? That type of field works exactly as you describe:

  • Users can select from the list of records in the other table, or
  • They can create a new row of the other table and link that instead