Skip to main content
Solved

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


Forum|alt.badge.img+3

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.

Best answer by Alexey_Gusev

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.

View original
Did this topic help you find an answer to your question?

3 replies

Alexey_Gusev
Forum|alt.badge.img+23
  • Brainy
  • 1127 replies
  • Answer
  • November 8, 2023

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.


ScottWorld
Forum|alt.badge.img+33
  • Brainy
  • 8779 replies
  • November 8, 2023

@zen_Table 

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


Forum|alt.badge.img+3
  • Author
  • New Participant
  • 1 reply
  • November 13, 2023
Alexey_Gusev wrote:

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.


Thank you for your detailed answer.


Reply