Update multiple fields with bulk field actions
  • 24 Aug 2022
  • 3 Minutes to read
  • Dark
    Light

Update multiple fields with bulk field actions

  • Dark
    Light

Using bulk field actions you can make changes (including field permissions, grouping, filtering, and hiding) to multiple fields at the same time.

How to select multiple fields

To select multiple fields, start by clicking on one of the field names for a field you want to use. Then, while holding down the CMD key (on Mac) or the CTRL key (on Windows), click on the field names of any other fields that you want to select together.

Once you’ve selected all the fields you want to edit together, release the CMD (or CTRL) key, then right click on any of the field names you selected to bring up the options menu.

4419888353175selectmultiplefields.gif

Edit field permissions for multiple fields

This option lets you adjust a field or group of fields in your base.

To configure either field and table editing permissions, you’ll need creator or owner permissions to a base within a Pro or Enterprise workspace. To confirm your permission level, open the base and click Share in the top right. If you don’t have creator or owner permissions, ask someone with creator or owner permissions to grant you this access.

After you’ve selected the field(s) that you want to edit (using the instructions at the top of this article), select the “Edit field permissions” option.

4419908400279editpermissions.png

This will open a settings window where you can select which permission level you want to set for the selected fields.

4419888485783fieldpermissions.gif

Once the permission level has been set, you can optionally toggle on/off the ability for the form to be updated through Airtable forms or automations.

TIP

When adjusting the permissions for specific users, organizations on our Enterprise plan will also have the option to adjust any User groups that may be collaborating in the base.


Group by multiple fields

After you’ve selected the field(s) that you want to edit (using the instructions at the top of this article), select the “Group by fields” option.

This will automatically group the grid view by the selected fields in the order that they appear in your current view. Once you’ve selected this option, you can adjust the grouping as needed. You can learn more about grouping records in this article.

Filter by multiple fields

After you’ve selected the field(s) that you want to edit (using the instructions at the top of this article), select the “Filter by fields” option.

This will automatically create filter conditions based on those fields which you can adjust as needed.

Hide multiple fields

After you’ve selected the field(s) that you want to edit (using the instructions at the top of this article), select the “Hide fields” option.

This will automatically hide the selected fields from your current view. Once you’ve selected this option, you can adjust which fields are hidden through the view menu bar. You can learn more about hiding and showing fields in this article.

Move multiple fields

Move multiple fields at once by clicking on one of the field names for a field you want to use. Then, while holding down the CMD key (on Mac) or the CTRL key (on Windows), click on the field names of any other fields that you want to select together. Then, click and drag those fields to move them before or after other fields in your view.

FAQs

Are there any limitations to the number of fields with which I can perform specific bulk actions?

With bulk field actions, you can select multiple fields (up to 50) to filter by within a single table with one click. You can also group by up to 3 fields with one click, for more fine-grained ability to categorize information. There are no limitations regarding the number of fields on which you can perform other actions (i.e. updating field permissions, moving fields, or hiding fields).


Was this article helpful?