Nov 08, 2023 01:15 PM
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.
Solved! Go to Solution.
Nov 08, 2023 01:35 PM - edited Nov 08, 2023 01:42 PM
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.
Nov 08, 2023 01:35 PM - edited Nov 08, 2023 01:42 PM
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.
Nov 08, 2023 03:46 PM
Yes, you can do that with Airtable's Batch Update extension.
Nov 13, 2023 06:40 AM
Thank you for your detailed answer.