FXL Bulk Edit

Introduction

You can use FXL Bulk Edit to update multiple records in the data grid at once, except for the discount for items that have Locked Discount selected.

Fields that you can’t edit display in gray in the Data Grid; they are Locked Cells.

To use the FieldFX Lightning package starting with version 1.225, you must use the FieldFX Managed Package version 1.529 or higher.

To find the version numbers you have installed, see Check Version Number for FieldFX Managed Package and FieldFX Lightning Managed Package.

Step-By-Step Guides

  1. In the FX Data Grid, select the records you want to bulk edit.

    Bulk Edit displays the number of records you have selected.

    Bulk Edit window with the selected item count highlighted

  2. Select a field to edit from the records you selected.

    If the field is not listed for selection, it is not editable.

    • If the field you are editing has a dependency, the first record you select controls the filters used for lookup functions.

    • A message displays when you click Set Values listing the record that controls lookups with dependencies.

      Example message identifying the controlling record

  3. Select one of the editing controls available for the field to use:

    • Click Clear values to clear the field in the selected records.

    • Click Set Values and complete the fields that display to set the field to the same value in the selected records.

    • Click Adjust Values and complete the fields that display to adjust the numeric value for the field in each selected record by a greater or less than percentage or amount.

      Example of the Bulk Edit panel

  4. Click Update.

    A message confirms the number of records updated.

Back to Additional FXL Data Grid Features