Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: In a Column, is it possible to Bulk edit a "single select value" for all fields?

Solved
Jump to Solution
1707 0
cancel
Showing results for 
Search instead for 
Did you mean: 
zen_Table
4 - Data Explorer
4 - Data Explorer

Greetings,

In an Airtable, In a single column, I want to be able to edit a single select drop-down menu for all the fields in that column at once. Or to select and edit several at once.

Any suggestions, ideas, or information would be greatly appreciated.

Thank you.

1 Solution

Accepted Solutions
Alexey_Gusev
12 - Earth
12 - Earth

Manage bulk operations in single-select field is very easy.
If you want to fill whole field with some value, select it in one cell, copy it(ctrl+c), fill whole field and paste (ctrl+v)
If you fill some cells with 'In Progress', and want it to be 'Never', just change it in field settings.
If you want to change among existing values, duplicate field, change copy to Single text, use it for filtering and do copy - paste whole field with filtered records. afterwards, delete temporary Single text field 


NOte: i just realized that you are maybe used to work with spreadsheet. In Airtable, all cells in single-select fields has the same drop-down menu, which can be edited if field settings. If you add new option, it will be seen for any cell you click. The list of available options is field property, it cannot be set  different for different cells.

See Solution in Thread

3 Replies 3
Alexey_Gusev
12 - Earth
12 - Earth

Manage bulk operations in single-select field is very easy.
If you want to fill whole field with some value, select it in one cell, copy it(ctrl+c), fill whole field and paste (ctrl+v)
If you fill some cells with 'In Progress', and want it to be 'Never', just change it in field settings.
If you want to change among existing values, duplicate field, change copy to Single text, use it for filtering and do copy - paste whole field with filtered records. afterwards, delete temporary Single text field 


NOte: i just realized that you are maybe used to work with spreadsheet. In Airtable, all cells in single-select fields has the same drop-down menu, which can be edited if field settings. If you add new option, it will be seen for any cell you click. The list of available options is field property, it cannot be set  different for different cells.

@zen_Table 

Yes, you can do that with Airtable's Batch Update extension.

Thank you for your detailed answer.